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 Addruku : System.Web.UI.Page
14...{
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17
18    }
19    protected void Button1_Click(object sender, EventArgs e)
20    ...{
21        if (kong())
22        ...{
23            //定义变量
24            string aa, bb, cc, dd, ee, ff, gg, hh, ii;
25            //aa = this.TextBox1.Text;//riqi
26            aa =DateTime.Now.ToString("yyyy-MM-dd");
27            bb = this.TextBox2.Text;//danhao
28            cc = this.TextBox3.Text;//mingcheng
29            dd = this.TextBox4.Text;//shuliang
30            ee = this.TextBox5.Text;//jinhuojia
31            ff = this.TextBox6.Text;//zonge
32            gg = this.TextBox7.Text;//beizhu
33            hh = this.DropDownList1.Text;
34            ii = this.DropDownList2.Text;
35
36            SqlConnection scon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
37            scon.Open();
38            SqlCommand scmd = new SqlCommand("insert into ruku(rukuDate,rukuBianma,huoName,shuliang,jinjia,zhonge,beizhu,ghdw,jingbanren) values ('" + aa + "','" + bb + "','" + cc + "','" + dd + "','" + ee + "','" + ff + "','" + gg + "','" + hh + "','" + ii + "')", scon);
39            scmd.ExecuteNonQuery();
40            scmd.Dispose();
41            scon.Close();
42            Response.Write("<script language='javascript'>alert('添加成功！');</script>");
43            Server.Transfer("rukujetj.aspx");
44        }
45    }
46    private bool kong()
47    ...{
48            if (this.TextBox2.Text == "")
49            ...{
50                Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
51                return false;
52            }
53            else
54            ...{
55                if (this.TextBox3.Text == "")
56                ...{
57                    Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
58                    return false;
59                }
60
61                else
62                ...{
63                    if (this.TextBox5.Text == "")
64                    ...{
65                        Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
66                        return false;
67                    }
68                    else
69                    ...{
70                        if (this.TextBox6.Text == "")
71                        ...{
72                            Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
73                            return false;
74                        }
75                       
76                            else
77                            ...{
78                               return true;
79                            }
80                }
81            }
82        }
83    }
84    protected void Button2_Click(object sender, EventArgs e)
85    ...{
86        Server.Transfer("rukujetj.aspx");
87    }
88}
89