private void rightBtnDelete_Click(object sender, EventArgs e) { DialogResult result = MsgBox.Show("確定刪除選取資料行?", "提醒", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { List <UDT.Place> listDeleteData = new List <UDT.Place>(); foreach (DataGridViewRow dgvrow in dataGridViewX1.SelectedRows) { if (dgvrow.Tag == null) { dataGridViewX1.Rows.Remove(dgvrow); } else { UDT.Place data = (UDT.Place)dgvrow.Tag; listDeleteData.Add(data); dataGridViewX1.Rows.Remove(dgvrow); } } try { this._access.DeletedValues(listDeleteData); MsgBox.Show("資料刪除成功!"); } catch (Exception ex) { MsgBox.Show(ex.Message); } } }
private void btnSave_Click(object sender, EventArgs e) { if (dgvDisplayOrder_Validate() && dgvName_Validate() && dgvZone_Validate()) // 資料驗證. { // 資料整理 List <UDT.Place> listInsertData = new List <UDT.Place>(); List <UDT.Place> listUpdateData = new List <UDT.Place>(); int row = 0; foreach (DataGridViewRow dgvrow in dataGridViewX1.Rows) { if (row == dataGridViewX1.Rows.Count - 1) { break; } row++; if (dgvrow.Tag == null) { UDT.Place data = new UDT.Place(); fillData(data, dgvrow); listInsertData.Add(data); } else { UDT.Place data = (UDT.Place)dgvrow.Tag; fillData(data, dgvrow); listUpdateData.Add(data); } } // 資料儲存 try { if (listInsertData.Count > 0) { this._access.InsertValues(listInsertData); } if (listUpdateData.Count > 0) { this._access.UpdateValues(listUpdateData); } MsgBox.Show("資料儲存成功!"); ReloadDataGridView(); } catch (Exception ex) { MsgBox.Show(ex.Message); } } }
private void fillData(UDT.Place data, DataGridViewRow dgvrow) { data.Enabled = bool.Parse(("" + dgvrow.Cells[0].Value) == "" ? "false" : "" + dgvrow.Cells[0].Value); data.Name = "" + dgvrow.Cells[1].Value; if (!string.IsNullOrEmpty("" + dgvrow.Cells[2].Value)) { data.DisplayOrder = int.Parse("" + dgvrow.Cells[2].Value); } data.RefAreaID = int.Parse(this._dicAreaByName[cbxArea.SelectedItem.ToString()].UID); if (!string.IsNullOrEmpty("" + dgvrow.Cells[3].Value)) { data.Zone = int.Parse("" + dgvrow.Cells[3].Value); } data.CreatedBy = "" + dgvrow.Cells[4].Value; data.CreateTime = DateTime.Parse(DateTime.Now.ToString("yyyy/MM/dd")); }