private List <VMX_CONTOLPOLIZA_LINE> getListVMX_CONTOLPOLIZA_LINE_CXC_TCPago()
{
List <VMX_CONTOLPOLIZA_LINE> lstVMXPoliza = new List <VMX_CONTOLPOLIZA_LINE>();
foreach (DataRow dr_i in _dtDetalla_IVA.Rows)
{
VMX_CONTOLPOLIZA_LINE oPL = new VMX_CONTOLPOLIZA_LINE();
oPL.NO_TRANSACCION = ID;
oPL.BANK_ACCOUNT_ID = dr_i["BANK_ACCOUNTID"].ToString();
oPL.VAT_AMOUNT = "0";
oPL.SELL_RATE = double.Parse(dr_i["TC_FACTURA"].ToString());
oPL.MONTO = double.Parse(dr_i["IVA_MXN_TRASLADAR_FACT"].ToString());
oPL.CUENTA = dr_i["VAT_GL_ACCTID"].ToString();
oPL.DESCRIPCION = dr_i["DESCRIPCION"].ToString();
oPL.CUENTA_TRASLADO = dr_i["TRASLADO"].ToString();
oPL.DESCRIPTION = dr_i["TRASLADO"].ToString();
oPL.CHECK_ID = dr_i["CONTROL_NO"].ToString();
oPL.TIPO_OPERACION = "CXC";
oPL.CUSTOMER_ID = dr_i["Cliente"].ToString();
lstVMXPoliza.Add(oPL);
}
return(lstVMXPoliza);
}
public void createVMX_CONTOLPOLIZA_LINE_CXP(VMX_CONTOLPOLIZA_LINE oVMXLine)
{
string sCons = string.Empty;
try
{
string query = MapeoQuerySql.ObtenerPorId("AdminGeneralJournal.createVMX_CONTOLPOLIZA_LINE_CXP");
sCons = string.Format(query
, oVMXLine.NO_TRANSACCION, oVMXLine.BANK_ACCOUNT_ID, oVMXLine.CONTROL_NO
, oVMXLine.VAT_AMOUNT, oVMXLine.SELL_RATE, oVMXLine.MONTO
, oVMXLine.CUENTA, oVMXLine.DESCRIPCION, oVMXLine.CUENTA_TRASLADO, oVMXLine.DESCRIPTION, oVMXLine.TIPO_OPERACION, oVMXLine.CUSTOMER_ID, oVMXLine.PERDIDA_GANANCIA, oVMXLine.IVA_DEPOSITO, oVMXLine.SITE_ID, oVMXLine.MONTO_RET, oVMXLine.RET_DEPOSITO);
_trace.AppendLine(sCons);
_oSQL.EjecutarDML(sCons);
}
catch (Exception ex)
{
throw new Exception("Error al insertar en VMX_CONTOLPOLIZA_LINE - CXP. Detalle: " + ex.Message);
}
}