void Bind() { mf = bf.GetModel(int.Parse(DropDownList1.SelectedValue)); mtf = tf.GetModel(mf.f_form); if (mtf == null) { Tunnel.Common.Message.back("表单不存在或已删除,请与管理员联系"); return; } Label1.Text = fc.From_Content(mtf.f_content, "", false);//取得替换后的表单数据 ul.UsbnLogin = ul.getUserModel(ul.LoginID); string bumname = Tunnel.Common.GetValue.getDataValue("Tunnel_bum", "b_name", "b_id=" + ul.UsbnLogin.m_bum); TextBox1.Text = bumname + mf.f_name; if (mf.f_isfile.ToString() == "1") { isuploads = false; } Repeater1.DataSource = bs.GetList("s_lid=" + mf.f_id); Repeater1.DataBind(); if (Repeater1.Items.Count <= 0) { Label2.Text = "本公文未设置流程,将不能保存!"; HiddenField2.Value = "0"; } else { Label2.Text = ""; HiddenField2.Value = "1"; } }
void Bind() { mtb = btb.GetModel(Convert.ToInt32(Request.Params["bid"])); mf = bf.GetModel(mtb.b_sort); mtf = tf.GetModel(mf.f_form); if (mtf == null) { Tunnel.Common.Message.back("表单不存在或已删除,请与管理员联系"); return; } Label1.Text = fc.From_Content(mtf.f_content, mtb.b_content, false);//取得替换后的表单数据 if (mf.f_isfile.ToString() == "1") { isuploads = false; } TextBox1.Text = mtb.b_title; if (mtb.b_suser == 0) { RadioButtonList3.SelectedIndex = 0; isusered = false; } else { TextBox2.Text = Tunnel.Common.GetValue.getDataValue("Tunnel_menber", "m_name", "m_id=" + mtb.b_suser); RadioButtonList3.SelectedIndex = 1; isusered = true; } m_value.Value = mtb.b_suser.ToString(); hfile.Value = mtb.b_file; if (!"".Equals(mtb.b_file)) { string[] filelist = mtb.b_file.Split(','); foreach (string list in filelist) { string flist = list.Substring(list.LastIndexOf('/') + 1, list.Length - list.LastIndexOf('/') - 1); hfilelist += "<span><img src=\"../../image/attach.png\">" + flist + "<img style='cursor:hand' onclick=\"del(this,'" + list + "')\" alt='删除附件' src=\"../../image/remove.png\">;</span>"; } } if (mf.f_state.ToString() == "0") { scontent = "审核→"; issheng = true; } else { scontent = ""; issheng = false; } Repeater1.DataSource = bs.GetList("s_lid=" + mf.f_id); Repeater1.DataBind(); if (Repeater1.Items.Count <= 0) { Label2.Text = "本申请未设置流程,将不能保存!"; HiddenField2.Value = "0"; scontent = ""; } else { Label2.Text = ""; HiddenField2.Value = "1"; } }
void Bind() { try { mtb = btb.GetModel(int.Parse(Request.Params["bid"])); mf = bf.GetModel(mtb.b_sort); mtf = tf.GetModel(mf.f_form); if (mtf == null) { Tunnel.Common.Message.back("表单不存在或已删除,请与管理员联系"); return; } Label1.Text = fc.From_Content(mtf.f_content, mtb.b_content, true);//取得替换后的表单数据 Label4.Text = mtb.b_title + " (" + mtb.b_time + ")"; Label5.Text = "<font color=red>(注:红色代表当前执行步骤,<font color=green>绿色代表已经审批通过</font>)</font>"; formfile = Tunnel.Common.GetValue.getFile(mtb.b_file); if (mf.f_isfile.ToString() == "1") { isuploads = false; } if (mf.f_state.ToString() == "0" && mf.f_sort != 18) { scontent = "<font color='green'>审核→</font>"; } else { scontent = ""; } Repeater1.DataSource = bts.GetList("s_lid=" + mf.f_id); Repeater1.DataBind(); Button4.Visible = false; Button5.Visible = false; string currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_nextbid", "e_gid=" + Request.Params["bid"] + " order by e_id desc"); if ("".Equals(currbid) || "0".Equals(currbid)) { currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_id", "s_lid=" + mtb.b_sort + " and s_num=1"); } mts = bts.GetModel(Convert.ToInt32(currbid)); if (mts.s_isbak == 1) { Button5.Visible = true; Button1.Visible = false; Button2.Visible = false; spPassword.Enabled = false; spPassword.TextMode = TextBoxMode.SingleLine; spPassword.Text = "不需填写审批密码"; } } catch { Tunnel.Common.Message.back("不正确的ID"); return; } }
/// <summary> /// 流程修改数据显示 /// </summary> void editbind() { try { Tunnel.BLL.Tunnel_flow bf = new Tunnel.BLL.Tunnel_flow(); Tunnel.Model.Tunnel_flow mf = new Tunnel.Model.Tunnel_flow(); mf = bf.GetModel(int.Parse(Request.Params["editid"])); if (mf.f_sort != 0 && tfc.Exists(mf.f_sort)) { DropDownList1.SelectedValue = mf.f_sort.ToString(); } if (mf.f_bum != 0 && bt.Exists(mf.f_bum)) { DropDownList2.SelectedValue = mf.f_bum.ToString(); } if (mf.f_form != 0 && btf.Exists(mf.f_form)) { DropDownList4.SelectedValue = mf.f_form.ToString(); } TextBox1.Text = mf.f_name; TextBox2.Text = mf.f_depict; RadioButtonList1.SelectedValue = mf.f_isfile.ToString(); RadioButtonList2.SelectedValue = mf.f_state.ToString(); //RadioButtonList3.SelectedValue = mf.f_stype.ToString(); } catch { Tunnel.Common.Message.back("不正确的ID!"); } }
void Bind() { try { mf = bf.GetModel(int.Parse(Request.Params["Flow"])); mtf = tf.GetModel(mf.f_form); if (mtf == null) { Tunnel.Common.Message.back("表单不存在或已删除,请与管理员联系"); return; return; } Label1.Text = fc.From_Content(mtf.f_content, "", false);//取得替换后的表单数据 ul.UsbnLogin = ul.getUserModel(ul.LoginID); string bumname = Tunnel.Common.GetValue.getDataValue("Tunnel_bum", "b_name", "b_id=" + ul.UsbnLogin.m_bum); TextBox1.Text = bumname + mf.f_name; if (mf.f_isfile.ToString() == "1") { isuploads = false; } if (mf.f_state.ToString() == "0") { scontent = "审核→"; issheng = true; isshen = true; } else { scontent = ""; issheng = false; isshen = false; } Repeater1.DataSource = bs.GetList("s_lid=" + mf.f_id); Repeater1.DataBind(); if (Repeater1.Items.Count <= 0) { Label2.Text = "本申请未设置流程,将不能保存!"; HiddenField2.Value = "0"; } else { Label2.Text = ""; HiddenField2.Value = "1"; } } catch { Tunnel.Common.Message.back("不正确的ID"); return; } }
void Bind() { try { mtb = btb.GetModel(int.Parse(Request.Params["bid"])); mf = bf.GetModel(mtb.b_sort); mtf = tf.GetModel(mf.f_form); Label1.Text = fc.From_Content(mtf.f_content, mtb.b_content, true);//取得替换后的表单数据 Label4.Text = mtb.b_title + " (" + mtb.b_time + ")"; formfile = Tunnel.Common.GetValue.getFile(mtb.b_file); if (mf.f_isfile.ToString() == "1") { isuploads = false; } Repeater1.DataSource = bts.GetList("s_lid=" + mf.f_id); Repeater1.DataBind(); } catch { Tunnel.Common.Message.back("不正确的ID"); return; } }
protected void Button1_Click(object sender, EventArgs e) { Tunnel.Model.Tunnel_menber tm = ul.GetUserBean(ul.LoginID); if (!Tunnel.Data.DESEncrypt.Encrypt(spPassword.Text.Trim()).Equals(tm.m_spassword)) { Tunnel.Common.Message.back("审批密码错误"); return; } else { //这里为存储当前步骤 mtb = btb.GetModel(int.Parse(Request.Params["bid"])); mf = bf.GetModel(mtb.b_sort); if (mtb.b_state == 3) { Tunnel.Common.Message.back("此流程己审批结束,请勿重复审批!"); return; } else { //将当前步骤存入数据库表:Tunnel_exam Tunnel.BLL.Tunnel_exam bte = new Tunnel.BLL.Tunnel_exam(); Tunnel.Model.Tunnel_exam mte = new Tunnel.Model.Tunnel_exam(); mte.e_bid = 0; mte.e_endtime = DateTime.Now; mte.e_gid = Convert.ToInt32(Request.Params["bid"]); mte.e_user = ul.LoginID; mte.e_nextbuser = m_value.Value; string lastendtime = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_endtime", "e_gid=" + Request.Params["bid"] + " order by e_id desc"); if (!string.IsNullOrEmpty(lastendtime)) { mte.e_time = Convert.ToDateTime(lastendtime);//取得上一步的最后执行时间 } else { mte.e_time = mtb.b_time; } mte.e_nextbid = 1; Tunnel.Model.Tunnel_Remind tr = new Tunnel.Model.Tunnel_Remind(); Tunnel.BLL.Tunnel_Remind br = new Tunnel.BLL.Tunnel_Remind(); string[] users = m_value.Value.Split(','); foreach (string user in users) { if (!string.IsNullOrEmpty(user)) { tr.m_title = mtb.b_title + "<font color=red>(待审批)</font>"; tr.m_url = "N_WorkFlow/OtherDocument/Other_zSp.aspx?bid=" + Request.Params["bid"]; tr.m_touser = Convert.ToInt32(user); tr.m_time = DateTime.Now; tr.m_type = 1; tr.m_typeid = Convert.ToInt32(mtb.b_id); tr.m_bid = 1; tr.m_callTime = Convert.ToDateTime("1800-1-1 00:00:00"); tr.m_isread = 0; long messge = br.Add(tr); } } bte.Add(mte); string contents = FCKeditor1.Value; //添加审批意见 if (!string.IsNullOrEmpty(contents)) { Tunnel.BLL.Tunnel_Advice ta = new Tunnel.BLL.Tunnel_Advice(); Tunnel.Model.Tunnel_Advice ma = new Tunnel.Model.Tunnel_Advice(); ma.a_content = contents; ma.a_bid = Convert.ToInt32(mts.s_id); ma.a_gid = Convert.ToInt32(mtb.b_id); ma.a_time = DateTime.Now; ma.a_user = ul.LoginID; string count = Tunnel.Common.GetValue.getDataValue("Tunnel_Advice", "count(*)", "a_bid=1024 and a_gid=" + Request.Params["bid"]); ta.Add(ma); } Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=1 and m_touser="******" and m_typeid=" + mtb.b_id);//删除待办事项 Tunnel.Common.Message.Show("操作成功!", "../MyApply/Apply_Sp.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { string bWhere = ""; mtb = btb.GetModel(int.Parse(Request.Params["lid"])); mf = bf.GetModel(mtb.b_sort); if (mf.f_sort == 18) { bWhere = " and e_bid<>0"; } else { bWhere = ""; } Page.Title = mtb.b_title; DataSet ds = bte.GetList("e_gid=" + mtb.b_id + bWhere + " order by e_id asc"); StringBuilder text = new StringBuilder(); StringBuilder texttop = new StringBuilder(); texttop.Append("<tr>"); texttop.Append("<td align=\"center\" style=\"height: 30px; width: 10%;\">第<font color=red>1</font>步</td>"); texttop.Append("<td align=\"left\" style=\"height: 30px; width: 30%\"> 发起</td>"); texttop.Append("<td align=\"left\" style=\"height: 50%\"> <strong style=\"color:Red\">" + getUname(mtb.b_user.ToString()) + "</strong> [<font color=Green>发起</font>]"); texttop.Append("<br /> 发起于:" + mtb.b_time.ToString() + "</td>"); texttop.Append("</tr> "); if (mtb.b_state == 3) { nextb = ""; isend = true; } else if (mtb.b_state == 1) { string suser = ""; if (mtb.b_suser == 0) { ul.UsbnLogin = bm.GetModel(mtb.b_user); DataSet dss = new DataSet(); dss = bm.GetList("m_bum=" + ul.UsbnLogin.m_bum); foreach (DataRow dr in dss.Tables[0].Rows) { if (Tunnel.BLL.Permission.IfHasPrimision(dr["m_id"].ToString(), "流程审核", "我的工作", false)) { suser += dr["m_id"].ToString() + ","; } } if (!string.IsNullOrEmpty(suser)) { text.Append("<tr>"); text.Append("<td align=\"center\" style=\"height: 30px; width: 10%;\">第<font color=red>2</font>步</td>"); text.Append("<td align=\"left\" style=\"height: 30px; width: 30%\"> 审核</td>"); text.Append("<td align=\"left\" style=\"height: 50%\"> <strong style=\"color:Red\">" + getallUname(suser) + " 主办</strong> [<font color=blue>审核中</font>]"); text.Append("<br /> 开始于:" + mtb.b_time.ToString() + "</td>"); text.Append("</tr> "); } else { text.Append("<tr>"); text.Append("<td align=\"center\" colspan='3' style=\"height: 30px; width: 10%;color:red\">没有设置审核人,请与管理员联系!</td>"); text.Append("</tr> "); } } else { text.Append("<tr>"); text.Append("<td align=\"center\" style=\"height: 30px; width: 10%;\">第<font color=red>2</font>步</td>"); text.Append("<td align=\"left\" style=\"height: 30px; width: 30%\"> 审核</td>"); text.Append("<td align=\"left\" style=\"height: 50%\"> <strong style=\"color:Red\">" + getUname(mtb.b_suser.ToString()) + " 主办</strong> [<font color=blue>审核中</font>]"); text.Append("<br /> 开始于:" + mtb.b_time.ToString() + "</td>"); text.Append("</tr> "); } nextb = text.ToString(); } else { if (mtb.b_state > 0) { string currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_nextbid", "e_gid=" + mtb.b_id + " order by e_id desc"); string currtime = Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "e_time", "e_gid=" + mtb.b_id + " order by e_id desc"); int currnum = Convert.ToInt32(Tunnel.Common.GetValue.getDataValue("Tunnel_exam", "count(*)", "e_gid=" + mtb.b_id)); if ("".Equals(currbid) || "0".Equals(currbid)) { currbid = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_id", "s_lid=" + mtb.b_sort + " and s_num=1"); } mts = ts.GetModel(Convert.ToInt32(currbid)); string nextnum = ""; string nextname = ""; string nextuser = ""; if (mts != null) { nextnum = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_num", "s_id=" + mts.s_id); nextname = getname(mts.s_id.ToString()); nextuser = getallUname(mts.s_zid.ToString()); } else { nextname = "步骤不存在或已删除"; nextuser = nextnum = "无"; } text.Append("<tr>"); text.Append("<td align=\"center\" style=\"height: 30px; width: 10%;\">第<font color=red>" + (currnum + (bWhere == ""?2:1)) + "</font>步</td>"); text.Append("<td align=\"left\" style=\"height: 30px; width: 30%\"> " + "序号" + nextnum + ":" + nextname + "</td>"); text.Append("<td align=\"left\" style=\"height: 50%\"> <strong style=\"color:Red\">" + nextuser + " 主办</strong> [<font color=blue>办理中</font>]"); text.Append("<br /> 开始于:" + currtime + "</td>"); text.Append("</tr> "); nextb = text.ToString(); } } toptb = texttop.ToString(); Repeater1.DataSource = ds; Repeater1.DataBind(); } }