private void Delete(object item) { try { List <JHUpdateRecordRecord> DelPackage = (List <JHUpdateRecordRecord>)item; JHUpdateRecord.Delete(DelPackage); } catch (Exception ex) { FISCA.Presentation.Controls.MsgBox.Show("刪除資料發生異常."); } }
public void ExecuteAutoCorrect(IEnumerable <string> EntityIDs) { List <JHUpdateRecordRecord> AutoCorrectRecords = new List <JHUpdateRecordRecord>(); if (K12.Data.Utility.Utility.IsNullOrEmpty(EntityIDs)) { AutoCorrectRecords = CorrectableUpdateRecords; } else { AutoCorrectRecords = CorrectableUpdateRecords.Where(x => EntityIDs.Contains(x.StudentID)).ToList(); } if (MsgBox.Show("自動修正將依照檢查結果建議值進行修正總共" + AutoCorrectRecords.Count + "筆,強烈建議您務必將檢查結果匯出備份,是否進行自動修正?", "您是否要進行自動修正?", System.Windows.Forms.MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes) { try { StringBuilder strBuilder = new StringBuilder(); strBuilder.AppendLine("學號,狀態,學年度,學期,異動日期,入學年月,備註,入學資格-畢業國小名稱,異動班級,異動姓名,異動身分證號,異動地址,異動學號,異動性別,異動生日,核准日期,核准文號"); for (int i = 0; i < AutoCorrectRecords.Count; i++) { string StudentID = AutoCorrectRecords[i].StudentID; List <string> LogValues = new List <string>(); LogValues.Add(StudentRecords[StudentID].StudentNumber); LogValues.Add(StudentRecords[StudentID].StatusStr); LogValues.Add(AutoCorrectRecords[i].StudentNumber); LogValues.Add(K12.Data.Int.GetString(AutoCorrectRecords[i].SchoolYear)); LogValues.Add(K12.Data.Int.GetString(AutoCorrectRecords[i].Semester)); LogValues.Add(AutoCorrectRecords[i].UpdateDate); LogValues.Add(AutoCorrectRecords[i].EnrollmentSchoolYear); LogValues.Add(AutoCorrectRecords[i].Comment); LogValues.Add(AutoCorrectRecords[i].GraduateSchool); LogValues.Add(AutoCorrectRecords[i].OriginClassName); LogValues.Add(AutoCorrectRecords[i].StudentName); LogValues.Add(AutoCorrectRecords[i].IDNumber); LogValues.Add(AutoCorrectRecords[i].OriginAddress); LogValues.Add(AutoCorrectRecords[i].StudentNumber); LogValues.Add(AutoCorrectRecords[i].Gender); LogValues.Add(AutoCorrectRecords[i].Birthdate); LogValues.Add(AutoCorrectRecords[i].ADDate); LogValues.Add(AutoCorrectRecords[i].ADNumber); strBuilder.AppendLine(string.Join(",", LogValues.ToArray())); } JHUpdateRecord.Delete(AutoCorrectRecords); AutoCorrectRecords.ForEach(x => CorrectableUpdateRecords.Remove(x)); FISCA.LogAgent.ApplicationLog.Log("資料合理性檢查.轉入生包含『新生異動記錄』檢查", "將轉入生『新生異動記錄』刪除", strBuilder.ToString()); MsgBox.Show("已自動修正完成,您可再次執行檢查確認!"); } catch (Exception e) { SmartSchool.ErrorReporting.ReportingService.ReportException(e); MsgBox.Show(e.Message); } } }
private void btnNext_Click(object sender, EventArgs e) { _StudUpdateRecordEntity.SetUpdateDate(dtUpdateDate.Text); _StudUpdateRecordEntity.SetComment(txtComment.Text); _StudUpdateRecordEntity.SetClassName(txtClass.Text); _StudUpdateRecordEntity.SetName(txtName.Text); _StudUpdateRecordEntity.SetIDNumber(txtIDNumber.Text); _StudUpdateRecordEntity.SetStudentNumber(txtStudentNumber.Text); _StudUpdateRecordEntity.SetGender(cboGender.Text); _StudUpdateRecordEntity.SetBirthday(dtBirthday.Text); _StudUpdateRecordEntity.SetAddress(txtAddress.Text); _StudUpdateRecordEntity.SetImportExportSchool(txtExportSchool.Text); _StudUpdateRecordEntity.SetLastADDate(dtLastADDate.Text); _StudUpdateRecordEntity.SetLastADNumber(txtLastADNumber.Text); _StudUpdateRecordEntity.SetADDate(dtADDate.Text); _StudUpdateRecordEntity.SetADNumber(txtADNumber.Text); _StudUpdateRecordEntity.SetUpdateDescription(cboUpdateDescription.Text); int intSchoolYear, intSemester; int.TryParse(JHSchool.School.DefaultSchoolYear, out intSchoolYear); int.TryParse(JHSchool.School.DefaultSemester, out intSemester); _StudUpdateRecordEntity.SchoolYear = intSchoolYear; _StudUpdateRecordEntity.Semester = intSemester; _StudUpdateRecordEntity.SetUpdateCode("3"); // 檢查相同學年度學期異動日期 List <JHUpdateRecordRecord> StudUpRecList = JHUpdateRecord.SelectByStudentID(_StudUpdateRecordEntity.StudentID); foreach (JHUpdateRecordRecord urr in StudUpRecList) { // 轉入 if (urr.UpdateCode == "3" && urr.SchoolYear == intSchoolYear && urr.Semester == intSemester) { DateTime dtA, dtB; DateTime.TryParse(urr.UpdateDate, out dtA); DateTime.TryParse(dtUpdateDate.Text, out dtB); // 相同異動日期 if (dtA == dtB) { if (FISCA.Presentation.Controls.MsgBox.Show("已有一筆相同學年度、學期、異動日期的轉入異動,請問是否覆蓋?", MessageBoxButtons.YesNo) == DialogResult.Yes) { JHUpdateRecord.Delete(urr); _StudUpdateRecordEntity.UID = string.Empty; } else { return; } } } } // Save DAL.DALTransfer2.SetStudUpdateRecordEntity(_StudUpdateRecordEntity); // log JHSchool.PermRecLogProcess prlp = new JHSchool.PermRecLogProcess(); prlp.SaveLog("學生.轉入異動", "新增轉入異動", "新增轉入異動資料,姓名:" + _StudUpdateRecordEntity.GetName() + ",學號:" + _StudUpdateRecordEntity.GetStudentNumber()); this.Close(); }