void bkwImport_DoWork(object sender, DoWorkEventArgs e)
{
BackgroundWorker bkw = (BackgroundWorker)sender;
List<List<RowData>> packages = (List<List<RowData>>)((object[])e.Argument)[0];
List<string> importFields = (List<string>)((object[])e.Argument)[1];
//_Process.StartImport();
if (ImportStart != null)
ImportStart(this, new EventArgs());
double totle = 0.0;
double packageProgress = 100.0 / packages.Count;
bkw.ReportProgress(1);
foreach (List<RowData> package in packages)
{
//_Process.ImportPackage(package, importFields);
if (ImportPackage != null)
{
SmartSchool.API.PlugIn.Import.ImportPackageEventArgs args = new SmartSchool.API.PlugIn.Import.ImportPackageEventArgs();
args.ImportFields.AddRange(importFields);
args.Items.AddRange(package);
ImportPackage(this, args);
}
totle += packageProgress;
bkw.ReportProgress((int)totle);
}
}
void wizard_ImportPackage(object sender, SmartSchool.API.PlugIn.Import.ImportPackageEventArgs e)
{
// 尋找主要Key來判斷，如果有學生系統編號先用系統編號，沒有使用學號，
Dictionary <string, RowData> RowDataDict = new Dictionary <string, RowData>();
Dictionary <string, int> chkSidDict = new Dictionary <string, int>();
Dictionary <string, string> chkSnumDict = new Dictionary <string, string>();
List <JHStudentRecord> InsertStudentRecList = new List <JHStudentRecord>();
List <JHStudentRecord> StudentRecAllList = JHStudent.SelectAll();
foreach (JHStudentRecord rec in StudentRecAllList)
{
chkSidDict.Add(rec.ID, 0);
string key = rec.StudentNumber + rec.StatusStr;
if (!chkSnumDict.ContainsKey(key))
{
chkSnumDict.Add(key, rec.ID);
}
}
// 先處理學生基本資料
foreach (RowData Row in e.Items)
{
string StudentID = "";
if (Row.ContainsKey("學生系統編號"))
{
string id = Row["學生系統編號"].ToString();
if (chkSidDict.ContainsKey(id))
{
StudentID = id;
}
}
if (StudentID == "")
{
string ssNum = "", snum = "";
if (Row.ContainsKey("學號"))
{
snum = Row["學號"].ToString();
string status = "一般";
if (Row.ContainsKey("狀態"))
{
if (Row["狀態"].ToString() != "")
{
status = Row["狀態"].ToString();
}
}
ssNum = snum + status;
}
if (chkSnumDict.ContainsKey(ssNum))
{
StudentID = chkSnumDict[ssNum];
}
else
{
// 新增
if (chkSnumDict.ContainsKey(snum + "一般"))
{
// 有重複
}
else
{
// 批次新增
JHStudentRecord newRec = new JHStudentRecord();
newRec.StudentNumber = snum;
newRec.Status = StudentRecord.StudentStatus.一般;
if (Row.ContainsKey("姓名"))
{
newRec.Name = Row["姓名"].ToString();
}
InsertStudentRecList.Add(newRec);
}
}
}
}
// 如有新學生處理新增學生
if (InsertStudentRecList.Count > 0)
{
JHStudent.Insert(InsertStudentRecList);
}
// 再次建立索引
Dictionary <string, JHStudentRecord> StudRecAllDict = new Dictionary <string, JHStudentRecord>();
StudentRecAllList = JHStudent.SelectAll();
chkSidDict.Clear();
chkSnumDict.Clear();
foreach (JHStudentRecord rec in StudentRecAllList)
{
chkSidDict.Add(rec.ID, 0);
string key = rec.StudentNumber + rec.StatusStr;
if (!chkSnumDict.ContainsKey(key))
{
chkSnumDict.Add(key, rec.ID);
}
StudRecAllDict.Add(rec.ID, rec);
}
List <string> StudentIDList = new List <string>();
//比對
foreach (RowData Row in e.Items)
{
string StudentID = "";
if (Row.ContainsKey("學生系統編號"))
{
string id = Row["學生系統編號"].ToString();
if (chkSidDict.ContainsKey(id))
{
StudentID = id;
}
}
if (StudentID == "")
{
string ssNum = "", snum = "";
if (Row.ContainsKey("學號"))
{
snum = Row["學號"].ToString();
string status = "一般";
if (Row.ContainsKey("狀態"))
{
if (Row["狀態"].ToString() != "")
{
status = Row["狀態"].ToString();
}
}
ssNum = snum + status;
}
if (chkSnumDict.ContainsKey(ssNum))
{
StudentID = chkSnumDict[ssNum];
}
}
if (!string.IsNullOrEmpty(StudentID))
{
if (!RowDataDict.ContainsKey(StudentID))
{
RowDataDict.Add(StudentID, Row);
}
StudentIDList.Add(StudentID);
}
}
// 取得學生基本、父母監護人、電話、地址、UDT
List <JHStudentRecord> StudentRecordList = JHStudent.SelectByIDs(StudentIDList);
Dictionary <string, JHStudentRecord> StudentRecordDict = new Dictionary <string, JHStudentRecord>();
foreach (JHStudentRecord rec in StudentRecordList)
{
if (!StudentRecordDict.ContainsKey(rec.ID))
{
StudentRecordDict.Add(rec.ID, rec);
}
}
List <JHParentRecord> ParentRecordList = JHParent.SelectByStudentIDs(StudentIDList);
Dictionary <string, JHParentRecord> ParentRecordDict = new Dictionary <string, JHParentRecord>();
foreach (JHParentRecord rec in ParentRecordList)
{
if (!ParentRecordDict.ContainsKey(rec.RefStudentID))
{
ParentRecordDict.Add(rec.RefStudentID, rec);
}
}
List <JHPhoneRecord> PhoneRecordList = JHPhone.SelectByStudentIDs(StudentIDList);
Dictionary <string, JHPhoneRecord> PhoneRecordDict = new Dictionary <string, JHPhoneRecord>();
foreach (JHPhoneRecord rec in PhoneRecordList)
{
if (!PhoneRecordDict.ContainsKey(rec.RefStudentID))
{
PhoneRecordDict.Add(rec.RefStudentID, rec);
}
}
List <JHAddressRecord> AddressRecordList = JHAddress.SelectByStudentIDs(StudentIDList);
Dictionary <string, JHAddressRecord> AddressRecordDict = new Dictionary <string, JHAddressRecord>();
foreach (JHAddressRecord rec in AddressRecordList)
{
if (!AddressRecordDict.ContainsKey(rec.RefStudentID))
{
AddressRecordDict.Add(rec.RefStudentID, rec);
}
}
AccessHelper accHepler = new AccessHelper();
string qry = "ref_student_id in('" + string.Join("','", StudentIDList.ToArray()) + "')";
List <StudentRecord_Ext> StudentRecord_ExtList = accHepler.Select <StudentRecord_Ext>(qry);
Dictionary <string, StudentRecord_Ext> StudentRecord_ExtDict = new Dictionary <string, StudentRecord_Ext> ();
foreach (StudentRecord_Ext rec in StudentRecord_ExtList)
{
if (!StudentRecord_ExtDict.ContainsKey(rec.RefStudentID))
{
StudentRecord_ExtDict.Add(rec.RefStudentID, rec);
}
}
// 開始處理
List <JHStudentRecord> updateStudentRecList = new List <JHStudentRecord>();
List <JHParentRecord> updateParentRecList = new List <JHParentRecord>();
List <JHPhoneRecord> updatePhoneList = new List <JHPhoneRecord>();
List <JHAddressRecord> updateAddressList = new List <JHAddressRecord>();
List <StudentRecord_Ext> insertStudentRecord_ExtList = new List <StudentRecord_Ext>();
List <StudentRecord_Ext> updateStudentRecord_ExtList = new List <StudentRecord_Ext>();
List <JHClassRecord> classRecAllList = JHClass.SelectAll();
Dictionary <string, string> classNameIDDict = new Dictionary <string, string>();
foreach (JHClassRecord rec in classRecAllList)
{
classNameIDDict.Add(rec.Name, rec.ID);
}
StringBuilder sbLog = new StringBuilder();
foreach (string StudentID in RowDataDict.Keys)
{
RowData rd = RowDataDict[StudentID];
if (StudentRecordDict.ContainsKey(StudentID))
{
string tt = "學生系統編號：" + StudentID + ",學號：" + StudentRecordDict[StudentID].StudentNumber;
if (StudentRecordDict[StudentID].Class != null)
{
tt += "班級：" + StudentRecordDict[StudentID].Class.Name;
}
if (StudentRecordDict[StudentID].SeatNo.HasValue)
{
tt += "座號：" + StudentRecordDict[StudentID].SeatNo.Value;
}
sbLog.AppendLine(tt);
if (rd.ContainsKey("學號"))
{
string value = rd["學號"].ToString();
if (StudentRecordDict[StudentID].StudentNumber != value)
{
sbLog.AppendLine(string.Format("學號由「{0}」改為「{1}」", StudentRecordDict[StudentID].StudentNumber, value));
}
StudentRecordDict[StudentID].StudentNumber = value;
}
if (rd.ContainsKey("班級"))
{
string value = rd["班級"].ToString();
string oldValue = "";
if (StudentRecordDict[StudentID].Class != null)
{
oldValue = StudentRecordDict[StudentID].Class.Name;
}
if (oldValue != value)
{
sbLog.AppendLine(string.Format("班級由「{0}」改為「{1}」", oldValue, value));
}
if (classNameIDDict.ContainsKey(value))
{
StudentRecordDict[StudentID].RefClassID = classNameIDDict[value];
}
}
if (rd.ContainsKey("座號"))
{
string value = rd["座號"].ToString();
string oldValue = "";
if (StudentRecordDict[StudentID].SeatNo.HasValue)
{
oldValue = StudentRecordDict[StudentID].SeatNo.Value.ToString();
}
if (oldValue != value)
{
sbLog.AppendLine(string.Format("座號由「{0}」改為「{1}」", oldValue, value));
}
StudentRecordDict[StudentID].SeatNo = null;
int i;
if (int.TryParse(value, out i))
{
StudentRecordDict[StudentID].SeatNo = i;
}
}
if (rd.ContainsKey("姓名"))
{
string value = rd["姓名"].ToString();
if (StudentRecordDict[StudentID].Name != value)
{
sbLog.AppendLine(string.Format("姓名由「{0}」改為「{1}」", StudentRecordDict[StudentID].Name, value));
}
StudentRecordDict[StudentID].Name = value;
}
if (rd.ContainsKey("身分證號"))
{
string value = rd["身分證號"].ToString();
if (StudentRecordDict[StudentID].IDNumber != value)
{
sbLog.AppendLine(string.Format("身分證號由「{0}」改為「{1}」", StudentRecordDict[StudentID].IDNumber, value));
}
StudentRecordDict[StudentID].IDNumber = value;
}
if (rd.ContainsKey("國籍"))
{
string value = rd["國籍"].ToString();
if (StudentRecordDict[StudentID].Nationality != value)
{
sbLog.AppendLine(string.Format("國籍由「{0}」改為「{1}」", StudentRecordDict[StudentID].Nationality, value));
}
StudentRecordDict[StudentID].Nationality = value;
}
if (rd.ContainsKey("出生地"))
{
string value = rd["出生地"].ToString();
if (StudentRecordDict[StudentID].BirthPlace != value)
{
sbLog.AppendLine(string.Format("出生地由「{0}」改為「{1}」", StudentRecordDict[StudentID].BirthPlace, value));
}
StudentRecordDict[StudentID].BirthPlace = value;
}
if (rd.ContainsKey("生日"))
{
string value = rd["生日"].ToString();
string oldValue = "";
if (StudentRecordDict[StudentID].Birthday.HasValue)
{
oldValue = StudentRecordDict[StudentID].Birthday.Value.ToShortDateString();
}
if (oldValue != value)
{
sbLog.AppendLine(string.Format("生日由「{0}」改為「{1}」", oldValue, value));
}
StudentRecordDict[StudentID].Birthday = null;
DateTime dt;
if (DateTime.TryParse(value, out dt))
{
StudentRecordDict[StudentID].Birthday = dt;
}
}
if (rd.ContainsKey("性別"))
{
string value = rd["性別"].ToString();
if (StudentRecordDict[StudentID].Gender != value)
{
sbLog.AppendLine(string.Format("性別由「{0}」改為「{1}」", StudentRecordDict[StudentID].Gender, value));
}
StudentRecordDict[StudentID].Gender = value;
}
if (rd.ContainsKey("英文姓名"))
{
string value = rd["英文姓名"].ToString();
if (StudentRecordDict[StudentID].EnglishName != value)
{
sbLog.AppendLine(string.Format("英文姓名由「{0}」改為「{1}」", StudentRecordDict[StudentID].EnglishName, value));
}
StudentRecordDict[StudentID].EnglishName = value;
}
if (rd.ContainsKey("登入帳號"))
{
string value = rd["登入帳號"].ToString();
if (StudentRecordDict[StudentID].SALoginName != value)
{
sbLog.AppendLine(string.Format("登入帳號由「{0}」改為「{1}」", StudentRecordDict[StudentID].SALoginName, value));
}
StudentRecordDict[StudentID].SALoginName = value;
}
if (rd.ContainsKey("狀態"))
{
string value = rd["狀態"].ToString();
string oldValue = StudentRecordDict[StudentID].StatusStr;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("狀態由「{0}」改為「{1}」", oldValue, value));
}
switch (value)
{
case "":
case "一般": StudentRecordDict[StudentID].Status = StudentRecord.StudentStatus.一般; break;
case "畢業或離校": StudentRecordDict[StudentID].Status = StudentRecord.StudentStatus.畢業或離校; break;
case "休學": StudentRecordDict[StudentID].Status = StudentRecord.StudentStatus.休學; break;
case "輟學": StudentRecordDict[StudentID].Status = StudentRecord.StudentStatus.輟學; break;
case "刪除": StudentRecordDict[StudentID].Status = StudentRecord.StudentStatus.刪除; break;
}
}
}
// 和班級走
//if (rd.ContainsKey("年級") && StudentRecordDict.ContainsKey(StudentID)) { string value = rd["年級"].ToString(); }
StudentRecord_Ext exRec = null;
bool isNewExRec = false;
if (StudentRecord_ExtDict.ContainsKey(StudentID))
{
exRec = StudentRecord_ExtDict[StudentID];
}
else
{
exRec = new StudentRecord_Ext();
exRec.RefStudentID = StudentID;
isNewExRec = true;
}
if (rd.ContainsKey("英文別名"))
{
string value = rd["英文別名"].ToString();
if (exRec.Nickname != value)
{
sbLog.AppendLine(string.Format("英文別名由「{0}」改為「{1}」", exRec.Nickname, value));
}
exRec.Nickname = value;
}
if (rd.ContainsKey("居留證號"))
{
string value = rd["居留證號"].ToString();
if (exRec.PassportNumber != value)
{
sbLog.AppendLine(string.Format("居留證號由「{0}」改為「{1}」", exRec.PassportNumber, value));
}
exRec.PassportNumber = value;
}
if (rd.ContainsKey("GivenName"))
{
string value = rd["GivenName"].ToString();
if (exRec.GivenName != value)
{
sbLog.AppendLine(string.Format("GivenName由「{0}」改為「{1}」", exRec.GivenName, value));
}
exRec.GivenName = value;
}
if (rd.ContainsKey("MiddleName"))
{
string value = rd["MiddleName"].ToString();
if (exRec.MiddleName != value)
{
sbLog.AppendLine(string.Format("MiddleName由「{0}」改為「{1}」", exRec.MiddleName, value));
}
exRec.MiddleName = value;
}
if (rd.ContainsKey("FamilyName"))
{
string value = rd["FamilyName"].ToString();
if (exRec.FamilyName != value)
{
sbLog.AppendLine(string.Format("FamilyName由「{0}」改為「{1}」", exRec.FamilyName, value));
}
exRec.FamilyName = value;
}
if (rd.ContainsKey("入學日期"))
{
string value = rd["入學日期"].ToString();
string oldValue = "";
if (exRec.EntranceDate.HasValue)
{
oldValue = exRec.EntranceDate.Value.ToShortDateString();
}
exRec.EntranceDate = null;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("入學日期由「{0}」改為「{1}」", oldValue, value));
}
DateTime dt1;
if (DateTime.TryParse(value, out dt1))
{
exRec.EntranceDate = dt1;
}
}
if (rd.ContainsKey("畢業日期"))
{
string value = rd["畢業日期"].ToString();
string oldValue = "";
if (exRec.LeavingDate.HasValue)
{
oldValue = exRec.LeavingDate.Value.ToShortDateString();
}
if (oldValue != value)
{
sbLog.AppendLine(string.Format("畢業日期由「{0}」改為「{1}」", oldValue, value));
}
exRec.LeavingDate = null;
DateTime dt2;
if (DateTime.TryParse(value, out dt2))
{
exRec.LeavingDate = dt2;
}
}
if (isNewExRec)
{
insertStudentRecord_ExtList.Add(exRec);
}
else
{
updateStudentRecord_ExtList.Add(exRec);
}
if (ParentRecordDict.ContainsKey(StudentID))
{
if (rd.ContainsKey("父親姓名"))
{
string value = rd["父親姓名"].ToString();
string oldValue = ParentRecordDict[StudentID].Father.Name;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("父親姓名由「{0}」改為「{1}」", oldValue, value));
}
ParentRecordDict[StudentID].Father.Name = value;
}
if (rd.ContainsKey("父親學歷"))
{
string value = rd["父親學歷"].ToString();
string oldValue = ParentRecordDict[StudentID].Father.EducationDegree;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("父親學歷由「{0}」改為「{1}」", oldValue, value));
}
ParentRecordDict[StudentID].Father.EducationDegree = value;
}
if (rd.ContainsKey("父親職業"))
{
string value = rd["父親職業"].ToString();
string oldValue = ParentRecordDict[StudentID].Father.Job;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("父親職業由「{0}」改為「{1}」", oldValue, value));
}
ParentRecordDict[StudentID].Father.Job = value;
}
if (rd.ContainsKey("父親電話"))
{
string value = rd["父親電話"].ToString();
string oldValue = ParentRecordDict[StudentID].Father.Phone;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("父親電話由「{0}」改為「{1}」", oldValue, value));
}
ParentRecordDict[StudentID].Father.Phone = value;
}
if (rd.ContainsKey("父親電子郵件"))
{
string value = rd["父親電子郵件"].ToString();
string oldValue = ParentRecordDict[StudentID].Father.EMail;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("父親電子郵件由「{0}」改為「{1}」", oldValue, value));
}
ParentRecordDict[StudentID].Father.EMail = value;
}
if (rd.ContainsKey("母親姓名"))
{
string value = rd["母親姓名"].ToString();
string oldValue = ParentRecordDict[StudentID].Mother.Name;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("母親姓名由「{0}」改為「{1}」", oldValue, value));
}
ParentRecordDict[StudentID].Mother.Name = value;
}
if (rd.ContainsKey("母親學歷"))
{
string value = rd["母親學歷"].ToString();
string oldValue = ParentRecordDict[StudentID].Mother.EducationDegree;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("母親學歷由「{0}」改為「{1}」", oldValue, value));
}
ParentRecordDict[StudentID].Mother.EducationDegree = value;
}
if (rd.ContainsKey("母親職業"))
{
string value = rd["母親職業"].ToString();
string oldValue = ParentRecordDict[StudentID].Mother.Job;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("母親職業由「{0}」改為「{1}」", oldValue, value));
}
ParentRecordDict[StudentID].Mother.Job = value;
}
if (rd.ContainsKey("母親電話"))
{
string value = rd["母親電話"].ToString();
string oldValue = ParentRecordDict[StudentID].Mother.Phone;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("母親電話由「{0}」改為「{1}」", oldValue, value));
}
ParentRecordDict[StudentID].Mother.Phone = value;
}
if (rd.ContainsKey("母親電子郵件"))
{
string value = rd["母親電子郵件"].ToString();
string oldValue = ParentRecordDict[StudentID].Mother.EMail;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("母親電子郵件由「{0}」改為「{1}」", oldValue, value));
}
ParentRecordDict[StudentID].Mother.EMail = value;
}
if (rd.ContainsKey("監護人姓名"))
{
string value = rd["監護人姓名"].ToString();
string oldValue = ParentRecordDict[StudentID].Custodian.Name;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("監護人姓名由「{0}」改為「{1}」", oldValue, value));
}
ParentRecordDict[StudentID].Custodian.Name = value;
}
if (rd.ContainsKey("監護人電話"))
{
string value = rd["監護人電話"].ToString();
string oldValue = ParentRecordDict[StudentID].Custodian.Phone;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("監護人電話由「{0}」改為「{1}」", oldValue, value));
}
ParentRecordDict[StudentID].Custodian.Phone = value;
}
if (rd.ContainsKey("監護人電子郵件"))
{
string value = rd["監護人電子郵件"].ToString();
string oldValue = ParentRecordDict[StudentID].Custodian.EMail;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("監護人電子郵件由「{0}」改為「{1}」", oldValue, value));
}
ParentRecordDict[StudentID].Custodian.EMail = value;
}
updateParentRecList.Add(ParentRecordDict[StudentID]);
}
if (PhoneRecordDict.ContainsKey(StudentID))
{
if (rd.ContainsKey("戶籍電話"))
{
string value = rd["戶籍電話"].ToString();
string oldValue = PhoneRecordDict[StudentID].Permanent;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("戶籍電話由「{0}」改為「{1}」", oldValue, value));
}
PhoneRecordDict[StudentID].Permanent = value;
}
if (rd.ContainsKey("聯絡電話"))
{
string value = rd["聯絡電話"].ToString();
string oldValue = PhoneRecordDict[StudentID].Contact;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("聯絡電話由「{0}」改為「{1}」", oldValue, value));
}
PhoneRecordDict[StudentID].Contact = value;
}
if (rd.ContainsKey("行動電話"))
{
string value = rd["行動電話"].ToString();
string oldValue = PhoneRecordDict[StudentID].Cell;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("行動電話由「{0}」改為「{1}」", oldValue, value));
}
PhoneRecordDict[StudentID].Cell = value;
}
if (rd.ContainsKey("其它電話1"))
{
string value = rd["其它電話1"].ToString();
string oldValue = PhoneRecordDict[StudentID].Phone1;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("其它電話1由「{0}」改為「{1}」", oldValue, value));
}
PhoneRecordDict[StudentID].Phone1 = value;
}
updatePhoneList.Add(PhoneRecordDict[StudentID]);
}
if (AddressRecordDict.ContainsKey(StudentID))
{
if (rd.ContainsKey("戶籍:郵遞區號"))
{
string value = rd["戶籍:郵遞區號"].ToString();
string oldValue = AddressRecordDict[StudentID].Permanent.ZipCode;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("戶籍:郵遞區號由「{0}」改為「{1}」", oldValue, value));
}
AddressRecordDict[StudentID].Permanent.ZipCode = value;
}
if (rd.ContainsKey("戶籍:縣市"))
{
string value = rd["戶籍:縣市"].ToString();
string oldValue = AddressRecordDict[StudentID].Permanent.County;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("戶籍:縣市由「{0}」改為「{1}」", oldValue, value));
}
AddressRecordDict[StudentID].Permanent.County = value;
}
if (rd.ContainsKey("戶籍:鄉鎮市區"))
{
string value = rd["戶籍:鄉鎮市區"].ToString();
string oldValue = AddressRecordDict[StudentID].Permanent.Town;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("戶籍:鄉鎮市區由「{0}」改為「{1}」", oldValue, value));
}
AddressRecordDict[StudentID].Permanent.Town = value;
}
if (rd.ContainsKey("戶籍:村里"))
{
string value = rd["戶籍:村里"].ToString();
string oldValue = AddressRecordDict[StudentID].Permanent.District;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("戶籍:村里由「{0}」改為「{1}」", oldValue, value));
}
AddressRecordDict[StudentID].Permanent.District = value;
}
if (rd.ContainsKey("戶籍:鄰"))
{
string value = rd["戶籍:鄰"].ToString();
string oldValue = AddressRecordDict[StudentID].Permanent.Area;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("戶籍:鄰由「{0}」改為「{1}」", oldValue, value));
}
AddressRecordDict[StudentID].Permanent.Area = value;
}
if (rd.ContainsKey("戶籍:其他"))
{
string value = rd["戶籍:其他"].ToString();
string oldValue = AddressRecordDict[StudentID].Permanent.Detail;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("戶籍:其他由「{0}」改為「{1}」", oldValue, value));
}
AddressRecordDict[StudentID].Permanent.Detail = value;
}
if (rd.ContainsKey("聯絡:郵遞區號"))
{
string value = rd["聯絡:郵遞區號"].ToString();
string oldValue = AddressRecordDict[StudentID].Mailing.ZipCode;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("聯絡:郵遞區號由「{0}」改為「{1}」", oldValue, value));
}
AddressRecordDict[StudentID].Mailing.ZipCode = value;
}
if (rd.ContainsKey("聯絡:縣市"))
{
string value = rd["聯絡:縣市"].ToString();
string oldValue = AddressRecordDict[StudentID].Mailing.County;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("聯絡:縣市由「{0}」改為「{1}」", oldValue, value));
}
AddressRecordDict[StudentID].Mailing.County = value;
}
if (rd.ContainsKey("聯絡:鄉鎮市區"))
{
string value = rd["聯絡:鄉鎮市區"].ToString();
string oldValue = AddressRecordDict[StudentID].Mailing.Town;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("聯絡:鄉鎮市區由「{0}」改為「{1}」", oldValue, value));
}
AddressRecordDict[StudentID].Mailing.Town = value;
}
if (rd.ContainsKey("聯絡:村里"))
{
string value = rd["聯絡:村里"].ToString();
string oldValue = AddressRecordDict[StudentID].Mailing.District;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("聯絡:村里由「{0}」改為「{1}」", oldValue, value));
}
AddressRecordDict[StudentID].Mailing.District = value;
}
if (rd.ContainsKey("聯絡:鄰"))
{
string value = rd["聯絡:鄰"].ToString();
string oldValue = AddressRecordDict[StudentID].Mailing.Area;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("聯絡:鄰由「{0}」改為「{1}」", oldValue, value));
}
AddressRecordDict[StudentID].Mailing.Area = value;
}
if (rd.ContainsKey("聯絡:其他"))
{
string value = rd["聯絡:其他"].ToString();
string oldValue = AddressRecordDict[StudentID].Mailing.Detail;
if (oldValue != value)
{
sbLog.AppendLine(string.Format("聯絡:其他由「{0}」改為「{1}」", oldValue, value));
}
AddressRecordDict[StudentID].Mailing.Detail = value;
}
sbLog.AppendLine();
updateAddressList.Add(AddressRecordDict[StudentID]);
}
}
// 處理學生資料
foreach (string key in StudentRecordDict.Keys)
{
updateStudentRecList.Add(StudentRecordDict[key]);
}
if (updateStudentRecList.Count > 0)
{
JHStudent.Update(updateStudentRecList);
}
if (updateParentRecList.Count > 0)
{
JHParent.Update(updateParentRecList);
}
if (updatePhoneList.Count > 0)
{
JHPhone.Update(updatePhoneList);
}
if (updateAddressList.Count > 0)
{
JHAddress.Update(updateAddressList);
}
if (insertStudentRecord_ExtList.Count > 0)
{
insertStudentRecord_ExtList.SaveAll();
}
if (updateStudentRecord_ExtList.Count > 0)
{
updateStudentRecord_ExtList.SaveAll();
}
FISCA.LogAgent.ApplicationLog.Log("匯入學生基本資料(New)", "匯入", sbLog.ToString());
// 同步
JHSchool.Student.Instance.SyncAllBackground();
JHSchool.Data.JHStudent.RemoveAll();
JHSchool.Data.JHStudent.SelectAll();
}
void wizard_ImportPackage(object sender, SmartSchool.API.PlugIn.Import.ImportPackageEventArgs e)
{
//根據學生編號、學年度、學期組成主鍵
List <string> keyList = new List <string>();
Dictionary <string, int> schoolYearMapping = new Dictionary <string, int>();
Dictionary <string, int> semesterMapping = new Dictionary <string, int>();
Dictionary <string, string> studentIDMapping = new Dictionary <string, string>();
Dictionary <string, List <RowData> > rowsMapping = new Dictionary <string, List <RowData> >();
//一個學生只會有一筆學期歷程
Dictionary <string, JHSemesterHistoryRecord> studentSemesterHistory = new Dictionary <string, JHSemesterHistoryRecord>();
//掃描每行資料，定出資料的PrimaryKey，並且將PrimaryKey對應到的資料寫成Dictionary
foreach (RowData Row in e.Items)
{
int schoolYear = int.Parse(Row["學年度"]);
int semester = int.Parse(Row["學期"]);
string studentID = Row.ID;
string key = schoolYear + "^_^" + semester + "^_^" + studentID;
if (!keyList.Contains(key))
{
keyList.Add(key);
schoolYearMapping.Add(key, schoolYear);
semesterMapping.Add(key, semester);
studentIDMapping.Add(key, studentID);
rowsMapping.Add(key, new List <RowData>());
}
rowsMapping[key].Add(Row);
}
//一次取得學生學期歷程
List <JHSemesterHistoryRecord> records = JHSemesterHistory.SelectByStudentIDs(studentIDMapping.Values.Distinct());
#region 將學生現有學期歷程做快取
foreach (JHSemesterHistoryRecord var in records)
{
studentSemesterHistory.Add(var.RefStudentID, var);
}
#endregion
List <JHSemesterHistoryRecord> UpdateRecords = new List <JHSemesterHistoryRecord>();
foreach (string key in keyList)
{
JHSemesterHistoryRecord record = studentSemesterHistory[studentIDMapping[key]];
List <RowData> Rows = rowsMapping[key];
if (record != null)
{
for (int i = 0; i < Rows.Count; i++)
{
string StudentID = Rows[i].ID;
string SchoolYear = Rows[i]["學年度"];
string Semester = Rows[i]["學期"];
string GradeYear = Rows[i]["年級"];
string ClassName = Rows[i].ContainsKey("當時班級")?Rows[i]["當時班級"]:string.Empty;
string SeatNo = Rows[i].ContainsKey("當時座號")?Rows[i]["當時座號"]:string.Empty;
string TeacherName = Rows[i].ContainsKey("當時班導師姓名")?Rows[i]["當時班導師姓名"]:string.Empty;
string SchoolDayCount = Rows[i].ContainsKey("上課天數")?Rows[i]["上課天數"]:string.Empty;
List <K12.Data.SemesterHistoryItem> Items = record.SemesterHistoryItems.Where(x => x.RefStudentID == StudentID && x.SchoolYear.ToString() == SchoolYear && x.Semester.ToString() == Semester).ToList();
if (Items.Count > 0)
{
Items[0].GradeYear = K12.Data.Int.Parse(GradeYear);
if (Rows[i].ContainsKey("當時班級"))
{
Items[0].ClassName = ClassName;
}
if (Rows[i].ContainsKey("當時座號"))
{
Items[0].SeatNo = K12.Data.Int.ParseAllowNull(SeatNo);
}
if (Rows[i].ContainsKey("當時班導師姓名"))
{
Items[0].Teacher = TeacherName;
}
if (Rows[i].ContainsKey("上課天數"))
{
Items[0].SchoolDayCount = K12.Data.Int.ParseAllowNull(SchoolDayCount);
}
}
else
{
K12.Data.SemesterHistoryItem Item = new K12.Data.SemesterHistoryItem();
Item.SchoolYear = K12.Data.Int.Parse(SchoolYear);
Item.Semester = K12.Data.Int.Parse(Semester);
Item.GradeYear = K12.Data.Int.Parse(GradeYear);
Item.ClassName = ClassName;
Item.SeatNo = K12.Data.Int.ParseAllowNull(SeatNo);
Item.Teacher = TeacherName;
Item.SchoolDayCount = K12.Data.Int.ParseAllowNull(SchoolDayCount);
record.SemesterHistoryItems.Add(Item);
}
}
UpdateRecords.Add(record);
}
else
{
JHSemesterHistoryRecord newrecord = new JHSemesterHistoryRecord();
newrecord.RefStudentID = Rows[0].ID;
List <K12.Data.SemesterHistoryItem> Items = new List <K12.Data.SemesterHistoryItem>();
for (int i = 0; i < Rows.Count; i++)
{
string SchoolYear = Rows[i]["學年度"];
string Semester = Rows[i]["學期"];
string GradeYear = Rows[i].ContainsKey("年級") ? Rows[i]["年級"] : string.Empty;
string ClassName = Rows[i].ContainsKey("當時班級") ? Rows[i]["當時班級"] : string.Empty;
string SeatNo = Rows[i].ContainsKey("當時座號") ? Rows[i]["當時座號"] : string.Empty;
string TeacherName = Rows[i].ContainsKey("當時班導師姓名") ? Rows[i]["當時班導師姓名"] : string.Empty;
string SchoolDayCount = Rows[i].ContainsKey("上課天數") ? Rows[i]["上課天數"] : string.Empty;
K12.Data.SemesterHistoryItem Item = new K12.Data.SemesterHistoryItem();
Item.SchoolYear = K12.Data.Int.Parse(SchoolYear);
Item.Semester = K12.Data.Int.Parse(Semester);
Item.GradeYear = K12.Data.Int.Parse(GradeYear);
Item.ClassName = ClassName;
Item.SeatNo = K12.Data.Int.ParseAllowNull(SeatNo);
Item.Teacher = TeacherName;
Item.SchoolDayCount = K12.Data.Int.ParseAllowNull(SchoolDayCount);
Items.Add(Item);
}
newrecord.SemesterHistoryItems = Items;
UpdateRecords.Add(newrecord);
}
}
if (UpdateRecords.Count > 0)
{
JHSemesterHistory.Update(UpdateRecords);
}
}
void wizard_ImportPackage(object sender, SmartSchool.API.PlugIn.Import.ImportPackageEventArgs e)
{
//Log
StringBuilder LogSb = new StringBuilder();
List <ActiveRecord> InsertRecords = new List <ActiveRecord>();
List <ActiveRecord> UpdateRecords = new List <ActiveRecord>();
//取得學號清單
List <string> StudentNumList = GetStudentNumber(e.Items);
//取得狀態為1的學生系統編號
List <string> StudentIDList = GetStudentIDList(StudentNumList);
//取得學生基本資料對照 學號:學生Record
Dictionary <string, StudentRecord> StudentNumberDic = GetStudentNumberDic(StudentIDList);
//取得學生基本資料對照 學號:學生Record
Dictionary <string, StudentRecord> StudentIDDic = GetStudentIDDic(StudentIDList);
//取得學生延申資料 學號:學生延申資料
Dictionary <string, StudentRecord_Ext> StudentExtDic = GetStudExt(StudentIDList, StudentIDDic);
foreach (RowData Row in e.Items)
{
string StudentNumber = "" + Row["學號"];
//必須有這個學生
if (StudentNumberDic.ContainsKey(StudentNumber))
{
StudentRecord StudR = StudentNumberDic[StudentNumber];
string ClassName = StudR.RefClassID != "" ? StudR.Class.Name : "";
string SeatNo = StudR.SeatNo.HasValue ? StudR.SeatNo.Value.ToString() : "";
if (StudentExtDic.ContainsKey(StudentNumber))
{
StudentRecord_Ext record = StudentExtDic[StudentNumber];
DateTime Entrance = new DateTime();
if (Row.ContainsKey("入學日期"))
{
DateTime.TryParse("" + Row["入學日期"], out Entrance);
}
else
{
Entrance = record.EntranceDate.HasValue ? record.EntranceDate.Value : new DateTime();
}
DateTime Leaving = new DateTime();
if (Row.ContainsKey("畢業日期"))
{
DateTime.TryParse("" + Row["畢業日期"], out Leaving);
}
else
{
Leaving = record.EntranceDate.HasValue ? record.EntranceDate.Value : new DateTime();
}
string Nickname = "";
if (Row.ContainsKey("英文別名"))
{
Nickname = "" + Row["英文別名"];
}
else
{
Nickname = record.Nickname;
}
string PassportNumber = "";
if (Row.ContainsKey("居留證號"))
{
PassportNumber = "" + Row["居留證號"];
}
else
{
PassportNumber = record.PassportNumber;
}
LogSb.AppendLine("修改資料：");
LogSb.AppendLine(string.Format("班級「{0}」座號「{1}」學生「{2}」", ClassName, SeatNo, StudR.Name));
LogSb.AppendLine(string.Format("英文別名由「{0}」改為「{1}」", record.Nickname, Nickname));
LogSb.AppendLine(string.Format("居留證號由「{0}」改為「{1}」", record.PassportNumber, PassportNumber));
string entrance = record.EntranceDate.HasValue ? record.EntranceDate.Value.ToShortDateString() : "";
LogSb.AppendLine(string.Format("入學日期由「{0}」改為「{1}」", entrance, Entrance.ToShortDateString() != "0001/1/1" ? Entrance.ToShortDateString() : ""));
string leaving = record.LeavingDate.HasValue ? record.LeavingDate.Value.ToShortDateString() : "";
LogSb.AppendLine(string.Format("畢業日期由「{0}」改為「{1}」", leaving, Leaving.ToShortDateString() != "0001/1/1" ? Leaving.ToShortDateString() : ""));
LogSb.AppendLine();
record.Nickname = Nickname;
record.PassportNumber = PassportNumber;
if (Entrance.ToShortDateString() != "0001/1/1")
{
record.EntranceDate = Entrance;
}
else
{
record.EntranceDate = null;
}
if (Leaving.ToShortDateString() != "0001/1/1")
{
record.LeavingDate = Leaving;
}
else
{
record.LeavingDate = null;
}
UpdateRecords.Add(record);
}
else
{
DateTime Entrance = new DateTime();
if (Row.ContainsKey("入學日期"))
{
DateTime.TryParse("" + Row["入學日期"], out Entrance);
}
DateTime Leaving = new DateTime();
if (Row.ContainsKey("畢業日期"))
{
DateTime.TryParse("" + Row["畢業日期"], out Leaving);
}
string Nickname = Row.ContainsKey("英文別名") ? "" + Row["英文別名"] : "";
string PassportNumber = Row.ContainsKey("居留證號") ? "" + Row["居留證號"] : "";
//Log
LogSb.AppendLine("新增資料：");
LogSb.AppendLine(string.Format("班級「{0}」座號「{1}」學生「{2}」", ClassName, SeatNo, StudR.Name));
LogSb.AppendLine(string.Format("英文別名「{0}」", Nickname));
LogSb.AppendLine(string.Format("居留證號「{0}」", PassportNumber));
LogSb.AppendLine(string.Format("入學日期「{0}」", Entrance.ToShortDateString() != "0001/1/1" ? Entrance.ToShortDateString() : ""));
LogSb.AppendLine(string.Format("畢業日期「{0}」", Leaving.ToShortDateString() != "0001/1/1" ? Leaving.ToShortDateString() : ""));
LogSb.AppendLine();
//新增
//新增資料
StudentRecord_Ext record = new StudentRecord_Ext();
record.RefStudentID = StudentNumberDic[StudentNumber].ID;
record.Nickname = Nickname;
record.PassportNumber = PassportNumber;
if (Entrance.ToShortDateString() != "0001/1/1")
{
record.EntranceDate = Entrance;
}
else
{
record.EntranceDate = null;
}
if (Leaving.ToShortDateString() != "0001/1/1")
{
record.LeavingDate = Leaving;
}
else
{
record.LeavingDate = null;
}
InsertRecords.Add(record);
}
}
}
if (InsertRecords.Count > 0)
{
tool._A.InsertValues(InsertRecords);
}
if (UpdateRecords.Count > 0)
{
tool._A.UpdateValues(UpdateRecords);
}
FISCA.LogAgent.ApplicationLog.Log("匯入學生基本資料(雙語部)", "匯入", LogSb.ToString());
eh(null, EventArgs.Empty);
}
