/// <summary>
/// 根据专业ID查询对应详细信息
/// </summary>
/// <param name="zyid"></param>
private void GetSpecial(int zyid)
{
TbSpeciality special = TbSpecialityManager.GetSpecialByID(zyid);
string message = special.ZyID + "|" + special.ZyName + "|" + special.Remark;
Response.Write(message);
}
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>
/// 根据专业ID修改专业信息
/// </summary>
/// <param name="spec">专业对象</param>
/// <returns></returns>
public int EditSpecByID(TbSpeciality spec)
{
string sql = "update tbSpeciality set ZyName=@ZyName,Remark=@Remark where ZyID=@ZyID";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@ZyName", spec.ZyName),
new SqlParameter("@Remark", spec.Remark),
new SqlParameter("@ZyID", spec.ZyID)
};
return(DBHelper.ExecuteCommand(sql, paras));
}
/// <summary>
/// 获取所有专业列表
/// </summary>
/// <returns></returns>
public List <TbSpeciality> GetAllSpecialityList()
{
List <TbSpeciality> subjectList = new List <TbSpeciality>();
TbSpeciality sbt = null;
string sql = "select * from tbSpeciality";
SqlDataReader reader = DBHelper.GetReader(sql);
while (reader.Read())
{
sbt = new TbSpeciality();
sbt.ZyName = reader["ZyName"].ToString();
sbt.ZyID = (int)reader["ZyID"];
sbt.Remark = reader["Remark"].ToString();
subjectList.Add(sbt);
}
reader.Close();
return(subjectList);
}
/// <summary>
/// 根据教师编号LsID查询对应的详细信息
/// </summary>
/// <param name="LsID"></param>
private void GetTeacher(int YhID)
{
TbTeacher teacher = TbTeacherManager.GetTeacherInfoByLsID(YhID);
TbUser user = TbUserManager.GetUserInfoByYhID(YhID);
string role = "";
if (user.Zt == 1)
{
role = "管理员";
}
else
{
role = "教师";
}
TbSpeciality speciality = TbSpecialityManager.GetSpecialByID(teacher.ZyID);
string message = teacher.YhID + "|" + teacher.LsName + "|" + user.YhName + "|" + user.YhPwd + "|" + role + "|" + speciality.ZyName + "|" + teacher.Remark;
Response.Write(message);
}
/// <summary>
/// 根据专业ID返回对应详细信息
/// </summary>
/// <param name="ZyID">专业ID</param>
/// <returns></returns>
public TbSpeciality GetSpecialByID(int ZyID)
{
TbSpeciality spec = null;
string sql = "select * from tbSpeciality where ZyID=@ZyID";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@ZyID", ZyID)
};
SqlDataReader reader = DBHelper.GetReader(sql, paras);
if (reader.Read())
{
spec = new TbSpeciality();
spec.ZyID = ZyID;
spec.ZyName = reader["ZyName"].ToString();
spec.Remark = reader["Remark"].ToString();
reader.Close();
}
return(spec);
}
/// <summary>
/// 新增界面确定添加按钮单击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnbc_Click(object sender, EventArgs e)
{
TbSpeciality special = new TbSpeciality();
special.ZyName = this.ZyName.Text;
special.Remark = this.Remark.Text;
if (hidSpecID.Value != "")
{
special.ZyID = int.Parse(this.hidSpecID.Value);
TbSpecialityManager.EditSpecByID(special);
this.hidSpecID.Value = "";
}
else
{
TbSpecialityManager.addSpeciality(special.ZyName, special.Remark);
}
this.ZyName.Text = "";
this.Remark.Text = "";
GetAllSpenIntoCount();//重新调用方法实现数据加载
}
/// <summary>
/// 根据当前已有成绩获取对应所有专业列表
/// </summary>
/// <returns></returns>
public List <TbSpeciality> GetAllSpecialityListByScore()
{
List <TbSpeciality> subjectList = new List <TbSpeciality>();
TbSpeciality sbt = null;
StringBuilder sbsql = new StringBuilder();
sbsql.Append("select * from tbSpeciality where ZyID in (select ZyID from tbSubject where KmID in (select KmID from tbTestPaper ");
sbsql.Append(" where SjID in (select SjID from tbObjTopic where KgtID in(select KgtID from tbScore))))");
SqlDataReader reader = DBHelper.GetReader(sbsql.ToString());
while (reader.Read())
{
sbt = new TbSpeciality();
sbt.ZyName = reader["ZyName"].ToString();
sbt.ZyID = (int)reader["ZyID"];
sbt.Remark = reader["Remark"].ToString();
subjectList.Add(sbt);
}
reader.Close();
return(subjectList);
}
/// <summary>
/// 根据专业ID修改专业信息
/// </summary>
/// <param name="spec">专业对象</param>
/// <returns></returns>
public static int EditSpecByID(TbSpeciality spec)
{
return(tbSpecialityService.EditSpecByID(spec));
}
