private static WorkFlowsInfo WorkFlowsFromrdr(NullableDataReader rdr) { WorkFlowsInfo info = new WorkFlowsInfo(); info.FlowId = rdr.GetInt32("FlowId"); info.FlowName = rdr.GetString("FlowName"); info.Description = rdr.GetString("Description"); return(info); }
public bool Add(WorkFlowsInfo workFlowsInfo) { Parameters cmdParams = new Parameters(); cmdParams.AddInParameter("@FlowID", DbType.Int32, this.GetMaxId() + 1); cmdParams.AddInParameter("@FlowName", DbType.String, workFlowsInfo.FlowName); cmdParams.AddInParameter("@Description", DbType.String, workFlowsInfo.Description); string strSql = "INSERT INTO PE_WorkFlows(FlowID, FlowName, Description) VALUES (@FlowID, @FlowName, @Description)"; return(DBHelper.ExecuteSql(strSql, cmdParams)); }
public bool Update(WorkFlowsInfo workFlowsInfo) { Parameters cmdParams = new Parameters(); cmdParams.AddInParameter("@FlowId", DbType.Int32, workFlowsInfo.FlowId); cmdParams.AddInParameter("@FlowName", DbType.String, workFlowsInfo.FlowName); cmdParams.AddInParameter("@Description", DbType.String, workFlowsInfo.Description); string strSql = "UPDATE PE_WorkFlows SET FlowName = @FlowName, Description = @Description WHERE FlowId = @FlowId"; return(DBHelper.ExecuteSql(strSql, cmdParams)); }
public static bool Copy(int flowId) { bool flag = false; WorkFlowsInfo workFlowsById = new WorkFlowsInfo(); WorkFlowsInfo workFlowsInfo = new WorkFlowsInfo(); workFlowsById = GetWorkFlowsById(flowId); workFlowsInfo.FlowId = GetMaxId() + 1; workFlowsInfo.FlowName = workFlowsById.FlowName + "复制"; workFlowsInfo.Description = workFlowsById.Description; if (!Add(workFlowsInfo)) { return(flag); } string str = ""; IList <FlowProcessInfo> flowProcessList = FlowProcess.GetFlowProcessList(flowId); for (int i = 0; i < flowProcessList.Count; i++) { FlowProcessInfo flowProcessInfo = new FlowProcessInfo(); flowProcessInfo.FlowId = workFlowsInfo.FlowId; flowProcessInfo.Description = flowProcessList[i].Description; flowProcessInfo.PassActionName = flowProcessList[i].PassActionName; flowProcessInfo.PassActionStatus = flowProcessList[i].PassActionStatus; flowProcessInfo.ProcessId = flowProcessList[i].ProcessId; flowProcessInfo.ProcessName = flowProcessList[i].ProcessName; flowProcessInfo.RejectActionName = flowProcessList[i].RejectActionName; flowProcessInfo.RejectActionStatus = flowProcessList[i].RejectActionStatus; IList <StatusInfo> processStatusCodeList = FlowProcess.GetProcessStatusCodeList(flowProcessList[i].FlowId, flowProcessList[i].ProcessId); StringBuilder sb = new StringBuilder(); for (int j = 0; j < processStatusCodeList.Count; j++) { StringHelper.AppendString(sb, processStatusCodeList[j].StatusCode.ToString()); } IList <RoleInfo> processRoleList = FlowProcess.GetProcessRoleList(flowProcessList[i].FlowId, flowProcessList[i].ProcessId); for (int k = 0; k < processRoleList.Count; k++) { if (string.IsNullOrEmpty(str)) { str = processRoleList[k].RoleId.ToString(); } else { str = str + "," + processRoleList[k].RoleId; } } if (!FlowProcess.Add(flowProcessInfo, sb.ToString(), str)) { break; } } return(true); }
protected void Page_Load(object sender, EventArgs e) { if (!this.Page.IsPostBack) { string str = BasePage.RequestString("Action", "Add"); if (str == "Modify") { WorkFlowsInfo workFlowsById = WorkFlow.GetWorkFlowsById(BasePage.RequestInt32("FlowID")); if (!workFlowsById.IsNull) { this.TxtFlowName.Text = workFlowsById.FlowName; this.TxtDescription.Text = workFlowsById.Description; this.HdnAction.Value = str; this.HdnFlowName.Value = workFlowsById.FlowName.ToString(); } } } }
protected void EBtnSubmit_Click(object sender, EventArgs e) { if (this.Page.IsValid) { bool flag = false; bool flag2 = false; WorkFlowsInfo workFlowsInfo = new WorkFlowsInfo(); if (this.HdnAction.Value == "Modify") { workFlowsInfo.FlowId = BasePage.RequestInt32("FlowID"); } workFlowsInfo.FlowName = this.TxtFlowName.Text; workFlowsInfo.Description = this.TxtDescription.Text; string text = this.TxtFlowName.Text; if ((this.HdnAction.Value == "Modify") && (text == this.HdnFlowName.Value)) { flag = false; } else if (WorkFlow.Exists(text)) { AdminPage.WriteErrMsg("<li>系统已经有此流程名称,请返回重新填写流程名称!</li>"); } if (!flag) { if (this.HdnAction.Value == "Modify") { flag2 = WorkFlow.Update(workFlowsInfo); } else { flag2 = WorkFlow.Add(workFlowsInfo); } if (flag2) { base.Response.Write("<script type='text/javascript'>parent.frames[\"left\"].location.reload();</script>"); AdminPage.WriteSuccessMsg("<li>保存流程数据成功!</li>", "WorkFlowsManage.aspx"); } else { AdminPage.WriteErrMsg("<li>保存流程数据失败!</li>"); } } } }
public static bool Add(WorkFlowsInfo workFlowsInfo) { return(dal.Add(workFlowsInfo)); }
public static bool Update(WorkFlowsInfo workFlowsInfo) { return(dal.Update(workFlowsInfo)); }