采购登记界面.aspx.cs

本系统时物资管理系统

using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

        //设置数据库连接串
        string myConnStr 
               = "data source= . ;  database=物资管理系统;Trusted_Connection=SSPI ";

        //设置要执行的SQL命令
        //提取当前增加的进货单的编号并设置到控件
        SqlConnection myConn = new SqlConnection(myConnStr);
        string sql = "select max(采购单编号) from 物资采购信息表";
        SqlCommand myComm = new SqlCommand(sql,myConn);
        myConn.Open();
        int maxNum = Convert.ToInt32(myComm.ExecuteScalar()) + 1;
        this.TextBoxcaigoudanbianhao.Text = maxNum.ToString();

        //设置要执行的SQL命令
        //提取当前采购的原料物资名称并设置到控件
        sql = "select 姓名 from 职工信息表  where 部门名称='材料科'";
        myComm = new SqlCommand(sql, myConn);
        SqlDataReader myReader = myComm.ExecuteReader();
        
        if (!IsPostBack)
        {
            this.DropDownListjingshouren.Items.Add("");
            while (myReader.Read())
                this.DropDownListjingshouren.Items.Add(myReader.GetValue(0).ToString());
        }
        myReader.Close();

        //设置要执行的SQL命令
        //提取当前供应商并设置到控件
        sql = "select 供货商 from 供货商表  ";
        myComm = new SqlCommand(sql, myConn);
        myReader = myComm.ExecuteReader();
        
        if (!IsPostBack)
        {
            this.DropDownListgongyingsang.Items.Add("");
            while (myReader.Read())
                this.DropDownListgongyingsang.Items.Add(myReader.GetValue(0).ToString());
        }
        myReader.Close();
        myConn.Close();
    }


    protected void Buttonfanhui_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("物资入库界面.aspx");
    }
    protected void Buttonbaocun_Click(object sender, EventArgs e)
    {
        if(this.TextBoxwuzibianhao.Text == ""||this.TextBoxwuzimingcheng.Text ==""||this.TextBoxwuzishuliang.Text== ""||this.TextBoxwuzidanjia.Text == ""||this.TextBoxcaigoushijian.Text == "")
            this.Response.Write("<script language=javascript>alert('请确保采购物品信息齐全！ ')</script>");

        else if (this.TextBoxwuzibianhao.Text != "" && this.TextBoxwuzimingcheng.Text != "" && this.TextBoxwuzishuliang.Text != "" && this.TextBoxwuzidanjia.Text != ""&& this.TextBoxcaigoushijian.Text != "")
        {
        //设置数据库连接串
        string myConnStr = "data source= . ;  database=物资管理系统;Trusted_Connection=SSPI ";

        //设置要执行的SQL命令
        //修改物资采购信息表并同时修改物资信息表中物资数量
        SqlConnection myConn = new SqlConnection(myConnStr);
        string sql
            = "insert  物资采购信息表(采购单编号,物资编号,物资名称,物资数量,物资单价,经手人,采购时间,供货商) values('"
            +  this.TextBoxcaigoudanbianhao.Text +"','" +
            this.TextBoxwuzibianhao.Text + "','" +
            this.TextBoxwuzimingcheng.Text + "','" + 
            this.TextBoxwuzishuliang.Text + "','" +
            this.TextBoxwuzidanjia.Text + "','" +
            this.DropDownListjingshouren.Text + "','" +
            this.TextBoxcaigoushijian.Text + "','" +
            this.DropDownListgongyingsang.Text  + "');";

        SqlCommand myComm = new SqlCommand(sql, myConn);
        myConn.Open();
        myComm.ExecuteNonQuery();
        myConn.Close();


        //提示用户操作成功
        this.Response.Write("<script language=javascript>alert('采购登记输入成功！')</script>");
            this.TextBoxwuzibianhao.Text = "";
            this.TextBoxwuzimingcheng.Text ="";
            this.TextBoxwuzishuliang.Text= "";
            this.TextBoxwuzidanjia.Text = "";
            this.TextBoxcaigoushijian.Text = "";

            myConn = new SqlConnection(myConnStr);
             sql = "select max(采购单编号) from 物资采购信息表";
             myComm = new SqlCommand(sql, myConn);
            myConn.Open();
            int maxNum=Convert.ToInt32(myComm.ExecuteScalar()) +1;
            this.TextBoxcaigoudanbianhao.Text = maxNum.ToString();

        }
    }
}