private void txtId_Leave(object sender, EventArgs e)
{
if (txtId.Text.Trim().Length > 0)
{
this.UseWaitCursor = true;
try
{
string sql = String.Format("SELECT * FROM m_barang where id={0}", txtId.Text.Trim());
DataTable dt = MyUtil.ExecuteReader(sql);
if (dt.Rows.Count > 0)
{
flag = 1;//update
txtId.ReadOnly = true;
txtNama.Focus();
txtNama.Text = dt.Rows[0][1].ToString();
txtBeli.Text = MyUtil.GetFormatNumber(dt.Rows[0][2].ToString());
txtJual.Text = MyUtil.GetFormatNumber(dt.Rows[0][3].ToString());
txtSatuan.Text = dt.Rows[0][4].ToString();
txtBerat.Text = dt.Rows[0][5].ToString();
string unit = dt.Rows[0][6].ToString();
if (unit.ToLower() == "gram")
{
cboUnit.SelectedIndex = 0;
}
else
{
cboUnit.SelectedIndex = 1;
}
string gbr1 = dt.Rows[0][8].ToString();
txtGbr1.Text = (File.Exists(gbr1) || gbr1 == String.Empty) ? gbr1 : MyUtil.IMG_UPDATE;
string gbr2 = dt.Rows[0][9].ToString();
txtGbr2.Text = (File.Exists(gbr2) || gbr2 == String.Empty) ? gbr2 : MyUtil.IMG_UPDATE;
string gbr3 = dt.Rows[0][10].ToString();
txtGbr3.Text = (File.Exists(gbr3) || gbr3 == String.Empty) ? gbr3 : MyUtil.IMG_UPDATE;
string gbr4 = dt.Rows[0][11].ToString();
txtGbr4.Text = (File.Exists(gbr4) || gbr4 == String.Empty) ? gbr4 : MyUtil.IMG_UPDATE;
txtKet.Text = dt.Rows[0][7].ToString() + dt.Rows[0][12].ToString() + dt.Rows[0][13].ToString() + dt.Rows[0][14].ToString();
}
else
{
flag = 0;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error Find Id", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
this.UseWaitCursor = false;
}
}
private void txtBerat_Leave(object sender, EventArgs e)
{
txtBerat.Text = MyUtil.GetFormatNumber(txtBerat.Text);
}