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