/// <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));
}
