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);
}
