public ActionResult GetMeasuresPageList(Pagination pagination, string queryJson) { var watch = CommonHelper.TimerStart(); Operator opertator = new OperatorProvider().Current(); var queryParam = queryJson.ToJObject(); if (pagination.p_fields.IsEmpty()) { pagination.p_fields = "worktask,dangerpoint,measures,createuserid,createuserorgcode,createuserdeptcode,isover,remark,remark1"; } pagination.p_kid = "id"; pagination.p_tablename = @"epg_workmeetingmeasures"; pagination.conditionJson = " 1=1 "; if (!queryParam["recid"].IsEmpty()) { pagination.conditionJson += string.Format(@" and workmeetingid ='{0}'", queryParam["recid"].ToString()); } var data = workMeetingbll.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) { string res = json.Value <string>("json"); dynamic dyy = JsonConvert.DeserializeObject <ExpandoObject>(res); string userid = dyy.userid; //获取用户基本信息 OperatorProvider.AppUserId = userid; //设置当前用户 Operator curUser = OperatorProvider.Provider.Current(); if (null == curUser) { return(new { code = -1, count = 0, info = "请求失败,请登录!", data = new object() }); } string roleNames = curUser.RoleName; //分页获取数据 var dy = dyy.data; Pagination pagination = new Pagination(); pagination.page = int.Parse(dy.page ?? "1"); pagination.rows = int.Parse(dy.rows ?? "1"); pagination.p_kid = "a.id"; pagination.p_fields = "a.autoid,a.createdate,a.createuserid,a.createuserdeptcode,a.createuserorgcode,a.modifydate,a.modifyuserid,a.meetingname,a.meetingtype,a.meetingdate,a.shoudpernum,a.realpernum,a.address,b.fullname outprojectname"; pagination.p_tablename = "BIS_WORKMEETING a left join ( select d.FullName,c.ID from EPG_OUTSOURINGENGINEER c, BASE_DEPARTMENT d where c.OUTPROJECTID=d.DEPARTMENTID) b on a.engineerid=b.id"; pagination.sidx = "a.meetingdate"; pagination.sord = "desc"; pagination.conditionJson = " a.iscommit='1' "; if (curUser.IsSystem || curUser.RoleName.Contains("厂级部门用户") || curUser.RoleName.Contains("公司级用户") || curUser.RoleName.Contains("公司管理员")) { pagination.conditionJson += string.Format(" and createuserorgcode = '{0}' ", curUser.OrganizeCode); } else { //发包部门查看所属承包商的开收工会、承包商查看发包部门创建的开收工会。 pagination.conditionJson += string.Format(@" and (engineerid in (select e.ID from EPG_OutSouringEngineer e where e.outprojectid in(select departmentid from base_department where senddeptid='{0}')) or engineerid in (select e.ID from EPG_OutSouringEngineer e where e.outprojectid='{0}') )", curUser.DeptId); } //外包工程 string engineerid = dy.engineerid ?? ""; if (!string.IsNullOrWhiteSpace(engineerid)) { pagination.conditionJson += string.Format(@" and engineerid = '{0}' ", engineerid); } //外包单位 string engineerdeptid = dy.engineerdeptid ?? ""; if (!string.IsNullOrWhiteSpace(engineerdeptid)) { pagination.conditionJson += string.Format(@" and engineerid in (select e.ID from EPG_OutSouringEngineer e where e.outprojectid='{0}') ", engineerdeptid); } //发包部门 string senddeptid = dy.senddeptid ?? ""; if (!string.IsNullOrWhiteSpace(senddeptid) && !curUser.RoleName.Contains("承包商级用户")) { //发包部门下属外包单位的外包工程数据 pagination.conditionJson += string.Format(@" and engineerid in (select e.ID from EPG_OutSouringEngineer e where e.outprojectid in(select departmentid from base_department where senddeptid='{0}')) ", senddeptid); } //开始时间 string startTime = dy.startTime ?? ""; if (!string.IsNullOrWhiteSpace(startTime)) { pagination.conditionJson += string.Format(" and meetingdate >= to_date('{0}','yyyy-mm-dd hh24:mi:ss')", startTime.ToString()); } //结束时间 string endTime = dy.endTime ?? ""; if (!string.IsNullOrWhiteSpace(endTime)) { pagination.conditionJson += string.Format(" and meetingdate < to_date('{0}','yyyy-mm-dd hh24:mi:ss')", DateTime.Parse(endTime.ToString()).AddDays(1).ToString("yyyy-MM-dd")); } //类型 string meetingtype = dy.meetingtype ?? ""; if (!string.IsNullOrWhiteSpace(meetingtype)) { pagination.conditionJson += string.Format(@" and meetingtype = '{0}'", meetingtype); } //会议名称 string meetingname = dy.meetingname ?? ""; if (!string.IsNullOrWhiteSpace(meetingname)) { pagination.conditionJson += string.Format(@" and meetingname like '%{0}%'", meetingname); } var data = workMeetingbll.GetPageList(pagination, null); var JsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, }; JsonSerializerSettings settings = new JsonSerializerSettings { //ContractResolver = new LowercaseContractResolver(dict_props), //转小写,并对指定的列进行自定义名进行更换 DateFormatString = "yyyy-MM-dd HH:mm:ss", //格式化日期 //NullValueHandling = NullValueHandling.Ignore 值为空则在JSON中体现 }; //return Json(new { code = 0, info = "获取数据成功", count = pagination.records, data = JsonData }, new JsonSerializerSettings() { DateFormatString = "yyyy-MM-dd HH:mm:ss" }); return(new { code = 0, info = "获取数据成功", count = pagination.records, data = JObject.Parse(JsonConvert.SerializeObject(JsonData, Formatting.None, settings)) }); }