private void btnSearchPVC_Click(object sender, EventArgs e)
{
Master.PVC.SearchPVC searchPVC = new Master.PVC.SearchPVC(main);
DialogResult result = searchPVC.ShowDialog();
if (result == System.Windows.Forms.DialogResult.OK)
{
pvcID = main.globalPVCID;
DataTable dt = ExecuteQuery("SELECT pvcName, pvcPerPack, pvcTypeUnit, sellPrice FROM MsPVC WHERE pvcID = " + pvcID + "");
if (dt != null)
{
if (dt.Rows.Count == 1)
{
tbNamaPVC.Text = dt.Rows[0]["pvcName"].ToString();
nudPerPack.Value = Decimal.Parse(dt.Rows[0]["pvcPerPack"].ToString());
LblPVCType.Text = dt.Rows[0]["pvcTypeUnit"].ToString();
nudPrice.Value = Int32.Parse(dt.Rows[0]["sellPrice"].ToString());
nudPack.Value = 0;
nudQty.Value = 0;
nudTotal.Value = 0;
nudTotalQty.Value = 0;
nudPack.Focus();
nudPack.Select(0, 9);
}
}
}
}
private void btnSearchPVC_Click(object sender, EventArgs e)
{
Master.PVC.SearchPVC searchPVC = new Master.PVC.SearchPVC(main);
DialogResult result = searchPVC.ShowDialog();
if (result == System.Windows.Forms.DialogResult.OK)
{
pvcID = main.globalPVCID;
DataTable dt = ExecuteQuery("SELECT * FROM MsPVC WHERE pvcID = '" + pvcID + "'");
tbNamaPVC.Text = dt.Rows[0]["pvcName"].ToString();
nudPack.Value = 0;
nudQty.Value = 0;
nudPerPack.Value = Decimal.Parse(dt.Rows[0]["pvcPerPack"].ToString());
LblPVCType.Text = dt.Rows[0]["pvcTypeUnit"].ToString();
}
}
