private void LoadLesson()
{
foreach (OleDbDataReader reader in ThisModule.OleDB.EachRows(
"select Id, FSquadGroup, FCourse, FIsSelfStudy, FSharedTime "
+ " from TLesson"))
{
EnLesson Lsn = new EnLesson();
Lsn.Id = Convert.ToInt64(reader[0]);
Lsn.SquadGroup = ThisModule.Sqd.GrpDAC.Get(Convert.ToInt64(reader[1]));
Lsn.Course = ThisModule.Crs.MbrDAC.Get(Convert.ToInt64(reader[2]));
Lsn.IsSelfStudy = Convert.ToBoolean(reader[3]);
Lsn.SharedTime = Convert.ToInt32(reader[4]);
if (Lsn.SquadGroup == null)
{
ThisModule.ErrorLog.Error("VcLesson恢复错误：ID对应的实体不存在 "
+ " SquadGroup: " + reader[1]);
continue;
}
if (Lsn.Course == null)
{
ThisModule.ErrorLog.Error("VcLesson恢复错误：ID对应的实体不存在 "
+ " Course: " + reader[2]);
continue;
}
LsnContainer LsnCnt = new LsnContainer();
LsnCnt.Lsn = Lsn;
Lsns.Add(LsnCnt.Lsn.Id, LsnCnt);
}
}
public EnLesson SaveLesson(EnLesson Value)
{
foreach (LsnContainer LsnCnt in Lsns.Values)
{
if (LsnCnt.Lsn.SquadGroup == Value.SquadGroup &&
LsnCnt.Lsn.Course == Value.Course)
{
LsnCnt.Lsn.SharedTime = Value.SharedTime;
LsnCnt.Lsn.IsSelfStudy = Value.IsSelfStudy;
ThisModule.OleDB.ExecuteNonQuery("update TLesson set "
+ " FSharedTime = " + Value.SharedTime
+ ", FIsSelfStudy = " + (Value.IsSelfStudy ? "True" : "False")
+ " where Id = " + LsnCnt.Lsn.Id);
return(LsnCnt.Lsn);
}
}
LsnContainer lc = new LsnContainer();
lc.Lsn = new EnLesson();
lc.Lsn.SharedTime = Value.SharedTime;
lc.Lsn.IsSelfStudy = Value.IsSelfStudy;
lc.Lsn.SquadGroup = Value.SquadGroup;
lc.Lsn.Course = Value.Course;
lc.Lsn.Id = Convert.ToInt64(ThisModule.OleDB.InsertAndReturnId_MS("insert into TLesson"
+ " (FSquadGroup, FCourse, FIsSelfStudy, FSharedTime) values ("
+ Value.SquadGroup.Id
+ ", " + Value.Course.Id
+ ", " + (Value.IsSelfStudy ? "True" : "False")
+ ", " + Value.SharedTime
+ ")"));
Lsns.Add(lc.Lsn.Id, lc);
return(lc.Lsn);
}
public void DeleteLesson(EnLesson Lesson)
{
LsnContainer LsnCnt = Lsns[Lesson.Id];
String SWhere = "";
foreach (EnClsLesson ClsLsn in LsnCnt.ClsLessons)
{
if (!String.IsNullOrEmpty(SWhere))
{
SWhere = SWhere + " or ";
}
SWhere = SWhere + "FClsLesson = " + ClsLsn.Id;
ClsLsns.Remove(ClsLsn.Id);
}
Lsns.Remove(Lesson.Id);
if (!String.IsNullOrEmpty(SWhere))
{
ThisModule.OleDB.ExecuteNonQuery("delete from TLsnAct where " + SWhere);
}
ThisModule.OleDB.ExecuteNonQuery("delete from TClsLesson where FLesson = " + Lesson.Id);
ThisModule.OleDB.ExecuteNonQuery("delete from TLesson where Id = " + Lesson.Id);
}