/// <summary> /// 获取操作记录列表 /// </summary> /// <param name="req"></param> /// <returns></returns> public string GetOperRecordList(OperRecordReq req) { var user = JsonConvert.DeserializeObject <AllInOne_UserInfo>(Session["user"].ToString()); var r = AllFunc.Instance.GetOperRecordList(req, user); return(JsonConvert.SerializeObject(r)); }
/// <summary> /// 获取区域列表 /// </summary> /// <param name="req"></param> /// <param name="size"></param> /// <returns></returns> public List <AllInOne_OperateRecordView> GetList(OperRecordReq req, int size, AllInOne_UserInfo user) { var lastCId = AllInOne_UserInfoOper.Instance.GetLastCId(user); 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}%" }, { "@lastcid", lastCId }, }; var condition = " 1=1 and (cid1=@lastcid or cid2=@lastcid or cid3=@lastcid or cid4=@lastcid) "; if (!search.IsNullOrEmpty()) { condition += " and (operatorName like @search or content like @search)"; } return(SqlHelper.Instance.GetViewPaging <AllInOne_OperateRecordView>("AllInOne_OperateRecordView", "select * from AllInOne_OperateRecordView ", condition, index, size, orderStr, dict)); }
/// <summary> /// 获取区域列表总数 /// </summary> /// <param name="req"></param> /// <returns></returns> public int GetCount(OperRecordReq req, AllInOne_UserInfo user) { var lastCId = AllInOne_UserInfoOper.Instance.GetLastCId(user);//-txy 迷 var search = req.search ?? ""; var dict = new Dictionary <string, string> { { "@search", $"%{search}%" }, { "@lastcid", lastCId }, }; var condition = " 1=1 and (cid1=@lastcid or cid2=@lastcid or cid3=@lastcid or cid4=@lastcid) "; if (!search.IsNullOrEmpty()) { condition += " and (operatorName like @search or content like @search)"; } var list = SqlHelper.Instance.GetDistinctCount <AllInOne_OperateRecordView>("AllInOne_OperateRecordView", condition, dict); return(list.Count); }