public DataTable SELECTGENERATEINVOICE(RMS.COMMON.EXPRESS.RMS_SPJ 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); } }
void LOAD_DATA(RMS.COMMON.EXPRESS.RMS_SPJ obj) { DataTable dt = b.CARI_BYID(obj); if (dt.Rows.Count > 0) { string TGLPENGIRIMAN; c.IDKENDARAAN = Convert.ToInt32(dt.Rows[0]["IDKENDARAAN"].ToString()); txtSPJ.Text = dt.Rows[0]["NOSPJ"].ToString(); TGLPENGIRIMAN = dt.Rows[0]["TGLPENGIRIMAN"].ToString(); dtTGLKIRIM.Value = DateTime.Parse(TGLPENGIRIMAN); txtNOPOL.Text = dt.Rows[0]["NOPOL"].ToString(); txtJENISKENDARAAN.Text = dt.Rows[0]["JENISKENDARAAN"].ToString(); txtMAXMUATAN.Text = dt.Rows[0]["MAXMUATAN"].ToString(); txtMAXVOLUME.Text = dt.Rows[0]["MAXVOLUME"].ToString(); if (!string.IsNullOrEmpty(dt.Rows[0]["IDDRIVER"].ToString())) { c.IDDRIVER = Convert.ToInt32(dt.Rows[0]["IDDRIVER"].ToString()); } if (!string.IsNullOrEmpty(dt.Rows[0]["IDCODRIVER"].ToString())) { c.IDCODRIVER = Convert.ToInt32(dt.Rows[0]["IDCODRIVER"].ToString()); } txtKODEDRIVER.Text = dt.Rows[0]["KODEDRIVER"].ToString(); txtKODEHELPER.Text = dt.Rows[0]["KODEHELPER"].ToString(); txtNAMADRIVER.Text = dt.Rows[0]["NAMADRIVER"].ToString(); txtNAMAHELPER.Text = dt.Rows[0]["NAMAHELPER"].ToString(); } }
public DataTable SELECTPEMB(RMS.COMMON.EXPRESS.RMS_SPJ 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 SEARCH_BYNAMA(RMS.COMMON.EXPRESS.RMS_SPJ 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 FormVIEWMISSROUTE(EXPRESS.FormENTRYPENGIRIMANBARANG _frm, RMS.COMMON.EXPRESS.RMS_SPJ spj, int _Type) { InitializeComponent(); this.Type = _Type; //txtNORESI.Text = GETKODE(); c = spj; txtNORESI.ReadOnly = true; txtNORESI.Text = c.NORESI; this.frm = _frm; LOAD_DATA(c); }
public void DELETE(RMS.COMMON.EXPRESS.RMS_SPJ 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("@IDDETAIL", MySqlDbType.Int32, obj.IDDETAIL)); dt = db.Commands[0].ExecuteDataTable(); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public void UPDATESTATUSPENGIRIMAN(RMS.COMMON.EXPRESS.RMS_SPJ obj) { try { using (Database db = new Database()) { DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand(QUERY_UPDATESTATUSPENGIRIMAN)); db.Commands[0].Parameters.Add(new Parameter("@NORESI", MySqlDbType.VarChar, obj.NORESI)); db.Commands[0].Parameters.Add(new Parameter("@STATUS", MySqlDbType.Int32, obj.STATUS)); dt = db.Commands[0].ExecuteDataTable(); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public DataTable SELECTKODEIVOICE(RMS.COMMON.EXPRESS.RMS_SPJ 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_SPJ 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 FormENTRYPENGIRIMANBARANG(EXPRESS.FormDAFTARPENGIRIMANBARANG _frm, int _Type, RMS.COMMON.EXPRESS.RMS_SPJ obj, RMS.COMMON.MASTER.RMS_USER user) { InitializeComponent(); frm = _frm; Type = _Type; if (Type == 0) { txtSPJ.Text = GETKODE(); } else { // update coy c.ID = obj.ID; INIT_PERUSAHAAN(); LOAD_DATA(obj); LOAD_DETAIL(); } }
public DataTable CARI_BYNAMA(RMS.COMMON.EXPRESS.RMS_SPJ 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 SELECTLIKE(RMS.COMMON.EXPRESS.RMS_SPJ obj) { DataTable dt = new DataTable(); try { using (Database db = new Database()) { db.Commands.Add(db.CreateCommand(QUERY_SELECTRESI)); 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 void INSERTRESI(RMS.COMMON.EXPRESS.RMS_SPJ obj) { try { using (Database db = new Database()) { DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand(QUERY_INSERTRESI)); db.Commands[0].Parameters.Add(new Parameter("@NOSPJ", MySqlDbType.VarChar, obj.NOSPJ)); db.Commands[0].Parameters.Add(new Parameter("@NORESI", MySqlDbType.VarChar, obj.NORESI)); dt = db.Commands[0].ExecuteDataTable(); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public void INSERT(RMS.COMMON.EXPRESS.RMS_SPJ 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("@NOSPJ", MySqlDbType.VarChar, obj.NOSPJ)); db.Commands[0].Parameters.Add(new Parameter("@IDKENDARAAN", MySqlDbType.Int32, obj.IDKENDARAAN)); if (obj.IDDRIVER != 0) { db.Commands[0].Parameters.Add(new Parameter("@IDDRIVER", MySqlDbType.Int32, obj.IDDRIVER)); } else { db.Commands[0].Parameters.Add(new Parameter("@IDDRIVER", MySqlDbType.Int32, null)); } if (obj.IDCODRIVER != 0) { db.Commands[0].Parameters.Add(new Parameter("@IDCODRIVER", MySqlDbType.Int32, obj.IDCODRIVER)); } else { db.Commands[0].Parameters.Add(new Parameter("@IDCODRIVER", MySqlDbType.Int32, null)); } db.Commands[0].Parameters.Add(new Parameter("@TGLPENGIRIMAN", MySqlDbType.VarChar, obj.TGLPENGIRIMAN)); 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(); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public DataTable SELECTFILTER(RMS.COMMON.EXPRESS.RMS_SPJ obj) { return(p.SELECTFILTER(obj)); }
public DataTable SELECTINVOICECETAK(RMS.COMMON.EXPRESS.RMS_SPJ obj) { return(p.SELECTINVOICECETAK(obj)); }
public DataTable SELECTGENERATEINVOICE(RMS.COMMON.EXPRESS.RMS_SPJ obj) { return(p.SELECTGENERATEINVOICE(obj)); }
public DataTable SELECTPMBINV(RMS.COMMON.EXPRESS.RMS_SPJ obj) { return(p.SELECTPMBINV(obj)); }
public void UPDATESTATUSPENGIRIMAN(RMS.COMMON.EXPRESS.RMS_SPJ obj) { p.UPDATESTATUSPENGIRIMAN(obj); }
public void DELETE(RMS.COMMON.EXPRESS.RMS_SPJ obj) { p.DELETE(obj); }
public void INSERTRESI(RMS.COMMON.EXPRESS.RMS_SPJ obj) { p.INSERTRESI(obj); }
public DataTable SEARCH_BYNAMA(RMS.COMMON.EXPRESS.RMS_SPJ obj) { return(p.SEARCH_BYNAMA(obj)); }
public DataTable CARI_BYNAMA(RMS.COMMON.EXPRESS.RMS_SPJ obj) { return(p.CARI_BYNAMA(obj)); }
void LOAD_DATA(RMS.COMMON.EXPRESS.RMS_SPJ obj) { DataTable dt = b.CARI_BYNORESI(obj); if (dt.Rows.Count > 0) { int status = Convert.ToInt32(dt.Rows[0]["status"].ToString()); if (status == 2) { rbONTRANSIT.Checked = true; rbONTRANSIT.BackColor = Color.Orange; c.STATUS = 2; } else if (status == 3) { rbANTARULANG.Checked = true; rbANTARULANG.BackColor = Color.Orange; c.STATUS = 3; } else if (status == 4) { rbBADADRESS.Checked = true; rbBADADRESS.BackColor = Color.Orange; c.STATUS = 4; } else if (status == 5) { rbRECEIVEONDESC.Checked = true; rbRECEIVEONDESC.BackColor = Color.Orange; c.STATUS = 5; } else if (status == 6) { rbMISSROUTE.Checked = true; rbMISSROUTE.BackColor = Color.Orange; c.STATUS = 6; } else if (status == 7) { rbCRISCROSS.Checked = true; rbCRISCROSS.BackColor = Color.Orange; c.STATUS = 7; } else if (status == 8) { rbREDELIVERY.Checked = true; rbREDELIVERY.BackColor = Color.Orange; c.STATUS = 8; } else if (status == 9) { rbCLOSED.Checked = true; rbCLOSED.BackColor = Color.Orange; c.STATUS = 9; } else if (status == 10) { rbDELIVERY.Checked = true; rbDELIVERY.BackColor = Color.Orange; c.STATUS = 10; } else { rbDELIVERYSUCCESS.Checked = true; rbDELIVERYSUCCESS.BackColor = Color.Orange; c.STATUS = 11; } } }
public DataTable SELECTIDSTT(RMS.COMMON.EXPRESS.RMS_SPJ obj) { return(p.SELECTIDSTT(obj)); }
public DataTable SELECTAGENTBYID(RMS.COMMON.EXPRESS.RMS_SPJ obj) { return(p.SELECTAGENTBYID(obj)); }
public void UPDATE(RMS.COMMON.EXPRESS.RMS_SPJ obj) { p.UPDATE(obj); }