private void toolStripButton1_Click(object sender, EventArgs e) { Transf.TranferRequisition frm = new TranferRequisition(stock); frm.ShowDialog(); if (frm.DialogResult == DialogResult.OK) { toolStripButton2_Click(sender,e); } }
public TranferAddReq(String type, String id, String tw, String qtyp, String qty,String gid,String price) { ID = id; Type = type; Qty = qty; InitializeComponent(); Class.clsDatabase cls = null; DataTable dt = null; String sql = "select p.productid,p.productname,u.unitpackname,us.unitsalename from product p left join unitpack u on p.unitpackid = u.unitpackid " + "left join unitsale us on p.unitsaleid = us.unitsaleid where p.productid = '" + id + "'"; try { String local = "select * from GrStockDetail where GrStockDetailId = '" + gid + "'"; DataRow d = Class.DBConnString.clsDB.QueryDataTable(local).Rows[0]; if (Class.DBConnString.clsDB.QueryDataTable(local).Rows.Count > 0) { cls = new Class.clsDatabase(d["ip"].ToString(), d["db"].ToString(), d["dbuser"].ToString(), d["dbpass"].ToString(), ""); dt = cls.QueryDataTable(sql); } else { dt = Class.DBConnString.clsDB.QueryDataTable(sql); } } catch { if (Class.DBConnString.sDb == "SHOPFR") { DBConnString.strConn = "Data Source=192.168.0.3;Initial Catalog=SHOP; Persist Security Info=True;User ID=KTCNET;Password=khu@9wbe"; DBConnString.sServer = "192.168.0.3"; DBConnString.clsDB = new clsDatabase(DBConnString.strConn, DBConnString.sServer); } dt = Class.DBConnString.clsDB.QueryDataTable(sql); } DataTable dtNew = dt; foreach (DataRow row in dtNew.Rows) { TxtProductId.Text = row["ProductId"].ToString(); TxtProductName.Text = row["ProductName"].ToString(); lblSale1.Text = row["UnitSaleName"].ToString(); lblPack.Text = row["UnitPackName"].ToString(); } this.Text = "หน้าจอเพิ่มรายการเบิกโอนสินค้า"; if (Type == "1") { dgvWeight.ColumnCount = 3; TranferRequisition f = new TranferRequisition(); f.SetDgvWeightH(tw, dgvWeight, Type); txtSale.Text = CellSum(1).ToString(); txtWeight.Text = CellSum(2).ToString(); if (Class.DBConnString.sDb != "SHOP" || Class.DBConnString.sDb != "SHOPFR") { textBox1.Text = price; } } if (Type == "2") { dgvWeight.ColumnCount = 2; TranferRequisition f = new TranferRequisition(); f.SetDgvWeightH(tw, dgvWeight, Type); txtSale.Text = CellSum(1).ToString(); txtWeight.Text = "0"; if (Class.DBConnString.sDb != "SHOP" || Class.DBConnString.sDb != "SHOPFR") { textBox1.Text = price; } } if (Type == "3") { dgvWeight.ColumnCount = 2; txtPack.Text = qtyp; txtSale.Text = qty; 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 (Class.DBConnString.sDb != "SHOP" || Class.DBConnString.sDb != "SHOPFR") { textBox1.Text = price; } } }