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