/// <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"); } }
public string GetRole(object stepID) { string str = ""; if (!string.IsNullOrEmpty(stepID.ToString())) { Mod_TS_ROLE modRloe = ts_role.GetModel(stepID.ToString()); str = modRloe.C_NAME; } return(str); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Mod_TS_ROLE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TS_ROLE set "); strSql.Append("C_NAME=:C_NAME,"); strSql.Append("C_CODE=:C_CODE,"); strSql.Append("C_DESC=:C_DESC,"); strSql.Append("N_STATUS=:N_STATUS,"); strSql.Append("C_EMP_ID=:C_EMP_ID,"); strSql.Append("C_EMP_NAME=:C_EMP_NAME,"); strSql.Append("D_MOD_DT=:D_MOD_DT"); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":C_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_DESC", OracleDbType.Varchar2, 200), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 20), new OracleParameter(":D_MOD_DT", OracleDbType.Date), new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = model.C_NAME; parameters[1].Value = model.C_CODE; parameters[2].Value = model.C_DESC; parameters[3].Value = model.N_STATUS; parameters[4].Value = model.C_EMP_ID; parameters[5].Value = model.C_EMP_NAME; parameters[6].Value = model.D_MOD_DT; parameters[7].Value = model.C_ID; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TS_ROLE DataRowToModel(DataRow row) { Mod_TS_ROLE model = new Mod_TS_ROLE(); if (row != null) { if (row["C_ID"] != null) { model.C_ID = row["C_ID"].ToString(); } if (row["C_NAME"] != null) { model.C_NAME = row["C_NAME"].ToString(); } if (row["C_CODE"] != null) { model.C_CODE = row["C_CODE"].ToString(); } if (row["C_DESC"] != null) { model.C_DESC = row["C_DESC"].ToString(); } if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "") { model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString()); } if (row["C_EMP_ID"] != null) { model.C_EMP_ID = row["C_EMP_ID"].ToString(); } if (row["C_EMP_NAME"] != null) { model.C_EMP_NAME = row["C_EMP_NAME"].ToString(); } if (row["D_MOD_DT"] != null && row["D_MOD_DT"].ToString() != "") { model.D_MOD_DT = DateTime.Parse(row["D_MOD_DT"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TS_ROLE model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TS_ROLE("); strSql.Append("C_ID,C_NAME,C_CODE,C_DESC,N_STATUS,C_EMP_ID,C_EMP_NAME,D_MOD_DT)"); strSql.Append(" values ("); strSql.Append(":C_ID,:C_NAME,:C_CODE,:C_DESC,:N_STATUS,:C_EMP_ID,:C_EMP_NAME,:D_MOD_DT)"); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_NAME", OracleDbType.Varchar2, 100), new OracleParameter(":C_CODE", OracleDbType.Varchar2, 100), new OracleParameter(":C_DESC", OracleDbType.Varchar2, 200), new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1), new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100), new OracleParameter(":C_EMP_NAME", OracleDbType.Varchar2, 20), new OracleParameter(":D_MOD_DT", OracleDbType.Date) }; parameters[0].Value = model.C_ID; parameters[1].Value = model.C_NAME; parameters[2].Value = model.C_CODE; parameters[3].Value = model.C_DESC; parameters[4].Value = model.N_STATUS; parameters[5].Value = model.C_EMP_ID; parameters[6].Value = model.C_EMP_NAME; parameters[7].Value = model.D_MOD_DT; int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["ID"])) { try { ltlStepID.Text = Request.QueryString["ID"]; Mod_TS_ROLE mod = ts_role.GetModel(Request.QueryString["ID"]); if (mod != null) { ltlRoleName.Text = mod.C_NAME; } GetList(); } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } } } }
/// <summary> /// 得到一个对象实体 /// </summary> public Mod_TS_ROLE GetModel(string C_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select C_ID,C_NAME,C_CODE,C_DESC,N_STATUS,C_EMP_ID,C_EMP_NAME,D_MOD_DT from TS_ROLE "); strSql.Append(" where C_ID=:C_ID "); OracleParameter[] parameters = { new OracleParameter(":C_ID", OracleDbType.Varchar2, 100) }; parameters[0].Value = C_ID; Mod_TS_ROLE model = new Mod_TS_ROLE(); 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_TS_ROLE model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Mod_TS_ROLE model) { return(dal.Add(model)); }