/// <summary>
/// 修改班级信息
/// </summary>
/// <param name="arg"></param>
/// <returns></returns>
public static int ModifyGroup(GroupClassInfo arg)
{
string sql =
string.Format(
"update GroupClassTable set GroupName = '{0}', ClassTeacher = '{1}' where ID ={2}",
arg.GroupName, arg.ClassTeacher, arg.ID);
return(SQLiteControl.ExecuteNonQuery(sql));
}
/// <summary>
/// 创建班级
/// </summary>
/// <param name="arg"></param>
/// <returns></returns>
public static int CreateGroup(GroupClassInfo arg)
{
string sql =
string.Format("insert into GroupClassTable values(NULL, '{0}', '{1}','{2}','{3}','{4}', 0)",
arg.GroupName, arg.CreatePerson, arg.CreateDate.ToString("yyyy-MM-dd"), arg.PersonID,
arg.ClassTeacher);
return(SQLiteControl.ExecuteNonQuery(sql));
}