using?System;
using?System.Data;
using?System.Configuration;
using?System.Collections;
using?System.Web;
using?System.Web.Security;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.Web.UI.HtmlControls;

public?partial?class?baoxiujilu_add?:?System.Web.UI.Page
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
		if?（!IsPostBack）
????????{
			
			//?xingbie.Items.Add（“male“）;?
			//?xingbie.Items.Add（“female“）;
????????????bianhao.Items.Add（“請(qǐng)選擇“）;
????????????addxiala（“shebeixinxi“?“bianhao“?“kehubianhao“）;
????????????sunhuaichengdu.Items.Add（“輕微“）;
????????????sunhuaichengdu.Items.Add（“中等“）;
????????????sunhuaichengdu.Items.Add（“嚴(yán)重“）;
????????}
????}
????protected?void?Button1_Click（object?sender?EventArgs?e）
????{
????????string?sql;
????????sql=“insert?into?baoxiujilu（bianhaomingchengsunhuaichengdusunhuairiqiweixiufeiyongbeizhu）?values（‘“+bianhao.Text.ToString（）.Trim（）+“‘‘“+mingcheng.Text.ToString（）.Trim（）+“‘‘“+sunhuaichengdu.Text.ToString（）.Trim（）+“‘‘“+sunhuairiqi.Text.ToString（）.Trim（）+“‘‘“+weixiufeiyong.Text.ToString（）.Trim（）+“‘‘“+beizhu.Text.ToString（）.Trim（）+“‘）?“;
????????int?result;
????????result?=?new?Class1（）.hsgexucute（sql）;
????????if?（result?==?1）
????????{
????????????Response.Write（“ript>javascript:alert（‘添加成功‘）;ript>“）;
????????}
????????else
????????{
????????????Response.Write（“ript>javascript:alert（‘系統(tǒng)錯(cuò)誤，請(qǐng)檢查數(shù)據(jù)庫(kù)設(shè)置問題‘）;ript>“）;
????????}
????}
????private?void?addxiala（string?ntable?string?nzd?string?nxlk）
????{
????????string?sql;
????????sql?=?“select?“?+?nzd?+?“?from?“?+?ntable?+?“?order?by?id?desc“;
????????DataSet?result?=?new?DataSet（）;
????????result?=?new?Class1（）.hsggetdata（sql）;
????????if?（result?!=?null）
????????{
????????????if?（result.Tables[0].Rows.Count?>?0）
????????????{
????????????????int?i?=?0;
????????????????for?（i?=?0;?i?????????????????{
????????????????????bianhao.Items.Add（result.Tables[0].Rows[i][0].ToString（）.Trim（））;
????????????????}
????????????}
????????}
????}
????protected?void?bianhao_SelectedIndexChanged（object?sender?EventArgs?e）
????{
????????string?sql?=?““;
????????sql?=?“select?mingcheng?from?shebeixinxi?where?bianhao=‘“+bianhao.Text.ToString（）.Trim（）+“‘“;
????????DataSet?result?=?new?DataSet（）;
????????result?=?new?Class1（）.hsggetdata（sql）;
????????if?（result?!=?null）
????????{
????????????if?（result.Tables[0].Rows.Count?>?0）
????????????{
????????????????
????????????????????mingcheng.Text=result.Tables[0].Rows[0][0].ToString（）.Trim（）;
????????????????
????????????}
????????}
????}
}