#region GetDataSet
public static DataSet GetDataSet(string sql)
{
string ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["strConnection"];
SqlDataAdapter sda =new SqlDataAdapter(sql,ConnectionString);
DataSet ds=new DataSet();
sda.Fill(ds);
return ds;
}
#endregion
public static DataSet GetDataSet(string sql)
{
string ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["strConnection"];
SqlDataAdapter sda =new SqlDataAdapter(sql,ConnectionString);
DataSet ds=new DataSet();
sda.Fill(ds);
return ds;
}
#endregion
public static DataSet GetClass1List()
{
string sql="select * from qyclass1tb";
return GetDataSet(sql);
}
[AjaxPro.AjaxMethod(AjaxPro.HttpSessionStateRequirement.Read)]
public DataSet GetClassList(int sortid)
{
string sql="select * from qyclass2tb where sortid="+sortid;
return GetDataSet(sql);
}
[AjaxPro.AjaxMethod(AjaxPro.HttpSessionStateRequirement.Read)]
public DataSet GetCityList(int provinceid)
{
//string sql="select * from qyclass2tb where sortid="+sortid;
//return GetDataSet(sql);
return Company.ExecuteSQLForDS ("select * from Citytb where proviceid="+provinceid);
//this.ddlcity.DataTextField ="cityname";
//this.ddlcity.DataValueField ="cityid";
}
{
string sql="select * from qyclass1tb";
return GetDataSet(sql);
}
[AjaxPro.AjaxMethod(AjaxPro.HttpSessionStateRequirement.Read)]
public DataSet GetClassList(int sortid)
{
string sql="select * from qyclass2tb where sortid="+sortid;
return GetDataSet(sql);
}
[AjaxPro.AjaxMethod(AjaxPro.HttpSessionStateRequirement.Read)]
public DataSet GetCityList(int provinceid)
{
//string sql="select * from qyclass2tb where sortid="+sortid;
//return GetDataSet(sql);
return Company.ExecuteSQLForDS ("select * from Citytb where proviceid="+provinceid);
//this.ddlcity.DataTextField ="cityname";
//this.ddlcity.DataValueField ="cityid";
}