private DataTable MyBind(int psize, int cpage)
{
M_ModelInfo modMod = modBll.SelReturnModel(pubMod.PubModelID);
string where = "1=1 ";
List <SqlParameter> sp = new List <SqlParameter>();
if (!string.IsNullOrEmpty(skey.Value))
{
if (!IsExistInFieldDT(skey_dp.SelectedValue))
{
function.WriteErrMsg("搜索的字段不存在");
}
where += " AND " + skey_dp.SelectedValue + " LIKE @skey";
sp.Add(new SqlParameter("skey", "%" + skey.Value.Trim() + "%"));
}
if (Status != -100)
{
where += " AND PubStart=" + Status;
}
if (ParentID > 0)
{
where += " AND Parentid=" + ParentID;
}
setting = PageSetting.Single(cpage, psize, modMod.TableName, "ID", where, "ID DESC", sp);
DBCenter.SelPage(setting);
foreach (DataRow dr in setting.dt.Rows)
{
dr["PubIP"] = dr["PubIP"] + "(" + IPScaner.IPLocation(DataConvert.CStr(dr["PubIP"])) + ")";
}
RPT.ItemCount = setting.itemCount;
return(setting.dt);
}
/// <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="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);
}
/// <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>
/// <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);
}
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, 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 SelPage(int cpage, int psize, F_User filter)
{
List <SqlParameter> sp = new List <SqlParameter>();
string where = "1=1 ";
if (!string.IsNullOrEmpty(filter.groupIds))
{
if (filter.groupIds.Equals("0"))//全部
{
}
else if (filter.groupIds.Equals("-1"))//未分组
{
where += " And Gid IS NULL OR Gid=''";
}
else
{
where += " And Gid Like '%," + DataConvert.CLng(filter.groupIds) + ",%'";
}
}
if (!string.IsNullOrEmpty(filter.compIds) && !filter.compIds.Equals("0"))
{
where += " AND CompID=" + DataConvert.CLng(filter.compIds);
}
if (!string.IsNullOrEmpty(filter.uname))
{
sp.Add(new SqlParameter("uname", "%" + filter.uname + "%"));
where += " AND (UserName LIKE @uname OR HoneyName LIKE @uname) ";
}
PageSetting setting = PageSetting.Single(cpage, psize, TbView, PK, where, "", 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 (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);
}
public PageSetting SelPage(int cpage, int psize, int stype, int uid, string skey, string stime, string etime)
{
string tbname = GetTbName((SType)stype);
List <SqlParameter> sp = new List <SqlParameter>();
string where = "1=1 ";
if (uid > 0)
{
where += " AND UserID=" + uid;
}
if (!string.IsNullOrEmpty(stime))
{
where += " AND HisTime >=@stime"; sp.Add(new SqlParameter("stime", stime));
}
if (!string.IsNullOrEmpty(etime))
{
where += " AND HisTime <=@etime"; sp.Add(new SqlParameter("etime", etime));
}
if (!string.IsNullOrEmpty(skey))
{
where += " AND Detail LIKE @skey"; sp.Add(new SqlParameter("skey", "%" + skey + "%"));
}
PageSetting setting = PageSetting.Single(cpage, psize, tbname, PK, where, "HisTime DESC", sp);
DBCenter.SelPage(setting);
return(setting);
}
public static PageSetting User_SelPage(int cpage, int psize, F_User filter)
{
List <SqlParameter> sp = new List <SqlParameter>();
string where = "SiteID=" + filter.storeId + " ";
//where += " AND Status=0";
switch (filter.utype)
{
case "employee":
where += " AND GroupID=" + ExConast.EmployGroup;
break;
case "client":
default:
where += " AND GroupID=" + ExConast.ClientGroup;
break;
}
if (!string.IsNullOrEmpty(filter.uname))
{
sp.Add(new SqlParameter("uname", "%" + filter.uname + "%"));
where += " AND UserName LIKE @uname";
}
if (filter.status != -100)
{
where += " AND Status=" + filter.status;
}
PageSetting setting = PageSetting.Single(cpage, psize, "ZL_User", "UserID", where, "UserID DESC", sp);
DBCenter.SelPage(setting);
return(setting);
}
public PageSetting SelPage(int cpage, int psize, string inputer = "", int results = -100, string approver = "", string send = "")
{
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 (results != -100)
{
where += " AND Results=" + results;
}
if (!string.IsNullOrEmpty(approver))
{
where += " AND Approver LIKE @approver"; sp.Add(new SqlParameter("approver", "%" + approver + "%"));
}
if (!string.IsNullOrEmpty(send))
{
where += " AND Send LIKE @send"; sp.Add(new SqlParameter("send", "%" + send + "%"));
}
PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, "", sp);
DBCenter.SelPage(setting);
return(setting);
}
public PageSetting SelPage(int cpage, int psize, int pid = -100, string inputer = "", string type = "", string title = "")
{
string where = " 1=1";
List <SqlParameter> sp = new List <SqlParameter>();
if (pid != -100)
{
where += " AND ParentID=" + pid;
}
if (!string.IsNullOrEmpty(inputer))
{
where += " AND Inputer LIKE @inputer"; sp.Add(new SqlParameter("inputer", inputer));
}
if (!string.IsNullOrEmpty(type))
{
where += " AND type LIKE @type"; sp.Add(new SqlParameter("type", type));
}
if (!string.IsNullOrEmpty(title))
{
where += " AND title LIKE @title"; sp.Add(new SqlParameter("title", title));
}
PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, "", sp);
DBCenter.SelPage(setting);
return(setting);
}
public PageSetting SelPage(int cpage, int psize, string ztype = "", string ids = "", string remind = "", int status = -100, int uid = 0)
{
string where = "1=1 ";
List <SqlParameter> sp = new List <SqlParameter>();
if (!string.IsNullOrEmpty(ztype))
{
where += " AND A.ZType=@ztype"; sp.Add(new SqlParameter("ztype", ztype));
}
if (!string.IsNullOrEmpty(ids))
{
SafeSC.CheckIDSEx(ids); where += " AND A.ID IN (" + ids + ")";
}
if (!string.IsNullOrEmpty(remind))
{
where += " AND A.Remind=@remind"; sp.Add(new SqlParameter("remind", remind));
}
if (status != -100)
{
where += " AND A.Status=" + status;
}
if (uid > 0)
{
where += " AND A.UserID=" + uid;
}
PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, PK + " DESC", sp);
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 PageSetting SelPage(int cpage, int psize, Com_Filter filter)
{
PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, "");
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>
/// <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(int cpage, int psize, Com_Filter filter)
{
string fields = "*";
string where = "1=1";
List <SqlParameter> sp = new List <SqlParameter>();
if (filter.storeId != -100)
{
where += " AND SpecCate=" + filter.storeId;
}
if (filter.pid != -100)
{
where += " AND Pid=" + filter.pid;
}
if (!string.IsNullOrEmpty(filter.skey))
{
where += " AND SpecName LIKE @name";
sp.Add(new SqlParameter("name", "%" + filter.skey + "%"));
}
if (filter.type != "-100")
{
where += " AND SpecCate=" + DataConvert.CLng(filter.type);
}
if (filter.mode == "list")
{
fields = "A.*,(Select Count(*) From ZL_Special Where Pid=A.SpecID) as ChildCount";
}
PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, "OrderID", sp, fields);
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, 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);
}
/// <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);
}
//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 PageSetting SelPage(int cpage, int psize)
{
PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, "", "CDate DESC");
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);
}
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);
}
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 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);
}
public PageSetting SelPage(int cpage, int psize)
{
string where = "1=1 ";
PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where);
DBCenter.SelPage(setting);
return(setting);
}
//只取正常状态的
private DataTable SelMyLend()
{
string where = "UserID=" + mu.UserID + " AND OrderType=10 AND OrderStatus IN (0,-2) ";
PageSetting setting = PageSetting.Single(1, int.MaxValue, "ZL_Ex_OrderView", "ID", where, "OrderStatus DESC,ID ASC");
DBCenter.SelPage(setting);
return(setting.dt);
}