public DataTable SELECTPEMB(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { DataTable dt = new DataTable(); try { using (Database db = new Database()) { /* * if (obj.STATUS == "SEMUA") * { * db.Commands.Add(db.CreateCommand(QUERY_SELECTPMBALL)); } * else * { * db.Commands.Add(db.CreateCommand(QUERY_SELECTPMB)); * } * db.Commands[0].Parameters.Add(new Parameter("@STARTDATE", MySqlDbType.Date, obj.STARTDATE)); * db.Commands[0].Parameters.Add(new Parameter("@ENDDATE", MySqlDbType.Date, obj.ENDDATE)); * db.Commands[0].Parameters.Add(new Parameter("@TPAYMENT", MySqlDbType.VarChar, obj.STATUSSTT)); * db.Commands[0].Parameters.Add(new Parameter("@STATUS", MySqlDbType.VarChar, obj.STATUS)); * dt = db.Commands[0].ExecuteDataTable(); */ } return(dt); } catch (Exception ex) { throw new Exception(ex.Message); } }
public DataTable SELECT(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { DataTable dt = new DataTable(); try { using (Database db = new Database()) { if (obj.STATUSORDER != "SEMUA") { db.Commands.Add(db.CreateCommand(QUERY_SELECT)); } else { db.Commands.Add(db.CreateCommand(QUERY_SELECTALL)); } db.Commands[0].Parameters.Add(new Parameter("@STARTDATE", MySqlDbType.Date, obj.STARTDATE)); db.Commands[0].Parameters.Add(new Parameter("@ENDDATE", MySqlDbType.Date, obj.ENDDATE)); db.Commands[0].Parameters.Add(new Parameter("@STATUSORDER", MySqlDbType.VarChar, obj.STATUSORDER)); dt = db.Commands[0].ExecuteDataTable(); } return(dt); } catch (Exception ex) { throw new Exception(ex.Message); } }
public DataTable SELECTGENERATEINVOICE(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { DataTable dt = new DataTable(); try { /* * using (Database db = new Database()) * { * * db.Commands.Add(db.CreateCommand(QUERY_SELECTGENEREATEINVOICE)); * db.Commands[0].Parameters.Add(new Parameter("@STARTDATE", MySqlDbType.Date, obj.STARTDATE)); * db.Commands[0].Parameters.Add(new Parameter("@ENDDATE", MySqlDbType.Date, obj.ENDDATE)); * db.Commands[0].Parameters.Add(new Parameter("@TPAYMENT", MySqlDbType.VarChar, obj.STATUSSTT)); * db.Commands[0].Parameters.Add(new Parameter("@CUSTOMER", MySqlDbType.VarChar, obj.NAMACUSTOMER)); * * dt = db.Commands[0].ExecuteDataTable(); * } * */ return(dt); } catch (Exception ex) { throw new Exception(ex.Message); } }
public DataTable SEARCH_BYNAMA(RMS.COMMON.EXPRESS.RMS_TRANSAKSI 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("@NAMACUSTOMER", MySqlDbType.VarChar, obj.NAMACUSTOMER)); * db.Commands[0].Parameters.Add(new Parameter("@STARTDATE", MySqlDbType.Date, obj.STARTDATE)); * db.Commands[0].Parameters.Add(new Parameter("@ENDDATE", MySqlDbType.Date, obj.ENDDATE)); * db.Commands[0].Parameters.Add(new Parameter("@TYPEOFPAYMENT", MySqlDbType.VarChar, obj.STATUSSTT)); * dt = db.Commands[0].ExecuteDataTable(); */ } return(dt); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void INSERT(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { try { using (Database db = new Database()) { DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand(QUERY_INSERT)); db.Commands[0].Parameters.Add(new Parameter("@NORESI", MySqlDbType.VarChar, obj.NORESI)); db.Commands[0].Parameters.Add(new Parameter("@IDCUSTOMER", MySqlDbType.Int32, obj.IDCUSTOMER)); db.Commands[0].Parameters.Add(new Parameter("@IDTARIF", MySqlDbType.Int32, obj.IDTARIF)); db.Commands[0].Parameters.Add(new Parameter("@IDPENERIMA", MySqlDbType.Int32, obj.IDPENERIMA)); db.Commands[0].Parameters.Add(new Parameter("@TGLTERIMA", MySqlDbType.VarChar, obj.TGLTERIMA)); db.Commands[0].Parameters.Add(new Parameter("@TGLESTIMASI", MySqlDbType.VarChar, obj.TGLESTIMASI)); db.Commands[0].Parameters.Add(new Parameter("@JUMLAH", MySqlDbType.Int32, obj.JUMLAH)); db.Commands[0].Parameters.Add(new Parameter("@BERAT", MySqlDbType.Float, obj.BERAT)); db.Commands[0].Parameters.Add(new Parameter("@KETERANGANISI", MySqlDbType.VarChar, obj.KETERANGANISI)); db.Commands[0].Parameters.Add(new Parameter("@INSTRUKSIKHUSUS", MySqlDbType.VarChar, obj.INSTRUKSIKHUSUS)); db.Commands[0].Parameters.Add(new Parameter("@DIM_P", MySqlDbType.Float, obj.DIM_P)); db.Commands[0].Parameters.Add(new Parameter("@DIM_L", MySqlDbType.Float, obj.DIM_L)); db.Commands[0].Parameters.Add(new Parameter("@DIM_T", MySqlDbType.Float, obj.DIM_T)); db.Commands[0].Parameters.Add(new Parameter("@RATE_KIRIM", MySqlDbType.Float, obj.RATE_KIRIM)); db.Commands[0].Parameters.Add(new Parameter("@CHARGE_KIRIM", MySqlDbType.Float, obj.CHARGE_KIRIM)); db.Commands[0].Parameters.Add(new Parameter("@PPNPERCENT", MySqlDbType.Float, obj.PPNPERCENT)); db.Commands[0].Parameters.Add(new Parameter("@PPN", MySqlDbType.Float, obj.PPN)); db.Commands[0].Parameters.Add(new Parameter("@CHARGE_PACKING", MySqlDbType.Float, obj.CHARGE_PACKING)); db.Commands[0].Parameters.Add(new Parameter("@OTHER_CHARGE", MySqlDbType.Float, obj.OTHER_CHARGE)); db.Commands[0].Parameters.Add(new Parameter("@DISCPERCENT", MySqlDbType.Float, obj.DISCPERCENT)); db.Commands[0].Parameters.Add(new Parameter("@DISC", MySqlDbType.Float, obj.DISC)); db.Commands[0].Parameters.Add(new Parameter("@INSURANCE", MySqlDbType.Float, obj.INCURANCE)); db.Commands[0].Parameters.Add(new Parameter("@INCURANCEPERCENT", MySqlDbType.Float, obj.INCURANCEPERCENT)); db.Commands[0].Parameters.Add(new Parameter("@NBARANGINSURANCE", MySqlDbType.Float, obj.NBARANGINSURANCE)); db.Commands[0].Parameters.Add(new Parameter("@TGLPENGIRIMAN", MySqlDbType.VarChar, obj.TGLPENGIRIMAN)); db.Commands[0].Parameters.Add(new Parameter("@TGLPENGAMBILAN", MySqlDbType.VarChar, obj.TGLPENGAMBILAN)); db.Commands[0].Parameters.Add(new Parameter("@TOTAL", MySqlDbType.Float, obj.TOTAL)); db.Commands[0].Parameters.Add(new Parameter("@BAYAR", MySqlDbType.Float, obj.BAYAR)); db.Commands[0].Parameters.Add(new Parameter("@SISA", MySqlDbType.Float, obj.SISA)); db.Commands[0].Parameters.Add(new Parameter("@VOID", MySqlDbType.Float, obj.VOID)); db.Commands[0].Parameters.Add(new Parameter("@STATUS", MySqlDbType.Int32, obj.STATUS)); db.Commands[0].Parameters.Add(new Parameter("@PENERIMABARANG", MySqlDbType.VarChar, obj.PENERIMABARANG)); db.Commands[0].Parameters.Add(new Parameter("@CREATED_BY", MySqlDbType.VarChar, "admin development")); db.Commands[0].Parameters.Add(new Parameter("@CREATED_AT", MySqlDbType.VarChar, null)); db.Commands[0].Parameters.Add(new Parameter("@UPDATED_BY", MySqlDbType.VarChar, null)); db.Commands[0].Parameters.Add(new Parameter("@UPDATED_AT", MySqlDbType.VarChar, null)); dt = db.Commands[0].ExecuteDataTable(); // http://www.c-sharpcorner.com/UploadFile/krishnasarala/generating-barcode-in-C-Sharp/ // ini referesi qr barcode } } catch (Exception ex) { throw new Exception(ex.Message); } }
public void DELETE(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { try { using (Database db = new Database()) { DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand(QUERY_DELETE)); dt = db.Commands[0].ExecuteDataTable(); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public DataTable CARI_BYNAMA(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { DataTable dt = new DataTable(); try { using (Database db = new Database()) { db.Commands.Add(db.CreateCommand(QUERY_CARI_BYNAME)); //db.Commands[0].Parameters.Add(new Parameter("@NAMASALES", MySqlDbType.VarChar, obj.NAMA)); dt = db.Commands[0].ExecuteDataTable(); } return(dt); } catch (Exception ex) { throw new Exception(ex.Message); } }
public DataTable SELECTKODEIVOICE(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { DataTable dt = new DataTable(); try { using (Database db = new Database()) { db.Commands.Add(db.CreateCommand(QUERY_SELECTKODEINVOICE)); // db.Commands[0].Parameters.Add(new Parameter("@KODEINVOICE", MySqlDbType.VarChar, obj.KODEIVOICE)); dt = db.Commands[0].ExecuteDataTable(); } return(dt); } catch (Exception ex) { throw new Exception(ex.Message); } }
public DataTable SELECTAGENTBYID(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { DataTable dt = new DataTable(); try { using (Database db = new Database()) { db.Commands.Add(db.CreateCommand(QUERY_SELECTAGENTBYID)); //db.Commands[0].Parameters.Add(new Parameter("@IDAGENT", MySqlDbType.Int32, obj.IDAGENT)); dt = db.Commands[0].ExecuteDataTable(); } return(dt); } catch (Exception ex) { throw new Exception(ex.Message); } }
public DataTable SELECTPMBINV(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { DataTable dt = new DataTable(); try { using (Database db = new Database()) { db.Commands.Add(db.CreateCommand(QUERY_SELECTPMBINV)); // db.Commands[0].Parameters.Add(new Parameter("@STARTDATE", MySqlDbType.Date, obj.STARTDATE)); //db.Commands[0].Parameters.Add(new Parameter("@ENDDATE", MySqlDbType.Date, obj.ENDDATE)); dt = db.Commands[0].ExecuteDataTable(); } return(dt); } catch (Exception ex) { throw new Exception(ex.Message); } }
public FormENTRYSO(EXPRESS.FormDAFTARSO _frm, int _Type, RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj, RMS.COMMON.MASTER.RMS_USER user) { InitializeComponent(); INIT_PERUSAHAAN(); frm = _frm; Type = _Type; if (Type == 0) { cboINSURANCE.Text = "0"; setDIM(); ptbASAL.Visible = false; ptbTUJUAN.Visible = false; txtNORESI.Text = GETKODE(); } else { c.ID = obj.ID; LOAD_DATA(obj); } SET_PRINT(); }
public DataTable SELECTLIKE(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { DataTable dt = new DataTable(); try { using (Database db = new Database()) { if (obj.STATUSORDER != "SEMUA") { db.Commands.Add(db.CreateCommand(QUERY_SELECTLIKE)); } else { db.Commands.Add(db.CreateCommand(QUERY_SELECTLIKEALL)); } /* * db.Commands[0].Parameters.Add(new Parameter("@STARTDATE", MySqlDbType.Date, obj.STARTDATE)); * db.Commands[0].Parameters.Add(new Parameter("@ENDDATE", MySqlDbType.Date, obj.ENDDATE)); * db.Commands[0].Parameters.Add(new Parameter("@TPAYMENT", MySqlDbType.VarChar, obj.STATUSSTT)); * db.Commands[0].Parameters.Add(new Parameter("@CUSTOMER", MySqlDbType.VarChar, obj.NAMACUSTOMER)); * db.Commands[0].Parameters.Add(new Parameter("@MARKETING", MySqlDbType.VarChar, obj.MARKETING)); * db.Commands[0].Parameters.Add(new Parameter("@STATUS", MySqlDbType.VarChar, obj.STATUSPEMBAYARAN)); * db.Commands[0].Parameters.Add(new Parameter("@SERVICE", MySqlDbType.VarChar, obj.SERVICE)); * db.Commands[0].Parameters.Add(new Parameter("@ARMADA", MySqlDbType.VarChar, obj.ARMADA)); * db.Commands[0].Parameters.Add(new Parameter("@DEST", MySqlDbType.VarChar, obj.NAMAKOTADEST)); */ dt = db.Commands[0].ExecuteDataTable(); } return(dt); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void UPDATE(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { p.UPDATE(obj); }
public void DELETE(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { p.DELETE(obj); }
public DataTable SELECTPMBINV(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { return(p.SELECTPMBINV(obj)); }
public DataTable SELECTINVOICECETAK(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { return(p.SELECTINVOICECETAK(obj)); }
public void INSERT(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { p.INSERT(obj); }
public DataTable SELECTAGENTBYID(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { return(p.SELECTAGENTBYID(obj)); }
public DataTable CARI_BYKODE(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { return(p.CARI_BYKODE(obj)); }
public DataTable SELECTFILTER(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { return(p.SELECTFILTER(obj)); }
public DataTable SELECTKODEINVOICE(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { return(p.SELECTKODEIVOICE(obj)); }
void LOAD_DATA(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { DataTable dt = b.CARI_BYID(obj); if (dt.Rows.Count > 0) { string TGLTERIMA, TGLETD; txtNORESI.Text = dt.Rows[0]["NORESI"].ToString(); checkIDTARIF = Convert.ToInt32(dt.Rows[0]["IDTARIF"].ToString()); c.IDTARIF = Convert.ToInt32(dt.Rows[0]["IDTARIF"].ToString()); txtSFROM.Text = dt.Rows[0]["KOTAASAL"].ToString(); txtSTO.Text = dt.Rows[0]["KOTATUJUAN"].ToString(); TGLTERIMA = dt.Rows[0]["TGLTERIMA"].ToString(); TGLETD = dt.Rows[0]["TGLESTIMASI"].ToString(); dtTGLMANIFEST.Value = DateTime.Parse(TGLTERIMA); dtETD.Value = DateTime.Parse(TGLETD); txtRATEKIRIM.Text = dt.Rows[0]["RATE_KIRIM"].ToString(); txtSWIGHT.Text = dt.Rows[0]["BERAT"].ToString(); txtPCS.Text = dt.Rows[0]["JUMLAH"].ToString(); txtPDIM.Text = dt.Rows[0]["DIM_P"].ToString(); txtLDIM.Text = dt.Rows[0]["DIM_L"].ToString(); txtTDIM.Text = dt.Rows[0]["DIM_T"].ToString(); if (txtPDIM.Text != "0") { chkISDIM.Checked = true; } txtWEIGHT.Text = dt.Rows[0]["BERAT"].ToString(); LOAD_TARIF(); // untuk mengetahui tarif yang digunakan sebelumnya c.IDCUSTOMER = Convert.ToInt32(dt.Rows[0]["IDCUSTOMER"].ToString()); txtKODECUSTOMER.Text = dt.Rows[0]["KODECUSTOMER"].ToString(); txtNAMACUSTOMER.Text = dt.Rows[0]["NAMACUSTOMER"].ToString(); // tambah disini mang txtALAMATPENGIRIM.Text = dt.Rows[0]["ALAMAT"].ToString(); txtPHONEPENGIRIM.Text = dt.Rows[0]["TELEPON"].ToString(); txtHPPENGIRIM.Text = dt.Rows[0]["HP"].ToString(); c.IDPENERIMA = Convert.ToInt32(dt.Rows[0]["IDPENERIMA"].ToString()); txtPENERIMA.Text = dt.Rows[0]["NAMAPENERIMA"].ToString(); txtPHONEPENERIMA.Text = dt.Rows[0]["TELEPONPENERIMA"].ToString(); txtFAXPENERIMA.Text = dt.Rows[0]["FAXPENERIMA"].ToString(); txtALAMAT.Text = dt.Rows[0]["ALAMATPENERIMA"].ToString(); // informasi other charge txtTOTALCHARGEKIRIM.Text = dt.Rows[0]["CHARGE_KIRIM"].ToString(); txtDISKONPERCENT.Text = dt.Rows[0]["DISCPERCENT"].ToString(); txtDISKON.Text = dt.Rows[0]["DISC"].ToString(); txtBAYAR.Text = dt.Rows[0]["BAYAR"].ToString(); // hitunga on change grandTOTAL txtPPNPercent.Text = dt.Rows[0]["PPNPERCENT"].ToString(); if (txtPPNPercent.Text != "0") { chkPPN.Checked = true; } txtCHARGEPPN.Text = dt.Rows[0]["PPN"].ToString(); cboINSURANCE.Text = dt.Rows[0]["INCURANCEPERCENT"].ToString(); txtCHARGEINSURANCE.Text = dt.Rows[0]["INSURANCE"].ToString(); txtNOMINALBARANG.Text = dt.Rows[0]["NBARANGINSURANCE"].ToString(); if (txtNOMINALBARANG.Text != "0") { chkPACKING.Checked = true; } txtCHARGEPACKING.Text = dt.Rows[0]["CHARGE_PACKING"].ToString(); // additional info pamantes lblFROM.Text = dt.Rows[0]["KOTAASAL"].ToString(); lblTO.Text = dt.Rows[0]["KOTATUJUAN"].ToString(); lblLAYANAN.Text = dt.Rows[0]["PRODUK"].ToString(); lblJENISKIRIMAN.Text = dt.Rows[0]["JENISKIRIMAN"].ToString(); // additional txtKETERANGANISI.Text = dt.Rows[0]["KETERANGANISI"].ToString(); txtINSTRUKSIKHUSUS.Text = dt.Rows[0]["INSTRUKSIKHUSUS"].ToString(); } }
public DataTable SEARCH_BYNAMA(RMS.COMMON.EXPRESS.RMS_TRANSAKSI obj) { return(p.SEARCH_BYNAMA(obj)); }