1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12public partial class Editcangku : System.Web.UI.Page
13...{
14    private readonly string SqlConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString();
15    private string BID;
16    private int strID
17    ...{
18        get
19        ...{
20            return Convert.ToInt32(ViewState["_BID"]);
21        }
22        set
23        ...{
24            ViewState["_BID"] = Request.QueryString["BID"];
25        }
26    }
27    protected void Page_Load(object sender, EventArgs e)
28    ...{
29         if (!IsPostBack)
30        ...{
31            BID = Request["BID"].ToString();
32            BindData(BID);
33        }
34    }
35    private void BindData(string BID)
36    ...{
37        string sqlstr;
38        sqlstr = "select * from cangku where ckID='" + BID + "'";
39        SqlConnection scon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
40        SqlCommand scm = new SqlCommand(sqlstr, scon);
41        //打开数据库并执行查询操作 
42        scon.Open();
43        SqlDataReader dr = scm.ExecuteReader();
44        if (dr.Read())
45        ...{
46            this.TextBox1.Text = dr["Name"].ToString();
47            this.TextBox2.Text = dr["ckbm"].ToString();
48            this.TextBox5.Text = dr["beizhu"].ToString();  
49        }
50        //关闭数据库的连接
51        dr.Close();
52        scon.Close();
53    }
54    protected void Button1_Click(object sender, EventArgs e)
55    ...{
56        if (kong())
57        ...{
58            //定义变量
59            string bbb = Request.QueryString["BID"];
60            string aa, bb, cc;
61            aa = this.TextBox1.Text;
62            bb = this.TextBox2.Text;
63            cc = this.TextBox5.Text;
64            SqlConnection scon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
65            scon.Open();
66            SqlCommand scmd = new SqlCommand("update cangku set Name='" + aa +"',beizhu='" + cc + "',ckbm='" + bb + "'  where ckID='" + bbb + "'", scon);
67            scmd.ExecuteNonQuery();
68            scmd.Dispose();
69            scon.Close();
70            Response.Write("<script language='javascript'>alert('修改成功！');</script>");
71            Server.Transfer("manageCangku.aspx");
72        }
73    }
74    private bool kong()
75    ...{
76        if (this.TextBox1.Text == "")
77        ...{
78            Response.Write("<script language='javascript'>alert('仓库名称不能为空！');</script>");
79            return false;
80        }
81        else
82        ...{
83            if (this.TextBox2.Text == "")
84            ...{
85                Response.Write("<script language='javascript'>alert('仓库编码不能为空！');</script>");
86                return false;
87            }
88            else
89            ...{
90                return true;
91            }
92        }
93    }
94    protected void Button2_Click(object sender, EventArgs e)
95    ...{
96        Server.Transfer("manageCangku.aspx");
97    }
98}
99