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 Addchuku : 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,qq;
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
34            hh = this.DropDownList1.Text;
35            ii = this.DropDownList2.Text;
36            qq = this.TextBox1.Text;
37
38            SqlConnection scon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
39            scon.Open();
40            SqlCommand scmd = new SqlCommand("insert into chuku(rukuDate,rukuBianma,huoName,shuliang,jinjia,zhonge,beizhu,ghdw,jingbanren,huokuan) values ('" + aa + "','" + bb + "','" + cc + "','" + dd + "','" + ee + "','" + ff + "','" + gg + "','" + hh + "','" + ii + "','" + qq + "')", scon);
41            scmd.ExecuteNonQuery();
42            scmd.Dispose();
43            scon.Close();
44            Response.Write("<script language='javascript'>alert('添加成功！');</script>");
45            Server.Transfer("chukujetongji.aspx");
46        }
47    }
48    private bool kong()
49    ...{
50            if (this.TextBox2.Text == "")
51            ...{
52                Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
53                return false;
54            }
55            else
56            ...{
57                if (this.TextBox3.Text == "")
58                ...{
59                    Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
60                    return false;
61                }
62
63                else
64                ...{
65                    if (this.TextBox5.Text == "")
66                    ...{
67                        Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
68                        return false;
69                    }
70                    else
71                    ...{
72                        if (this.TextBox6.Text == "")
73                        ...{
74                            Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
75                            return false;
76                        }
77                       
78                            else
79                            ...{
80                               return true;
81                            }
82                }
83            }
84        }
85    }
86    protected void Button2_Click(object sender, EventArgs e)
87    ...{
88        Server.Transfer("chukujetongji.aspx");
89    }
90}
91
92