public ActionResult List() { var model = new ListViewModel(); var key = Request.QueryString["skeys"] ?? ""; var state = Request.QueryString["state"] ?? ""; var _sort = Request.QueryString["s_sort"] ?? "0"; model.CurrentPage = Convert.ToInt32(Request.QueryString["curr"] ?? "1"); if (model.CurrentPage == 0) { model.CurrentPage = 1; } string stype = !string.IsNullOrEmpty(Request["stype"]) ? Request["stype"] : ""; model.PageSize = Convert.ToInt32(Request.QueryString["psize"] ?? "10"); int pageCount; var sort = Convert.ToInt32(_sort); var lstWhere = new List <string>(); if (!string.IsNullOrEmpty(state)) { lstWhere.Add(string.Format("m_state={0}", state)); } if (!string.IsNullOrEmpty(stype)) { if (!string.IsNullOrEmpty(key)) { if (stype == "1") { lstWhere.Add(string.Format("m_loginname like '%{0}%'", key)); } if (stype == "2") { lstWhere.Add(string.Format("m_realname like '%{0}%'", key)); } } } var where = lstWhere.Count > 0 ? string.Format(" WHERE {0}", string.Join(" AND ", lstWhere)) : ""; var strSql = string.Format("SELECT * FROM jmp_merchant {0}", where); var strOrderBy = string.Format(" ORDER BY m_id {0}", sort == 0 ? "" : "DESC"); var lst = new JMP.BLL.BllCommonQuery().GetLists <JMP.MDL.jmp_merchant>(strSql, strOrderBy, model.CurrentPage, model.PageSize, out pageCount); model.PageCount = pageCount; if (lst != null && lst.Count > 0) { model.Merchants = lst; } model.ButtonsTags = GetVoidHtml(); model.MerchantSearchModel.Sort = sort; model.MerchantSearchModel.State = state; model.MerchantSearchModel.SearchKey = key; ViewBag.stype = stype; return(View(model)); }
public ActionResult ChoiceMerchantList() { var model = new ListUserViewModel(); var key = Request.QueryString["skeys"] ?? ""; var _sort = Request.QueryString["s_sort"] ?? "0"; model.CurrentPage = Convert.ToInt32(Request.QueryString["curr"] ?? "1"); model.PageSize = Convert.ToInt32(Request.QueryString["psize"] ?? "10"); int pageCount; var sort = Convert.ToInt32(_sort); string stype = !string.IsNullOrEmpty(Request["stype"]) ? Request["stype"] : ""; //string dept = System.Configuration.ConfigurationManager.AppSettings["RoleID"]; var lstWhere = new List <string>(); lstWhere.Add(string.Format("u_state={0}", 1)); ///lstWhere.Add(string.Format(" u_role_id ={0}", ""+dept+"" )); if (!string.IsNullOrEmpty(stype)) { if (!string.IsNullOrEmpty(key)) { if (stype == "1") { lstWhere.Add(string.Format("u_loginname like '%{0}%'", key)); } if (stype == "2") { lstWhere.Add(string.Format("u_realname like '%{0}%'", key)); } } } var where = lstWhere.Count > 0 ? string.Format(" WHERE {0}", string.Join(" AND ", lstWhere)) : ""; var strSql = string.Format("SELECT * FROM jmp_locuser {0}", where); var strOrderBy = string.Format(" ORDER BY u_id {0}", sort == 0 ? "" : "DESC"); var lst = new JMP.BLL.BllCommonQuery().GetLists <JMP.MDL.jmp_locuser>(strSql, strOrderBy, model.CurrentPage, model.PageSize, out pageCount); model.PageCount = pageCount; if (lst != null && lst.Count > 0) { model.Users = lst; } model.ButtonsTags = GetVoidHtml(); ViewBag.stype = stype; model.MerchantSearchModel.Sort = sort; model.MerchantSearchModel.SearchKey = key; return(View(model)); }