private DataTable Content_SelByNid(int siteID, string nids)//需要改为不依靠登录用户获取
{
string where = "";
if (string.IsNullOrEmpty(nids))
{
DataTable dt = Node_Sel(siteID);
foreach (DataRow dr in dt.Rows)
{
nids += dr["NodeID"] + ",";
}
nids = nids.TrimEnd(',');
}
SafeSC.CheckIDSEx(nids);
where += " A.NodeID IN(" + nids + ")";
PageSetting setting = new PageSetting()
{
cpage = CPage,
psize = PSize,
fields = "A.*,B.synopsis",
t1 = "ZL_CommonModel",
t2 = "ZL_C_Article",
on = "A.ItemID=B.ID",
where = where,
order = "A.GeneralID DESC"
};
return(DBCenter.SelPage(setting));
}
public PageSetting SelPage(int cpage, int psize, string ntype = "", int zstatus = -100, int infoid = -100, string sdate = "", string title = "")
{
string where = "1=1 ";
List <SqlParameter> sp = new List <SqlParameter>();
if (!string.IsNullOrEmpty(ntype))
{
SafeSC.CheckIDSEx(ntype); where += " AND NType IN(" + ntype + ")";
}
if (zstatus != -100)
{
where += " AND ZStatus=" + zstatus;
}
if (infoid != -100)
{
where += " AND InfoID=" + infoid;
}
if (!string.IsNullOrEmpty(sdate))
{
where += " AND BeginDate>=@sdate"; sp.Add(new SqlParameter("sdate", sdate));
}
if (!string.IsNullOrEmpty(title))
{
where += " AND Title LIKE @title"; sp.Add(new SqlParameter("title", "%" + title + "%"));
}
PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, PK + " DESC", sp);
DBCenter.SelPage(setting);
return(setting);
}
public PageSetting SelPage(int cpage, int psize)
{
PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, "", "CDate Desc");
DBCenter.SelPage(setting);
return(setting);
}
//PostContent
//public DataTable SelByPid(int pid)
//{
// return DBCenter.JoinQuery("A.*,B.salt AS UserFace,B.HoneyName", "ZL_Guest_Bar", "ZL_User", "A.CUser=B.UserID", "Pid=" + pid + " And A.Status>0", "CDATE ASC");
//}
/// <summary>
/// 查找指定cateid下主贴
/// </summary>
public PageSetting SelPage(int cpage, int psize, int cateid, int uid, string key, bool isaudit = false)
{
string where = "Pid=0 ";
if (cateid != 0)
{
where += " AND CateID=" + cateid;
}
//匿名用户不提供搜索
if (uid > 0)
{
where += " AND CUser="******" AND Title LIKE @skey";
}
if (isaudit)
{
where += " AND Status>0 And Status IS NOT NULL";
}
string order = "OrderFlag DESC,R_CDate DESC,CDate DESC";
List <SqlParameter> sp = new List <SqlParameter>()
{
new SqlParameter("skey", "%" + key + "%")
};
PageSetting setting = PageSetting.Single(cpage, psize, TbView, PK, where, order, sp);
DBCenter.SelPage(setting);
return(setting);
}
//本周热门,如本周无数据,则取总数据
public DataTable SelTop(int num)
{
string stime = "", etime = "";
DateHelper.GetWeekSE(DateTime.Now, ref stime, ref etime);
Sql_Where whereMod = new Sql_Where()
{
join = "AND", field = "CDate", type = "date", stime = stime, etime = etime
};
string where = "Pid = 0 And Status != " + ((int)ConStatus.Recycle);
PageSetting setting = new PageSetting()
{
psize = num,
cpage = 1,
pk = PK,
t1 = TbName,
fields = "*",
where = where + DBCenter.DB.GetDateSql(whereMod),
order = "HitCount DESC"
};
DataTable dt = DBCenter.SelPage(setting);
if (dt.Rows.Count < 1)
{
setting.where = where; dt = DBCenter.SelPage(setting);
}
dt.Columns.Add(new DataColumn("IndexNum", typeof(int)));
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["IndexNum"] = (i + 1);
}
return(dt);
}
//----------------------------------------------------------------------------------------------------------
public PageSetting SelPage(int cpage, int psize, Com_Filter filter)
{
string where = " 1=1";
List <SqlParameter> sp = new List <SqlParameter>();
if (filter.type != "-100")
{
where += " AND A.QueType=" + DataConvert.CLng(filter.type);
}
if (!string.IsNullOrEmpty(filter.status))
{
SafeSC.CheckIDSEx(filter.status); where += " AND A.Status IN (" + filter.status + ")";
}
if (!string.IsNullOrEmpty(filter.uids))
{
SafeSC.CheckIDSEx(filter.uids); where += " AND A.UserID IN (" + filter.uids + ")";
}
if (!string.IsNullOrEmpty(filter.skey))
{
where += " AND A.Qcontent LIKE @skey"; sp.Add(new SqlParameter("skey", "%" + filter.skey + "%"));
}
if (!string.IsNullOrEmpty(filter.ids))
{
SafeSC.CheckIDSEx(filter.ids); where += " AND A.ID IN (" + filter.ids + ")";
}
PageSetting setting = PageSetting.Double(cpage, psize, strTableName, "ZL_Grade", "A.ID", "A.QueType=B.GradeID",
where, "ID DESC", sp, "A.*,B.GradeName");
DBCenter.SelPage(setting);
return(setting);
}
public PageSetting SelPage(int cpage, int psize, string inputer = "", int type = -100, string date = "")
{
string where = " 1=1";
List <SqlParameter> sp = new List <SqlParameter>();
if (!string.IsNullOrEmpty(inputer))
{
where += " AND Inputer=@inputer"; sp.Add(new SqlParameter("inputer", inputer));
}
if (type != -100)
{
where += " AND Type=" + type;
}
if (!string.IsNullOrEmpty(date))
{
var newDate = DateTime.MinValue;
bool isdate = DateTime.TryParse(date, out newDate);
if (isdate)
{
where += " And Datediff(d,CreateTime,@Date) = 0";
sp.Add(new SqlParameter("Date", newDate));
}
}
PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, "", sp);
DBCenter.SelPage(setting);
return(setting);
}
/// <summary>
/// 筛选获取数据
/// </summary>
/// <param name="Type">0:后台,1:会员中心</param>
/// <param name="customPath">后台路径</param>
/// <param name="state">0:全部,1:启用,2:禁用</param>
/// <returns></returns>
public PageSetting SelPage(int cpage, int psize, F_Search filter)
{
List <SqlParameter> sp = new List <SqlParameter>();
string where = "1=1 ";
if (!string.IsNullOrEmpty(filter.name))
{
sp.Add(new SqlParameter("name", "%" + filter.name + "%"));
where += " AND Name LIKE @name";
}
if (filter.elite != -100)
{
where += " AND EliteLevel=" + filter.elite;
}
if (filter.type != -100)
{
where += " AND Type=" + filter.type;
}
if (filter.groupId != -100)
{
where += " AND (UserGroup='' OR ','+UserGroup+',' LIKE '%,'+'" + filter.groupId + "'+',%' ) ";
}
PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, "OrderID ASC", sp);
DBCenter.SelPage(setting);
if (filter.type == 1)
{
for (int i = 0; i < setting.dt.Rows.Count; i++)
{
DataRow dr = setting.dt.Rows[i];
dr["FileUrl"] = DataConvert.CStr(dr["FileUrl"]).ToLower().Replace("/manage/", "/" + SiteConfig.SiteOption.ManageDir + "/");
}
}
return(setting);
}
/// <summary>
/// 用于管理试卷下题目
/// </summary>
public PageSetting SelByIDS(int cpage, int psize, string ids, int qtype = 99, string fields = "*")
{
ids = StrHelper.PureIDSForDB(ids);
if (string.IsNullOrEmpty(ids))
{
return(null);
}
if (!SafeSC.CheckIDS(ids))
{
return(null);
}
fields += ",IsRight=0,Remark=''";
//string sql = "SELECT " + fields + ",IsRight=0,Remark='' FROM " + strTableName + " WHERE p_id IN(" + ids + ") ";
string where = " p_id IN(" + ids + ")";
if (qtype != 99)//过滤大题
{
where += " AND p_Type=" + qtype;
}
else
{
where += " AND P_Type!=10";
}
PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, "p_type", null, fields);
DBCenter.SelPage(setting);
return(setting);
}
/// <summary>
/// 关键字搜索，并返回关键字对应文章、商品的数量
/// </summary>
/// <param name="priority">优先级,1:非推荐,2:推荐,其它:全部</param>
/// <returns></returns>
public PageSetting SelPage(int cpage, int psize, string skey = "", int priority = 0)
{
string where = "1=1";
List <SqlParameter> sp = new List <SqlParameter>();
if (!string.IsNullOrEmpty(skey))
{
where += " AND KeywordText LIKE @skey"; sp.Add(new SqlParameter("skey", "%" + skey + "%"));
}
switch (priority)
{
case 1:
where += " AND Priority = 0";
break;
case 2:
where += " AND Priority > 0";
break;
}
PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, "Priority DESC", sp);
setting.fields = "(SELECT COUNT(*) FROM ZL_CommonModel WHERE Tagkey LIKE '%'+A.KeywordText+'%') ConCount,(SELECT COUNT(*) FROM ZL_Commodities WHERE Kayword LIKE '%'+A.KeywordText+'%') ComCount,*";
DBCenter.SelPage(setting);
return(setting);
}
/// <summary>
/// 我发送的好友申请
/// </summary>
public PageSetting SelMySendApply_SPage(int cpage, int psize, int uid)
{
PageSetting setting = PageSetting.Double(cpage, psize, TbName, "ZL_User", "A." + PK, "A.TUserID=B.UserID", "A.UserID=" + uid, "", null, "A.*,B.Salt,B.HoneyName,B.UserName");
DBCenter.SelPage(setting);
return(setting);
}
public PageSetting SelPage(int cpage, int psize, string name = "", string province = "", string city = "", string county = "")
{
string where = " 1=1";
List <SqlParameter> sp = new List <SqlParameter>();
if (!string.IsNullOrEmpty(name))
{
where += " AND SchoolName @LIKE @name"; sp.Add(new SqlParameter("name", name));
}
if (!string.IsNullOrEmpty(province))
{
where += " AND Province=@province"; sp.Add(new SqlParameter("province", province));
}
if (!string.IsNullOrEmpty(city))
{
where += " AND City=@city"; sp.Add(new SqlParameter("city", city));
}
if (!string.IsNullOrEmpty(county))
{
where += " AND County LIKE @county"; sp.Add(new SqlParameter("county", "%" + county + "%"));
}
PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, "", sp);
DBCenter.SelPage(setting);
return(setting);
}
public PageSetting SPageByStore(int cpage, int psize, int expUid, int expStatus = -100)
{
//if (string.IsNullOrEmpty(storeids)) { return new PageSetting() { dt = new DataTable() }; }
//SafeSC.CheckIDSEx(storeids);
//所有已付款,指定了送货员的订单
string mTbName = "(SELECT A.*,B.PayType,B.PrePayInfo,C.ExpNo FROM ZL_OrderInfo A LEFT JOIN ZL_Payment B ON A.PayMentNo = B.PayNO LEFT JOIN ZL_Order_Exp C ON A.ExpressNum = C.ID WHERE A.Paymentstatus = 1 AND C.ExpNo='" + expUid + "')";
//string where = "A.StoreID IN (" + storeids + ") AND A.Settle=0 AND A.Paymentstatus=1";
string where = "1=1 ";
if (expStatus == -100)
{
}
else if (expStatus == 99)
{
//已完结==预付单支付了尾款,普通订单完成了签收
where += " AND ((A.PayType=1 AND A.PrePayInfo LIKE '%\"status\":99%') OR (A.PayType!=1 AND A.StateLogistics=99))";
}
else
{
where += " AND A.StateLogistics=" + expStatus;
}
PageSetting setting = PageSetting.Double(cpage, psize, mTbName, "ZL_CommonModel", "A.ID", "A.StoreID=B.GeneralID", where, "", null, "A.*,B.Title StoreName");
DBCenter.SelPage(setting);
return(setting);
}
public PageSetting SelPage(int cpage, int psize, Com_Filter filter)
{
PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, "");
DBCenter.SelPage(setting);
return(setting);
}
public static PageSetting GetTipsList_SPage(int cpage, int psize, int gid)
{
PageSetting setting = PageSetting.Double(cpage, psize, "ZL_GuestBook", "ZL_User", "A.Gid", "A.UserID=B.UserID", "A.GID=" + gid + " OR A.ParentID=" + gid, "A.ParentID ASC,A.Gid ASC", null, "A.*,B.salt AS UserFace,B.UserName");
DBCenter.SelPage(setting);
return(setting);
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="status">词条状态：0未审核，1通过</param>
/// <param name="title">词条名称</param>
/// <param name="btype">词条标签</param>
/// <param name="bkclass">词条所属类别</param>
/// <returns></returns>
public PageSetting SelPage(int cpage, int psize, int status = -100, string title = "", string btype = "", int uid = -100, string bkclass = "")
{
string where = " 1=1";
List <SqlParameter> sp = new List <SqlParameter>();
if (status != -100)
{
where += " AND Status=" + status;
}
if (!string.IsNullOrEmpty(title))
{
where += " AND Tittle LIKE @title"; sp.Add(new SqlParameter("title", "%" + title + "%"));
}
if (!string.IsNullOrEmpty(btype))
{
where += " AND btype LIKE @btype"; sp.Add(new SqlParameter("btype", "%" + btype + "%"));
}
if (uid != -100)
{
where += " AND UserID=" + uid;
}
if (!string.IsNullOrEmpty(bkclass))
{
where += " ANd bkclass=@bkclass"; sp.Add(new SqlParameter("bkclass", bkclass));
}
PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, "", sp);
DBCenter.SelPage(setting);
return(setting);
}
public PageSetting SelWaitQuest_SPage(int cpage, int psize, string quetype = "", int stype = 1, string skey = "")
{
string where = "1=1";
List <SqlParameter> sp = new List <SqlParameter>();
switch (stype)
{
case 1: where += " AND Status <> 2"; break;
case 2: where += " AND Status = 2"; break;
}
if (!string.IsNullOrEmpty(quetype))
{
where += " AND QueType = @quetype";
sp.Add(new SqlParameter("quetype", quetype));
}
if (!string.IsNullOrEmpty(skey))
{
where += " AND (Qcontent like @key or Supplyment like @key or QueType like @key)";
sp.Add(new SqlParameter("key", "%" + skey + "%"));
}
string fields = "*,(SELECT COUNT(*) FROM ZL_Favorite WHERE InfoID=A.ID) Favorite,(SELECT COUNT(*) FROM ZL_GuestAnswer WHERE QueID=A.ID) Answer";
PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, "AddTime DESC", sp, fields);
DBCenter.SelPage(setting);
return(setting);
}
/// <summary>
/// 根据词条名,标签,类别来搜索数据,用于替代其他所有搜索
/// </summary>
/// <param name="title">词条名称</param>
/// <param name="btype">词条标签</param>
/// <param name="bkclass">词条所属类别</param>
public PageSetting SelByInfo(int cpage, int psize, string title, string btype, int uid, string bkclass = "")
{
List <SqlParameter> sp = new List <SqlParameter>();
string where = " Status=1 ";
if (!string.IsNullOrEmpty(title))
{
where += " AND Tittle LIKE @title"; sp.Add(new SqlParameter("title", "%" + title + "%"));
}
if (!string.IsNullOrEmpty(btype))
{
where += " AND btype LIKE @btype"; sp.Add(new SqlParameter("btype", "%" + btype + "%"));
}
if (uid > 0)
{
where += " AND UserID=" + uid;
}
if (!string.IsNullOrEmpty(bkclass))
{
where += " AND bkclass=@bkclass"; sp.Add(new SqlParameter("bkclass", bkclass));
}
PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, PK + " DESC", sp);
DBCenter.SelPage(setting);
return(setting);
}
public PageSetting SelPage_All(int cpage, int psize, int userid = 0, int status = -1, string skey = "")
{
string where = "1=1";
List <SqlParameter> sp = new List <SqlParameter>();
if (userid > 0)
{
where += " AND CreateUser="******" AND IsTrue =" + status;
}
if (!string.IsNullOrEmpty(skey))
{
where += " AND RoomName LIKE @name"; sp.Add(new SqlParameter("name", "%" + skey + "%"));
}
//该班级成员人数字段（按成员类别统计）
string stufiled = ",(SELECT COUNT(*) FROM ZL_Exam_Student E WHERE A.RoomID=E.RoomID AND E.StudentType={0}) {1} ";
PageSetting setting = PageSetting.Single(cpage, psize, "ZL_Exam_ClassView", PK, where, "Creation DESC", sp);
setting.fields = "*" + string.Format(stufiled, 1, "StuCount") + string.Format(stufiled, 2, "TeachCount") + string.Format(stufiled, 3, "FamilyCount");
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.status) && filter.status != "-100")
{
where += " AND Status=" + DataConvert.CLng(filter.status);
}
if (!string.IsNullOrEmpty(filter.skey))
{
where += " AND A.Tittle LIKE @key";
sp.Add(new SqlParameter("key", "%" + filter.skey + "%"));
}
if (!string.IsNullOrEmpty(filter.uids))
{
SafeSC.CheckIDSEx(filter.uids);
where += " AND UserID IN (" + filter.uids + ")";
}
if (!string.IsNullOrEmpty(filter.type))
{
where += " AND btype LIKE @btype"; sp.Add(new SqlParameter("btype", "%" + filter.type + "%"));
}
if (!string.IsNullOrEmpty(filter.nids))
{
where += " ANd bkclass=@bkclass"; sp.Add(new SqlParameter("bkclass", filter.nids));
}
//if (!string.IsNullOrEmpty(btype)) { where += " AND btype LIKE @btype"; sp.Add(new SqlParameter("btype", "%" + btype + "%")); }
//if (!string.IsNullOrEmpty(bkclass)) { where += " ANd bkclass=@bkclass"; sp.Add(new SqlParameter("bkclass", bkclass)); }
string fields = "A.*,B.GradeName";
PageSetting setting = PageSetting.Double(cpage, psize, TbName, "ZL_Grade", "A." + PK, "A.BType=B.GradeName", where, "A." + PK + " DESC", sp, fields);
DBCenter.SelPage(setting);
return(setting);
}
//, 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);
}
//---------------------------------------------New
public PageSetting SelPage(int cpage, int psize, F_Pub filter)
{
string where = "1=1 ";
List <SqlParameter> sp = new List <SqlParameter>();
if (!string.IsNullOrEmpty(filter.pubType))
{
SafeSC.CheckIDSEx(filter.pubType);
where += " AND PubType IN (" + filter.pubType + ")";
}
if (!string.IsNullOrEmpty(filter.pubName))
{
sp.Add(new SqlParameter("pname", filter.pubName));
where += " AND PubName=@pname";
}
if (filter.hasDel == false)
{
where += " AND PubIsDel=0";
}
if (!string.IsNullOrEmpty(filter.ids))
{
SafeSC.CheckIDSEx(filter.ids);
where += " AND PubID IN (" + filter.ids + ")";
}
PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, "", sp);
DBCenter.SelPage(setting);
return(setting);
}
//获取焦点数据
public DataTable SelFocus()
{
//后期改为不获取加密社区
int itemcount = 0;
return(DBCenter.SelPage(10, 1, out itemcount, "A.ID", "a.*,b.CateName", TbName, "ZL_GuestCate", "a.CateID=b.CateID", "Pid=0 And A.Status>0 AND CateName !='华成会' AND B.GType=1", "CDate Desc"));
}
private DataTable SelPage(out int itemCount)
{
//0:内容,1:商品,2:论坛,3:问答,4:留言,5:店铺
int s = DataConvert.CLng(Request["s"]);
//*节点ID可能有重复,解决:加一个来源参数,S=0:内容表,1:贴吧
//ZL_CommonModel status=99,表名ZL_C_,或ZL_P,或ZL_S
string where = " Title Like @key ";
if (s != -100)
{
where += " AND S=" + s;
}
string order = "";
if (NodeID > 0)
{
where += " AND NodeID=" + NodeID;
}
switch (Order)
{
case 0:
order = "CreateTime DESC";
break;
case 1:
order = "Hits DESC";
break;
}
SqlParameter[] sp = new SqlParameter[] { new SqlParameter("key", "%" + KeyWord + "%") };
return(DBCenter.SelPage(20, CPage, out itemCount, "ID", "*", "ZL_SearchView", where, order, sp));
}
private PageSetting SelPage(int cpage, int psize, int stepid, int id)
{
string where = "";
if (id > 0)
{
where += " A.ID=" + id;
}
if (stepid > 0)
{
where += " A.StepID=" + stepid;
}
PageSetting setting = new PageSetting()
{
fields = "A.*,B.UserName,B.UserFace,B.GroupName",
cpage = cpage,
psize = psize,
t1 = "ZL_Pro_Msg",
t2 = "ZL_User_PlatView",
on = "A.CUser=B.UserID",
where = where
};
setting.dt = DBCenter.SelPage(setting);
return(setting);
}
public PageSetting SelWaitQuest_SPage(int cpage, int psize, string quetype = "", int stype = 1, string skey = "")
{
string where = "1=1";
List <SqlParameter> sp = new List <SqlParameter>();
switch (stype)
{
case 1: where += " AND Status <> 2"; break;
case 2: where += " AND Status = 2"; break;
}
if (!string.IsNullOrEmpty(quetype))
{
where += " AND QueType = @quetype";
sp.Add(new SqlParameter("quetype", quetype));
}
if (!string.IsNullOrEmpty(skey))
{
where += " AND (Qcontent like @key or Supplyment like @key or QueType like @key)";
sp.Add(new SqlParameter("key", "%" + skey + "%"));
}
PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, "AddTime DESC", sp);
DBCenter.SelPage(setting);
return(setting);
}
/// <summary>
/// 用于前后台|店铺筛选订单(支持快速搜索)
/// </summary>
public PageSetting SelPage(int cpage, int psize, out double total, int storeid, string orderType, string orderStatus, string payStatus)
{
string where = "1=1 ";
if (storeid != -100)
{
where += " AND StoreID=" + storeid;
}
if (!string.IsNullOrEmpty(orderType))
{
SafeSC.CheckIDSEx(orderType); where += " AND OrderType IN (" + orderType + ")";
}
if (!string.IsNullOrEmpty(orderStatus))
{
where += " AND OrderStatus=" + DataConvert.CLng(orderStatus);
}
if (!string.IsNullOrEmpty(payStatus))
{
where += " AND Paymentstatus=" + DataConvert.CLng(payStatus);
}
PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, "", null);
DBCenter.SelPage(setting);
total = DataConvert.CDouble(DBCenter.ExecuteScala(TbName, "SUM(ordersamount)", where));
return(setting);
}
public PageSetting SelPage(int cpage, int psize, int queType = -100, int status = -100, int uid = -100, string key = "")
{
string where = " 1=1";
List <SqlParameter> sp = new List <SqlParameter>();
if (queType != -100)
{
where += " AND QueType=" + queType;
}
if (status != -100)
{
where += " AND Status=" + status;
}
if (uid != -100)
{
where += " AND UserID=" + uid;
}
if (!string.IsNullOrEmpty(key))
{
where += " AND Qcontent LIKE @skey"; sp.Add(new SqlParameter("skey", "%" + key + "%"));
}
PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, "", sp);
DBCenter.SelPage(setting);
return(setting);
}
public PageSetting SelPage(int cpage, int psize)
{
PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, "");
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 (group != -100) { where += " AND [Group]=" + group; }
//if (status != -100) { where += " AND Status=" + status; }
if (!string.IsNullOrEmpty(filter.skey))
{
sp.Add(new SqlParameter("name", "%" + filter.skey + "%"));
where += " AND Name LIKE @name";
}
if (filter.pid > 0)
{
where += " And ParentID=" + filter.pid;
}
else
{
where += " And ParentID=0";
}
//不倒序
PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, "", sp);
DBCenter.SelPage(setting);
return(setting);
}
