public DataTable SELECT(RMS.COMMON.DELIVERYORDER.RMS_DETAILINVOICE obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
if (obj.STATUSSTT != "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("@TPAYMENT", MySqlDbType.VarChar, obj.STATUSSTT));
dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SELECTLIKE(RMS.COMMON.DELIVERYORDER.RMS_DETAILINVOICE obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
if (obj.STATUSSTT != "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);
}
}
void LOAD_DATA(RMS.COMMON.DELIVERYORDER.RMS_DETAILINVOICE obj)
{
DataTable dt = bDETAIL.SELECTKODEINVOICE(obj);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
// txtKODE.Text = dt.Rows[0]["KODEAGENT"].ToString();
txtINVOICE.Text = dt.Rows[0]["KODEINVOICE"].ToString();
txtCUSTOMER.Text = dt.Rows[0]["NAMACUSTOMER"].ToString();
txtPACKING.Text = dt.Rows[0]["PACKING"].ToString();
txtPPN.Text = dt.Rows[0]["PPN"].ToString();
txtINSURANCE.Text = dt.Rows[0]["INSURANCE"].ToString();
txtTOTALCHARGE.Text = dt.Rows[0]["CHARGE"].ToString();
txtTOTALPEMBAYARAN.Text = dt.Rows[0]["TOTALBAYAR"].ToString();
txtSISA.Text = dt.Rows[0]["SISAKEKURANGAN"].ToString();
if (dt.Rows[0]["SISAKEKURANGAN"].ToString() == "0")
{
lblSTATUS.Text = "LUNAS";
}
else
{
lblSTATUS.Text = "BELUM LUNAS";
}
}
}
}
void LOAD_DATA(RMS.COMMON.DELIVERYORDER.RMS_DETAILINVOICE obj)
{
DataTable dt = b.SELECTIDSTT(obj);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
// txtKODE.Text = dt.Rows[0]["KODEAGENT"].ToString();
txtTGLCONNOTE.Text = DateTime.Parse(dt.Rows[0]["DATE"].ToString()).ToString("dd-MM-yyyy");
txtNOCONNOTE.Text = dt.Rows[0]["NOCONNOTE"].ToString();
txtCUSTOMER.Text = dt.Rows[0]["CUSTOMER"].ToString();
txtDEST.Text = dt.Rows[0]["DEST"].ToString();
txtSERVICE.Text = dt.Rows[0]["SERVICE"].ToString();
txtCONSIGNEE.Text = dt.Rows[0]["CONSIGNEE"].ToString();
txtPACKING.Text = dt.Rows[0]["PACKING"].ToString();
txtPPN.Text = dt.Rows[0]["PPN"].ToString();
txtINSURANCE.Text = dt.Rows[0]["INSURANCE"].ToString();
txtTOTALCHARGE.Text = dt.Rows[0]["TOTAL_CHARGE"].ToString();
txtTOTALPEMBAYARAN.Text = dt.Rows[0]["TOTALBAYAR"].ToString();
txtSISA.Text = dt.Rows[0]["SISAKEKURANGAN"].ToString();
lblSTATUS.Text = dt.Rows[0]["STATUS"].ToString();
}
}
}
public FormVIEWPRICELISTCUSTOMER(DELIVERYORDER.FormDATAENTRY _frm, RMS.COMMON.DELIVERYORDER.RMS_DETAILINVOICE obj)
{
InitializeComponent();
this.frm = _frm;
c.IDCUSTOMER = obj.IDCUSTOMER;
c.NAMACUSTOMER = obj.NAMACUSTOMER;
lblCUSTOMER.Text = obj.NAMACUSTOMER;
LOAD_DATA();
}
public void DELETE(RMS.COMMON.DELIVERYORDER.RMS_DETAILINVOICE 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 SELECTKODEIVOICE(RMS.COMMON.DELIVERYORDER.RMS_DETAILINVOICE 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 FormPEMBAYARAN(FINANCE.FormDAFTARPEMBAYRANPIUTANG _frm, int Type, RMS.COMMON.DELIVERYORDER.RMS_DETAILINVOICE obj)
{
InitializeComponent();
this.frm = _frm;
this.Type = Type;
type = 0;
cPMB.IDSTT = obj.ID;
c.ID = obj.ID;
cboMETODEBAYAR.Text = "CASH";
cboJENISBAYAR.Text = "PELUNASAN";
pnlNOTRANSFER.Visible = false;
txtTERBILANG.Visible = false;
if (type == 0)
{
LOAD_DATA(obj);
LOAD_HISTORYBAYAR(cPMB);
}
}
public DataTable CARI_BYNAMA(RMS.COMMON.DELIVERYORDER.RMS_DETAILINVOICE 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 SEARCH_BYNAMA(RMS.COMMON.DELIVERYORDER.RMS_DETAILINVOICE 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 DataTable SEARCH_BYNAMA(RMS.COMMON.DELIVERYORDER.RMS_DETAILINVOICE obj)
{
return(p.SEARCH_BYNAMA(obj));
}
public void DELETE(RMS.COMMON.DELIVERYORDER.RMS_DETAILINVOICE obj)
{
p.DELETE(obj);
}
public void INSERT(RMS.COMMON.DELIVERYORDER.RMS_DETAILINVOICE 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("@_KODECUSTOMER", MySqlDbType.VarChar, obj._KODECUSTOMER));
db.Commands[0].Parameters.Add(new Parameter("@NOCONNOTE", MySqlDbType.VarChar, obj.NOCONNOTE));
db.Commands[0].Parameters.Add(new Parameter("@TGLCONNOTE", MySqlDbType.VarChar, obj.TGLCONNOTE));
db.Commands[0].Parameters.Add(new Parameter("@TGLMANIFEST", MySqlDbType.VarChar, obj.TGLMANIFEST));
db.Commands[0].Parameters.Add(new Parameter("@NOACCOUNT", MySqlDbType.VarChar, obj.NOACCOUNT));
db.Commands[0].Parameters.Add(new Parameter("@NOREFERENSI", MySqlDbType.VarChar, obj.NOREFERENSI));
db.Commands[0].Parameters.Add(new Parameter("@CONSIGNEE", MySqlDbType.VarChar, obj.CONSIGNEE));
db.Commands[0].Parameters.Add(new Parameter("@PHONE", MySqlDbType.VarChar, obj.PHONE));
db.Commands[0].Parameters.Add(new Parameter("@FAX", MySqlDbType.VarChar, obj.FAX));
db.Commands[0].Parameters.Add(new Parameter("@ALAMAT", MySqlDbType.VarChar, obj.ALAMAT));
db.Commands[0].Parameters.Add(new Parameter("@MARKETING", MySqlDbType.VarChar, obj.MARKETING));
db.Commands[0].Parameters.Add(new Parameter("@IDSTATUSSTT", MySqlDbType.Int32, obj.IDSTATUSSTT));
db.Commands[0].Parameters.Add(new Parameter("@IDSERVICE", MySqlDbType.Int32, obj.IDSERVICE));
db.Commands[0].Parameters.Add(new Parameter("@IDHANDLING", MySqlDbType.Int32, obj.IDHANDLING));
db.Commands[0].Parameters.Add(new Parameter("@NAMAKOTAORIGIN", MySqlDbType.VarChar, obj.NAMAKOTAORIGIN));
db.Commands[0].Parameters.Add(new Parameter("@NAMAKOTADEST", MySqlDbType.VarChar, obj.NAMAKOTADEST));
db.Commands[0].Parameters.Add(new Parameter("@PCS", MySqlDbType.Int32, obj.PCS));
db.Commands[0].Parameters.Add(new Parameter("@WEIGHT", MySqlDbType.Float, obj.WEIGHT));
db.Commands[0].Parameters.Add(new Parameter("@WEIGHTDIM", MySqlDbType.Float, obj.WEIGHTDIM));
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("@CHARGE_DIM", MySqlDbType.Float, obj.CHARGE_DIM));
db.Commands[0].Parameters.Add(new Parameter("@PPN", MySqlDbType.Float, obj.PPN));
db.Commands[0].Parameters.Add(new Parameter("@INSURANCE", MySqlDbType.Float, obj.INSURANCE));
db.Commands[0].Parameters.Add(new Parameter("@PACKING", MySqlDbType.Float, obj.PACKING));
db.Commands[0].Parameters.Add(new Parameter("@CHARGE_TERUSAN", MySqlDbType.Float, obj.CHARGE_TERUSAN));
db.Commands[0].Parameters.Add(new Parameter("@_KAGENT_SHIPPING", MySqlDbType.VarChar, obj._KAGENT_SHIPPING));
db.Commands[0].Parameters.Add(new Parameter("@_KAGENT_DELIVERY", MySqlDbType.VarChar, obj._KAGENT_DELIVERY));
db.Commands[0].Parameters.Add(new Parameter("@_KAGENT_WAREHOUSE", MySqlDbType.VarChar, obj._KAGENT_WAREHOUSE));
db.Commands[0].Parameters.Add(new Parameter("@_KOTATERUSAN", MySqlDbType.VarChar, obj._KOTATERUSAN));
db.Commands[0].Parameters.Add(new Parameter("@_KAGENT_RA", MySqlDbType.VarChar, obj._KAGENT_RA));
db.Commands[0].Parameters.Add(new Parameter("@_KAGENT_TRUCKING", MySqlDbType.VarChar, obj._KAGENT_TRUCKING));
db.Commands[0].Parameters.Add(new Parameter("@_KAGENT_SMU", MySqlDbType.VarChar, obj._KAGENT_SMU));
db.Commands[0].Parameters.Add(new Parameter("@NOSMU", MySqlDbType.VarChar, obj.NOSMU));
db.Commands[0].Parameters.Add(new Parameter("@_KAGENT_GRDH", MySqlDbType.VarChar, obj._KAGENT_GRDH));
db.Commands[0].Parameters.Add(new Parameter("@COST_SHIPPING", MySqlDbType.Float, obj.COST_SHIPPING));
db.Commands[0].Parameters.Add(new Parameter("@COST_DELIVERY", MySqlDbType.Float, obj.COST_DELIVERY));
db.Commands[0].Parameters.Add(new Parameter("@COST_TRUCKING", MySqlDbType.Float, obj.COST_TRUCKING));
db.Commands[0].Parameters.Add(new Parameter("@COST_WAREHOUSE", MySqlDbType.Float, obj.COST_WAREHOUSE));
db.Commands[0].Parameters.Add(new Parameter("@COST_RA", MySqlDbType.Float, obj.COST_RA));
db.Commands[0].Parameters.Add(new Parameter("@COST_SMU", MySqlDbType.Float, obj.COST_SMU));
db.Commands[0].Parameters.Add(new Parameter("@COST_GRDH", MySqlDbType.Float, obj.COST_GRDH));
db.Commands[0].Parameters.Add(new Parameter("@COST_FEEMARKETING", MySqlDbType.Float, obj.COST_FEEMARKETING));
db.Commands[0].Parameters.Add(new Parameter("@COST_REFUNDCUST", MySqlDbType.Float, obj.COST_REFUNDCUST));
db.Commands[0].Parameters.Add(new Parameter("@IDSTATUSBAYAR", MySqlDbType.Int32, obj.IDSTATUSBAYAR));
db.Commands[0].Parameters.Add(new Parameter("@TOTAL_CHARGE", MySqlDbType.Float, obj.TOTAL_CHARGE));
db.Commands[0].Parameters.Add(new Parameter("@TOTAL_COST", MySqlDbType.Float, obj.TOTAL_COST));
db.Commands[0].Parameters.Add(new Parameter("@TOTAL_PROFIT", MySqlDbType.Float, obj.TOTAL_PROFIT));
db.Commands[0].Parameters.Add(new Parameter("@NBARANGINSURANCE", MySqlDbType.Int32, obj.NBARANGINSURANCE));
db.Commands[0].Parameters.Add(new Parameter("@PPNPERCENT", MySqlDbType.Float, obj.PPNPERCENT));
db.Commands[0].Parameters.Add(new Parameter("@INCURANCEPERCENT", MySqlDbType.Float, obj.INCURANCEPERCENT));
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("@IDMARKETING", MySqlDbType.Float, obj.IDMARKETING));
dt = db.Commands[0].ExecuteDataTable();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SELECTAGENTBYID(RMS.COMMON.DELIVERYORDER.RMS_DETAILINVOICE obj)
{
return(p.SELECTAGENTBYID(obj));
}
public DataTable SELECTKODEINVOICE(RMS.COMMON.DELIVERYORDER.RMS_DETAILINVOICE obj)
{
return(p.SELECTKODEIVOICE(obj));
}
public void INSERT(RMS.COMMON.DELIVERYORDER.RMS_DETAILINVOICE obj)
{
p.INSERT(obj);
}
public DataTable SELECTFILTER(RMS.COMMON.DELIVERYORDER.RMS_DETAILINVOICE obj)
{
return(p.SELECTFILTER(obj));
}
public DataTable CARI_BYKODE(RMS.COMMON.DELIVERYORDER.RMS_DETAILINVOICE obj)
{
return(p.CARI_BYKODE(obj));
}
