采购单查询.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.DropDownList1.Items.Add("");
            while (myReader.Read())
            {
                this.DropDownList1.Items.Add(myReader.GetValue(0).ToString());
                this.DropDownList2.Items.Add(myReader.GetValue(0).ToString());
            }
        }
        myReader.Close();


       sql = "select distinct 采购时间 from 物资采购信息表";
        myComm = new SqlCommand(sql, myConn);
        myReader = myComm.ExecuteReader();
        if (!IsPostBack)
        {
            while (myReader.Read())
            {
                this.DropDownList3.Items.Add(myReader.GetValue(0).ToString());
            }
        }
        myConn.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 库存信息表";
        String sql
              = "select * from 物资采购信息表 where 物资名称 like'%"
              + this.DropDownList1.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)));

        //读查询的结果并放入表中
        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();
            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);
        }
        

        //关闭数据库连接
        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 Button2_Click(object sender, EventArgs e)
    {
        //设置数据库连接串
        String myConnStr =
            "data source=.;database=物资管理系统;Trusted_Connection=SSPI";

        //设置要执行的SQL命令
        SqlConnection myConn = new SqlConnection(myConnStr);
        //    String sql = "select 物资名称 from 库存信息表";
       String sql
              = "select sum(物资数量) from 物资采购信息表  where 物资名称 like'%"
              + this.DropDownList2.Text+ "%'";
        SqlCommand myComm = new SqlCommand(sql, myConn);
        myConn.Open();
        SqlDataReader myReader;
        myReader = myComm.ExecuteReader();

        if (myReader.Read())
        {
            this.TextBox1zongliang.Text = Convert.ToString( myReader[0]);
        }
        //关闭数据库连接
        myConn.Close();
    }
    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");
    }
}