private void btnSave_Click(object sender, EventArgs e) { // 驗證資料 foreach (DataGridViewRow dgvr in dgvSHWeight.Rows) { if (dgvr.Cells[AddWeight.Index].ErrorText != "") { FISCA.Presentation.Controls.MsgBox.Show("資料有誤,無法儲存!"); return; } } foreach (DataGridViewRow dgvr in dgvSH5Weight.Rows) { if (dgvr.Cells[AddWeight5.Index].ErrorText != "") { FISCA.Presentation.Controls.MsgBox.Show("資料有誤,無法儲存!"); return; } } // 清除舊資料 foreach (DAL.UserDefData_StudTypeWeight ud in _udd) { ud.Deleted = true; } DAL.UDTTransfer.DeleteDataToUDT_StudTypeWeight(_udd); // 新增資料 List <DAL.UserDefData_StudTypeWeight> InsertData = new List <JointAdmissionModule.DAL.UserDefData_StudTypeWeight>(); foreach (DataGridViewRow dgvr in dgvSHWeight.Rows) { if (dgvr.IsNewRow) { continue; } DAL.UserDefData_StudTypeWeight ud = new JointAdmissionModule.DAL.UserDefData_StudTypeWeight(); ud.SchoolType = "高中"; if (dgvr.Cells[JoinStudType.Index].Value != null) { ud.JoinStudType = dgvr.Cells[JoinStudType.Index].Value.ToString(); } if (dgvr.Cells[StudType.Index].Value != null) { ud.StudentType = dgvr.Cells[StudType.Index].Value.ToString(); } decimal dd; bool bl; if (dgvr.Cells[AddWeight.Index].Value != null) { if (decimal.TryParse(dgvr.Cells[AddWeight.Index].Value.ToString(), out dd)) { ud.AddWeight = dd; } } if (dgvr.Cells[checkNonRank.Index].Value != null) { if (bool.TryParse(dgvr.Cells[checkNonRank.Index].Value.ToString(), out bl)) { ud.CheckNonRank = bl; } } if (dgvr.Cells[JoinStudTypeCode.Index].Value != null) { ud.JoinStudTypeCode = dgvr.Cells[JoinStudTypeCode.Index].Value.ToString(); } InsertData.Add(ud); } foreach (DataGridViewRow dgvr in dgvSH5Weight.Rows) { if (dgvr.IsNewRow) { continue; } DAL.UserDefData_StudTypeWeight ud = new JointAdmissionModule.DAL.UserDefData_StudTypeWeight(); ud.SchoolType = "五專"; if (dgvr.Cells[JoinStudType5.Index].Value != null) { ud.JoinStudType = dgvr.Cells[JoinStudType5.Index].Value.ToString(); } if (dgvr.Cells[StudType5.Index].Value != null) { ud.StudentType = dgvr.Cells[StudType5.Index].Value.ToString(); } decimal dd; bool bl; if (dgvr.Cells[AddWeight5.Index].Value != null) { if (decimal.TryParse(dgvr.Cells[AddWeight5.Index].Value.ToString(), out dd)) { ud.AddWeight = dd; } } if (dgvr.Cells[checkNonRank5.Index].Value != null) { if (bool.TryParse(dgvr.Cells[checkNonRank5.Index].Value.ToString(), out bl)) { ud.CheckNonRank = bl; } } if (dgvr.Cells[JoinStudTypeCode5.Index].Value != null) { ud.JoinStudTypeCode = dgvr.Cells[JoinStudTypeCode5.Index].Value.ToString(); } InsertData.Add(ud); } if (InsertData.Count > 0) { DAL.UDTTransfer.InsertDataToUDT_StudTypeWeight(InsertData); FISCA.Presentation.Controls.MsgBox.Show("儲存完成"); this.Close(); } }
private void btnSave_Click(object sender, EventArgs e) { // 驗證資料 foreach (DataGridViewRow dgvr in dgvSHWeight.Rows) if (dgvr.Cells[AddWeight.Index].ErrorText != "") { FISCA.Presentation.Controls.MsgBox.Show("資料有誤,無法儲存!"); return; } foreach (DataGridViewRow dgvr in dgvSH5Weight.Rows) if (dgvr.Cells[AddWeight5.Index].ErrorText != "") { FISCA.Presentation.Controls.MsgBox.Show("資料有誤,無法儲存!"); return; } // 清除舊資料 foreach (DAL.UserDefData_StudTypeWeight ud in _udd) ud.Deleted = true; DAL.UDTTransfer.DeleteDataToUDT_StudTypeWeight(_udd); // 新增資料 List<DAL.UserDefData_StudTypeWeight> InsertData = new List<JointAdmissionModule.DAL.UserDefData_StudTypeWeight>(); foreach (DataGridViewRow dgvr in dgvSHWeight.Rows) { if (dgvr.IsNewRow) continue; DAL.UserDefData_StudTypeWeight ud = new JointAdmissionModule.DAL.UserDefData_StudTypeWeight(); ud.SchoolType = "高中"; if (dgvr.Cells[JoinStudType.Index].Value != null) ud.JoinStudType = dgvr.Cells[JoinStudType.Index].Value.ToString(); if (dgvr.Cells[StudType.Index].Value != null) ud.StudentType = dgvr.Cells[StudType.Index].Value.ToString(); decimal dd; bool bl; if (dgvr.Cells[AddWeight.Index].Value != null) if (decimal.TryParse(dgvr.Cells[AddWeight.Index].Value.ToString(), out dd)) ud.AddWeight = dd; if (dgvr.Cells[checkNonRank.Index].Value != null) if (bool.TryParse(dgvr.Cells[checkNonRank.Index].Value.ToString(), out bl)) ud.CheckNonRank = bl; if (dgvr.Cells[JoinStudTypeCode.Index].Value != null) ud.JoinStudTypeCode = dgvr.Cells[JoinStudTypeCode.Index].Value.ToString(); InsertData.Add(ud); } foreach (DataGridViewRow dgvr in dgvSH5Weight.Rows) { if (dgvr.IsNewRow) continue; DAL.UserDefData_StudTypeWeight ud = new JointAdmissionModule.DAL.UserDefData_StudTypeWeight(); ud.SchoolType = "五專"; if (dgvr.Cells[JoinStudType5.Index].Value != null) ud.JoinStudType = dgvr.Cells[JoinStudType5.Index].Value.ToString(); if (dgvr.Cells[StudType5.Index].Value != null) ud.StudentType = dgvr.Cells[StudType5.Index].Value.ToString(); decimal dd; bool bl; if (dgvr.Cells[AddWeight5.Index].Value != null) if (decimal.TryParse(dgvr.Cells[AddWeight5.Index].Value.ToString(), out dd)) ud.AddWeight = dd; if (dgvr.Cells[checkNonRank5.Index].Value != null) if (bool.TryParse(dgvr.Cells[checkNonRank5.Index].Value.ToString(), out bl)) ud.CheckNonRank = bl; if (dgvr.Cells[JoinStudTypeCode5.Index].Value != null) ud.JoinStudTypeCode = dgvr.Cells[JoinStudTypeCode5.Index].Value.ToString(); InsertData.Add(ud); } if (InsertData.Count > 0) { DAL.UDTTransfer.InsertDataToUDT_StudTypeWeight(InsertData); FISCA.Presentation.Controls.MsgBox.Show("儲存完成"); this.Close(); } }