public PageSetting SelPage(int cpage, int psize, F_Stock filter) { string where = "1=1 "; //if (storeid != -100) { where += " AND A.StoreID=" + storeid; } List <SqlParameter> sp = new List <SqlParameter>(); if (filter.ProID != 0 && filter.ProID != -100) { where += " AND A.ProID=" + filter.ProID; } if (filter.StoreID != -100) { where += " AND A.StoreID=" + filter.StoreID; } if (filter.StockType != -100) { where += " AND A.StockType=" + filter.StockType; } if (!string.IsNullOrEmpty(filter.ProName)) { where += " AND B.ProName LIKE @proname"; sp.Add(new SqlParameter("proname", "%" + filter.ProName + "%")); } if (!string.IsNullOrEmpty(filter.AddUser)) { where += " AND A.AddUser LIKE @adduser"; sp.Add(new SqlParameter("adduser", "%" + filter.AddUser + "%")); } if (!string.IsNullOrEmpty(filter.SDate)) { where += " AND A.AddTime>=@sdate"; sp.Add(new SqlParameter("sdate", Convert.ToDateTime(filter.SDate).ToString("yyyy/MM/dd 00:00:00"))); } if (!string.IsNullOrEmpty(filter.EDate)) { where += " AND A.AddTime<=@edate"; sp.Add(new SqlParameter("edate", Convert.ToDateTime(filter.EDate).ToString("yyyy/MM/dd 23:59:59"))); } if (filter.NodeID != 0) { where += " AND B.NodeID=" + filter.NodeID; } //PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where); PageSetting setting = PageSetting.Double(cpage, psize, TbName, "ZL_Commodities", "A.ID", "A.ProID=B.ID", where, "A.ID DESC", sp, "A.*,B.ProName,B.NodeID"); DBCenter.SelPage(setting); return(setting); }
public PageSetting GetPageSetting(string filePath) { string url = (filePath.IndexOf("?") > 0 ? filePath.Substring(0, filePath.IndexOf("?")) : filePath); url = url.ToLower(); url = url.Replace("//", "/"); for (int i = 0; i < this.m_PageSettings.Length; i++) { PageSetting setting = this.m_PageSettings[i]; if (string.Compare(setting.FilePath, url, true) == 0) { return(setting); } } return(new PageSetting()); }
public IActionResult ModelManage() { ViewBag.ModelType = ModelType; PageSetting setting = bll.SelPage(CPage, PSize, new Com_Filter() { type = ModelType.ToString(), skey = "", orderBy = GetParam("orderBy") }); if (Request.IsAjax()) { return(PartialView("ModelManage_List", setting)); } return(View("ModelManage", setting)); }
public ActionResult DeliveryMan() { M_CommonData storeMod = conBll.SelMyStore_Ex(ref err); if (!string.IsNullOrEmpty(err)) { function.WriteErrMsg(err); return(null); } PageSetting setting = manBll.SelPage(CPage, PSize, storeMod.GeneralID); if (Request.IsAjaxRequest()) { return(PartialView("DeliveryMan_List", setting)); } return(View(setting)); }
public PageSetting SelPage(int cpage, int psize, int cid = -100, int uid = -100) { string where = " 1=1"; if (cid != -100) { where += " AND OwenClass=" + cid; } if (uid != -100) { where += " AND UserID"; } PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where); DBCenter.SelPage(setting); return(setting); }
public PageSetting SelPage(int cpage, int psize, int group = -100, int status = -100) { string where = " 1=1"; if (group != -100) { where += " AND [Group]=" + group; } if (status != -100) { where += " AND Status=" + status; } PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, ""); DBCenter.SelPage(setting); return(setting); }
public PageSetting SelPage(int cpage, int psize, int nodeid = 0, string roleids = "") { string where = " 1=1"; if (nodeid > 0) { where += " AND NID=" + nodeid; } if (!string.IsNullOrEmpty(roleids)) { SafeSC.CheckIDSEx(roleids); where += " AND RID IN (" + roleids + ")"; } PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where); DBCenter.SelPage(setting); return(setting); }
public PageSetting U_SPage(int cpage, int psize, int uid, int nodeid = 0, int Recycler = -100) { string where = "UserID=" + uid; if (nodeid > 0) { where += " AND (NodeID=" + nodeid + " OR FirstNodeID=" + nodeid + ")"; } if (Recycler != -100) { where += " AND Recycler=" + Recycler; } PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, PK + " DESC"); DBCenter.SelPage(setting); return(setting); }
/// <summary> /// 用于发送消息后直接返回查看,限定用户ID(安全) /// </summary> public DataTable SelByPid(int id, int uid) { PageSetting setting = new PageSetting() { psize = 1, cpage = 1, pk = "A.ID", t1 = TbView, t2 = "ZL_User", fields = "A.*,B.Salt AS UserFace,B.UserName,B.HoneyName", on = "A.CUser=B.UserID", where = "A.CUser="******" AND A.ID=" + id }; return(DBCenter.SelPage(setting)); }
public IActionResult BKVersionList() { ViewBag.viewDir = viewDir; PageSetting setting = editBll.SelPage(CPage, PSize, new Com_Filter() { skey = GetParam("skey"), addon = Flow }); ViewBag.viewDir = viewDir; if (Request.IsAjax()) { return(PartialView(viewDir + "BKVersion_List.cshtml", setting)); } return(View("BKVersionList", setting)); }
public ActionResult FollowList() { int ztype = DataConverter.CLng(Request["type"]); PageSetting setting = null; if (ztype == 1)//关注我的 { setting = fwBll.SelByTUser_SPage(CPage, PSize, mu.UserID, Request["skey"]); } else { setting = fwBll.SelByUser_SPage(CPage, PSize, mu.UserID, Request["skey"]); } ViewBag.ztype = ztype; return(View(setting)); }
public ActionResult KnowledgeManage() { int NodeID = DataConverter.CLng(Request.QueryString["nid"]); if (NodeID < 1) { function.WriteErrMsg("未指定科目"); return(null); } PageSetting setting = knowBll.SelPage(CPage, PSize, NodeID); if (Request.IsAjaxRequest()) { return(PartialView("KnowledgeManage_List", setting)); } return(View(setting)); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { PageSetting setting = SelPage(CPage, PSize, new F_Logo_Design() { }); DataTable dt = setting.dt; foreach (DataRow dr in dt.Rows) { dr["LogoContent"] = StrHelper.DecompressString(DataConvert.CStr(dr["LogoContent"])); } List_Hid.Value = JsonConvert.SerializeObject(dt); Page_Lit.Text = PageCommon.CreatePageHtml(setting.pageCount, CPage); } }
//运费模板 public IActionResult DeliverType() { PageSetting setting = fareBll.SelPage(CPage, PSize, new Com_Filter() { uids = mu.UserID.ToString() }); if (Request.IsAjaxRequest()) { return(PartialView("DeliverType_List", setting)); } else { return(View("DeliverType", setting)); } }
public PageSetting SelPage(int cpage, int psize, int uid = -100, int IsDefault = -100) { string where = " 1=1"; if (uid != -100) { where += " AND UserID" + uid; } if (IsDefault != -100) { where += " AND IsDefault=" + IsDefault; } PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where, ""); DBCenter.SelPage(setting); return(setting); }
public ActionResult SaleList() { PageSetting setting = payBll.SelPage(CPage, PSize, mu.UserID); if (Request.IsAjaxRequest()) { return(PartialView("SaleList_List", setting)); } else { object allmoney, MoneyTrue; allmoney = setting.dt.Compute("Sum(MoneyPay)", ""); MoneyTrue = setting.dt.Compute("Sum(MoneyTrue)", ""); return(View(setting)); } }
public ActionResult ClassRoomManage() { if (!B_ARoleAuth.AuthCheckEx(ZLEnum.Auth.exam, "class")) { return(null); } int status = DataConverter.CLng(Request["status"], -1); string skey = Request["skey"]; PageSetting setting = croomBll.SelPage_All(CPage, PSize, 0, status, skey); if (Request.IsAjaxRequest()) { return(PartialView("ClassRoomManage_List", setting)); } return(View(setting)); }
public PageSetting SelPage(int cpage, int psize, int status = -100, int uid = 0) { string where = " 1=1"; if (status != -100) { where += " AND MailStatus=" + status; } if (uid > 0) { where += " AND UserID=" + uid; } PageSetting setting = PageSetting.Single(cpage, psize, strTableName, PK, where); DBCenter.SelPage(setting); return(setting); }
// 回答其他用户的提问,仅限于被@ public ActionResult ISAnswer() { string title = Request.Form["title"]; PageSetting setting = isBll.SelPage(CPage, PSize, new F_IServer() { ccuser = mu.UserID.ToString(), title = Request.Form["title"], state = Request.Form["state"] }); if (function.isAjax()) { return(PartialView("ISAnswer_List", setting)); } return(View(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); }
public PageSetting SelPage_U(int cpage, int psize, int userid, string skey = "") { string where = "CreateUser!=" + userid + " AND IsTrue=1"; List <SqlParameter> sp = new List <SqlParameter>(); if (!string.IsNullOrEmpty(skey)) { where += " AND (SchoolName LIKE @key OR GradeName LIKE @key OR RoomName LIKE @key)"; sp.Add(new SqlParameter("key", "%" + skey + "%")); } string fields = "*,(SELECT COUNT(*) FROM ZL_Exam_Student B WHERE UserID=" + userid + " AND B.RoomID=A.RoomID) AS StuCount"; PageSetting setting = PageSetting.Single(cpage, psize, "ZL_Exam_ClassView", PK, where, "", sp, fields); DBCenter.SelPage(setting); return(setting); }
public PageSetting SelMyAsk_SPage(int cpage, int psize, int userID, string quetype = "") { string where = "UserID=" + userID; List <SqlParameter> sp = new List <SqlParameter>(); if (!string.IsNullOrEmpty(quetype)) { where += " AND QueType LIKE @quetype"; sp.Add(new SqlParameter("quetype", quetype)); } 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 ActionResult Papers_System_Manage() { if (!B_ARoleAuth.AuthCheckEx(ZLEnum.Auth.exam, "paper")) { return(null); } int PaperClass = DataConverter.CLng(Request.QueryString["type"]); int NodeID = DataConverter.CLng(Request.QueryString["NodeID"]); PageSetting setting = paperBll.SelAll_SPage(CPage, PSize, NodeID, Request["skey"]); if (Request.IsAjaxRequest()) { return(PartialView("Papers_System_Manage_List", setting)); } ViewBag.nodeid = NodeID; return(View(setting)); }
public PageSetting SelPage(int cpage, int psize, int proid = -100) { string where = " 1=1"; string order = ""; if (proid != -100) { where += " AND ProID=" + proid; order = "StepNum"; } PageSetting setting = PageSetting.Single(cpage, psize, strTableName, "A." + PK, where, order); setting.fields = "A.*,B.ProcedureName"; setting.t2 = "ZL_MisProcedure"; setting.on = "A.ProID=B.ID"; DBCenter.SelPage(setting); return(setting); }
public PageSetting SelPage(int cpage, int psize, Filter_Arrive filter) { string where = "1=1"; if (filter.uid > 0) { where += " AND UserID=" + filter.uid; } if (filter.type != -100) { where += " AND type=" + filter.type; } if (filter.state != -100) { where += " AND state=" + filter.state; } if (filter.storeID != -100) { where += " AND StoreID=" + filter.storeID; } if (!string.IsNullOrEmpty(filter.StoreIDS)) { SafeSC.CheckIDSEx(filter.StoreIDS); where += " AND StoreID IN (" + filter.StoreIDS + ")"; } switch (filter.addon.ToLower()) { case "expired": where += " AND EndTime <= GETDATE()"; break; case "noexp": where += " AND EndTime > GETDATE()"; break; default: break; } //string mtbname = "(SELECT A.*,B.Title AS StoreName FROM ZL_Arrive A LEFT JOIN ZL_CommonModel B ON A.StoreID=B.GeneralID)"; string fields = "*,(SELECT UserName FROM ZL_User WHERE UserID=A.UserID) AS UserName"; fields += ",(SELECT Title FROM ZL_CommonModel WHERE GeneralID=A.StoreID) AS StoreName"; PageSetting setting = PageSetting.Single(cpage, psize, TbName, PK, where, "ID DESC", null, fields); DBCenter.SelPage(setting); return(setting); }
public IActionResult Message() { F_Message filter = new F_Message() { title = RequestEx["skey_t"], uid = mu.UserID, filter = "rece" }; PageSetting setting = msgBll.SelPage(CPage, PSize, filter); if (Request.IsAjax()) { return(PartialView("Message_List", setting)); } ViewBag.filter = filter; return(View(setting)); }
public static DataTable SelPage(int psize, int cpage, out int itemCount, string pk, string fields, string tbname, string where = "", string order = "", SqlParameter[] sp = null) { PageSetting config = new PageSetting(); config.cpage = cpage; config.psize = psize; config.pk = pk; config.fields = fields; config.t1 = tbname; config.where = where; config.order = order; config.sp = sp; DataTable dt = DB.SelPage(config); itemCount = config.itemCount; return(dt); }
public ActionResult QuestList() { PageSetting setting = questBll.U_SelByFilter(CPage, PSize, NodeID, QType, "", mu.UserID, 0); C_TreeView treeMod = new C_TreeView() { NodeID = "C_id", NodeName = "C_ClassName", NodePid = "C_Classid", DataSource = clsBll.Select_All(), SelectedNode = Request.QueryString["NodeID"] }; ViewBag.treeMod = treeMod; ViewBag.QType = QType; ViewBag.NodeID = NodeID; return(View(setting)); }
//发件箱 public ActionResult MessageOutbox() { F_Message filter = new F_Message() { title = Request["skey_t"], uid = mu.UserID, filter = "send" }; PageSetting setting = msgBll.SelPage(CPage, PSize, filter); if (function.isAjax()) { return(PartialView("MessageOutbox_List", setting)); } ViewBag.filter = filter; return(View(setting)); }
public IActionResult OrderList() { if (!B_ARoleAuth.AuthCheckEx(ZLEnum.Auth.shop, "order")) { return(null); } Filter_Order filter = new Filter_Order(); filter.cpage = CPage; filter.psize = PSize; filter.storeType = GetParam("StoreType_DP"); filter.orderType = GetParam("OrderType"); filter.addon = GetParam("filter"); filter.proname = GetParam("ProName_T"); filter.orderno = GetParam("OrderNo_T"); filter.reuser = GetParam("ReUser_T"); filter.mobile = GetParam("Mobile_T"); filter.uids = GetParam("UserID_T"); filter.stype = GetParam("SkeyType_DP"); filter.skey = GetParam("Skey_T"); filter.stime = GetParam("STime_T"); filter.etime = GetParam("ETime_T"); filter.expstime = GetParam("ExpSTime_T"); filter.expetime = GetParam("ExpETime_T"); if (!Request.IsAjaxRequest()) { filter.needCount = true; } PageSetting setting = cpBll.SelForOrderList(filter); DataTable StoreDT = orderCom.SelStoreDT(setting.dt); DataTable CartDT = setting.dt; setting.dt = new DataTableHelper().DistinctByField(setting.dt, "ID"); //Session["Temp_OrderList"] = CartDT; ViewBag.filter = filter; ViewBag.CartDT = CartDT; if (Request.IsAjaxRequest()) { return(PartialView("Order_List", setting)); } else { ViewBag.countMod = filter.countMod; return(View(setting)); } }