//�����÷���Ϣ protected void Modify_OnClick(object sender, EventArgs e) { LabMS.Model.Location location = new LabMS.Model.Location(); LabMS.BLL.Location loctioninfo = new LabMS.BLL.Location(); location.ID = int.Parse(ViewState["ID"].ToString());//ID location.Location_Name = LocationNameTBX.Text;//�÷����� if (LabDDL.SelectedValue != "0") { location.LabID = int.Parse(LabDDL.SelectedValue);// ����ʵ���� } location.Location_Area = AreaTBX.Text.Trim();// ��� location.Location_Building = BuildingNameTBX.Text.Trim();// ¥���� location.Location_Campus = CampusTBX.Text.Trim();//У�� location.Location_Floor = FloorTBX.Text.Trim();//¥�� location.Location_InCharge = ManagerTBX.Text.Trim();//������ location.Location_Name = BuildingNameTBX.Text.Trim();//¥���� location.Location_Phone = TelTBX.Text.Trim();//��ϵ�绰 location.Location_RoomNum = RoomNumTBX.Text.Trim();//����� location.Location_State = StatusDDL.SelectedValue;//ʹ��״̬ location.Location_Summary = SummaryTBX.Text.Trim();//��ע location.Location_Usage = UsageTBX.Text.Trim();//��; if (StudentNumTBX.Text.Trim() != "") { int i; if (int.TryParse(StudentNumTBX.Text.Trim(), out i)) { location.Location_StudentNum = i;//����ѧ���� } else { Page.ClientScript.RegisterClientScriptBlock(GetType(), "", "<script type='text/javascript'>alert('ѧ��������Ϊ����!')</script>"); return; } } loctioninfo.Update(location);//����һ������Ϣ Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "script", "<script type='text/javascript'>alert('�����÷���Ϣ�ɹ���');refreshParent();this.window.close();</script>"); }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public LabMS.Model.Location GetModel(int ID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 ID,Location_Name,Location_Campus,Location_Building,Location_Floor,Location_RoomNum,LabID,Location_Usage,Location_StudentNum,Location_Area,Location_InCharge,Location_State,Location_Summary,Location_Phone from Location "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4)}; parameters[0].Value = ID; LabMS.Model.Location model=new LabMS.Model.Location(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["ID"].ToString()!="") { model.ID=int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } model.Location_Name=ds.Tables[0].Rows[0]["Location_Name"].ToString(); model.Location_Campus=ds.Tables[0].Rows[0]["Location_Campus"].ToString(); model.Location_Building=ds.Tables[0].Rows[0]["Location_Building"].ToString(); model.Location_Floor=ds.Tables[0].Rows[0]["Location_Floor"].ToString(); model.Location_RoomNum=ds.Tables[0].Rows[0]["Location_RoomNum"].ToString(); if(ds.Tables[0].Rows[0]["LabID"].ToString()!="") { model.LabID=int.Parse(ds.Tables[0].Rows[0]["LabID"].ToString()); } model.Location_Usage=ds.Tables[0].Rows[0]["Location_Usage"].ToString(); if(ds.Tables[0].Rows[0]["Location_StudentNum"].ToString()!="") { model.Location_StudentNum=int.Parse(ds.Tables[0].Rows[0]["Location_StudentNum"].ToString()); } model.Location_Area=ds.Tables[0].Rows[0]["Location_Area"].ToString(); model.Location_InCharge=ds.Tables[0].Rows[0]["Location_InCharge"].ToString(); model.Location_State=ds.Tables[0].Rows[0]["Location_State"].ToString(); model.Location_Summary=ds.Tables[0].Rows[0]["Location_Summary"].ToString(); model.Location_Phone=ds.Tables[0].Rows[0]["Location_Phone"].ToString(); return model; } else { return null; } }
protected void Page_Load(object sender, EventArgs e) { strPagePrivilege.Add("SYYF"); if (UserType == "student" || UserType == "teacher") { modifybtn.Visible = false; DeleteBtn.Visible = false; } if (Request.QueryString["ID"] != null) { if (!IsPostBack) { int ID; string strID = Request.QueryString["ID"].ToString(); if (int.TryParse(strID, out ID)) { LabMS.BLL.Location location = new LabMS.BLL.Location(); LabMS.Model.Location Locationinfo = new LabMS.Model.Location(); List<LabMS.Model.Dictionary> list = new List<LabMS.Model.Dictionary>(); IDHF.Value = ID.ToString();//存储ID值 //获取用房信息 通过ID Locationinfo = location.GetModel(ID); LocationNameLbl.Text = Locationinfo.Location_Name;//名称 AreaLbl.Text = Locationinfo.Location_Area;//面积 BuildingNameLbl.Text = Locationinfo.Location_Building;//楼名称 CampusLbl.Text = Locationinfo.Location_Campus;//校区 FloorLbl.Text = Locationinfo.Location_Floor;//楼层 ManagerLbl.Text = Locationinfo.Location_InCharge;//负责人 BuildingNameLbl.Text = Locationinfo.Location_Name;//楼名称 TelLbl.Text = Locationinfo.Location_Phone;//联系电话 RoomNumLbl.Text = Locationinfo.Location_RoomNum;//房间号 SummaryLbl.Text = Locationinfo.Location_Summary.Replace("\r\n", "<br/>");//备注 UsageLbl.Text = Locationinfo.Location_Usage;//用途 StudentNumLbl.Text = Locationinfo.Location_StudentNum.ToString();//容纳学生数 //绑定使用状态 list = DictionaryDropdownlist("117"); StatusDDL.DataSource = list; StatusDDL.DataBind(); //绑定实验室名 LabDropdowlist(); LabDDL.SelectedValue = Locationinfo.LabID.ToString(); } else { ERRLbl.Text = "系统异常,ID值不合法!"; ERRLbl.Visible = true; modifybtn.Visible = false; DeleteBtn.Visible = false; } } } else { ERRLbl.Text = "系统异常,ID值不合法!"; ERRLbl.Visible = true; modifybtn.Visible = false; DeleteBtn.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { strPagePrivilege.Add("SYYF"); strPageUserType.Add("mana"); if (Request.QueryString["ID"] == null) { if (!IsPostBack) { List<LabMS.Model.Dictionary> list = new List<LabMS.Model.Dictionary>(); //����ʹ��״̬ list = DictionaryDropdownlist("117"); StatusDDL.DataSource = list; StatusDDL.DataBind(); //������ʵ���� LabDropdowlist(); } } else { if (!IsPostBack) { int ID; string strID = Request.QueryString["ID"].ToString(); if (int.TryParse(strID, out ID)) { SaveBtn.Visible = false; ModifyBtn.Visible = true; label1.Visible = false; label2.Visible = true; LabMS.BLL.Location location = new LabMS.BLL.Location(); LabMS.Model.Location Locationinfo = new LabMS.Model.Location(); List<LabMS.Model.Dictionary> list = new List<LabMS.Model.Dictionary>(); ViewState["ID"] = ID;//�洢IDֵ //��ȡ�÷���Ϣ ͨ��ID Locationinfo = location.GetModel(ID); LocationNameTBX.Text = Locationinfo.Location_Name;//���� AreaTBX.Text = Locationinfo.Location_Area;//��� BuildingNameTBX.Text = Locationinfo.Location_Building;//¥���� CampusTBX.Text = Locationinfo.Location_Campus;//У�� FloorTBX.Text = Locationinfo.Location_Floor;//¥�� ManagerTBX.Text = Locationinfo.Location_InCharge;//������ BuildingNameTBX.Text = Locationinfo.Location_Name;//¥���� TelTBX.Text = Locationinfo.Location_Phone;//��ϵ�绰 RoomNumTBX.Text = Locationinfo.Location_RoomNum;//����� SummaryTBX.Text = Locationinfo.Location_Summary;//��ע UsageTBX.Text = Locationinfo.Location_Usage;//��; StudentNumTBX.Text = Locationinfo.Location_StudentNum.ToString();//����ѧ���� //��ʹ��״̬ list = DictionaryDropdownlist("117"); StatusDDL.DataSource = list; StatusDDL.DataBind(); //��ʵ������ LabDropdowlist(); LabDDL.SelectedValue = Locationinfo.LabID.ToString(); } else { SaveBtn.Visible = false; ERRLbl.Text = "ϵͳ�쳣��IDֵ���Ϸ���"; ERRLbl.Visible = true; } } } }