App_Code/CLassWebService.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Web.Script.Services;
using System.Collections.Generic;
using System.Collections.Specialized;
using AjaxControlToolkit;
using System.Data.SqlClient;
using System.Data;

/// <summary>
/// 获取组别姓名
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[ScriptService]
public class CLassWebService : System.Web.Services.WebService 
{

    public CLassWebService ()
    {

    }

    /// <summary>
    /// 获取组别数据
    /// </summary>
    [WebMethod]
    public CascadingDropDownNameValue[] GetProvinceContents(string knownCategoryValues, string category)
    {
        List<CascadingDropDownNameValue> provinceList = new List<CascadingDropDownNameValue>();

        string connectionString = ConfigHelper.GetValueByKey("ConnString");

        SqlConnection sqlConn = new SqlConnection(connectionString);

        sqlConn.Open();

        string strSql = "Select  *  From [Group] where 1=1  order by GNum ";

        SqlCommand sqlCmd = new SqlCommand(strSql, sqlConn);

        SqlDataReader dtr = sqlCmd.ExecuteReader();

        while (dtr.Read())
        {
            provinceList.Add(new CascadingDropDownNameValue(dtr["GName"].ToString(), dtr["GID"].ToString()));
        }

        dtr.Close();

        sqlConn.Close();

        return provinceList.ToArray();
    }
    /// <summary>
    /// 获取姓名数据
    /// </summary>