private void Delete(object item)
 {
     try
     {
         List <JHUpdateRecordRecord> DelPackage = (List <JHUpdateRecordRecord>)item;
         JHUpdateRecord.Delete(DelPackage);
     }
     catch (Exception ex) { FISCA.Presentation.Controls.MsgBox.Show("刪除資料發生異常."); }
 }
Exemple #2
0
        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);
                }
            }
        }
Exemple #3
0
        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();
        }