protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (!string.IsNullOrEmpty(Request.Params["delid"])) { mb = tb.GetModel(Convert.ToInt32(Request.Params["delid"])); if ("issure".Equals(Request.Params["mod"])) { tmt.Title = mb.b_title; tmt.TypeId = 5; tmt.HtmlSource = fc.From_Content(mb.b_formcontent, mb.b_content, true);//取得替换后的表单数据 tmt.UserId = mb.b_user; Tunnel.BLL.Tunnel_information bllf = new Tunnel.BLL.Tunnel_information(); int relt = -1; relt = bllf.Add(tmt); } tb.Delete(mb.b_id); Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE FROM TUNNEL_EXAM WHERE E_GID=" + mb.b_id); Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE FROM Tunnel_Advice WHERE A_GID=" + mb.b_id); Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE FROM Tunnel_Remind WHERE m_type=1 and m_typeid=" + mb.b_id); Tunnel.Common.Del_File delfile = new Tunnel.Common.Del_File(); delfile.FileDelete(mb.b_file); Tunnel.Common.Message.Show("操作成功!", "Other_Manage.aspx"); } this.ShowInit(""); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { this.ShowInit(""); Tunnel.BLL.Tunnel_flow tf = new Tunnel.BLL.Tunnel_flow(); DataSet dds = tf.GetList("f_sort=18"); ListItem list = new ListItem(); //list.Text = "所有流程类型"; //list.Value = "0"; //DropDownList1.Items.Add(list); foreach (DataRow drds in dds.Tables[0].Rows) { list = new ListItem(); list.Text = drds["f_name"].ToString(); list.Value = drds["f_id"].ToString(); DropDownList1.Items.Add(list); } if (!string.IsNullOrEmpty(Request.Params["delid"])) { mb = tb.GetModel(Convert.ToInt32(Request.Params["delid"])); if ("issure".Equals(Request.Params["mod"])) { tmt.Title = mb.b_title; tmt.TypeId = 5; tmt.HtmlSource = fc.From_Content(mb.b_formcontent, mb.b_content, true);//取得替换后的表单数据 tmt.UserId = mb.b_user; Tunnel.BLL.Tunnel_information bllf = new Tunnel.BLL.Tunnel_information(); int relt = -1; relt = bllf.Add(tmt); } tb.Delete(mb.b_id); Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE FROM TUNNEL_EXAM WHERE E_GID=" + mb.b_id); Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE FROM Tunnel_Advice WHERE A_GID=" + mb.b_id); Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE FROM Tunnel_Remind WHERE m_type=1 and m_typeid=" + mb.b_id); Tunnel.Common.Del_File delfile = new Tunnel.Common.Del_File(); delfile.FileDelete(mb.b_file); Tunnel.Common.Message.Show("操作成功!"); } } }
//添加至信息表 protected void Button1_Click(object sender, EventArgs e) { if (titleId == 1) { if (!"0".Equals(Request.Form["DropDownList1"])) { string title = this.tb_Title.Text.Trim(); int typeid = Convert.ToInt32(this.DropDownList1.SelectedValue); string htmlsourcce = this.FCKeditor.Value; // Request.Form["content1"]; //this.FCKeditor.Value; string imagepaht = stringFormat(From_Content(htmlsourcce)).Trim(); string content = FCKeditor.Value; //Request.Form["content1"]; //FreeTextBox1.HtmlStrippedText; int userid = ul.LoginID; if (!string.IsNullOrEmpty(imagepaht)) { if (imagepaht.Substring(0, 1) == "/") { imagepaht = imagepaht.Substring(1, imagepaht.Length - 1); } imagepaht = imagepaht.Replace("src=/sdoa/", ""); } Tunnel.Model.Tunnel_index model = new Tunnel.Model.Tunnel_index(); model.Id = indexId; model.Title = title; model.TypeId = typeid; model.HtmlSource = htmlsourcce; model.ImagePaht = imagepaht; model.Content = content; model.UserId = userid; HttpPostedFile hpf = file1.PostedFile; if (Convert.ToDouble(hpf.ContentLength) / 1024 / 1024 > 10) { Response.Write("<script>alert('附件大小不能大于10MB');</script>"); return; } else { CreateMdAndFilePaht(hpf); } model.Files = filePaht; //infofiles //string str = titleName; Tunnel.BLL.Tunnel_information bllf = new Tunnel.BLL.Tunnel_information(); Tunnel.BLL.Tunnel_Index index = new Tunnel.BLL.Tunnel_Index(); int relt = -1; relt = index.Update(model); if (relt > 0) { Tunnel.Common.Message.Show("修改成功!", "N_InformationManage.aspx?type=" + Request.QueryString["type"]); } else { Tunnel.Common.Message.Show("修改失败!", "N_InformationManage.aspx?type=" + Request.QueryString["type"]); } // MessageBox(str, url); } else { Tunnel.Common.Message.Show("请选择子栏目!"); } } else { if (!"0".Equals(Request.Form["DropDownList1"])) { string title = this.tb_Title.Text.Trim(); int typeid = Convert.ToInt32(this.DropDownList1.SelectedValue); string htmlsourcce = this.FCKeditor.Value; // Request.Form["content1"]; //this.FCKeditor.Value; string imagepaht = stringFormat(From_Content(htmlsourcce)).Trim(); string content = FCKeditor.Value; //Request.Form["content1"]; //FreeTextBox1.HtmlStrippedText; int userid = ul.LoginID; if (!string.IsNullOrEmpty(imagepaht)) { if (imagepaht.Substring(0, 1) == "/") { imagepaht = imagepaht.Substring(1, imagepaht.Length - 1); } imagepaht = imagepaht.Replace("src=/sdoa/", ""); } Tunnel.Model.Tunnel_index model = new Tunnel.Model.Tunnel_index(); model.Title = title; model.TypeId = typeid; model.HtmlSource = htmlsourcce; model.ImagePaht = imagepaht; model.Content = content; model.UserId = userid; HttpPostedFile hpf = file1.PostedFile; if (Convert.ToDouble(hpf.ContentLength) / 1024 / 1024 > 10) { Response.Write("<script>alert('附件大小不能大于10MB');</script>"); return; } else { CreateMdAndFilePaht(hpf); } model.Files = filePaht; //infofiles //string str = titleName; Tunnel.BLL.Tunnel_information bllf = new Tunnel.BLL.Tunnel_information(); int relt = -1; relt = bllf.Add(model); if (relt > 0) { Tunnel.Common.Message.Show("增加成功!", "N_InformationManage.aspx?type=" + Request.QueryString["type"]); string strsql = ""; strsql = "insert into tunnel_log(l_user,l_time,l_content,l_ip,l_sort) values(" + ul.LoginID + ",'" + DateTime.Now + "','公司事务>>党工团信息>>修改党工团信息。标题:" + model.Title + "','" + Tunnel.Common.Common.GetIp() + "',1)"; Tunnel.Data.DbHelperSQL.ExecuteSql(strsql); } else { Tunnel.Common.Message.Show("增加失败!", "N_InformationManage.aspx?type=" + Request.QueryString["type"]); } // MessageBox(str, url); } else { Tunnel.Common.Message.Show("请选择子栏目!"); } } }
protected void Button5_Click(object sender, EventArgs e) { //这里为存储当前步骤 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 { 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)); int cunum = mts.s_num; bool iscshened = true; int sum = bts.GetCount("s_lid=" + mtb.b_sort); string curruser = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_zid", "s_id=" + mts.s_id); if (!string.IsNullOrEmpty(curruser)) { string[] users = curruser.Split(','); foreach (string user in users) { if (!string.IsNullOrEmpty(user)) { if (user == ul.LoginID.ToString()) { iscshened = false; } } } } if (!iscshened || ul.JiaoSe(ul.LoginID) == "系统管理员") { //将当前步骤存入数据库表: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 = Convert.ToInt32(mts.s_id); mte.e_endtime = DateTime.Now; mte.e_gid = Convert.ToInt32(Request.Params["bid"]); mte.e_user = ul.LoginID; 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; } //如果为最后一步则结束流程 if (cunum == sum) { mte.e_nextbid = 0; string pid = Tunnel.Common.GetValue.getDataValue("Tunnel_flow", "f_sort", "f_id=" + mtb.b_sort); //插入到公司发文 if ("18".Equals(pid)) { tmt.Title = mtb.b_title; tmt.TypeId = 5; tmt.HtmlSource = fc.From_Content(mtb.b_formcontent, mtb.b_content, true);//取得替换后的表单数据 tmt.UserId = mtb.b_user; Tunnel.BLL.Tunnel_information bllf = new Tunnel.BLL.Tunnel_information(); int relt = -1; relt = bllf.Add(tmt); } Tunnel.Data.DbHelperSQL.ExecuteSql("UPDATE TUNNEL_BUMF SET B_STATE=3 WHERE B_ID=" + Request.Params["bid"]); Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=" + currbid + " and m_typeid=" + mtb.b_id);//删除待办事项 Tunnel.Common.Message.Show("流程结束成功!", "Apply_Sp.aspx"); } else { string currs = ""; if (!"".Equals(currbid) || !"0".Equals(currbid)) { string nid = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_id", "s_lid=" + mtb.b_sort + " and s_num>" + mts.s_num + " order by s_num asc"); currs = Tunnel.Common.GetValue.getDataValue("Tunnel_step", "s_zid", "s_lid=" + mtb.b_sort + " and s_num>" + mts.s_num + " order by s_num asc"); if (string.IsNullOrEmpty(nid)) { nid = "0"; } mte.e_nextbid = long.Parse(nid); } else { mte.e_nextbid = 0; } if (!string.IsNullOrEmpty(currs)) { Tunnel.Model.Tunnel_Remind tr = new Tunnel.Model.Tunnel_Remind(); Tunnel.BLL.Tunnel_Remind br = new Tunnel.BLL.Tunnel_Remind(); string[] users = currs.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/MyApply/Apply_zSp.aspx?bid=" + mtb.b_id; 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 = Convert.ToInt32(mte.e_nextbid); 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=" + mf.f_id + " and a_gid=" + Request.Params["bid"]); if (int.Parse(count) > 0) { ta.Update(ma); } else { ta.Add(ma); } } Tunnel.Data.DbHelperSQL.ExecuteSql("DELETE TUNNEL_REMIND WHERE m_type=1 and m_bid=" + currbid + " and m_typeid=" + mtb.b_id);//删除待办事项 Tunnel.Common.Message.Show("操作成功!", "Apply_Sp.aspx"); } else { Tunnel.Common.Message.back("此流程己审批通过,请勿重复审批!"); return; } } }