开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > OA系统 > 查看源码
add_flow.aspx.cs
资源名称：web.rar　[点击查看]
上传用户：xrffrp
上传日期：2022-03-25
资源大小：22155k
文件大小：10k
源码类别：

OA系统

开发平台：

ASP/ASPX

add_flow.aspx.cs：源码内容
  1. using System;
  2. using System.Data;
  3. using System.Configuration;
  4. using System.Collections;
  5. using System.Web;
  6. using System.Web.Security;
  7. using System.Web.UI;
  8. using System.Web.UI.WebControls;
  9. using System.Web.UI.WebControls.WebParts;
  10. using System.Web.UI.HtmlControls;
  11. using System.Data.SqlClient;
  13. public partial class web_approvel_flow_add_flow : System.Web.UI.Page
  14. {
  15.     protected void Page_Load(object sender, EventArgs e)
  16.     {
  17.         if (!IsPostBack)
  18.         {
  19.             LoginDAO.CheckLogin(Session, Response, "../../", 2);
  20.             this.SetEmpty();
  21.             if (Request.QueryString["main_id"] != null)
  22.             {
  23.                 this.SetTable(Request.QueryString["main_id"]);
  24.                 if (Request.QueryString["flow_id"] != null)
  25.                 {
  26.                     this.SetFlow(Request.QueryString["flow_id"]);
  27.                 }
  28.             }
  29.         }
  30.     }
  31.     protected void SetEmpty()
  32.     {
  33.         TxtName.Text = "";
  34.         DdlType.SelectedIndex = 2;
  35.         TxtNumber.Text = "";
  36.         TxtOperator.Text = "";
  37.         OperatorId.Value = "";
  38.         TxtLargerNext.Text = "";
  39.         TxtLargerThan.Text = "";
  40.         TxtNumber.Text = "";
  41.     }
  42.     protected void SetFlow(string flow_id)
  43.     {
  44.         SqlConnection conn = dbConnection.getConnection();
  45.         conn.Open();
  46.         SqlCommand cmd = new SqlCommand("select f.name, f.apply_type, f.operator_id, e.emp_name, "+
  47.             "f.number, f.next_number, f.larger_than, f.larger_next from OA_FLOW_DETAIL f "+
  48.             "inner join OA_EMPLOYEE e on f.operator_id=e.id where f.id=" + flow_id, conn);
  49.         SqlDataReader dr = cmd.ExecuteReader();
  50.         if(dr.Read())
  51.         {
  52.             TxtName.Text = dr["name"].ToString();
  53.             DdlType.SelectedValue = dr["apply_type"].ToString();
  54.             OperatorId.Value = dr["operator_id"].ToString();
  55.             TxtOperator.Text = dr["emp_name"].ToString();
  56.             TxtNumber.Text = dr["number"].ToString();
  57.             TxtNextNumber.Text = dr["next_number"].ToString();
  58.             if (dr["larger_than"].ToString().Equals("0"))
  59.             {
  60.                 TxtLargerThan.Text = "";
  61.             }
  62.             else
  63.             {
  64.                 TxtLargerThan.Text = dr["larger_than"].ToString();
  65.             }
  66.             TxtLargerNext.Text = dr["larger_next"].ToString();
  67.         }
  68.         dr.Close();
  69.         conn.Close();
  70.     }
  71.     protected void SetTable(string main_id)
  72.     {
  73.         SqlConnection conn = dbConnection.getConnection();
  74.         conn.Open();
  75.         SqlCommand cmd = new SqlCommand("select count(*) from OA_FLOW_DETAIL where main_id="+main_id, conn);
  76.         int count = Convert.ToInt32(cmd.ExecuteScalar().ToString());
  77.         if (count > 0)
  78.         {
  79.             TableHeaderRow th = new TableHeaderRow();
  80.             th.BackColor = System.Drawing.Color.LightGray;
  81.             TableHeaderCell thc = new TableHeaderCell();
  82.             thc.BorderWidth = Unit.Pixel(1);
  83.             thc.HorizontalAlign = HorizontalAlign.Center;
  84.             thc.Text = "流程名稱";
  85.             th.Cells.Add(thc);
  86.             thc = new TableHeaderCell();
  87.             thc.BorderWidth = Unit.Pixel(1);
  88.             thc.HorizontalAlign = HorizontalAlign.Center;
  89.             thc.Text = "類別";
  90.             th.Cells.Add(thc);
  91.             thc = new TableHeaderCell();
  92.             thc.BorderWidth = Unit.Pixel(1);
  93.             thc.HorizontalAlign = HorizontalAlign.Center;
  94.             thc.Text = "編號";
  95.             th.Cells.Add(thc);
  96.             thc = new TableHeaderCell();
  97.             thc.BorderWidth = Unit.Pixel(1);
  98.             thc.HorizontalAlign = HorizontalAlign.Center;
  99.             thc.Text = "辦理人";
  100.             th.Cells.Add(thc);
  101.             thc = new TableHeaderCell();
  102.             thc.BorderWidth = Unit.Pixel(1);
  103.             thc.HorizontalAlign = HorizontalAlign.Center;
  104.             thc.Text = "下一步編號";
  105.             th.Cells.Add(thc);
  106.             thc = new TableHeaderCell();
  107.             thc.BorderWidth = Unit.Pixel(1);
  108.             thc.HorizontalAlign = HorizontalAlign.Center;
  109.             thc.Text = "最大天數";
  110.             th.Cells.Add(thc);
  111.             thc = new TableHeaderCell();
  112.             thc.BorderWidth = Unit.Pixel(1);
  113.             thc.HorizontalAlign = HorizontalAlign.Center;
  114.             thc.Text = "超過最大天數跳轉編號";
  115.             th.Cells.Add(thc);
  116.             thc = new TableHeaderCell();
  117.             thc.BorderWidth = Unit.Pixel(1);
  118.             thc.HorizontalAlign = HorizontalAlign.Center;
  119.             thc.Text = " ";
  120.             th.Cells.Add(thc);
  122.             TblFlowList.Rows.Add(th);
  124.             cmd = new SqlCommand("select d.id, d.main_id, d.name, d.apply_type, e.emp_name, d.number, d.next_number, "+
  125.                 "d.larger_than, d.larger_next from OA_FLOW_DETAIL d inner join OA_EMPLOYEE e on "+
  126.                 "d.operator_id=e.id where main_id="+main_id, conn);
  127.             SqlDataReader dr = cmd.ExecuteReader();
  128.             while (dr.Read())
  129.             {
  130.                 TableRow tr = new TableRow();
  131.                 TableCell td = new TableCell();
  132.                 td.HorizontalAlign = HorizontalAlign.Center;
  133.                 td.BorderWidth = Unit.Pixel(1);
  134.                 td.Text = dr["name"].ToString();
  135.                 tr.Cells.Add(td); td = new TableCell();
  136.                 td.HorizontalAlign = HorizontalAlign.Center;
  137.                 td.BorderWidth = Unit.Pixel(1);
  138.                 if (dr["apply_type"].ToString().Equals("1"))
  139.                 {
  140.                     td.Text = "會簽";
  141.                 }
  142.                 else
  143.                 {
  144.                     td.Text = "審批";
  145.                 }
  146.                 tr.Cells.Add(td); 
  147.                 td = new TableCell();
  148.                 td.HorizontalAlign = HorizontalAlign.Center;
  149.                 td.BorderWidth = Unit.Pixel(1);
  150.                 td.Text = dr["number"].ToString();
  151.                 tr.Cells.Add(td); 
  152.                 td = new TableCell();
  153.                 td.HorizontalAlign = HorizontalAlign.Center;
  154.                 td.BorderWidth = Unit.Pixel(1);
  155.                 td.Text = dr["emp_name"].ToString();
  156.                 tr.Cells.Add(td); 
  157.                 td = new TableCell();
  158.                 td.HorizontalAlign = HorizontalAlign.Center;
  159.                 td.BorderWidth = Unit.Pixel(1);
  160.                 if (!dr["next_number"].ToString().Equals(""))
  161.                 {
  162.                     td.Text = dr["next_number"].ToString();
  163.                 }
  164.                 else
  165.                 {
  166.                     td.Text = "  ";
  167.                 }
  168.                 tr.Cells.Add(td); 
  169.                 td = new TableCell();
  170.                 td.HorizontalAlign = HorizontalAlign.Center;
  171.                 td.BorderWidth = Unit.Pixel(1);
  172.                 if (!dr["larger_than"].ToString().Equals("0"))
  173.                 {
  174.                     td.Text = dr["larger_than"].ToString();
  175.                 }
  176.                 else
  177.                 {
  178.                     td.Text = "  ";
  179.                 }
  180.                 tr.Cells.Add(td); 
  181.                 td = new TableCell();
  182.                 td.HorizontalAlign = HorizontalAlign.Center;
  183.                 td.BorderWidth = Unit.Pixel(1);
  184.                 if (!dr["larger_next"].ToString().Equals(""))
  185.                 {
  186.                     td.Text = dr["larger_next"].ToString();
  187.                 }
  188.                 else
  189.                 {
  190.                     td.Text = " ";
  191.                 }
  192.                 tr.Cells.Add(td);
  194.                 td = new TableCell();
  195.                 td.BorderWidth = Unit.Pixel(1);
  196.                 td.HorizontalAlign = HorizontalAlign.Center;
  197.                 HyperLink lb = new HyperLink();
  198.                 lb.Text = "編輯";
  199.                 lb.NavigateUrl = "add_flow.aspx?main_id=" + dr["main_id"].ToString() + "&flow_id=" + dr["id"].ToString();
  200.                 td.Controls.Add(lb);
  201.                 tr.Cells.Add(td);
  203.                 TblFlowList.Rows.Add(tr);
  204.             }
  205.             dr.Close();
  206.         }
  207.         conn.Close();
  208.     }
  209.     protected void BtnOk_Click(object sender, EventArgs e)
  210.     { 
  211.         int main_id = 0;
  212.         if (Request.QueryString["main_id"] != null)
  213.         {
  214.             main_id = Convert.ToInt32(Request.QueryString["main_id"]);
  215.         }
  217.         SqlConnection conn = dbConnection.getConnection();
  218.         conn.Open();
  219.         if (Request.QueryString["flow_id"] == null)
  220.         {
  221.             //新增
  222.             int flow_id = 1;
  223.             SqlCommand cmd = new SqlCommand("select max(id) from OA_FLOW_DETAIL", conn);
  224.             try
  225.             {
  226.                 flow_id = Convert.ToInt32(cmd.ExecuteScalar()) + 1;
  227.             }
  228.             catch { }
  230.             cmd = new SqlCommand("insert into OA_FLOW_DETAIL(id, main_id, name, apply_type, operator_id, " +
  231.                 "number, next_number, larger_than, larger_next) values (" + flow_id + "," + main_id + ",'" +
  232.                 TxtName.Text + "','" + DdlType.SelectedValue + "','" + OperatorId.Value + "','" + TxtNumber.Text + "','" +
  233.                 TxtNextNumber.Text + "','" + TxtLargerThan.Text + "','" + TxtLargerNext.Text + "')", conn);
  234.             cmd.ExecuteNonQuery();
  235.         }
  236.         else
  237.         { 
  238.             //編輯
  239.             int flow_id = Convert.ToInt32(Request.QueryString["flow_id"]);
  240.             SqlCommand cmd = new SqlCommand("update OA_FLOW_DETAIL set name='"+TxtName.Text+"', apply_type='"+
  241.                 DdlType.SelectedValue+"',  operator_id='"+OperatorId.Value+"',number='"+TxtNumber.Text+
  242.                 "', next_number='"+TxtNextNumber.Text+"', larger_than='"+TxtLargerThan.Text+
  243.                 "', larger_next='"+TxtLargerNext.Text+"' where id="+flow_id, conn);
  244.             cmd.ExecuteNonQuery();
  245.         }
  246.         conn.Close();
  247.         Response.Redirect("add_flow.aspx?main_id="+main_id);
  248.     }
  249.     protected void BtnCancel_Click(object sender, EventArgs e)
  250.     {
  251.         if (Request.QueryString["main_id"] != null)
  252.         {
  253.             Response.Redirect("add_flow.aspx?main_id="+Request.QueryString["main_id"]);
  254.         }
  255.     }
  256. }