/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Save_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(tbClassNumber.Text.Trim()))
{
Common.JShelper.JSAlert(this.Page, "", "班号不能为空！");
tbClassNumber.Focus();
}
else if (string.IsNullOrEmpty(tbClassName.Text.Trim()))
{
Common.JShelper.JSAlert(this.Page, "", "班级名称不能为空！");
tbClassName.Focus();
}
else if (string.IsNullOrEmpty(tbNum.Text.Trim()))
{
Common.JShelper.JSAlert(this.Page, "", "班级人数不能为空！");
tbNum.Focus();
}
else if (string.IsNullOrEmpty(tbClassMajor.Text.Trim()))
{
Common.JShelper.JSAlert(this.Page, "", "所属专业不能为空！");
tbClassMajor.Focus();
}
else
{
LabMS.Model.Class cclass = new LabMS.Model.Class();
ExtendBLL.Class extendclass = new ExtendBLL.Class();
if(extendclass.IsExistClass(tbClassNumber.Text.Trim())==1)
{
Common.JShelper.JSAlert(this.Page,"","该班级编号已经存在！");
tbClassNumber.Text="";
tbClassNumber.Focus();
}
else
{
cclass.Class_Professional =int.Parse(tb.Text.Trim());//专业
cclass.Class_Code = tbClassNumber.Text.Trim();//班级编号
cclass.Class_Name = tbClassName.Text.Trim();//班级名称
cclass.Class_Year = ddlClass.SelectedValue;//年级
cclass.Class_StudentNum =int.Parse(tbNum.Text.Trim());//人数
int a=extendclass.Add(cclass);
if (a > 0)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('新增成功！');window.opener.location.href=window.opener.location.href;self.close();</script>");
}
else
{
Common.JShelper.JSAlert(this.Page,"","新增失败！");
}
}
}
}
protected void InitBindFromDB(int ID)
{
LabMS.BLL.Class BC = new LabMS.BLL.Class();
LabMS.Model.Class MC = new LabMS.Model.Class();
MC = BC.GetModel(ID);
tbClassName.Text = MC.Class_Name;
tbClassNumber.Text = MC.Class_Code;//班号
ddlClass.SelectedValue = MC.Class_Year;
tbNum.Text = MC.Class_StudentNum.Value.ToString();
tb.Text = MC.Class_Professional.Value.ToString();//专业代号
ExtendBLL.Class EC = new ExtendBLL.Class();
tbClassMajor.Text=EC.ProessionalNameByID(int.Parse(tb.Text.Trim()));
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Save_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(tbClassNumber.Text.Trim()))
{
Common.JShelper.JSAlert(this.Page, "", "班号不能为空！");
tbClassNumber.Focus();
}
else if (string.IsNullOrEmpty(tbClassName.Text.Trim()))
{
Common.JShelper.JSAlert(this.Page, "", "班级名称不能为空！");
tbClassName.Focus();
}
else if (string.IsNullOrEmpty(tbNum.Text.Trim()))
{
Common.JShelper.JSAlert(this.Page, "", "班级人数不能为空！");
tbNum.Focus();
}
else if (string.IsNullOrEmpty(tbClassMajor.Text.Trim()))
{
Common.JShelper.JSAlert(this.Page, "", "所属专业不能为空！");
tbClassMajor.Focus();
}
else
{
LabMS.Model.Class cclass = new LabMS.Model.Class();
ExtendBLL.Class extendclass = new ExtendBLL.Class();
cclass.Class_Professional = int.Parse(tb.Text.Trim());//专业
cclass.Class_Code = tbClassNumber.Text.Trim();//班级编号
cclass.Class_Name = tbClassName.Text.Trim();//班级名称
cclass.Class_Year = ddlClass.SelectedValue;//年级
cclass.Class_StudentNum = int.Parse(tbNum.Text.Trim());//人数
cclass.ID = int.Parse(Request.QueryString["ID"].ToString());
try
{
extendclass.Update(cclass);
Common.JShelper.JSAlertAndRedirect(this.Page, "", "更新成功！", "ClassData.aspx");
}
catch
{
Common.JShelper.JSAlert(this.Page, "", "更新失败！");
}
}
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public LabMS.Model.Class GetModel(int ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 ID,Class_Code,Class_Name,Class_Year,Class_StudentNum,Class_Professional from Class ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = ID;
LabMS.Model.Class model=new LabMS.Model.Class();
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.Class_Code=ds.Tables[0].Rows[0]["Class_Code"].ToString();
model.Class_Name=ds.Tables[0].Rows[0]["Class_Name"].ToString();
model.Class_Year=ds.Tables[0].Rows[0]["Class_Year"].ToString();
if(ds.Tables[0].Rows[0]["Class_StudentNum"].ToString()!="")
{
model.Class_StudentNum=int.Parse(ds.Tables[0].Rows[0]["Class_StudentNum"].ToString());
}
if(ds.Tables[0].Rows[0]["Class_Professional"].ToString()!="")
{
model.Class_Professional=int.Parse(ds.Tables[0].Rows[0]["Class_Professional"].ToString());
}
return model;
}
else
{
return null;
}
}
protected void Page_Load(object sender, EventArgs e)
{
strPagePrivilege.Add("BJKB");
strPageUserType.Add("mana");
if (!Page.IsPostBack)
{
if (!string.IsNullOrEmpty(Request.QueryString["ID"]) && !string.IsNullOrEmpty(Request.QueryString["Year"]) && !string.IsNullOrEmpty(Request.QueryString["Term"]))
{
int ClassID = 0;
int Year = 0;
int Term = 0;
if (int.TryParse(Request.QueryString["ID"], out ClassID) && int.TryParse(Request.QueryString["Year"], out Year) && int.TryParse(Request.QueryString["Term"], out Term))
{
DataBinds();
if (ClassID != 0)
{
LabMS.BLL.Class Class = new LabMS.BLL.Class();
LabMS.Model.Class model = new LabMS.Model.Class();
model = Class.GetModel(ClassID);
if (model != null)
{
lb_Class.Text = model.Class_Name;
}
if (Year != 0)
{
lb_Year.Text = Year.ToString();
}
if (Term != 0)
{
if (Term == 1)
{
lb_Term.Text = "��ѧ��";
}
else
{
lb_Term.Text = "��ѧ��";
}
}
}
}
}
}
}
