private void UpdateGrid(bool isSearch) { tbl_inspect_data insData = new tbl_inspect_data(); DataTable dt1 = new DataTable(); DataTable dtFinal = new DataTable(); if (isSearch) { insData.Search(txtBoxID.Text); dt1 = insData.listData.CreateDatatableFromClass <tbl_inspect_data>(); if (dt1.Columns.Contains("inspect_date")) { dt1.Columns.Remove("inspect_date"); } if (dt1.Columns.Contains("judge")) { dt1.Columns.Remove("judge"); } dtFinal = DatatableClass.Pivot(dt1, dt1.Columns["item_no"], dt1.Columns["inspect_data"]); } tbl_inspect_master masterData = new tbl_inspect_master(); masterData.Search(new tbl_inspect_master { inspect_id = 0, part_number = txtPartNumber.Text }); for (int i = 0; i < dtFinal.Rows.Count; i++) { int id = int.Parse(dtFinal.Rows[i]["inspect_id"].ToString()); string insName = masterData.listMaster.Where(x => x.inspect_id == id).Select(x => x.inspect_name).First(); dtFinal.Rows[i]["inspect_id"] = insName; } dgvMain.DataSource = dtFinal; current = insData.GetMaxQty(txtBoxID.Text); txtBoxQty.Text = current.ToString(); }
private void GetCmb() { tbl_inspect_master masterData = new tbl_inspect_master(); cmbTools.DataSource = masterData.GetTools(); cmbTools.ResetText(); }
private void dgvMain_CellDoubleClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex < 0) { return; } tbl_inspect_master masterData = dgvMain.Rows[e.RowIndex].DataBoundItem as tbl_inspect_master; OpenMeasurement(masterData); }
private void OpenMeasurement(tbl_inspect_master inItem) { switch (inItem.inspect_tool) { case "DG": case "PG": DGMeasureFrm dgfrm = new DGMeasureFrm(txtBoxID.Text, inItem); dgfrm.ShowDialog(); break; } }
private void UpdateGrid(bool isSearch) { tbl_inspect_master masterData = new tbl_inspect_master(); if (isSearch) { masterData.Search(new tbl_inspect_master { part_number = txtPartNumber.Text, inspect_tool = cmbTools.Text }); } dgvMain.DataSource = masterData.listMaster; }
public DGMeasureFrm(string boxid, tbl_inspect_master inItem) { InitializeComponent(); txtBoxID.Text = boxid; insID = inItem.inspect_id; txtInsCode.Text = inItem.inspect_cd; txtInsName.Text = inItem.inspect_name; txtInsPart.Text = inItem.part_number; txtInsTool.Text = inItem.inspect_tool; txtInsSpec.Text = inItem.inspect_spec.ToString(); txtUSL.Text = (inItem.inspect_spec + inItem.tol_plus).ToString(); txtLSL.Text = (inItem.inspect_spec - inItem.tol_minus).ToString(); listNewData = new BindingList <tbl_inspect_data>(); }
private void btnDelMaster_Click(object sender, EventArgs e) { try { tbl_inspect_master masterData = dgvMain.SelectedRows[0].DataBoundItem as tbl_inspect_master; int n = masterData.Delete(masterData.inspect_id); CustomMessageBox.Notice("Deleted " + n + " master inspect!" + Environment.NewLine + "Đã xóa " + n + " hạng mục!"); UpdateGrid(true); } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
private void btnExport_Click(object sender, EventArgs e) { try { string boxCode = string.Empty; string partCode = string.Empty; tbl_part_box boxData = new tbl_part_box(); tbl_inspect_data insData = new tbl_inspect_data(); tbl_inspect_master masterData = new tbl_inspect_master(); if (IsBoxMode) { if (dgvMain.SelectedRows.Count <= 0) { CustomMessageBox.Notice("Please choose a box!" + Environment.NewLine + "Vui lòng chọn 1 box!"); return; } boxData = dgvMain.SelectedRows[0].DataBoundItem as tbl_part_box; boxCode = boxData.part_box_cd; partCode = boxData.part_number; } else { boxCode = txtBoxID.Text; partCode = txtPartNumber.Text; } insData.Search(boxCode); boxData.Search(new tbl_part_box { part_box_cd = boxCode }, false); masterData.Search(new tbl_inspect_master { inspect_id = 0, part_number = partCode }); ExcelClassnew excel = new ExcelClassnew(); excel.exportExcelIQC(boxData.listBox[0], masterData.listMaster, insData.listData); } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
private void btnExport_Click(object sender, EventArgs e) { try { tbl_part_box boxData = new tbl_part_box(); tbl_inspect_data insData = new tbl_inspect_data(); tbl_inspect_master masterData = new tbl_inspect_master(); insData.Search(txtBoxID.Text); boxData.Search(new tbl_part_box { part_box_cd = txtBoxID.Text }, false); masterData.Search(new tbl_inspect_master { inspect_id = 0, part_number = txtPartNumber.Text }); ExcelClassnew excel = new ExcelClassnew(); excel.exportExcelIQC(boxData.listBox[0], masterData.listMaster, insData.listData); } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
private void btnRegister_Click(object sender, EventArgs e) { try { tbl_inspect_master masterData = new tbl_inspect_master(); int n = masterData.Add(new tbl_inspect_master { inspect_cd = txtInsCode.Text, part_number = txtInsPart.Text, inspect_name = txtInsName.Text, inspect_tool = cmbInsTool.Text, inspect_spec = double.Parse(txtInsSpec.Text), tol_plus = double.Parse(txtInsPlus.Text), tol_minus = double.Parse(txtInsMinus.Text) }); CustomMessageBox.Notice("Add " + n + " master inspect!" + Environment.NewLine + "Đã thêm " + n + " hạng mục!"); } catch (Exception ex) { CustomMessageBox.Error(ex.Message); } }
private void btnOpenMeasure_Click(object sender, EventArgs e) { tbl_inspect_master masterData = dgvMain.SelectedRows[0].DataBoundItem as tbl_inspect_master; OpenMeasurement(masterData); }