当前文件： RenKouPuCha/Code/AddRecord.aspx.cs[9K，2009-6-12 11:52:57]，打开代码结构图

		            
  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//源码网址http://www.51aspx.com/CV/RenKouPuCha
 13public partial class Code_AddRecord : System.Web.UI.Page
 14...{   
 15    protected CCUtility _utility = new CCUtility();
 16    DataSet _ds = new DataSet();
 17    string _idField = "";
 18    string _nameFiedl = "";
 19    int _age;
 20    string _profession = "";
 21    string _sex = "";
 22    string _edgLevel = "";
 23    string _nation = "";
 24    string _polity = "";
 25    string _marriage = "";
 26    int _income;
 27    int _provinceID;
 28    int _cityID;
 29    int _townID;
 30    int _countryID;
 31
 32   
 33    protected void Page_Load(object sender, EventArgs e)
 34    ...{
 35        if (!IsPostBack)
 36        ...{
 37            if (Session["UserID"] == null || Session["RoleID"] == null)
 38            ...{
 39                Response.Redirect("Login.aspx");
 40            }
 41        }
 42            
 43    }
 44    public void getData(string sql,string tablename)
 45    ...{
 46        _utility.DBOpen();
 47        SqlCommand cmd = new SqlCommand(sql, _utility.Connection);
 48        SqlDataAdapter da = new SqlDataAdapter();
 49        da.SelectCommand = cmd;
 50        da.Fill(_ds, tablename);
 51        _utility.DBClose();
 52        return;
 53    }
 54
 55    //添加人员信息
 56    protected void submitButton_Click(object sender, EventArgs e)
 57    ...{
 58        _idField = idTextBox.Text;
 59        _nameFiedl = nameTextBox.Text;
 60        if (ageTextBox.Text == "")
 61        ...{
 62            _age = 0;
 63        }
 64        else
 65        ...{
 66            _age = Convert.ToInt32(ageTextBox.Text);
 67        }
 68        _profession = profTextBox.Text;
 69        _sex = sexDrop.SelectedItem.Text;
 70        _edgLevel = eduDropD.SelectedItem.Text;
 71        _nation = nationDropD.SelectedItem.Text;
 72        _polity = polityDropD.SelectedItem.Text;
 73        _marriage = marriDropD.SelectedItem.Text;
 74        if(incomTextBox.Text=="")
 75        ...{
 76            _income=0;
 77        }
 78        else
 79        ...{
 80            _income=Convert.ToInt32(incomTextBox.Text);
 81        }
 82        _provinceID = Convert.ToInt32(DropDownList1.SelectedValue);
 83       
 84        if (DropDownList2.SelectedValue == "")
 85        ...{
 86            _cityID = 0;
 87            _townID = 0;
 88            _countryID = 0;
 89
 90        }
 91        else
 92        ...{
 93            _cityID = Convert.ToInt32(DropDownList2.SelectedValue);
 94            if (DropDownList3.SelectedValue == "")
 95            ...{
 96                _townID = 0;
 97                _countryID = 0;
 98            }
 99            else
100            ...{
101                _townID = Convert.ToInt32(DropDownList3.SelectedValue);
102                if (DropDownList4.SelectedValue == "")
103                ...{
104                    _countryID = 0;
105                }
106                else
107                ...{
108                    _countryID = Convert.ToInt32(DropDownList4.SelectedValue);
109                }
110            }
111        }
112       
113
114      
115        if (_idField == "" || _nameFiedl== "" ||ageTextBox.Text==""  || _profession == "")
116        ...{
117            Response.Write("<script>alert('人口信息没有填写完整！')</script>");
118        }
119        else if(IsExist(_idField))
120        ...{
121            Response.Write("<script>alert('该人员已存在，请检查！')</script>");
122        }
123        else
124        ...{
125            try
126            ...{
127                _utility.DBOpen();
128                SqlCommand cmd = new SqlCommand("AddRk", _utility.Connection);
129                cmd.CommandType = CommandType.StoredProcedure;
130                SqlParameter idParameter = cmd.Parameters.Add("@IdField", SqlDbType.VarChar, 30);
131                idParameter.Value = _idField;
132                SqlParameter nameParameter = cmd.Parameters.Add("@NameField", SqlDbType.VarChar, 30);
133                nameParameter.Value = _nameFiedl;
134                SqlParameter ageParameter = cmd.Parameters.Add("@Age", SqlDbType.Int, 4);
135                ageParameter.Value = _age;
136                SqlParameter proParameter = cmd.Parameters.Add("@Profession", SqlDbType.VarChar, 50);
137                proParameter.Value = _profession;
138                SqlParameter sexParameter = cmd.Parameters.Add("@Sex", SqlDbType.VarChar, 10);
139                sexParameter.Value = _sex;
140                SqlParameter edgParameter = cmd.Parameters.Add("@EdgLevel", SqlDbType.VarChar, 50);
141                edgParameter.Value = _edgLevel;
142                SqlParameter nationParameter = cmd.Parameters.Add("@Nation", SqlDbType.VarChar, 20);
143                nationParameter.Value = _nation;
144                SqlParameter polityParameter = cmd.Parameters.Add("@Polity", SqlDbType.VarChar, 20);
145                polityParameter.Value = _polity;
146                SqlParameter marriParameter = cmd.Parameters.Add("@Marriage", SqlDbType.VarChar, 10);
147                marriParameter.Value = _marriage;
148                SqlParameter incomeParameter = cmd.Parameters.Add("@Incom", SqlDbType.BigInt, 8);
149                incomeParameter.Value = _income;
150                SqlParameter provinceParameter = cmd.Parameters.Add("@ProvinceID", SqlDbType.Int, 4);
151                provinceParameter.Value = _provinceID;
152                SqlParameter cityParamter = cmd.Parameters.Add("@CityID", SqlDbType.Int, 4);
153                cityParamter.Value = _cityID;
154                
155                SqlParameter townParameter = cmd.Parameters.Add("@TownID", SqlDbType.Int, 4);
156                townParameter.Value = _townID;
157                
158                SqlParameter countryParameter = cmd.Parameters.Add("@CountryID", SqlDbType.Int, 4);
159                countryParameter.Value = _countryID;
160                cmd.ExecuteNonQuery();
161                _utility.DBClose();
162                Response.Write("<script>alert('添加人员信息成功！')</script>");
163                idTextBox.Text = "";
164                nameTextBox.Text = "";
165                ageTextBox.Text= "";
166                profTextBox.Text = "";
167                incomTextBox.Text = "";
168            }
169            catch (SqlException sqlerror)
170            ...{
171                Response.Write(sqlerror.Message);
172            }
173            finally
174            ...{
175                _utility.DBClose();
176            }
177        }
178    }
179
180    //根据身份证号码判断，人员是否已经存在
181    private bool IsExist(string id)
182    ...{
183        _utility.DBOpen();
184        string sqlstring = "Select * from tRkry where idfield=" + "'" + id + "'";
185        SqlCommand cmd = new SqlCommand(sqlstring, _utility.Connection);
186        SqlDataReader dr = cmd.ExecuteReader();
187        try
188        ...{
189            if (dr.Read())
190            ...{
191                return true;
192            }
193            else
194            ...{
195                return false;
196            }
197        }
198        finally
199        ...{
200            dr.Close();
201            _utility.DBClose();
202        }
203
204    }
205
206    //返回
207    protected void backButton_Click(object sender, EventArgs e)
208    ...{
209        Response.Redirect("Record.aspx");
210    }
211
212    处理省与市的级联#region 处理省与市的级联
213    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
214    ...{
215        BindCity();
216    }
217    private void BindCity()
218    ...{
219        string sql = "select cityID,cityName from tCity where provinceID=" + Convert.ToInt32(DropDownList1.SelectedValue);
220        getData(sql, "City");
221        DropDownList2.DataSource = _ds.Tables["City"].DefaultView;
222        DropDownList2.DataTextField = "cityName";
223        DropDownList2.DataValueField = "cityID";
224        DropDownList2.DataBind();
225    }
226    protected void DropDownList2_DataBinding(object sender, EventArgs e)
227    ...{
228        DropDownList2.Items.Clear();
229        DropDownList2.AppendDataBoundItems = true;
230        ListItem lt = new ListItem("--未选择--", "0");
231        DropDownList2.Items.Add(lt);
232    }
233    #endregion
234    处理市与县的级连#region 处理市与县的级连
235    protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
236    ...{
237        BindTown();
238    }
239    private void BindTown()
240    ...{
241        string sql = "Select townID,townName from tTown where cityID=" + Convert.ToInt32(DropDownList2.SelectedValue);
242        getData(sql, "Town");
243        DropDownList3.DataSource = _ds.Tables["Town"].DefaultView;
244        DropDownList3.DataTextField = "townName";
245        DropDownList3.DataValueField = "townID";
246        DropDownList3.DataBind();
247    }
248    protected void DropDownList3_DataBinding(object sender, EventArgs e)
249    ...{
250        DropDownList3.Items.Clear();
251        DropDownList3.AppendDataBoundItems = true;
252        ListItem lt = new ListItem("--未选择--", "0");
253        DropDownList3.Items.Add(lt);
254    }
255    #endregion
256    处理县镇级连#region  处理县镇级连
257    protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)
258    ...{
259        string sql = "Select countryID,controyName from tCountry where townID=" + Convert.ToInt32(DropDownList3.SelectedValue);
260        getData(sql, "Country");
261        DropDownList4.DataSource = _ds.Tables["Country"].DefaultView;
262        DropDownList4.DataTextField = "controyName";
263        DropDownList4.DataValueField = "countryID";
264        DropDownList4.DataBind();
265    }
266   
267   
268    protected void DropDownList4_DataBinding(object sender, EventArgs e)
269    ...{
270
271        DropDownList4.Items.Clear();
272        DropDownList4.AppendDataBoundItems = true;
273        ListItem lt = new ListItem("--未选择--", "0");
274        DropDownList4.Items.Add(lt);
275    }
276    #endregion
277}
278