//���½�����Ϣ protected void Modify_OnClick(object sender, EventArgs e) { if (AwardNameTBX.Text.ToString().Trim() == "") { Page.ClientScript.RegisterClientScriptBlock(GetType(), "", "<script type='text/javascript'>alert('�����뽱������!')</script>"); return; } LabMS.Model.AwardInfo award = new LabMS.Model.AwardInfo(); LabMS.BLL.AwardInfo awardinfo = new LabMS.BLL.AwardInfo(); award.ID = int.Parse(ViewState["ID"].ToString());//����ID award.Award_Name = AwardNameTBX.Text.Trim();//�������� award.Award_Lab = int.Parse(LabNameDDL.SelectedValue);//ʵ�������� award.Award_Content = AwardContentTBX.Text.Trim();//�������� award.Award_Level = AwardLevelDDL.SelectedValue;//���� award.Award_Presentation = PresentationTBX.Text.Trim();//�佱��λ award.Award_Time = DateTime.Parse(AwardDate.Text.Trim()); //��ʱ�� award.Award_Type = AwardTypeDDL.SelectedValue;//������ award.Award_Winner = AwarderTBX.Text.Trim();//�� �� �� awardinfo.Update(award);//����һ������Ϣ Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "script", "<script type='text/javascript'>alert('���»���Ϣ�ɹ���');refreshParent();this.window.close();</script>"); }
protected void Page_Load(object sender, EventArgs e) { strPagePrivilege.Add("HJXX"); strPageUserType.Add("mana"); if (Request.QueryString["ID"] == null) { if (!IsPostBack) { List<LabMS.Model.Dictionary> list = new List<LabMS.Model.Dictionary>(); //�������� list = DictionaryDropdownlist("114"); AwardLevelDDL.DataSource = list; AwardLevelDDL.DataBind(); //������ list = DictionaryDropdownlist("116"); AwardTypeDDL.DataSource = list; AwardTypeDDL.DataBind(); //������ѧ�� LabDropdownlist(); } } else if (Request.QueryString["Flag"] != null) { if (!IsPostBack) { int ID; string strID = Request.QueryString["ID"].ToString(); if (int.TryParse(strID, out ID)) { tr1.Visible = false; IDHF.Value = ID.ToString();//�洢IDֵ List<LabMS.Model.Dictionary> list = new List<LabMS.Model.Dictionary>(); //�������� list = DictionaryDropdownlist("114"); AwardLevelDDL.DataSource = list; AwardLevelDDL.DataBind(); //������ list = DictionaryDropdownlist("116"); AwardTypeDDL.DataSource = list; AwardTypeDDL.DataBind(); //������ѧ�� LabDropdownlist(); } } } else { if (!IsPostBack) { int ID; string strID = Request.QueryString["ID"].ToString(); if (int.TryParse(strID, out ID)) { SaveBtn.Visible = false; ModifyBtn.Visible = true; LabNameDDL.Visible = false; label1.Visible = false; label2.Visible = true; tr1.Visible = false; LabMS.BLL.AwardInfo award = new LabMS.BLL.AwardInfo(); LabMS.Model.AwardInfo awardinfo = new LabMS.Model.AwardInfo(); List<LabMS.Model.Dictionary> list = new List<LabMS.Model.Dictionary>(); ViewState["ID"] = ID;//�洢IDֵ //��ȡ������Ϣ ͨ��ID awardinfo = award.GetModel(ID); AwardNameTBX.Text = awardinfo.Award_Name;//��ȡʵ������ AwarderTBX.Text = awardinfo.Award_Winner;//��ȡ������ AwardContentTBX.Text = awardinfo.Award_Content;//�������� PresentationTBX.Text = awardinfo.Award_Presentation;//�佱��λ AwardDate.Text =string.Format("{0:d}", awardinfo.Award_Time); //���� //�������� list = DictionaryDropdownlist("114"); AwardLevelDDL.DataSource = list; AwardLevelDDL.DataBind(); AwardLevelDDL.SelectedValue = awardinfo.Award_Level.ToString(); //������ list = DictionaryDropdownlist("116"); AwardTypeDDL.DataSource = list; AwardTypeDDL.DataBind(); AwardTypeDDL.SelectedValue = awardinfo.Award_Type.ToString(); //��ʵ������ LabDropdownlist(); LabNameDDL.SelectedValue = awardinfo.Award_Lab.ToString(); } else { SaveBtn.Visible = false; ERRLbl.Text = "ϵͳ�쳣��IDֵ���Ϸ���"; ERRLbl.Visible = true; } } } AwardDate.Attributes.Add("onclick", "c.showMoreDay = false;c.show(this);"); AwardDate.Attributes.Add("readOnly", "-1"); }
protected void Page_Load(object sender, EventArgs e) { strPagePrivilege.Add("HJXX"); 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.AwardInfo award = new LabMS.BLL.AwardInfo(); LabMS.Model.AwardInfo awardinfo = new LabMS.Model.AwardInfo(); List<LabMS.Model.Dictionary> list = new List<LabMS.Model.Dictionary>(); IDHF.Value = ID.ToString();//存储ID值 //获取奖励信息 通过ID awardinfo = award.GetModel(ID); AwardNameLbl.Text = awardinfo.Award_Name;//获取奖励名 AwarderLbl.Text = awardinfo.Award_Winner;//获取获奖者名 AwardContentLbl.Text = awardinfo.Award_Content;//奖励内容 PresentationLbl.Text = awardinfo.Award_Presentation;//颁奖单位 AwardDateLbl.Text = string.Format("{0:d}", awardinfo.Award_Time); //日期 //绑定奖励级别 list = DictionaryDropdownlist("114"); AwardLevelDDL.DataSource = list; AwardLevelDDL.DataBind(); AwardLevelDDL.SelectedValue = awardinfo.Award_Level.ToString(); //绑定获奖类型 list = DictionaryDropdownlist("116"); AwardTypeDDL.DataSource = list; AwardTypeDDL.DataBind(); AwardTypeDDL.SelectedValue = awardinfo.Award_Type.ToString(); //绑定实验室名 LabDropdownlist(); LabNameDDL.SelectedValue = awardinfo.Award_Lab.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; } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public LabMS.Model.AwardInfo GetModel(int ID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 ID,Award_Name,Award_Level,Award_Type,Award_Winner,Award_Time,Award_Content,Award_Presentation,Award_Lab from AwardInfo "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4)}; parameters[0].Value = ID; LabMS.Model.AwardInfo model=new LabMS.Model.AwardInfo(); 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.Award_Name=ds.Tables[0].Rows[0]["Award_Name"].ToString(); model.Award_Level=ds.Tables[0].Rows[0]["Award_Level"].ToString(); model.Award_Type=ds.Tables[0].Rows[0]["Award_Type"].ToString(); model.Award_Winner=ds.Tables[0].Rows[0]["Award_Winner"].ToString(); if(ds.Tables[0].Rows[0]["Award_Time"].ToString()!="") { model.Award_Time=DateTime.Parse(ds.Tables[0].Rows[0]["Award_Time"].ToString()); } model.Award_Content=ds.Tables[0].Rows[0]["Award_Content"].ToString(); model.Award_Presentation=ds.Tables[0].Rows[0]["Award_Presentation"].ToString(); if(ds.Tables[0].Rows[0]["Award_Lab"].ToString()!="") { model.Award_Lab=int.Parse(ds.Tables[0].Rows[0]["Award_Lab"].ToString()); } return model; } else { return null; } }