public ActionResult GetPageListJson(Pagination pagination, string queryJson) { Operator user = OperatorProvider.Provider.Current(); var watch = CommonHelper.TimerStart(); pagination.p_kid = "id"; pagination.p_fields = "examinecode,examinetype,examinetodept,examinemoney,examineperson,remark,flowdept,flowrolename,createuserid,createuserdeptcode,createuserorgcode,issaved,isover,examinecontent"; pagination.p_tablename = " epg_dailyexamine"; pagination.conditionJson = "1=1"; //pagination.sidx = "createdate"; //pagination.sord = "desc"; if (!user.IsSystem) { pagination.conditionJson += " and createuserorgcode='" + user.OrganizeCode + "'"; } var data = dailyexaminebll.GetPageList(pagination, queryJson); var jsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(ToJsonResult(jsonData)); }
public object GetList([FromBody] JObject json) { try { string res = json.Value <string>("json"); dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res); string userId = dy.userid; string actiontype = dy.data.actiontype;//0全部 1 我的 2 待审核 long pageIndex = dy.pageindex; long pageSize = dy.pagesize; string examinetodept = res.Contains("examinetodept") ? dy.data.examinetodept : ""; string startdate = res.Contains("startdate") ? dy.data.startdate : ""; string enddate = res.Contains("enddate") ? dy.data.enddate : ""; string examinetype = res.Contains("examinetype") ? dy.data.examinetype : ""; //获取用户基本信息 OperatorProvider.AppUserId = userId; //设置当前用户 Pagination pagination = new Pagination(); pagination.page = int.Parse(pageIndex.ToString()); pagination.rows = int.Parse(pageSize.ToString()); pagination.p_kid = "id"; pagination.p_fields = @"examinetodept,examineperson,to_char(examinetime,'yyyy-mm-dd') examinetime,flowrolename,flowdept,'' as approveuserid,'' as approveusername, case when isover='1' then '1' when isover ='0' and issaved='1' then '2' when isover='0' and issaved ='0' then '0' end status, case when isover='1' then '审核完成' when isover ='0' and issaved='1' then '待审核' when isover='0' and issaved ='0' then '待提交' end statusinfo"; pagination.p_tablename = "epg_dailyexamine "; pagination.sidx = "createdate"; //排序字段 pagination.sord = "desc"; //排序方式 Operator currUser = OperatorProvider.Provider.Current(); pagination.conditionJson += "1=1 "; string role = currUser.RoleName; if (actiontype == "0") { if (currUser.IsSystem) { } else { pagination.conditionJson += " and createuserorgcode ='" + currUser.OrganizeCode + "'"; } //(s.issaved = '0' and s.createuserid ='{0}') pagination.conditionJson += " and issaved = '1'"; } else if (actiontype == "1") { //查询我的 pagination.conditionJson += string.Format(" and ((flowdept ='{0}'", currUser.DeptId); string[] arr = currUser.RoleName.Split(','); if (arr.Length > 0) { pagination.conditionJson += " and ("; foreach (var item in arr) { pagination.conditionJson += string.Format(" flowrolename like '%{0}%' or", item); } pagination.conditionJson = pagination.conditionJson.Substring(0, pagination.conditionJson.Length - 2); pagination.conditionJson += " )"; } pagination.conditionJson += string.Format(") or (issaved = '0' and createuserid ='{0}'))", currUser.UserId); } else if (actiontype == "2")//待我审核审批 { //查询我的 pagination.conditionJson += string.Format(" and ((flowdept ='{0}'", currUser.DeptId); string[] arr = currUser.RoleName.Split(','); if (arr.Length > 0) { pagination.conditionJson += " and ("; foreach (var item in arr) { pagination.conditionJson += string.Format(" flowrolename like '%{0}%' or", item); } pagination.conditionJson = pagination.conditionJson.Substring(0, pagination.conditionJson.Length - 2); pagination.conditionJson += " )"; } pagination.conditionJson += string.Format(") and isover='0' and issaved='1')"); } if (!string.IsNullOrEmpty(startdate)) { pagination.conditionJson += string.Format(" and examinetime>= to_date('{0}','yyyy-MM-dd') ", startdate); } if (!string.IsNullOrEmpty(enddate)) { pagination.conditionJson += string.Format(" and examinetime<= to_date('{0}','yyyy-MM-dd') ", Convert.ToDateTime(enddate).AddDays(1).ToString("yyyy-MM-dd")); } if (!string.IsNullOrEmpty(examinetodept)) { pagination.conditionJson += string.Format(" and examinetodeptid = '{0}' ", examinetodept); } if (!string.IsNullOrEmpty(examinetype)) { pagination.conditionJson += string.Format(" and examinetype like '%{0}%' ", examinetype); } string queryJson = Newtonsoft.Json.JsonConvert.SerializeObject(new { }); var data = dailyexaminebll.GetPageList(pagination, queryJson); foreach (DataRow row in data.Rows) { string str = new ScaffoldBLL().GetUserName(row["flowdept"].ToString(), row["flowrolename"].ToString(), "0"); row["approveuserid"] = str.Split('|')[1]; row["approveusername"] = str.Split('|')[0]; } return(new { Code = 0, Count = pagination.records, Info = "获取数据成功", data = data }); } catch (Exception ex) { return(new { Code = -1, Count = 0, Info = ex.Message }); } }