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