private void BtnAdd_Click(object sender, EventArgs e)
{
string ProductId = TxtProductId.Text.Trim();
if (ProductId == "")
{
MessageBox.Show("ไม่พบข้อมูล");
TxtProductId.Focus();
return;
}
string sql = "SELECT PRODUCT.ProductId, PRODUCT.ProductName, UNITPACK.UnitPackName, UNITSALE.UnitSaleName " +
"FROM PRODUCT INNER JOIN " +
"UNITPACK ON PRODUCT.UnitPackId = UNITPACK.UnitPackId INNER JOIN " +
"UNITSALE ON PRODUCT.UnitSaleId = UNITSALE.UnitSaleId " +
"WHERE PRODUCT.ProductId = '" + ProductId + "' OR ProductIdExternal = '" + ProductId + "' OR ProductIdExternal2 = '" + ProductId + "'";
DataSet ds = sqlquery(sql);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count == 0)
{
MessageBox.Show("ไม่พบข้อมูล");
TxtProductId.Focus();
TxtProductId.SelectAll();
return;
}
ProductId = dt.Rows[0][0].ToString();
string ProductName = dt.Rows[0][1].ToString();
string UnitPackName = dt.Rows[0][2].ToString();
string UnitSaleName = dt.Rows[0][3].ToString();
TxtProductName.Text = ProductName;
PreRecieve.DialogQuantity d = new PreRecieve.DialogQuantity();
d.LblProductId.Text = ProductId;
d.LblProductName.Text = ProductName;
d.LblUnitSale.Text = UnitSaleName + "/" + UnitPackName;
d.ShowDialog();
if (d.DialogResult == DialogResult.OK)
{
string Quantity = d.TxtQuantity.Text;
string Weight = d.TxtWeight.Text;
string[] row = new string[] { (LvDetail.Items.Count + 1) + "", ProductId, ProductName, Quantity, UnitSaleName + "/" + UnitPackName, Weight, UnitPackName, "" };
ListViewItem lvi = new ListViewItem(row);
LvDetail.Items.Add(lvi);
TxtProductId.Text = "";
TxtProductName.Text = "";
TxtProductId.Focus();
BtnEdit.Enabled = false;
BtnDelete.Enabled = false;
CalculateToSummary();
}
else
{
TxtProductId.Focus();
TxtProductId.SelectAll();
BtnEdit.Enabled = false;
BtnDelete.Enabled = false;
}
}
private void DialogNewAddProduct(string ProductId, string ProductName, string UnitPackName, string UnitSaleName)
{
PreRecieve.DialogQuantity d = new PreRecieve.DialogQuantity();
d.LblProductId.Text = ProductId;
d.LblProductName.Text = ProductName;
d.LblUnitSale.Text = UnitSaleName + "/" + UnitPackName;
d.ShowDialog();
if (d.DialogResult == DialogResult.OK)
{
string PackingId = "รอสร้าง";
string Quantity = d.TxtQuantity.Text;
string Weight = d.TxtWeight.Text;
string[] str = new string[] { (LvDetailPacking2.Items.Count + 1) + "", PackingId, ProductId, ProductName, Quantity, UnitSaleName + "/" + UnitPackName, Weight, "-1" };
ListViewItem lvi = new ListViewItem(str);
LvDetailPacking2.Items.Add(lvi);
TxtProductFind.Text = "";
TxtProductFind.Focus();
CalculateAddToLvDetail2();
}
else
{
TxtProductFind.Focus();
TxtProductFind.SelectAll();
}
}
private void BtnEdit_Click(object sender, EventArgs e)
{
if (TxtProductId.Text.Trim() == "" && TxtProductName.Text.Trim() == "" || LvDetail.SelectedItems.Count <= 0)
{
MessageBox.Show("กรุณาเลือกรายการที่ต้องการแก้ไข", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
String ProductId = LvDetail.SelectedItems[0].SubItems[1].Text.ToString();
String ProductName = LvDetail.SelectedItems[0].SubItems[2].Text.ToString();
String Quantity = LvDetail.SelectedItems[0].SubItems[3].Text.ToString();
String UnitSaleNameAndPack = LvDetail.SelectedItems[0].SubItems[4].Text.ToString();
String Weight = LvDetail.SelectedItems[0].SubItems[5].Text.ToString();
PreRecieve.DialogQuantity d = new PreRecieve.DialogQuantity();
d.LblProductId.Text = ProductId;
d.LblProductName.Text = ProductName;
d.TxtQuantity.Text = Quantity;
d.LblUnitSale.Text = UnitSaleNameAndPack;
d.TxtWeight.Text = Weight;
d.ShowDialog();
if (d.DialogResult == DialogResult.OK)
{
Quantity = d.TxtQuantity.Text;
Weight = d.TxtWeight.Text;
LvDetail.SelectedItems[0].SubItems[3].Text = Quantity;
LvDetail.SelectedItems[0].SubItems[5].Text = Weight;
TxtProductId.Text = "";
TxtProductName.Text = "";
TxtProductId.Focus();
BtnEdit.Enabled = false;
BtnDelete.Enabled = false;
CalculateToSummary();
}
else
{
TxtProductId.Focus();
TxtProductId.SelectAll();
BtnEdit.Enabled = false;
BtnDelete.Enabled = false;
}
}
