/*ดึงรายการสินค้าจาก dialog แสดงรายการสินค้า*/
private void ProductAction(KeyEventArgs e)
{
if (txtProduct.Text != "" && e == null)
{
//ProductPut();
}
else if (e.KeyData == Keys.Enter && txtProduct.Text != "")
{
Dialog.frmDialogSearchProduct Product = new Dialog.frmDialogSearchProduct(txtProduct.Text);
Product.MultiCase = true;
Product.ShowDialog();
if (Product.DialogResult == System.Windows.Forms.DialogResult.OK)
{
foreach (DataGridViewRow r in Product.DgvOutputReturn.Rows)
{
//txtProduct.Text = "[" + Product.GetProductId() + "] " + Product.GetProductName();
txtProduct.Text = "[" + r.Cells[0].Value.ToString() + "] " + r.Cells[1].Value.ToString();
ProductPut();
}
}
txtProduct.Text = "";
}
}
private void BtnNew_Click(object sender, EventArgs e)
{
string ProductFind = TxtProductFind.Text.Trim();
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 = '" + ProductFind + "' ";
if (ProductFind != "")
{
sql += "OR ProductIdExternal = '" + ProductFind + "' OR ProductIdExternal2 = '" + ProductFind + "'";
}
DataSet ds = sqlquery(sql);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count != 0)
{
string 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();
DialogNewAddProduct(ProductId, ProductName, UnitPackName, UnitSaleName);
}
else
{
Dialog.frmDialogSearchProduct d = new Dialog.frmDialogSearchProduct(ProductFind);
d.ShowDialog();
if (d.DialogResult == DialogResult.OK)
{
string ProductId = d.DgvOutputReturn.Rows[0].Cells[0].Value.ToString();
string ProductName = d.DgvOutputReturn.Rows[0].Cells[1].Value.ToString();
string UnitPackName = d.DgvOutputReturn.Rows[0].Cells[4].Value.ToString();
string UnitSaleName = d.DgvOutputReturn.Rows[0].Cells[3].Value.ToString();
TxtProductFind.Text = ProductName;
DialogNewAddProduct(ProductId, ProductName, UnitPackName, UnitSaleName);
}
}
}
//เหตการณเมื่อป้อนข้อมูลลง TbxProductName ให้ตรวจว่ามีการกดแป้น Enter ไหม เพื่อเปิดไดอะลอกฟอร์มเพิ่มสิ้ค้าใหม่
private void TbxProductName_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Return)
{
Dialog.frmDialogSearchProduct d = new Dialog.frmDialogSearchProduct(TbxProductName.Text.Trim());
d.ShowDialog();
if (d.DialogResult == DialogResult.OK)
{
String ProductId = d.DgvOutputReturn.Rows[0].Cells[0].Value.ToString();
String ProductName = d.DgvOutputReturn.Rows[0].Cells[1].Value.ToString();
TbxProductId.Text = ProductId;
TbxProductName.Text = ProductName;
BtnAdd_Click(sender, e);
}
}
}