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);
}
