protected void user_department_SelectedIndexChanged(object sender, EventArgs e) { this.id = this.user_department.SelectedValue; this.user_department.DataSource = DatabaseTool.ExecSqlReturnTable("select * from department where d_number= " + id); this.user_department.DataTextField = "d_name"; this.user_department.DataValueField = "d_number"; user_department.DataBind(); }
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(); DataTable dt = DatabaseTool.ExecSqlReturnTable("select * from device"); examination_num1.DataSource = dt; examination_num1.DataTextField = "d_num"; examination_num1.DataValueField = "d_num"; examination_num1.DataBind(); examination_num2.DataSource = dt; examination_num2.DataTextField = "d_num"; examination_num2.DataBind(); examination_num3.DataSource = dt; examination_num3.DataTextField = "d_num"; examination_num3.DataBind(); examination_num4.DataSource = dt; examination_num4.DataTextField = "d_num"; examination_num4.DataBind(); examination_num5.DataSource = dt; examination_num5.DataTextField = "d_num"; examination_num5.DataBind(); examination_num6.DataSource = dt; examination_num6.DataTextField = "d_num"; examination_num6.DataBind(); examination_num7.DataSource = dt; examination_num7.DataTextField = "d_num"; examination_num7.DataBind(); examination_num8.DataSource = dt; examination_num8.DataTextField = "d_num"; examination_num8.DataBind(); examination_num9.DataSource = dt; examination_num9.DataTextField = "d_num"; examination_num9.DataBind(); examination_num10.DataSource = dt; examination_num10.DataTextField = "d_num"; examination_num10.DataBind(); //不可编辑的医生编号从session中获取,即当前用户的编号 doctor1.Text = Session["doctorNum"].ToString(); doctor2.Text = Session["doctorNum"].ToString(); doctor3.Text = Session["doctorNum"].ToString(); doctor4.Text = Session["doctorNum"].ToString(); doctor5.Text = Session["doctorNum"].ToString(); doctor6.Text = Session["doctorNum"].ToString(); doctor7.Text = Session["doctorNum"].ToString(); doctor8.Text = Session["doctorNum"].ToString(); doctor9.Text = Session["doctorNum"].ToString(); doctor10.Text = Session["doctorNum"].ToString(); }
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>"); } System.Diagnostics.Debug.Write(Session["number"]); session.Text = Session["number"].ToString(); DataTable dt = DatabaseTool.ExecSqlReturnTable("select * from department"); room_department.DataSource = dt; room_department.DataTextField = "d_name"; room_department.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 department"); user_department.DataSource = dt; user_department.DataTextField = "d_name"; user_department.DataValueField = "d_number"; user_department.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(); doctor_num.Text = Session["doctorNum"].ToString(); doctor_name.Text = Session["number"].ToString(); DataTable dt = DatabaseTool.ExecSqlReturnTable("select * from patient where attending_physican_num=" + Session["doctorNum"].ToString()); patient_num.DataSource = dt; patient_num.DataTextField = "p_name"; patient_num.DataValueField = "p_number"; patient_num.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(); } }