public ActionResult GetListJson(Pagination pagination, string queryJson) { pagination.p_kid = "t.ID"; pagination.p_fields = @"e.departmentid,t.engineername,e.fullname,t.planenddate,t.actualenddate,t.createuserorgcode"; pagination.p_tablename = @" epg_outsouringengineer t left join base_department e on t.outprojectid=e.departmentid"; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); string role = user.RoleName; 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("厂级部门用户")) { pagination.conditionJson = string.Format(" t.createuserorgcode = '{0}'", user.OrganizeCode); } else { pagination.conditionJson = string.Format(" t.engineerletdeptid = '{0}'", user.DeptId); } var queryParam = queryJson.ToJObject(); //查询条件 if (!queryParam["txtSearch"].IsEmpty()) { pagination.conditionJson += string.Format(" and t.engineername like '%{0}%'", queryParam["txtSearch"].ToString()); } var watch = CommonHelper.TimerStart(); var data = protocolbll.GetList(pagination, queryJson); var jsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(ToJsonResult(jsonData)); }
public ActionResult GetListJson(Pagination pagination, string queryJson) { pagination.p_kid = "t.ID"; pagination.p_fields = @" e.fullname,r.ENGINEERNAME,t.FirstParty,t.SecondParty,t.SignPlace,to_char(SignDate,'yyyy-MM-dd') as SignDate,r.outprojectid,e.senddeptid,t.MODIFYUSERID,t.createuserid,t.createuserorgcode "; pagination.p_tablename = @"epg_protocol t left join EPG_OutSouringEngineer r on t.projectid=r.id left join base_department e on r.outprojectid=e.departmentid "; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); string role = user.RoleName; 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("厂级部门用户")) { pagination.conditionJson = string.Format(" t.CREATEUSERORGCODE = '{0}'", user.OrganizeCode); } else if (role.Contains("承包商级用户")) { pagination.conditionJson = string.Format(" (e.departmentid = '{0}' or r.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(" r.engineerletdeptid in (select departmentid from base_department where encode like '{0}%') ", deptentity.EnCode); //pagination.conditionJson = string.Format(" r.engineerletdeptid = '{0}'", user.DeptId); } var queryParam = queryJson.ToJObject(); //时间范围 if (!queryParam["sTime"].IsEmpty() || !queryParam["eTime"].IsEmpty()) { string startTime = queryParam["sTime"].ToString(); string endTime = queryParam["eTime"].ToString(); if (queryParam["sTime"].IsEmpty()) { startTime = "1899-01-01"; } if (queryParam["eTime"].IsEmpty()) { endTime = DateTime.Now.ToString("yyyy-MM-dd"); } pagination.conditionJson += string.Format(" and to_date(to_char(SignDate,'yyyy-MM-dd'),'yyyy-MM-dd') between to_date('{0}','yyyy-MM-dd') and to_date('{1}','yyyy-MM-dd')", startTime, endTime); } ////查询条件 //if (!queryParam["txtSearch"].IsEmpty()) //{ // pagination.conditionJson += string.Format(" and r.ENGINEERNAME like '%{0}%'", queryParam["txtSearch"].ToString()); //} //查询条件 if (!queryParam["condition"].IsEmpty() && !queryParam["txtSearch"].IsEmpty()) { pagination.conditionJson += string.Format(" and {0} like '%{1}%'", queryParam["condition"].ToString(), queryParam["txtSearch"].ToString()); } if (!queryParam["outengineerid"].IsEmpty()) { pagination.conditionJson += string.Format(" and t.projectid ='{0}' ", queryParam["outengineerid"].ToString()); } if (!queryParam["orgCode"].IsEmpty()) { pagination.conditionJson += string.Format(" and t.createuserorgcode ='{0}' ", queryParam["orgCode"].ToString()); } if (!queryParam["projectid"].IsEmpty()) { pagination.conditionJson += string.Format(" and r.id ='{0}' ", queryParam["projectid"].ToString()); } var watch = CommonHelper.TimerStart(); var data = protocolbll.GetList(pagination, queryJson); var jsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(ToJsonResult(jsonData)); }