/// <summary>
/// 用户列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public DataTable GetPageList(Pagination pagination, string queryJson)
{
DatabaseType dataType = DbHelper.DbType;
if (queryJson.Length > 0)
{
var queryParam = queryJson.ToJObject();
#region 查询条件
//查询条件
if (!queryParam["Hxpaqsms"].IsEmpty())
{
string HXPAQSMS = queryParam["Hxpaqsms"].ToString();
pagination.conditionJson += string.Format(" and HXPAQSMS like '%{0}%'", HXPAQSMS);
}
#endregion
#region 权限判断
if (!queryParam["code"].IsEmpty() && !queryParam["isOrg"].IsEmpty())
{
pagination = PermissionByCurrent.GetPermissionByCurrent2(pagination, queryParam["code"].ToString(), queryParam["isOrg"].ToString());
}
#endregion
}
return(this.BaseRepository().FindTableByProcPager(pagination, dataType));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public DataTable GetPageList(Pagination pagination, string queryJson)
{
DatabaseType dataType = DbHelper.DbType;
if (queryJson.Length > 0)
{
var queryParam = queryJson.ToJObject();
//查询条件
//if (!queryParam["checkaddress"].IsEmpty())
//{
// string sgtype = queryParam["checkaddress"].ToString();
// pagination.conditionJson += string.Format(" and checkaddress = '{0}'", sgtype);
//}
if (!queryParam["checkdate"].IsEmpty())
{
string checkdate = queryParam["checkdate"].ToString();
pagination.conditionJson += string.Format(" and checkdate = to_date('{0}', 'yyyy-MM-dd')", checkdate);
}
#region 权限判断
if (!queryParam["code"].IsEmpty() && !queryParam["isOrg"].IsEmpty())
{
pagination = PermissionByCurrent.GetPermissionByCurrent2(pagination, queryParam["code"].ToString(), queryParam["isOrg"].ToString());
}
#endregion
}
return(this.BaseRepository().FindTableByProcPager(pagination, dataType));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public DataTable GetPageList(Pagination pagination, string queryJson)
{
DatabaseType dataType = DbHelper.DbType;
if (queryJson.Length > 0)
{
var queryParam = queryJson.ToJObject();
//查询条件
if (!queryParam["keyvalue"].IsEmpty())
{
string id = queryParam["keyvalue"].ToString();
pagination.conditionJson += string.Format(" and id ='{0}'", id);
}
//查询条件
if (!queryParam["keyword"].IsEmpty())
{
string sgtypename = queryParam["keyword"].ToString();
pagination.conditionJson += string.Format(" and sampleno like '%{0}%'", sgtypename);
}
if (!queryParam["sampletype"].IsEmpty())
{
string sgtype = queryParam["sampletype"].ToString();
pagination.conditionJson += string.Format(" and sampletype = '{0}'", sgtype);
}
if (!queryParam["testdate"].IsEmpty())
{
string testdate = queryParam["testdate"].ToString();
pagination.conditionJson += string.Format(" and testdate = to_date('{0}', 'yyyy-MM-dd')", testdate);
}
#region 权限判断
if (!queryParam["code"].IsEmpty() && !queryParam["isOrg"].IsEmpty())
{
pagination = PermissionByCurrent.GetPermissionByCurrent2(pagination, queryParam["code"].ToString(), queryParam["isOrg"].ToString());
}
#endregion
}
return(this.BaseRepository().FindTableByProcPager(pagination, dataType));
}
/// <summary>
/// 用户列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public DataTable GetPageList(Pagination pagination, string queryJson)
{
DatabaseType dataType = DbHelper.DbType;
if (queryJson.Length > 0)
{
var queryParam = queryJson.ToJObject();
//查询条件
//姓名
if (!queryParam["RealName"].IsEmpty())
{
string RealName = queryParam["RealName"].ToString();
pagination.conditionJson += string.Format(" and UserFullName like '%{0}%'", RealName);
}
if (!queryParam["PostId"].IsEmpty())
{
string PostId = queryParam["PostId"].ToString();
pagination.conditionJson += string.Format(" and PostId = '{0}'", PostId);
}
//公司主键
if (!queryParam["organizeId"].IsEmpty())
{
string organizeId = queryParam["organizeId"].ToString();
pagination.conditionJson += string.Format(" and ORGANIZEID = '{0}'", organizeId);
}
//部门主键
if (!queryParam["departmentId"].IsEmpty())
{
string departmentId = queryParam["departmentId"].ToString();
pagination.conditionJson += string.Format(" and departmentid = '{0}'", departmentId);
}
if (!queryParam["OrgCode"].IsEmpty())
{
pagination.conditionJson += string.Format(" and OrgName = '{0}'", queryParam["OrgCode"].ToString());
}
#region 权限判断
if (!queryParam["code"].IsEmpty() && !queryParam["isOrg"].IsEmpty())
{
pagination = PermissionByCurrent.GetPermissionByCurrent2(pagination, queryParam["code"].ToString(), queryParam["isOrg"].ToString());
}
#endregion
}
return(this.BaseRepository().FindTableByProcPager(pagination, dataType));
}
/// <summary>
/// 用户列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public DataTable GetPageList(Pagination pagination, string queryJson)
{
DatabaseType dataType = DbHelper.DbType;
if (queryJson.Length > 0)
{
var queryParam = queryJson.ToJObject();
//查询条件
if (!queryParam["condition"].IsEmpty() && !queryParam["keyword"].IsEmpty())
{
string condition = queryParam["condition"].ToString();
string keyord = queryParam["keyword"].ToString();
switch (condition)
{
case "ReserverPlanName": //预案名称
pagination.conditionJson += string.Format(" and ReserverPlanName like '%{0}%'", keyord);
break;
default:
break;
}
}
//公司主键
if (!queryParam["organizeId"].IsEmpty())
{
string organizeId = queryParam["organizeId"].ToString();
pagination.conditionJson += string.Format(" and ORGANIZEID = '{0}'", organizeId);
}
//部门主键
if (!queryParam["departmentId"].IsEmpty())
{
string departmentId = queryParam["departmentId"].ToString();
pagination.conditionJson += string.Format(" and departmentId = '{0}'", departmentId);
}
#region 权限判断
if (!queryParam["code"].IsEmpty() && !queryParam["isOrg"].IsEmpty())
{
pagination = PermissionByCurrent.GetPermissionByCurrent(pagination, queryParam["code"].ToString(), queryParam["isOrg"].ToString());
}
#endregion
}
return(this.BaseRepository().FindTableByProcPager(pagination, dataType));
}
/// <summary>
/// 用户列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public DataTable GetPageList(Pagination pagination, string queryJson)
{
DatabaseType dataType = DbHelper.DbType;
if (queryJson.Length > 0)
{
var queryParam = queryJson.ToJObject();
#region 查询条件
//查询条件
if (!queryParam["TimeEnd"].IsEmpty())
{
string TimeEnd = queryParam["TimeEnd"].ToString();
TimeEnd = DateTime.Parse(TimeEnd).AddDays(1).ToString();
pagination.conditionJson += string.Format(" and CreateDate <= (select to_date('{0}', 'yyyy-MM-dd') from dual)", TimeEnd);
}
//查询条件
if (!queryParam["TimeStart"].IsEmpty())
{
string TimeStart = queryParam["TimeStart"].ToString();
pagination.conditionJson += string.Format(" and CreateDate >= (select to_date('{0}', 'yyyy-MM-dd') from dual)", TimeStart);
}
//查询条件
if (!queryParam["DangerSourceName"].IsEmpty())
{
string DangerSourceName = queryParam["DangerSourceName"].ToString();
pagination.conditionJson += string.Format(" and DangerSourceName like '%{0}%'", DangerSourceName);
}
#endregion
#region 权限判断
if (!queryParam["code"].IsEmpty() && !queryParam["isOrg"].IsEmpty())
{
pagination = PermissionByCurrent.GetPermissionByCurrent2(pagination, queryParam["code"].ToString(), queryParam["isOrg"].ToString());
}
#endregion
}
return(this.BaseRepository().FindTableByProcPager(pagination, dataType));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public DataTable GetPageList(Pagination pagination, string queryJson)
{
Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current();
DatabaseType dataType = DbHelper.DbType;
if (queryJson.Length > 0)
{
var queryParam = queryJson.ToJObject();
//查询条件
if (!queryParam["keyword"].IsEmpty())
{
string keyord = queryParam["keyword"].ToString();
//keyord
pagination.conditionJson += string.Format(" and (WSSJNAME like '%{0}%' or WSSJBGUSERNAME like '%{1}%' or AREANAME like '{2}') ", keyord, keyord, keyord);
}
if (!queryParam["wssjtype"].IsEmpty())
{
string sgtype = queryParam["wssjtype"].ToString();
pagination.conditionJson += string.Format(" and WSSJTYPE = '{0}'", sgtype);
}
if (!queryParam["wssjtypename"].IsEmpty())
{
string wssjtypename = queryParam["wssjtypename"].ToString();
pagination.conditionJson += string.Format(" and WSSJTYPENAME = '{0}'", wssjtypename);
}
if (!queryParam["happentimestart"].IsEmpty())
{
string happentimestart = queryParam["happentimestart"].ToString();
pagination.conditionJson += string.Format(" and happentime >=(select to_date('{0}', 'yyyy-MM-dd HH24:mi:ss') from dual)", happentimestart);
}
if (!queryParam["happentimeend"].IsEmpty())
{
string happentimeend = queryParam["happentimeend"].ToString();
if (happentimeend.Length == 10)
{
happentimeend = Convert.ToDateTime(happentimeend).AddDays(1).ToString();
}
pagination.conditionJson += string.Format(" and happentime <=(select to_date('{0}', 'yyyy-MM-dd HH24:mi:ss') from dual)", happentimeend);
}
//处理时间
if (!queryParam["happentimestart_deal"].IsEmpty())
{
string happentimestart_deal = queryParam["happentimestart_deal"].ToString();
pagination.conditionJson += string.Format(" and happentime_deal >= (select to_date('{0}', 'yyyy-MM-dd HH24:mi:ss') from dual)", happentimestart_deal);
}
if (!queryParam["happentimeend_deal"].IsEmpty())
{
string happentimeend_deal = queryParam["happentimeend_deal"].ToString();
if (happentimeend_deal.Length == 10)
{
happentimeend_deal = Convert.ToDateTime(happentimeend_deal).AddDays(1).ToString();
}
pagination.conditionJson += string.Format(" and happentime_deal <= (select to_date('{0}', 'yyyy-MM-dd HH24:mi:ss') from dual)", happentimeend_deal);
}
if (!queryParam["IsSubmit"].IsEmpty())
{
var IsSubmit = int.Parse(queryParam["IsSubmit"].ToString());
pagination.conditionJson += string.Format(" and IsSubmit = '{0}'", IsSubmit);
}
if (!queryParam["IsSubmit_Deal"].IsEmpty())
{
var IsSubmit_Deal = int.Parse(queryParam["IsSubmit_Deal"].ToString());
if (IsSubmit_Deal == 0)
{
pagination.conditionJson += string.Format(" and ( IsSubmit_Deal = '{0}' OR IsSubmit_Deal is null)", IsSubmit_Deal);
}
else
{
pagination.conditionJson += string.Format(" and IsSubmit_Deal = '{0}'", IsSubmit_Deal);
}
}
//公司主键
if (!queryParam["organizeId"].IsEmpty())
{
string organizeId = queryParam["organizeId"].ToString();
pagination.conditionJson += string.Format(" and ORGANIZEID = '{0}'", organizeId);
}
//部门主键
if (!queryParam["departmentId"].IsEmpty())
{
string departmentId = queryParam["departmentId"].ToString();
pagination.conditionJson += string.Format(" and departmentid = '{0}'", departmentId);
}
//厂级领导安全指标参数
if (!queryParam["action"].IsEmpty())
{
pagination.conditionJson += string.Format(" and t.createuserorgcode='{0}' and issubmit_deal =1 and to_char(t.createdate,'yyyy')='{1}'", user.OrganizeCode, DateTime.Now.Year);
}
#region 权限判断
if (!queryParam["code"].IsEmpty() && !queryParam["isOrg"].IsEmpty())
{
pagination = PermissionByCurrent.GetPermissionByCurrent2(pagination, queryParam["code"].ToString(), queryParam["isOrg"].ToString());
}
#endregion
}
return(this.BaseRepository().FindTableByProcPager(pagination, dataType));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public DataTable GetPageList(Pagination pagination, string queryJson)
{
DatabaseType dataType = DbHelper.DbType;
if (queryJson.Length > 0)
{
var queryParam = queryJson.ToJObject();
//查询条件
if (!queryParam["keyword"].IsEmpty())
{
string keyord = queryParam["keyword"].ToString();
//keyord
pagination.conditionJson += string.Format(" and (SGNAME like '%{0}%' or SGKBUSERNAME like '%{1}%' or AREANAME like '%{2}%') ", keyord, keyord, keyord);
}
if (!queryParam["sgtypeLevel"].IsEmpty())
{
string sgtypeLevel = queryParam["sgtypeLevel"].ToString();
pagination.conditionJson += " and sgtype='" + sgtypeLevel + "'";
}
//事故原因
if (!queryParam["sgyy"].IsEmpty())
{
string keyord = queryParam["sgyy"].ToString();
if (keyord == "IsXW")
{
pagination.conditionJson += string.Format(" and BAQXWNAME is not null ");
}
else if (keyord == "IsZT")
{
pagination.conditionJson += string.Format(" and BAQZTNAME is not null ");
}
else
{
pagination.conditionJson += string.Format(" and (JJYYNAME like '%{0}%' or BAQXWNAME like '%{1}%' or BAQZTNAME like '%{2}%') ", keyord, keyord, keyord);
}
}
if (!queryParam["sgtype"].IsEmpty())
{
string sgtype = queryParam["sgtype"].ToString();
pagination.conditionJson += string.Format(" and sgtype = '{0}'", sgtype);
}
if (!queryParam["sgtypename"].IsEmpty())
{
string sgtypename = queryParam["sgtypename"].ToString();
pagination.conditionJson += string.Format(" and sgtypename = '{0}'", sgtypename);
}
if (!queryParam["rsshsgtypename"].IsEmpty())
{
string rsshsgtypename = queryParam["rsshsgtypename"].ToString();
pagination.conditionJson += string.Format(" and rsshsgtypename = '{0}'", rsshsgtypename);
}
if (!queryParam["sglevelname"].IsEmpty())
{
string sglevelname = queryParam["sglevelname"].ToString();
pagination.conditionJson += string.Format(" and sglevelname = '{0}'", sglevelname);
}
if (!queryParam["rsshsgtype_deal"].IsEmpty())
{
string rsshsgtype_deal = queryParam["rsshsgtype_deal"].ToString();
pagination.conditionJson += string.Format(" and rsshsgtype_deal = '{0}'", rsshsgtype_deal);
}
if (!queryParam["happentimestart"].IsEmpty())
{
string happentimestart = queryParam["happentimestart"].ToString();
pagination.conditionJson += string.Format(" and happentime >= (select to_date('{0}', 'yyyy-MM-dd HH24:mi:ss') from dual)", happentimestart);
}
if (!queryParam["happentimeend"].IsEmpty())
{
string happentimeend = queryParam["happentimeend"].ToString();
if (happentimeend.Length == 10)
{
happentimeend = Convert.ToDateTime(happentimeend).AddDays(1).ToString();
}
pagination.conditionJson += string.Format(" and happentime <= (select to_date('{0}', 'yyyy-MM-dd HH24:mi:ss') from dual)", happentimeend);
}
//处理时间
if (!queryParam["happentimestart_deal"].IsEmpty())
{
string happentimestart_deal = queryParam["happentimestart_deal"].ToString();
pagination.conditionJson += string.Format(" and happentime_deal >= (select to_date('{0}', 'yyyy-MM-dd HH24:mi:ss') from dual)", happentimestart_deal);
}
if (!queryParam["happentimeend_deal"].IsEmpty())
{
string happentimeend_deal = queryParam["happentimeend_deal"].ToString();
if (happentimeend_deal.Length == 10)
{
happentimeend_deal = Convert.ToDateTime(happentimeend_deal).AddDays(1).ToString();
}
pagination.conditionJson += string.Format(" and happentime_deal <= (select to_date('{0}', 'yyyy-MM-dd HH24:mi:ss') from dual)", happentimeend_deal);
}
if (!queryParam["IsSubmit"].IsEmpty())
{
var IsSubmit = int.Parse(queryParam["IsSubmit"].ToString());
pagination.conditionJson += string.Format(" and IsSubmit = '{0}'", IsSubmit);
}
if (!queryParam["IsSubmit_Deal"].IsEmpty())
{
var IsSubmit_Deal = int.Parse(queryParam["IsSubmit_Deal"].ToString());
if (IsSubmit_Deal == 0)
{
pagination.conditionJson += string.Format(" and ( IsSubmit_Deal = '{0}' OR IsSubmit_Deal is null)", IsSubmit_Deal);
}
else
{
pagination.conditionJson += string.Format(" and IsSubmit_Deal = '{0}'", IsSubmit_Deal);
}
}
//报表类型
if (!queryParam["type"].IsEmpty())
{
var type = queryParam["type"].ToString();
if (type == "swrs")
{
pagination.conditionJson += string.Format(" and sgtypename like '%人身伤亡事故%'");
}
}
#region 权限判断
if (!queryParam["code"].IsEmpty() && !queryParam["isOrg"].IsEmpty())
{
pagination = PermissionByCurrent.GetPermissionByCurrent2(pagination, queryParam["code"].ToString(), queryParam["isOrg"].ToString());
}
#endregion
}
return(this.BaseRepository().FindTableByProcPager(pagination, dataType));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="pagination">分页</param>
/// <param name="queryJson">查询参数</param>
/// <returns></returns>
public DataTable GetPageList(Pagination pagination, string queryJson)
{
DatabaseType dataType = DbHelper.DbType;
if (queryJson.Length > 0)
{
var queryParam = queryJson.ToJObject();
//查询条件
if (!queryParam["sgtype"].IsEmpty())
{
string sgtype = queryParam["sgtype"].ToString();
pagination.conditionJson += string.Format(" and accidenteventtype = '{0}'", sgtype);
}
if (!queryParam["keyword"].IsEmpty())
{
string sgtypename = queryParam["keyword"].ToString();
pagination.conditionJson += string.Format(" and accidenteventname like '%{0}%'", sgtypename);
}
if (!queryParam["happentimestart"].IsEmpty())
{
string happentimestart = queryParam["happentimestart"].ToString();
pagination.conditionJson += string.Format(" and happentime >= (select to_date('{0}', 'yyyy-MM-dd HH24:mi:ss') from dual)", happentimestart);
}
if (!queryParam["happentimeend"].IsEmpty())
{
string happentimeend = queryParam["happentimeend"].ToString();
if (happentimeend.Length == 10)
{
happentimeend = Convert.ToDateTime(happentimeend).AddDays(1).ToString();
}
pagination.conditionJson += string.Format(" and happentime <= (select to_date('{0}', 'yyyy-MM-dd HH24:mi:ss') from dual)", happentimeend);
}
//待办事项
if (!queryParam["mode"].IsEmpty())
{
string mode = queryParam["mode"].ToString();
if (mode == "dbsx")
{
Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current();
var roleArr = user.RoleName.Split(','); //当前人员角色
string strRole = "";
foreach (var rolename in roleArr)
{
strRole += string.Format(" flowrolename like '%{0}%' or ", rolename);
}
if (strRole.Length > 2)
{
strRole = strRole.Substring(0, strRole.Length - 3);
}
string strsql = string.Format(" and createuserorgcode = '{0}' and ISSAVED=1 and isover <> 1 and flowdept = '{1}' and ({2})", user.OrganizeCode, user.DeptId, strRole);
pagination.conditionJson += strsql;
}
else if (mode == "isover")
{
pagination.conditionJson += " and issaved=1 and isover=1";
}
}
#region 权限判断
if (!queryParam["code"].IsEmpty() && !queryParam["isOrg"].IsEmpty())
{
pagination = PermissionByCurrent.GetPermissionByCurrent2(pagination, queryParam["code"].ToString(), queryParam["isOrg"].ToString());
}
#endregion
}
return(this.BaseRepository().FindTableByProcPager(pagination, dataType));
}
