/// <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)); }