protected void DataBinds()
{
LabMS.BLL.Professional Pro = new LabMS.BLL.Professional();
LabMS.Model.Professional model = new LabMS.Model.Professional();
model = Pro.GetModel(Convert.ToInt32(QueryStrings));
tb_Code.Text = model.Pro_Code;
tb_EngName.Text = model.Pro_Name;
tb_Name.Text = model.Pro_Name;
}
protected void Submit_Click(object sender, EventArgs e)
{
LabMS.BLL.Professional Pro = new LabMS.BLL.Professional();
LabMS.Model.Professional model = new LabMS.Model.Professional();
model = Pro.GetModel(Convert.ToInt32(QueryStrings));
model.Pro_Name = tb_Name.Text.Trim();
model.Pro_EnglishName = tb_EngName.Text.Trim();
model.Pro_Code = tb_Code.Text.Trim();
try
{
Pro.Update(model);
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('���³ɹ�');window.opener.location.href=window.opener.location.href;self.close();</script>");
}
catch
{
LabMS.Common.JShelper.JSAlert(this, "���½��", "����ʧ��");
}
}
protected void Submit_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(tb_ProCode.Text.Trim()))
{
Common.JShelper.JSAlert(this.Page, "", "רҵ�Ų���Ϊ��!");
tb_ProCode.Focus();
}
else if (string.IsNullOrEmpty( tb_ProIntro.Text.Trim()))
{
Common.JShelper.JSAlert(this.Page, "", "���Ƽ�鲻��Ϊ��!");
tb_ProIntro.Focus();
}
else if (string.IsNullOrEmpty(tb_ProName.Text.Trim()))
{
Common.JShelper.JSAlert(this.Page, "", "רҵ���Ʋ���Ϊ��!");
tb_ProName.Focus();
}
else if (string.IsNullOrEmpty(tb_EngName.Text.Trim()))
{
Common.JShelper.JSAlert(this.Page, "", "Ӣ�����Ʋ���Ϊ��!");
tb_EngName.Focus();
}
else
{
LabMS.BLL.Professional Pro = new LabMS.BLL.Professional();
LabMS.Model.Professional model = new LabMS.Model.Professional();
model.Pro_Code = tb_ProCode.Text.Trim();
model.Pro_Name = tb_ProName.Text.Trim();
model.Pro_EnglishName = tb_EngName.Text.Trim();
if (Pro.Add(model) != 1)
{
LabMS.Common.JShelper.JSAlertAndRedirect(this.Page, "", "�����ɹ�", "ProfessionalList.aspx");
}
else
{
LabMS.Common.JShelper.JSAlert(this, "�������", "����ʧ��,������");
}
}
}
protected void DataBinds()
{
tb_Content.Attributes.Add("readonly", "readonly");
LabMS.BLL.ProfessionalPlan ProPlan = new LabMS.BLL.ProfessionalPlan();
LabMS.Model.ProfessionalPlan model = new LabMS.Model.ProfessionalPlan();
model = ProPlan.GetModel(QueryString);
LabMS.Model.Professional professionalmodel = new LabMS.Model.Professional();
LabMS.BLL.Professional Profess = new LabMS.BLL.Professional();
professionalmodel = Profess.GetModel(model.Pro_Professional.Value);
lb_Pro.Text = professionalmodel.Pro_Name;
if (model.Pro_Curriculum == 1)
{
lb_Term.Text = "��ѧ��";
}
else
{
lb_Term.Text = "��ѧ��";
}
lb_Year.Text = model.Pro_Year.ToString();
tb_Content.Text = model.Pro_Content;
hf_ID.Value = QueryString.ToString();
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public LabMS.Model.Professional GetModel(int ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 ID,Pro_Code,Pro_Name,Pro_EnglishName,Pro_Education from Professional ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = ID;
LabMS.Model.Professional model=new LabMS.Model.Professional();
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.Pro_Code=ds.Tables[0].Rows[0]["Pro_Code"].ToString();
model.Pro_Name=ds.Tables[0].Rows[0]["Pro_Name"].ToString();
model.Pro_EnglishName=ds.Tables[0].Rows[0]["Pro_EnglishName"].ToString();
model.Pro_Education=ds.Tables[0].Rows[0]["Pro_Education"].ToString();
return model;
}
else
{
return null;
}
}
