OA系统

开发平台：
ASP/ASPX

select_edit.aspx.cs：源码内容
							﻿using System;
using System.Data;
using System.Data.SqlClient;
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;
public partial class web_new_repair_select_edit : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection conn = dbConnection.getConnection();
        conn.Open();
        if (!IsPostBack)
        {
            ArrayList array = new ArrayList();
            array = (ArrayList)Session["s_1"];
            if (array.Count != 0)
            {
                for (int j = 0; j < array.Count; j++)
                {
                    DropDownList1.Items.Add(Convert.ToString(j + 1));
                }
            }
            if (Request.QueryString["form_id"] != null)
            {
                bind(Request.QueryString["form_id"]);
                for (int i = 0; i < array.Count; i++)
                {
                    if (array[i].ToString().Equals(Request.QueryString["form_id"].ToString()))
                    {
                        DropDownList1.SelectedIndex = i;
                    }
                }
            }
        }
    }
    public void bind(string s)
    {
        string str = "";
        SqlConnection conn = dbConnection.getConnection();
        conn.Open();
        form_id.Text = s;
        SqlCommand sqlcom4 = new SqlCommand("select * from oa_repair where form_id='" + s + "'", conn);
        SqlDataReader dr4 = sqlcom4.ExecuteReader();
        if (dr4.HasRows)
        {
            while (dr4.Read())
            {
                area.Text = dr4["area"].ToString().Trim();
                level.Text = dr4["Level"].ToString().Trim();
                bxperson.Text = dr4["bxperson"].ToString().Trim();
                department.Text = dr4["department"].ToString();
                type.Text = dr4["type"].ToString();
                equipment.Text = dr4["equipment"].ToString();
                create_time.Text = dr4["create_time"].ToString();
                SqlConnection conn1 = dbConnection.getConnection();
                conn1.Open();
                SqlCommand sqlcom5 = new SqlCommand("select emp_name from oa_employee where id=" + Convert.ToInt32(dr4["lbperson"]), conn1);
                SqlDataReader dr5 = sqlcom5.ExecuteReader();
                if (dr5.HasRows)
                {
                    while (dr5.Read())
                    {
                        lbperson.Text = dr5["emp_name"].ToString();
                    }
                }
                dr5.Close();
                SqlCommand sqlcom6 = new SqlCommand("select tel from oa_department where name='" + dr4["department"].ToString() + "'", conn1);
                SqlDataReader dr6 = sqlcom6.ExecuteReader();
                if (dr6.HasRows)
                {
                    while (dr6.Read())
                    {
                        tel.Text = dr6["tel"].ToString();
                    }
                }
                dr6.Close();
            }
        }
        dr4.Close();
        SqlCommand sqlcom7 = new SqlCommand("select destine_time from OA_REPAIR_D where form_id='" + s + "'", conn);
        SqlDataReader dr7 = sqlcom7.ExecuteReader();
        if (dr7.HasRows)
        {
            while (dr7.Read())
            {
                if (!dr7["destine_time"].ToString().Equals(""))
                {
                    destine_time.Text = dr7["destine_time"].ToString();
                }
            }
        }
        dr7.Close();
        SqlCommand sqlcom9 = new SqlCommand("select complete_time from OA_REPAIR_D where form_id='" + s + "'", conn);
        SqlDataReader dr9 = sqlcom9.ExecuteReader();
        if (dr9.HasRows)
        {
            while (dr9.Read())
            {
                if (!dr9["complete_time"].ToString().Equals(""))
                {
                    ImageButton4.Enabled = false;
                    complete_time.Text = dr9["complete_time"].ToString();
                    complete_time.Enabled = false;
                }
                else
                {
                    ImageButton4.Enabled = true;
                    complete_time.Enabled = true;
                }
            }
        }
        dr9.Close();
        SqlCommand sqlcom10 = new SqlCommand("select [confirm] from OA_REPAIR_D where form_id='" + s + "'", conn);
        SqlDataReader dr10 = sqlcom10.ExecuteReader();
        if (dr10.HasRows)
        {
            while (dr10.Read())
            {
                if (!dr10["confirm"].ToString().Equals(""))
                {
                    confirm.Text = dr10["confirm"].ToString();
                }
                else
                {
                    SqlConnection conn1 = dbConnection.getConnection();
                    conn1.Open();
                    SqlCommand sqlcom12 = new SqlCommand("select emp_name from oa_employee where id='" + Session["user_id"].ToString().Trim() + "'", conn1);
                    SqlDataReader dr12 = sqlcom12.ExecuteReader();
                    if (dr12.HasRows)
                    {
                        while (dr12.Read())
                        {
                            confirm.Text = dr12["emp_name"].ToString().Trim();
                        }
                    }
                    dr12.Close();
                    conn1.Close();
                }
            }
        }
        dr10.Close();
        SqlCommand sqlcom11 = new SqlCommand("select remark from OA_REPAIR_D where form_id='" + s + "'", conn);
        SqlDataReader dr11 = sqlcom11.ExecuteReader();
        if (dr11.HasRows)
        {
            while (dr11.Read())
            {
                if (!dr11["remark"].ToString().Equals(""))
                {
                    remark.Text = dr11["remark"].ToString();
                    remark.Enabled = false;
                }
                else
                {
                    remark.Enabled = true;
                }
            }
        }
        dr11.Close();
        SqlCommand sqlcom8 = new SqlCommand("select company from OA_repair_d where form_id='" + s + "'", conn);
        str = sqlcom8.ExecuteScalar().ToString();
        Label1.Text=str;
        conn.Close();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection conn = dbConnection.getConnection();
        conn.Open();
        if (!complete_time.Text.ToString().Equals(""))
        {
            string sqlstr = "update oa_repair_d set complete_time='" + complete_time.Text.ToString() + "'";
            if (!confirm.Text.ToString().Equals(""))
            {
                sqlstr = sqlstr + ",[confirm]='" + confirm.Text.ToString() + "'";
            }
            if (!remark.Text.ToString().Equals(""))
            {
                sqlstr = sqlstr + ",remark='" + remark.Text.ToString() + "'";
            }
            sqlstr = sqlstr + "where form_id='" + form_id.Text.ToString() + "'";
            SqlCommand sqlcom = new SqlCommand(sqlstr, conn);
            sqlcom.ExecuteNonQuery();
            ShowMessageBox("操作成功");
        }
        else
        {
            ShowMessageBox("请选择完工日期");
        }
        conn.Close();
    }
    protected void ImageButton4_Click(object sender, ImageClickEventArgs e)
    {
        if (Calendar2.Visible == true)
        {
            Calendar2.Visible = false;
            Calendar2.Focus();
        }
        else
        {
            Calendar2.Visible = true;
            Calendar2.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;
        }
        complete_time.Text = year + month + day;
        complete_time.Focus();
    }
    protected void ShowMessageBox(string strMessage)
    {
        Response.Write(string.Format("<script>alert('{0}')</script>", strMessage));
    }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        form_id.Text = "";
        department.Text = "";
        lbperson.Text = "";
        create_time.Text = "";
        type.Text = "";
        equipment.Text = "";
        tel.Text = "";
        confirm.Text = "";
        destine_time.Text = "";
        complete_time.Text = "";
        remark.Text = "";
        ArrayList array = new ArrayList();
        array = (ArrayList)Session["s_1"];
        int id = Convert.ToInt32(DropDownList1.SelectedItem.ToString());
        id = id - 1;
        bind(array[id].ToString());
    }
}

						