/// <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 = "ID"; pagination.p_fields = "createuserid,createuserdeptcode,createuserorgcode, Files,Name,PLANTYPENAME,ISAUDITNAME,DATATIME_BZ,DEPARTNAME_BZ,CREATEUSERNAME,USERID_BZ,DEPARTID_BZ,USERNAME_BZ,FILEPS,PLANTYPE"; pagination.p_tablename = "(select * from MAE_RESERVERPLAN order by CREATEDATE,DATATIME_BZ) t"; pagination.conditionJson = "1=1"; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); if (user.IsSystem) { pagination.conditionJson = "1=1"; } else { string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "CREATEUSERDEPTCODE", "CREATEUSERORGCODE"); if (!string.IsNullOrEmpty(where)) { pagination.conditionJson += " and " + where; } } var watch = CommonHelper.TimerStart(); var data = reserverplanbll.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 GetTempConfigPageJson(Pagination pagination, string queryJson) { var watch = CommonHelper.TimerStart(); pagination.p_kid = "id"; pagination.p_fields = @" createuserid,createuserdeptcode,createuserorgcode,createdate,createusername,modulename,modulecode,tempname,proessmode,deptname,deptcode,deptid"; pagination.p_tablename = @" epg_tempmanage t"; Operator currUser = OperatorProvider.Provider.Current(); pagination.conditionJson = string.Format(" 1=1 "); if (!currUser.IsSystem) { //根据当前用户对模块的权限获取记录 string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "createuserdeptcode", "deptcode"); if (!string.IsNullOrEmpty(where)) { pagination.conditionJson += " and " + where; } } var data = tempconfigbll.GetTempConfigPageJson(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) { try { var watch = CommonHelper.TimerStart(); #region 数据权限 Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); //查看范围数据权限 /** * 1.作业单位及子部门(下级) * 2.本人创建的作业 * 3.发包部门管辖的外包单位 * 4.外包单位只能看本单位的 * */ string authType = new AuthorizeBLL().GetOperAuthorzeType(user, HttpContext.Request.Cookies["currentmoduleId"].Value, "search"); #endregion var data = firewaterbll.GetList(pagination, queryJson, authType, user); var jsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(ToJsonResult(jsonData)); } catch (Exception ex) { return(Error(ex.Message)); } }
public ActionResult GetPageListJson(Pagination pagination, string queryJson) { pagination.p_kid = "ID"; pagination.p_fields = @"a.CreateUserId,a.CreateDate,a.CreateUserName,a.ModifyUserId,a.ModifyDate,a.ModifyUserName,a.CreateUserDeptCode,a.CreateUserOrgCode,a.sampleno,b.itemname as sampletype,a.testusername,to_char(testdate,'yyyy-MM-dd')as testdate"; pagination.p_tablename = @"bis_waterquality a left join ( select itemname,itemvalue from base_dataitemdetail where itemid = (select itemid from base_dataitem where itemname = '水质分类' )) b on a.sampletype = b.itemvalue"; //pagination.p_fields = @"a.CreateUserId,a.CreateDate,a.CreateUserName,a.ModifyUserId,a.ModifyDate,a.ModifyUserName,a.CreateUserDeptCode,a.CreateUserOrgCode,sampleno,sampletype,testusername,to_char(testdate,'yyyy-MM-dd') testdate"; //pagination.p_tablename = @"bis_waterquality a "; pagination.conditionJson = "1=1"; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); if (!user.IsSystem) { //根据当前用户对模块的权限获取记录 string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "createuserdeptcode", "createuserorgcode"); if (!string.IsNullOrEmpty(where)) { pagination.conditionJson += " and " + where; } } var watch = CommonHelper.TimerStart(); var data = waterqualitybll.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 ActionResult GetPageListJson(Pagination pagination, string queryJson) { Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); var watch = CommonHelper.TimerStart(); pagination.p_tablename = "BIS_RISKTRAIN"; pagination.p_kid = "id"; pagination.p_fields = @"taskname,worktype,postname,taskcontent,Status,userids,createuserid,workusers,workfzr,workunit,to_char(workstarttime, 'yyyy-MM-dd HH:mm') workstarttime, to_char(workendtime, 'yyyy-MM-dd HH:mm') workendtime,iscommit,workfzrid "; pagination.conditionJson = "(((userids like '%," + user.Account + ",%' and iscommit=1) or (createuserid='" + user.UserId + "') or (workfzrid='" + user.Account + "' and iscommit=1))"; if (!user.IsSystem) { //根据当前用户对模块的权限获取记录 string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "createuserdeptcode", "createuserorgcode"); if (!string.IsNullOrEmpty(where)) { pagination.conditionJson += " or (" + where + " and iscommit=1)"; } } pagination.conditionJson += ")"; var data = risktrainbll.GetPageListJson(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 GetPageListJson(Pagination pagination, string queryJson) { pagination.p_kid = "ID"; pagination.p_fields = @"a.CreateUserId,a.CreateDate,a.CreateUserName,a.ModifyUserId,a.ModifyDate,a.ModifyUserName,a.CreateUserDeptCode,a.CreateUserOrgCode,b.Appraise,b.operuser,Equipmenttype,EquipmentName,EquipmentValue,EquipmentNo,Specifications,outputdeptname,checkdate,NextCheckDate,factorydate,district,districtid,districtcode,depositary,controluserid,controlusername,acceptance,ControlDept,ControlDeptId,ControlDeptCode,belongdept,belongdeptid,belongdeptCode,unit,quantity"; pagination.p_tablename = @"BIS_TOOLEQUIPMENT a left join (select appraise,tb1.toolequipmentid,operuser from BIS_TOOLRECORD tb1 ,(select max(createdate) createdate,toolequipmentid from BIS_TOOLRECORD group by toolequipmentid) tb2 where tb1.createdate= tb2.createdate and tb1.toolequipmentid= tb2.toolequipmentid) b on a.id = b.toolequipmentid"; pagination.conditionJson = "1=1"; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); if (!user.IsSystem) { //根据当前用户对模块的权限获取记录 string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "createuserdeptcode", "createuserorgcode"); if (!string.IsNullOrEmpty(where)) { pagination.conditionJson += " and " + where; } } var watch = CommonHelper.TimerStart(); var data = toolequipmentBll.GetPageList(pagination, queryJson); var jsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(ToJsonResult(jsonData)); }
/// <summary> /// 获取电动工器具检查记录 /// </summary> /// <returns></returns> public ActionResult GetToolRecordList(Pagination pagination, string queryJson) { //var data = toolequipmentBll.GetToolRecordList(keyValue); //return ToJsonResult(data); pagination.p_kid = "id"; pagination.p_fields = @"toolequipmentid,equipmentname,equipmentno,voltagelevel,trialvoltage,checkdate,nextcheckdate,appraise,operuser,specification,checkproject"; pagination.p_tablename = "BIS_TOOLRECORD"; pagination.sidx = "createdate"; pagination.sord = "desc"; pagination.conditionJson = "1=1"; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); if (!user.IsSystem) { //根据当前用户对模块的权限获取记录 string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "createuserdeptcode", "createuserorgcode"); if (!string.IsNullOrEmpty(where)) { pagination.conditionJson += " and " + where; } } var watch = CommonHelper.TimerStart(); var data = toolrecordbll.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 ActionResult GetPageListJson(Pagination pagination, string queryJson) { try { var watch = CommonHelper.TimerStart(); pagination.conditionJson = " 1=1 "; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); string authType = new AuthorizeBLL().GetOperAuthorzeType(user, HttpContext.Request.Cookies["currentmoduleId"].Value, "search"); var data = announcementbll.GetPageList(pagination, queryJson, authType); var jsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(ToJsonResult(jsonData)); } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <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 = "ID"; pagination.p_fields = " reserverplanid,organizecode, ORGANIZEIDNAME,name,reserverplanname"; pagination.p_tablename = "MAE_DRILLPLAN_WW t"; pagination.conditionJson = "1=1"; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); if (user.IsSystem) { pagination.conditionJson = "1=1"; } else { string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "CREATEUSERDEPTCODE", "CREATEUSERORGCODE"); if (!string.IsNullOrEmpty(where)) { pagination.conditionJson += " and " + where; } } var watch = CommonHelper.TimerStart(); var data = drillplan_wwbll.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())); }
/// <summary> /// 获取权限 /// </summary> /// <param name="jsonData"></param> /// <returns></returns> public string GetDataAuthority() { AuthorizeBLL authBLL = new AuthorizeBLL(); string result = authBLL.GetDataAuthority(OperatorProvider.Provider.Current(), Request.Cookies["currentmoduleId"].Value, ""); return(result); }
/// <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 = "ID"; pagination.p_fields = "IsSubmit,CREATEUSERID,WSSJNAME, WSSJTYPENAME,HAPPENTIME,AREANAME,WSSJBGUSERNAME,CREATEUSERDEPTCODE as departmentcode,CREATEUSERORGCODE as organizecode"; pagination.p_tablename = "V_AEM_WSSJBG_Order t"; pagination.conditionJson = "1=1"; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); if (user.IsSystem) { pagination.conditionJson = "1=1"; } else { string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "CREATEUSERDEPTCODE", "CREATEUSERORGCODE"); if (!string.IsNullOrEmpty(where)) { pagination.conditionJson += " and " + where; } } var watch = CommonHelper.TimerStart(); var data = wssjbgbll.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 queryParam = queryJson.ToJObject(); var watch = CommonHelper.TimerStart(); pagination.conditionJson = " 1=1 "; //根据后台配置查看数据权限 string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "createuserdeptcode", "createuserorgcode"); if (!string.IsNullOrEmpty(where)) { pagination.conditionJson += " and " + where; } DataTable dt = safeSummaryBLL.GetList(pagination, queryJson); var jsonData = new { rows = dt, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(ToJsonResult(jsonData)); } catch (Exception ex) { return(Error(ex.Message)); } }
public ActionResult GetPageListJson(Pagination pagination, string queryJson) { pagination.p_kid = "ID"; pagination.p_fields = @"a.CreateUserId,a.CreateDate,a.CreateUserName,a.ModifyUserId,a.ModifyDate,a.ModifyUserName,a.CreateUserDeptCode,a.CreateUserOrgCode,checkuserid,checkusername,to_char(checkdate,'yyyy-MM-dd') checkdate ,zj1,zj2,zj3,zj4,zj5,zj6,yj1,yj2,yj3,yj4,yj5,yj6"; pagination.p_tablename = @"BIS_NoiseCheck a "; pagination.conditionJson = "1=1"; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); if (!user.IsSystem) { //根据当前用户对模块的权限获取记录 string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "createuserdeptcode", "createuserorgcode"); if (!string.IsNullOrEmpty(where)) { pagination.conditionJson += " and " + where; } } var watch = CommonHelper.TimerStart(); var data = noisecheckbll.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 ActionResult GetPageListJson(Pagination pagination, string queryJson) { var watch = CommonHelper.TimerStart(); pagination.p_kid = "t.id as itemid"; pagination.p_fields = "u.realname,u.Gender,u.identifyid,u.DEPTNAME,s.itemname,t.score,s.itemtype,u.OrganizeCode,u.DEPARTMENTCODE,u.realname as username,u.userid,t.createdate,t.createusername,case when s.isauto=0 then '手动积分' else '自动积分' end isauto"; pagination.p_tablename = "BIS_USERSCORE t left join v_userinfo u on t.userid=u.userid left join bis_scoreset s on t.itemid=s.id"; pagination.conditionJson = "1=1"; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); if (user.IsSystem) { pagination.conditionJson = "1=1"; } else { string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "departmentcode", "organizecode"); if (!string.IsNullOrEmpty(where)) { pagination.conditionJson += " and " + where; } } var data = userscorebll.GetPageJsonList(pagination, queryJson); var jsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(ToJsonResult(jsonData)); }
/// <summary> /// 用户列表 /// </summary> /// <param name="pagination">分页参数</param> /// <param name="queryJson">查询参数</param> /// <returns>返回分页列表Json</returns> //[HandlerMonitor(3, "分页查询用户信息!")] public ActionResult GetPageListJsonByRsshsgType(Pagination pagination, string queryJson) { var watch = CommonHelper.TimerStart(); pagination.p_kid = "ID"; pagination.p_fields = "IsSubmit_deal,JJYYNAME,BAQZTNAME,BAQXWNAME,RSSHSGTYPENAME,CREATEUSERID ,sglevelname,SGNAME, SGTYPENAME,HAPPENTIME,AREANAME,SGKBUSERNAME,DEALID,CREATEUSERDEPTCODE as departmentcode,CREATEUSERORGCODE as organizecode"; pagination.p_tablename = "V_AEM_BULLETIN_deal t"; pagination.conditionJson = "(sgTypeName='电力生产人身伤亡事故' or sgTypeName='电力建设人身伤亡事故')"; ERCHTMS.Code.Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); if (user.IsSystem) { pagination.conditionJson = "(sgTypeName='电力生产人身伤亡事故' or sgTypeName='电力建设人身伤亡事故')"; } else { string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "CREATEUSERDEPTCODE", "CREATEUSERORGCODE"); if (!string.IsNullOrEmpty(where)) { pagination.conditionJson += " and " + where; } } pagination.conditionJson += " and IsSubmit_Deal=1"; var data = bulletinbll.GetPageList(pagination, queryJson); var jsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(ToJsonResult(jsonData)); }
/// <summary> /// 伤亡人数人数统计 /// </summary> /// <param name="pagination">分页参数</param> /// <param name="queryJson">查询参数</param> /// <returns>返回分页列表Json</returns> //[HandlerMonitor(3, "分页查询用户信息!")] public ActionResult GetPageListJson(Pagination pagination, string queryJson) { var watch = CommonHelper.TimerStart(); pagination.p_kid = "ID"; pagination.p_fields = "IsSubmit_deal,SGNAME,SGTYPENAME,HAPPENTIME,AREANAME,CreateDate,dealid"; pagination.p_tablename = "V_AEM_BULLETIN_deal"; pagination.conditionJson = "IsSubmit_Deal=1"; ERCHTMS.Code.Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); if (user.IsSystem) { pagination.conditionJson = "1=1"; } else { string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "CREATEUSERDEPTCODE", "CREATEUSERORGCODE"); if (!string.IsNullOrEmpty(where)) { pagination.conditionJson += " and " + where; } } pagination.conditionJson += " and IsSubmit_Deal=1"; var data = bulletinbll.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 GetOperAuthorityType([FromBody] JObject json) { try { string res = json.Value <string>("json"); dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res); string userid = dy.userid; string moduleEncode = dy.data.moduleEncode; string encode = dy.data.encode; //获取用户基本信息 OperatorProvider.AppUserId = userid; //设置当前用户 Operator curUser = OperatorProvider.Provider.Current(); if (null == curUser) { return(new { code = -1, count = 0, info = "请求失败,请登录!", data = new object() }); } string authority = new AuthorizeBLL().GetOperAuthorzeTypeEncode(curUser, moduleEncode, encode); return(new { code = 0, info = "获取数据成功", count = 0, data = authority }); } catch (Exception ex) { return(new { code = -1, count = 0, info = "获取失败,错误:" + ex.Message, data = new object() }); } }
public ActionResult GetPageListJson(Pagination pagination, string queryJson) { Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); var watch = CommonHelper.TimerStart(); pagination.p_tablename = "bis_risktrainlib"; pagination.p_kid = "id"; pagination.p_fields = @"worktask,worktype,workpost,workarea,workareaid,workdes,usernum,modifynum, resources,createusername,createdate,createuserdeptcode,createuserorgcode,createuserid,worktypecode,risklevel,risklevelval"; pagination.conditionJson = "1=1"; if (!user.IsSystem) { //根据当前用户对模块的权限获取记录 string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "createuserdeptcode", "createuserorgcode"); if (!string.IsNullOrEmpty(where)) { pagination.conditionJson += " and " + where; } } var data = risktrainlibbll.GetPageListJson(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 GetPageListJson(Pagination pagination, string queryJson) { var watch = CommonHelper.TimerStart(); pagination.conditionJson = "1=1"; #region 数据权限 Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); //查看范围数据权限 /** * */ string authType = new AuthorizeBLL().GetOperAuthorzeType(user, HttpContext.Request.Cookies["currentmoduleId"].Value, "search"); #endregion var data = writtenworkbll.GetPageDataTable(pagination, queryJson, authType); var jsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(ToJsonResult(jsonData)); }
public ActionResult GetPageListJson(Pagination pagination, string queryJson) { pagination.p_kid = "ID"; pagination.p_fields = @"a.CreateUserId,a.CreateDate,a.CreateUserName,a.ModifyUserId,a.ModifyDate,a.ModifyUserName,a.CreateUserDeptCode,a.CreateUserOrgCode,a.WEATHER,a.REQUIRE,a.INITIATEMODE"; pagination.p_tablename = @"BIS_WEATHER a"; pagination.conditionJson = "1=1"; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); if (!user.IsSystem) { //根据当前用户对模块的权限获取记录 string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "createuserdeptcode", "createuserorgcode"); if (!string.IsNullOrEmpty(where)) { pagination.conditionJson += " and " + where; } } var watch = CommonHelper.TimerStart(); var data = weatherbll.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 ActionResult GetLeaveApproveList(Pagination pagination, string queryJson) { pagination.conditionJson = " 1=1 "; var queryParam = queryJson.ToJObject(); //根据后台配置查看数据权限 string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "createuserdeptcode", "createuserorgcode"); if (!string.IsNullOrEmpty(where)) { pagination.conditionJson += " and " + where; } var watch = CommonHelper.TimerStart(); var dt = leaveApproveBLL.GetLeaveApproveList(pagination, queryJson); string str = string.Empty; foreach (DataRow row in dt.Rows) { str = manypowercheckbll.GetApproveUserAccount(row["flowid"].ToString(), row["id"].ToString(), "", "", row["LeaveDeptId"].ToString()); //获取审核人账号 row["approveuseraccount"] = str; } var jsonData = new { rows = dt, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(ToJsonResult(jsonData)); }
public ActionResult Export(string queryJson) { Pagination pagination = new Pagination(); queryJson = queryJson ?? ""; pagination.page = 1; pagination.rows = 100000000; pagination.p_kid = "id"; pagination.p_fields = "REALNAME,GENDER,identifyid,DEPTNAME,jointime,reason"; pagination.p_tablename = "bis_blacklist a left join v_userinfo u on a.userid=u.userid"; pagination.conditionJson = "isblack=1"; string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "DEPARTMENTCODE", "OrganizeCode"); pagination.conditionJson = string.IsNullOrEmpty(where) ? pagination.conditionJson : pagination.conditionJson + " and " + where; var watch = CommonHelper.TimerStart(); var data = new UserBLL().GetPageList(pagination, queryJson); //设置导出格式 ExcelConfig excelconfig = new ExcelConfig(); excelconfig.Title = "人员黑名单"; excelconfig.TitleFont = "微软雅黑"; excelconfig.TitlePoint = 25; excelconfig.FileName = "人员黑名单.xls"; excelconfig.IsAllSizeColumn = true; //每一列的设置,没有设置的列信息,系统将按datatable中的列名导出 List <ColumnEntity> listColumnEntity = new List <ColumnEntity>(); ColumnEntity columnentity = new ColumnEntity(); listColumnEntity.Add(new ColumnEntity() { Column = "REALNAME".ToLower(), ExcelColumn = "姓名", Alignment = "Center" }); listColumnEntity.Add(new ColumnEntity() { Column = "GENDER".ToLower(), ExcelColumn = "性别", Alignment = "Center" }); listColumnEntity.Add(new ColumnEntity() { Column = "identifyid".ToLower(), ExcelColumn = "身份证号", Alignment = "Center" }); listColumnEntity.Add(new ColumnEntity() { Column = "DEPTNAME".ToLower(), ExcelColumn = "单位/部门", Alignment = "Center" }); listColumnEntity.Add(new ColumnEntity() { Column = "jointime".ToLower(), ExcelColumn = "加入黑名单时间", Alignment = "Center" }); listColumnEntity.Add(new ColumnEntity() { Column = "reason".ToLower(), ExcelColumn = "加入黑名单原因", Alignment = "Center" }); excelconfig.ColumnEntity = listColumnEntity; //调用导出方法 ExcelHelper.ExcelDownload(data, excelconfig); return(Success("导出成功。")); }
public ActionResult exportExcelData(string condition, string queryJson) { Pagination pagination = new Pagination(); queryJson = queryJson ?? ""; pagination.page = 1; pagination.rows = 100000000; pagination.p_fields = @"a.WEATHER,a.REQUIRE, case when a.INITIATEMODE ='1' then '是' else '否' end INITIATEMODE"; pagination.p_tablename = @"BIS_WEATHER a"; pagination.sord = "CreateDate"; #region 权限校验 pagination.conditionJson = "1=1"; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); if (user.IsSystem) { pagination.conditionJson = "1=1"; } else { string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "CREATEUSERDEPTCODE", "CREATEUSERORGCODE"); if (!string.IsNullOrEmpty(where)) { pagination.conditionJson += " and " + where; } } #endregion var data = weatherbll.GetPageList(pagination, queryJson); ////设置导出格式 ExcelConfig excelconfig = new ExcelConfig(); excelconfig.Title = "天气预警"; excelconfig.TitleFont = "微软雅黑"; excelconfig.TitlePoint = 25; excelconfig.FileName = "天气预警" + ".xls"; excelconfig.IsAllSizeColumn = true; //每一列的设置,没有设置的列信息,系统将按datatable中的列名导出 excelconfig.ColumnEntity = new List <ColumnEntity>(); excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "weather".ToLower(), ExcelColumn = "天气" }); excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "require".ToLower(), ExcelColumn = "作业要求" }); excelconfig.ColumnEntity.Add(new ColumnEntity() { Column = "initiatemode".ToLower(), ExcelColumn = "是否启用" }); //调用导出方法 //ExcelHelper.ExcelDownload(data, excelconfig); //return Success("导出成功。"); //设置导出格式 //调用导出方法 ExcelHelper.ExportByAspose(data, excelconfig.FileName, excelconfig.ColumnEntity); return(Success("导出成功。")); }
public object getRiskIdentifyList([FromBody] JObject json) { try { string res = json.Value <string>("json"); dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res); string userId = dy.userid; //获取用户基本信息 OperatorProvider.AppUserId = userId; //设置当前用户 Operator user = OperatorProvider.Provider.Current(); long mode = dy.data.mode; string sql = "deptcode like '" + user.OrganizeCode + "%'"; //当前用户辨识的数据 if (mode == 0) { sql += string.Format(" and status=0 and id in(select planid from BIS_RISKPPLANDATA where userid='{0}' and datatype=0)", user.Account); } else { string authType = new AuthorizeBLL().GetOperAuthorzeType(user, "7b040bd0-7561-4f87-8967-49c0f969702a", "search"); if (!string.IsNullOrEmpty(authType)) { switch (authType) { case "1": sql += " and (createuserid='" + user.UserId + "'"; break; case "2": sql += " and (deptcode='" + user.DeptCode + "%'"; break; case "3": sql += " and (deptcode like '" + user.DeptCode + "%'"; break; case "4": sql += " and (deptcode like '" + user.OrganizeCode + "%'"; break; case "5": sql += " and (1=1 "; break; } sql += " or (',' || userids || ',') like '%," + user.Account + ",%')"; } else { sql += " (',' || userids || ',') like '%," + user.Account + ",%'"; } } DataTable dt = riskBll.GetPlanList(user, sql); return(new { Code = 0, Count = -1, Info = "获取数据成功", data = dt }); } catch (Exception ex) { return(new { Code = -1, Count = 0, Info = ex.Message }); } }
public string GetDataAuthority(string jsonData) { var user = OperatorProvider.Provider.Current(); AuthorizeBLL authBLL = new AuthorizeBLL(); string result = authBLL.GetDataAuthority(user.UserId, Request.Cookies["currentmoduleId"].Value, jsonData); return(result); }
public ActionResult GetListJson(Pagination pagination, string queryJson) { var watch = CommonHelper.TimerStart(); var queryParam = queryJson.ToJObject(); Operator opertator = new OperatorProvider().Current(); if (pagination.p_fields.IsEmpty()) { pagination.p_fields = @"a.autoid,a.createdate,a.createuserid,a.createuserdeptcode,a.createuserorgcode,a.modifydate,a.modifyuserid,a.belongmodule,a.belongmodulecode, a.moduleno,a.modulename,a.flowname,a.checkdeptid,a.checkdeptcode,a.checkdeptname,a.checkroleid,a.checkrolename,a.remark,b.fullname orginezename,a.serialnum"; } pagination.p_kid = "id"; pagination.p_tablename = @"bis_manypowercheck a left join base_department b on a.createuserorgcode = b.encode"; pagination.conditionJson = " 1=1"; string authWhere = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "CREATEUSERDEPTCODE", "CREATEUSERORGCODE"); if (!string.IsNullOrEmpty(authWhere)) {//数据权限,含系统管理员添加的数据。 pagination.conditionJson += " and (" + authWhere + " or a.CREATEUSERORGCODE='00')"; } else { pagination.conditionJson += " and a.CREATEUSERORGCODE='" + opertator.OrganizeCode + "'"; } //模块名称 if (!queryParam["modulename"].IsEmpty()) { pagination.conditionJson += string.Format(@" and a.moduleno = '{0}' ", queryParam["modulename"].ToString()); } //审核部门名称 if (!queryParam["checkdeptname"].IsEmpty()) { pagination.conditionJson += string.Format(@" and a.checkdeptname like '%{0}%'", queryParam["checkdeptname"].ToString()); } //角色名称 if (!queryParam["checkrolename"].IsEmpty()) { pagination.conditionJson += string.Format(@" and a.checkrolename like '%{0}%'", queryParam["checkrolename"].ToString()); } //所属模块 if (!queryParam["belongmodule"].IsEmpty()) { pagination.conditionJson += string.Format(@" and a.belongmodulecode = '{0}'", queryParam["belongmodule"].ToString()); } var data = manyPowerCheckbll.GetManyPowerCheckEntityPage(pagination, queryJson); var JsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(Content(JsonData.ToJson())); }
/// <summary> /// 导出到Excel /// </summary> /// <param name="queryJson"></param> /// <returns></returns> public ActionResult Excel(string queryJson) { DepartmentBLL departmentBLL = new DepartmentBLL(); string sqlwhere = "Account!='System' and us is not null"; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); if (user.IsSystem) { sqlwhere = "1=1 and us is not null"; } else { var queryParam = queryJson.ToJObject(); if (queryParam["datatype"].IsEmpty()) { string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "departmentcode", "organizecode"); if (!string.IsNullOrEmpty(where) && (queryParam["code"].IsEmpty() || !queryJson.Contains("code"))) { sqlwhere += " and " + where; } } } var data = new HazardfactoruserBLL().GetPageList(sqlwhere, queryJson); foreach (DataRow dr in data.Rows) { if (dr["nature"].ToString() == "专业" || dr["nature"].ToString() == "班组") { DataTable dt = departmentBLL.GetDataTable(string.Format("select fullname from BASE_DEPARTMENT where encode=(select encode from BASE_DEPARTMENT t where instr('{0}',encode)=1 and nature='{1}' and organizeid='{2}') or encode='{0}' order by deptcode", dr["DEPARTMENTCODE"], "部门", dr["organizeid"])); if (dt.Rows.Count > 0) { string name = ""; foreach (DataRow dr1 in dt.Rows) { name += dr1["fullname"].ToString() + "/"; } dr["deptname"] = name.TrimEnd('/'); } } } for (int i = 0; i < data.Rows.Count; i++) { data.Rows[i][0] = i + 1; } string FileUrl = @"\Resource\ExcelTemplate\接触职业危害因素人员_导出模板.xlsx"; AsposeExcelHelper.ExecuteResult(data, FileUrl, "接触职业危害因素人员清单", "接触职业危害因素人员列表"); return(Success("导出成功。")); }
public ActionResult GetPageListNormJson(Pagination pagination, string queryJson) { var watch = CommonHelper.TimerStart(); pagination.p_kid = "Id"; pagination.p_fields = @"CREATEUSERID,CREATEUSERDEPTCODE,CREATEUSERORGCODE,CREATEDATE,CREATEUSERNAME,MODIFYDATE,MODIFYUSERID,MODIFYUSERNAME,NAME,OCONTENT"; pagination.p_tablename = @"HSE_SECURITYOBSERVENORM "; pagination.sidx = "createdate"; pagination.sord = "desc"; pagination.conditionJson = "1=1"; Operator currUser = OperatorProvider.Provider.Current(); if (!currUser.IsSystem) { //根据当前用户对模块的权限获取记录 string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "createuserdeptcode", "createuserorgcode"); if (!string.IsNullOrEmpty(where)) { pagination.conditionJson += " and " + where; } } var queryParam = queryJson.ToJObject(); //if (queryJson.Contains("deptcode")) //{ // if (!queryParam["deptcode"].IsEmpty()) // { // pagination.conditionJson += string.Format(" and DEPARTMENTCODE like'{0}%'", queryParam["deptcode"].ToString()); // } //} //if (!queryParam["starttime"].IsEmpty()) //{ // pagination.conditionJson += string.Format(" and to_char(CREATEDATE,'yyyy-mm-dd')>=to_char(to_date('{0}','yyyy-mm-dd'),'yyyy-mm-dd') ", queryParam["starttime"].ToString()); //} //if (!queryParam["endtime"].IsEmpty()) //{ // pagination.conditionJson += string.Format(" and to_char(CREATEDATE,'yyyy-mm-dd')<=to_char(to_date('{0}','yyyy-mm-dd'),'yyyy-mm-dd') ", queryParam["endtime"].ToString()); //} var data = hseobservenormbll.GetPageList(pagination, null); 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 path = new DataItemDetailBLL().GetItemValue("imgUrl"); string res = json.Value <string>("json"); dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res); string userId = dy.userid; string username = dy.data.username; //姓名 string deptid = dy.data.deptid; //部门 string card = dy.data.idcard; //身份证 long pageIndex = dy.data.pageIndex; long pageSize = dy.data.pageSize; //获取用户基本信息 OperatorProvider.AppUserId = userId; //设置当前用户 Operator user = OperatorProvider.Provider.Current(); Pagination pagination = new Pagination(); pagination.page = int.Parse(pageIndex.ToString()); pagination.rows = int.Parse(pageSize.ToString()); pagination.sidx = "createdate"; pagination.sord = "desc"; pagination.p_kid = "u.USERID"; pagination.p_fields = "REALNAME,MOBILE,DEPTNAME,usertype,GENDER,identifyid,case when headicon is null then '' else ('" + path + "' || headicon) end faceurl"; pagination.p_tablename = "v_userinfo u"; pagination.conditionJson = "Account!='System'"; if (user.IsSystem) { pagination.conditionJson = "1=1"; } else { string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), "ea93dc6b-83fc-4ac2-a1b7-56ef6909445c", "departmentcode", "organizecode"); if (!string.IsNullOrEmpty(where)) { pagination.conditionJson += " and " + where; } } string queryJson = Newtonsoft.Json.JsonConvert.SerializeObject(new { userName = username, idCard = card, departmentId = deptid }); var data = new UserBLL().GetPageList(pagination, queryJson); return(new { Code = 0, Count = pagination.records, Info = "获取数据成功", data = data }); } catch (Exception ex) { return(new { Code = -1, Count = 0, Info = ex.Message }); } }
public ActionResult GetPageListJson(Pagination pagination, string queryJson) { pagination.p_kid = "ID"; pagination.p_fields = "createuserid,Title,Publisher,ReleaseTime,IsSend"; pagination.p_tablename = "bis_staffmien t"; pagination.conditionJson = "1=1"; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); if (!user.IsSystem) { string authType = new AuthorizeBLL().GetOperAuthorzeType(user, HttpContext.Request.Cookies["currentmoduleId"].Value, "search"); if (!string.IsNullOrEmpty(authType)) { switch (authType) { case "1": pagination.conditionJson += " and createuserid='" + user.UserId + "'"; break; case "2": pagination.conditionJson += " and createuserdeptcode='" + user.DeptCode + "'"; break; case "3": pagination.conditionJson += " and createuserdeptcode like'" + user.DeptCode + "%'"; break; case "4": pagination.conditionJson += " and createuserorgcode='" + user.OrganizeCode + "'"; break; } } else { pagination.conditionJson += " and 0=1"; } } pagination.conditionJson += string.Format(" and (IsSend='0' or createuserid='{0}')", user.UserId); var watch = CommonHelper.TimerStart(); var data = staffmienbll.GetPageList(pagination, queryJson); var jsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(ToJsonResult(jsonData)); }