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