/// <summary> /// 插入学籍异动记录 /// </summary> /// <param name="typeid"></param> /// <param name="reason"></param> /// <param name="stuid"></param> /// <param name="date"></param> /// <returns></returns> public int InsertChange(string typeid, string reason, string stuid, string date) { string sql = "insert into ChangeTypeRecode values(@0,@1,@2,@3)"; int i = DataBaseHelper.cmdExecuteNonQuery(sql, typeid, reason, stuid, date); return(i); }
public int UpdateStudentInfo(Students s) { string sql = "update Students set Student_Name=@0,Student_Sex=@1,Student_Class=@2,StudentNum=@3,StudentEnterYear=@4,StudentOrigin=@5,StudentBirthDay=@6,StudentCard=@7,StudentAddress=@8,FamilyTel=@9,DormTel=@10,Mobile=@11,Email=@12 where Student_ID=@13"; int i = DataBaseHelper.cmdExecuteNonQuery(sql, s.Student_Name, s.Student_Sex, s.StudentClass, s.StudentNum, s.StudentEnterYear, s.StudentOrigin, s.StudentBirthDay, s.StudentCard, s.StudentAddress, s.FamilyTel, s.DormTel, s.Mobile, s.Email, s.StudentID); return(i); }
/// <summary> /// 删除学籍异动记录 /// </summary> /// <param name="changeid"></param> /// <returns></returns> public int DeleteChange(string changeid) { string sql = "delete from ChangeTypeRecode where ChangeTypeRecode_ID=@0"; int i = DataBaseHelper.cmdExecuteNonQuery(sql, changeid); return(i); }
public int UpdateClass(Classes c) { string sql = "update Classes set Classes_Name=@0,ClassHeadTeacher=@1,Classes_PS=@2 where Classes_ID=@3"; return(DataBaseHelper.cmdExecuteNonQuery(sql, c.Classes_Name, c.ClassHeadTeacher, c.Classes_PS, c.Classes_ID)); }
public int DeleteTreeViewByClassid(string classid) { string sql = "delete from Classes where Classes_ID=@0"; return(DataBaseHelper.cmdExecuteNonQuery(sql, classid)); }
/// <summary> /// 插入班级 /// </summary> /// <param name="c"></param> /// <returns></returns> public int InsertClasses(Classes c) { string sql = "insert into Classes values (@0,@1,@2,@3,@4)"; return(DataBaseHelper.cmdExecuteNonQuery(sql, c.Classes_ID, c.Classes_Name, c.Classes_Speciality, c.ClassHeadTeacher, c.Classes_PS)); }
public int InsertPunishment(int Recode_ID, string Type_ID, string StudentID, string Content, string Reason, string date) { string sql = "insert into PunshmentAwardsRecode values(@0,@1,@2,@3,@4,@5)"; return(DataBaseHelper.cmdExecuteNonQuery(sql, Recode_ID, Type_ID, StudentID, Content, Reason, date)); }
/// <summary> /// 根据学生id删除学生信息 /// </summary> /// <param name="s"></param> /// <returns></returns> public int DeleteStudent(string studentid) { string sql = "delete from Students where Student_ID=@0"; return(DataBaseHelper.cmdExecuteNonQuery(sql, studentid)); }
/// <summary> /// 删除处分记录 /// </summary> /// <param name="punishmentid"></param> /// <returns></returns> public int DelectPunishment(string punishmentid) { string sql = "delete from PunshmentAwardsRecode where PunshmentAwardsRecode_ID=@0"; return(DataBaseHelper.cmdExecuteNonQuery(sql, punishmentid)); }
/// <summary> /// 根据学生id,科目id修改成绩 /// </summary> /// <param name="score">成绩</param> /// <param name="studentid">学生id</param> /// <param name="subjectid">科目id</param> /// <returns></returns> public int UpdateExamInation(string score, string studentid, string subjectid) { string sql = "update ExamInation set ExamScore=@0 where StudentID=@1 and SubjectsID=@2"; return(DataBaseHelper.cmdExecuteNonQuery(sql, score, studentid, subjectid)); }
/// <summary> /// 插入成绩 /// </summary> /// <param name="studentid">学生id</param> /// <param name="subjectsid">科目id</param> /// <param name="score">成绩</param> /// <returns></returns> public int InsertExamInation(string studentid, string subjectid, string score) { string sql = "insert into Examination values(@0,@1,@2)"; return(DataBaseHelper.cmdExecuteNonQuery(sql, studentid, subjectid, score)); }