OA系统

开发平台：
ASP/ASPX

form_list.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_form_list : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection conn = dbConnection.getConnection();
        conn.Open();
        if (!IsPostBack)
        {
            dl_company.Items.Clear();
            dl_company.Items.Add("所有厂商");
            SqlCommand sqlcom1 = new SqlCommand("select company from OA_COMPANY order by id", conn);
            SqlDataReader dr1 = sqlcom1.ExecuteReader();
            if (dr1.HasRows)
            {
                while (dr1.Read())
                {
                    dl_company.Items.Add(dr1["company"].ToString());
                }
            }
            dr1.Close();
            dl_department.Items.Clear();
            dl_department.Items.Add("所有门店");
            SqlCommand sqlcom2 = new SqlCommand("select name FROM OA_DEPARTMENT WHERE (CHARINDEX('店', name) > 0)", conn);
            SqlDataReader dr2 = sqlcom2.ExecuteReader();
            if (dr2.HasRows)
            {
                while (dr2.Read())
                {
                    dl_department.Items.Add(dr2["name"].ToString());
                }
            }
            dr2.Close();
            dl_type.Items.Clear();
            dl_type.Items.Add("所有类型");
            SqlCommand sqlcom3 = new SqlCommand("select type from OA_UNIT_TYPE order by id", conn);
            SqlDataReader dr3 = sqlcom3.ExecuteReader();
            if (dr3.HasRows)
            {
                while (dr3.Read())
                {
                    dl_type.Items.Add(dr3["type"].ToString());
                }
            }
            dr3.Close();
            dl_name.Items.Clear();
            dl_name.Items.Add("所有设备");
            SqlCommand sqlcom = new SqlCommand("select eq_name from OA_UNIT_DETAIL order by id", conn);
            SqlDataReader dr = sqlcom.ExecuteReader();
            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    dl_name.Items.Add(dr["eq_name"].ToString());
                }
            }
            dr.Close();
        }
        conn.Close();
    }
    protected void ApprovelList1_RowCreated(object sender, GridViewRowEventArgs e)
    {
        LinkButton lbRevoke = (LinkButton)e.Row.FindControl("LbRevoke1");
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            lbRevoke.CommandArgument = GridView1.DataKeys[e.Row.RowIndex].Value.ToString();
            lbRevoke.Click += new EventHandler(lbRevoke1_Click);
        }
    }
    public void lbRevoke1_Click(object sender, EventArgs e)
    {
        SqlConnection conn = dbConnection.getConnection();
        conn.Open();
        SqlCommand sqlcom = new SqlCommand("");
    }
    protected void Begindate_SelectionChanged(object sender, EventArgs e)
    {
        Begindate.Visible = false;
        string year = Begindate.SelectedDate.Year.ToString();
        string month = Begindate.SelectedDate.Month.ToString();
        if (month.Length == 1)
        {
            month = "0" + month;
        }
        string day = Begindate.SelectedDate.Day.ToString();
        if (day.Length == 1)
        {
            day = "0" + day;
        }
        b_time.Text = year + month + day + "000000";
        b_time.Focus();
    }
    protected void Enddate_SelectionChanged(object sender, EventArgs e)
    {
        Enddate.Visible = false;
        string year = Enddate.SelectedDate.Year.ToString();
        string month = Enddate.SelectedDate.Month.ToString();
        if (month.Length == 1)
        {
            month = "0" + month;
        }
        string day = Enddate.SelectedDate.Day.ToString();
        if (day.Length == 1)
        {
            day = "0" + day;
        }
        e_time.Text = year + month + day + "000000";
        e_time.Focus();
    }
    protected void ImageButton2_Click(object sender, ImageClickEventArgs e)
    {
        if (Enddate.Visible == true)
        {
            Enddate.Visible = false;
            Enddate.Focus();
        }
        else
        {
            Enddate.Visible = true;
            Enddate.Focus();
        }
    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        if (Begindate.Visible == true)
        {
            Begindate.Visible = false;
            Begindate.Focus();
        }
        else
        {
            Begindate.Visible = true;
            Begindate.Focus();
        }
    }
    protected void dl_type_SelectedIndexChanged(object sender, EventArgs e)
    {
        SqlConnection conn = dbConnection.getConnection();
        conn.Open();
        if (dl_type.SelectedItem.ToString().Equals("所有类型"))
        {
            dl_name.Items.Clear();
            dl_name.Items.Add("所有设备");
            SqlCommand sqlcom1 = new SqlCommand("select eq_name from OA_UNIT_DETAIL order by id", conn);
            SqlDataReader dr1 = sqlcom1.ExecuteReader();
            if (dr1.HasRows)
            {
                while (dr1.Read())
                {
                    dl_name.Items.Add(dr1["eq_name"].ToString());
                }
            }
            dr1.Close();
        }
        else
        {
            dl_name.Items.Clear();
            dl_name.Items.Add("所有设备");
            SqlCommand sqlcom = new SqlCommand("select eq_name from OA_UNIT_DETAIL where eq_type='" + dl_type.SelectedItem.ToString() + "'", conn);
            SqlDataReader dr = sqlcom.ExecuteReader();
            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    dl_name.Items.Add(dr["eq_name"].ToString());
                }
            }
            dr.Close();
        }
        conn.Close();
    }
    protected void dl_company_SelectedIndexChanged(object sender, EventArgs e)
    {
        SqlConnection conn = dbConnection.getConnection();
        conn.Open();
        dl_type.Items.Clear();
        dl_type.Items.Add("所有类型");
        if (dl_company.SelectedItem.ToString().Equals("所有厂商"))
        {
            SqlCommand sqlcom3 = new SqlCommand("select type from OA_UNIT_TYPE order by id", conn);
            SqlDataReader dr3 = sqlcom3.ExecuteReader();
            if (dr3.HasRows)
            {
                while (dr3.Read())
                {
                    dl_type.Items.Add(dr3["type"].ToString());
                }
            }
            dr3.Close();
        }
        else
        {
            SqlCommand sqlcom = new SqlCommand("select equipment from OA_company where company='" + dl_company.SelectedItem.ToString() + "'", conn);
            SqlDataReader dr = sqlcom.ExecuteReader();
            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    dl_type.Items.Add(dr["equipment"].ToString());
                }
            }
            dr.Close();
        }
        conn.Close();
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        int i;
        //执行循环，保证每条数据都可以更新
        for (i = -1; i < GridView1.Rows.Count; i++)
        {
            //首先判断是否是数据行
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                //当鼠标停留时更改背景色
                e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#00A9FF'");
                //当鼠标移开时还原背景色
                e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c");
                e.Row.Attributes.Add("onclick", "javascript:varwin=window.open('select.aspx?form_id=" + GridView1.DataKeys[e.Row.RowIndex].Value.ToString() +"',null,'width=800,height=600')");
                //e.Row.Attributes.Add("onclick", "location.href='select.aspx?form_id=" + GridView1.DataKeys[e.Row.RowIndex].Value.ToString() + "'");
            }
        }
    }
    public void bind1()
    {
        ArrayList array = new ArrayList();
        MultiView2.ActiveViewIndex = 0;
        SqlConnection conn = dbConnection.getConnection();
        conn.Open();
        DataSet ds = new DataSet();
        DataTable dt = new DataTable();
        dt.Columns.Add("no", typeof(string));
        dt.Columns.Add("form_id", typeof(string));
        dt.Columns.Add("bxperson", typeof(string));
        dt.Columns.Add("level", typeof(string));
        dt.Columns.Add("department", typeof(string));
        dt.Columns.Add("tel", typeof(string));
        dt.Columns.Add("date", typeof(string));
        dt.Columns.Add("lbperson", typeof(string));
        dt.Columns.Add("type", typeof(string));
        dt.Columns.Add("equipment", typeof(string));
        dt.Columns.Add("comment", typeof(string));
        dt.Columns.Add("company", typeof(string));
        dt.Columns.Add("destine_time", typeof(string));
        dt.Columns.Add("complete_time", typeof(string));
        dt.Columns.Add("confirm", typeof(string));
        dt.Columns.Add("remark", typeof(string));
        string sqlstr = "select  f.area as area,f.level as level,f.bxperson as bxperson,f.form_id as form_id,f.department as department,f.lbperson as lbperson,f.type as type,f.equipment as equipment,f.comment as comment,f.create_time as create_time,g.company as company,g.destine_time as destine_time,g.complete_time as complete_time,g.confirm as confirm,g.remark as remark from oa_repair as f,oa_repair_d as g where g.form_id=f.form_id";
        if (!dl_department.SelectedItem.ToString().Equals("所有门店"))
        {
            sqlstr = sqlstr + " and f.department='" + dl_department.SelectedItem.ToString()+"'";
        }
        if (!dl_company.SelectedItem.ToString().Equals("所有厂商"))
        {
            sqlstr = sqlstr + " and g.company='" + dl_company.SelectedItem.ToString()+"'";
        }
        if (!dl_type.SelectedItem.ToString().Equals("所有类型"))
        {
            sqlstr = sqlstr + " and f.type='" + dl_type.SelectedItem.ToString()+"'";
        }
        if (!dl_name.SelectedItem.ToString().Equals("所有设备"))
        {
            sqlstr = sqlstr + " and f.equipment='" + dl_name.SelectedItem.ToString()+"'";
        }
        if ((!b_time.Text.Equals("")) && (!e_time.Text.Equals("")))
        {
            sqlstr = sqlstr + " and f.form_id between '" + b_time.Text.ToString().Trim() + "' and '" + e_time.Text.ToString() + "'";
        }
        sqlstr = sqlstr + " order by form_id desc";
        SqlCommand sqlcom = new SqlCommand(sqlstr, conn);
        SqlDataReader dr = sqlcom.ExecuteReader();
        if (dr.HasRows)
        {
            while (dr.Read())
            {
                DataRow row = dt.NewRow();
                row["no"] = dr["area"].ToString().Trim();
                row["bxperson"] = dr["bxperson"].ToString().Trim();
                row["level"] = dr["level"].ToString().Trim();
                row["form_id"] = dr["form_id"].ToString();
                array.Add(dr["form_id"].ToString());
                row["department"] = dr["department"].ToString();
                SqlConnection conn1 = dbConnection.getConnection();
                conn1.Open();
                SqlCommand sqlcom2 = new SqlCommand("select tel from oa_department where name='" + dr["department"] + "'", conn1);
                SqlDataReader dr2 = sqlcom2.ExecuteReader();
                if (dr2.HasRows)
                {
                    while (dr2.Read())
                    {
                        row["tel"] = dr2["tel"].ToString();
                    }
                }
                dr2.Close();
                row["date"] = dr["create_time"].ToString();
                SqlCommand sqlcom1 = new SqlCommand("select emp_name from oa_employee where id='" + dr["lbperson"].ToString().Trim() + "'", conn1);
                SqlDataReader dr1 = sqlcom1.ExecuteReader();
                if (dr1.HasRows)
                {
                    while (dr1.Read())
                    {
                        row["lbperson"] = dr1["emp_name"].ToString();
                    }
            }
                dr1.Close();
                row["type"] = dr["type"].ToString();
                row["equipment"] = dr["equipment"].ToString();
                row["comment"] = dr["comment"].ToString();
                row["company"] = dr["company"].ToString();
                row["destine_time"] = dr["destine_time"].ToString();
                row["complete_time"] = dr["complete_time"].ToString();
                row["confirm"] = dr["confirm"].ToString();
                row["remark"] = dr["remark"].ToString();
                dt.Rows.Add(row);
                conn1.Close();
            }
        }
        dr.Close();
        conn.Close();
        ds.Tables.Add(dt);
        GridView1.DataSource = ds;
        GridView1.DataKeyNames = new string[] { "form_id" };
        GridView1.DataBind();
        Session["s"] = array;
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        bind1();
    }
}

						