protected void ButtonOK_Click(object sender, EventArgs e)
{
TbSubject subject = new TbSubject();
subject.KmName = this.KmName.Text;
subject.Remark = this.Remark.Text;
subject.ZyID = int.Parse(this.ZyName.SelectedValue);
if (this.HiddenKmID.Value == "")
{
subject.ZyID = int.Parse(this.ZyName.SelectedValue);
TbSubjectManager.addSubject(subject);
if (apge <= Maxapge)
{
Load_Subject();
}
else
{
apge--;//到达最后一页，apge已经加一，所以需要减一
}
}
else
{
subject.KmID = int.Parse(this.HiddenKmID.Value);
TbSubjectManager.Get_SubjectBy(subject);
this.HiddenKmID.Value = "";
}
this.KmName.Text = "";
this.Remark.Text = "";
Load_Subject();
}
public void GetSubject(int KmID)
{
TbSubject subject = TbSubjectManager.GetSubjectByID(KmID);
TbSpeciality speciality = TbSpecialityManager.GetSpecialByID(subject.ZyID);
string message = subject.KmID + "," + subject.KmName + "," + speciality.ZyName + "," + subject.Remark;
Response.Write(message);
}
/// <summary>
/// 查询科目信息
/// </summary>
/// <param name="KmName">科目名称</param>
/// <returns>返回满足条件的数据行数</returns>
public int seeSujectcount(TbSubject subject)
{
string sql = "select count(*) from tbSubject where KmName=@KmName";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@KmName", subject.KmName)
};
return(DBHelper.GetScalar(sql, paras));
}
/// <summary>
/// 新增科目信息
/// </summary>
/// <param name="KmName">科目名称</param>
/// <param name="Remark">备注</param>
/// <param name="ZyID">专业ID</param>
/// <returns>返回受影响的行数</returns>
public int addSubject(TbSubject subject)
{
string sql = "insert into tbSubject values(@KmName,@Remark,@ZyID)";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@KmName", subject.KmName),
new SqlParameter("@Remark", subject.Remark),
new SqlParameter("@ZyID", subject.ZyID)
};
return(DBHelper.ExecuteCommand(sql, paras));
}
/// <summary>
/// 修改对应科目ID的信息并返回对应的专业ID
/// </summary>
/// <param name="subject"></param>
/// <returns></returns>
public void Get_SubjectBy(TbSubject subject)
{
string Sql_Update = "update tbSubject set KmName=@KmName,Remark=@Remark,ZyID=@ZyID where KmID=@KmID";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@KmName", subject.KmName),
new SqlParameter("@Remark", subject.Remark),
new SqlParameter("@ZyID", subject.ZyID),
new SqlParameter("@KmID", subject.KmID)
};
DBHelper.ExecuteCommand(Sql_Update, paras);
}
/// <summary>
/// 获取所有科目列表
/// </summary>
/// <returns></returns>
public List <TbSubject> GetAllSubjectList()
{
List <TbSubject> SpecialityList = new List <TbSubject>();
TbSubject sbt = null;
string sql = "select * from tbSubject";
SqlDataReader reader = DBHelper.GetReader(sql);
while (reader.Read())
{
sbt = new TbSubject();
sbt.KmID = (int)reader["KmID"];
sbt.KmName = reader["KmName"].ToString();
sbt.ZyID = (int)reader["ZyID"];
sbt.Remark = reader["Remark"].ToString();
SpecialityList.Add(sbt);
}
reader.Close();
return(SpecialityList);
}
/// <summary>
/// 根据科目ID查找对应科目信息
/// </summary>
/// <param name="KmID">科目ID</param>
/// <returns></returns>
public TbSubject GetSubjectByID(int KmID)
{
TbSubject subject = null;
string Sql_Select = "select * from tbSubject where KmID=@KmID";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@KmID", KmID)
};
SqlDataReader reader = DBHelper.GetReader(Sql_Select, paras);
if (reader.Read())
{
subject = new TbSubject();
subject.KmID = (int)reader["KmID"];
subject.KmName = reader["KmName"].ToString();
subject.Remark = reader["Remark"].ToString();
subject.ZyID = (int)reader["ZyID"];
}
return(subject);
}
/// <summary>
/// 根据专业绑定科目信息
/// </summary>
/// <param name="zyid"></param>
/// <returns></returns>
public List <TbSubject> GetSubjectListByZyId(int zyid)
{
List <TbSubject> SpecialityList = new List <TbSubject>();
TbSubject sbt = null;
string sql = "select * from tbSubject where ZyID=@zyid";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@zyid", zyid)
};
SqlDataReader reader = DBHelper.GetReader(sql, paras);
while (reader.Read())
{
sbt = new TbSubject();
sbt.KmID = (int)reader["KmID"];
sbt.KmName = reader["KmName"].ToString();
sbt.ZyID = (int)reader["ZyID"];
sbt.Remark = reader["Remark"].ToString();
SpecialityList.Add(sbt);
}
reader.Close();
return(SpecialityList);
}
/// <summary>
/// 新增科目信息
/// </summary>
/// <param name="KmName">科目名称</param>
/// <param name="Remark">备注</param>
/// <param name="ZyID">专业ID</param>
/// <returns>返回受影响的行数</returns>
public static int addSubject(TbSubject subject)
{
return(tbSubjectService.addSubject(subject));
}
/// <summary>
/// 查询科目信息
/// </summary>
/// <param name="KmName">科目名称</param>
/// <returns>返回满足条件的数据行数</returns>
public static int seeSubjectcount(TbSubject subject)
{
return(tbSubjectService.seeSujectcount(subject));
}
/// <summary>
/// 修改对应科目ID的信息
/// </summary>
/// <param name="subject"></param>
/// <returns></returns>
public static void Get_SubjectBy(TbSubject subject)
{
tbSubjectService.Get_SubjectBy(subject);
}
