/// <summary> /// 记录审批内容 /// </summary> /// <param name="status">状态</param> private void ProAdd(string status) { #region //添加流程明细 string content = string.Empty; DateTime dt = DateTime.Now; if (!string.IsNullOrEmpty(txtContent.Text)) { content += txtContent.Text + "-(" + ltlUserName.Text + " " + dt.ToString() + ")"; } else { content += status + "—(" + ltlUserName.Text + " " + dt.ToString() + ")"; } Mod_TMB_FLOWPROC modPro = new Mod_TMB_FLOWPROC(); modPro.C_FILE_ID = ltlFileID.Text; modPro.C_STEP_ID = ltlStepID.Text; modPro.C_STEP_EMP_ID = ltlUserID.Text; modPro.C_STEPNOTE = content; modPro.D_STEP_DT = dt; modPro.N_PROCRESULT = 1; Mod_TS_ROLE modRloe = ts_role.GetModel(ltlStepID.Text); modPro.C_REMARK = modRloe.C_NAME; #endregion if (flowproc.Add(modPro)) { WebMsg.MessageBox("提交成功", "WorkFlow_D.aspx"); } }
/// <summary> /// 审批日志 /// </summary> /// <param name="status">处理状态</param> /// <param name="content">批语</param> /// <param name="userName">审批人姓名</param> /// <param name="userID">审批人ID</param> /// <param name="stepID">步骤ID</param> /// <param name="fileID">文件ID</param> /// <returns></returns> private string ProAdd(string status, string content, string userName, string userID, string stepID, string fileID) { #region //添加流程明细 Mod_TMB_FLOWPROC modPro = new Mod_TMB_FLOWPROC(); modPro.C_FILE_ID = fileID; modPro.C_STEP_ID = stepID; modPro.C_STEP_EMP_ID = userID; if (!string.IsNullOrEmpty(content)) { modPro.C_STEPNOTE = content; } else { modPro.C_STEPNOTE = status; } modPro.N_PROCRESULT = status == "批准" ? 1 : 0; Mod_TS_ROLE modRloe = ts_role.GetModel(stepID); modPro.C_REMARK = modRloe.C_NAME; #endregion if (tmb_flowproc.Add(modPro)) { return("提交成功"); } else { return("提交失败"); } }
/// <summary> /// 记录审批内容 /// </summary> /// <param name="status">状态</param> private void ProAdd(string status) { #region //添加流程明细 string content = string.Empty; if (!string.IsNullOrEmpty(txtContent.Text)) { content += txtContent.Text; } else { content += status; } Mod_TMB_FLOWPROC modPro = new Mod_TMB_FLOWPROC(); modPro.C_FILE_ID = ltlFileID.Text; modPro.C_STEP_ID = ltlStepID.Text; modPro.C_STEP_EMP_ID = ltlUserID.Text; modPro.C_STEPNOTE = content; modPro.N_PROCRESULT = status == "批准" ? 1 : 0; Mod_TS_ROLE modRloe = ts_role.GetModel(ltlStepID.Text); modPro.C_REMARK = modRloe.C_NAME; #endregion if (flowproc.Add(modPro)) { WebMsg.MessageBox("提交成功", "WorkFlow_F.aspx"); } }
//退回 protected void btnNo_Click(object sender, EventArgs e) { #region //添加流程明细 string content = string.Empty; DateTime dt = DateTime.Now; if (!string.IsNullOrEmpty(txtContent.Text)) { content += txtContent.Text + "-(" + ltlUserName.Text + " " + dt.ToString() + ")"; } else { content += "退回—(" + ltlUserName.Text + " " + dt.ToString() + ")"; } Mod_TMB_FLOWPROC modPro = new Mod_TMB_FLOWPROC(); modPro.C_FILE_ID = ltlFileID.Text; modPro.C_STEP_ID = ltlStepID.Text; modPro.C_STEP_EMP_ID = ltlUserID.Text; modPro.C_STEPNOTE = content; modPro.D_STEP_DT = dt; modPro.N_PROCRESULT = 1; #endregion if (flowproc.Add(modPro)) //插入流程明细 { con.UpdateCheckEmp(ltlTaskID.Text, ltlUserID.Text, dt); //更新当前审批人/时间 string upStep = flowstep.GetUpStep(ltlFlowID.Text, ltlStepID.Text); //获取上一步骤 if (upStep == "0") //判断是否流程第一步 { if (fileinfo.UpdateStepStatus(upStep, 1, ltlFileID.Text)) //更新文件事务状态为办结 { #region //退回合同 if (con.UpdateConStatus(0, ltlTaskID.Text)) //更新合同状态 { WebMsg.MessageBox("提交成功", "WorkFlow_D.aspx"); } #endregion } } else { if (fileinfo.UpdateStep(upStep, ltlFileID.Text))//更新当前步骤,上一步骤 { WebMsg.MessageBox("提交成功", "WorkFlow_D.aspx"); } } } }
//批准 protected void btnOk_Click(object sender, EventArgs e) { #region //添加流程明细 string content = string.Empty; DateTime dt = DateTime.Now; if (!string.IsNullOrEmpty(txtContent.Text)) { content += txtContent.Text + "-(" + ltlUserName.Text + " " + dt.ToString() + ")"; } else { content += "批准—(" + ltlUserName.Text + " " + dt.ToString() + ")"; } Mod_TMB_FLOWPROC modPro = new Mod_TMB_FLOWPROC(); modPro.C_FILE_ID = ltlFileID.Text; modPro.C_STEP_ID = ltlStepID.Text; modPro.C_STEP_EMP_ID = ltlUserID.Text; modPro.C_STEPNOTE = content; modPro.D_STEP_DT = dt; modPro.N_PROCRESULT = 1; #endregion if (flowproc.Add(modPro)) //插入流程明细 { quality_main.UpdateCheckEmp(ltlTaskID.Text, ltlUserID.Text, dt); //更新当前审批人/时间 string nextStep = flowstep.GetNextStep(ltlFlowID.Text, ltlStepID.Text); //下一处理步骤 if (nextStep == "0") //判断是否流程,最后步骤 { if (fileinfo.UpdateStepStatus(nextStep, 1, ltlFileID.Text)) //更新文件事务状态为办结 { if (quality_main.UpdateStatus(ltlTaskID.Text, "2")) //更新质量主表状态 { WebMsg.MessageBox("提交成功", "WorkFlow_D.aspx"); } } } else { if (fileinfo.UpdateStep(nextStep, ltlFileID.Text))//更新文件事务下一步骤 { WebMsg.MessageBox("提交成功", "WorkFlow_D.aspx"); } } } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TMB_FLOWPROC model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TMB_FLOWPROC set "); strSql.Append("C_FILE_ID=:C_FILE_ID,"); strSql.Append("C_STEP_ID=:C_STEP_ID,"); strSql.Append("C_STEP_EMP_ID=:C_STEP_EMP_ID,"); strSql.Append("C_STEPNOTE=:C_STEPNOTE,"); strSql.Append("D_STEP_DT=:D_STEP_DT,"); strSql.Append("C_NEXT_EMP_ID=:C_NEXT_EMP_ID,"); strSql.Append("N_PROCRESULT=:N_PROCRESULT,"); strSql.Append("C_REMARK=:C_REMARK"); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_FILE_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_STEP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_STEP_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_STEPNOTE", OracleDbType.Varchar2, 500), new OracleParameter(":D_STEP_DT", OracleDbType.Date), new OracleParameter(":C_NEXT_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_PROCRESULT", OracleDbType.Decimal, 1), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200), new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_FILE_ID; parameters[1].Value = model.C_STEP_ID; parameters[2].Value = model.C_STEP_EMP_ID; parameters[3].Value = model.C_STEPNOTE; parameters[4].Value = model.D_STEP_DT; parameters[5].Value = model.C_NEXT_EMP_ID; parameters[6].Value = model.N_PROCRESULT; parameters[7].Value = model.C_REMARK; parameters[8].Value = model.C_ID; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TMB_FLOWPROC DataRowToModel(DataRow row) { Mod_TMB_FLOWPROC model = new Mod_TMB_FLOWPROC(); if (row != null) { if (row["C_ID"] != null) { model.C_ID = row["C_ID"].ToString(); } if (row["C_FILE_ID"] != null) { model.C_FILE_ID = row["C_FILE_ID"].ToString(); } if (row["C_STEP_ID"] != null) { model.C_STEP_ID = row["C_STEP_ID"].ToString(); } if (row["C_STEP_EMP_ID"] != null) { model.C_STEP_EMP_ID = row["C_STEP_EMP_ID"].ToString(); } if (row["C_STEPNOTE"] != null) { model.C_STEPNOTE = row["C_STEPNOTE"].ToString(); } if (row["D_STEP_DT"] != null && row["D_STEP_DT"].ToString() != "") { model.D_STEP_DT = DateTime.Parse(row["D_STEP_DT"].ToString()); } if (row["C_NEXT_EMP_ID"] != null) { model.C_NEXT_EMP_ID = row["C_NEXT_EMP_ID"].ToString(); } if (row["N_PROCRESULT"] != null && row["N_PROCRESULT"].ToString() != "") { model.N_PROCRESULT = decimal.Parse(row["N_PROCRESULT"].ToString()); } if (row["C_REMARK"] != null) { model.C_REMARK = row["C_REMARK"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TMB_FLOWPROC model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TMB_FLOWPROC("); strSql.Append("C_FILE_ID,C_STEP_ID,C_STEP_EMP_ID,C_STEPNOTE,C_NEXT_EMP_ID,N_PROCRESULT,C_REMARK)"); strSql.Append(" values ("); strSql.Append(":C_FILE_ID,:C_STEP_ID,:C_STEP_EMP_ID,:C_STEPNOTE,:C_NEXT_EMP_ID,:N_PROCRESULT,:C_REMARK)"); OracleParameter[] parameters = { new OracleParameter(":C_FILE_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_STEP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_STEP_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_STEPNOTE", OracleDbType.Varchar2, 500), new OracleParameter(":C_NEXT_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":N_PROCRESULT", OracleDbType.Decimal, 1), new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200) }; parameters[0].Value = model.C_FILE_ID; parameters[1].Value = model.C_STEP_ID; parameters[2].Value = model.C_STEP_EMP_ID; parameters[3].Value = model.C_STEPNOTE; parameters[4].Value = model.C_NEXT_EMP_ID; parameters[5].Value = model.N_PROCRESULT; parameters[6].Value = model.C_REMARK; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TMB_FLOWPROC GetModel(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_FILE_ID,C_STEP_ID,C_STEP_EMP_ID,C_STEPNOTE,D_STEP_DT,C_NEXT_EMP_ID,N_PROCRESULT,C_REMARK from TMB_FLOWPROC "); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_ID; Mod_TMB_FLOWPROC model = new Mod_TMB_FLOWPROC(); DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TMB_FLOWPROC model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TMB_FLOWPROC model) { return(dal.Add(model)); }
//批准 protected void btnOk_Click(object sender, EventArgs e) { #region //添加流程明细 string content = string.Empty; DateTime dt = DateTime.Now; if (!string.IsNullOrEmpty(txtContent.Text)) { content += txtContent.Text + "-(" + ltlUserName.Text + " " + dt.ToString() + ")"; } else { content += "批准—(" + ltlUserName.Text + " " + dt.ToString() + ")"; } Mod_TMB_FLOWPROC modPro = new Mod_TMB_FLOWPROC(); modPro.C_FILE_ID = ltlFileID.Text; modPro.C_STEP_ID = ltlStepID.Text; modPro.C_STEP_EMP_ID = ltlUserID.Text; modPro.C_STEPNOTE = content; modPro.D_STEP_DT = dt; modPro.N_PROCRESULT = 1; #endregion if (flowproc.Add(modPro)) //插入流程明细 { con.UpdateCheckEmp(ltlTaskID.Text, ltlUserID.Text, dt); //更新当前审批人/时间 string nextStep = flowstep.GetNextStep(ltlFlowID.Text, ltlStepID.Text); //下一处理步骤 if (nextStep == "0") //判断是否最后步骤 { if (fileinfo.UpdateStepStatus(nextStep, 1, ltlFileID.Text)) //更新文件事务状态为办结 { #region //更新合同/明细状态 if (con.UpdateConStatus(2, ltlTaskID.Text)) //更新合同 { if (condetails.UpdateStatus(2, ltlTaskID.Text)) //更新合同明细 { bool result = false; foreach (RepeaterItem rpt in rptList.Items) { Literal ltlOrderNo = (Literal)rpt.FindControl("ltlOrderNo"); DataRow[] row = orderdata.Select("C_ORDER_NO='" + ltlOrderNo.Text + "'"); if (row.Length > 0) { if (row[0]["N_EXEC_STATUS"].ToString() == "0")//订单未排产 { Mod_TMO_CONDETAILS mod = condetails.GetModel(ltlOrderNo.Text); if (tmo_order.UpdateOrder(mod)) //更新订单池订单 { result = tmp_plan.UpdatePlan(mod); //更新订单日计划 } } } else { if (condetails.AddOrder(ltlOrderNo.Text))//订单插入订单池 { Mod_TMO_CONDETAILS mod = condetails.GetModel(ltlOrderNo.Text); mod.C_BUSINESS_TYPE = dropYeWuType.SelectedValue; if (mod != null) { result = tmp_plan.AddPlan(mod);//插入日计划 } } } } if (result) { WebMsg.MessageBox("提交成功", "WorkFlow_D.aspx"); } } } #endregion } } else { if (fileinfo.UpdateStep(nextStep, ltlFileID.Text))//更新文件事务下一步骤 { WebMsg.MessageBox("提交成功", "WorkFlow_D.aspx"); } } } }