protected void NativeProvinceList_SelectedIndexChanged(object sender, EventArgs e) { // Response.Write("<script>alert('我响应了!')</script>"); String proID = this.NativeProvinceList.SelectedValue; this.NativeCityList.DataSource = DatabaseTool.ExecSqlReturnTable("select * from city where province_num= " + proID); this.NativeCityList.DataTextField = "city_name"; this.NativeCityList.DataValueField = "number"; NativeCityList.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["number"] == null) { Response.Write("<script language=javascript>window.alert('请先登录!');window.location.href=('login.aspx');</script>"); } session.Text = Session["number"].ToString(); //为籍贯和出生地的省下拉框绑定数据源 if (!IsPostBack) { DataTable dt = DatabaseTool.ExecSqlReturnTable("select * from province"); NativeProvinceList.DataSource = dt; NativeProvinceList.DataTextField = "provinceName"; NativeProvinceList.DataValueField = "provinceNum"; NativeProvinceList.DataBind(); BirthProvince.DataSource = dt; BirthProvince.DataTextField = "provinceName"; BirthProvince.DataValueField = "provinceNum"; BirthProvince.DataBind(); //为籍贯和出生地的城市的下拉框绑定数据源 dt = DatabaseTool.ExecSqlReturnTable("select * from city"); NativeCityList.DataSource = dt; NativeCityList.DataTextField = "city_name"; NativeCityList.DataValueField = "city_num"; NativeCityList.DataBind(); BirthCity.DataSource = dt; BirthCity.DataTextField = "city_name"; BirthCity.DataValueField = "city_num"; BirthCity.DataBind(); //为这五个下拉框添加item0 BirthCity.Items.Insert(0, "请选择市"); NativeProvinceList.Items.Insert(0, "请选择省或直辖市"); department.Items.Insert(0, "请选择科室"); BirthProvince.Items.Insert(0, "请选择省或直辖市"); NativeCityList.Items.Insert(0, "请选择市"); //为科室下拉框绑定数据源 dt = DatabaseTool.ExecSqlReturnTable("select * from department"); department.DataSource = dt; department.DataTextField = "d_name"; department.DataBind(); //为主治医师编号下拉框绑定数据源 dt = DatabaseTool.ExecSqlReturnTable("select * from users where type=3"); physician.DataSource = dt; physician.DataTextField = "u_num"; physician.DataBind(); //为病房添加下拉框绑定数据源 dt = DatabaseTool.ExecSqlReturnTable("select * from room"); roomNumber.DataSource = dt; roomNumber.DataTextField = "r_num"; roomNumber.DataBind(); //为病床添加下拉框绑定数据源,必须是可用的病床 dt = DatabaseTool.ExecSqlReturnTable("select * from bed where isavailable=1"); bedNumber.DataSource = dt; bedNumber.DataTextField = "b_num"; bedNumber.DataBind(); } }