public override string Import(List<Campus.DocumentValidator.IRowStream> Rows)
{
if (mOption.Action == ImportAction.InsertOrUpdate)
{
List<CLUBRecord> ClubInsertList = new List<CLUBRecord>();
List<CLUBRecord> ClubUpdateList = new List<CLUBRecord>();
foreach (IRowStream Row in Rows)
{ //教师名称
string SchoolYear = Row.GetValue("学年度");
string Semester = Row.GetValue("学期");
string CLUBName = Row.GetValue("课程名称");
string name = SchoolYear + "," + Semester + "," + CLUBName;
if (Importbot.ClubDic.ContainsKey(name)) //更新
{
CLUBRecord club = Importbot.ClubDic[name];
if (!Log_Dic.ContainsKey(club.UID))
{
ImputLog i_n = new ImputLog();
i_n.lo_CLUB = club.CopyExtension();
Log_Dic.Add(club.UID, i_n);
}
Importbot.SetClub(Row, club);
ClubUpdateList.Add(club);
}
else
{
//新增
CLUBRecord club = new CLUBRecord();
club.SchoolYear = int.Parse(SchoolYear);
club.Semester = int.Parse(Semester);
club.ClubName = CLUBName;
Importbot.SetClub(Row, club);
ClubInsertList.Add(club);
}
}
if (ClubInsertList.Count > 0)
{
StringBuilder mstrLog1 = new StringBuilder();
mstrLog1.AppendLine("新增汇入课程：");
foreach (CLUBRecord each in ClubInsertList)
{
mstrLog1.AppendLine(Importbot.GetLogString(each));
}
tool._A.InsertValues(ClubInsertList);
FISCA.LogAgent.ApplicationLog.Log("课程", "新增汇入", mstrLog1.ToString());
}
if (ClubUpdateList.Count > 0)
{
StringBuilder mstrLog2 = new StringBuilder();
mstrLog2.AppendLine("更新汇入课程：");
foreach (CLUBRecord each in ClubUpdateList)
{
if (Log_Dic.ContainsKey(each.UID))
{
Log_Dic[each.UID].New_club = each.CopyExtension();
mstrLog2.AppendLine(Importbot.SetLog(Log_Dic[each.UID]));
}
}
tool._A.UpdateValues(ClubUpdateList);
FISCA.LogAgent.ApplicationLog.Log("课程", "更新汇入", mstrLog2.ToString());
}
ClubEvents.RaiseAssnChanged();
}
return "";
}
public string SetLog(ImputLog log)
{
//检查与确认资料是否被修改
StringBuilder sb = new StringBuilder();
sb.AppendLine(string.Format("学年度「{0}」学期「{1}」课程名称「{2}」", log.New_club.SchoolYear, log.New_club.Semester, log.New_club.ClubName));
if (log.lo_CLUB.ClubNumber != log.New_club.ClubNumber)
sb.AppendLine(ByOne("代码", log.lo_CLUB.ClubNumber, log.New_club.ClubNumber));
if (log.lo_CLUB.Location != log.New_club.Location)
sb.AppendLine(ByOne("场地", log.lo_CLUB.Location, log.New_club.Location));
if (log.lo_CLUB.ClubCategory != log.New_club.ClubCategory)
sb.AppendLine(ByOne("类型", log.lo_CLUB.ClubCategory, log.New_club.ClubCategory));
if (log.lo_CLUB.RefTeacherID != log.New_club.RefTeacherID)
ByTeacher("老师1", log.lo_CLUB.RefTeacherID, log.New_club.RefTeacherID);
if (log.lo_CLUB.RefTeacherID2 != log.New_club.RefTeacherID2)
ByTeacher("老师2", log.lo_CLUB.RefTeacherID2, log.New_club.RefTeacherID2);
if (log.lo_CLUB.RefTeacherID3 != log.New_club.RefTeacherID3)
ByTeacher("老师3", log.lo_CLUB.RefTeacherID3, log.New_club.RefTeacherID3);
//总课时数
if (log.lo_CLUB.TotalNumberHours != log.New_club.TotalNumberHours)
sb.AppendLine(ByOne("总课时数",
log.lo_CLUB.TotalNumberHours.HasValue ? log.lo_CLUB.TotalNumberHours.Value.ToString() : "",
log.New_club.TotalNumberHours.HasValue ? log.New_club.TotalNumberHours.Value.ToString() : ""));
if (log.lo_CLUB.About != log.New_club.About)
sb.AppendLine(ByOne("简介", log.lo_CLUB.About, log.New_club.About));
if (log.lo_CLUB.Grade1Limit != log.New_club.Grade1Limit)
sb.AppendLine(ByOne("限制:一年级选课人数限制", ByInet(log.lo_CLUB.Grade1Limit), ByInet(log.New_club.Grade1Limit)));
if (log.lo_CLUB.Grade2Limit != log.New_club.Grade2Limit)
sb.AppendLine(ByOne("限制:二年级选课人数限制", ByInet(log.lo_CLUB.Grade2Limit), ByInet(log.New_club.Grade2Limit)));
if (log.lo_CLUB.Grade3Limit != log.New_club.Grade3Limit)
sb.AppendLine(ByOne("限制:三年级选课人数限制", ByInet(log.lo_CLUB.Grade3Limit), ByInet(log.New_club.Grade3Limit)));
if (log.lo_CLUB.Grade4Limit != log.New_club.Grade4Limit)
sb.AppendLine(ByOne("限制:四年级选课人数限制", ByInet(log.lo_CLUB.Grade4Limit), ByInet(log.New_club.Grade4Limit)));
if (log.lo_CLUB.Grade5Limit != log.New_club.Grade5Limit)
sb.AppendLine(ByOne("限制:五年级选课人数限制", ByInet(log.lo_CLUB.Grade5Limit), ByInet(log.New_club.Grade5Limit)));
if (log.lo_CLUB.Grade1BoyLimit != log.New_club.Grade1BoyLimit)
sb.AppendLine(ByOne("限制:一年级选课人数男生限制", ByInet(log.lo_CLUB.Grade1BoyLimit), ByInet(log.New_club.Grade1BoyLimit)));
if (log.lo_CLUB.Grade2BoyLimit != log.New_club.Grade2BoyLimit)
sb.AppendLine(ByOne("限制:二年级选课人数男生限制", ByInet(log.lo_CLUB.Grade2BoyLimit), ByInet(log.New_club.Grade2BoyLimit)));
if (log.lo_CLUB.Grade3BoyLimit != log.New_club.Grade3BoyLimit)
sb.AppendLine(ByOne("限制:三年级选课人数男生限制", ByInet(log.lo_CLUB.Grade3BoyLimit), ByInet(log.New_club.Grade3BoyLimit)));
if (log.lo_CLUB.Grade4BoyLimit != log.New_club.Grade4BoyLimit)
sb.AppendLine(ByOne("限制:四年级选课人数男生限制", ByInet(log.lo_CLUB.Grade4BoyLimit), ByInet(log.New_club.Grade4BoyLimit)));
if (log.lo_CLUB.Grade5BoyLimit != log.New_club.Grade5BoyLimit)
sb.AppendLine(ByOne("限制:五年级选课人数男生限制", ByInet(log.lo_CLUB.Grade5BoyLimit), ByInet(log.New_club.Grade5BoyLimit)));
if (log.lo_CLUB.Grade1GirlLimit != log.New_club.Grade1GirlLimit)
sb.AppendLine(ByOne("限制:一年级选课人数女生限制", ByInet(log.lo_CLUB.Grade1GirlLimit), ByInet(log.New_club.Grade1GirlLimit)));
if (log.lo_CLUB.Grade2GirlLimit != log.New_club.Grade2GirlLimit)
sb.AppendLine(ByOne("限制:二年级选课人数女生限制", ByInet(log.lo_CLUB.Grade2GirlLimit), ByInet(log.New_club.Grade2GirlLimit)));
if (log.lo_CLUB.Grade3GirlLimit != log.New_club.Grade3GirlLimit)
sb.AppendLine(ByOne("限制:三年级选课人数女生限制", ByInet(log.lo_CLUB.Grade3GirlLimit), ByInet(log.New_club.Grade3GirlLimit)));
if (log.lo_CLUB.Grade4GirlLimit != log.New_club.Grade4GirlLimit)
sb.AppendLine(ByOne("限制:四年级选课人数女生限制", ByInet(log.lo_CLUB.Grade4GirlLimit), ByInet(log.New_club.Grade4GirlLimit)));
if (log.lo_CLUB.Grade5GirlLimit != log.New_club.Grade5GirlLimit)
sb.AppendLine(ByOne("限制:五年级选课人数女生限制", ByInet(log.lo_CLUB.Grade5GirlLimit), ByInet(log.New_club.Grade5GirlLimit)));
sb.AppendLine("");
return sb.ToString();
}
