public int Add(TeacherCourse model)
{
//修改
string sql = "insert into teacher_course(teacher_id,course_id,add_time) " +
"values (@teacher_id,@course_id,@add_time)";
SQLiteParameter[] ps =
{
//修改
new SQLiteParameter("@teacher_id", model.teacher_id),
new SQLiteParameter("@course_id", model.course_id),
new SQLiteParameter("@add_time", DateTime.Now)
};
return(SqliteHelper.Add(sql, ps));
}
public int Add(CourseScore model)
{
//修改
string sql = "insert into course_score(student_id,course_id,score,add_time) " +
"values (@student_id,@course_id,@score,@add_time)";
SQLiteParameter[] ps =
{
//修改
new SQLiteParameter("@student_id", model.student_id),
new SQLiteParameter("@course_id", model.course_id),
new SQLiteParameter("@score", model.score),
new SQLiteParameter("@add_time", DateTime.Now)
};
return(SqliteHelper.Add(sql, ps));
}
public int Add(CreditClass model)
{
//修改
string sql = "insert into credit_class(student_class,credit_limit,add_time) values (@student_class,@credit_limit,@add_time)";
//数组的初始化器
SQLiteParameter[] ps =
{
//修改
new SQLiteParameter("@student_class", model.student_class),
new SQLiteParameter("@credit_limit", model.credit_limit),
new SQLiteParameter("@add_time", DateTime.Now)
};
//执行
return(SqliteHelper.Add(sql, ps));
}
public int Add(Admin model)
{
//修改
string sql = "insert into admin(admin_name,password,add_time) values (@admin_name,@password,@add_time)";
//数组的初始化器
SQLiteParameter[] ps =
{
//修改
new SQLiteParameter("@admin_name", model.admin_name),
new SQLiteParameter("@password", Md5Helper.GetMd5(model.password)),
new SQLiteParameter("@add_time", DateTime.Now)
};
//执行
return(SqliteHelper.Add(sql, ps));
}
public int Add(Student model)
{
string sql = "insert into student(student_id,password,name,sex,student_class,age,add_time) " +
"values (@student_id,@password,@name,@sex,@student_class,@age,@add_time)";
//数组的初始化器
SQLiteParameter[] ps =
{
new SQLiteParameter("@student_id", model.student_id),
new SQLiteParameter("@password", Md5Helper.GetMd5(model.password)),
new SQLiteParameter("@name", model.name),
new SQLiteParameter("@sex", model.sex),
new SQLiteParameter("@student_class", model.student_class),
new SQLiteParameter("@age", model.age),
new SQLiteParameter("@add_time", DateTime.Now)
};
//执行
return(SqliteHelper.Add(sql, ps));
}
public int Add(Teacher model)
{
string sql = "insert into teacher(teacher_id,password,name,sex,position,age,add_time) " +
"values (@teacher_id,@password,@name,@sex,@position,@age,@add_time)";
//数组的初始化器
SQLiteParameter[] ps =
{
new SQLiteParameter("@teacher_id", model.teacher_id),
new SQLiteParameter("@password", Md5Helper.GetMd5(model.password)),
new SQLiteParameter("@name", model.name),
new SQLiteParameter("@sex", model.sex),
new SQLiteParameter("@position", model.position),
new SQLiteParameter("@age", model.age),
new SQLiteParameter("@add_time", DateTime.Now)
};
//执行
return(SqliteHelper.Add(sql, ps));
}
public int Add(Course model)
{
string sql = "insert into course(name,credit,teacher,time,place,capacity,type,add_time) " +
"values (@name,@credit,@teacher,@time,@place,@capacity,@type,@add_time)";
//数组的初始化器
SQLiteParameter[] ps =
{
new SQLiteParameter("@name", model.name),
new SQLiteParameter("@credit", model.credit),
new SQLiteParameter("@teacher", model.teacher),
new SQLiteParameter("@time", model.time),
new SQLiteParameter("@place", model.place),
new SQLiteParameter("@capacity", model.capacity),
new SQLiteParameter("@type", model.type),
new SQLiteParameter("@add_time", DateTime.Now)
};
//执行
return(SqliteHelper.Add(sql, ps));
}
