//���½�����Ϣ
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;
}
}