//添加
protected void btn_Save_Click(object sender, EventArgs e)
{
lab_Error.Text = "";
Profess model = new Profess();
try
{
if (hid_id.Value != "")
{
model=Profess.Load(Convert.ToInt32(hid_id.Value));
}
model.ProCode = txt_MajorCode.Text.Trim();
model.ProName = txt_MajorName.Text.Trim();
model.ProSetting =Convert.ToInt32(ddl_seting.SelectedValue);
model.ProShortName = txt_MajorShortName.Text.Trim();
model.SchoolCate = ddlSchoolCate.SelectedValue.ToString() ;
model.Des = txt_Des.Text.Trim();
model.IsHighLevel = int.Parse(ddlishigh.SelectedValue);
if (hid_id.Value != "")
{
Profess temp = Profess.IsExists(model.Id,model.ProCode);
if (temp != null)
{
lab_Error.Text = "专业编号已经存在";
return;
}
model.Save();
txt_MajorCode.Text = "";
txt_MajorName.Text = "";
txt_MajorShortName.Text = "";
txt_Des.Text = "";
Page.ClientScript.RegisterStartupScript(typeof(string), "", "alert('修改成功');location.href='MajorList.aspx'", true);
hid_id.Value = "";
}
else
{
Profess temp = Profess.GetInstance(model.ProCode);
if (temp != null)
{
lab_Error.Text = "专业编号已经存在";
return;
}
model.Save();
txt_MajorCode.Text = "";
txt_MajorName.Text = "";
txt_MajorShortName.Text = "";
txt_Des.Text = "";
Page.ClientScript.RegisterStartupScript(typeof(string),"","alert('添加成功');",true);
}
}
catch (Exception ex)
{
lab_Error.Text =ex.Message;
}
}
public IList<ProCourse> Fill(Profess profess)
{
if (profess == null)
{
return null;
}
IList<Core.Business.ProCourse> proCourselist = new List<Core.Business.ProCourse>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Code", SqlDbType.NVarChar, profess.ProCode, 30);
SqlDataReader reader = sql.ExecuteSqlReader(SqlFillProCourse);
if (reader != null && !reader.IsClosed)
{
while (reader.Read())
{
Core.Business.ProCourse proCourse = new Core.Business.ProCourse();
if (!reader.IsDBNull(0)) proCourse.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) proCourse.IsMulti = reader.GetBoolean(1);
if (!reader.IsDBNull(2)) proCourse.ProCode = reader.GetString(2);
if (!reader.IsDBNull(3)) proCourse.CourseCode = reader.GetString(3);
if (!reader.IsDBNull(4)) proCourse.CourseCate = reader.GetString(4);
if (!reader.IsDBNull(5)) proCourse.MultiCate = reader.GetString(5);
proCourse.MarkOld();
proCourselist.Add(proCourse);
}
reader.Close();
}
return proCourselist;
}
/// <summary>
/// SqlFillWithParam "SELECT [Id], [ClassCode],[GradeCode],[ProCode],[OrStdNum] FROM [ClassInfo] WHERE [ProCode]=@Profess AND [GradeCode]=@Grade";
/// </summary>
/// <param name="profess"></param>
/// <param name="grade"></param>
/// <returns></returns>
public IList<ClassInfo> Fill(Profess profess, Grade grade)
{
if (profess == null || grade == null)
return null;
IList<Core.Business.ClassInfo> classInfolist = new List<Core.Business.ClassInfo>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Profess", SqlDbType.NVarChar, profess.ProCode, 30);
sql.AddParameter("@Grade", SqlDbType.NVarChar, grade.GradeCode, 30);
SqlDataReader reader = sql.ExecuteSqlReader(SqlFillWithParam);
if (reader != null)
{
while (reader.Read())
{
Core.Business.ClassInfo classInfo = new Core.Business.ClassInfo();
if (!reader.IsDBNull(0)) classInfo.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) classInfo.ClassCode = reader.GetString(1);
if (!reader.IsDBNull(2)) classInfo.GradeCode = reader.GetString(2);
if (!reader.IsDBNull(3)) classInfo.ProCode = reader.GetString(3);
if (!reader.IsDBNull(4)) classInfo.OrStdNum = reader.GetInt32(4);
if (!reader.IsDBNull(5)) classInfo.ClassName = reader.GetString(5);
classInfo.MarkOld();
classInfolist.Add(classInfo);
}
reader.Close();
}
return classInfolist;
}
/// <summary>
/// private static readonly string SqlSelectCoursePlanWithParam = "SELECT [Id], [PlanCode],[PlanYear],[PlanTerm],[ProCode],[PlanGrade] FROM [CoursePlan] WHERE [PlanYear]=@Year AND [PlanTerm]=@Term AND [ProCode]=@Profess AND [PlanGrade]=@Grade";
/// </summary>
/// <param name="profess"></param>
/// <param name="grade"></param>
/// <param name="term"></param>
/// <param name="year"></param>
/// <returns></returns>
public CoursePlan Select(Profess profess, Grade grade, string term, string year, string clsCode)
{
if (profess == null || grade == null || string.IsNullOrEmpty(term) || string.IsNullOrEmpty(year) || string.IsNullOrEmpty(clsCode))
return null;
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Profess", SqlDbType.NVarChar, profess.ProCode, 30);
sql.AddParameter("@Grade", SqlDbType.NVarChar, grade.GradeCode, 30);
sql.AddParameter("@Term", SqlDbType.NVarChar, term, 10);
sql.AddParameter("@Year", SqlDbType.NVarChar, year, 10);
sql.AddParameter("@ClassCode", SqlDbType.NVarChar, clsCode, 30);
SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectCoursePlanWithParam);
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.CoursePlan coursePlan = new Core.Business.CoursePlan();
if (!reader.IsDBNull(0)) coursePlan.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) coursePlan.PlanCode = reader.GetString(1);
if (!reader.IsDBNull(2)) coursePlan.PlanYear = reader.GetString(2);
if (!reader.IsDBNull(3)) coursePlan.PlanTerm = reader.GetString(3);
if (!reader.IsDBNull(4)) coursePlan.ProCode = reader.GetString(4);
if (!reader.IsDBNull(5)) coursePlan.PlanGrade = reader.GetString(5);
if (!reader.IsDBNull(6)) coursePlan.ClsCode = reader.GetString(6);
reader.Close();
coursePlan.MarkOld();
return coursePlan;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
