public ActionResult UserList() { List <JMP.MDL.jmp_user> list = new List <JMP.MDL.jmp_user>(); JMP.BLL.jmp_user bll = new JMP.BLL.jmp_user(); #region 初始化 //获取请求参数 int pageCount = 0; int pageIndexs = string.IsNullOrEmpty(Request["curr"]) ? 1 : Int32.Parse(Request["curr"]); //当前页 int PageSize = string.IsNullOrEmpty(Request["psize"]) ? 20 : Int32.Parse(Request["psize"]); //每页显示数量 string type = string.IsNullOrEmpty(Request["stype"]) ? "0" : Request["stype"]; //查询条件类型 string sea_name = string.IsNullOrEmpty(Request["skeys"]) ? "" : Request["skeys"]; //查询条件值 string category = string.IsNullOrEmpty(Request["scategory"]) ? "" : Request["scategory"]; //认证类型 int px = string.IsNullOrEmpty(Request["s_sort"]) ? 0 : Int32.Parse(Request["s_sort"]); //排序 //获取用户列表 string where = " where 1=1 and u_auditstate='1' and u_state='1' "; if (!string.IsNullOrEmpty(type.ToString())) { if (!string.IsNullOrEmpty(sea_name)) { if (type == "0") { where += string.Format(" and u_email like '%{0}%'", sea_name); } else if (type == "1") { where += string.Format(" and u_phone like '%{0}%'", sea_name); } else if (type == "3") { where += string.Format(" and u_idnumber like '%{0}%'", sea_name); } else if (type == "6") { where += string.Format(" and u_blicensenumber like '%{0}%'", sea_name); } } } if (!string.IsNullOrEmpty(category)) { where += string.Format(" and u_category={0}", category); } string Order = " order by u_id " + (px == 0 ? "" : " desc ") + " "; string query = "select * from jmp_user" + where; list = bll.GetLists(query, Order, pageIndexs, PageSize, out pageCount); //返回 ViewBag.CurrPage = pageIndexs; ViewBag.PageSize = PageSize; ViewBag.PageCount = pageCount; ViewBag.stype = type; ViewBag.skeys = sea_name; ViewBag.scategory = category; ViewBag.s_sort = px; ViewBag.list = list; #endregion return(View()); }
/// <summary> /// 开发者直客管理 /// </summary> /// <returns></returns> public ActionResult userList() { #region 初始化 //获取请求参数 int pageCount = 0; int pageIndexs = string.IsNullOrEmpty(Request["curr"]) ? 1 : Int32.Parse(Request["curr"]); //当前页 int PageSize = string.IsNullOrEmpty(Request["psize"]) ? 20 : Int32.Parse(Request["psize"]); //每页显示数量 string type = string.IsNullOrEmpty(Request["stype"]) ? "5" : Request["stype"]; //查询条件类型 string sea_name = string.IsNullOrEmpty(Request["skeys"]) ? "" : Request["skeys"]; //查询条件值 string category = string.IsNullOrEmpty(Request["scategory"]) ? "" : Request["scategory"]; //认证类型 int px = string.IsNullOrEmpty(Request["s_sort"]) ? 0 : Int32.Parse(Request["s_sort"]); //排序 //获取用户列表 //查询已通过审核,账户状态正常,所属关系为商务的直客开发者 string where = " where 1=1 and u_auditstate='1' and u_state='1' and relation_type='1' "; //关联人的ID,比如商务ID,代理商ID //where += " and relation_person_id='"+id+"'"; if (!string.IsNullOrEmpty(type.ToString())) { if (!string.IsNullOrEmpty(sea_name)) { switch (type) { case "0": where += string.Format(" and u_email like '%{0}%'", sea_name); break; case "1": where += string.Format(" and u_phone like '%{0}%'", sea_name); break; case "3": where += string.Format(" and u_idnumber like '%{0}%'", sea_name); break; case "6": where += string.Format(" and u_blicensenumber like '%{0}%'", sea_name); break; case "5": where += string.Format(" and u_realname like '%{0}%'", sea_name); break; } } } if (!string.IsNullOrEmpty(category)) { where += string.Format(" and u_category={0}", category); } string Order = " order by u_id " + (px == 0 ? "" : " desc ") + " "; string query = "select a.*,b.DisplayName,c.[Name] from jmp_user a left join CoBusinessPersonnel b on a.relation_person_id = b.Id left join CoServiceFeeRatioGrade c on a.ServiceFeeRatioGradeId = c.Id" + where; listUser = bllUser.GetLists(query, Order, pageIndexs, PageSize, out pageCount); //返回 ViewBag.CurrPage = pageIndexs; ViewBag.PageSize = PageSize; ViewBag.PageCount = pageCount; ViewBag.stype = type; ViewBag.skeys = sea_name; ViewBag.scategory = category; ViewBag.s_sort = px; ViewBag.list = listUser; #endregion return(View()); }