3物资信息管理.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 物资编号 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());
                }
             }
                myReader.Close();
            
            if (!IsPostBack)
            {
                this.DropDownList3.Items.Add("");
                this.DropDownList3.Items.Add("原料仓库");
                this.DropDownList3.Items.Add("成品仓库");
            }
            if (!IsPostBack)
            {
                this.DropDownList4.Items.Add("");
                this.DropDownList4.Items.Add("原料");
                this.DropDownList4.Items.Add("成品");
            }
            
                sql = "select 物资名称 from 物资信息表";
                myComm = new SqlCommand(sql, myConn);
                myReader = myComm.ExecuteReader();
          if (!IsPostBack)
          {
              this.DropDownList7.Items.Add("");
                while (myReader.Read())
                {
                    this.DropDownList7.Items.Add(myReader.GetValue(0).ToString());
                }
                myReader.Close();
            }
            myConn.Close();

  }
    
    protected void Button2_Click(object sender, EventArgs e)
    {
        string myConnStr = "data source=.;database=物资管理系统;trusted_connection=SSPI";
        SqlConnection myConn = new SqlConnection(myConnStr);
        string sql;
        
        if (this.DropDownList1.Text != "" || this.DropDownList7.Text != "")
        {
            myConn.Open();
            string wuzibianhao="wucijilu";
            if (this.DropDownList1.Text != "")
            {
               sql = "select 物资编号 from 物资信息表 where 物资编号='" + this.DropDownList1.Text + "'";
                SqlCommand myCom = new SqlCommand(sql, myConn);  
                SqlDataReader myReader1 = myCom.ExecuteReader();
                DataTable d = new DataTable();
                d.Columns.Add("物资编号", typeof(string));
                if (myReader1.Read())
                {
                    DataRow dr = d.NewRow();
                    dr[0] = myReader1.GetValue(0).ToString();
                    wuzibianhao = Convert.ToString(dr[0]);

                }

                myReader1.Close();
                if (this.DropDownList1.Text!=wuzibianhao) 
                    this.Response.Write("<script language=javascript>alert('数据库中无此项记录！')</script>");
                //myConn.Close;

                sql = "select 物资编号,物资名称,物资数量,生产地点,仓库名称,单价,备注 from 物资信息表 where 物资编号 ='" + this.DropDownList1.Text + "'";
            }
            else
                sql = "select 物资编号,物资名称,物资数量,生产地点,仓库名称,单价,备注 from 物资信息表 where 物资名称 ='" + this.DropDownList7.Text + "'";
            SqlCommand myComm = new SqlCommand(sql, myConn);
           // myConn.Open();
            SqlDataReader myReader = myComm.ExecuteReader();
            DataTable dt = new DataTable();
            dt.Columns.Add("物资编号", typeof(string));
            dt.Columns.Add("物资名称", typeof(string));
            dt.Columns.Add("物资数量", typeof(string));
            dt.Columns.Add("生产地点", typeof(string));
            dt.Columns.Add("仓库名称", typeof(string));
            dt.Columns.Add("单价", typeof(string));
            dt.Columns.Add("备注", typeof(string));
            //if (!myReader.Read())
            //this.Response.Write("<script language=javascript>alert('无此记录！')</script>");
            // bool sign=myReader.Read()
                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();
                    dt.Rows.Add(dr);
                }
            myReader.Close();
            this.GridView1.DataSource = new DataView(dt);
            this.GridView1.DataBind();


            myConn.Close();
            
        }
        else
        {
            Response.Write("<script>alert('请输入搜索项!');</script>");
        }
       
        //if (!sign) 
            //this.Response.Write("<script language=javascript>alert('无此记录！')</script>");
        
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        string wuzibianhao="wucichanpin ";
        
        string myConnStr = "data source=.;database=物资管理系统;trusted_connection=SSPI";
        SqlConnection myConn = new SqlConnection(myConnStr);
        if (this.TextBox2.Text != "")
        {
            string msql = "select 物资编号 from 物资信息表 where 物资编号='" + this.TextBox2.Text+"'";
            SqlCommand myCom = new SqlCommand(msql, myConn);
            myConn.Open();
            SqlDataReader myReader = myCom.ExecuteReader();
            DataTable dt = new DataTable();
            dt.Columns.Add("物资编号", typeof(string));
            if (myReader.Read())
            {
                    DataRow dr = dt.NewRow();
                    dr[0] = myReader.GetValue(0).ToString();
                    wuzibianhao = Convert.ToString(dr[0]);
                    
            }
            
            myReader.Close();
            if (this.TextBox2.Text!=wuzibianhao)
            {
                if (this.TextBox3.Text != "" && this.TextBox4.Text != "" && this.TextBox7.Text != "" && this.TextBox7.Text != "" && this.DropDownList3.Text != "" && this.TextBox5.Text != "" && this.DropDownList4.Text != "")
                {
                    string
                   sql =
                   "insert into 物资信息表(物资编号,物资名称,物资数量,生产地点,仓库名称,单价,备注)values('" + this.TextBox2.Text + "','" +
                   this.TextBox3.Text + "','" + this.TextBox4.Text + "','" + this.TextBox7.Text + "','" +
                     this.DropDownList3.Text + "','" + this.TextBox5.Text + "','" + this.DropDownList4.Text + "')";
                    SqlCommand myComm = new SqlCommand(sql, myConn);
                    // myConn.Open();
                    myComm.ExecuteNonQuery();
                    myConn.Close();
                    this.DropDownList1.Items.Add(this.TextBox2.Text);
                    this.DropDownList7.Items.Add(this.TextBox3.Text);
                    //this.Response.Write("<scrip language=javascrip>alter('添加成功！')</script>");
                    this.Response.Write("<script language=javascript>alert('添加成功！')</script>");

                    this.TextBox2.Text = "";
                    this.TextBox3.Text = ""; 
                    this.TextBox4.Text = "";
                    this.TextBox7.Text = ""; 
                    this.DropDownList3.Text = ""; 
                    this.TextBox5.Text = "";
                    this.DropDownList4.Text = "";
                }
                else
                {
                    this.Response.Write("<script language=javascript>alert('输入信息不完整！')</script>");
                }
            }
            else
                this.Response.Write("<script language=javascript>alert('该物资编号已存在！')</script>");
        }

        else
        {
            this.Response.Write("<script language=javascript>alert('输入信息不完整！')</script>");
        }

    }
    
    protected void Button4_Click(object sender, EventArgs e)
    {
        string myConnStr = "data source=.;database=物资管理系统;trusted_connection=SSPI";
           SqlConnection myConn = new SqlConnection(myConnStr);
           if (this.DropDownList1.Text != "" || this.DropDownList7.Text != "")
           {
               string sql;
               if (this.DropDownList1.Text != "")
                   sql = "delete from 物资信息表 where 物资编号='" + this.DropDownList1.Text + "'";
               else
                   sql = "delete from 物资信息表 where 物资名称 ='" + this.DropDownList7.Text + "'";
               SqlCommand myComm = new SqlCommand(sql, myConn);
               myConn.Open();
               myComm.ExecuteNonQuery();
               myConn.Close();
               //this.Response.Write("<script language=javascrip>alter('！')</script>");
               Response.Write("<script>alert('删除成功！')</script>");
               
           }
           else 
           {
               Response.Write("<script>alert('请输入搜索项！')</script>");
           }
    }

    protected void LinkButton2_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("4部门信息管理.aspx");
    }
    protected void LinkButton3_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("5职工信息管理.aspx");
    }
    
   
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("库存信息管理.aspx");
    }
    protected void Button5_Click(object sender, EventArgs e)
    {
        string myConnStr = "data source=.;database=物资管理系统;trusted_connection=SSPI";

        SqlConnection myConn = new SqlConnection(myConnStr);
        if (this.TextBox4.Text != "")
        {
            string sql;
            sql = "update 物资信息表 set 物资编号='" + this.TextBox2.Text + "'";
            if (this.DropDownList1.Text != "")
            {
                if (this.TextBox2.Text != "")
                {
                    sql = sql + ",物资数量='" + this.TextBox4.Text + "'";

                }

                if (this.TextBox3.Text != "")
                    sql = sql + ", 物资名称='" + this.TextBox3.Text + "'";
                if (this.TextBox7.Text != "")
                    sql = sql + " , 生产地点='" + this.TextBox7.Text + "'";
                if (this.DropDownList3.Text != "")
                    sql = sql + ", 仓库名称='" + this.DropDownList3.Text + "'";
                if (this.TextBox5.Text != "")
                    sql = sql + " , 单价='" + this.TextBox5.Text + "'";
                if (this.DropDownList4.Text != "")
                    sql = sql + " , 备注='" + this.DropDownList4.Text + "'";
                sql += "where 物资编号='" + this.DropDownList1.Text + "'";
            }
            else
            {
                if (this.TextBox2.Text != "")
                    sql = sql + ", 物资编号='" + this.TextBox2.Text + "'";
                if (this.TextBox3.Text != "")
                    sql = sql + ", 物资名称='" + this.TextBox3.Text + "'";
                if (this.TextBox7.Text != "")
                    sql = sql + " , 生产地点='" + this.TextBox7.Text + "'";
                if (this.DropDownList3.Text != "")
                    sql = sql + ", 仓库名称='" + this.DropDownList3.Text + "'";
                if (this.TextBox5.Text != "")
                    sql = sql + " , 单价='" + this.TextBox5.Text + "'";
                if (this.DropDownList4.Text != "")
                    sql = sql + " , 备注='" + this.DropDownList4.Text + "'";
                sql = sql + "'where 物资名称='" + this.DropDownList7.Text + "'";
            }
            SqlCommand myComm = new SqlCommand(sql, myConn);
            myConn.Open();
            myComm.ExecuteNonQuery();
            myConn.Close();
            this.Response.Write("<script language=javascript>alert('修改成功！')</script>");
            this.TextBox2.Text = "";
            this.TextBox3.Text = "";
            this.TextBox4.Text = "";
            this.TextBox7.Text = "";
            this.DropDownList3.Text = "";
            this.TextBox5.Text = "";
            this.DropDownList4.Text = "";
        }
        else
        {
            Response.Write("<script>alert('修改时，必须输入物资编号！如不清楚，可在搜索中填入物资名称，点击核对，进行查询。')</script>");
        }
    }


    protected void LinkButton4_Click(object sender, EventArgs e)
    {
     this.Response.Redirect("2物资信息盘点.aspx"); 
    }

    protected void LinkButton5_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("1首页.aspx"); 
    }
}