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;
 12
 13public partial class Editchuku : System.Web.UI.Page
 14...{
 15    //private readonly string SqlConnectionString = ConfigurationSettings.AppSettings["ConnectionString"].ToString();
 16    private string BID;
 17    private int strID
 18    ...{
 19        get
 20        ...{
 21            return Convert.ToInt32(ViewState["_BID"]);
 22        }
 23        set
 24        ...{
 25            ViewState["_BID"] = Request.QueryString["BID"];
 26        }
 27    }
 28    protected void Page_Load(object sender, EventArgs e)
 29    ...{
 30        if (!IsPostBack)
 31        ...{
 32            BID = Request["BID"].ToString();
 33            BindData(BID);
 34        }
 35    }
 36    private void BindData(string BID)
 37    ...{
 38        string sqlstr;
 39        sqlstr = "select * from chuku where rukuID='" + BID + "'";
 40        SqlConnection scon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
 41        SqlCommand scm = new SqlCommand(sqlstr, scon);
 42        //打开数据库并执行查询操作 
 43        scon.Open();
 44        SqlDataReader dr = scm.ExecuteReader();
 45        if (dr.Read())
 46        ...{
 47            this.TextBox2.Text = dr["rukuBianma"].ToString();
 48            this.TextBox3.Text = dr["huoName"].ToString();
 49            this.TextBox4.Text = dr["shuliang"].ToString();
 50            this.TextBox5.Text = dr["jinjia"].ToString();
 51            this.TextBox6.Text = dr["zhonge"].ToString();
 52            this.TextBox7.Text = dr["beizhu"].ToString();
 53            this.DropDownList1.Text = dr["ghdw"].ToString();
 54            this.DropDownList2.Text = dr["jingbanren"].ToString();
 55        }
 56        //关闭数据库的连接
 57        dr.Close();
 58        scon.Close();
 59    }
 60    private bool kong()
 61    ...{
 62        if (this.TextBox2.Text == "")
 63        ...{
 64            Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
 65            return false;
 66        }
 67        else
 68        ...{
 69            if (this.TextBox3.Text == "")
 70            ...{
 71                Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
 72                return false;
 73            }
 74
 75            else
 76            ...{
 77                if (this.TextBox5.Text == "")
 78                ...{
 79                    Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
 80                    return false;
 81                }
 82                else
 83                ...{
 84                    if (this.TextBox6.Text == "")
 85                    ...{
 86                        Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
 87                        return false;
 88                    }
 89
 90                    else
 91                    ...{
 92                        return true;
 93                    }
 94                }
 95            }
 96        }
 97    }
 98    protected void Button1_Click(object sender, EventArgs e)
 99    ...{
100        if (kong())
101        ...{
102            //定义变量
103            string bbb = Request.QueryString["BID"];
104            string aa, bb, cc, dd, ee, ff, gg, hh, ii,qq;
105            //aa = this.TextBox1.Text;//riqi
106            aa = DateTime.Now.ToString("yyyy-MM-dd");
107            bb = this.TextBox2.Text;//danhao
108            cc = this.TextBox3.Text;//mingcheng
109            dd = this.TextBox4.Text;//shuliang
110            ee = this.TextBox5.Text;//jinhuojia
111            ff = this.TextBox6.Text;//zonge
112            gg = this.TextBox7.Text;//beizhu
113            hh = this.DropDownList1.Text;
114            ii = this.DropDownList2.Text;
115            qq = this.TextBox1.Text;
116            SqlConnection scon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
117            scon.Open();
118            SqlCommand scmd = new SqlCommand("update chuku set rukuDate='" + aa + "',rukuBianma='" + bb + "',huoName='" + cc + "',shuliang='" + dd + "',jinjia='" + ee + "',zhonge='" + ff + "',beizhu='" + gg + "',ghdw='" + hh + "',jingbanren='" + ii + "',huokuan='" + qq + "' where rukuID='" + bbb + "'", scon);
119            scmd.ExecuteNonQuery();
120            scmd.Dispose();
121            scon.Close();
122            Response.Write("<script language='javascript'>alert('更新成功！');</script>");
123            Server.Transfer("rukujetj.aspx");
124        }
125    }
126    protected void Button2_Click(object sender, EventArgs e)
127    ...{
128        Server.Transfer("rukujetj.aspx");
129    }
130}
131