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 btnEnterValue_Click(object sender, EventArgs e)
{
try
{
//currNo++;
if (string.IsNullOrEmpty(txtMeasureValue.Text))
{
return;
}
double measVal = double.Parse(txtMeasureValue.Text);
double uslVal = double.Parse(txtUSL.Text);
double lslVal = double.Parse(txtLSL.Text);
string judge = "0";
if (measVal > uslVal || measVal < lslVal)
{
judge = "1";
}
else
{
judge = "0";
}
tbl_inspect_data insData = new tbl_inspect_data
{
judge = judge,
item_no = currNo,
inspect_id = insID,
part_box_cd = txtBoxID.Text,
inspect_date = DateTime.Now,
inspect_data = measVal,
incharge = UserData.username
};
listNewData.Add(insData);
UpdateGridNew();
//UpdateGridReg();
txtMeasureValue.ResetText();
txtMeasureValue.Focus();
}
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_data insData = new tbl_inspect_data();
int n = insData.AddMultiData(listNewData.ToList());
tbl_part_box boxData = new tbl_part_box();
if (boxData.Search(new tbl_part_box {
part_box_cd = listNewData[0].part_box_cd
}, false) > 0)
{
boxData = boxData.listBox[0];
if (string.IsNullOrEmpty(boxData.incharge))
{
boxData.incharge = UserData.username;
}
else if (!boxData.incharge.Contains(UserData.username))
{
boxData.incharge += "+" + UserData.username;
}
int m = insData.GetMaxQty(boxData.part_box_cd);
if (currNo < m)
{
currNo = m;
}
boxData.UpdateInchargeQty(boxData.part_box_cd, boxData.incharge, currNo);
}
CustomMessageBox.Notice("Added " + n + " item!" + Environment.NewLine + "Đăng ký " + n + " con hàng!");
currNo = 0;
listNewData.Clear();
btnRefresh.PerformClick();
txtMeasureValue.Focus();
}
catch (Exception ex)
{
CustomMessageBox.Error(ex.Message);
}
}
private void UpdateGridReg()
{
tbl_inspect_data insData = new tbl_inspect_data()
{
part_box_cd = txtBoxID.Text,
inspect_id = insID
};
insData.Search(insData);
maxNo = insData.GetMax(txtBoxID.Text, insID);
dgvRegMeasure.DataSource = insData.listData;
foreach (DataGridViewRow dr in dgvRegMeasure.Rows)
{
if (dr.Cells["judge"].Value.ToString() == "1")
{
dr.DefaultCellStyle.BackColor = Color.Red;
}
else
{
dr.DefaultCellStyle.BackColor = Color.White;
}
}
currNo = maxNo;
}
