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