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));
}
