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