protected void ibnt_addok_Click(object sender, ImageClickEventArgs e)
{
string subjectNo = this.txt_SubjentNo.Text.ToString();
string str2 = this.txt_subjectname.Text.ToString();
string str3 = this.txt_SubjectIntroduction.Text.ToString();
var model = jcSubjectBF.GetSubjectBySubjectNo(subjectNo);
if (model != null)
{
this.cv.IsValid = false;
this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscript",
"<script text=\"text/javascript\" defer=\"defer\">Dialog.alert('添加新科目完成！');</script>");
}
else
{
model=new SHMetroTestSysModel.jc_Subject();
model.SubjectNo = subjectNo;
model.SubjectName = str2;
model.SubjectIntroduction = str3;
model.ShowUnit = null;
if (jcSubjectBF.AddSubject(model))
{
this.AddProhibitSubject(subjectNo);
this.pan_Add.Visible = false;
this.Pan_OK.Visible = true;
this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscript",
"<script text=\"text/javascript\" defer=\"defer\">Dialog.alert('添加新科目完成！');</script>");
}
else
{
this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscript",
"<script text=\"text/javascript\" defer=\"defer\">Dialog.alert('发生未知错误！');</script>");
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SHMetroTestSysModel.jc_Subject DataRowToModel(DataRow row)
{
SHMetroTestSysModel.jc_Subject model = new SHMetroTestSysModel.jc_Subject();
if (row != null)
{
if (row["SubjectNo"] != null)
{
model.SubjectNo = row["SubjectNo"].ToString();
}
if (row["SubjectName"] != null)
{
model.SubjectName = row["SubjectName"].ToString();
}
if (row["SubjectIntroduction"] != null)
{
model.SubjectIntroduction = row["SubjectIntroduction"].ToString();
}
if (row["ShowUnit"] != null)
{
model.ShowUnit = row["ShowUnit"].ToString();
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SHMetroTestSysModel.jc_Subject GetModel(string SubjectNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 SubjectNo,SubjectName,SubjectIntroduction,ShowUnit from jc_Subject ");
strSql.Append(" where SubjectNo=@SubjectNo ");
SqlParameter[] parameters = {
new SqlParameter("@SubjectNo", SqlDbType.VarChar,4) };
parameters[0].Value = SubjectNo;
SHMetroTestSysModel.jc_Subject model = new SHMetroTestSysModel.jc_Subject();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
