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(); }