/// <summary> /// 获取列表 /// </summary> /// <param name="pagination">分页参数</param> /// <param name="queryJson">查询参数</param> /// <returns>返回分页列表Json</returns> //[HandlerMonitor(3, "分页查询用户信息!")] public ActionResult GetPageListJson(Pagination pagination, string queryJson) { queryJson = queryJson ?? ""; pagination.p_kid = "t.Id"; pagination.p_fields = "t.EngineerId,t.CREATEUSERID,t.CREATEUSERDEPTCODE,t.CREATEUSERORGCODE,t.CREATEDATE,t.CREATEUSERNAME,o.engineerletdept,o.engineername,p.outsourcingname,t.FLOWNAME,t.FLOWROLE,t.FLOWROLENAME,t.FLOWDEPT,t.FLOWDEPTNAME,t.ISSAVED,t.ISOVER,t.FlowId"; pagination.p_tablename = "EPG_SAFETYCOLLECT t left join EPG_OUTSOURINGENGINEER o on t.engineerid=o.id left join EPG_OUTSOURCINGPROJECT p on o.outprojectid=p.outprojectid"; //pagination.conditionJson = "1=1"; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); string role = user.RoleName; string allrangedept = ""; try { allrangedept = dataitemdetailbll.GetDataItemByDetailCode("SBDept", "SBDeptId").FirstOrDefault().ItemValue; } catch (Exception) { } if (role.Contains("省级")) { pagination.conditionJson = string.Format(@" t.createuserorgcode in (select encode from BASE_DEPARTMENT d where d.deptcode like '{0}%' and d.nature = '厂级' and d.description is null)", user.NewDeptCode); } else if (role.Contains("公司级用户") || role.Contains("厂级部门用户") || allrangedept.Contains(user.DeptId)) { pagination.conditionJson = string.Format(" t.createuserorgcode = '{0}'", user.OrganizeCode); } else if (role.Contains("承包商级用户")) { pagination.conditionJson = string.Format(" (o.outprojectid ='{0}' or o.supervisorid='{0}' or t.createuserid = '{1}')", user.DeptId, user.UserId); } else { var deptentity = departmentbll.GetEntity(user.DeptId); while (deptentity.Nature == "班组" || deptentity.Nature == "专业") { deptentity = departmentbll.GetEntity(deptentity.ParentId); } pagination.conditionJson = string.Format(" o.engineerletdeptid in (select departmentid from base_department where encode like '{0}%') ", deptentity.EnCode); } var watch = CommonHelper.TimerStart(); var data = SafetyCollectbll.GetPageList(pagination, queryJson); var JsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(Content(JsonData.ToJson())); }
public ActionResult GetPageListJson(Pagination pagination, string queryJson) { try { var watch = CommonHelper.TimerStart(); pagination.p_kid = "t.id"; pagination.p_fields = @"t.outengineerid,e.engineername,e.engineerareaname as districtname,d.itemname engineertype,l.itemname engineerlevel, e.id eid,t.issaveorcommit,t.nextcheckrolename, p.outprojectid,t.isauditover,t.nextcheckdeptid,e.engineerarea, p.outsourcingname,e.engineerstate, t.createusername, t.createdate,t.createuserorgcode,t.flowid, t.createuserid,e.engineerletdept,e.engineerletdeptid,'' as approveuserids "; pagination.p_tablename = @" epg_aptitudeinvestigateinfo t left join epg_outsouringengineer e on e.id = t.outengineerid left join epg_outsourcingproject p on p.outprojectid = t.outprojectid left join base_department b on b.departmentid = t.outprojectid left join ( select m.itemname,m.itemvalue from base_dataitem t left join base_dataitemdetail m on m.itemid=t.itemid where t.itemcode='ProjectType') d on d.itemvalue=e.engineertype left join ( select m.itemname,m.itemvalue from base_dataitem t left join base_dataitemdetail m on m.itemid=t.itemid where t.itemcode='ProjectLevel') l on l.itemvalue=e.engineerlevel left join ( select m.itemname,m.itemvalue from base_dataitem t left join base_dataitemdetail m on m.itemid=t.itemid where t.itemcode='OutProjectState') s on s.itemvalue=e.engineerstate"; pagination.sidx = "t.createdate";//排序字段 pagination.sord = "desc";//排序方式 Operator currUser = OperatorProvider.Provider.Current(); string allrangedept = ""; try { allrangedept = dataitemdetailbll.GetDataItemByDetailCode("SBDept", "SBDeptId").FirstOrDefault().ItemValue; } catch (Exception) { } if (currUser.IsSystem) { pagination.conditionJson = " 1=1 "; } else if (currUser.RoleName.Contains("省级")) { pagination.conditionJson = string.Format(@" t.createuserorgcode in (select encode from BASE_DEPARTMENT d where d.deptcode like '{0}%' and d.nature = '厂级' and d.description is null)", currUser.NewDeptCode); } else if (currUser.RoleName.Contains("厂级部门用户") || currUser.RoleName.Contains("公司级用户") || allrangedept.Contains(currUser.DeptId)) { pagination.conditionJson = string.Format(" (t.issaveorcommit='1' or t.createuserid='{0}') ", currUser.UserId); } else if (currUser.RoleName.Contains("承包商级用户")) { pagination.conditionJson = string.Format(" ( e.outprojectid ='{0}' or e.supervisorid='{0}' or t.createuserid='{1}') ", currUser.DeptId, currUser.UserId); } else { var deptentity = departmentbll.GetEntity(currUser.DeptId); while (deptentity.Nature == "班组" || deptentity.Nature == "专业") { deptentity = departmentbll.GetEntity(deptentity.ParentId); } pagination.conditionJson = string.Format(" (e.engineerletdeptid in (select departmentid from base_department where encode like '{0}%') and t.issaveorcommit='1' or t.createuserid='{1}') ", deptentity.EnCode, currUser.UserId); } //pagination.conditionJson += string.Format(" or t.createuserid='{0}' ", currUser.UserId); var data = aptitudeinvestigateinfobll.GetPageList(pagination, queryJson); for (int i = 0; i < data.Rows.Count; i++) { var engineerEntity = Outsouringengineernll.GetEntity(data.Rows[i]["outengineerid"].ToString()); var excutdept = departmentbll.GetEntity(engineerEntity.ENGINEERLETDEPTID).DepartmentId; var outengineerdept = departmentbll.GetEntity(engineerEntity.OUTPROJECTID).DepartmentId; var supervisordept = string.IsNullOrEmpty(engineerEntity.SupervisorId) ? "" : departmentbll.GetEntity(engineerEntity.SupervisorId).DepartmentId; //获取下一步审核人 string str = manypowercheckbll.GetApproveUserId(data.Rows[i]["flowid"].ToString(), data.Rows[i]["outengineerid"].ToString(), "", "", excutdept, outengineerdept, "", "", "", supervisordept, data.Rows[i]["outengineerid"].ToString()); data.Rows[i]["approveuserids"] = str; } var jsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return ToJsonResult(jsonData); } catch (System.Exception ex) { return Error(ex.ToString()); } }
public ActionResult GetIntromissionList(Pagination pagination, string queryJson) { pagination.p_kid = "a.id"; pagination.p_fields = @"a.createuserid,a.createdate, a.applypeople,a.applytime, a.investigatestate,a.outengineerid,b.engineername,c.fullname, a.flowdeptname,a.flowdept,a.flowrolename,a.flowrole,a.flowname,a.flowid, b.engineerareaname as districtname,d.itemname engineertype,l.itemname engineerlevel,b.engineerletdept,b.engineerletdeptid,'' as approveuserids"; pagination.p_tablename = @" epg_intromission a left join epg_outsouringengineer b on a.outengineerid = b.id left join base_department c on b.outprojectid=c.departmentid left join ( select m.itemname,m.itemvalue from base_dataitem t left join base_dataitemdetail m on m.itemid=t.itemid where t.itemcode='ProjectType') d on d.itemvalue=b.engineertype left join ( select m.itemname,m.itemvalue from base_dataitem t left join base_dataitemdetail m on m.itemid=t.itemid where t.itemcode='ProjectLevel') l on l.itemvalue=b.engineerlevel left join ( select m.itemname,m.itemvalue from base_dataitem t left join base_dataitemdetail m on m.itemid=t.itemid where t.itemcode='OutProjectState') s on s.itemvalue=b.engineerstate "; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); string role = user.RoleName; string allrangedept = ""; try { allrangedept = dataitemdetailbll.GetDataItemByDetailCode("SBDept", "SBDeptId").FirstOrDefault().ItemValue; } catch (Exception) { } //公用下不显示登记 pagination.conditionJson = "(( a.investigatestate !='0' and "; if (role.Contains("公司级用户") || role.Contains("厂级部门用户") || allrangedept.Contains(user.DeptId)) { pagination.conditionJson += string.Format(" a.createuserorgcode = '{0}'", user.OrganizeCode); } else if (role.Contains("承包商级用户")) { pagination.conditionJson += string.Format("( c.departmentid = '{0}' or b.supervisorid ='{0}')", user.DeptId); } else { var deptentity = departmentbll.GetEntity(user.DeptId); while (deptentity.Nature == "班组" || deptentity.Nature == "专业") { deptentity = departmentbll.GetEntity(deptentity.ParentId); } pagination.conditionJson += string.Format(" b.engineerletdeptid in (select departmentid from base_department where encode like '{0}%') ", deptentity.EnCode); // pagination.conditionJson += string.Format(" b.engineerletdeptid = '{0}'", user.DeptId); } pagination.conditionJson += string.Format(" ) or (a.investigatestate ='0' and a.createuserid = '{0}'))", user.UserId); var watch = CommonHelper.TimerStart(); var data = intromissionbll.GetIntromissionPageList(pagination, queryJson); for (int i = 0; i < data.Rows.Count; i++) { var engineerEntity = Outsouringengineernll.GetEntity(data.Rows[i]["outengineerid"].ToString()); var excutdept = departmentbll.GetEntity(engineerEntity.ENGINEERLETDEPTID).DepartmentId; var outengineerdept = departmentbll.GetEntity(engineerEntity.OUTPROJECTID).DepartmentId; var supervisordept = string.IsNullOrEmpty(engineerEntity.SupervisorId) ? "" : departmentbll.GetEntity(engineerEntity.SupervisorId).DepartmentId; //获取下一步审核人 string str = manypowercheckbll.GetApproveUserId(data.Rows[i]["flowid"].ToString(), data.Rows[i]["outengineerid"].ToString(), "", "", excutdept, outengineerdept, "", "", "", supervisordept, data.Rows[i]["outengineerid"].ToString()); data.Rows[i]["approveuserids"] = str; } var jsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(ToJsonResult(jsonData)); }