/// <summary> /// 获取区域列表 /// </summary> /// <param name="req"></param> /// <param name="size"></param> /// <returns></returns> public List <AllInOne_AreaInfo> GetList(AreaReq req, int size, int userId, int lv) { var search = req.search ?? ""; var order = req.orderField; var desc = Convert.ToBoolean(req.isDesc); var index = Convert.ToInt32(req.pageIndex); //var size = 5; var orderStr = $"order by {order} "; if (desc) { orderStr += " desc "; } else { orderStr += " asc "; } var dict = new Dictionary <string, string> { { "@search", $"%{search}%" } }; var condition = " isDeleted=0 "; if (lv != 100) { condition += $" and createUserId={userId}"; } if (!search.IsNullOrEmpty()) { condition += " and name like @search "; } return(SqlHelper.Instance.GetViewPaging <AllInOne_AreaInfo>("AllInOne_AreaInfo", "select * from AllInOne_AreaInfo ", condition, index, size, orderStr, dict)); }
public string GetAreaList(AreaReq req) { var userId = Convert.ToInt32(Session["userId"]); var lv = Convert.ToInt32(Session["lv"]); var r = AllFunc.Instance.GetAreaList(req, userId, lv); return(JsonConvert.SerializeObject(r)); }
/// <summary> /// 获取区域列表总数 /// </summary> /// <param name="req"></param> /// <returns></returns> public int GetCount(AreaReq req, int userId, int lv) { var search = req.search ?? ""; var dict = new Dictionary <string, string> { { "@search", $"%{search}%" } }; var condition = " isDeleted=0 "; if (lv != 100) { condition += $" and createUserId={userId}"; } if (!search.IsNullOrEmpty()) { condition += " and name like @search "; } var list = SqlHelper.Instance.GetDistinctCount <AllInOne_AreaInfo>("AllInOne_AreaInfo", condition, dict); return(list.Count); }