public FormSATUAN(MASTER.FormSATUAN _frm, int Type, RMS.COMMON.MASTER.RMS_SATUAN obj) { InitializeComponent(); this.Type = Type; this.frm = _frm; if (Type == 1) { LOAD_DATA(obj); } }
void LOAD_DATA(RMS.COMMON.MASTER.RMS_SATUAN obj) { txtKODE.Enabled = false; DataTable dt = b.CARI_BYKODE(obj); if (dt.Rows.Count > 0) { txtKODE.Text = dt.Rows[0]["KODESATUAN"].ToString(); txtNAMA.Text = dt.Rows[0]["NAMASATUAN"].ToString(); txtISI.Text = dt.Rows[0]["ISI"].ToString(); } }
public void DELETE(RMS.COMMON.MASTER.RMS_SATUAN obj) { try { using (Database db = new Database()) { DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand(QUERY_DELETE)); db.Commands[0].Parameters.Add(new Parameter("@KODESATUAN", MySqlDbType.VarChar, obj.KODE)); dt = db.Commands[0].ExecuteDataTable(); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public DataTable SEARCH_BYNAMA(RMS.COMMON.MASTER.RMS_SATUAN obj) { DataTable dt = new DataTable(); try { using (Database db = new Database()) { db.Commands.Add(db.CreateCommand(QUERY_SEARCH_BYNAME)); db.Commands[0].Parameters.Add(new Parameter("@NAMASATUAN", MySqlDbType.VarChar, obj.NAMA)); dt = db.Commands[0].ExecuteDataTable(); } return(dt); } catch (Exception ex) { throw new Exception(ex.Message); } }
public DataTable SEARCH_BYNAMA(RMS.COMMON.MASTER.RMS_SATUAN obj) { return(p.SEARCH_BYNAMA(obj)); }
public DataTable CARI_BYNAMA(RMS.COMMON.MASTER.RMS_SATUAN obj) { return(p.CARI_BYNAMA(obj)); }
public void DELETE(RMS.COMMON.MASTER.RMS_SATUAN obj) { p.DELETE(obj); }
public void UPDATE(RMS.COMMON.MASTER.RMS_SATUAN obj) { p.UPDATE(obj); }
public void INSERT(RMS.COMMON.MASTER.RMS_SATUAN obj) { p.INSERT(obj); }
public void GETA_KODE_SATUAN(RMS.COMMON.MASTER.RMS_SATUAN obj) { txtUNIT.Text = obj.NAMA; txtISIUNIT.Text = obj.ISI.ToString(); }