private string GetWhere(Com_Filter filter, List <SqlParameter> sp) { string where = "B.PaymentStatus=1 AND A.AllMoney_Json IS NOT NULL"; if (filter.storeId != -100) { where += " AND B.StoreID=" + filter.storeId; } //技师用户ID if (!string.IsNullOrEmpty(filter.uids)) { SafeSC.CheckIDSEx(filter.uids); where += " AND (A.Code IS NOT NULL AND A.Code IN (" + filter.uids + "))"; } if (!string.IsNullOrEmpty(filter.uname)) { sp.Add(new SqlParameter("uname", "%" + filter.uname + "%")); where += " AND A.Attribute LIKE @uname"; } if (!string.IsNullOrEmpty(filter.skey)) { sp.Add(new SqlParameter("skey", "%" + filter.skey + "%")); where += " AND A.Proname LIKE @skey"; } DateTime time = DateTime.Now; if (!string.IsNullOrEmpty(filter.stime) && DateTime.TryParse(filter.stime, out time)) { where += " AND A.AddTime>='" + filter.stime + "'"; } if (!string.IsNullOrEmpty(filter.etime) && DateTime.TryParse(filter.etime, out time)) { where += " AND A.AddTime<='" + filter.etime + "'"; } return(where); }
//, int uid, int status public PageSetting SelPage(int cpage, int psize, Com_Filter filter) { string where = "1=1 "; List <SqlParameter> sp = new List <SqlParameter>(); if (!string.IsNullOrEmpty(filter.uids)) { where += " AND UserID IN (" + filter.uids + ")"; } if (!string.IsNullOrEmpty(filter.status) && filter.status != "-100") { where += " AND Status=" + DataConvert.CLng(filter.status); } if (!string.IsNullOrEmpty(filter.skey)) { where += " AND Tittle LIKE @skey"; sp.Add(new SqlParameter("skey", "%" + filter.skey + "%")); } //flow if (!string.IsNullOrEmpty(filter.addon)) { where += " AND Flow =@flow"; sp.Add(new SqlParameter("flow", filter.addon)); } PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where); DBCenter.SelPage(setting); return(setting); }
public DataTable Sel(Com_Filter filter) { string where = ""; string order = ""; switch (filter.orderBy) { case "money_desc": order = "Min DESC"; break; case "money_asc": order = "Min ASC"; break; case "id_desc": default: order = "ID DESC"; break; } if (filter.storeId > 0) { where += " AND StoreID=" + filter.storeId; } return(DBCenter.Sel(TbName, where, order)); }
//------------------- public PageSetting SelPage(int cpage, int psize, Com_Filter filter) { string where = "1=1 "; PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, PK + " DESC"); DBCenter.SelPage(setting); return(setting); }
public DataTable SelByJS(Com_Filter filter) { List <SqlParameter> sp = new List <SqlParameter>(); string where = GetWhere(filter, sp); return(DBCenter.ExecuteTable("SELECT A.Attribute,SUM(CAST(A.AllMoney_Json AS MONEY)) AllMoney_Json " + " FROM ZL_CartPro A LEFT JOIN ZL_OrderInfo B ON A.OrderListID=B.ID " + " WHERE A.Attribute!='' AND " + where + " GROUP BY Attribute", sp)); }
public PageSetting SelPage(int cpage, int psize, Com_Filter filter) { string where = "1=1 "; List <SqlParameter> sp = new List <SqlParameter>(); PageSetting setting = PageSetting.Double(cpage, psize, TbName, "ZL_AdZone", "A.ID", "A.ADID=B.ZoneID", where, PK + " DESC", sp); DBCenter.SelPage(setting); return(setting); }
public DataTable Sel(Com_Filter filter) { List <SqlParameter> sp = new List <SqlParameter>(); string where = "ParentID=0 "; if (filter.storeId != -100) { where += " AND StoreId=" + filter.storeId; } return(DBCenter.Sel(TbName, where, "ID DESC")); }
public PageSetting SelPage(int cpage, int psize, Com_Filter filter) { PageSetting setting = new PageSetting() { t1 = TbName, cpage = cpage, psize = psize }; DBCenter.SelPage(setting); return(setting); }
public PageSetting SelPage(int cpage, int psize, Com_Filter filter) { string where = "1=1 "; if (!string.IsNullOrEmpty(filter.uids)) { SafeSC.CheckIDSEx(filter.uids); where += " AND UserID IN (" + filter.uids + ")"; } PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where); DBCenter.SelPage(setting); return(setting); }
public PageSetting SelPage(int cpage, int psize, Com_Filter filter) { //code==技师ID,ProInfo==技师名 List <SqlParameter> sp = new List <SqlParameter>(); string where = GetWhere(filter, sp); //需要加上是否支付的筛选 PageSetting setting = PageSetting.Double(cpage, psize, "ZL_CartPro", "ZL_OrderInfo", "A.ID", "A.OrderListID=B.ID", where, "A.ID DESC", sp, "A.*,B.PaymentStatus"); DBCenter.SelPage(setting); return(setting); }
public PageSetting SelPage(int cpage, int psize, Com_Filter filter) { string where = "1=1 "; if (filter.storeId > 0) { where += " AND A.Appid=" + filter.storeId; } string fields = "A.*,(SELECT Alias FROM ZL_WX_APPID WHERE ID=A.AppId) AS Alias"; PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, "A.ID DESC", null, fields); DBCenter.SelPage(setting); return(setting); }
private DataTable MyBind(int pageSize, int pageIndex) { M_UserInfo mu = buser.GetLogin(); Com_Filter filter = new Com_Filter() { storeId = mu.SiteID, uname = UName_T.Text.Trim(), skey = Label_T.Text.Trim() }; filter.addon = addon; PageSetting setting = suBll.SelPage(pageIndex, pageSize, filter); RPT.ItemCount = setting.itemCount; return(setting.dt); }
private DataTable MyBind(int pageSize, int pageIndex) { M_UserInfo mu = buser.GetLogin(); Com_Filter filter = new Com_Filter() { storeId = mu.SiteID, uname = JSName_T.Text, skey = Proname_T.Text, stime = STime_T.Text, etime = ETime_T.Text }; PageSetting setting = SelPage(pageIndex, pageSize, filter); ByJS_RPT.DataSource = SelByJS(filter); ByJS_RPT.DataBind(); RPT.ItemCount = setting.itemCount; return(setting.dt); }
public DataTable Sel(Com_Filter filter) { string where = "1=1"; List <SqlParameter> sp = new List <SqlParameter>(); if (!string.IsNullOrEmpty(filter.uids)) { SafeSC.CheckIDSEx(filter.uids); where += " AND UserID IN (" + filter.uids + ")"; } if (filter.storeId > 0) { where += " AND SiteId=" + filter.storeId; } DataTable dt = DBCenter.Sel("ZL_Ex_UserView", where, "UserID DESC", sp); dt.Columns.Remove("userPwd"); return(dt); }
public PageSetting SelPage(int cpage, int psize, Com_Filter filter) { string where = "1=1 "; List <SqlParameter> sp = new List <SqlParameter>(); if (!string.IsNullOrEmpty(filter.uids)) { SafeSC.CheckIDSEx(filter.uids); where += " AND A.UID IN (" + filter.uids + ")"; } if (!string.IsNullOrEmpty(filter.status)) { SafeSC.CheckIDSEx(filter.status); where += " AND A.State IN (" + filter.status + ")"; } PageSetting setting = PageSetting.Double(cpage, psize, TbName, "ZL_AdZone", "A.ID", "A.ADID=B.ZoneID", where, PK + " DESC", sp); DBCenter.SelPage(setting); return(setting); }
public PageSetting SelPage(int cpage, int psize, Com_Filter filter) { List <SqlParameter> sp = new List <SqlParameter>(); string where = "1=1"; if (!string.IsNullOrEmpty(filter.type)) { SafeSC.CheckIDSEx(filter.type); where += " AND ModelType IN (" + filter.type + ")"; } if (!string.IsNullOrEmpty(filter.skey)) { where += " AND ModelName LIKE @skey"; sp.Add(new SqlParameter("skey", "%" + filter.skey + "%")); } string orderBy = StrHelper.SQL_OrderBy(filter.orderBy, "modelid"); PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, orderBy); DBCenter.SelPage(setting); return(setting); }
public DataTable Sel(Com_Filter filter) { //int zoneType, string skey List <SqlParameter> sp = new List <SqlParameter>(); string where = "1=1 "; if (!string.IsNullOrEmpty(filter.type) && filter.type != "-100") { where += " AND ZoneType =" + Convert.ToInt32(filter.type); } if (!string.IsNullOrEmpty(filter.skey)) { where += " AND ZoneName LIKE @skey"; sp.Add(new SqlParameter("skey", "%" + filter.skey + "%")); } if (filter.addon == "sale") { where += " AND Sales=1"; } return(DBCenter.Sel(TbName, where, "ZoneID DESC", sp)); }