OA系统

开发平台：
ASP/ASPX

b_form.aspx.cs：源码内容
							﻿
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Net.Mail;
using System.Net;
using System.Net.Sockets;
public partial class web_approvel_b_form : System.Web.UI.Page
{
    ArrayList apply_type = new ArrayList();
    ArrayList operator_id = new ArrayList();
    private int count = 0;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            this.SetValue();
            LoginDAO.CheckLogin(Session, Response, "../../", 2);
        }
    }
    protected void SetValue()
    {
        if (Session["user"] != null)
        { 
            DateMgr mgr = new DateMgr();
            User user = (User)Session["user"];
            TxtEmpName.Text = user.Emp_name;
            TxtEmpNo.Text = user.Emp_no;
            TxtDepartment.Text = user.Department.Full_name;
            TxtPosition.Text = user.Position;
            PositionSequence.Value = user.PositionSequence.ToString();
            TxtFormId.Text = mgr.getTime();
            TxtApplyDate.Text = mgr.getDateTime();
            EmployeeId.Value = user.Id.ToString();
            DepartmentId.Value = user.Department.Id.ToString();
            PositionId.Value = user.PositionId.ToString();
            UserGroup.Value = user.UserGroup.ToString();
        }
    }
   
    protected void ImageButton1_Click(object sender, EventArgs e)
    {
        if (Calendar1.Visible == true)
        {
            Calendar1.Visible = false;
        }
        else
        {
            Calendar1.Visible = true;
        }
    }
    protected void ImageButton2_Click(object sender, EventArgs e)
    {
        if (Calendar2.Visible == true)
        {
            Calendar2.Visible = false;
        }
        else
        {
            Calendar2.Visible = true;
        }
    }
    protected void ImageButton3_Click(object sender, EventArgs e)
    {
        if (Calendar3.Visible == true)
        {
            Calendar3.Visible = false;
        }
        else
        {
            Calendar3.Visible = true;
        }
    }
    protected void ImageButton4_Click(object sender, EventArgs e)
    {
        if (Calendar4.Visible == true)
        {
            Calendar4.Visible = false;
        }
        else
        {
            Calendar4.Visible = true;
        }
    }
    protected void Calendar1_SelectionChanged(object sender, EventArgs e)
    {
        Calendar1.Visible = false;
        string year = Calendar1.SelectedDate.Year.ToString();
        string month = Calendar1.SelectedDate.Month.ToString();
        if (month.Length == 1)
        {
            month = "0" + month;
        }
        string day = Calendar1.SelectedDate.Day.ToString();
        if (day.Length == 1)
        {
            day = "0" + day;
        }
        TxtBeginTime.Text = year + "-" + month + "-" + day + " 07:50:00";
    }
    protected void Calendar2_SelectionChanged(object sender, EventArgs e)
    {
        Calendar2.Visible = false;
        string year = Calendar2.SelectedDate.Year.ToString();
        string month = Calendar2.SelectedDate.Month.ToString();
        if (month.Length == 1)
        {
            month = "0" + month;
        }
        string day = Calendar2.SelectedDate.Day.ToString();
        if (day.Length == 1)
        {
            day = "0" + day;
        }
        TxtEndTime.Text = year + "-" + month + "-" + day + " 17:30:00";
    }
    protected void Calendar3_SelectionChanged(object sender, EventArgs e)
    {
        Calendar3.Visible = false;
        string year = Calendar3.SelectedDate.Year.ToString();
        string month = Calendar3.SelectedDate.Month.ToString();
        if (month.Length == 1)
        {
            month = "0" + month;
        }
        string day = Calendar3.SelectedDate.Day.ToString();
        if (day.Length == 1)
        {
            day = "0" + day;
        }
        TxtDepartTime.Text = year + "-" + month + "-" + day + " 00:00:00";
    }
    protected void Calendar4_SelectionChanged(object sender, EventArgs e)
    {
        Calendar4.Visible = false;
        string year = Calendar4.SelectedDate.Year.ToString();
        string month = Calendar4.SelectedDate.Month.ToString();
        if (month.Length == 1)
        {
            month = "0" + month;
        }
        string day = Calendar4.SelectedDate.Day.ToString();
        if (day.Length == 1)
        {
            day = "0" + day;
        }
        TxtArriveTime.Text = year + "-" + month + "-" + day + " 00:00:00";
    }
    protected void BtnOk_Click(object sender, EventArgs e)
    {
        if (this.checktime()&&this.CheckValidate())
        {
            this.Save(1);
        }
    }
    protected bool checktime()
    {
        LblError.Text = "";
        int flag = 0;
        if (TxtBeginTime.Text == "" || TxtEndTime.Text == "") 
        {
            flag = 1;
           
        }
        if (TxtDays.Text == "") { flag = 2; }
        if (flag == 1) 
        {
            LblError.Text = "出差日期起止不能为空";
            Response.Write("<script>alert('出差日起止不能为空')</script>");
            TxtBeginTime.Focus();
            return false; 
        }
        else if (flag == 2) {
            LblError.Text = "出差天数不能为空";
            Response.Write("<script>alert('出差天数不能为空')</script>");
            TxtDays.Focus();
            return false;
        }
        else
        { return true; }
    
    }
    protected void Save(int state)
    {
        SqlConnection conn = dbConnection.getConnection();
        conn.Open();
        SqlTransaction tx = conn.BeginTransaction();
        try
        {
            int id = 1;
            SqlCommand cmd = new SqlCommand("select max(id) from OA_CH_BUSINESS_FORM", conn);
            cmd.Transaction = tx;
            try
            {
                id = Convert.ToInt32(cmd.ExecuteScalar().ToString()) + 1;
            }
            catch { }
            
            string total_result = "跑流程中";
            
            if (state == 2)
            {
                total_result = "未送件";
              
            }
            //添加表單
            cmd = new SqlCommand("insert into OA_CH_BUSINESS_FORM(id, form_id, emp_id, apply_date, " +
                "department_id, days, begin_time, end_time, depart_place, arrive_place, depart_time, " +
                "arrive_time, step, total_result, finish_date, state) values (" + id + ",'" + TxtFormId.Text + "','" +
                EmployeeId.Value + "','" + TxtApplyDate.Text + "','" + DepartmentId.Value + "','" + TxtDays.Text +
                "','" + TxtBeginTime.Text + "','" + TxtEndTime.Text + "','" + DdlDepartPlace.Text + "','" +
                DdlArrivePlace.Text + "','" + TxtDepartTime.Text + "','" + TxtArriveTime.Text + "',0,'" +
                total_result + "',''," + state + ")", conn);
            cmd.Transaction = tx;
            cmd.ExecuteNonQuery();
            //添加表身
            int detail_id = 1;
            cmd = new SqlCommand("select max(id) from OA_CH_BUSINESS_DETAIL", conn);
            cmd.Transaction = tx;
            try
            {
                detail_id = Convert.ToInt32(cmd.ExecuteScalar().ToString()) + 1;
            }
            catch { }
            #region
            int index = 1;
            //
            if (!TxtDate1.Text.Trim().Equals("") || !TxtDate1.Text.Trim().Equals(""))
            {
               
                cmd = new SqlCommand("insert into OA_CH_BUSINESS_DETAIL(id, form_id, number, date, " +
                    "d_start,d_end,tool,content,remark) values (" + detail_id + "," + id + ",'" + index + "','" +
                    TxtDate1.Text + "','" + TxtD_start1.Text + "','" + TxtD_end1.Text + "','" + TxtTool1.Text +
                    "','" + TxtContent1.Text + "','" + TxtRemark1.Text+ "')", conn);
                cmd.Transaction = tx;
                cmd.ExecuteNonQuery();
                detail_id++;
                index++;
            }
            if (!TxtDate2.Text.Trim().Equals("") || !TxtDate2.Text.Trim().Equals(""))
            {
                cmd = new SqlCommand("insert into OA_CH_BUSINESS_DETAIL(id, form_id, number, date, " +
                    "d_start,d_end,tool,content,remark) values (" + detail_id + "," + id + ",'" + index + "','" +
                    TxtDate2.Text + "','" + TxtD_start2.Text + "','" + TxtD_end2.Text + "','" + TxtTool2.Text +
                    "','" + TxtContent2.Text + "','" + TxtRemark2.Text + "')", conn);
                cmd.Transaction = tx;
                cmd.ExecuteNonQuery();
                detail_id++;
                index++;
            }
            if (!TxtDate3.Text.Trim().Equals("") || !TxtDate3.Text.Trim().Equals(""))
            {
                cmd = new SqlCommand("insert into OA_CH_BUSINESS_DETAIL(id, form_id, number, date, " +
                    "d_start,d_end,tool,content,remark) values (" + detail_id + "," + id + ",'" + index + "','" +
                    TxtDate3.Text + "','" + TxtD_start3.Text + "','" + TxtD_end3.Text + "','" + TxtTool3.Text +
                    "','" + TxtContent3.Text + "','" + TxtRemark3.Text + "')", conn);
                cmd.Transaction = tx;
                cmd.ExecuteNonQuery();
                detail_id++;
                index++;
            }
            if (!TxtDate4.Text.Trim().Equals("") || !TxtDate4.Text.Trim().Equals(""))
            {
                cmd = new SqlCommand("insert into OA_CH_BUSINESS_DETAIL(id, form_id, number, date, " +
                    "d_start,d_end,tool,content,remark) values (" + detail_id + "," + id + ",'" + index + "','" +
                    TxtDate4.Text + "','" + TxtD_start4.Text + "','" + TxtD_end4.Text + "','" + TxtTool4.Text +
                    "','" + TxtContent4.Text + "','" + TxtRemark4.Text + "')", conn);
                cmd.Transaction = tx;
                cmd.ExecuteNonQuery();
                detail_id++;
                index++;
            }
            if (!TxtDate5.Text.Trim().Equals("") || !TxtDate5.Text.Trim().Equals(""))
            {
                cmd = new SqlCommand("insert into OA_CH_BUSINESS_DETAIL(id, form_id, number, date, " +
                    "d_start,d_end,tool,content,remark) values (" + detail_id + "," + id + ",'" + index + "','" +
                    TxtDate5.Text + "','" + TxtD_start5.Text + "','" + TxtD_end5.Text + "','" + TxtTool5.Text +
                    "','" + TxtContent5.Text + "','" + TxtRemark5.Text + "')", conn);
                cmd.Transaction = tx;
                cmd.ExecuteNonQuery();
                detail_id++;
                index++;
            }
            //金额
           // if (!TxtDate1.Text.Trim().Equals("") || !TxtDate1.Text.Trim().Equals(""))
            // { 
          int detail_id1 = 1;
            cmd = new SqlCommand("select max(id) from OA_CH_BUSINESS_DETAIL1", conn);
            cmd.Transaction = tx;
            try
            {
                detail_id1 = Convert.ToInt32(cmd.ExecuteScalar().ToString()) + 1;
            }
            catch { }
           
                cmd = new SqlCommand("insert into OA_CH_BUSINESS_DETAIL1(id, form_id, f_eat, f_eat_remark, " +
                       "f_house,f_house_remark,f_move,f_move_remark,f_other,f_other_remark,f_total,f_total_remark)" +
                       " values ('" + detail_id1 + "','" + id + "','" +  TxtFAmt1.Text+ "','" +
                      TxtFRemark1.Text + "','" + TxtFAmt2.Text + "','" +
                      TxtFRemark2.Text + "','" + TxtFAmt3.Text+ "','" +
                      TxtFRemark3.Text + "','" + TxtFAmt4.Text + "','" +
                      TxtFRemark4.Text + "','" + TxtFAmt5.Text + "','" +
                      TxtFRemark5.Text + "')", conn);
                cmd.Transaction = tx;
                cmd.ExecuteNonQuery();
            
          //  catch (Exception e1) { Response.Write(e1.Message); }
                
            //}
          //
           
            #endregion
           //逐级签核
                
                ArrayList operator_id = new ArrayList();//记录上层节点职级小于登陆者的ID
                ArrayList name1 = new ArrayList();//记录上层节点职级小于登陆者的name
                ArrayList mail1 = new ArrayList();//记录上层节点职级小于登陆者的mail
                ArrayList last_id = new ArrayList();//记录上层节点的ID                
                ArrayList tmp_people = new ArrayList();//记录待签核人的ID
                ArrayList d_people = new ArrayList();
                ArrayList b_d_people = new ArrayList();
                ArrayList mail2 = new ArrayList();//记录代理人的MAIL
                ArrayList mail2_name = new ArrayList();//记录代理人姓名
                
             
                int ceng = 0;
                cmd = new SqlCommand("select ceng from oa_department where id="+DepartmentId.Value,conn);
                cmd.Transaction = tx;
                
                try
                {
                     ceng = Convert.ToInt32(cmd.ExecuteScalar());
                }
                catch { }
                    last_id.Add(DepartmentId.Value.ToString());
                   
                    for (int j = 1; j < ceng; j++)
                    {
                        cmd = new SqlCommand("select distinct last_id from oa_department where id=" + last_id[j - 1], conn);
                        cmd.Transaction = tx;
                        SqlDataReader dr2 = cmd.ExecuteReader();
                        while (dr2.Read())
                        {
                            last_id.Add(dr2["last_id"].ToString());
                        }
                      
                        dr2.Close();
                    }
                    //找到上层节点人的ID
                    for (int i = 0; i < last_id.Count; i++)
                    {
                        cmd = new SqlCommand("select a.id as id,a.email_work,a.emp_name from oa_employee as a left join oa_department as b on a.department_id=b.id" +
                       " where  b.id=" + last_id[i] + " and q_manger=1 order by position desc", conn);
                        cmd.Transaction = tx;
                        SqlDataReader dr1 = cmd.ExecuteReader();
                        while (dr1.Read())
                        {   
                            
                            operator_id.Add(dr1["id"].ToString());
                            name1.Add(dr1["emp_name"].ToString());
                            mail1.Add(dr1["email_work"].ToString());
                        }
                      
                        dr1.Close();
                    }
                   
               
               //是副董，跳過
                    for (int p = 0; p < operator_id.Count; p++)
                    {
                        if (Convert.ToInt32(operator_id[p]) == 128)
                        {
                            if (TxtFAmt5.Text.ToString().Equals("0"))
                            { 
                                operator_id.RemoveAt(p);
                            }
                        }
                    }
                    
                /*    for (int i = 0; i < 1; i++)
                    {
                        if (UserGroup.Value.Equals("1"))
                        {
                            cmd = new SqlCommand("select a.id as id from oa_employee as a left join oa_department as b on a.department_id=b.id" +
                         " where  b.id=56 and q_manger=1 order by position desc", conn);
                        }
                        else if (UserGroup.Value.Equals("2"))
                        {
                            cmd = new SqlCommand("select a.id as id from oa_employee as a left join oa_department as b on a.department_id=b.id" +
                         " where  b.id=90 and q_manger=1 order by position desc", conn);
                        }
                        cmd.Transaction = tx;
                        SqlDataReader dr1 = cmd.ExecuteReader();
                        while (dr1.Read())
                        {
                            operator_id.Add(dr1["id"].ToString());
                            
                        }
                        dr1.Close();
                    }*/
                  //  operator_id.Add("128");
                        //  确定是否有代理人签核
                        for (int k = 0; k < operator_id.Count; k++)
                        {
                            cmd = new SqlCommand("select d_people,b_d_people from oa_delegate where  s_date<=convert(varchar, getdate(), 120)" +
                                  " and e_date>=convert(varchar, getdate(),120) and b_d_people='" + operator_id[k] + "'", conn);
                            cmd.Transaction = tx;
                            SqlDataReader dr3 = cmd.ExecuteReader();
                            while (dr3.Read())
                            {
                                d_people.Add(dr3["d_people"].ToString());
                                b_d_people.Add(dr3["b_d_people"].ToString());
                                operator_id.RemoveAt(k);
                                operator_id.Add(dr3["d_people"].ToString());
                            }
                            dr3.Close();
                        }
                        //   是本人，跳過
                        for (int i = 0; i < operator_id.Count; i++)
                        {
                            if (operator_id[i].ToString().Equals(Session["user_id"].ToString())) { operator_id.RemoveAt(i); }
                        }  
                    //添加流程
                    int flow_id = 1;
              
                    cmd = new SqlCommand("select max(id) from OA_CH_APPROVEL_FORM_FLOW", conn);
                    cmd.Transaction = tx;
                    try
                    {
                        flow_id = Convert.ToInt32(cmd.ExecuteScalar().ToString()) + 1;
                    }
                    catch { }
                
                    for (int i = 0; i < operator_id.Count; i++)
                    {
                        cmd = new SqlCommand("insert into OA_CH_APPROVEL_FORM_FLOW(id, form_id, operator_id, " +
                            "apply_type, is_check, is_agree, comment, check_date, step, is_business)values(" +
                            flow_id + ", " + id + "," + operator_id[i] + ",2,'N','N','',''," + (i + 1) + ",'Y')", conn);
                        cmd.Transaction = tx;
                        cmd.ExecuteNonQuery();
                        flow_id++;
                    }
                  
                    if (state == 1)
                    {
                       // mail.mail_q(mail1[0], name1[0], TxtEmpName.Text, "中幹出差申請單");
                    }
                 
                   
                    tx.Commit();
                    Response.Redirect("my_list.aspx");
                }
               
                 
     
        catch (Exception ex)
        {
            Response.Write(ex.Message);
            Response.Write("没找到相應主管簽核，請聯繫管理員");
           // try
          //  {
           //     tx.Rollback();
           // }
         //   catch { }
        }
        conn.Close();  
    }
    protected void BtnSave_Click(object sender, EventArgs e)
    {
        this.Save(2);
    }
  /*  protected void total()
    {
        if (TxtFAmt5.Focus)
        {
            int total = 0;
            total = Convert.ToInt32(TxtFAmt1.Text) + Convert.ToInt32(TxtFAmt2.Text)
                 + Convert.ToInt32(TxtFAmt3.Text) + Convert.ToInt32(TxtFAmt4.Text) + Convert.ToInt32(TxtFAmt5.Text);
              TxtFAmt3.Text = total.ToString();
            return total;
        }
    }*/
    protected bool CheckValidate()
    {
       LblError.Text = "";
        int flag = 0;
        try
        {
            if (!(TxtFAmt1.Text == null || TxtFAmt1.Text == ""))
            { double day = Convert.ToDouble(TxtFAmt1.Text); }
        }
        catch
        {
            flag = 1;
            Response.Write("<script>alert('格式有误')</script>");
            LblError.Text = "膳食費用" + "格式有误";
            TxtFAmt1.Focus();
        }
        try
        {
            if (!(TxtFAmt2.Text == null || TxtFAmt2.Text == ""))
            {
                double day = Convert.ToDouble(TxtFAmt2.Text);
            }
        }
        catch
        {
            flag = 1;
            Response.Write("<script>alert('格式有误')</script>");
            LblError.Text = "住宿費用" + "格式有误";
            TxtFAmt2.Focus();
        }
        try
        {
            if (!(TxtFAmt3.Text == null || TxtFAmt3.Text == ""))
            {
                double day = Convert.ToDouble(TxtFAmt3.Text);
            }
        }
        catch
        {
            flag = 1;
            Response.Write("<script>alert('格式有误')</script>");
            LblError.Text = "交通費用" + "格式有误";
            TxtFAmt3.Focus();
        }
        try
        {
            if (!(TxtFAmt4.Text == null || TxtFAmt4.Text == ""))
            {
                double day = Convert.ToDouble(TxtFAmt4.Text);
            }
        }
        catch
        {
            flag = 1;
            Response.Write("<script>alert('格式有误')</script>");
            LblError.Text = "其他費用" + "格式有误";
            TxtFAmt4.Focus();
        }
        try
        {
           
                double day = Convert.ToDouble(TxtFAmt5.Text);
            
        }
        catch
        {
            flag = 1;
            Response.Write("<script>alert('格式有误')</script>");
            LblError.Text = "合計" + "格式有误";
            TxtFAmt5.Focus();
        }
          if (flag == 0)
        {
            return true;
        }
        else
        {
            return false;
        }
    }
    //遞歸取出辦理人-- position:7-副理; 2-副董
    protected void getEmployee(int department_id, int position)
    {
        int operator_id = 0;
        int flag = 0;
        SqlConnection conn = dbConnection.getConnection();
        conn.Open();
        string sql = "select id from OA_EMPLOYEE where department_id=" + department_id + " and position=" + position;
        if (position == 2)
        {
            sql = "select id from OA_EMPLOYEE where position=" + position;
        }
        SqlCommand cmd = new SqlCommand(sql, conn);
        SqlDataReader dr = cmd.ExecuteReader();
        if (dr.Read())
        {
            operator_id = Convert.ToInt32(dr["id"].ToString());
            OperatorId.Value = operator_id.ToString();
        }
        else
        {
            flag = 1;
        }
        dr.Close();
        count = count + 1;
        if (count == 6)
        {
            flag = 0;
            OperatorId.Value = "0";
        }
        if (flag == 1)
        {
            cmd = new SqlCommand("select last_id from OA_DEPARTMENT where id=" + department_id, conn);
            this.getEmployee(Convert.ToInt32(cmd.ExecuteScalar()), position);
        }
        conn.Close();
    }
    //遞歸取自由流程
    protected void GetFlow(int main_id, int number, SqlConnection conn, SqlTransaction tx)
    {
        string sql = "select top 1 apply_type, operator_id, number, next_number, " +
            "larger_than, larger_next from OA_FLOW_DETAIL where main_id=" + main_id + " order by number";
        if (number != 0)
        {
            sql = "select top 1 apply_type, operator_id, number, next_number, " +
             "larger_than, larger_next from OA_FLOW_DETAIL where main_id=" + main_id + " and number=" + number;
        }
        SqlCommand cmd = new SqlCommand(sql, conn);
        cmd.Transaction = tx;
        int next = 0;
        int flag = 0;
        SqlDataReader dr = cmd.ExecuteReader();
        if (dr.Read())
        {
            apply_type.Add(dr["apply_type"].ToString());
            operator_id.Add(dr["operator_id"].ToString());
            if (!dr["larger_than"].ToString().Equals("0"))
            {
                if (Convert.ToInt32(dr["larger_than"].ToString()) < Convert.ToInt32(TxtDays.Text))
                {
                    if (!dr["larger_next"].Equals(""))
                    {
                        flag = 1;
                        next = Convert.ToInt32(dr["larger_next"].ToString());
                    }
                }
                else
                {
                    if (!dr["next_number"].Equals(""))
                    {
                        flag = 1;
                        next = Convert.ToInt32(dr["next_number"].ToString());
                    }
                }
            }
            else
            {
                if (!dr["next_number"].ToString().Equals(""))
                {
                    flag = 1;
                    next = Convert.ToInt32(dr["next_number"].ToString());
                }
            }
        }
        dr.Close();
        if (flag == 1)
        {
            this.GetFlow(main_id, next, conn, tx);
        }
    }
}

						