OA系统

开发平台：
ASP/ASPX

finish_list.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;
public partial class web_approvel_ch_finish_list : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            LoginDAO.CheckLogin(Session, Response, "../../", 2);
            this.SetMainTable();
            if (Request.QueryString["f_id"] != null)
            {
                PnlApprovel.Visible = true;
                PnlDeal.Visible = true;
                this.SetValue(Request.QueryString["f_id"]);
                this.SetAmtValue(Request.QueryString["f_id"]);
            }
            if (Request.QueryString["o_id"] != null)
            {
                PnlFlow.Visible = true;
                PnlOff.Visible = true;
                PnlDeal.Visible = true;
                this.SetOffValue(Request.QueryString["o_id"]);
            }
        }
    }
    protected void SetMainTable()
    {
        SqlConnection conn = dbConnection.getConnection();
        conn.Open();
        string user_id = "0";
        if (Session["user_id"] != null)
        {
            user_id = Session["user_id"].ToString();
        }
        ArrayList ids = new ArrayList();
        ArrayList form_ids = new ArrayList();
        ArrayList is_businesses = new ArrayList();
        SqlCommand cmd = new SqlCommand("SELECT f.id, f.form_id, f.is_business FROM dbo.OA_CH_APPROVEL_FORM_FLOW AS f " +
            " WHERE (f.operator_id = " + user_id + ") AND (f.is_check = 'Y')", conn);
        SqlDataReader dr = cmd.ExecuteReader();
        while (dr.Read())
        {
            ids.Add(dr["id"].ToString());
            form_ids.Add(dr["form_id"].ToString());
            is_businesses.Add(dr["is_business"].ToString());
        }
        dr.Close();
        for (int i = ids.Count - 1; i >= 0; i--)
        {
            if (is_businesses[i].Equals("Y"))
            {
                cmd = new SqlCommand("select e.emp_name, b.apply_date, b.step,f.is_agree from OA_CH_APPROVEL_FORM_FLOW as f left join"+
                    " OA_CH_BUSINESS_FORM b on f.form_id=b.id inner join " +
                    "OA_EMPLOYEE e on b.emp_id=e.id where b.id=" + form_ids[i]+"and is_business='Y' and operator_id="+Session["user_id"], conn);
                dr = cmd.ExecuteReader();
                if (dr.Read())
                {
                    TblFlow.Visible = true;
                    TableRow tr = new TableRow();
                    TableCell td = new TableCell();
                    td.BorderWidth = Unit.Pixel(1);
                    td.Text = dr["emp_name"].ToString();
                    tr.Cells.Add(td);
                    td = new TableCell();
                    td.BorderWidth = Unit.Pixel(1);
                    td.Text = dr["emp_name"].ToString() + "的出差單";
                    tr.Cells.Add(td);
                    td = new TableCell();
                    td.BorderWidth = Unit.Pixel(1);
                    td.Text = dr["apply_date"].ToString();
                    tr.Cells.Add(td);
                    td = new TableCell();
                    td.BorderWidth = Unit.Pixel(1);
                    if(dr["is_agree"].ToString().Equals("Y"))
                    {
                        td.Text = "同意";
                        tr.Cells.Add(td);
                    }
                    else
                    {
                        td.Text = "不同意";
                        tr.Cells.Add(td);
                    }
                   
                    td = new TableCell();
                    td.BorderWidth = Unit.Pixel(1);
                    HyperLink hl = new HyperLink();
                    hl.Text = "查看";
                    hl.NavigateUrl = "finish_list.aspx?f_id=" + ids[i].ToString();
                    td.Controls.Add(hl);
                    tr.Cells.Add(td);
                    TblFlow.Rows.Add(tr);
                }
                dr.Close();
            }
            else
            {
                cmd = new SqlCommand("select e.emp_name, o.apply_date, t.name off_type,f.is_agree"+
                    " from OA_CH_APPROVEL_FORM_FLOW as f left join OA_CH_OFF_FORM o on f.form_id=o.id " +
                    " inner join OA_EMPLOYEE e on o.emp_id=e.id inner join OA_CH_OFF_TYPE t on o.off_type=t.id " +
                    " where o.id=" + form_ids[i]+" and is_business='N' and operator_id="+Session["user_id"], conn);
                dr = cmd.ExecuteReader();
                if (dr.Read())
                {
                    TblFlow.Visible = true;
                    TableRow tr = new TableRow();
                    TableCell td = new TableCell();
                    td.BorderWidth = Unit.Pixel(1);
                    td.Text = dr["emp_name"].ToString();
                    tr.Cells.Add(td);
                    td = new TableCell();
                    td.BorderWidth = Unit.Pixel(1);
                    td.Text = dr["emp_name"].ToString() + "的" + dr["off_type"].ToString() + "單";
                    tr.Cells.Add(td);
                    td = new TableCell();
                    td.BorderWidth = Unit.Pixel(1);
                    td.Text = dr["apply_date"].ToString();
                    tr.Cells.Add(td);
                    td = new TableCell();
                    td.BorderWidth = Unit.Pixel(1);
                    if (dr["is_agree"].ToString().Equals("Y"))
                    {
                        td.Text = "同意";
                        tr.Cells.Add(td);
                    }
                    else
                    {
                        td.Text = "不同意";
                        tr.Cells.Add(td);
                    }
                    td = new TableCell();
                    td.BorderWidth = Unit.Pixel(1);
                    HyperLink hl = new HyperLink();
                    hl.Text = "查看";
                    hl.NavigateUrl = "finish_list.aspx?o_id=" + ids[i].ToString();
                    td.Controls.Add(hl);
                    tr.Cells.Add(td);
                    TblFlow.Rows.Add(tr);
                }
                dr.Close();
            }
        }
        conn.Close();
    }
    protected void SetAmtValue(string id)
    {
        SqlConnection conn = dbConnection.getConnection();
        conn.Open();
        SqlCommand cmd = new SqlCommand("select * from OA_CH_BUSINESS_DETAIL where form_id=" + id, conn);
        SqlDataReader dr = cmd.ExecuteReader();
        while (dr.Read())
        {
            TxtFAmt1.Text = dr["f_eat"].ToString();
            TxtFRemark1.Text = dr["f_eat_remark"].ToString();
            TxtFAmt2.Text = dr["f_house"].ToString();
            TxtFRemark2.Text = dr["f_house_remark"].ToString();
            TxtFAmt3.Text = dr["f_move"].ToString();
            TxtFRemark3.Text = dr["f_move_remark"].ToString();
            TxtFAmt4.Text = dr["f_other"].ToString();
            TxtFRemark4.Text = dr["f_other_remark"].ToString();
            TxtFAmt5.Text = dr["f_total"].ToString();
            TxtFRemark5.Text = dr["f_total_remark"].ToString();
        }
        dr.Close();
        conn.Close();
    }
    protected void SetValue(string id)
    {
        SqlConnection conn = dbConnection.getConnection();
        conn.Open();
        int form_id = 0;
        string is_business = "";
        SqlCommand cmd = new SqlCommand("select form_id, is_agree, comment, check_date, is_business from OA_CH_APPROVEL_FORM_FLOW where id=" + id, conn);
        SqlDataReader dr = cmd.ExecuteReader();
        if (dr.Read())
        {
            form_id = Convert.ToInt32(dr["form_id"].ToString());
            RbAgree.SelectedValue = dr["is_agree"].ToString();
            TxtComment.Text = dr["comment"].ToString();
            is_business = dr["is_business"].ToString();
        }
        dr.Close();
        FormId.Value = form_id.ToString();
        if (is_business.Equals("Y"))
        {
            PnlApprovel.Visible = true;
            cmd = new SqlCommand("select a.form_id, e.emp_name, e.emp_no, p.name position, a.apply_date," +
                "d.name department, a.days, a.begin_time, a.end_time, depart_place, arrive_place, " +
                "a.depart_time, a.arrive_time from OA_CH_BUSINESS_FORM a inner join OA_EMPLOYEE e on a.emp_id=e.id " +
                "inner join OA_DEPARTMENT d on a.department_id=d.id inner join OA_EMPLOYEE_POSITION p on " +
                "e.position=p.id  where a.id=" + form_id, conn);
            dr = cmd.ExecuteReader();
            if (dr.Read())
            {
                TxtFormId.Text = dr["form_id"].ToString();
                TxtEmpName.Text = dr["emp_name"].ToString();
                TxtEmpNo.Text = dr["emp_no"].ToString();
                TxtPosition.Text = dr["position"].ToString();
                TxtApplyDate.Text = dr["apply_date"].ToString();
                TxtDepartment.Text = dr["department"].ToString();
                TxtDays.Text = dr["days"].ToString();
                TxtBeginTime.Text = dr["begin_time"].ToString();
                TxtEndTime.Text = dr["end_time"].ToString();
                TxtDepartPlace.Text = dr["depart_place"].ToString();
                TxtArrivePlace.Text = dr["arrive_place"].ToString();
                TxtDepartTime.Text = dr["depart_time"].ToString();
                TxtArriveTime.Text = dr["arrive_time"].ToString();
            }
            dr.Close();
        }
        conn.Close();
        this.SetTable(form_id);
    }
    protected void SetOffValue(string id)
    {
        SqlConnection conn = dbConnection.getConnection();
        conn.Open();
        int form_id = 0;
        SqlCommand cmd = new SqlCommand("select form_id, is_agree, comment, check_date from OA_CH_APPROVEL_FORM_FLOW where id=" + id, conn);
        SqlDataReader dr = cmd.ExecuteReader();
        if (dr.Read())
        {
            form_id = Convert.ToInt32(dr["form_id"].ToString());
            RbAgree.SelectedValue = dr["is_agree"].ToString();
            TxtComment.Text = dr["comment"].ToString();
            LblCheckDate.Text = dr["check_date"].ToString();
        }
        dr.Close();
        cmd = new SqlCommand("select o.form_id, e.emp_no, e.emp_name, d.name department, " +
            "e.emp_name delegate, e.position position, " +
            "t.name off_type, o.begin_time, o.end_time, o.hours, o.apply_date, o.parenthesis, " +
            "o.reason from OA_CH_OFF_FORM o inner join OA_EMPLOYEE e on o.emp_id=e.id inner join " +
            "OA_DEPARTMENT d on o.department_id=d.id inner join OA_CH_OFF_TYPE t on " +
            "o.off_type=t.id where o.id=" + form_id, conn);
        dr = cmd.ExecuteReader();
        if (dr.Read())
        {
            TxtOffFormId.Text = dr["form_id"].ToString();
            TxtOffEmpName.Text = dr["emp_no"].ToString() + dr["emp_name"].ToString();
            TxtOffDepartment.Text = dr["department"].ToString();
            TxtDelegate.Text = dr["delegate"].ToString();
            TxtOffPosition.Text = dr["position"].ToString();
            TxtOffType2.Text = dr["off_type"].ToString();
            TxtOffBeginTime.Text = dr["begin_time"].ToString();
            TxtOffEndTime.Text = dr["end_time"].ToString();
            TxtHours.Text = dr["hours"].ToString();
            TxtOffApplyDate.Text = dr["apply_date"].ToString();
            TxtParenthesis.Text = dr["parenthesis"].ToString();
            TxtReason.Text = dr["reason"].ToString();
        }
        dr.Close();
        conn.Close();
    }
    protected void SetTable(int form_id)
    {
        SqlConnection conn = dbConnection.getConnection();
        conn.Open();
        int flag = 0;
        SqlCommand cmd = new SqlCommand("select * from OA_CH_BUSINESS_DETAIL  where form_id=" + form_id +
            " order by number", conn);
        SqlDataReader dr = cmd.ExecuteReader();
        while (dr.Read())
        {
            flag = 1;
            //動態創建表格行
            TableRow tr1 = new TableRow();
            TableCell td1 = new TableCell();
            td1.BorderWidth = Unit.Pixel(1);
            Label label = new Label();
            label.BorderStyle = BorderStyle.None;
            label.Text = dr["number"].ToString();
            td1.Controls.Add(label);
            tr1.Cells.Add(td1);
            TableCell td2 = new TableCell();
            td2.BorderWidth = Unit.Pixel(1);
            label = new Label();
            label.BorderStyle = BorderStyle.None;
            label.Text = dr["date"].ToString();
            td2.Controls.Add(label);
            tr1.Cells.Add(td2);
            TableCell td3 = new TableCell();
            td3.BorderWidth = Unit.Pixel(1);
            label = new Label();
            label.BorderStyle = BorderStyle.None;
            label.Text = dr["d_start"].ToString();
            td3.Controls.Add(label);
            tr1.Cells.Add(td3);
            TableCell td4 = new TableCell();
            td4.BorderWidth = Unit.Pixel(1);
            label = new Label();
            label.BorderStyle = BorderStyle.None;
            label.Text = dr["d_end"].ToString();
            td4.Controls.Add(label);
            tr1.Cells.Add(td4);
            TableCell td5 = new TableCell();
            td5.BorderWidth = Unit.Pixel(1);
            label = new Label();
            label.BorderStyle = BorderStyle.None;
            label.Text = dr["tool"].ToString();
            td5.Controls.Add(label);
            tr1.Cells.Add(td5);
            TableCell td6 = new TableCell();
            td6.BorderWidth = Unit.Pixel(1);
            label = new Label();
            label.BorderStyle = BorderStyle.None;
            label.Text = dr["content"].ToString();
            td6.Controls.Add(label);
            tr1.Cells.Add(td6);
            TableCell td7 = new TableCell();
            td7.BorderWidth = Unit.Pixel(1);
            label = new Label();
            label.BorderStyle = BorderStyle.None;
            label.Text = dr["remark"].ToString();
            td7.Controls.Add(label);
            tr1.Cells.Add(td7);
            TblDetail.Rows.Add(tr1);
        }
        dr.Close();
        conn.Close();
        if (flag == 0)
        {
            TblDetail.Visible = false;
        }
    }
}

						