private void deleteBtn_Click(object sender, EventArgs e) { var pesan = MessageBox.Show("Apakah Anda Yakin Ingin Menghapus ? ", "Penghapusan", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation); if (pesan == DialogResult.Yes) { foreach (DataGridViewRow row in dataGridView1.SelectedRows) { valueFromDG += row.Cells[0].Value + ","; idObat += row.Cells[1].Value + ","; } string[] valuesDG = valueFromDG.Split(','); string[] idObats = idObat.Split(','); //int counter; for (byte i = 0; i < valuesDG.Count(); i++) { crud.Dt = crud.ExecuteQuery("SELECT id_obat FROM tbl_obat_stock WHERE id_obat = '" + idObats[i] + "'"); if (crud.Dt.Rows.Count == 1) { crud.Update("tbl_obat_stock", "stock_utama = '0', stock_turunan = '0'", "id_obat = '" + idObats[i] + "'"); } else { crud.Delete("tbl_obat_stock", "no = '" + valuesDG[i] + "'"); } } MessageBox.Show(valueFromDG); valueFromDG = null; recordLoad(); } }
private void toolStripButton4_Click(object sender, EventArgs e) { var pesan = MessageBox.Show("Apakah Anda Yakin Ingin Menghapus ? ", "Penghapusan", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation); if (pesan == DialogResult.Yes) { foreach (DataGridViewRow row in dataGridView1.SelectedRows) { crud.Dt = crud.ExecuteQuery("SELECT distinct stock_utama, stock_turunan FROM tbl_obat_stock WHERE id_obat = '" + row.Cells[0].Value.ToString() + "' ORDER BY tgl_expired ASC"); if (crud.Dt.Rows.Count > 0) { decimal stockUtama = Convert.ToDecimal(crud.Dt.Rows[0]["stock_utama"]); decimal stockTurunan = Convert.ToDecimal(crud.Dt.Rows[0]["stock_turunan"]); if (stockUtama == 0 && stockTurunan == 0) { crud.Delete("tbl_obat", "id_obat ='" + row.Cells[0].Value.ToString() + "'"); crud.Delete("tbl_konversi", "id_item ='" + row.Cells[0].Value.ToString() + "'"); crud.Delete("tbl_obat_stock", "id_obat ='" + row.Cells[0].Value.ToString() + "'"); // MessageBox.Show(crud.Dt.Rows[0]["stock_utama"].ToString() + crud.Dt.Rows[0]["stock_turunan"].ToString()); } else { MessageBox.Show("Terdapat Stock Dalam Tabel, Pastikan Stock sudah kosong !", "Error Penghapusan", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } BgWorkerDoWork(); } }
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 FrmStock_Load(object sender, EventArgs e) { crud.Dt = crud.ExecuteQuery("SELECT merek,nama_obat FROM tbl_obat WHERE id_obat = '" + kdObatTxt.Text + "' "); merekTxt.Text = crud.Dt.Rows[0]["merek"].ToString(); nmObatTxt.Text = crud.Dt.Rows[0]["nama_obat"].ToString(); }