部门领用查询.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 部门领用查询 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //设置数据库连接串
        String myConnStr =
            "data source=.;database=物资管理系统;Trusted_Connection=SSPI";
        SqlConnection myConn = new SqlConnection(myConnStr);

        String sql = "select distinct 领用时间 from 部门领用信息表";
        SqlCommand myComm = new SqlCommand(sql, myConn);
        myConn.Open();
        SqlDataReader myReader = myComm.ExecuteReader();
        if (!IsPostBack)
        {
            this.DropDownList3.Items.Add("");
            while (myReader.Read())
            {
                this.DropDownList3.Items.Add(myReader.GetValue(0).ToString());
            }
        }
        myReader.Close();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        //设置数据库连接串
        String myConnStr =
            "data source=.;database=物资管理系统;Trusted_Connection=SSPI";

        //设置要执行的SQL命令
        SqlConnection myConn = new SqlConnection(myConnStr);
        String sql
              = "select * from 部门领用信息表 where 物资编号 like'%"
              + this.TextBox1.Text + "%'";
        SqlCommand myComm = new SqlCommand(sql, myConn);
        myConn.Open();
        SqlDataReader myReader;
        myReader = myComm.ExecuteReader();

        //设置返回查询结果的表变量
        DataTable dt = new DataTable();
        dt.Columns.Add(new DataColumn(" 领用表编号", typeof(String)));
        dt.Columns.Add(new DataColumn("物资编号", typeof(String)));
        dt.Columns.Add(new DataColumn("领用数量", typeof(String)));
        dt.Columns.Add(new DataColumn("领用人", typeof(String)));
        dt.Columns.Add(new DataColumn("管理员", typeof(String)));
        dt.Columns.Add(new DataColumn("部门编号", typeof(String)));
        dt.Columns.Add(new DataColumn("部门名称", typeof(String)));
        dt.Columns.Add(new DataColumn("领用时间", typeof(String)));

        if (myReader.Read())
        {   //读查询的结果并放入表中
            DataRow dr = dt.NewRow();
            dr[0] = myReader.GetValue(0).ToString();
            dr[1] = myReader.GetValue(1).ToString();
            dr[2] = myReader.GetValue(2).ToString();
            dr[3] = myReader.GetValue(3).ToString();
            dr[4] = myReader.GetValue(4).ToString();
            dr[5] = myReader.GetValue(5).ToString();
            dr[6] = myReader.GetValue(6).ToString();
            dr[7] = myReader.GetValue(7).ToString();
            dt.Rows.Add(dr);
        }
        //输入不存在的物资编号时的提示操作
        else
        {
            this.Response.Write("<script language = javascript>alert('此物资不存在！')</script>");
        }

        //关闭数据库连接
        myConn.Close();

       

        //将查询结果显示到表格控件
        this.GridView1.DataSource = new DataView(dt);
        this.GridView1.DataBind();
    }
    protected void LinkButton6_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("采购单查询.aspx");
    }
    protected void LinkButton7_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("入库查询查询.aspx");
    }
    protected void LinkButton8_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("成品出售查询.aspx");
    }
    protected void LinkButton9_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("库存信息查询.aspx");
    }
    protected void Button3caigoutime_Click(object sender, EventArgs e)
    {
        //设置数据库连接串
        String myConnStr =
            "data source=.;database=物资管理系统;Trusted_Connection=SSPI";

        //设置要执行的SQL命令
        SqlConnection myConn = new SqlConnection(myConnStr);
        //    String sql = "select 物资名称 from 库存信息表";
        DateTime time = Convert.ToDateTime(this.DropDownList3.Text);
        String sql
               = "select 物资编号,领用数量,领用时间 from 部门领用信息表  where 领用时间 ='" + time + "'";
        SqlCommand myComm = new SqlCommand(sql, myConn);
        myConn.Open();
        SqlDataReader myReader;
        myReader = myComm.ExecuteReader();

        //设置返回查询结果的表变量
        DataTable dt = new DataTable();
        dt.Columns.Add(new DataColumn("物资编号", typeof(String)));
        dt.Columns.Add(new DataColumn("领用数量", typeof(String)));
        dt.Columns.Add(new DataColumn("领用时间", typeof(String)));

        //读查询的结果并放入表中
        while (myReader.Read())
        {
            DataRow dr = dt.NewRow();
            dr[0] = myReader.GetValue(0).ToString();
            dr[1] = myReader.GetValue(1).ToString();
            dr[2] = myReader.GetValue(2).ToString();
            dt.Rows.Add(dr);
        }


        //关闭数据库连接
        myConn.Close();

        //将查询结果显示到表格控件
        this.GridView2.DataSource = new DataView(dt);
        this.GridView2.DataBind();
    }
    protected void LinkButton10_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("物资信息查询.aspx");
    }
    protected void LinkButton2_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("登录.aspx");
    }
    protected void LinkButton4_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("物资信息查询.aspx");
    }
    protected void LinkButton5_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("1首页.aspx");
    }
}