private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
foreach (DataGridViewRow d in dataGridView1.SelectedRows)
{
if (d.Cells["confirmName"].Value.ToString() == "อนุมัติ")
{
return;
}
}
Transf.TranferCreate c = new TranferCreate(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(), dataGridView1.CurrentRow.Cells["TranferSource"].Value.ToString());
c.ShowDialog();
if (c.DialogResult == DialogResult.OK)
{
loadGridHd();
}
}
private void toolStripButton1_Click(object sender, EventArgs e)
{
Transf.TranferCreate c = new TranferCreate();
c.ShowDialog();
if (c.DialogResult == DialogResult.OK) {
loadGridHd();
}
}
public TranferAdd(String type, String id, String tw, String qtyp, String qty,String gid)
{
ID = id;
Type = type;
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 { 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;
TranferCreate f = new TranferCreate();
f.SetDgvWeightH(tw, dgvWeight, Type);
txtSale.Text = CellSum(1).ToString();
txtWeight.Text = CellSum(2).ToString();
}
if (Type == "2")
{
dgvWeight.ColumnCount = 2;
TranferCreate f = new TranferCreate();
f.SetDgvWeightH(tw, dgvWeight, Type);
txtSale.Text = CellSum(1).ToString();
txtWeight.Text = "0";
}
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();
}
}
