2物资信息盘点.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 _1物资信息盘点 : System.Web.UI.Page
{
    
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        string myConnStr = "data source=.;database=物资管理系统;trusted_connection=SSPI";
        SqlConnection myConn = new SqlConnection(myConnStr);
        
        if (this.TextBox2.Text != "" )
        {
            string sql = "select 物资编号,物资名称,物资数量,生产地点,仓库名称,单价,备注 from 物资信息表 where 物资编号 ='" + this.TextBox2.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())
            {
                    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);
     
                this.GridView1.DataSource = new DataView(dt);
                this.GridView1.DataBind();

               // this.TextBox3.Text = Convert.ToString(dr[1]);
               // num=this.TextBox4.Text= Convert.ToString(dr[2]);
                Response.Write("<script>alert('请核对无误后，进行保存！如未保存，数据无法录入数据库！')</script>");

            }
            else
            {
                Response.Write("<script>alert('您的输入有误，无此项记录!')</script>");
            }
            myConn.Close();
        }
        else
        {
            Response.Write("<script>alert('请输“物资编号”!');</script>");
        }
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("库存信息管理.aspx");
    }
    protected void LinkButton3_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("5职工信息管理.aspx");
    }
    protected void LinkButton4_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("3物资信息管理.aspx");
    }
    protected void LinkButton2_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("4部门信息管理.aspx");
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        string wuziname="";
        string swuzinum="";
        string myConnStr = "data source=.;database=物资管理系统;trusted_connection=SSPI";
        SqlConnection myConn = new SqlConnection(myConnStr);
        SqlCommand myComm;
        if (this.TextBox2.Text != "")
        {

            string msql = "select 物资编号,物资名称,物资数量 from 物资信息表 where 物资编号 ='" + this.TextBox2.Text + "'";
            myComm = new SqlCommand(msql, 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));

            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();

                dt.Rows.Add(dr);

                wuziname = Convert.ToString(dr[1]);
                swuzinum = Convert.ToString(dr[2]);



            }
            else
            {
                Response.Write("<script>alert('输入有误，不存在此物资!');</script>");
            }
            myReader.Close();
            if (this.TextBox3.Text == wuziname && this.TextBox4.Text == swuzinum)
            {
                string day = Convert.ToString(this.TextBox6.Text);
                string sql = "insert into 物资盘点表(物资编号,物资名称,帐上数量,实际数量,盘点时间,备注)values('" + this.TextBox2.Text + "','" +
              this.TextBox3.Text + "','" + this.TextBox4.Text + "','" + this.TextBox5.Text + "','" + day + "','" + this.TextBox1.Text + "')";
                sql += "update 物资信息表 set 物资数量='" + this.TextBox5.Text + "'";
                myComm = new SqlCommand(sql, myConn);
              //  myConn.Open();
                myComm.ExecuteNonQuery();
                myConn.Close();
                //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.TextBox5.Text="";
                this.TextBox6.Text="";
                this.TextBox1.Text = "";
            }
            else
            {
                this.Response.Write("<script language=javascript>alert('输入物资名称或帐上数量与物资编号不符。注意：在“录入”后必须“保存”！')</script>");
            }
        }
        else
        {
            this.Response.Write("<script language=javascript>alert('输入物资编号！提醒：不要输入，物资编号和帐上数量。在“录入”后“保存”！')</script>");
        }

    }
    
   
    

  
    protected void LinkButton5_Click(object sender, EventArgs e)
    {
       this.Response.Redirect("1首页.aspx");
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string myConnStr = "data source=.;database=物资管理系统;trusted_connection=SSPI";
        SqlConnection myConn = new SqlConnection(myConnStr);

        if (this.TextBox2.Text != "")
        {
            string sql = "select 物资编号,物资名称,帐上数量,实际数量,盘点时间,备注 from 物资盘点表 where 物资编号 ='" + this.TextBox2.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));
            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();
                
                dt.Rows.Add(dr);

                this.GridView1.DataSource = new DataView(dt);
                this.GridView1.DataBind();

                // this.TextBox3.Text = Convert.ToString(dr[1]);
                // num=this.TextBox4.Text= Convert.ToString(dr[2]);
                Response.Write("<script>alert('请核对！！')</script>");

            }
            else
            {
                Response.Write("<script>alert('您的输入有误，无此项记录!')</script>");
            }
            myConn.Close();
        }
        else
        {
            Response.Write("<script>alert('请输“物资编号”!');</script>");
        }
    }
}