public Report(Config config)
{
_config = config;
_rc = new ReportConfiguration(Global.ReportName);
// 設定列印文字評語不出現
_rc.SetBoolean("列印文字評語", false);
_rc.Save();
_effortMapper = new EffortMapper();
_doc = new Document();
_doc.Sections.Clear();
if (_rc.Template == null)
{
_rc.Template = new ReportTemplate(Properties.Resources.評量成績通知單, TemplateType.Word);
}
//_template = _rc.Template.ToDocument();
_template = new Document(new MemoryStream(_rc.Template.ToBinary()));
_rowCount = GetRowCount(_template);
_worker = new BackgroundWorker();
_worker.DoWork += new DoWorkEventHandler(Worker_DoWork);
_worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(Worker_RunWorkerCompleted);
_worker.ProgressChanged += new ProgressChangedEventHandler(Worker_ProgressChanged);
_worker.WorkerReportsProgress = true;
}
public ImportStartupForm()
{
InitializeComponent();
InitializeSemesters();
_effortMapper = new EffortMapper();
// 載入預設儲存值
LoadConfigData();
_worker = new BackgroundWorker();
_worker.WorkerReportsProgress = true;
_worker.ProgressChanged += delegate(object sender, ProgressChangedEventArgs e)
{
lblMessage.Text = "" + e.UserState;
};
_worker.DoWork += delegate(object sender, DoWorkEventArgs e)
{
#region Worker DoWork
_worker.ReportProgress(0, "檢查讀卡文字格式…");
#region 檢查文字檔
ValidateTextFiles vtf = new ValidateTextFiles(intStudentNumberLenght.Value);
ValidateTextResult vtResult = vtf.CheckFormat(_files);
if (vtResult.Error)
{
e.Result = vtResult;
return;
}
#endregion
//文字檔轉 RawData
RawDataCollection rdCollection = new RawDataCollection();
rdCollection.ConvertFromFiles(_files);
//RawData 轉 DataRecord
DataRecordCollection drCollection = new DataRecordCollection();
drCollection.ConvertFromRawData(rdCollection);
_rawDataValidator = new DataValidator <RawData>();
_dataRecordValidator = new DataValidator <DataRecord>();
#region 取得驗證需要的資料
JHCourse.RemoveAll();
_worker.ReportProgress(0, "取得學生資料…");
List <JHStudentRecord> studentList = GetInSchoolStudents();
List <string> s_ids = new List <string>();
Dictionary <string, List <string> > studentNumberToStudentIDs = new Dictionary <string, List <string> >();
foreach (JHStudentRecord student in studentList)
{
string sn = SCValidatorCreator.GetStudentNumberFormat(student.StudentNumber);
if (!studentNumberToStudentIDs.ContainsKey(sn))
{
studentNumberToStudentIDs.Add(sn, new List <string>());
}
studentNumberToStudentIDs[sn].Add(student.ID);
}
foreach (var dr in drCollection)
{
if (studentNumberToStudentIDs.ContainsKey(dr.StudentNumber))
{
s_ids.AddRange(studentNumberToStudentIDs[dr.StudentNumber]);
}
}
studentList.Clear();
_worker.ReportProgress(0, "取得課程資料…");
List <JHCourseRecord> courseList = JHCourse.SelectBySchoolYearAndSemester(SchoolYear, Semester);
List <JHAEIncludeRecord> aeList = JHAEInclude.SelectAll();
//List<JHSCAttendRecord> scaList = JHSCAttend.SelectAll();
var c_ids = from course in courseList select course.ID;
_worker.ReportProgress(0, "取得修課資料…");
//List<JHSCAttendRecord> scaList2 = JHSCAttend.SelectByStudentIDAndCourseID(s_ids, c_ids.ToList<string>());
List <JHSCAttendRecord> scaList = new List <JHSCAttendRecord>();
FunctionSpliter <string, JHSCAttendRecord> spliter = new FunctionSpliter <string, JHSCAttendRecord>(300, 3);
spliter.Function = delegate(List <string> part)
{
return(JHSCAttend.Select(part, c_ids.ToList <string>(), null, SchoolYear.ToString(), Semester.ToString()));
};
scaList = spliter.Execute(s_ids);
_worker.ReportProgress(0, "取得試別資料…");
List <JHExamRecord> examList = JHExam.SelectAll();
#endregion
#region 註冊驗證
_worker.ReportProgress(0, "載入驗證規則…");
_rawDataValidator.Register(new SubjectCodeValidator());
_rawDataValidator.Register(new ClassCodeValidator());
_rawDataValidator.Register(new ExamCodeValidator());
SCValidatorCreator scCreator = new SCValidatorCreator(JHStudent.SelectByIDs(s_ids), courseList, scaList);
_dataRecordValidator.Register(scCreator.CreateStudentValidator());
_dataRecordValidator.Register(new ExamValidator(examList));
_dataRecordValidator.Register(scCreator.CreateSCAttendValidator());
_dataRecordValidator.Register(new CourseExamValidator(scCreator.StudentCourseInfo, aeList, examList));
#endregion
#region 進行驗證
_worker.ReportProgress(0, "進行驗證中…");
List <string> msgList = new List <string>();
foreach (RawData rawData in rdCollection)
{
List <string> msgs = _rawDataValidator.Validate(rawData);
msgList.AddRange(msgs);
}
if (msgList.Count > 0)
{
e.Result = msgList;
return;
}
foreach (DataRecord dataRecord in drCollection)
{
List <string> msgs = _dataRecordValidator.Validate(dataRecord);
msgList.AddRange(msgs);
}
if (msgList.Count > 0)
{
e.Result = msgList;
return;
}
#endregion
#region 取得學生的評量成績
_deleteScoreList.Clear();
_addScoreList.Clear();
//var student_ids = from student in scCreator.StudentNumberDictionary.Values select student.ID;
//List<string> course_ids = scCreator.AttendCourseIDs;
var scaIDs = from sca in scaList select sca.ID;
Dictionary <string, JHSCETakeRecord> sceList = new Dictionary <string, JHSCETakeRecord>();
FunctionSpliter <string, JHSCETakeRecord> spliterSCE = new FunctionSpliter <string, JHSCETakeRecord>(300, 3);
spliterSCE.Function = delegate(List <string> part)
{
return(JHSCETake.Select(null, null, null, null, part));
};
foreach (JHSCETakeRecord sce in spliterSCE.Execute(scaIDs.ToList()))
{
string key = GetCombineKey(sce.RefStudentID, sce.RefCourseID, sce.RefExamID);
if (!sceList.ContainsKey(key))
{
sceList.Add(key, sce);
}
}
Dictionary <string, JHExamRecord> examTable = new Dictionary <string, JHExamRecord>();
Dictionary <string, JHSCAttendRecord> scaTable = new Dictionary <string, JHSCAttendRecord>();
foreach (JHExamRecord exam in examList)
{
if (!examTable.ContainsKey(exam.Name))
{
examTable.Add(exam.Name, exam);
}
}
foreach (JHSCAttendRecord sca in scaList)
{
string key = GetCombineKey(sca.RefStudentID, sca.RefCourseID);
if (!scaTable.ContainsKey(key))
{
scaTable.Add(key, sca);
}
}
foreach (DataRecord dr in drCollection)
{
JHStudentRecord student = student = scCreator.StudentNumberDictionary[dr.StudentNumber];
JHExamRecord exam = examTable[dr.Exam];
List <JHCourseRecord> courses = new List <JHCourseRecord>();
foreach (JHCourseRecord course in scCreator.StudentCourseInfo.GetCourses(dr.StudentNumber))
{
if (dr.Subjects.Contains(course.Subject))
{
courses.Add(course);
}
}
foreach (JHCourseRecord course in courses)
{
string key = GetCombineKey(student.ID, course.ID, exam.ID);
if (sceList.ContainsKey(key))
{
_deleteScoreList.Add(sceList[key]);
}
JHSCETakeRecord jh = new JHSCETakeRecord();
KH.JHSCETakeRecord sceNew = new KH.JHSCETakeRecord(jh);
sceNew.RefCourseID = course.ID;
sceNew.RefExamID = exam.ID;
sceNew.RefSCAttendID = scaTable[GetCombineKey(student.ID, course.ID)].ID;
sceNew.RefStudentID = student.ID;
sceNew.Score = dr.Score;
sceNew.Effort = _effortMapper.GetCodeByScore(dr.Score);
_addScoreList.Add(sceNew.AsJHSCETakeRecord());
}
}
#endregion
e.Result = null;
#endregion
};
_worker.RunWorkerCompleted += delegate(object sender, RunWorkerCompletedEventArgs e)
{
#region Worker Completed
if (e.Error == null && e.Result == null)
{
if (!_upload.IsBusy)
{
//如果學生身上已有成績，則提醒使用者
if (_deleteScoreList.Count > 0)
{
_warn.RunWorkerAsync();
}
else
{
lblMessage.Text = "成績上傳中…";
FISCA.Presentation.MotherForm.SetStatusBarMessage("成績上傳中…", 0);
counter = 0;
_upload.RunWorkerAsync();
}
}
}
else
{
ControlEnable = true;
if (e.Error != null)
{
MsgBox.Show("匯入失敗。" + e.Error.Message);
SmartSchool.ErrorReporting.ReportingService.ReportException(e.Error);
}
else if (e.Result != null && e.Result is ValidateTextResult)
{
ValidateTextResult result = e.Result as ValidateTextResult;
ValidationErrorViewer viewer = new ValidationErrorViewer();
viewer.SetTextFileError(result.LineIndexes, result.ErrorFormatLineIndexes, result.DuplicateLineIndexes);
viewer.ShowDialog();
}
else if (e.Result != null && e.Result is List <string> )
{
ValidationErrorViewer viewer = new ValidationErrorViewer();
viewer.SetErrorLines(e.Result as List <string>);
viewer.ShowDialog();
}
}
#endregion
};
_upload = new BackgroundWorker();
_upload.WorkerReportsProgress = true;
_upload.ProgressChanged += new ProgressChangedEventHandler(_upload_ProgressChanged);
//_upload.ProgressChanged += delegate(object sender, ProgressChangedEventArgs e)
//{
// counter += double.Parse("" + e.ProgressPercentage);
// FISCA.Presentation.MotherForm.SetStatusBarMessage("成績上傳中…", (int)(counter * 100f / (double)_addScoreList.Count));
//};
_upload.DoWork += new DoWorkEventHandler(_upload_DoWork);
//_upload.DoWork += delegate
//{
//#region Upload DoWork
//Framework.MultiThreadWorker<JHSCETakeRecord> multi = new Framework.MultiThreadWorker<JHSCETakeRecord>();
//multi.MaxThreads = 3;
//multi.PackageSize = 500;
//multi.PackageWorker += delegate(object sender, Framework.PackageWorkEventArgs<JHSCETakeRecord> e)
//{
// JHSCETake.Delete(e.List);
//};
//multi.Run(_deleteScoreList);
//Framework.MultiThreadWorker<JHSCETakeRecord> multi2 = new Framework.MultiThreadWorker<JHSCETakeRecord>();
//multi2.MaxThreads = 3;
//multi2.PackageSize = 500;
//multi2.PackageWorker += delegate(object sender, Framework.PackageWorkEventArgs<JHSCETakeRecord> e)
//{
// JHSCETake.Insert(e.List);
// lock (_upload)
// {
// _upload.ReportProgress(e.List.Count);
// }
//};
//multi2.Run(_addScoreList);
//#endregion
//};
_upload.RunWorkerCompleted += new RunWorkerCompletedEventHandler(_upload_RunWorkerCompleted);
_warn = new BackgroundWorker();
_warn.WorkerReportsProgress = true;
_warn.DoWork += delegate(object sender, DoWorkEventArgs e)
{
_warn.ReportProgress(0, "產生警告訊息...");
Dictionary <string, string> examDict = new Dictionary <string, string>();
foreach (JHExamRecord exam in JHExam.SelectAll())
{
if (!examDict.ContainsKey(exam.ID))
{
examDict.Add(exam.ID, exam.Name);
}
}
WarningForm form = new WarningForm();
int count = 0;
foreach (JHSCETakeRecord sce in _deleteScoreList)
{
// 當成績資料是空值跳過
if (sce.Score.HasValue == false && sce.Effort.HasValue == false && string.IsNullOrEmpty(sce.Text))
{
continue;
}
count++;
JHStudentRecord student = JHStudent.SelectByID(sce.RefStudentID);
JHCourseRecord course = JHCourse.SelectByID(sce.RefCourseID);
string exam = (examDict.ContainsKey(sce.RefExamID) ? examDict[sce.RefExamID] : "<未知的試別>");
string s = "";
if (student.Class != null)
{
s += student.Class.Name;
}
if (!string.IsNullOrEmpty("" + student.SeatNo))
{
s += " " + student.SeatNo + "號";
}
if (!string.IsNullOrEmpty(student.StudentNumber))
{
s += " (" + student.StudentNumber + ")";
}
s += " " + student.Name;
form.Add(student.ID, s, string.Format("學生在「{0}」課程「{1}」中已有成績。", course.Name, exam));
_warn.ReportProgress((int)(count * 100 / _deleteScoreList.Count), "產生警告訊息...");
}
e.Result = form;
};
_warn.RunWorkerCompleted += delegate(object sender, RunWorkerCompletedEventArgs e)
{
WarningForm form = e.Result as WarningForm;
if (form.ShowDialog() == DialogResult.OK)
{
lblMessage.Text = "成績上傳中…";
FISCA.Presentation.MotherForm.SetStatusBarMessage("成績上傳中…", 0);
counter = 0;
_upload.RunWorkerAsync();
}
else
{
this.DialogResult = DialogResult.Cancel;
}
};
_warn.ProgressChanged += delegate(object sender, ProgressChangedEventArgs e)
{
FISCA.Presentation.MotherForm.SetStatusBarMessage("" + e.UserState, e.ProgressPercentage);
};
_files = new List <FileInfo>();
_addScoreList = new List <JHSCETakeRecord>();
_deleteScoreList = new List <JHSCETakeRecord>();
}
internal void SetEffortMapper(EffortMapper effortMapper)
{
_effortMapper = effortMapper;
}
public ImportStartupForm()
{
// 每次開啟，就重新載入 代碼對照
KaoHsiung.ReaderScoreImport_DomainMakeUp.Mapper.ClassCodeMapper.Instance.Reload();
KaoHsiung.ReaderScoreImport_DomainMakeUp.Mapper.ExamCodeMapper.Instance.Reload();
KaoHsiung.ReaderScoreImport_DomainMakeUp.Mapper.DomainCodeMapper.Instance.Reload();
InitializeComponent();
InitializeSemesters();
_effortMapper = new EffortMapper();
// 載入預設儲存值
LoadConfigData();
_worker = new BackgroundWorker();
_worker.WorkerReportsProgress = true;
_worker.ProgressChanged += delegate(object sender, ProgressChangedEventArgs e)
{
lblMessage.Text = "" + e.UserState;
};
_worker.DoWork += delegate(object sender, DoWorkEventArgs e)
{
//將錯誤訊息刪光，以便重新統計
msgList.Clear();
#region Worker DoWork
_worker.ReportProgress(0, "檢查讀卡文字格式…");
#region 檢查文字檔
ValidateTextFiles vtf = new ValidateTextFiles(intStudentNumberLenght.Value);
ValidateTextResult vtResult = vtf.CheckFormat(_files);
if (vtResult.Error)
{
e.Result = vtResult;
return;
}
#endregion
//文字檔轉 RawData
RawDataCollection rdCollection = new RawDataCollection();
rdCollection.ConvertFromFiles(_files);
//RawData 轉 DataRecord
DataRecordCollection drCollection = new DataRecordCollection();
drCollection.ConvertFromRawData(rdCollection);
_rawDataValidator = new DataValidator <RawData>();
_dataRecordValidator = new DataValidator <DataRecord>();
#region 取得驗證需要的資料
JHCourse.RemoveAll();
_worker.ReportProgress(0, "取得學生資料…");
List <JHStudentRecord> studentList = GetInSchoolStudents();
List <string> s_ids = new List <string>();
Dictionary <string, string> studentNumberToStudentIDs = new Dictionary <string, string>();
foreach (JHStudentRecord student in studentList)
{
string sn = SCValidatorCreator.GetStudentNumberFormat(student.StudentNumber);
if (!studentNumberToStudentIDs.ContainsKey(sn))
{
studentNumberToStudentIDs.Add(sn, student.ID);
}
}
//紀錄現在所有txt 上 的學號，以處理重覆學號學號問題
List <string> s_numbers = new List <string>();
foreach (var dr in drCollection)
{
if (studentNumberToStudentIDs.ContainsKey(dr.StudentNumber))
{
s_ids.Add(studentNumberToStudentIDs[dr.StudentNumber]);
}
else
{
//學號不存在系統中，下面的Validator 會進行處理
}
//2017/1/8 穎驊註解， 原本的程式碼並沒有驗證學號重覆的問題，且無法在他Validator 的處理邏輯加入，故在此驗證
if (!s_numbers.Contains(dr.StudentNumber))
{
s_numbers.Add(dr.StudentNumber);
}
else
{
msgList.Add("學號:" + dr.StudentNumber + "，資料重覆，請檢察資料來源txt是否有重覆填寫的學號資料。");
}
}
studentList.Clear();
_worker.ReportProgress(0, "取得學期領域成績…");
List <JHSemesterScoreRecord> jhssr_list = JHSemesterScore.SelectBySchoolYearAndSemester(s_ids, SchoolYear, Semester);
#endregion
#region 註冊驗證
_worker.ReportProgress(0, "載入驗證規則…");
_rawDataValidator.Register(new DomainCodeValidator());
_rawDataValidator.Register(new ClassCodeValidator());
_rawDataValidator.Register(new ExamCodeValidator());
SCValidatorCreator scCreator = new SCValidatorCreator(JHStudent.SelectByIDs(s_ids));
_dataRecordValidator.Register(scCreator.CreateStudentValidator());
//_dataRecordValidator.Register(new ExamValidator(examList));
//_dataRecordValidator.Register(scCreator.CreateSCAttendValidator());
//_dataRecordValidator.Register(new CourseExamValidator(scCreator.StudentCourseInfo, aeList, examList));
#endregion
#region 進行驗證
_worker.ReportProgress(0, "進行驗證中…");
foreach (RawData rawData in rdCollection)
{
List <string> msgs = _rawDataValidator.Validate(rawData);
msgList.AddRange(msgs);
}
if (msgList.Count > 0)
{
e.Result = msgList;
return;
}
foreach (DataRecord dataRecord in drCollection)
{
List <string> msgs = _dataRecordValidator.Validate(dataRecord);
msgList.AddRange(msgs);
}
if (msgList.Count > 0)
{
e.Result = msgList;
return;
}
#endregion
#region 取得學生的評量成績
_duplicateMakeUpScoreList.Clear();
_updateMakeUpScoreList.Clear();
//Dictionary<string, JHSCETakeRecord> sceList = new Dictionary<string, JHSCETakeRecord>();
//FunctionSpliter<string, JHSCETakeRecord> spliterSCE = new FunctionSpliter<string, JHSCETakeRecord>(300, 3);
//spliterSCE.Function = delegate(List<string> part)
//{
// return JHSCETake.Select(null, null, null, null, part);
//};
//foreach (JHSCETakeRecord sce in spliterSCE.Execute(scaIDs.ToList()))
//{
// string key = GetCombineKey(sce.RefStudentID, sce.RefCourseID, sce.RefExamID);
// if (!sceList.ContainsKey(key))
// sceList.Add(key, sce);
//}
//Dictionary<string, JHExamRecord> examTable = new Dictionary<string, JHExamRecord>();
//Dictionary<string, JHSCAttendRecord> scaTable = new Dictionary<string, JHSCAttendRecord>();
//foreach (JHExamRecord exam in examList)
// if (!examTable.ContainsKey(exam.Name))
// examTable.Add(exam.Name, exam);
//foreach (JHSCAttendRecord sca in scaList)
//{
// string key = GetCombineKey(sca.RefStudentID, sca.RefCourseID);
// if (!scaTable.ContainsKey(key))
// scaTable.Add(key, sca);
//}
//2018/1/8 穎驊新增
//填寫補考成績
foreach (DataRecord dr in drCollection)
{
// 利用學號 將學生的isd 對應出來
string s_id = studentNumberToStudentIDs[dr.StudentNumber];
// 紀錄學生是否有學期成績，如果連學期成績都沒有，本補考成績將會無法匯入(因為不合理)
bool haveSemesterRecord = false;
foreach (JHSemesterScoreRecord jhssr in jhssr_list)
{
if (jhssr.RefStudentID == s_id)
{
haveSemesterRecord = true;
if (jhssr.Domains.ContainsKey(dr.Domain))
{
// 假如原本已經有補考成績，必須將之加入waring_list，讓使用者決定是否真的要覆蓋
if (jhssr.Domains[dr.Domain].ScoreMakeup != null)
{
string warning = "學號:" + dr.StudentNumber + "學生，在學年度: " + SchoolYear + "，學期: " + Semester + "，領域: " + dr.Domain + "已有補考成績: " + jhssr.Domains[dr.Domain].ScoreMakeup + "，本次匯入將會將其覆蓋取代。";
_duplicateMakeUpScoreList.Add(jhssr);
if (!msg_DuplicatedDict.ContainsKey(s_id))
{
msg_DuplicatedDict.Add(s_id, warning);
}
else
{
}
jhssr.Domains[dr.Domain].ScoreMakeup = dr.Score;
_updateMakeUpScoreList.Add(jhssr);
}
else
{
jhssr.Domains[dr.Domain].ScoreMakeup = dr.Score;
_updateMakeUpScoreList.Add(jhssr);
}
}
else
{
// 2018/1/8 穎驊註解，針對假如該學生在當學期成績卻沒有其領域成績時，跳出提醒，因為正常情境是領域成績計算出來不及格，才需要補考。
msgList.Add("學號:" + dr.StudentNumber + "學生，在學年度:" + SchoolYear + "，學期:" + Semester + "，並無領域:" + dr.Domain + "成績，請先至學生上確認是否已有結算資料。");
}
}
}
if (!haveSemesterRecord)
{
msgList.Add("學號:" + dr.StudentNumber + "學生，在學年度:" + SchoolYear + "，學期:" + Semester + "，並無學期成績，請先至學生上確認是否已有結算資料。");
}
}
if (msgList.Count > 0)
{
e.Result = msgList;
return;
}
#endregion
e.Result = null;
#endregion
};
_worker.RunWorkerCompleted += delegate(object sender, RunWorkerCompletedEventArgs e)
{
#region Worker Completed
if (e.Error == null && e.Result == null)
{
if (!_upload.IsBusy)
{
//如果學生身上已有補考成績，則提醒使用者
if (_duplicateMakeUpScoreList.Count > 0)
{
_warn.RunWorkerAsync();
}
else
{
lblMessage.Text = "成績上傳中…";
FISCA.Presentation.MotherForm.SetStatusBarMessage("成績上傳中…", 0);
counter = 0;
_upload.RunWorkerAsync();
}
}
}
else
{
ControlEnable = true;
if (e.Error != null)
{
MsgBox.Show("匯入失敗。" + e.Error.Message);
SmartSchool.ErrorReporting.ReportingService.ReportException(e.Error);
}
else if (e.Result != null && e.Result is ValidateTextResult)
{
ValidateTextResult result = e.Result as ValidateTextResult;
ValidationErrorViewer viewer = new ValidationErrorViewer();
viewer.SetTextFileError(result.LineIndexes, result.ErrorFormatLineIndexes, result.DuplicateLineIndexes);
viewer.ShowDialog();
}
else if (e.Result != null && e.Result is List <string> )
{
ValidationErrorViewer viewer = new ValidationErrorViewer();
viewer.SetErrorLines(e.Result as List <string>);
viewer.ShowDialog();
}
}
#endregion
};
_upload = new BackgroundWorker();
_upload.WorkerReportsProgress = true;
_upload.ProgressChanged += new ProgressChangedEventHandler(_upload_ProgressChanged);
//_upload.ProgressChanged += delegate(object sender, ProgressChangedEventArgs e)
//{
// counter += double.Parse("" + e.ProgressPercentage);
// FISCA.Presentation.MotherForm.SetStatusBarMessage("成績上傳中…", (int)(counter * 100f / (double)_addScoreList.Count));
//};
_upload.DoWork += new DoWorkEventHandler(_upload_DoWork);
_upload.RunWorkerCompleted += new RunWorkerCompletedEventHandler(_upload_RunWorkerCompleted);
_warn = new BackgroundWorker();
_warn.WorkerReportsProgress = true;
_warn.DoWork += delegate(object sender, DoWorkEventArgs e)
{
_warn.ReportProgress(0, "產生警告訊息...");
Dictionary <string, string> examDict = new Dictionary <string, string>();
foreach (JHExamRecord exam in JHExam.SelectAll())
{
if (!examDict.ContainsKey(exam.ID))
{
examDict.Add(exam.ID, exam.Name);
}
}
WarningForm form = new WarningForm();
int count = 0;
foreach (JHSemesterScoreRecord sce in _duplicateMakeUpScoreList)
{
form.Add(sce.RefStudentID, sce.Student.Name, msg_DuplicatedDict[sce.RefStudentID]);
_warn.ReportProgress((int)(count * 100 / _duplicateMakeUpScoreList.Count), "產生警告訊息...");
}
e.Result = form;
};
_warn.RunWorkerCompleted += delegate(object sender, RunWorkerCompletedEventArgs e)
{
WarningForm form = e.Result as WarningForm;
if (form.ShowDialog() == DialogResult.OK)
{
lblMessage.Text = "成績上傳中…";
FISCA.Presentation.MotherForm.SetStatusBarMessage("成績上傳中…", 0);
counter = 0;
_upload.RunWorkerAsync();
}
else
{
this.DialogResult = DialogResult.Cancel;
}
};
_warn.ProgressChanged += delegate(object sender, ProgressChangedEventArgs e)
{
FISCA.Presentation.MotherForm.SetStatusBarMessage("" + e.UserState, e.ProgressPercentage);
};
_files = new List <FileInfo>();
}
public ScoreInputForm(JHStudentRecord student, JHCourseRecord course)
{
InitializeComponent();
InitializeListener();
_effortMapper = new EffortMapper();
prlp = new PermRecLogProcess();
lblCourseName.Text = course.Name;
lblStudent.Text = student.Name + " " + student.StudentNumber;
lblWaringMsg.Visible = false;
_course = course;
_student = student;
List <JHSCAttendRecord> scattendList = JHSCAttend.SelectByStudentIDAndCourseID(new string[] { student.ID }, new string[] { course.ID });
if (scattendList.Count > 0)
{
_scattend = scattendList[0];
}
#region 取得評量成績
_listener.SuspendListen();
// 取得所有試別
Dictionary <string, JHExamRecord> exams = JHExam.SelectAll().ToDictionary(x => x.ID);
List <string> examIDs = new List <string>(exams.Keys);
List <KH.JHAEIncludeRecord> aeList = new List <KH.JHAEIncludeRecord>();
// 當課程有評量成績時取得評量設定
if (course.RefAssessmentSetupID != null)
{
JHAssessmentSetupRecord assessment = JHAssessmentSetup.SelectByID(course.RefAssessmentSetupID);
if (assessment != null)
{
foreach (JHAEIncludeRecord ae in JHAEInclude.SelectByAssessmentSetupID(assessment.ID))
{
aeList.Add(new KH.JHAEIncludeRecord(ae));
}
}
}
// 排序需要再改寫
aeList.Sort(delegate(KH.JHAEIncludeRecord x, KH.JHAEIncludeRecord y)
{
int ix = examIDs.IndexOf(x.RefExamID);
int iy = examIDs.IndexOf(y.RefExamID);
if (ix == -1)
{
ix = int.MaxValue;
}
if (iy == -1)
{
iy = int.MaxValue;
}
return(ix.CompareTo(iy));
});
List <KH.JHSCETakeRecord> sceList = JHSCETake.SelectByStudentAndCourse(student.ID, course.ID).AsKHJHSCETakeRecords();
Dictionary <string, DataGridViewRow> rows = new Dictionary <string, DataGridViewRow>();
foreach (KH.JHAEIncludeRecord ae in aeList)
{
DataGridViewRow row = new DataGridViewRow();
JHExamRecord exam = null;
if (exams.ContainsKey(ae.RefExamID))
{
exam = exams[ae.RefExamID];
}
row.CreateCells(dgv, (exam != null) ? exam.Name : "無此評量(" + ae.RefExamID + ")", "", "", "");
dgv.Rows.Add(row);
row.Cells[chExamName.Index].Tag = (exam != null) ? exam.ID : "";
if (!ae.UseScore)
{
DisableCell(row, chScore);
}
if (!ae.UseEffort)
{
DisableCell(row, chEffort);
}
if (!ae.UseText)
{
DisableCell(row, chText);
}
if (!rows.ContainsKey(ae.RefExamID))
{
rows.Add(ae.RefExamID, row);
}
}
foreach (KH.JHSCETakeRecord sce in sceList)
{
if (rows.ContainsKey(sce.RefExamID))
{
DataGridViewRow row = rows[sce.RefExamID];
row.Cells[chScore.Index].Value = sce.Score.HasValue ? "" + sce.Score.Value : "";
row.Cells[chEffort.Index].Value = sce.Effort.HasValue ? "" + sce.Effort.Value : "";
row.Cells[chText.Index].Value = sce.Text;
row.Tag = sce;
}
else
{
DataGridViewRow row = new DataGridViewRow();
JHExamRecord exam = JHExam.SelectByID(sce.RefExamID);
row.CreateCells(dgv, (exam != null) ? exam.Name : "無此評量(" + sce.RefExamID + ")", sce.Score.HasValue ? "" + sce.Score.Value : "", sce.Effort.HasValue ? "" + sce.Effort.Value : "", sce.Text);
row.Tag = sce;
row.Cells[chExamName.Index].Tag = (exam != null) ? exam.ID : "";
dgv.Rows.Add(row);
DisableCell(row, chExamName);
DisableCell(row, chScore);
DisableCell(row, chEffort);
DisableCell(row, chText);
lblWaringMsg.Visible = true;
}
}
if (_scattend != null)
{
DataGridViewRow row = new DataGridViewRow();
row.CreateCells(dgv, "平時評量", "" + _scattend.OrdinarilyScore, "" + _scattend.OrdinarilyEffort, string.Empty);
row.Tag = "平時評量";
dgv.Rows.Add(row);
DisableCell(row, chText);
DataGridViewRow row2 = new DataGridViewRow();
row2.CreateCells(dgv, "課程總成績", "" + _scattend.Score, "" + _scattend.Effort, _scattend.Text);
row2.Tag = "課程總成績";
dgv.Rows.Add(row2);
}
foreach (DataGridViewRow dgv1 in dgv.Rows)
{
foreach (DataGridViewCell cell in dgv1.Cells)
{
cell.ErrorText = "";
if (cell.OwningColumn == chScore)
{
cell.Style.ForeColor = Color.Black;
if (!string.IsNullOrEmpty("" + cell.Value))
{
decimal d;
if (!decimal.TryParse("" + cell.Value, out d))
{
cell.ErrorText = "分數必須為數字";
}
else
{
if (d < 60)
{
cell.Style.ForeColor = Color.Red;
}
if (d > 100 || d < 0)
{
cell.Style.ForeColor = Color.Green;
}
}
}
}
else if (cell.OwningColumn == chEffort)
{
if (!string.IsNullOrEmpty("" + cell.Value))
{
int i;
if (!int.TryParse("" + cell.Value, out i))
{
cell.ErrorText = "努力程度必須為整數";
}
}
}
}
}
_listener.Reset();
_listener.ResumeListen();
#endregion
SetLoadDataToLog();
}
