private void Save_Click(object sender, EventArgs e)
{
string graduationRequirementName = this.txtName.Text.Trim();
Access = new AccessHelper();
// 所有的「畢業條件」
List<GraduationRequirement> graduationRequirements = Access.Select<GraduationRequirement>();
// 若新增的「畢業條件」名稱已存在，則發出警告並跳出程式
if (graduationRequirements.Where(x => (x.Name == graduationRequirementName && x.DepartmentGroupID == _DepartmentGroupID)).Count() > 0)
{
MessageBox.Show("同名之畢業條件已存在！");
return;
}
// 待新增的「畢業條件」
GraduationRequirement graduationRequirement = new GraduationRequirement();
// 檢查是否複製
ComboItem item = (ComboItem)this.cboGraduationRequirementRule.SelectedItem;
if (item == null || item.Tag == null)
{
// 不複製
graduationRequirement.Name = graduationRequirementName;
graduationRequirement.DepartmentGroupID = _DepartmentGroupID;
graduationRequirement.RequiredCredit = 0;
graduationRequirement.DepartmentCredit = 0;
graduationRequirement.ElectiveCredit = 0;
graduationRequirement.Save();
}
else
{
// 1、複製「畢業條件」
GraduationRequirement oGraduationRequirement = (GraduationRequirement)item.Tag;
graduationRequirement.Name = graduationRequirementName;
graduationRequirement.DepartmentGroupID = _DepartmentGroupID;
graduationRequirement.RequiredCredit = oGraduationRequirement.RequiredCredit;
graduationRequirement.DepartmentCredit = oGraduationRequirement.DepartmentCredit;
graduationRequirement.ElectiveCredit = oGraduationRequirement.ElectiveCredit;
graduationRequirements = new List<GraduationRequirement>();
graduationRequirements.Add(graduationRequirement);
List<string> graduationRequirementIDs = graduationRequirements.SaveAll();
// 2、複製「畢業應修科目清單」
List<GraduationSubjectList> graduationSubjects = Access.Select<GraduationSubjectList>(string.Format("ref_graduation_requirement_id = {0}", oGraduationRequirement.UID));
List<GraduationSubjectList> newGraduationSubjects = new List<GraduationSubjectList>();
foreach(GraduationSubjectList graduationSubject in graduationSubjects)
{
GraduationSubjectList newGraduationSubjectList = new GraduationSubjectList();
newGraduationSubjectList.GraduationRequirementID = int.Parse(graduationRequirementIDs[0]);
newGraduationSubjectList.SubjectID = graduationSubject.SubjectID;
newGraduationSubjectList.Prerequisites = graduationSubject.Prerequisites;
newGraduationSubjects.Add(newGraduationSubjectList);
}
newGraduationSubjects.SaveAll();
// 3、複製「畢業應修科目群組應修科目數及應修學分數」--待討論，建議不做
// 4、重繪「指定畢業條件」選單
//EMBACore.Initialization.StudentInit.RedrawGraduationRequirementMenuButton();
}
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
private void SaveGraduationSubjectList(GraduationRequirement graduationRequirement)
{
List<GraduationSubjectList> graduationSubjectLists = Access.Select<GraduationSubjectList>(string.Format("ref_graduation_requirement_id={0}", graduationRequirement.UID));
graduationSubjectLists.ForEach(x => x.Deleted = true);
graduationSubjectLists.SaveAll();
List<GraduationSubjectList> newGraduationSubjectLists = new List<GraduationSubjectList>();
foreach (DataGridViewRow dataGridViewRow in this.dgvMotherData.Rows)
{
if (dataGridViewRow.IsNewRow)
continue;
GraduationSubjectList graduationSubjectList = new GraduationSubjectList();
graduationSubjectList.GraduationRequirementID = int.Parse(graduationRequirement.UID);
graduationSubjectList.SubjectID = int.Parse(dicSubjects[dataGridViewRow.Cells["SubjectCode"].Value.ToString()].UID);
graduationSubjectList.SubjectGroup = (dataGridViewRow.Cells["SubjectGroup"].Value == null ? "" : dataGridViewRow.Cells["SubjectGroup"].Value.ToString());
bool IsDeptRequired = false;
bool.TryParse(dataGridViewRow.Cells["IsDeptRequired"].Value + "", out IsDeptRequired);
graduationSubjectList.IsDeptRequired = IsDeptRequired;
graduationSubjectList.Prerequisites = (dataGridViewRow.Cells["Prerequisites"].Value == null ? "" : dataGridViewRow.Cells["Prerequisites"].Value.ToString());
newGraduationSubjectLists.Add(graduationSubjectList);
}
try
{
newGraduationSubjectLists.SaveAll();
MessageBox.Show("儲存成功。");
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
