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