余小章 @ 大內殿堂

/// <summary>

/// 過濾字串

/// </summary>

/// <param name="WebName">Web 名稱，若不輸入則表示開啟頂層網站</param>

/// <param name="ListName">清單名稱</param>

/// <param name="CityName">欲帶入比較的名稱</param>

/// <returns></returns>

[WebMethod]

public List<string> FilterString(string WebName,string ListName,string CityName)

{

    string url;

    try

    {

        url = SPContext.Current.Site.Url;

    }

    catch (Exception ex)

    {

        url = "http://win-83s5zz3cd3d";

    }

    List<string> ResultList = new List<string>(); 

    using (SPSite osite = new SPSite(url))

    {

        SPWeb oweb = null;

        if (WebName=="")

        {

             oweb = osite.OpenWeb();

        }

        else

        {

            oweb = osite.AllWebs[WebName];

        }

        SPList list = oweb.Lists[ListName]; 

        foreach (SPItem item in list.Items)

        {

            string city = item["City"].ToString();

            //因為該欄是使用查詢方式，所以資料格式為

            //4;#台南市，下段程式則是處理不必要的字串

            city=city.Substring(city.LastIndexOf('#') + 1);

            string area = item["Area"].ToString();

            area = area.Substring(area.LastIndexOf('#') + 1);

            if (CityName==city)

            {

                ResultList.Add(area);

            }

        }

        oweb.Dispose();

    }

    return ResultList;

}