private void cmdSave_Click(object sender, EventArgs e) { if (txtpsnCode.Text.Trim() == "") { MessageBox.Show("กรุณาเลือกพนักงาน ก่อน !!!", "ผลการตรวจสอบ", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); txtpsnCode.Focus(); return; } WorkTable workTable = new WorkTable(); workTable.psnCode = txtpsnCode.Text.Trim(); List<WorkTableDetail> workTableDetails = new List<WorkTableDetail>(); WorkTableDetail workTableDetail = null; for (int i = 0; i < dgvList.Rows.Count; i++) { if (Convert.ToBoolean(dgvList.Rows[i].Cells[0].Value = true)) { workTableDetail = new WorkTableDetail(); workTableDetail.day = dgvList.Rows[i].Cells[3].Value.ToString(); workTableDetail.start = dgvList.Rows[i].Cells[4].Value.ToString(); workTableDetail.end = dgvList.Rows[i].Cells[5].Value.ToString(); workTableDetails.Add(workTableDetail); } } workTable.workTableDetails = workTableDetails; int result = workTableService.CreateWorkTable(workTable); if (result > -1) { Console.WriteLine("Insert Complete"); lblresult.Visible = true; lblresult.Text = " บันทึกเรียบร้อย "; } else { Console.WriteLine("Insert Not Complete"); lblresult.Visible = true; lblresult.Text = " ไม่สามารถบันทึกข้อมูลได้"; } }
private void frmWorkTable_Load(object sender, EventArgs e) { this.WindowState = FormWindowState.Maximized; try { cboSearch.Items.Add("รหัสพนักงาน"); cboSearch.Items.Add("ชื่อพนักงาน"); cboSearch.SelectedIndex = 1; txtpsnPrefix.Enabled = false; txtpsnName.Enabled = false; txtpsnLastName.Enabled = false; txtpsndpName.Enabled = false; txtpsnpsName.Enabled = false; List<WorkTableDetail> workTableDetails = new List<WorkTableDetail>(); WorkTableDetail workTableDetail; workTableDetail = new WorkTableDetail(); workTableDetail.day = "จันทร์"; workTableDetail.start = "08.00"; workTableDetail.end = "17.00"; workTableDetails.Add(workTableDetail); workTableDetail = new WorkTableDetail(); workTableDetail.day = "อังคาร"; workTableDetail.start = "08.00"; workTableDetail.end = "17.00"; workTableDetails.Add(workTableDetail); workTableDetail = new WorkTableDetail(); workTableDetail.day = "พุธ"; workTableDetail.start = "08.00"; workTableDetail.end = "17.00"; workTableDetails.Add(workTableDetail); workTableDetail = new WorkTableDetail(); workTableDetail.day = "พฤหัสบดี"; workTableDetail.start = "08.00"; workTableDetail.end = "17.00"; workTableDetails.Add(workTableDetail); workTableDetail = new WorkTableDetail(); workTableDetail.day = "ศุกร์"; workTableDetail.start = "08.00"; workTableDetail.end = "17.00"; workTableDetails.Add(workTableDetail); workTableDetail = new WorkTableDetail(); workTableDetail.day = "เสาร์"; workTableDetail.start = "08.00"; workTableDetail.end = "17.00"; workTableDetails.Add(workTableDetail); workTableDetail = new WorkTableDetail(); workTableDetail.day = "อาทิตย์"; workTableDetail.start = "08.00"; workTableDetail.end = "17.00"; workTableDetails.Add(workTableDetail); //Bind XML dataset to DataGridView //DataSet ds = new DataSet(); //ds.ReadXml(_xmlFilePath); dgvList.DataSource = workTableDetails; countRow = workTableDetails.Count; FormatdgvList(); FormatDgvList(); DatagridViewCheckBoxHeaderCell cbHeader = new DatagridViewCheckBoxHeaderCell(); Column1.HeaderCell = cbHeader; Column1.HeaderText = ""; Column1.Width = 50; cbHeader.OnCheckBoxClicked += new CheckBoxClickedHandler(cbHeader_OnCheckBoxClicked); ////Add the checkbox column //dataGridView1.Columns.Insert(0, // new DataGridViewCheckBoxColumn()); ////SendKeys.Send("{TAB}"); //dataGridView1.ReadOnly = false; //foreach (DataGridViewColumn c in dataGridView1.Columns) { // c.SortMode = DataGridViewColumnSortMode.NotSortable; // c.Selected = true; //} //dataGridView1.SelectionMode = DataGridViewSelectionMode.FullColumnSelect; //dataGridView1.Columns[1].Selected = true; } catch (Exception ex) { MessageBox.Show("Exception: " + ex.ToString()); } }