/*ปุ่มเพิ่มใบรับสินค้าตามใบสั่งซื้อ*/
private void addReceive_Click(object sender, EventArgs e)
{
receive.FrmNewReceive frm = new FrmNewReceive();
//frm.MdiParent = this.MdiParent;
frm.ShowDialog();
//frm.WindowState = FormWindowState.Maximized;
if (frm.DialogResult == DialogResult.OK) {
FindSearch();
}
}
//public frmAddReceive(String head,String price, String poDetailid, String Type, String tw, String d, String p, String s, Double sum,String dpu,String dist,String t)
//{
// head2 = head;
// poDetailid2 = poDetailid;
// InitializeComponent();
// String sql = "SELECT pod.PurchaseOrderDetailId,pod.ProductId, CASE when pod.ProductId = '0000000000-00' then pod.ProductNameWait " +
// "ELSE p.ProductName END AS ProductName ,(pod.Quantity) as q," +
// "CASE when ISNULL((SELECT sum(ReceiveDetailQuantity) FROM Receive_Detail Where PurchaseOrderDetailId = " + poDetailid + " And ReceiveHeadId = " + head + "),0) != 0 " +
// "THEN pod.Quantity -((select isnull(sum(ReceiveDetailQuantity),0) FROM Receive_Detail " +
// "Where PurchaseOrderDetailId = " + poDetailid + ") - (SELECT isnull(sum(ReceiveDetailQuantity),0) FROM Receive_Detail " +
// "Where PurchaseOrderDetailId = " + poDetailid + " And ReceiveHeadId = " + head + ")) - " + sum + " " +
// "ELSE " +
// "pod.Quantity -((select isnull(sum(ReceiveDetailQuantity),0) FROM Receive_Detail Where PurchaseOrderDetailId = " + poDetailid + ") - 0) END as Quantity , " +
// "'' AS Qpack,up.UnitPackName,'' AS Qsale,us.UnitSaleName,pod.PricePerUnit,pod.DisText,isnull(pod.DisPerUnit,0) as DisPerUnit, " +
// "pod.Dis,'' AS Total,po.PurchaseOrderId " +
// "from PurchaseOrderDetail pod INNER JOIN PRODUCT p " +
// "ON pod.ProductId = p.ProductId INNER JOIN UNITPACK up " +
// "ON p.UnitPackId = up.UnitPackId INNER JOIN UNITSALE us " +
// "ON p.UnitSaleId = us.UnitSaleId INNER JOIN PurchaseOrder po " +
// "ON po.PurchaseOrderId = pod.PurchaseOrderId " +
// "where pod.PurchaseOrderDetailId = " + poDetailid;
// DataTable dtNew = Class.DBConnString.clsDB.QueryDataTable(sql);
// String sql2 = "select * from receive_detail where ReceiveHeadId = '" + head + "' and PurchaseOrderDetailId = " + poDetailid;
// DataTable dtNew2 = Class.DBConnString.clsDB.QueryDataTable(sql2);
// foreach (DataRow row in dtNew2.Rows)
// {
// txtPrice.Text = String.Format("{0:0,0.00}",Convert.ToDouble(row["ReceiveDetailPriceUnit"].ToString()));
// }
// foreach (DataRow row in dtNew.Rows)
// {
// TxtProductId.Text = row["ProductId"].ToString();
// TxtProductName.Text = row["ProductName"].ToString();
// txtQReceive.Text = row["Quantity"].ToString();
// if(price+"" != ""){
// txtPrice.Text = String.Format("{0:0,0.00}",Convert.ToDouble(price));
// }
// TxtPerDiscount.Text = row["DisText"].ToString();
// Disper = Convert.ToDouble(row["DisPerUnit"]);
// Discount = Convert.ToDouble(row["Dis"]);
// DisperUnit.Text = Convert.ToDouble(row["DisPerUnit"]).ToString();
// QuantityAll = Convert.ToDouble(row["q"]);
// lblSale.Text = row["UnitSaleName"].ToString();
// lblSale1.Text = lblSale.Text;
// lblPack.Text = row["UnitPackName"].ToString();
// if (dist + "" != "") {
// TxtPerDiscount.Text = dist;
// }
// }
// this.Text = "หน้าจอเพิ่มรายการรับสินค้า";
// type = Type;
// if (Type == "1")
// {
// dgvWeight.ColumnCount = 3;
// FrmNewReceive f = new FrmNewReceive();
// f.SetDgvWeight(tw, dgvWeight, Type);
// txtSale.Text = CellSum(1).ToString();
// txtWeight.Text = CellSum(2).ToString();
// }
// if (Type == "2")
// {
// dgvWeight.ColumnCount = 2;
// FrmNewReceive f = new FrmNewReceive();
// f.SetDgvWeight(tw, dgvWeight, Type);
// txtSale.Text = CellSum(1).ToString();
// txtWeight.Text = "0";
// }
// if (Type == "3")
// {
// dgvWeight.ColumnCount = 2;
// txtPack.Text = p;
// txtSale.Text = s;
// dgvWeight.Visible = false;
// txtPack.Enabled = true; txtPack.BackColor = Color.White;
// txtSale.Enabled = true; txtSale.BackColor = Color.White;
// btnAdd.Enabled = false;
// btnDel.Enabled = false;
// txtRunPack.Enabled = false;
// txtWeight.Text = "0";
// txtPack.Focus();
// txtPack.SelectAll();
// }
// if (d != "")
// {
// TxtDiscount.Text = String.Format("{0:0,0.00}",d);
// }
// if (dpu != "") {
// DisperUnit.Text = String.Format("{0:0,0.00}",dpu);
// }
// txtTrans.Text = String.Format("{0:0,0.00}", t);
//}
public frmAddReceive(String head, String price, String poDetailid, String Type, String tw, String d, String p, String s, Double sum, String dpu, String dist, String t)
{
head2 = head;
poDetailid2 = poDetailid;
InitializeComponent();
String sql = "SELECT pod.PurchaseOrderDetailId,pod.ProductId, CASE when pod.ProductId = '0000000000-00' then pod.ProductNameWait " +
"ELSE p.ProductName END AS ProductName ,(pod.Quantity) as q," +
"CASE when ISNULL((SELECT sum(ReceiveDetailQuantity) FROM Receive_Detail Where PurchaseOrderDetailId = " + poDetailid + " And ReceiveHeadId = " + head + "),0) "+
"+ ISNULL((SELECT sum(OutsideStockDetail_Quantity) FROM OUTSIDE_STOCK_DETAIL Where PurchaseOrderDetailId = " + poDetailid + " And OutsideStockHeadId = " + head + "),0) " +
" != 0 " +
"THEN pod.Quantity -(((select isnull(sum(ReceiveDetailQuantity),0) FROM Receive_Detail " +
"Where PurchaseOrderDetailId = " + poDetailid + ") - (SELECT isnull(sum(ReceiveDetailQuantity),0) FROM Receive_Detail " +
"Where PurchaseOrderDetailId = " + poDetailid + " And ReceiveHeadId = " + head + ")) + "+
"((select isnull(sum(OutsideStockDetail_Quantity),0) FROM OUTSIDE_STOCK_DETAIL " +
"Where PurchaseOrderDetailId = " + poDetailid + ") - (SELECT isnull(sum(OutsideStockDetail_Quantity),0) FROM OUTSIDE_STOCK_DETAIL " +
"Where PurchaseOrderDetailId = " + poDetailid + " And OutsideStockHeadId = " + head + "))" +
") - " + sum + " " +
"ELSE " +
"pod.Quantity -(((select isnull(sum(ReceiveDetailQuantity),0) FROM Receive_Detail Where PurchaseOrderDetailId = " + poDetailid + ") - 0) + "+
"((select isnull(sum(OutsideStockDetail_Quantity),0) FROM OUTSIDE_STOCK_DETAIL Where PurchaseOrderDetailId = " + poDetailid + ") - 0) " +
") END as Quantity , " +
"'' AS Qpack,up.UnitPackName,'' AS Qsale,us.UnitSaleName,pod.PricePerUnit,pod.DisText,isnull(pod.DisPerUnit,0) as DisPerUnit, " +
"pod.Dis,'' AS Total,po.PurchaseOrderId " +
"from PurchaseOrderDetail pod INNER JOIN PRODUCT p " +
"ON pod.ProductId = p.ProductId INNER JOIN UNITPACK up " +
"ON p.UnitPackId = up.UnitPackId INNER JOIN UNITSALE us " +
"ON p.UnitSaleId = us.UnitSaleId INNER JOIN PurchaseOrder po " +
"ON po.PurchaseOrderId = pod.PurchaseOrderId " +
"where pod.PurchaseOrderDetailId = " + poDetailid;
DataTable dtNew = Class.DBConnString.clsDB.QueryDataTable(sql);
String sql2 = "select * from receive_detail where ReceiveHeadId = '" + head + "' and PurchaseOrderDetailId = " + poDetailid;
DataTable dtNew2 = Class.DBConnString.clsDB.QueryDataTable(sql2);
foreach (DataRow row in dtNew2.Rows)
{
txtPrice.Text = String.Format("{0:0,0.000000}", Convert.ToDouble(row["ReceiveDetailPriceUnit"].ToString()));
}
foreach (DataRow row in dtNew.Rows)
{
TxtProductId.Text = row["ProductId"].ToString();
TxtProductName.Text = row["ProductName"].ToString();
txtQReceive.Text = Convert.ToDouble(row["Quantity"]).ToString("#,##0.00");
if (price + "" != "")
{
txtPrice.Text = String.Format("{0:0,0.000000}", Convert.ToDouble(price));
}
TxtPerDiscount.Text = row["DisText"].ToString();
Disper = Convert.ToDouble(row["DisPerUnit"]);
Discount = Convert.ToDouble(row["Dis"]);
DisperUnit.Text = Convert.ToDouble(row["DisPerUnit"]).ToString();
QuantityAll = Convert.ToDouble(row["q"]);
lblSale.Text = row["UnitSaleName"].ToString();
lblSale1.Text = lblSale.Text;
lblPack.Text = row["UnitPackName"].ToString();
if (dist + "" != "")
{
TxtPerDiscount.Text = dist;
}
}
this.Text = "หน้าจอเพิ่มรายการรับสินค้า";
type = Type;
if (Type == "1")
{
dgvWeight.ColumnCount = 3;
FrmNewReceive f = new FrmNewReceive();
f.SetDgvWeight(tw, dgvWeight, Type);
txtSale.Text = CellSum(1).ToString();
txtWeight.Text = CellSum(2).ToString();
}
if (Type == "2")
{
dgvWeight.ColumnCount = 2;
FrmNewReceive f = new FrmNewReceive();
f.SetDgvWeight(tw, dgvWeight, Type);
txtSale.Text = CellSum(1).ToString();
txtWeight.Text = "0";
}
if (Type == "3")
{
dgvWeight.ColumnCount = 2;
txtPack.Text = p;
txtSale.Text = s;
dgvWeight.Visible = false;
txtPack.Enabled = true; txtPack.BackColor = Color.White;
txtSale.Enabled = true; txtSale.BackColor = Color.White;
btnAdd.Enabled = false;
btnDel.Enabled = false;
txtRunPack.Enabled = false;
txtWeight.Text = "0";
txtPack.Focus();
txtPack.SelectAll();
}
if (d != "")
{
TxtDiscount.Text = String.Format("{0:0,0.00}", d);
}
if (dpu != "")
{
DisperUnit.Text = String.Format("{0:0,0.00}", dpu);
}
txtTrans.Text = String.Format("{0:0,0.00}", t);
}
private void NewrecieveMenu_Click(object sender, EventArgs e)
{
receive.FrmNewReceive frmNewRecieve = new receive.FrmNewReceive();
frmNewRecieve.MdiParent = this;
frmNewRecieve.Show();
frmNewRecieve.WindowState = FormWindowState.Maximized;
}