/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tSysDuty">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TSysDutyVo tSysDuty, int iIndex, int iCount) { string strSQL = " select * from T_SYS_DUTY {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(tSysDuty)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tSysDuty_UpdateSet">UpdateSet用户对象</param> /// <param name="tSysDuty_UpdateWhere">UpdateWhere用户对象</param> /// <returns>是否成功</returns> public bool Edit(TSysDutyVo tSysDuty_UpdateSet, TSysDutyVo tSysDuty_UpdateWhere) { string strSQL = SqlHelper.BuildUpdateExpress(tSysDuty_UpdateSet, TSysDutyVo.T_SYS_DUTY_TABLE); strSQL += this.BuildWhereStatement(tSysDuty_UpdateWhere); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tSysDuty">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TSysDutyVo tSysDuty) { string strSQL = SqlHelper.BuildUpdateExpress(tSysDuty, TSysDutyVo.T_SYS_DUTY_TABLE); strSQL += string.Format(" where ID='{0}' ", tSysDuty.ID); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 对象删除 /// </summary> /// <param name="Id">ID</param> /// <returns>是否成功</returns> public bool Delete(TSysDutyVo tSysDuty) { string strSQL = "delete from T_SYS_DUTY "; strSQL += this.BuildWhereStatement(tSysDuty); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获取已设置采样任务的人员列表 /// </summary> /// <param name="tSysDuty"></param> /// <returns></returns> public DataTable SelectByUnionTable(TSysDutyVo tSysDuty, int iIndex, int iCount) { string strSQL = String.Format("SELECT A.ID AS USERDUTYID,A.USERID AS ID,A.DUTY_ID,A.IF_DEFAULT,A.IF_DEFAULT_EX,C.REAL_NAME FROM T_SYS_USER_DUTY A" + " INNER JOIN t_sys_user C on C.id=a.userid and c.is_del='0' and is_hide='0' and is_use='1'" + " INNER JOIN T_SYS_DUTY B ON A.DUTY_ID=B.ID AND B.MONITOR_TYPE_ID='{0}' AND B.DICT_CODE='{1}' ", tSysDuty.MONITOR_TYPE_ID, tSysDuty.DICT_CODE); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 获取已设置采样任务的人员列表总数 /// </summary> /// <param name="tSysDuty"></param> /// <returns></returns> public int GetSelectByUnionResultCount(TSysDutyVo tSysDuty) { string strSQL = String.Format("SELECT A.ID AS USERDUTYID,A.USERID AS ID,A.DUTY_ID,A.IF_DEFAULT,A.IF_DEFAULT_EX,C.REAL_NAME FROM T_SYS_USER_DUTY A" + " INNER JOIN t_sys_user C on C.id=a.userid and c.is_del='0' and is_hide='0' and is_use='1'" + " INNER JOIN T_SYS_DUTY B ON A.DUTY_ID=B.ID AND B.MONITOR_TYPE_ID='{0}' AND B.DICT_CODE='{1}' ", tSysDuty.MONITOR_TYPE_ID, tSysDuty.DICT_CODE); return(SqlHelper.ExecuteDataTable(strSQL).Rows.Count); }
/// <summary> /// 功能描述:获取所有已设置采样任务的人员列表 /// 创建时间:2013-2-28 /// 创建人:邵世卓 /// </summary> /// <param name="tSysDuty"></param> /// <returns></returns> public DataTable SelectByUnionTableForWhere(TSysDutyVo tSysDuty, int iIndex, int iCount) { string strSQL = String.Format("SELECT A.ID AS USERDUTYID,A.USERID AS ID,A.DUTY_ID,A.IF_DEFAULT,A.IF_DEFAULT_EX,C.REAL_NAME FROM T_SYS_USER_DUTY A" + " INNER JOIN t_sys_user C on C.id=a.userid and c.is_del='0' and is_hide='0' and is_use='1'" + " INNER JOIN (select * from T_SYS_DUTY {0}) B ON A.DUTY_ID=B.ID", BuildWhereStatement(tSysDuty)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 插入分析类岗位的 监测类别 /// </summary> /// <param name="objcitems"></param> /// <param name="strDutyType"></param> /// <param name="strMonitor"></param> /// <param name="strItems"></param> /// <param name="strUserId"></param> /// <param name="dtis"></param> /// <param name="sAuItems"></param> /// <param name="sExItems"></param> /// <param name="mAuItems"></param> /// <param name="mExItems"></param> /// <returns></returns> public static bool InsertAddMonitorItems(TSysDutyVo objcitems, string strDutyType, string strMonitor, string strUserId, DataTable dtis, string[] strItems, string[] sAuItems, string[] sExItems, string[] mAuItems, string[] mExItems, bool isMonitorType) { bool flag = false; string flag_au = "", flag_ex = "", flag_mau = "", flag_mex = ""; string dutId = ""; int newNum = 0, newSuc = 0; int strCount = strItems.Length - 1; foreach (string str in strItems) { if (!String.IsNullOrEmpty(str)) { //是否存在已经设置了的监测项目组合 DataRow[] dr = dtis.Select("MONITOR_ITEM_ID IS NULL AND DICT_CODE='" + strDutyType + "'"); if (dr.Length > 0) { //获取已经存在符合条件的ID dutId = dr[0]["ID"].ToString(); } else { objcitems.ID = GetSerialNumber("duty_set_infor"); dutId = objcitems.ID; objcitems.DICT_CODE = strDutyType; bool flgs = new TSysDutyLogic().Create(objcitems); if (flgs) { string strMessage = new PageBase().LogInfo.UserInfo.USER_NAME + "新增岗位职责" + objcitems.ID + "成功"; new PageBase().WriteLog(i3.ValueObject.ObjectBase.LogType.AddDutyInfo, "", strMessage); } } //直接插入岗位职责用户关联数据 if (UserDutyItem(strUserId, "", dutId)) { newNum++; } else { newSuc++; } //插入默认负责人和默认协同人项目 flag_au = UpdateDefaultAuValue(strUserId, strMonitor, strDutyType, sAuItems, isMonitorType); flag_ex = UpdateDefaultExValue(strUserId, strMonitor, strDutyType, sExItems, isMonitorType); flag_mau = UpdateDefaultMoveAuValue(strUserId, strMonitor, strDutyType, mAuItems, isMonitorType); flag_mex = UpdateDefaultMoveExValue(strUserId, strMonitor, strDutyType, mExItems, isMonitorType); } } if ((newNum + newSuc) == strCount && flag_au != "0" && flag_ex != "0" && flag_mau != "0" & @flag_mex != "0") { flag = true; } return(flag); }
/// <summary> /// 获取用户数据集 /// </summary> /// <returns></returns> protected string getUserList() { DataTable dt = new DataTable(); TSysDutyVo objItems = new TSysDutyVo(); objItems.DICT_CODE = "duty_reportschedule"; dt = new TSysDutyLogic().SelectByUnionTableForWhere(objItems, 0, 0); return(DataTableToJson(dt)); }
public static bool InsertSelectedUser(string strUserId, string strItemID, string strDutyType) { string strDutyID = ""; string strMonitorID = new TBaseItemInfoLogic().Details(strItemID).MONITOR_ID; TSysDutyVo objDutySrh = new TSysDutyVo(); objDutySrh.MONITOR_TYPE_ID = strMonitorID; objDutySrh.MONITOR_ITEM_ID = strItemID; objDutySrh.DICT_CODE = strDutyType; DataTable dtDuty = new TSysDutyLogic().SelectByTable(objDutySrh); if (dtDuty.Rows.Count == 0) { //如果不存在岗位配置,增加 objDutySrh.ID = GetSerialNumber("duty_set_infor"); if (new TSysDutyLogic().Create(objDutySrh)) { strDutyID = objDutySrh.ID; } } else { strDutyID = dtDuty.Rows[0]["ID"].ToString(); } TSysUserDutyVo objUserDutySrh = new TSysUserDutyVo(); objUserDutySrh.DUTY_ID = strDutyID; DataTable dtUserDuty = new TSysUserDutyLogic().SelectByTable(objUserDutySrh); //删除移除的 for (int i = 0; i < dtUserDuty.Rows.Count; i++) { string strTmpUserID = dtUserDuty.Rows[i]["USERID"].ToString(); if (!strUserId.Contains(strTmpUserID)) { new TSysUserDutyLogic().Delete(dtUserDuty.Rows[i]["ID"].ToString()); } } string[] strUerArr = strUserId.Split(';'); new TSysUserDutyLogic().InsertSelectedUser(strUerArr, strDutyID); return(true); }
/// <summary> /// 获取用户信息 /// </summary> /// <returns></returns> protected string getUserInfo() { //获得所有监测类别 DataTable dtSonTask = new TMisMonitorSubtaskLogic().selectAllContractType(this.hdnTaskID.Value); string reslut = ""; DataTable dtTotal = new DataTable(); TSysDutyVo objItems = new TSysDutyVo(); /* * foreach (DataRow dr in dtSonTask.Rows) * { * DataTable dt = new DataTable(); * objItems.DICT_CODE = "duty_reportschedule"; * objItems.MONITOR_TYPE_ID = dr["MONITOR_ID"].ToString(); * dt = new TSysDutyLogic().SelectByUnionTable(objItems, 0, 0); * dt.Columns.Add("MONITOR_NAME"); * dt.Columns.Add("POST_NAME"); * //添加监测类别列 * foreach (DataRow drSon in dt.Rows) * { * drSon["MONITOR_NAME"] = new TBaseMonitorTypeInfoLogic().Details(dr["MONITOR_ID"].ToString()).MONITOR_TYPE_NAME; * drSon["POST_NAME"] = new TSysPostLogic().Details(new TSysUserPostLogic().Details(new TSysUserPostVo() { USER_ID = drSon["ID"].ToString() }).POST_ID).POST_NAME; * } * dtTotal.Merge(dt); * } */ DataTable dt = new DataTable(); objItems.DICT_CODE = "duty_reportschedule"; objItems.MONITOR_TYPE_ID = "000000001"; //默认报告编制人是废水类型的 dt = new TSysDutyLogic().SelectByUnionTable(objItems, 0, 0); dt.Columns.Add("MONITOR_NAME"); dt.Columns.Add("POST_NAME"); //添加监测类别列 foreach (DataRow drSon in dt.Rows) { drSon["MONITOR_NAME"] = new TBaseMonitorTypeInfoLogic().Details("000000001").MONITOR_TYPE_NAME; drSon["POST_NAME"] = new TSysPostLogic().Details(new TSysUserPostLogic().Details(new TSysUserPostVo() { USER_ID = drSon["ID"].ToString() }).POST_ID).POST_NAME; } dtTotal.Merge(dt); reslut = LigerGridDataToJson(dtTotal, dtTotal.Rows.Count); return(reslut); }
public static string EditSampling(string strMonitor, string strUserId, string strDutyType, string isAuDefault) { string result = ""; string[] strUerArr = null; TSysDutyVo objtd = new TSysDutyVo(); objtd.MONITOR_TYPE_ID = strMonitor; objtd.DICT_CODE = strDutyType; strUerArr = strUserId.Split(';'); if (strUerArr != null) { //如果存在岗位配置,则直接插入用户岗位表 DataTable dt = new DataTable(); dt = new TSysDutyLogic().SelectByTable(objtd); bool isDefAu = false; if (isAuDefault == "true") { isDefAu = true; } if (dt.Rows.Count > 0) { if (new TSysUserDutyLogic().InsertSamplingUser(strUerArr, dt.Rows[0]["ID"].ToString(), isDefAu)) { result = "true"; } } else { objtd.ID = GetSerialNumber("duty_set_infor"); if (new TSysDutyLogic().Create(objtd)) { if (new TSysUserDutyLogic().InsertSamplingUser(strUerArr, objtd.ID, isDefAu)) { result = "true"; } } } } return(result); }
/// <summary> /// 获取指定监测类型的岗位职责人员 /// </summary> /// <param name="tSysDuty"></param> /// <returns></returns> public DataTable SelectTableDutyUser(TSysDutyVo tSysDuty) { string strSQL = String.Format("SELECT A.*,B.MONITOR_TYPE_ID,C.REAL_NAME FROM T_SYS_USER_DUTY A " + " LEFT JOIN T_SYS_DUTY B ON A.DUTY_ID=B.ID " + " INNER JOIN T_SYS_USER C ON C.ID=A.USERID AND C.IS_DEL='0' AND IS_USE='1' AND IS_HIDE='0' " + " WHERE B.MONITOR_ITEM_ID IS NULL "); if (!String.IsNullOrEmpty(tSysDuty.MONITOR_TYPE_ID)) { strSQL += String.Format(" AND B.MONITOR_TYPE_ID='{0}'", tSysDuty.MONITOR_TYPE_ID); } if (!String.IsNullOrEmpty(tSysDuty.DICT_CODE)) { strSQL += String.Format(" AND B.DICT_CODE='{0}' ", tSysDuty.DICT_CODE); } return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 加载采样类岗位设置人员列表 /// </summary> /// <param name="strMonitor"></param> /// <param name="strDutyType"></param> /// <param name="iIndex"></param> /// <param name="iCount"></param> /// <returns></returns> public string LoadSetUserList() { //创建标准JSON数据 string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; string strDutyType = Request.Params["strDutyType"]; string strItemID = Request.Params["strItemID"]; TSysDutyVo objItems = new TSysDutyVo(); objItems.MONITOR_ITEM_ID = strItemID; objItems.DICT_CODE = strDutyType; DataTable dt = new TSysDutyLogic().SelectByUnionTableForWhere(objItems, 0, 0); string reslut = LigerGridDataToJson(dt, dt.Rows.Count); return(reslut); }
/// <summary> /// 创建原因:获取指定监测类别 指定岗位职责的项目人员 /// 创建人:胡方扬 /// 创建日期:20130-07-18 /// </summary> /// <param name="tSysDuty"></param> /// <returns></returns> public DataTable GetDutyUser(TSysDutyVo tSysDuty) { string strSQL = @" SELECT A.* FROM dbo.T_SYS_USER_DUTY A LEFT JOIN dbo.T_SYS_DUTY B ON A.DUTY_ID=B.ID WHERE 1=1 "; if (!String.IsNullOrEmpty(tSysDuty.MONITOR_TYPE_ID)) { strSQL += String.Format(" AND B.MONITOR_TYPE_ID='{0}'", tSysDuty.MONITOR_TYPE_ID); } if (!String.IsNullOrEmpty(tSysDuty.DICT_CODE)) { strSQL += String.Format(" AND B.DICT_CODE='{0}'", tSysDuty.DICT_CODE); } if (!String.IsNullOrEmpty(tSysDuty.MONITOR_ITEM_ID)) { strSQL += String.Format(" AND B.MONITOR_ITEM_ID='{0}'", tSysDuty.MONITOR_ITEM_ID); } return(SqlHelper.ExecuteDataTable(strSQL)); }
public static List <object> GetSubUserItems(string strPost_Dept, string strItemID, string strDutyType) { DataTable dt = new TSysUserLogic().SelectByTableUnderDept(strPost_Dept, 0, 0); TSysDutyVo objItems = new TSysDutyVo(); objItems.MONITOR_ITEM_ID = strItemID; objItems.DICT_CODE = strDutyType; DataTable dtDuty = new TSysDutyLogic().SelectByUnionTableForWhere(objItems, 0, 0); DataTable dtItems = new DataTable(); dtItems = dt.Copy(); dtItems.Clear(); if (dtDuty.Rows.Count > 0) { for (int i = 0; i < dtDuty.Rows.Count; i++) { if (!String.IsNullOrEmpty(dtDuty.Rows[i]["ID"].ToString())) { DataRow[] dr = dt.Select("ID='" + dtDuty.Rows[i]["ID"].ToString() + "'"); if (dr != null) { foreach (DataRow Temrow in dr) { Temrow.Delete(); dt.AcceptChanges(); } } } } } dtItems = dt.Copy(); List <object> listResult = LigerGridSelectDataToJson(dtItems, dtItems.Rows.Count); return(listResult); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tSysDuty">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TSysDutyVo> SelectByObject(TSysDutyVo tSysDuty, int iIndex, int iCount) { return(access.SelectByObject(tSysDuty, iIndex, iCount)); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tSysDuty">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TSysDutyVo tSysDuty, int iIndex, int iCount) { return(access.SelectByTable(tSysDuty, iIndex, iCount)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tSysDuty"></param> /// <returns></returns> public DataTable SelectByTable(TSysDutyVo tSysDuty) { return(access.SelectByTable(tSysDuty)); }
/// <summary> /// 保存默认监测计划岗位负责人 Create By Castle (胡方扬) 2013-4-1 /// </summary> /// <returns></returns> public static void SavePlanPeopleForEnv(string strPlanId) { DataTable dtMonitor = new DataTable(); TMisContractPointFreqVo objItemspan = new TMisContractPointFreqVo(); objItemspan.IF_PLAN = "0"; dtMonitor = new TMisContractPointFreqLogic().GetPointMonitorInforForPlan(objItemspan, strPlanId); //DataTable dtMonitor = GetPointMonitorInfor(strPlanId); DataTable dtTemple = new DataTable(); TSysDutyVo objItemspan1 = new TSysDutyVo(); objItemspan1.DICT_CODE = "duty_sampling"; dtTemple = new TSysDutyLogic().SelectTableDutyUser(objItemspan1); //DataTable dtTemple = GetMonitorDutyInforTable(); DataTable dtMonitorDutyUser = new DataTable(); dtMonitorDutyUser = dtTemple.Copy(); dtMonitorDutyUser.Clear(); //获取默认负责人 for (int n = 0; n < dtMonitor.Rows.Count; n++) { DataRow[] drowArr = dtTemple.Select(" IF_DEFAULT='0' AND MONITOR_TYPE_ID='" + dtMonitor.Rows[0]["ID"].ToString() + "'"); if (drowArr.Length > 0) { foreach (DataRow drow in drowArr) { dtMonitorDutyUser.ImportRow(drow); } dtMonitorDutyUser.AcceptChanges(); } else { drowArr = dtTemple.Select(" MONITOR_TYPE_ID='" + dtMonitor.Rows[0]["ID"].ToString() + "'"); if (drowArr.Length > 0) { dtMonitorDutyUser.ImportRow(drowArr[0]); } dtMonitorDutyUser.AcceptChanges(); } } //if (drowArr.Length > 0) //{ // foreach (DataRow drow in drowArr) // { // dtMonitorDutyUser.ImportRow(drow); // } // dtMonitorDutyUser.AcceptChanges(); //} string strMonitorId = "", strUserId = ""; foreach (DataRow drr in dtMonitor.Rows) { for (int i = 0; i < dtMonitorDutyUser.Rows.Count; i++) { if (drr["ID"].ToString() == dtMonitorDutyUser.Rows[i]["MONITOR_TYPE_ID"].ToString()) { strMonitorId += drr["ID"].ToString() + ";"; strUserId += dtMonitorDutyUser.Rows[i]["USERID"].ToString() + ";"; } } } TMisContractUserdutyVo objItems = new TMisContractUserdutyVo(); if (!String.IsNullOrEmpty(strPlanId)) { objItems.CONTRACT_PLAN_ID = strPlanId; string[] strMonitArr = null, strUserArr = null; if (!String.IsNullOrEmpty(strMonitorId) && !String.IsNullOrEmpty(strUserId)) { strMonitArr = strMonitorId.Substring(0, strMonitorId.Length - 1).Split(';'); strUserArr = strUserId.Substring(0, strUserId.Length - 1).Split(';'); if (strMonitArr != null && strUserArr != null) { new TMisContractUserdutyLogic().SaveContractPlanDutyForEnv(objItems, strMonitArr, strUserArr); } } } }
/// <summary> /// 对象明细 /// </summary> /// <param name="tSysDuty">对象条件</param> /// <returns>对象</returns> public TSysDutyVo Details(TSysDutyVo tSysDuty) { string strSQL = String.Format("select * from T_SYS_DUTY " + this.BuildWhereStatement(tSysDuty)); return(SqlHelper.ExecuteObject(new TSysDutyVo(), strSQL)); }
/// <summary> /// 修改项目复制人 /// </summary> /// <param name="strPlanId"></param> private void ModifTaskSampleDutyUser(string strPlanId) { if (!String.IsNullOrEmpty(strPlanId)) { TMisMonitorTaskVo objTaskDetail = new TMisMonitorTaskLogic().Details(new TMisMonitorTaskVo { PLAN_ID = strPlanId }); TMisMonitorSubtaskVo objSubTask = new TMisMonitorSubtaskVo(); objSubTask.TASK_ID = objTaskDetail.ID; DataTable dt = new TMisMonitorSubtaskLogic().SelectByTable(objSubTask, 0, 0); TMisContractUserdutyVo objUserDuty = new TMisContractUserdutyVo(); objUserDuty.CONTRACT_PLAN_ID = strPlanId; DataTable dtDuty = new TMisContractUserdutyLogic().SelectByTable(objUserDuty, 0, 0); //如果没有获取到委托书的默认采样人 则取对应监测类别的 岗位职责数据 if (dt.Rows.Count > 0 && dtDuty.Rows.Count < 1) { for (int i = 0; i < dt.Rows.Count; i++) { TSysDutyVo objDuty = new TSysDutyVo(); objDuty.MONITOR_TYPE_ID = dt.Rows[i]["MONITOR_ID"].ToString(); objDuty.DICT_CODE = "duty_sampling"; DataTable objDutyDt = new TSysDutyLogic().GetDutyUser(objDuty); DataRow drr = null; if (objDutyDt.Rows.Count > 0) { //如果设置了默认负责人,则取默认负责人 DataRow[] drArr = objDutyDt.Select(" IF_DEFAULT='0'"); if (drArr.Length > 0) { drr = drArr[0]; } else { //如果未设置默认负责人,则取第一行数据 drr = objDutyDt.Rows[0]; } if (drr != null) { TMisMonitorSubtaskVo objUpSubTask = new TMisMonitorSubtaskVo(); objUpSubTask.ID = dt.Rows[i]["ID"].ToString(); objUpSubTask.SAMPLING_MANAGER_ID = drr["USERID"].ToString(); new TMisMonitorSubtaskLogic().Edit(objUpSubTask); } } } } if (dt.Rows.Count > 0 && dtDuty.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { foreach (DataRow drr in dtDuty.Rows) { if (dr["MONITOR_ID"].ToString() == drr["MONITOR_TYPE_ID"].ToString()) { TMisMonitorSubtaskVo objUpSubTask = new TMisMonitorSubtaskVo(); objUpSubTask.ID = dr["ID"].ToString(); objUpSubTask.SAMPLING_MANAGER_ID = drr["SAMPLING_MANAGER_ID"].ToString(); new TMisMonitorSubtaskLogic().Edit(objUpSubTask); } } } } } }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tSysDuty">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TSysDutyVo tSysDuty) { string strSQL = "select Count(*) from T_SYS_DUTY " + this.BuildWhereStatement(tSysDuty); return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL))); }
public static bool InsertSelectedUser(string strUserId, string strMonitor, string strDutyType, string strMoveUserId) { bool result = false; string[] strUerArr = null, strMoveUserArr = null; TSysDutyVo objtd = new TSysDutyVo(); objtd.MONITOR_TYPE_ID = strMonitor; objtd.DICT_CODE = strDutyType; strUerArr = strUserId.Split(';'); strMoveUserArr = strMoveUserId.Split(';'); //如果存在岗位配置,则直接插入用户岗位表 DataTable dt = new DataTable(); dt = new TSysDutyLogic().SelectByTable(objtd); if (strMoveUserArr != null && strUerArr != null) { //如果要删除的 存在,则先进行删除,然后再进行添加 if (new TSysUserDutyLogic().DeleteUserMonitorSet(strMoveUserArr, strMonitor, strDutyType)) { if (dt.Rows.Count > 0) { if (new TSysUserDutyLogic().InsertSelectedUser(strUerArr, dt.Rows[0]["ID"].ToString())) { result = true; } } else { objtd.ID = GetSerialNumber("duty_set_infor"); if (new TSysDutyLogic().Create(objtd)) { if (new TSysUserDutyLogic().InsertSelectedUser(strUerArr, objtd.ID)) { result = true; } } } } } //如果删除的不存在,则直接进行添加操作 if (strMoveUserId == null && strUerArr != null) { if (dt.Rows.Count > 0) { if (new TSysUserDutyLogic().InsertSelectedUser(strUerArr, dt.Rows[0]["ID"].ToString())) { result = true; } } else { objtd.ID = GetSerialNumber("duty_set_infor"); if (new TSysDutyLogic().Create(objtd)) { if (new TSysUserDutyLogic().InsertSelectedUser(strUerArr, objtd.ID)) { result = true; } } } } return(result); }
/// <summary> /// 根据对象构造条件语句 /// </summary> /// <param name="tSysDuty"></param> /// <returns></returns> public string BuildWhereStatement(TSysDutyVo tSysDuty) { StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 "); if (null != tSysDuty) { //ID if (!String.IsNullOrEmpty(tSysDuty.ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ID = '{0}'", tSysDuty.ID.ToString())); } //监测类别ID if (!String.IsNullOrEmpty(tSysDuty.MONITOR_TYPE_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MONITOR_TYPE_ID = '{0}'", tSysDuty.MONITOR_TYPE_ID.ToString())); } //监测项目ID if (!String.IsNullOrEmpty(tSysDuty.MONITOR_ITEM_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MONITOR_ITEM_ID = '{0}'", tSysDuty.MONITOR_ITEM_ID.ToString())); } //岗位职责编码(字典项目获取) if (!String.IsNullOrEmpty(tSysDuty.DICT_CODE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND DICT_CODE = '{0}'", tSysDuty.DICT_CODE.ToString())); } //所有者 if (!String.IsNullOrEmpty(tSysDuty.OWNER.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND OWNER = '{0}'", tSysDuty.OWNER.ToString())); } //备注 if (!String.IsNullOrEmpty(tSysDuty.REMARK.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK = '{0}'", tSysDuty.REMARK.ToString())); } //备注1 if (!String.IsNullOrEmpty(tSysDuty.REMARK1.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tSysDuty.REMARK1.ToString())); } //备注2 if (!String.IsNullOrEmpty(tSysDuty.REMARK2.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tSysDuty.REMARK2.ToString())); } //备注3 if (!String.IsNullOrEmpty(tSysDuty.REMARK3.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tSysDuty.REMARK3.ToString())); } //备注4 if (!String.IsNullOrEmpty(tSysDuty.REMARK4.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tSysDuty.REMARK4.ToString())); } //备注5 if (!String.IsNullOrEmpty(tSysDuty.REMARK5.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tSysDuty.REMARK5.ToString())); } } return(strWhereStatement.ToString()); }
/// <summary> /// 加载采样类岗位设置人员列表 /// </summary> /// <param name="strMonitor"></param> /// <param name="strDutyType"></param> /// <param name="iIndex"></param> /// <param name="iCount"></param> /// <returns></returns> public string LoadSetUserList(string strMonitor, string strDutyType, int iIndex, int iCount) { string reslut = ""; dt = new DataTable(); TSysDutyVo objItems = new TSysDutyVo(); objItems.MONITOR_TYPE_ID = strMonitor; objItems.DICT_CODE = strDutyType; dt = new TSysDutyLogic().SelectByUnionTable(objItems, iIndex, iCount); int intCount = new TSysDutyLogic().GetSelectByUnionResultCount(objItems); //TSysUserVo objVo = new TSysUserVo(); //objVo.IS_DEL = "0"; //objVo.IS_USE = "1"; //objVo.IS_HIDE = "0"; //dt = new TSysUserLogic().SelectByTable(objVo, iIndex, iCount); //int intCount = new TSysUserLogic().GetSelectResultCount(objVo); //DataTable dtnew = new DataTable(); //dtnew = new TSysUserDutyLogic().GetSamplingSetUser(strMonitor, strDutyType); //dt.Columns.Add(new DataColumn("IF_DEFAULT", typeof(string))); //dt.Columns.Add(new DataColumn("IF_DEFAULT_EX", typeof(string))); //dt.Columns.Add(new DataColumn("ISEXIST", typeof(string))); //if (!String.IsNullOrEmpty(strMonitor)) //{ // if (dtnew.Rows.Count > 0) // { // for (int i = 0; i < dt.Rows.Count; i++) // { // foreach (DataRow dr in dtnew.Rows) // { // if (dt.Rows[i]["ID"].ToString() == dr["USERID"].ToString()) // { // dt.Rows[i]["IF_DEFAULT"] = dr["IF_DEFAULT"].ToString(); // dt.Rows[i]["IF_DEFAULT_EX"] = dr["IF_DEFAULT_EX"].ToString(); // dt.Rows[i]["ISEXIST"] = "True"; // } // } // } // dt.AcceptChanges(); // DataRow[] drr = dt.Select("ISEXIST='True'"); // DataTable dtTemp = dt.Copy(); // dtTemp.Clear(); // foreach (DataRow ddr in drr) // { // dtTemp.ImportRow(ddr); // } // dt.Clear(); // dt = dtTemp.Copy(); // } // else // { // dt.Clear(); // } //} //else //{ // dt.Clear(); //} //intCount = dt.Rows.Count; reslut = LigerGridDataToJson(dt, intCount); return(reslut); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tSysDuty">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TSysDutyVo> SelectByObject(TSysDutyVo tSysDuty, int iIndex, int iCount) { string strSQL = String.Format("select * from T_SYS_DUTY " + this.BuildWhereStatement(tSysDuty)); return(SqlHelper.ExecuteObjectList(tSysDuty, BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 根据对象特征获取单一对象 /// </summary> /// <param name="tSysDuty">对象</param> /// <returns></returns> public TSysDutyVo SelectByObject(TSysDutyVo tSysDuty) { string strSQL = "select * from T_SYS_DUTY " + this.BuildWhereStatement(tSysDuty); return(SqlHelper.ExecuteObject(new TSysDutyVo(), strSQL)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tSysDuty"></param> /// <returns></returns> public DataTable SelectByTable(TSysDutyVo tSysDuty) { string strSQL = "select * from T_SYS_DUTY " + this.BuildWhereStatement(tSysDuty); return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="tSysDuty">对象</param> /// <returns>是否成功</returns> public bool Create(TSysDutyVo tSysDuty) { string strSQL = SqlHelper.BuildInsertExpress(tSysDuty, TSysDutyVo.T_SYS_DUTY_TABLE); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }