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