当前文件： QiYeKeHuGuanLi/addcompact.aspx.cs[3K，2009-6-12 11:52:45]，打开代码结构图

		            
 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 addcompact : System.Web.UI.Page
14...{
15
16    SqlConnection cn;
17    protected void Page_Load(object sender, EventArgs e)
18    ...{
19        if (Session["branch"].ToString() == "0" || Session["branch"].ToString() == "1" || Session["branch"].ToString() == "2")
20        ...{
21           
22        }
23        else
24        ...{
25            Response.Write("您不是合法用户，请登入后再操作，<a href='default.aspx'>返回登录</a>");
26            Page.Response.End();
27        }
28        string strconn = ConfigurationSettings.AppSettings["ConnectionString"];
29        cn = new SqlConnection(strconn);
30    }
31    private void Cv_id_ServerValidate(object source, System.Web.UI.WebControls.ServerValidateEventArgs args)
32    ...{
33        cn.Open();
34        SqlCommand cm = new SqlCommand("select * from compact where compact_id=@compact_id", cn);
35        cm.Parameters.Add("@compact_id", SqlDbType.VarChar, 20);
36        cm.Parameters["@compact_id"].Value = compact_id.Text;
37        SqlDataReader dr = cm.ExecuteReader();
38        if (dr.Read())
39        ...{
40            args.IsValid = false;
41        }
42        else
43        ...{
44            args.IsValid = true;
45        }
46        cn.Close();
47    }
48    protected void Btn_ok_Click(object sender, EventArgs e)
49    ...{
50        if (Page.IsValid)
51        ...{
52            SqlCommand cm = new SqlCommand("Addcompact", cn);
53            cm.CommandType = CommandType.StoredProcedure;
54            cm.Parameters.Add(new SqlParameter("@compact_id", SqlDbType.VarChar, 20));
55            cm.Parameters.Add(new SqlParameter("@Client_id", SqlDbType.VarChar, 20));
56            cm.Parameters.Add(new SqlParameter("@person", SqlDbType.VarChar, 20));
57            cm.Parameters.Add(new SqlParameter("@price", SqlDbType.Money, 8));            
58            cm.Parameters.Add(new SqlParameter("@start", SqlDbType.DateTime, 8));
59            cm.Parameters.Add(new SqlParameter("@send", SqlDbType.DateTime, 8));
60            cm.Parameters.Add(new SqlParameter("@finish", SqlDbType.DateTime, 8));
61            cm.Parameters.Add(new SqlParameter("@state", SqlDbType.Char, 10));
62            cm.Parameters["@compact_id"].Value = compact_id.Text;
63            cm.Parameters["@Client_id"].Value = DropDownList1.SelectedItem.Value;
64            cm.Parameters["@person"].Value = compact_person.Text;
65            cm.Parameters["@price"].Value = compact_price.Text;           
66            cm.Parameters["@start"].Value = compact_start.Text;
67            cm.Parameters["@send"].Value = compact_send.Text;
68            cm.Parameters["@finish"].Value = compact_finish.Text;
69            cm.Parameters["@state"].Value = compact_state.SelectedItem.Value;
70            cm.Connection.Open();
71            try
72            ...{
73                cm.ExecuteNonQuery();
74                Response.Redirect("editcompact.aspx");
75            }
76            catch (SqlException)
77            ...{
78                Lbl_note.Text = "添加失败";
79                Lbl_note.Style["color"] = "red";
80            }
81            cm.Connection.Close();
82        }
83    }
84    protected void Btn_cancel_Click(object sender, EventArgs e)
85    ...{
86        Page.Response.Redirect("addcompact.aspx");
87    }
88}
89