/// <summary> /// 对象编辑 /// </summary> /// <param name="tMisMonitorProcessMgm">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TMisMonitorProcessMgmVo tMisMonitorProcessMgm) { string strSQL = SqlHelper.BuildUpdateExpress(tMisMonitorProcessMgm, TMisMonitorProcessMgmVo.T_MIS_MONITOR_PROCESS_MGM_TABLE); strSQL += string.Format(" where TASK_ID='{0}' and MONITOR_TYPE='{1}' ", tMisMonitorProcessMgm.TASK_ID, tMisMonitorProcessMgm.MONITOR_TYPE); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 根据对象构造条件语句 /// </summary> /// <param name="tMisMonitorProcessMgm"></param> /// <returns></returns> public string BuildWhereStatement(TMisMonitorProcessMgmVo tMisMonitorProcessMgm) { StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 "); if (null != tMisMonitorProcessMgm) { // if (!String.IsNullOrEmpty(tMisMonitorProcessMgm.ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND ID = '{0}'", tMisMonitorProcessMgm.ID.ToString())); } // if (!String.IsNullOrEmpty(tMisMonitorProcessMgm.TASK_ID.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND TASK_ID = '{0}'", tMisMonitorProcessMgm.TASK_ID.ToString())); } // if (!String.IsNullOrEmpty(tMisMonitorProcessMgm.MONITOR_TYPE.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MONITOR_TYPE = '{0}'", tMisMonitorProcessMgm.MONITOR_TYPE.ToString())); } // if (!String.IsNullOrEmpty(tMisMonitorProcessMgm.MONITOR_TIME_START.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MONITOR_TIME_START = '{0}'", tMisMonitorProcessMgm.MONITOR_TIME_START.ToString())); } // if (!String.IsNullOrEmpty(tMisMonitorProcessMgm.MONITOR_TIME_FINISH.ToString().Trim())) { strWhereStatement.Append(string.Format(" AND MONITOR_TIME_FINISH = '{0}'", tMisMonitorProcessMgm.MONITOR_TIME_FINISH.ToString())); } } return(strWhereStatement.ToString()); }
// 用户手动调整时间后,数据更新 public void saveDate(string strPlanId, string strNodeName, string strStartTime, string strFinishTime, string strStartMofified) { TMisMonitorProcessMgmLogic objLogic = new TMisMonitorProcessMgmLogic(); TMisMonitorProcessMgmVo objVo = new TMisMonitorProcessMgmVo(); int i = 0; for (; i < arrTaskName.Length; i++) { if (strNodeName == arrTaskName[i]) { break; } } if (i == arrTaskName.Length) { // 没有找到该节点的配置信息,应该是前台传过来的参数不对 return; } // 任务开始时间更新,结束时间自动更新 if ("true" == strStartMofified) { strFinishTime = GetNextNDate(strStartTime, arrTaskValue[i]); } // 更新本节点信息 objVo.TASK_ID = strPlanId; objVo.MONITOR_TYPE = strNodeName; objVo.MONITOR_TIME_START = strStartTime; objVo.MONITOR_TIME_FINISH = strFinishTime; objLogic.Edit(objVo); // 更新后续节点的信息 string strFlowingNodeStart = strFinishTime; if (0 == i) { //任务总体时间更新,各节点不自动更新 return; } ++i; for (; i < arrTaskName.Length; i++) { objVo.Init(); objVo.TASK_ID = strPlanId; objVo.MONITOR_TYPE = arrTaskName[i]; objVo.MONITOR_TIME_START = strFlowingNodeStart; objVo.MONITOR_TIME_FINISH = GetNextNDate(strFlowingNodeStart, arrTaskValue[i]); objLogic.Edit(objVo); strFlowingNodeStart = objVo.MONITOR_TIME_FINISH; } }
private int getNodeTimeFrmDB(string strPlanId, string strNodeType, ref string strStartTime, ref string strFinishTime) { strStartTime = ""; strFinishTime = ""; TMisMonitorProcessMgmLogic objLogic = new TMisMonitorProcessMgmLogic(); TMisMonitorProcessMgmVo objVo = new TMisMonitorProcessMgmVo(); objVo.TASK_ID = strPlanId; DataTable dt = objLogic.SelectByTable(objVo); for (int i = 0; i < dt.Rows.Count; i++) { string strTmpNodeType = dt.Rows[i]["MONITOR_TYPE"].ToString().Trim(); if (strTmpNodeType == strNodeType) { strStartTime = dt.Rows[i]["MONITOR_TIME_START"].ToString().Trim(); strFinishTime = dt.Rows[i]["MONITOR_TIME_FINISH"].ToString().Trim(); return(0); } } return(1); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tMisMonitorProcessMgm">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TMisMonitorProcessMgmVo tMisMonitorProcessMgm, int iIndex, int iCount) { string strSQL = " select * from T_MIS_MONITOR_PROCESS_MGM {0} "; strSQL = String.Format(strSQL, BuildWhereStatement(tMisMonitorProcessMgm)); return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount))); }
private static void GetBusniessStartAndEndTime(string userNo, string url, string workID, string fid, string pWorkID, out string businessStartTime, out string businessEndTime) { businessStartTime = ""; businessEndTime = ""; var requestParams = url.Split(new string[] { "&", "?" }, StringSplitOptions.RemoveEmptyEntries); var mgmType = ""; foreach (var param in requestParams) { if (param.ToLower().StartsWith("mgmtype")) { mgmType = param.Split('=')[1].Trim(); break; } } if (mgmType == "") { return; } var ccflowID = ""; if (!string.IsNullOrEmpty(pWorkID) && pWorkID != "0") { ccflowID = GetFatherIDOfSubFlow(userNo, Convert.ToInt64(workID)).ToString(); } else if (!string.IsNullOrEmpty(fid) && fid != "0") { ccflowID = fid; } else { ccflowID = workID; } TMisMonitorProcessMgmLogic objLogic = new TMisMonitorProcessMgmLogic(); TMisMonitorProcessMgmVo objVo = objLogic.DetailsByCCFlowIDAndType(ccflowID, mgmType); if (objVo.ID != "") { businessStartTime = objVo.MONITOR_TIME_START; businessEndTime = objVo.MONITOR_TIME_FINISH; } }
// 首次调用此表单需要创建数据 public void createDate(string strPlanId) { TMisMonitorProcessMgmLogic objLogic = new TMisMonitorProcessMgmLogic(); TMisMonitorProcessMgmVo objVo = new TMisMonitorProcessMgmVo(); objVo.TASK_ID = strPlanId; DataTable dt = objLogic.SelectByTable(objVo); // 第2+次加载此页面时,不用重复创建信息 if (0 != dt.Rows.Count) { return; } for (int i = 0; i < arrTaskName.Length; i++) { objVo.Init(); objVo.TASK_ID = strPlanId; objVo.ID = i3.View.PageBase.GetSerialNumber("t_mis_process_mgm_id"); string strNodeName = arrTaskName[i]; string strStartTime = ""; string strFinishTime = ""; GetNodeDate(strNodeName, ref strStartTime, ref strFinishTime); objVo.MONITOR_TIME_START = strStartTime; objVo.MONITOR_TIME_FINISH = strFinishTime; objVo.MONITOR_TYPE = strNodeName; objLogic.Create(objVo); } return; }
/// <summary> /// 获取对象List /// </summary> /// <param name="tMisMonitorProcessMgm">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TMisMonitorProcessMgmVo> SelectByObject(TMisMonitorProcessMgmVo tMisMonitorProcessMgm, int iIndex, int iCount) { return(access.SelectByObject(tMisMonitorProcessMgm, iIndex, iCount)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tMisMonitorProcessMgm">对象条件</param> /// <returns>对象</returns> public TMisMonitorProcessMgmVo Details(TMisMonitorProcessMgmVo tMisMonitorProcessMgm) { string strSQL = String.Format("select * from T_MIS_MONITOR_PROCESS_MGM " + this.BuildWhereStatement(tMisMonitorProcessMgm)); return(SqlHelper.ExecuteObject(new TMisMonitorProcessMgmVo(), strSQL)); }
/// <summary> /// 获取对象List /// </summary> /// <param name="tMisMonitorProcessMgm">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public List <TMisMonitorProcessMgmVo> SelectByObject(TMisMonitorProcessMgmVo tMisMonitorProcessMgm, int iIndex, int iCount) { string strSQL = String.Format("select * from T_MIS_MONITOR_PROCESS_MGM " + this.BuildWhereStatement(tMisMonitorProcessMgm)); return(SqlHelper.ExecuteObjectList(tMisMonitorProcessMgm, BuildPagerExpress(strSQL, iIndex, iCount))); }
/// <summary> /// 根据对象特征获取单一对象 /// </summary> /// <param name="tMisMonitorProcessMgm">对象</param> /// <returns></returns> public TMisMonitorProcessMgmVo SelectByObject(TMisMonitorProcessMgmVo tMisMonitorProcessMgm) { return(access.SelectByObject(tMisMonitorProcessMgm)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tMisMonitorProcessMgm">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TMisMonitorProcessMgmVo tMisMonitorProcessMgm) { string strSQL = "select Count(*) from T_MIS_MONITOR_PROCESS_MGM " + this.BuildWhereStatement(tMisMonitorProcessMgm); return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL))); }
/// <summary> /// 对象添加 /// </summary> /// <param name="sysRole">对象</param> /// <returns>是否成功</returns> public bool Create(TMisMonitorProcessMgmVo tMisMonitorProcessMgm) { return(access.Create(tMisMonitorProcessMgm)); }
/// <summary> /// 获取集合 /// </summary> /// <param name="model">条件实体</param> /// <returns></returns> public List <TMisMonitorProcessMgmVo> SelectByList(TMisMonitorProcessMgmVo model) { string strSql = string.Format("select * from T_MIS_MONITOR_PROCESS_MGM {0}", this.BuildWhereStatement(model)); return(SqlHelper.ExecuteObjectList(new TMisMonitorProcessMgmVo(), strSql)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tMisMonitorProcessMgm"></param> /// <returns></returns> public DataTable SelectByTable(TMisMonitorProcessMgmVo tMisMonitorProcessMgm) { string strSQL = "select * from T_MIS_MONITOR_PROCESS_MGM " + this.BuildWhereStatement(tMisMonitorProcessMgm) + " order by ID"; return(SqlHelper.ExecuteDataTable(strSQL)); }
/// <summary> /// 对象添加 /// </summary> /// <param name="tMisMonitorProcessMgm">对象</param> /// <returns>是否成功</returns> public bool Create(TMisMonitorProcessMgmVo tMisMonitorProcessMgm) { string strSQL = SqlHelper.BuildInsertExpress(tMisMonitorProcessMgm, TMisMonitorProcessMgmVo.T_MIS_MONITOR_PROCESS_MGM_TABLE); return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false); }
/// <summary> /// 获取对象DataTable /// </summary> /// <param name="tMisMonitorProcessMgm">对象</param> /// <param name="iIndex">起始页码</param> /// <param name="iCount">每页数目</param> /// <returns>返回结果</returns> public DataTable SelectByTable(TMisMonitorProcessMgmVo tMisMonitorProcessMgm, int iIndex, int iCount) { return(access.SelectByTable(tMisMonitorProcessMgm, iIndex, iCount)); }
/// <summary> /// 根据对象获取全部数据,用Table承载 /// 数据量较小时使用【不推荐】 /// </summary> /// <param name="tMisMonitorProcessMgm"></param> /// <returns></returns> public DataTable SelectByTable(TMisMonitorProcessMgmVo tMisMonitorProcessMgm) { return(access.SelectByTable(tMisMonitorProcessMgm)); }
/// <summary> /// 对象编辑 /// </summary> /// <param name="tMisMonitorProcessMgm">用户对象</param> /// <returns>是否成功</returns> public bool Edit(TMisMonitorProcessMgmVo tMisMonitorProcessMgm) { return(access.Edit(tMisMonitorProcessMgm)); }
/// <summary> /// 对象明细 /// </summary> /// <param name="tMisMonitorProcessMgm">对象条件</param> /// <returns>对象</returns> public TMisMonitorProcessMgmVo Details(TMisMonitorProcessMgmVo tMisMonitorProcessMgm) { return(access.Details(tMisMonitorProcessMgm)); }
/// <summary> /// 获得查询结果总行数,用于分页 /// </summary> /// <param name="tMisMonitorProcessMgm">对象</param> /// <returns>返回行数</returns> public int GetSelectResultCount(TMisMonitorProcessMgmVo tMisMonitorProcessMgm) { return(access.GetSelectResultCount(tMisMonitorProcessMgm)); }
public TMisMonitorProcessMgmLogic(TMisMonitorProcessMgmVo _tMisMonitorProcessMgm) { tMisMonitorProcessMgm = _tMisMonitorProcessMgm; access = new TMisMonitorProcessMgmAccess(); }
/// <summary> /// 获取集合 /// </summary> /// <param name="model">条件实体</param> /// <returns></returns> public List <TMisMonitorProcessMgmVo> SelectByList(TMisMonitorProcessMgmVo model) { return(access.SelectByList(model)); }