public FormGUDANG(MASTER.FormGUDANG _frm, int Type, RMS.COMMON.MASTER.RMS_GUDANG obj) { InitializeComponent(); this.Type = Type; this.frm = _frm; if (Type == 1) { LOAD_DATA(obj); } }
void LOAD_DATA(RMS.COMMON.MASTER.RMS_GUDANG obj) { txtKODE.Enabled = false; DataTable dt = b.SEARCH_BYKODE(obj); if (dt.Rows.Count > 0) { txtKODE.Text = dt.Rows[0]["KODEGUDANG"].ToString(); txtNAMA.Text = dt.Rows[0]["NAMAGUDANG"].ToString(); txtKETERANGAN.Text = dt.Rows[0]["KETERANGAN"].ToString(); } }
public void DELETE(RMS.COMMON.MASTER.RMS_GUDANG 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("@KODEGUDANG", 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_GUDANG 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("@NAMAGUDANG", 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_GUDANG obj) { return(p.SEARCH_BYNAMA(obj)); }
public DataTable CARI_BYNAMA(RMS.COMMON.MASTER.RMS_GUDANG obj) { return(p.CARI_BYNAMA(obj)); }
public void DELETE(RMS.COMMON.MASTER.RMS_GUDANG obj) { p.DELETE(obj); }
public void UPDATE(RMS.COMMON.MASTER.RMS_GUDANG obj) { p.UPDATE(obj); }
public void INSERT(RMS.COMMON.MASTER.RMS_GUDANG obj) { p.INSERT(obj); }