OA系统

开发平台：
ASP/ASPX

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_tw_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)
        {
            LoginDAO.CheckLogin(Session, Response, "../../", 2);
            if (Session["user"] != null)
            {
                DateMgr mgr = new DateMgr();
                User user = (User)Session["user"];
                TxtApplyDate.Text = mgr.getDateTime();
                TxtFormNo.Text = mgr.getTime();
                TxtEmpName.Text = user.Emp_name;
                EmpId.Value = user.Id.ToString();
                TxtEmpNo.Text = user.Emp_no;
                TxtDepartment.Text = user.Department.Full_name;
                DepartmentId.Value = user.Department.Id.ToString();
                TxtPosition.Text = user.Position;
                PositionSequence.Value = user.PositionSequence.ToString();
                PositionId.Value = user.PositionId.ToString();
                Session["department_id"] = user.Department.Id.ToString();
            }
        }
    }
    protected void ImageButton1_Click(object sender, EventArgs e)
    {
        if (Calendar1.Visible == true)
        {
            Calendar1.Visible = false;
            Calendar1.Focus();
        }
        else
        {
            Calendar1.Visible = true;
            Calendar1.Focus();
        }
    }
    protected void ImageButton2_Click(object sender, EventArgs e)
    {
        if (Calendar2.Visible == true)
        {
            Calendar2.Visible = false;
            Calendar2.Focus();
        }
        else
        {
            Calendar2.Visible = true;
            Calendar2.Focus();
        }
    }
    protected void ImageButton3_Click(object sender, EventArgs e)
    {
        if (Calendar3.Visible == true)
        {
            Calendar3.Visible = false;
            TxtBusinessEnd.Focus();
        }
        else
        {
            Calendar3.Visible = true;
            TxtBusinessEnd.Focus();
        }
    }
    protected void ImageButton4_Click(object sender, EventArgs e)
    {
        if (Calendar4.Visible == true)
        {
            Calendar4.Visible = false;
            TxtReason.Focus();
           
        }
        else
        {
            Calendar4.Visible = true;
            TxtReason.Focus();
            
        }
    }
    protected void ImageButton5_Click(object sender, EventArgs e)
    {
        if (Calendar5.Visible == true)
        {
            Calendar5.Visible = false;
            
        }
        else
        {
            Calendar5.Visible = true;
            TxtFlightBackTime.Focus();
        }
    }
    protected void ImageButton6_Click(object sender, EventArgs e)
    {
        if (Calendar6.Visible == true)
        {
            Calendar6.Visible = false;
            
        }
        else
        {
            Calendar6.Visible = true;
            DdlFlightBackDepart.Focus();
        }
    }
    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;
        }
        TxtVacationBegin.Text = year + "-" + month + "-" + day + " 00:00:00";
        TxtVacationBegin.Focus();
    }
    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;
        }
        TxtVacationEnd.Text = year + "-" + month + "-" + day + " 00:00:00";
        TxtVacationEnd.Focus();
    }
    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;
        }
        TxtBusinessBegin.Text = year + "-" + month + "-" + day + " 00:00:00";
        TxtBusinessEnd.Focus();
    }
    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;
        }
        TxtBusinessEnd.Text = year + "-" + month + "-" + day + " 00:00:00";
        TxtReason.Focus();
    }
    protected void Calendar5_SelectionChanged(object sender, EventArgs e)
    {
        Calendar5.Visible = false;
        string year = Calendar5.SelectedDate.Year.ToString();
        string month = Calendar5.SelectedDate.Month.ToString();
        if (month.Length == 1)
        {
            month = "0" + month;
        }
        string day = Calendar5.SelectedDate.Day.ToString();
        if (day.Length == 1)
        {
            day = "0" + day;
        }
        TxtFlightGoTime.Text = year + "-" + month + "-" + day + " 00:00:00";
        TxtFlightBackTime.Focus();
    }
    protected void Calendar6_SelectionChanged(object sender, EventArgs e)
    {
        Calendar6.Visible = false;
        string year = Calendar6.SelectedDate.Year.ToString();
        string month = Calendar6.SelectedDate.Month.ToString();
        if (month.Length == 1)
        {
            month = "0" + month;
        }
        string day = Calendar6.SelectedDate.Day.ToString();
        if (day.Length == 1)
        {
            day = "0" + day;
        }
        TxtFlightBackTime.Text = year + "-" + month + "-" + day + " 00:00:00";
        DdlFlightBackDepart.Focus();
    }
  
    protected void BtnSave_Click(object sender, EventArgs e)
    {
        this.save(2);
    }
    protected void BtnOk_Click(object sender, EventArgs e)
    {
        this.save(1);
    }
   
    protected void save(int state)
    {
        if (this.CheckValidate()&&this.checktime())
        {
            SqlConnection conn = dbConnection.getConnection();
            conn.Open();
            SqlTransaction tx = conn.BeginTransaction();
            string sql = "";
            try
            {
                int id = 1;
                SqlCommand cmd = new SqlCommand("select max(id) from OA_TW_APPROVEL_FORM", conn);
                cmd.Transaction = tx;
                try
                {
                    id = Convert.ToInt32(cmd.ExecuteScalar().ToString()) + 1;
                }
                catch { }
                string total_result = "跑流程中";
                if (state == 2)
                {
                    total_result = "未送件";
                }
                sql = "insert into OA_TW_APPROVEL_FORM(id, form_id, emp_id, department_id, delegate_id, " +
                    "off_type, parenthesis, days, vacation_begin, vacation_end, business_place," +
                    "vacation_place, flight_go_depart, flight_go_arrive, flight_go_time, flight_back_time, " +
                    "flight_back_depart, flight_back_arrive, business_begin, business_end, reason, " +
                    "step, total_result, finish_date, is_del, apply_date, state) values (" +
                    id + ", '" + TxtFormNo.Text + "','" + EmpId.Value + "', '" + DepartmentId.Value + "','" +
                    DelegateId.Value + "','" + DdlOffType.SelectedValue + "','" + TxtParenthesis.Text + "','" +
                    TxtDays.Text + "','" + TxtVacationBegin.Text + "','" + TxtVacationEnd.Text + "','" +
                    DdlBusinessPlace.SelectedValue + "','" + DdlVacationPlace.SelectedValue + "','" +
                    DdlFlightGoDepart.SelectedValue + "','" + DdlFlightGoArrive.SelectedValue + "','" +
                    TxtFlightGoTime.Text + "','" + TxtFlightBackTime.Text + "','" +
                    DdlFlightBackDepart.SelectedValue + "','" + DdlFlightBackArrive.SelectedValue + "','" +
                    TxtBusinessBegin.Text + "','" + TxtBusinessEnd.Text + "','" + TxtReason.Text + "'," +
                    "0,'" + total_result + "','','N','" + TxtApplyDate.Text + "','" + state + "')";
                cmd = new SqlCommand(sql, conn);
                cmd.Transaction = tx;
                cmd.ExecuteNonQuery();
                int flow_id = 1;
                cmd = new SqlCommand("select max(id) from OA_TW_APPROVEL_FORM_FLOW", conn);
                cmd.Transaction = tx;
                try
                {
                    flow_id = Convert.ToInt32(cmd.ExecuteScalar().ToString()) + 1;
                }
                catch { }
                cmd = new SqlCommand("select max(id) from OA_delegate", conn);
                cmd.Transaction = tx;
                
                //跑代理人            
                cmd = new SqlCommand( "select email_work from oa_employee where id=" + DelegateId.Value, conn);
                 cmd.Transaction = tx;                
                string email_work = cmd.ExecuteScalar().ToString();
               
                  
                sql = "insert into OA_TW_APPROVEL_FORM_FLOW(id, form_id, operator_id, " +
                    "apply_type, is_check, is_agree, comment, check_date, step) values (" +
                    flow_id + ", " + id + "," + DelegateId.Value + ",2,'N','N','','',1)";
                cmd = new SqlCommand(sql, conn);
                cmd.Transaction = tx;
                cmd.ExecuteNonQuery();
                mail.mail_d(email_work, TxtDelegate.Text.Substring(7), TxtEmpName.Text);
                
                if (state == 1)
                {//逐级签核
                    flow_id++;
                    ArrayList id1 = new ArrayList();//记录上层节点职级小于登陆者的ID
                    ArrayList name1 = new ArrayList();//记录上层节点职级小于登陆者的name
                    ArrayList mail1 = new ArrayList();//记录上层节点职级小于登陆者的mail
                    ArrayList last_id = new ArrayList();//记录上层节点的ID
                    ArrayList ceng = 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();//记录代理人姓名
                    //判断是否为副董办公室
                    if (DepartmentId.Value.ToString().Equals("50")) {
                                               
                              cmd = new SqlCommand("insert into OA_TW_APPROVEL_FORM_FLOW(id,form_id, operator_id, " +
                                  "apply_type, is_check, is_agree, comment, check_date, step)values(" +
                                  flow_id + ", " + id + ",'128',2,'N','N','',''," + 2 + ")", conn);
                              cmd.Transaction = tx;
                              cmd.ExecuteNonQuery();
                          
                              flow_id++;
                           cmd = new SqlCommand("update OA_TW_APPROVEL_FORM_FLOW set total_result='同意' where id=" + flow_id, conn);
                        
                          //代理人资料（OA_DELEGATE）
                        
                              cmd = new SqlCommand("insert into OA_DELEGATE(d_people,b_d_people,s_date,e_date)values('"
                              + DelegateId.Value + "','" + Session["user_id"] + "','" + TxtVacationBegin.Text + "','" + TxtVacationEnd.Text + "')", conn);
                              cmd.Transaction = tx;
                              cmd.ExecuteNonQuery();
                              flow_id++;
                        
                          tx.Commit();
                          Response.Redirect("my_list.aspx");
                   
                      } 
                    //判断职级，大于8的是一个情况
                    if (Convert.ToInt32(PositionId.Value) > 8) {
                       
                  
                        //找到上层节点部门的ID
                        last_id.Add(DepartmentId.Value.ToString());
                        for (int j = 1; j < 2; 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 = 1; 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  position<" + PositionId.Value + "and b.id=" + last_id[i] + " and q_manger=1 order by position desc", conn);
                           cmd.Transaction = tx;
                            SqlDataReader dr1 = cmd.ExecuteReader();
                            while (dr1.Read())
                            {
                                id1.Add(dr1["id"].ToString());
                                name1.Add(dr1["emp_name"].ToString());
                                mail1.Add(dr1["email_work"].ToString());
                                tmp_people.Add(dr1["id"].ToString());
                            }
                            dr1.Close();
                        }
                       
                    }
                       //职级小于8的是一个情况
                    else if (Convert.ToInt32(PositionId.Value) <= 8)
                    {
                  
                        //找到上层节点部门的ID
                        last_id.Add(DepartmentId.Value.ToString());
                        for (int j = 1; j < 5; 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
                        if (last_id.Count != 0)
                        {
                            for (int i = 1; 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  position<" + PositionId.Value + "and b.id=" + last_id[i] + " and q_manger=1 order by position desc", conn);
                                cmd.Transaction = tx;
                                SqlDataReader dr1 = cmd.ExecuteReader();
                                while (dr1.Read())
                                {
                                    id1.Add(dr1["id"].ToString());
                                    name1.Add(dr1["emp_name"].ToString());
                                    mail1.Add(dr1["email_work"].ToString());
                                 
                                } dr1.Close();
                                
                            }
                        }
                    //  确定是否有代理人签核
                        for (int k = 0; k < id1.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='" + id1[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());
                                id1.RemoveAt(k);
                                id1.Add(dr3["d_people"].ToString());
                            }
                            dr3.Close();
                        }
                        
                     //   
                      
                    }
                   
                    if (id1.Count!= null)
                    {
                      
                        for (int i = 0; i < id1.Count; i++)
                        {
                            cmd = new SqlCommand("insert into OA_TW_APPROVEL_FORM_FLOW(id,form_id, operator_id, " +
                                "apply_type, is_check, is_agree, comment, check_date, step)values(" +
                                flow_id + ", " + id + "," + id1[i] + ",2,'N','N','',''," + (i + 2) + ")", conn);
                            cmd.Transaction = tx;
                            cmd.ExecuteNonQuery();
                    
                           }                         
                   
                    for (int d = 0; d < id1.Count; d++)
                        {
                            cmd = new SqlCommand("insert into OA_DELEGATE(d_people,b_d_people,s_date,e_date)values('"
                            +DelegateId.Value + "','" + Session["user_id"] + "','" + TxtVacationBegin.Text+"','"+TxtVacationEnd.Text+"')", conn);
                            cmd.Transaction = tx;
                            cmd.ExecuteNonQuery();
                           
                            flow_id++;
                        }
                        tx.Commit();
                        Response.Redirect("my_list.aspx");
                    }
                    else
                    {
                        LblError.Text = "沒有找到相關處理流程, 請與管理員聯繫";
                        tx.Rollback();
                    }
                }
                else
                {
                    tx.Commit();
                    Response.Redirect("my_list.aspx");
                }
                #region
              
                #endregion
            }
            catch (Exception ex)
            {
                Response.Write(ex.Message);
                try
                {
                    tx.Rollback();
                }
                catch { }
            }
            conn.Close();
        }
    }
    //遞歸取出辦理人-- position:6-經理; 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);
        }
    }
    protected bool CheckValidate()
    {
        LblError.Text = "";
        int flag = 0;
        try
        {
            double day = Convert.ToDouble(TxtDays.Text);
        }
        catch
        {
            flag = 1;
            Response.Write("<script>alert('工作日数格式有误')</script>");
            LblError.Text = "工作日数格式有误";
            TxtDays.Focus();
        }
        if (DelegateId.Value.Equals("") || DelegateId.Value.Equals("0"))
        {
            flag = 1;
            Response.Write("<script>alert('請選擇代理人')</script>");
            LblError.Text = "請選擇代理人";
            TxtDelegate.Focus();
        }
        if (flag == 0)
        {
            return true;
        }
        else
        {
            return false;
        }
    }
      protected bool checktime() {
        LblError.Text = "";
        int flag = 0;
       
        if (DdlOffType.SelectedItem.Text.Equals("出差"))
        {
            if (TxtBusinessBegin.Text == "" || TxtBusinessEnd.Text == "")
            { flag = 2; }
        }
       else
        {
            if (TxtVacationBegin.Text == "" || TxtVacationEnd.Text == "")
            { flag = 1; }
        }
        if (flag == 1)
        {
            Response.Write("<script>alert('休假日起止不能为空')</script>");
            LblError.Text = "休假日起止不能为空";
            TxtVacationBegin.Focus();
            return false;
        }
        else if (flag == 2)
        {
            Response.Write("<script>alert('出差日起止不能为空')</script>");
            LblError.Text = "出差日起止不能为空";
            TxtBusinessBegin.Focus();
            return false;
        }
        else
        { 
            return true; 
        }
    }
    protected void DdlOffType_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (DdlOffType.SelectedItem.Text.Equals("出差"))
        {
            TxtBusinessBegin.Enabled = true;
            TxtBusinessEnd.Enabled = true;
            ImageButton3.Enabled = true;
            ImageButton4.Enabled = true;
            LblBusinessBegin.Enabled = true;
            LblBusinessEnd.Enabled = true;
            LblBusinessPlace.Enabled = true;
            DdlBusinessPlace.Enabled = true;
            LblDays.Text = "工作日數";
            DdlOffType.Focus();
            
            TxtVacationBegin.Enabled = false;
            TxtVacationEnd.Enabled = false;
            DdlVacationPlace.Enabled = false;
            ImageButton1.Enabled = false;
            ImageButton2.Enabled = false;
            LblVacationBegin.Enabled = false;
            LblVacationEnd.Enabled = false;
            LblVacationPlace.Enabled = false;
        }
        else
        {
            TxtBusinessBegin.Enabled = false;
            TxtBusinessEnd.Enabled = false;
            ImageButton3.Enabled = false;
            ImageButton4.Enabled = false;
            LblBusinessBegin.Enabled = false;
            LblBusinessEnd.Enabled = false;
            LblBusinessPlace.Enabled = false;
            DdlBusinessPlace.Enabled = false;
            LblDays.Text = "休假日數";
            DdlOffType.Focus();
            TxtVacationBegin.Enabled = true;
            TxtVacationEnd.Enabled = true;
            DdlVacationPlace.Enabled = true;
            ImageButton1.Enabled = true;
            ImageButton2.Enabled = true;
            LblVacationBegin.Enabled = true;
            LblVacationEnd.Enabled = true;
            LblVacationPlace.Enabled = true;
            
        }
    }
}

						