public void deleteByCourseTableId(string ctId)
{
string deleteSql = "DELETE FROM t_attendance WHERE courTableID=@courTableID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@courTableID", ctId) };
SQLServerDBUtil.execute(deleteSql, sqlParas);
}
public void delete(object obj)
{
Course course = (Course)obj;
string deleteSql = "DELETE FROM t_course WHERE ID=@ID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@ID", course.Id) };
SQLServerDBUtil.execute(deleteSql, sqlParas);
}
public void delete(object obj)
{
User user = (User)obj;
string deleteSql = "DELETE FROM t_user WHERE ID=@ID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@ID", user.Id) };
SQLServerDBUtil.execute(deleteSql, sqlParas);
}
public void delete(object obj)
{
Attendance att = (Attendance)obj;
string deleteSql = "DELETE FROM t_attendance WHERE ID=@ID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@ID", att.Id) };
SQLServerDBUtil.execute(deleteSql, sqlParas);
}
public void delete(object obj)
{
Class clazz = (Class)obj;
string deleteSql = "DELETE t_class WHERE ID=@ID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@ID", clazz.Id) };
SQLServerDBUtil.execute(deleteSql, sqlParas);
}
public void delete(object obj)
{
Staff staff = (Staff)obj;
string deleteSql = "DELETE FROM t_staff WHERE ID=@ID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@ID", staff.Id) };
SQLServerDBUtil.execute(deleteSql, sqlParas);
}
public void save(object obj)
{
User user = (User)obj;
string insertSql = "INSERT INTO t_user(username,password,type) VALUES(@username,@password,@type)";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@username", user.UserName),
new SqlParameter("@password", user.Password),
new SqlParameter("@type", user.Type) };
SQLServerDBUtil.execute(insertSql, sqlParas);
}
public void save(object obj)
{
Course course = (Course)obj;
string insertSql = "INSERT INTO t_course(name,credit,schoolHour) VALUES(@name,@credit,@schoolHour)";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@name", course.Name),
new SqlParameter("@credit", course.Credit),
new SqlParameter("@schoolHour", course.SchoolHour) };
SQLServerDBUtil.execute(insertSql, sqlParas);
}
public void update(object obj)
{
Course course = (Course)obj;
string updateSql = "UPDATE t_course SET name=@name,credit=@credit,schoolHour=@schoolHour WHERE ID=@ID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@name", course.Name),
new SqlParameter("@credit", course.Credit),
new SqlParameter("@schoolHour", course.SchoolHour),
new SqlParameter("@ID", course.Id) };
SQLServerDBUtil.execute(updateSql, sqlParas);
}
public void update(object obj)
{
User user = (User)obj;
string updateSql = "UPDATE t_user SET username=@username,password=@password,type=@type WHERE ID=@ID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@username", user.UserName),
new SqlParameter("@password", user.Password),
new SqlParameter("@type", user.Type),
new SqlParameter("@ID", user.Id) };
SQLServerDBUtil.execute(updateSql, sqlParas);
}
public void save(object obj)
{
Staff staff = (Staff)obj;
string insertSql = "INSERT INTO t_staff(name,gender,birth,phone,type,userID) VALUES(@name,@gender,@birth,@phone,@type,@userID)";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@name", staff.Name),
new SqlParameter("@gender", staff.Gender),
new SqlParameter("@birth", staff.Birth),
new SqlParameter("@phone", staff.Phone),
new SqlParameter("@type", staff.Type),
new SqlParameter("@userID", staff.UserId) };
SQLServerDBUtil.execute(insertSql, sqlParas);
}
public void save(object obj)
{
Class clazz = (Class)obj;
string insertSql = "INSERT INTO t_class(depart,grade,name,studCount,monitorID,teacherID) VALUES(@depart,@grade,@name,@studCount,@monitorID,@teacherID)";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@depart", clazz.Depart),
new SqlParameter("@grade", clazz.Grade),
new SqlParameter("@name", clazz.Name),
new SqlParameter("@studCount", clazz.StudCount),
string.IsNullOrEmpty(clazz.MonitorID)? new SqlParameter("@monitorID", DBNull.Value) : new SqlParameter("@monitorID", clazz.MonitorID),
new SqlParameter("@teacherID", clazz.TeacherID) };
SQLServerDBUtil.execute(insertSql, sqlParas);
}
public void save(object obj)
{
Attendance att = (Attendance)obj;
string insertSql = "INSERT INTO t_attendance(status,remark,recorder,recorderID,studID,courTableID) VALUES(@status,@remark,@recorder,@recorderID,@studID,@courTableID)";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@status", att.Status),
new SqlParameter("@remark", att.Remark),
new SqlParameter("@recorder", att.Recorder),
new SqlParameter("@recorderID", att.RecorderID),
new SqlParameter("@studID", att.StudID),
new SqlParameter("@courTableID", att.CourTableID) };
SQLServerDBUtil.execute(insertSql, sqlParas);
}
public void update(object obj)
{
Staff staff = (Staff)obj;
string updateSql = "UPDATE t_staff SET name=@name,gender=@gender,birth=@birth,phone=@phone,type=@type,userID=@userID WHERE ID=@ID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@name", staff.Name),
new SqlParameter("@gender", staff.Gender),
new SqlParameter("@birth", staff.Birth),
new SqlParameter("@phone", staff.Phone),
new SqlParameter("@type", staff.Type),
new SqlParameter("@userID", staff.UserId),
new SqlParameter("@ID", staff.Id) };
SQLServerDBUtil.execute(updateSql, sqlParas);
}
public void update(object obj)
{
Attendance att = (Attendance)obj;
string updateSql = "UPDATE t_attendance SET status=@status,remark=@remark,recorder=@recorder,recorderID=@recorderID,studID=@studID,courTableID=@courTableID WHERE ID=@ID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@status", att.Status),
new SqlParameter("@remark", att.Remark),
new SqlParameter("@recorder", att.Recorder),
new SqlParameter("@recorderID", att.RecorderID),
new SqlParameter("@studID", att.StudID),
new SqlParameter("@courTableID", att.CourTableID),
new SqlParameter("@ID", att.Id) };
SQLServerDBUtil.execute(updateSql, sqlParas);
}
public void update(object obj)
{
Class clazz = (Class)obj;
string updateSql = "UPDATE t_class SET depart=@depart,grade=@grade,name=@name,studCount=@studCount,monitorID=@monitorID,teacherID=@teacherID WHERE ID=@ID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@depart", clazz.Depart),
new SqlParameter("@grade", clazz.Grade),
new SqlParameter("@name", clazz.Name),
new SqlParameter("@studCount", clazz.StudCount),
string.IsNullOrEmpty(clazz.MonitorID)? new SqlParameter("@monitorID", DBNull.Value) : new SqlParameter("@monitorID", clazz.MonitorID),
new SqlParameter("@teacherID", clazz.TeacherID),
new SqlParameter("@ID", clazz.Id) };
SQLServerDBUtil.execute(updateSql, sqlParas);
}
public void save(object obj)
{
Student stu = (Student)obj;
string insertSql = "INSERT INTO t_student(stuId,name,gender,birth,phone,address,classID,userID) VALUES(@stuId,@name,@gender,@birth,@phone,@address,@classID,@userID)";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@stuId", stu.StuId),
new SqlParameter("@name", stu.Name),
new SqlParameter("@gender", stu.Gender),
new SqlParameter("@birth", stu.Birth),
new SqlParameter("@phone", stu.Phone),
new SqlParameter("@address", stu.Address),
new SqlParameter("@classID", stu.ClassID),
new SqlParameter("@userID", stu.UserID) };
SQLServerDBUtil.execute(insertSql, sqlParas);
}
public void save(object obj)
{
Teacher teacher = (Teacher)obj;
string insertSql = "INSERT INTO t_teacher(teacherId,name,gender,birth,title,phone,email,userID) VALUES(@teacherId,@name,@gender,@birth,@title,@phone,@email,@userID)";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@teacherId", teacher.TeacherId),
new SqlParameter("@name", teacher.Name),
new SqlParameter("@gender", teacher.Gender),
new SqlParameter("@birth", teacher.Birth),
new SqlParameter("@title", teacher.Title),
new SqlParameter("@phone", teacher.Phone),
new SqlParameter("@email", teacher.Email),
new SqlParameter("@userID", teacher.UserID) };
SQLServerDBUtil.execute(insertSql, sqlParas);
}
public void save(object obj)
{
CourseTable courTable = (CourseTable)obj;
string insertSql = "INSERT INTO t_courseTable(semester,week,weekDay,place,courseTime,teachID,classID,courId) VALUES(@semester,@week,@weekDay,@place,@courseTime,@teachID,@classID,@courId)";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@semester", courTable.Semester),
new SqlParameter("@week", courTable.Week),
new SqlParameter("@weekDay", courTable.WeekDay),
new SqlParameter("@place", courTable.Place),
new SqlParameter("@courseTime", courTable.CourseTime),
new SqlParameter("@teachID", courTable.TeachID),
new SqlParameter("@classID", courTable.ClassID),
new SqlParameter("@courId", courTable.CourId) };
SQLServerDBUtil.execute(insertSql, sqlParas);
}
public void update(object obj)
{
Teacher teacher = (Teacher)obj;
string updateSql = "UPDATE t_teacher SET teacherId=@teacherId, name=@name,gender=@gender,birth=@birth,title=@title,phone=@phone,email=@email,userID=@userID WHERE ID=@ID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@teacherId", teacher.TeacherId),
new SqlParameter("@name", teacher.Name),
new SqlParameter("@gender", teacher.Gender),
new SqlParameter("@birth", teacher.Birth),
new SqlParameter("@title", teacher.Title),
new SqlParameter("@phone", teacher.Phone),
new SqlParameter("@email", teacher.Email),
new SqlParameter("@userID", teacher.UserID),
new SqlParameter("@ID", teacher.Id) };
SQLServerDBUtil.execute(updateSql, sqlParas);
}
public void update(object obj)
{
Student stu = (Student)obj;
string updateSql = "UPDATE t_student SET stuId=@stuId,name=@name,gender=@gender,birth=@birth,phone=@phone,address=@address,classID=@classID,userID=@userID WHERE ID=@ID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@stuId", stu.StuId),
new SqlParameter("@name", stu.Name),
new SqlParameter("@gender", stu.Gender),
new SqlParameter("@birth", stu.Birth),
new SqlParameter("@phone", stu.Phone),
new SqlParameter("@address", stu.Address),
new SqlParameter("@classID", stu.ClassID),
new SqlParameter("@userID", stu.UserID),
new SqlParameter("@ID", stu.Id) };
SQLServerDBUtil.execute(updateSql, sqlParas);
}
public void update(object obj)
{
CourseTable courTable = (CourseTable)obj;
string updateSql = "UPDATE t_courseTable SET semester=@semester,week=@week,weekDay=@weekDay,place=@place,courseTime=@courseTime,teachID=@teachID,classID=@classID,courId=@courId WHERE ID=@ID";
SqlParameter[] sqlParas = new SqlParameter[] { new SqlParameter("@semester", courTable.Semester),
new SqlParameter("@week", courTable.Week),
new SqlParameter("@weekDay", courTable.WeekDay),
new SqlParameter("@place", courTable.Place),
new SqlParameter("@courseTime", courTable.CourseTime),
new SqlParameter("@teachID", courTable.TeachID),
new SqlParameter("@classID", courTable.ClassID),
new SqlParameter("@courId", courTable.CourId),
new SqlParameter("@ID", courTable.Id) };
SQLServerDBUtil.execute(updateSql, sqlParas);
}