public void Pengaturan()
{
if (isEdit == false)
{
Kontrol.EmptyText(this, tipeCBX);
kdObatTxt.Text = Kontrol.GenerateNumber("tbl_obat", "id_obat");
kdObatTxt.Enabled = true;
hargaJualTxt.Value = 0;
hargaPokokTxt.Value = 0;
selisihTXT.Value = 1;
marginTxt.Value = 1;
}
else
{
//Kontrol.EmptyText(this, tipeCBX);
kdObatTxt.Text = primaryKey;
kdObatTxt.Enabled = false;
crud.ExecuteQuery("SELECT Qty FROM tbl_konversi WHERE id_Item = '" + kdObatTxt.Text + "' AND isDefault = 0");
selisihTXT.Value = Convert.ToDecimal(crud.Dt.Rows[0]["Qty"]);
}
kdObatTxt.Focus();
crud.Dt = crud.Select("tbl_kategori", "kategori");
kategoriCBX.DataSource = crud.Dt;
kategoriCBX.DisplayMember = "kategori";
crud.Dt = crud.Select("tbl_tipe", "tipe");
tipeCBX.DataSource = crud.Dt;
tipeCBX.DisplayMember = "tipe";
crud.Dt = crud.Select("tbl_satuan", "satuan");
satuanStockCBX.DataSource = crud.Dt;
satuanStockCBX.DisplayMember = "satuan";
crud.Dt = crud.Select("tbl_satuan", "satuan");
satuanJualCBX.DataSource = crud.Dt;
satuanJualCBX.DisplayMember = "satuan";
}
private void SaveBtn_Click(object sender, EventArgs e)
{
crud.Dt = crud.ExecuteQuery("SELECT tgl_expired FROM tbl_obat_stock WHERE id_obat = '" + kdObatTxt.Text + "' AND tgl_expired = '" + expiredDT.Value.Date.ToString("yyyy-MM-dd") + "'");
if (crud.Dt.Rows.Count == 0)
{
if (isKosong)
{
crud.Delete("tbl_obat_stock", "id_obat ='" + kdObatTxt.Text + "'");
}
crud.Insert("tbl_obat_stock", "No = '" + setControl.GenerateNumber("tbl_obat_stock", "No") + "'," +
"id_obat = '" + kdObatTxt.Text + "'," +
"satuan_utama = '" + satuanUtamaTxt.Text + "'," +
"satuan_turunan = '" + satuanTurunanTxT.Text + "'," +
"stock_utama = '" + stockUtamaTxt.Text + "'," +
"stock_turunan = '" + stockTurunanTxt.Text + "'," +
"tgl_expired = '" + expiredDT.Value.Date.ToString("yyyy-MM-dd") + "'");
}
else
{
crud.ExecuteNonQuery("UPDATE tbl_obat_stock SET stock_utama = '" + stockUtamaTxt.Text + "'," +
"stock_turunan = '" + stockTurunanTxt.Text + "' WHERE id_obat = '" + kdObatTxt.Text + "' AND tgl_expired = '" + expiredDT.Value.Date.ToString("yyyy-MM-dd") + "'");
}
Pengaturan();
}
