protected void Page_Load(object sender, EventArgs e)
{
try
{
int page = int.Parse(base.Request.Params["page"].ToString());
int pagesize = int.Parse(base.Request.Params["pagesize"].ToString());
string xiaofei = base.Server.UrlDecode(base.Request.Params["xiaofei"].ToString());
string mnum = base.Server.UrlDecode(base.Request.Params["mnum"].ToString());
string sqll = "where 1=1 and Type='收银消费'";
if (xiaofei != "")
{
sqll = sqll + "and charindex('" + xiaofei + "',C_Id)>0";
}
if (mnum != "")
{
sqll = sqll + "and charindex('" + mnum + "',Card_Id)>0";
}
string sqlwhat = "* ";
int coutt = PublicMethod.QueryDataset("select " + sqlwhat + " from Consumption_Back_select " + sqll).Tables[0].Rows.Count;
DataTable dt = PublicMethod.FindForPageAll(page, pagesize, sqll, "Consumption_Back_select", "Id", sqlwhat);
if (dt.Rows.Count > 0)
{
base.Response.Write(CreateJsonParameters(dt, coutt));
}
else
{
string jsonstr = "{ Rows:[],Total:0}";
base.Response.Write(jsonstr);
}
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int page = int.Parse(base.Request.Params["page"].ToString());
int pagesize = int.Parse(base.Request.Params["pagesize"].ToString());
string year = base.Server.UrlDecode(base.Request.QueryString["year"].ToString());
string sqll = "where 1=1 and memberchong.cShopnum=shops.sNum ";
if (year != "")
{
sqll = sqll + "and DATEPART(yyyy,cDate)='" + year + "'";
}
string sqlwhat = "shops.sName,sNum,memberchong.cShopnum,cDate,cChongMoney,cYue,cGive,cmName,cmNum";
int coutt = PublicMethod.QueryDataset("select " + sqlwhat + " from shops,memberchong " + sqll).Tables[0].Rows.Count;
DataTable dt = PublicMethod.FindForPageAll(page, pagesize, sqll, "shops,memberchong", "memberchong.cId", sqlwhat);
if (dt.Rows.Count > 0)
{
base.Response.Write(CreateJsonParameters(dt, coutt));
}
else
{
string jsonstr = "{ Rows:[],Total:0}";
base.Response.Write(jsonstr);
}
}
catch
{
}
}
public DataTable load(int pagesize, int page)
{
DataTable dtz = new DataTable();
dtz.Columns.Add("tnum", typeof(string));
dtz.Columns.Add("tname", typeof(string));
dtz.Columns.Add("tfcount", typeof(decimal));
dtz.Columns.Add("tfmoney", typeof(decimal));
dtz.Columns.Add("txall", typeof(decimal));
dtz.Columns.Add("txmoney", typeof(decimal));
string sqladmin = " where 1=1 and aSnum='" + PublicMethod.GetSessionValue("shopnum").ToString() + "'";
if (this.num != "")
{
sqladmin = sqladmin + "and charindex('" + this.num + "', aNum)>0";
}
if (this.name != "")
{
sqladmin = sqladmin + "and charindex('" + this.name + "', .aName)>0";
}
string sqlwhat = "aNum,aName,aSnum";
DataTable dta = PublicMethod.FindForPageAll(page, pagesize, sqladmin, "admininfo", "aId", sqlwhat);
for (int i = 0; i < dta.Rows.Count; i++)
{
double jines = this.loadcout(dta.Rows[i]["aNum"].ToString()) * this.jine;
double bilis = this.loadmoney(dta.Rows[i]["aNum"].ToString()) * this.bili;
dtz.Rows.Add(new object[] { dta.Rows[i]["aNum"].ToString(), dta.Rows[i]["aName"].ToString(), this.loadcout(dta.Rows[i]["aNum"].ToString()), jines, this.loadmoney(dta.Rows[i]["aNum"].ToString()), bilis });
}
return(dtz);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int page = int.Parse(base.Request.Params["page"].ToString());
int pagesize = int.Parse(base.Request.Params["pagesize"].ToString());
string year = base.Server.UrlDecode(base.Request.QueryString["year"].ToString());
string sqll = "where 1=1 ";
if (year != "")
{
sqll = sqll + "and DATEPART(yyyy,Addtime)='" + year + "'";
}
string sqlwhat = "* ";
int coutt = PublicMethod.QueryDataset("select " + sqlwhat + " from Consumption_Back_select " + sqll).Tables[0].Rows.Count;
DataTable dt = PublicMethod.FindForPageAll(page, pagesize, sqll, "Consumption_Back_select", "Id", sqlwhat);
if (dt.Rows.Count > 0)
{
base.Response.Write(CreateJsonParameters(dt, coutt));
}
else
{
string jsonstr = "{ Rows:[],Total:0}";
base.Response.Write(jsonstr);
}
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int page = int.Parse(base.Request.Params["page"].ToString());
int pagesize = int.Parse(base.Request.Params["pagesize"].ToString());
string begin = base.Server.UrlDecode(base.Request.QueryString["begin"].ToString()) + " 00:00";
string over = base.Server.UrlDecode(base.Request.QueryString["over"].ToString()) + " 23:59";
string shopnum = base.Server.UrlDecode(base.Request.QueryString["shopnum"].ToString());
string sqll = "where 1=1 and ShopId='" + shopnum + "' ";
if ((begin != "") && (over != ""))
{
string name3 = sqll;
sqll = name3 + "and Addtime >='" + begin + "' and Addtime <='" + over + "'";
}
string sqlwhat = "* ";
int coutt = PublicMethod.QueryDataset("select " + sqlwhat + " from Consumption_Back_select " + sqll).Tables[0].Rows.Count;
DataTable dt = PublicMethod.FindForPageAll(page, pagesize, sqll, "Consumption_Back_select", "Id", sqlwhat);
if (dt.Rows.Count > 0)
{
base.Response.Write(CreateJsonParameters(dt, coutt));
}
else
{
string jsonstr = "{ Rows:[],Total:0}";
base.Response.Write(jsonstr);
}
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int page = int.Parse(base.Request.Params["page"].ToString());
int pagesize = int.Parse(base.Request.Params["pagesize"].ToString());
string sqlwhat = "C_Id,Card_Id,Type,Addtime,Remark,Shop,Money";
string where = "";
DataTable dtCheck = PublicMethod.QueryDataset("select P_Id,C_Id from TemporaryCard where C_Id='" + base.Request.QueryString["mnum"] + "'").Tables[0];
if (dtCheck.Rows.Count > 0)
{
where = " where Card_Id='" + dtCheck.Rows[0]["P_Id"].ToString() + "' or Card_Id='" + dtCheck.Rows[0]["C_Id"].ToString() + "'";
}
else
{
where = " where Card_Id='" + base.Request.QueryString["mnum"] + "'";
}
int coutt = PublicMethod.QueryDataset("select " + sqlwhat + " from Consumption_Back " + where).Tables[0].Rows.Count;
DataTable dt = PublicMethod.FindForPageAll(page, pagesize, where, "Consumption_Back", "Addtime", sqlwhat);
if (dt.Rows.Count > 0)
{
base.Response.Write(CreateJsonParameters(dt, coutt));
this.bc.execsql("delete from Consumption_Back where Card_Id='" + base.Request.QueryString["mnum"] + "' delete from TemporaryCard where C_Id='" + base.Request.QueryString["mnum"] + "'");
}
else
{
string jsonstr = "{ Rows:[],Total:0}";
base.Response.Write(jsonstr);
this.bc.execsql("delete from Consumption_Back where Card_Id='" + base.Request.QueryString["mnum"] + "' delete from TemporaryCard where C_Id='" + base.Request.QueryString["mnum"] + "'");
}
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int page = int.Parse(base.Request.Params["page"].ToString());
int pagesize = int.Parse(base.Request.Params["pagesize"].ToString());
string num = (base.Request.Params["num"].ToString() == "") ? "" : base.Request.Params["num"].ToString().Substring(1);
string name = (base.Server.UrlDecode(base.Request.Params["name"].ToString()) == "") ? "" : base.Server.UrlDecode(base.Request.Params["name"].ToString()).Substring(1);
string sqll = "where 1=1 ";
if (num != "")
{
sqll = sqll + "and charindex('" + num + "', gNum)>0";
}
if (name != "")
{
sqll = sqll + "and charindex('" + name + "', gName)>0";
}
string sqlwhat = "*";
int coutt = PublicMethod.QueryDataset("select " + sqlwhat + " from present " + sqll).Tables[0].Rows.Count;
DataTable dt = PublicMethod.FindForPageAll(page, pagesize, sqll, "present", "gId", sqlwhat);
if (dt.Rows.Count > 0)
{
base.Response.Write(CreateJsonParameters(dt, coutt));
}
else
{
string jsonstr = "{ Rows:[],Total:0}";
base.Response.Write(jsonstr);
}
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int page = int.Parse(base.Request.Params["page"].ToString());
int pagesize = int.Parse(base.Request.Params["pagesize"].ToString());
string tnum = base.Request.QueryString["tnum"].ToString();
string sqll = "where 1=1 and consumes.cTnum=consumetype.tNum and consumes.cCount<=10 ";
if (tnum != "")
{
sqll = sqll + "and charindex('" + tnum + "', consumes.cTnum)>0";
}
string sqlwhat = "consumes.* ,consumetype.tName,tNum";
int coutt = PublicMethod.QueryDataset("select " + sqlwhat + " from consumes,consumetype " + sqll).Tables[0].Rows.Count;
DataTable dt = PublicMethod.FindForPageAll(page, pagesize, sqll, "consumes,consumetype", "consumes.cId", sqlwhat);
if (dt.Rows.Count > 0)
{
base.Response.Write(CreateJsonParameters(dt, coutt));
}
else
{
string jsonstr = "{ Rows:[],Total:0}";
base.Response.Write(jsonstr);
}
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int page = int.Parse(base.Request.Params["page"].ToString());
int pagesize = int.Parse(base.Request.Params["pagesize"].ToString());
string tables = base.Request.Params["tables"].ToString();
string orders = base.Request.Params["orders"].ToString();
string mnum = base.Request.Params["mnum"].ToString();
string sqll = "where 1=1 and cmNum ='" + mnum + "' ";
int coutt = PublicMethod.QueryDataset("select * from " + tables + " " + sqll).Tables[0].Rows.Count;
DataTable dt = PublicMethod.FindForPageAll(page, pagesize, sqll, tables, orders, "*");
if (dt.Rows.Count > 0)
{
base.Response.Write(CreateJsonParameters(dt, coutt));
}
else
{
string jsonstr = "{ Rows:[],Total:0}";
base.Response.Write(jsonstr);
}
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int page = int.Parse(base.Request.Params["page"].ToString());
int pagesize = int.Parse(base.Request.Params["pagesize"].ToString());
string num = (base.Request.Params["num"].ToString() == "") ? "" : base.Request.Params["num"].ToString().Substring(1);
string sqll = "where 1=1 and yShopnum='" + PublicMethod.GetSessionValue("shopname") + "' ";
if (num != "")
{
sqll = sqll + "and charindex('" + num + "', yNum)>0";
}
string sqlwhat = "*";
int coutt = PublicMethod.QueryDataset("select " + sqlwhat + " from inventory " + sqll).Tables[0].Rows.Count;
DataTable dt = PublicMethod.FindForPageAll(page, pagesize, sqll, "inventory", "yId", sqlwhat);
if (dt.Rows.Count > 0)
{
base.Response.Write(CreateJsonParameters(dt, coutt));
}
else
{
string jsonstr = "{ Rows:[],Total:0}";
base.Response.Write(jsonstr);
}
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int page = int.Parse(base.Request.Params["page"].ToString());
int pagesize = int.Parse(base.Request.Params["pagesize"].ToString());
string mnum = (base.Request.Params["mnum"].ToString() == "") ? "" : base.Request.Params["mnum"].ToString().Substring(1);
string mmobile = (base.Request.Params["mmobile"].ToString() == "") ? "" : base.Request.Params["mmobile"].ToString().Substring(1);
string mname = (base.Server.UrlDecode(base.Request.Params["mname"].ToString()) == "") ? "" : base.Server.UrlDecode(base.Request.Params["mname"].ToString()).Substring(1);
string lnum = (base.Server.UrlDecode(base.Request.Params["lnum"].ToString()) == "") ? "" : base.Server.UrlDecode(base.Request.Params["lnum"].ToString()).Substring(1);
string sname = base.Server.UrlDecode(base.Request.Params["sname"].ToString());
string sqll = "where 1=1 and membersinfo.mShopNum=shops.sNum and membersinfo.mLevel=memberlevel.lNum ";
if (mnum != "")
{
sqll = sqll + "and charindex('" + mnum + "', membersinfo.mNum)>0";
}
if (mname != "")
{
sqll = sqll + "and charindex('" + mname + "', membersinfo.mName)>0";
}
if (mmobile != "")
{
sqll = sqll + "and charindex('" + mmobile + "', membersinfo.mMobile)>0";
}
if (lnum != "")
{
sqll = sqll + "and charindex('" + lnum + "', membersinfo.mLevel)>0";
}
if (sname != "总部")
{
sqll = sqll + " and shops.sNum='" + PublicMethod.GetSessionValue("shopnum").ToString() + "'";
}
string sqlwhat = "membersinfo.mId,mNum,mName,mMobile,mLevel,mBalance,mIntegral,mStates,mMakedate,mPastdate,mShopNum,shops.sName,sNum,memberlevel.lName,lNum";
int coutt = PublicMethod.QueryDataset("select " + sqlwhat + " from shops,membersinfo,memberlevel " + sqll).Tables[0].Rows.Count;
DataTable dt = PublicMethod.FindForPageAll(page, pagesize, sqll, "shops,membersinfo,memberlevel", "membersinfo.mId", sqlwhat);
if (dt.Rows.Count > 0)
{
base.Response.Write(CreateJsonParameters(dt, coutt));
}
else
{
string jsonstr = "{ Rows:[],Total:0}";
base.Response.Write(jsonstr);
}
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int page = int.Parse(base.Request.Params["page"].ToString());
int pagesize = int.Parse(base.Request.Params["pagesize"].ToString());
string begin = base.Server.UrlDecode(base.Request.QueryString["begin"].ToString()) + " 00:00";
string over = base.Server.UrlDecode(base.Request.QueryString["over"].ToString()) + " 23:59";
string dian = base.Server.UrlDecode(base.Request.QueryString["dian"].ToString());
string sqll = "where 1=1 ";
if ((begin != "") && (over != ""))
{
string name3 = sqll;
sqll = name3 + "and Addtime >='" + begin + "' and Addtime <='" + over + "'";
}
if (dian != "NONE")
{
sqll = sqll + "and ShopId='" + dian + "' ";
}
sqll = sqll + "group by Shop,ShopId";
string sqlwhat = "ShopId,Shop,sum(CONVERT(decimal(18, 2),[money])) as money, sum(BlancePay) as BlancePay,sum(CashPay) as CashPay,sum(BankPay) as BankPay,sum(JifenPay) as JifenPay,sum(ElsePay) as ElsePay ";
int coutt = PublicMethod.QueryDataset("select " + sqlwhat + " from Consumption_Back_select " + sqll).Tables[0].Rows.Count;
DataTable dt = PublicMethod.FindForPageAll(page, pagesize, sqll, "Consumption_Back_select", "ShopId", sqlwhat);
if (dt.Rows.Count > 0)
{
dt.Columns.Add("chong", typeof(decimal));
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["chong"] = this.loadchong(begin, over, dt.Rows[i]["ShopId"].ToString());
}
base.Response.Write(CreateJsonParameters(dt, coutt));
}
else
{
string jsonstr = "{ Rows:[],Total:0}";
base.Response.Write(jsonstr);
}
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int page = int.Parse(base.Request.Params["page"].ToString());
int pagesize = int.Parse(base.Request.Params["pagesize"].ToString());
string num = base.Request.Params["num"].ToString();
string name = base.Server.UrlDecode(base.Request.QueryString["name"].ToString());
string rnum = base.Server.UrlDecode(base.Request.QueryString["rnum"].ToString());
string sqll = "where 1=1 and admininfo.aSnum=shops.sNum and admininfo.aRnum=roles.rNum ";
if (num != "")
{
sqll = sqll + "and charindex('" + num + "', admininfo.aNum)>0";
}
if (name != "")
{
sqll = sqll + "and charindex('" + name + "', admininfo.aName)>0";
}
if (rnum != "")
{
sqll = sqll + "and charindex('" + rnum + "', roles.rNum)>0";
}
string sqlwhat = "admininfo.*,shops.sName,sNum, roles.rName,rNum";
int coutt = PublicMethod.QueryDataset("select " + sqlwhat + " from admininfo,shops,roles " + sqll).Tables[0].Rows.Count;
DataTable dt = PublicMethod.FindForPageAll(page, pagesize, sqll, "admininfo,shops,roles", "admininfo.aId", sqlwhat);
if (dt.Rows.Count > 0)
{
base.Response.Write(CreateJsonParameters(dt, coutt));
}
else
{
string jsonstr = "{ Rows:[],Total:0}";
base.Response.Write(jsonstr);
}
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int page = int.Parse(base.Request.Params["page"].ToString());
int pagesize = int.Parse(base.Request.Params["pagesize"].ToString());
string cmbProvince = base.Server.UrlDecode(base.Request.QueryString["cmbProvince"].ToString());
string cmbCity = base.Server.UrlDecode(base.Request.QueryString["cmbCity"].ToString());
string cmbArea = base.Server.UrlDecode(base.Request.QueryString["cmbArea"].ToString());
string sqll = "where 1=1 and membersinfo.mShopNum=shops.sNum and membersinfo.mLevel=memberlevel.lNum ";
if (cmbProvince != "")
{
sqll = sqll + "and charindex('" + cmbProvince + "', membersinfo.mProvince)>0";
}
if (cmbCity != "")
{
sqll = sqll + "and charindex('" + cmbCity + "', membersinfo.mCity)>0";
}
if (cmbArea != "全部")
{
sqll = sqll + "and charindex('" + cmbArea + "', membersinfo.mTown)>0";
}
string sqlwhat = "membersinfo.mId,mNum,mName,mMobile,mLevel,mBalance,mIntegral,mStates,mMakedate,mPastdate,mProvince,mCity,mTown,mShopNum,shops.sName,sNum,memberlevel.lName,lNum";
int coutt = PublicMethod.QueryDataset("select " + sqlwhat + " from shops,membersinfo,memberlevel " + sqll).Tables[0].Rows.Count;
DataTable dt = PublicMethod.FindForPageAll(page, pagesize, sqll, "shops,membersinfo,memberlevel", "membersinfo.mId", sqlwhat);
if (dt.Rows.Count > 0)
{
base.Response.Write(CreateJsonParameters(dt, coutt));
}
else
{
string jsonstr = "{ Rows:[],Total:0}";
base.Response.Write(jsonstr);
}
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int page = int.Parse(base.Request.Params["page"].ToString());
int pagesize = int.Parse(base.Request.Params["pagesize"].ToString());
string scontact = base.Request.QueryString["scontact"].ToString();
string stnum = base.Server.UrlDecode(base.Request.QueryString["stnum"].ToString());
string sname = base.Server.UrlDecode(base.Request.QueryString["sname"].ToString());
string sqll = "where 1=1 and shops.stNum=shopstype.tNum ";
if (sname != "")
{
sqll = sqll + "and charindex('" + sname + "', shops.sName)>0";
}
if (scontact != "")
{
sqll = sqll + "and charindex('" + scontact + "', shops.sContact)>0";
}
if (stnum != "")
{
sqll = sqll + "and charindex('" + stnum + "', shops.stNum)>0";
}
string sqlwhat = "shops.*,shopstype.tName,tNum";
int coutt = PublicMethod.QueryDataset("select " + sqlwhat + " from shops,shopstype " + sqll).Tables[0].Rows.Count;
DataTable dt = PublicMethod.FindForPageAll(page, pagesize, sqll, "shops,shopstype", "shops.sId", sqlwhat);
if (dt.Rows.Count > 0)
{
base.Response.Write(CreateJsonParameters(dt, coutt));
}
else
{
string jsonstr = "{ Rows:[],Total:0}";
base.Response.Write(jsonstr);
}
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int page = int.Parse(base.Request.Params["page"].ToString());
int pagesize = int.Parse(base.Request.Params["pagesize"].ToString());
string sqll = "where 1=1 ";
int coutt = PublicMethod.QueryDataset("select * from tuijianlist " + sqll).Tables[0].Rows.Count;
DataTable dt = PublicMethod.FindForPageAll(page, pagesize, sqll, "tuijianlist", "nId", "*");
if (dt.Rows.Count > 0)
{
base.Response.Write(CreateJsonParameters(dt, coutt));
}
else
{
string jsonstr = "{ Rows:[],Total:0}";
base.Response.Write(jsonstr);
}
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
int page = int.Parse(base.Request.Params["page"].ToString());
int pagesize = int.Parse(base.Request.Params["pagesize"].ToString());
string mnum = base.Request.Params["mnum"].ToString();
string sqll = "where 1=1 and present.gNum=prsentchange.cGnum and cMnum ='" + mnum + "' ";
int coutt = PublicMethod.QueryDataset("select present.*,prsentchange.* from present,prsentchange " + sqll).Tables[0].Rows.Count;
DataTable dt = PublicMethod.FindForPageAll(page, pagesize, sqll, "present,prsentchange", "cId", "present.*,prsentchange.*");
if (dt.Rows.Count > 0)
{
base.Response.Write(CreateJsonParameters(dt, coutt));
}
else
{
string jsonstr = "{ Rows:[],Total:0}";
base.Response.Write(jsonstr);
}
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string sqlwhat;
int page = int.Parse(base.Request.Params["page"].ToString());
int pagesize = int.Parse(base.Request.Params["pagesize"].ToString());
string lnum = base.Server.UrlDecode(base.Request.Params["lnum"].ToString());
if (lnum.IndexOf(",") > 0)
{
lnum = lnum.Split(new char[] { ',' })[1];
}
string sqll = "where 1=1 and membersinfo.mShopNum=shops.sNum and membersinfo.mLevel=memberlevel.lNum and shops.sNum='" + PublicMethod.GetSessionValue("shopnum").ToString() + "'";
if (lnum == "001")
{
sqll = sqll + " and membersinfo.mPastdate!='永久有效' and DATEDIFF(day, membersinfo.mPastdate,getdate())>=0 ";
}
else
{
switch (lnum)
{
case "003":
sqll = sqll + " and membersinfo.mBalance<10 ";
break;
case "004":
sqll = sqll + " and DATEDIFF(day, membersinfo.mBirth,getdate())<=3 ";
break;
case "002":
{
string detail = "";
string sqlf = "select distinct Card_Id from Consumption_Back_select where datediff(month,Addtime,getdate())<3 ";
DataTable dtf = this.bc.ReadTable(sqlf);
if (dtf.Rows.Count > 0)
{
for (int i = 0; i < dtf.Rows.Count; i++)
{
detail = detail + dtf.Rows[i]["Card_Id"].ToString() + "|";
}
}
sqll = sqll + " and charindex(mNum,'" + detail + "')=0 and datediff(month,mMakedate,getdate())>3";
goto Label_01E4;
}
}
}
Label_01E4:
sqlwhat = "membersinfo.mId,mNum,mName,mMobile,mLevel,mBalance,mIntegral,mStates,mMakedate,mPastdate,mShopNum,shops.sName,sNum,memberlevel.lName,lNum";
int coutt = PublicMethod.QueryDataset("select " + sqlwhat + " from shops,membersinfo,memberlevel " + sqll).Tables[0].Rows.Count;
DataTable dt = PublicMethod.FindForPageAll(page, pagesize, sqll, "shops,membersinfo,memberlevel", "membersinfo.mId", sqlwhat);
if (dt.Rows.Count > 0)
{
base.Response.Write(CreateJsonParameters(dt, coutt));
}
else
{
string jsonstr = "{ Rows:[],Total:0}";
base.Response.Write(jsonstr);
}
}
catch
{
}
}
