public void recordLoad()
{
SetDataGrid dgSet = new SetDataGrid();
dataGridView1.DataSource = crud.Select("tbl_satuan", "id_satuan, satuan");
// dgSet.CreateHeader(dataGridView1, 0, "Satuan","200");
}
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";
}
public void recordLoad()
{
crud.Dt = crud.Select("tbl_obat_stock", "no, id_obat, stock_utama, satuan_utama, stock_turunan, satuan_turunan, tgl_expired");
}
private void recordLoad()
{
crud.Dt = crud.Select("tbl_tipe", "id_tipe,tipe,keterangan");
dataGridView1.DataSource = crud.Dt;
setCGrid.CreateHeader(dataGridView1, 2, "ID Tipe, Tipe, Keterangan", "75,100,168");
}
public void recordLoad()
{
crud.Dt = crud.Select("tbl_obat", "*");
}
private void refreshGrid()
{
CRUD crud = new CRUD();
dataGridView1.DataSource = crud.Select("table_admin", "*");
}
private void recordLoad()
{
dataGridView1.DataSource = crud.Select("tbl_kategori", "*");
}
