edithuo.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 Edithuo : System.Web.UI.Page
{
    private readonly string SqlConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString();
    private string BID;
    private int strID
    {
        get
        {
            return Convert.ToInt32(ViewState["_BID"]);
        }
        set
        {
            ViewState["_BID"] = Request.QueryString["BID"];
        }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BID = Request["BID"].ToString();
            BindData(BID);
        }
    }
    private void BindData(string BID)
    {
        string sqlstr;
        sqlstr = "select * from huopin where huoID='" + BID + "'";
        SqlConnection scon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
        SqlCommand scm = new SqlCommand(sqlstr, scon);
        //打开数据库并执行查询操作 
        scon.Open();
        SqlDataReader dr = scm.ExecuteReader();
        if (dr.Read())
        {   //rukuDate,rukuBianma,huoName,shuliang,jinjia,zhonge,beizhu,ghdw,jingbanren
            this.TextBox1.Text = dr["huoName"].ToString();
            this.TextBox2.Text = dr["bianma"].ToString();
            this.TextBox3.Text = dr["huoDanwei"].ToString();
            this.DropDownList1.Text = dr["cfck"].ToString();
            //this.DropDownList2.Text = dr["jingbanren"].ToString();
            this.TextBox5.Text = dr["rkdw"].ToString();
            this.TextBox6.Text = dr["ckdw"].ToString();
            this.TextBox7.Text = dr["yskc"].ToString();
            this.TextBox8.Text = dr["dixian"].ToString();
            this.TextBox9.Text = dr["gaoxian"].ToString();
          
        }
        //关闭数据库的连接
        dr.Close();
        scon.Close();
    }
    private bool kong()
    {
        if (this.TextBox1.Text == "")
        {
            Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
            return false;
        }
        else
        {
            if (this.TextBox2.Text == "")
            {
                Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
                return false;
            }
            else
            {
                if (this.TextBox3.Text == "")
                {
                    Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
                    return false;
                }
                
                    else
                    {
                        if (this.TextBox5.Text == "")
                        {
                            Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
                            return false;
                        }
                        else
                        {
                            if (this.TextBox6.Text == "")
                            {
                                Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
                                return false;
                            }
                            else
                            {
                                if (this.TextBox7.Text == "")
                                {
                                    Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
                                    return false;
                                }
                                else
                                {
                                    if (this.TextBox8.Text == "")
                                    {
                                        Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
                                        return false;
                                    }
                                    else
                                    {
                                        if (this.TextBox9.Text == "")
                                        {
                                            Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
                                            return false;
                                        }
                                        else
                                        {
                                            return true;
                                        }
                                    }
                                }
                            }
                      
                    }
                }
            }
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (kong())
        {
            //定义变量
            string bbb = Request.QueryString["BID"];
            string aa, bb, cc, dd, ee, ff, gg, hh, ii;
            aa = this.TextBox1.Text;
            bb = this.TextBox2.Text;
            cc = this.TextBox3.Text;
            dd = this.DropDownList1.Text;
            ee = this.TextBox5.Text;
            ff = this.TextBox6.Text;
            gg = this.TextBox7.Text;
            hh = this.TextBox8.Text;
            ii = this.TextBox9.Text;
            SqlConnection scon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
            scon.Open();
        
            //SqlCommand scmd = new SqlCommand("insert into Notice(Title,Content,Note,entertime) values ('" + name + "','" + word + "','" + bz + "','" + intime + "')", scon);
            SqlCommand scmd = new SqlCommand("update huopin set huoName='" + aa + "',bianma='" + bb + "',huoDanwei='" + cc + "',cfck='" + dd + "',rkdw='" + ee + "',ckdw='" + ff + "',yskc='" + gg + "',dixian='" + hh + "',gaoxian='" + ii + "' where huoID='" + bbb + "'", scon);
            scmd.ExecuteNonQuery();
            scmd.Dispose();
            scon.Close();
            Response.Write("<script language='javascript'>alert('更新成功！');</script>");
            Server.Transfer("Managehuo.aspx");
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Server.Transfer("Managehuo.aspx");
    }
}