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();
}
}
