/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tWfSettingTaskCmd_UpdateSet">UpdateSet用户对象</param>
/// <param name="tWfSettingTaskCmd_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TWfSettingTaskCmdVo tWfSettingTaskCmd_UpdateSet, TWfSettingTaskCmdVo tWfSettingTaskCmd_UpdateWhere)
{
string strSQL = SqlHelper.BuildUpdateExpress(tWfSettingTaskCmd_UpdateSet, TWfSettingTaskCmdVo.T_WF_SETTING_TASK_CMD_TABLE);
strSQL += this.BuildWhereStatement(tWfSettingTaskCmd_UpdateWhere);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tWfSettingTaskCmd">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TWfSettingTaskCmdVo tWfSettingTaskCmd)
{
string strSQL = SqlHelper.BuildUpdateExpress(tWfSettingTaskCmd, TWfSettingTaskCmdVo.T_WF_SETTING_TASK_CMD_TABLE);
strSQL += string.Format(" where ID='{0}' ", tWfSettingTaskCmd.ID);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tWfSettingTaskCmd">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TWfSettingTaskCmdVo tWfSettingTaskCmd, int iIndex, int iCount)
{
string strSQL = " select * from T_WF_SETTING_TASK_CMD {0} ";
strSQL = String.Format(strSQL, BuildWhereStatement(tWfSettingTaskCmd));
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TWfSettingTaskCmdVo tWfSettingTaskCmd)
{
string strSQL = "delete from T_WF_SETTING_TASK_CMD ";
strSQL += this.BuildWhereStatement(tWfSettingTaskCmd);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 根据对象构造条件语句
/// </summary>
/// <param name="tWfSettingTaskCmd"></param>
/// <returns></returns>
public string BuildWhereStatement(TWfSettingTaskCmdVo tWfSettingTaskCmd)
{
StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 ");
if (null != tWfSettingTaskCmd)
{
//编号
if (!String.IsNullOrEmpty(tWfSettingTaskCmd.ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ID = '{0}'", tWfSettingTaskCmd.ID.ToString()));
}
//命令编号
if (!String.IsNullOrEmpty(tWfSettingTaskCmd.WF_CMD_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND WF_CMD_ID = '{0}'", tWfSettingTaskCmd.WF_CMD_ID.ToString()));
}
//流程编号
if (!String.IsNullOrEmpty(tWfSettingTaskCmd.WF_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND WF_ID = '{0}'", tWfSettingTaskCmd.WF_ID.ToString()));
}
//节点编号
if (!String.IsNullOrEmpty(tWfSettingTaskCmd.WF_TASK_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND WF_TASK_ID = '{0}'", tWfSettingTaskCmd.WF_TASK_ID.ToString()));
}
//命令名称
if (!String.IsNullOrEmpty(tWfSettingTaskCmd.CMD_NAME.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CMD_NAME = '{0}'", tWfSettingTaskCmd.CMD_NAME.ToString()));
}
//命令描述
if (!String.IsNullOrEmpty(tWfSettingTaskCmd.CMD_NOTE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CMD_NOTE = '{0}'", tWfSettingTaskCmd.CMD_NOTE.ToString()));
}
}
return(strWhereStatement.ToString());
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tWfSettingTaskCmd">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TWfSettingTaskCmdVo tWfSettingTaskCmd)
{
return(access.Edit(tWfSettingTaskCmd));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="sysRole">对象</param>
/// <returns>是否成功</returns>
public bool Create(TWfSettingTaskCmdVo tWfSettingTaskCmd)
{
return(access.Create(tWfSettingTaskCmd));
}
/// <summary>
/// 根据对象特征获取单一对象
/// </summary>
/// <param name="tWfSettingTaskCmd">对象</param>
/// <returns></returns>
public TWfSettingTaskCmdVo SelectByObject(TWfSettingTaskCmdVo tWfSettingTaskCmd)
{
return(access.SelectByObject(tWfSettingTaskCmd));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="tWfSettingTaskCmd">对象</param>
/// <returns>是否成功</returns>
public bool Create(TWfSettingTaskCmdVo tWfSettingTaskCmd)
{
string strSQL = SqlHelper.BuildInsertExpress(tWfSettingTaskCmd, TWfSettingTaskCmdVo.T_WF_SETTING_TASK_CMD_TABLE);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tWfSettingTaskCmd">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TWfSettingTaskCmdVo tWfSettingTaskCmd, int iIndex, int iCount)
{
return(access.SelectByTable(tWfSettingTaskCmd, iIndex, iCount));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tWfSettingTaskCmd">对象条件</param>
/// <returns>对象</returns>
public TWfSettingTaskCmdVo Details(TWfSettingTaskCmdVo tWfSettingTaskCmd)
{
return(access.Details(tWfSettingTaskCmd));
}
public TWfSettingTaskCmdLogic(TWfSettingTaskCmdVo _tWfSettingTaskCmd)
{
tWfSettingTaskCmd = _tWfSettingTaskCmd;
access = new TWfSettingTaskCmdAccess();
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tWfSettingTaskCmd">对象条件</param>
/// <returns>对象</returns>
public TWfSettingTaskCmdVo Details(TWfSettingTaskCmdVo tWfSettingTaskCmd)
{
string strSQL = String.Format("select * from T_WF_SETTING_TASK_CMD " + this.BuildWhereStatement(tWfSettingTaskCmd));
return(SqlHelper.ExecuteObject(new TWfSettingTaskCmdVo(), strSQL));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tWfSettingTaskCmd">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TWfSettingTaskCmdVo tWfSettingTaskCmd)
{
string strSQL = "select Count(*) from T_WF_SETTING_TASK_CMD " + this.BuildWhereStatement(tWfSettingTaskCmd);
return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL)));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tWfSettingTaskCmd_UpdateSet">UpdateSet用户对象</param>
/// <param name="tWfSettingTaskCmd_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TWfSettingTaskCmdVo tWfSettingTaskCmd_UpdateSet, TWfSettingTaskCmdVo tWfSettingTaskCmd_UpdateWhere)
{
return(access.Edit(tWfSettingTaskCmd_UpdateSet, tWfSettingTaskCmd_UpdateWhere));
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TWfSettingTaskCmdVo tWfSettingTaskCmd)
{
return(access.Delete(tWfSettingTaskCmd));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tWfSettingTaskCmd">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TWfSettingTaskCmdVo> SelectByObject(TWfSettingTaskCmdVo tWfSettingTaskCmd, int iIndex, int iCount)
{
string strSQL = String.Format("select * from T_WF_SETTING_TASK_CMD " + this.BuildWhereStatement(tWfSettingTaskCmd));
return(SqlHelper.ExecuteObjectList(tWfSettingTaskCmd, BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tWfSettingTaskCmd">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TWfSettingTaskCmdVo tWfSettingTaskCmd)
{
return(access.GetSelectResultCount(tWfSettingTaskCmd));
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tWfSettingTaskCmd"></param>
/// <returns></returns>
public DataTable SelectByTable(TWfSettingTaskCmdVo tWfSettingTaskCmd)
{
string strSQL = "select * from T_WF_SETTING_TASK_CMD " + this.BuildWhereStatement(tWfSettingTaskCmd);
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tWfSettingTaskCmd">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TWfSettingTaskCmdVo> SelectByObject(TWfSettingTaskCmdVo tWfSettingTaskCmd, int iIndex, int iCount)
{
return(access.SelectByObject(tWfSettingTaskCmd, iIndex, iCount));
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strTips = ValidateData();
if (!string.IsNullOrEmpty(strTips))
{
Alert(strTips);
return;
}
//构建节点记录
TWfSettingTaskVo setStep = new TWfSettingTaskVo();
BindControlsToObjectMode(setStep);
setStep.WF_ID = WF_ID.Value;
setStep.WF_TASK_ID = WF_TASK_ID.Value == "" ? this.GetGUID() : WF_TASK_ID.Value;
setStep.ID = setStep.WF_TASK_ID;
setStep.TASK_AND_OR = rdbtnlstAndOr.SelectedValue;
//暂时指定为01，后续扩展
setStep.TASK_TYPE = "01";
setStep.OPER_TYPE = rdbtnlstOperType.SelectedValue;
//构建操作人类型和数值
foreach (ListItem li in lsbStep.Items)
{
setStep.OPER_VALUE += li.Value + "|";
}
//构建排序的数值
//构建附加功能值
foreach (ListItem li in ckbxlstPowerList.Items)
{
if (li.Selected)
{
setStep.FUNCTION_LIST += li.Value + "|";
}
}
//如果是空，则说明不附加任何功能，直接置空
setStep.FUNCTION_LIST = setStep.FUNCTION_LIST == "" ? "###" : setStep.FUNCTION_LIST;
//构建节点命令集合
List <TWfSettingTaskCmdVo> cmdSetpList = new List <TWfSettingTaskCmdVo>();
foreach (ListItem li in ckbxlstCMDList.Items)
{
if (li.Selected)
{
TWfSettingTaskCmdVo cmdTemp = new TWfSettingTaskCmdVo();
cmdTemp.ID = this.GetGUID();
cmdTemp.WF_CMD_ID = cmdTemp.ID;
cmdTemp.WF_ID = WF_ID.Value;
cmdTemp.WF_TASK_ID = setStep.WF_TASK_ID;
cmdTemp.CMD_NAME = li.Value;
cmdTemp.CMD_NOTE = li.Text;
cmdSetpList.Add(cmdTemp);
//在节点表中存储一个字符串
setStep.COMMAND_NAME += cmdTemp.CMD_NAME + "|";
}
}
//构建节点表单页面记录
TWfSettingTaskFormVo formStep = new TWfSettingTaskFormVo();
formStep.WF_ID = setStep.WF_ID;
formStep.WF_TASK_ID = setStep.WF_TASK_ID;
formStep.ID = this.GetGUID();
formStep.WF_TF_ID = formStep.ID;
formStep.UCM_ID = UCM_ID.Text;
formStep.UCM_TYPE = UCM_TYPE.SelectedValue;
//保存按钮的处理
if (string.IsNullOrEmpty(WF_TASK_ID.Value))
{
//新增
TWfSettingTaskLogic taskLogic = new TWfSettingTaskLogic();
TWfSettingTaskCmdLogic cmdLogic = new TWfSettingTaskCmdLogic();
TWfSettingTaskFormLogic formLogic = new TWfSettingTaskFormLogic();
//新增是构建 TASK_ORDER
setStep.TASK_ORDER = (taskLogic.GetSelectResultCount(new TWfSettingTaskVo()
{
WF_ID = setStep.WF_ID
}) + 1).ToString();
bool bIsSucess = taskLogic.Create(setStep);
if (bIsSucess)
{
cmdLogic.Create(cmdSetpList);
formLogic.Create(formStep);
}
this.Alert("添加成功");
//日志记录
}
else
{
//修改
TWfSettingTaskLogic taskLogic = new TWfSettingTaskLogic();
TWfSettingTaskCmdLogic cmdLogic = new TWfSettingTaskCmdLogic();
TWfSettingTaskFormLogic formLogic = new TWfSettingTaskFormLogic();
bool bIsSucess = taskLogic.Edit(setStep);
if (bIsSucess)
{
cmdLogic.Delete(new TWfSettingTaskCmdVo()
{
WF_TASK_ID = setStep.WF_TASK_ID, WF_ID = setStep.WF_ID
});
cmdLogic.Create(cmdSetpList);
formLogic.Delete(new TWfSettingTaskFormVo()
{
WF_TASK_ID = setStep.WF_TASK_ID, WF_ID = setStep.WF_ID
});
formLogic.Create(formStep);
}
this.Alert("修改成功");
}
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tWfSettingTaskCmd"></param>
/// <returns></returns>
public DataTable SelectByTable(TWfSettingTaskCmdVo tWfSettingTaskCmd)
{
return(access.SelectByTable(tWfSettingTaskCmd));
}
public static string SaveData(string strid, string stWF_ID, string strWF_TASK_ID, string strTASK_CAPTION, string strTASK_NOTE, string strCOMMAND_NAME, string strCOMMAND_NAME_Text,
string strFUNCTION_LIST, string strTASK_AND_OR, string strPOSITION_IX, string strPOSITION_IY, string strOPER_VALUE)
{
bool isSuccess = true;
//构建节点记录
TWfSettingTaskVo setStep = new TWfSettingTaskVo();
setStep.WF_ID = stWF_ID;
setStep.WF_TASK_ID = strWF_TASK_ID == "0" ? new PageBaseForWF().GetGUID() : strWF_TASK_ID;
setStep.ID = strid == "0" ? setStep.WF_TASK_ID : strid;
setStep.TASK_CAPTION = strTASK_CAPTION;
setStep.TASK_NOTE = strTASK_NOTE;
setStep.COMMAND_NAME = strCOMMAND_NAME.Replace(";", "|");
setStep.FUNCTION_LIST = strFUNCTION_LIST.Length == 0 ? "###" : strFUNCTION_LIST.Replace(";", "|");
setStep.TASK_AND_OR = strTASK_AND_OR;
setStep.TASK_TYPE = "01"; //暂时指定为01，后续扩展
setStep.OPER_TYPE = "01"; //暂时指定为用户，屏蔽用户类型“职位”，因为工作流设计无法适应用户、职位同时选的情况
setStep.OPER_VALUE = strOPER_VALUE.Replace(";", "|");
//构建节点命令集合
List <TWfSettingTaskCmdVo> cmdSetpList = new List <TWfSettingTaskCmdVo>();
string[] arrCMDName = strCOMMAND_NAME.Split(';');
string[] arrCMDNameText = strCOMMAND_NAME_Text.Split(';');
for (int i = 0; i < arrCMDName.Length; i++)
{
TWfSettingTaskCmdVo cmdTemp = new TWfSettingTaskCmdVo();
cmdTemp.ID = new PageBaseForWF().GetGUID();
cmdTemp.WF_CMD_ID = cmdTemp.ID;
cmdTemp.WF_ID = stWF_ID;
cmdTemp.WF_TASK_ID = setStep.WF_TASK_ID;
cmdTemp.CMD_NAME = arrCMDName[i];
cmdTemp.CMD_NOTE = arrCMDNameText[i];
cmdSetpList.Add(cmdTemp);
}
//构建节点表单页面记录
TWfSettingTaskFormVo formStep = new TWfSettingTaskFormVo();
formStep.WF_ID = setStep.WF_ID;
formStep.WF_TASK_ID = setStep.WF_TASK_ID;
formStep.ID = new PageBaseForWF().GetGUID();
formStep.WF_TF_ID = formStep.ID;
formStep.UCM_ID = strPOSITION_IY;
formStep.UCM_TYPE = strPOSITION_IX;
TWfSettingTaskLogic taskLogic = new TWfSettingTaskLogic();
TWfSettingTaskCmdLogic cmdLogic = new TWfSettingTaskCmdLogic();
TWfSettingTaskFormLogic formLogic = new TWfSettingTaskFormLogic();
if (strid == "0")
{
//新增是构建 TASK_ORDER
setStep.TASK_ORDER = (taskLogic.GetSelectResultCount(new TWfSettingTaskVo()
{
WF_ID = setStep.WF_ID
}) + 1).ToString();
bool bIsSucess = taskLogic.Create(setStep);
if (bIsSucess)
{
cmdLogic.Create(cmdSetpList);
formLogic.Create(formStep);
}
string strMessage = new PageBase().LogInfo.UserInfo.USER_NAME + "增加环节:" + setStep.WF_TASK_ID + " 成功";
new PageBase().WriteLog("增加环节", "", strMessage);
}
else
{
bool bIsSucess = taskLogic.Edit(setStep);
if (bIsSucess)
{
cmdLogic.Delete(new TWfSettingTaskCmdVo()
{
WF_TASK_ID = setStep.WF_TASK_ID, WF_ID = setStep.WF_ID
});
cmdLogic.Create(cmdSetpList);
formLogic.Delete(new TWfSettingTaskFormVo()
{
WF_TASK_ID = setStep.WF_TASK_ID, WF_ID = setStep.WF_ID
});
formLogic.Create(formStep);
}
string strMessage = new PageBase().LogInfo.UserInfo.USER_NAME + "修改环节:" + setStep.WF_TASK_ID + " 成功";
new PageBase().WriteLog("修改环节", "", strMessage);
}
if (isSuccess)
{
return("1");
}
else
{
return("0");
}
}
