private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.ClienteDeuda __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "cuentaLP0", __theObject.CuentaLP0);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "UN", __theObject.UN);
com.sybase.afx.db.CommandUtil.SetDecimal(_conn.GetConnectionProfile(), ps, "deudaActual", __theObject.DeudaActual);
com.sybase.afx.db.CommandUtil.SetDecimal(_conn.GetConnectionProfile(), ps, "deudaVencida", __theObject.DeudaVencida);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "pending", __theObject.Pending);
com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps, "pendingChange", __theObject.PendingChange);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayPending", __theObject.ReplayPending);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayFailure", __theObject.ReplayFailure);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", __theObject.SurrogateKey);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayCounter", __theObject.ReplayCounter);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "disableSubmit", __theObject.DisableSubmit);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.ClientPersonalization __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "key_name", __theObject.Key_name);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "user", __theObject.User);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "value", __theObject.Value);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "user_defined", __theObject.User_defined);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "description", __theObject.Description);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "id", __theObject.Id);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.RepresentanteComercialSynchronizationParameters __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "Usuario", __theObject.Usuario);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "UsuarioUserDefined", __theObject.UsuarioUserDefined);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "size_sp", __theObject.Size_sp);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "user_sp", __theObject.User_sp);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.ClienteDetallePedido __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "pedido_CodigoSAP", __theObject.Pedido_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "pedido_Cuenta", __theObject.Pedido_Cuenta);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "pedido_Estado_CodigoSAP", __theObject.Pedido_Estado_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "pedido_direccionEntrega", __theObject.Pedido_direccionEntrega);
com.sybase.afx.db.CommandUtil.SetNullableDate(_conn.GetConnectionProfile(), ps, "pedido_FechaCreacion", __theObject.Pedido_FechaCreacion);
com.sybase.afx.db.CommandUtil.SetNullableTime(_conn.GetConnectionProfile(), ps, "pedido_HoraCreacion", __theObject.Pedido_HoraCreacion);
com.sybase.afx.db.CommandUtil.SetNullableDate(_conn.GetConnectionProfile(), ps, "pedido_FechaAprobacion", __theObject.Pedido_FechaAprobacion);
com.sybase.afx.db.CommandUtil.SetNullableTime(_conn.GetConnectionProfile(), ps, "pedido_HoraAprobacion", __theObject.Pedido_HoraAprobacion);
com.sybase.afx.db.CommandUtil.SetDecimal(_conn.GetConnectionProfile(), ps, "pedido_ImporteTotal", __theObject.Pedido_ImporteTotal);
com.sybase.afx.db.CommandUtil.SetDecimal(_conn.GetConnectionProfile(), ps, "pedido_ImporteFacturado", __theObject.Pedido_ImporteFacturado);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "producto_CodigoSAP", __theObject.Producto_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "producto_Estado_CodigoSAP", __theObject.Producto_Estado_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "producto_Terminal_CodigoSAP", __theObject.Producto_Terminal_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetDecimal(_conn.GetConnectionProfile(), ps, "producto_VolumenTotal", __theObject.Producto_VolumenTotal);
com.sybase.afx.db.CommandUtil.SetDecimal(_conn.GetConnectionProfile(), ps, "producto_VolumenPendiente", __theObject.Producto_VolumenPendiente);
com.sybase.afx.db.CommandUtil.SetDecimal(_conn.GetConnectionProfile(), ps, "producto_VolumenDespachado", __theObject.Producto_VolumenDespachado);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "producto_UnidadMedida", __theObject.Producto_UnidadMedida);
com.sybase.afx.db.CommandUtil.SetDecimal(_conn.GetConnectionProfile(), ps, "producto_ImporteTotal", __theObject.Producto_ImporteTotal);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "entrega_CodigoSAP", __theObject.Entrega_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "entrega_NumeroRemito", __theObject.Entrega_NumeroRemito);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "entrega_Estado_CodigoSAP", __theObject.Entrega_Estado_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "entrega_Patente", __theObject.Entrega_Patente);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "entrega_EstadoTransporte_CodigoSAP", __theObject.Entrega_EstadoTransporte_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetNullableDate(_conn.GetConnectionProfile(), ps, "entrega_FechaPlanificada", __theObject.Entrega_FechaPlanificada);
com.sybase.afx.db.CommandUtil.SetNullableDate(_conn.GetConnectionProfile(), ps, "entrega_FechaCarga", __theObject.Entrega_FechaCarga);
com.sybase.afx.db.CommandUtil.SetNullableDate(_conn.GetConnectionProfile(), ps, "entrega_FechaInicio", __theObject.Entrega_FechaInicio);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "pending", __theObject.Pending);
com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps, "pendingChange", __theObject.PendingChange);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayPending", __theObject.ReplayPending);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayFailure", __theObject.ReplayFailure);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", __theObject.SurrogateKey);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayCounter", __theObject.ReplayCounter);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "disableSubmit", __theObject.DisableSubmit);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.PreguntaFormulario __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "idFormulario", __theObject.IdFormulario);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "idPregunta", __theObject.IdPregunta);
com.sybase.afx.db.CommandUtil.SetNullableDecimal(_conn.GetConnectionProfile(), ps, "valor", __theObject.Valor);
com.sybase.afx.db.CommandUtil.SetNullableInt(_conn.GetConnectionProfile(), ps, "operacionNoCumplimiento", __theObject.OperacionNoCumplimiento);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "pending", __theObject.Pending);
com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps, "pendingChange", __theObject.PendingChange);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayPending", __theObject.ReplayPending);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayFailure", __theObject.ReplayFailure);
com.sybase.afx.db.CommandUtil.SetNullableLong(_conn.GetConnectionProfile(), ps, "preguntaFK", __theObject.PreguntaFK);
com.sybase.afx.db.CommandUtil.SetNullableLong(_conn.GetConnectionProfile(), ps, "formulario1FK", __theObject.Formulario1FK);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", __theObject.SurrogateKey);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayCounter", __theObject.ReplayCounter);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "disableSubmit", __theObject.DisableSubmit);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.RelevamientoProveedor __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "idInteraccion", __theObject.IdInteraccion);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "interaccion_nroOperacionSAP", __theObject.Interaccion_nroOperacionSAP);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "idRelevamientoProveedor", __theObject.IdRelevamientoProveedor);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "marca", __theObject.Marca);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "relevamientoProveedorCanal_CodigoSAP", __theObject.RelevamientoProveedorCanal_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "despacho", __theObject.Despacho);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "relevamientoProveedorLogistica_CodigoSAP", __theObject.RelevamientoProveedorLogistica_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "pending", __theObject.Pending);
com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps, "pendingChange", __theObject.PendingChange);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayPending", __theObject.ReplayPending);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayFailure", __theObject.ReplayFailure);
com.sybase.afx.db.CommandUtil.SetNullableLong(_conn.GetConnectionProfile(), ps, "interaccionFK", __theObject.InteraccionFK);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", __theObject.SurrogateKey);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayCounter", __theObject.ReplayCounter);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "disableSubmit", __theObject.DisableSubmit);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.Formulario __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "idFormulario", __theObject.IdFormulario);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "descripcion", __theObject.Descripcion);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "calculaPuntuacion", __theObject.CalculaPuntuacion);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "codigoSAP", __theObject.CodigoSAP);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "pending", __theObject.Pending);
com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps, "pendingChange", __theObject.PendingChange);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayPending", __theObject.ReplayPending);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayFailure", __theObject.ReplayFailure);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", __theObject.SurrogateKey);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayCounter", __theObject.ReplayCounter);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "disableSubmit", __theObject.DisableSubmit);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.intrnl.OperationReplay __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "remoteId", __theObject.RemoteId);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "component", __theObject.Component);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "entityKey", __theObject.EntityKey);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "attributes", __theObject.Attributes);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "operation", __theObject.Operation);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "parameters", __theObject.Parameters);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "replayLog", __theObject.ReplayLog);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "exception", __theObject.Exception);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "completed", __theObject.Completed);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "requestId", __theObject.RequestId);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.FormularioTransporte __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "idInteraccion", __theObject.IdInteraccion);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "flota", __theObject.Flota);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "empresasCliente", __theObject.EmpresasCliente);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "recorrido", __theObject.Recorrido);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "SYMA", __theObject.SYMA);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "RAZ_SOC_2", __theObject.RAZ_SOC_2);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "pending", __theObject.Pending);
com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps, "pendingChange", __theObject.PendingChange);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayPending", __theObject.ReplayPending);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayFailure", __theObject.ReplayFailure);
com.sybase.afx.db.CommandUtil.SetNullableLong(_conn.GetConnectionProfile(), ps, "interaccionFK", __theObject.InteraccionFK);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", __theObject.SurrogateKey);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayCounter", __theObject.ReplayCounter);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "disableSubmit", __theObject.DisableSubmit);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.Direccion __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "idDireccionEntrega", __theObject.IdDireccionEntrega);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "calle", __theObject.Calle);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "numero", __theObject.Numero);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "codigoPostal", __theObject.CodigoPostal);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "provincia_codigoSAP", __theObject.Provincia_codigoSAP);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "pending", __theObject.Pending);
com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps, "pendingChange", __theObject.PendingChange);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayPending", __theObject.ReplayPending);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayFailure", __theObject.ReplayFailure);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", __theObject.SurrogateKey);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayCounter", __theObject.ReplayCounter);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "disableSubmit", __theObject.DisableSubmit);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.PackageProperties __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "value", __theObject.Value);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "pending", __theObject.Pending);
com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps, "pendingChange", __theObject.PendingChange);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayPending", __theObject.ReplayPending);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayFailure", __theObject.ReplayFailure);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "key", __theObject.Key);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayCounter", __theObject.ReplayCounter);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "disableSubmit", __theObject.DisableSubmit);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.CustomLocalData __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetNullableBoolean(_conn.GetConnectionProfile(), ps, "valorBoolean", __theObject.ValorBoolean);
com.sybase.afx.db.CommandUtil.SetNullableInt(_conn.GetConnectionProfile(), ps, "valorInteger", __theObject.ValorInteger);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "valorString", __theObject.ValorString);
com.sybase.afx.db.CommandUtil.SetNullableDouble(_conn.GetConnectionProfile(), ps, "valorDouble", __theObject.ValorDouble);
com.sybase.afx.db.CommandUtil.SetNullableDateTime(_conn.GetConnectionProfile(), ps, "valorDateTime", __theObject.ValorDateTime);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "idCustomLocalData", __theObject.IdCustomLocalData);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.FormularioPrecios __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "idInteraccion", __theObject.IdInteraccion);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "formularioPreciosZonaInspeccion_CodigoSAP", __theObject.FormularioPreciosZonaInspeccion_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "zonaPrecios", __theObject.ZonaPrecios);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "cluster", __theObject.Cluster);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "formularioPreciosRed_CodigoSAP", __theObject.FormularioPreciosRed_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "APIES", __theObject.APIES);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "formularioPreciosMercado_CodigoSAP", __theObject.FormularioPreciosMercado_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "submercado", __theObject.Submercado);
com.sybase.afx.db.CommandUtil.SetDecimal(_conn.GetConnectionProfile(), ps, "tasaServicio", __theObject.TasaServicio);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "observacionesTasaServicio", __theObject.ObservacionesTasaServicio);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "tasaIncluida", __theObject.TasaIncluida);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "estrategica", __theObject.Estrategica);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "camara", __theObject.Camara);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "programaFidelizacion", __theObject.ProgramaFidelizacion);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "otrosNegocios", __theObject.OtrosNegocios);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "mediosPago", __theObject.MediosPago);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "pending", __theObject.Pending);
com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps, "pendingChange", __theObject.PendingChange);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayPending", __theObject.ReplayPending);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayFailure", __theObject.ReplayFailure);
com.sybase.afx.db.CommandUtil.SetNullableLong(_conn.GetConnectionProfile(), ps, "interaccionFK", __theObject.InteraccionFK);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", __theObject.SurrogateKey);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayCounter", __theObject.ReplayCounter);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "disableSubmit", __theObject.DisableSubmit);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.RelevamientoTransporte __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "idInteraccion", __theObject.IdInteraccion);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "interaccion_nroOperacionSAP", __theObject.Interaccion_nroOperacionSAP);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "relevamientoTransporteCompetidor_CodigoSAP", __theObject.RelevamientoTransporteCompetidor_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "relevamientoTransporteProducto_CodigoSAP", __theObject.RelevamientoTransporteProducto_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "volumen", __theObject.Volumen);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "volumenDireccionEntrega", __theObject.VolumenDireccionEntrega);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "pending", __theObject.Pending);
com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps, "pendingChange", __theObject.PendingChange);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayPending", __theObject.ReplayPending);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayFailure", __theObject.ReplayFailure);
com.sybase.afx.db.CommandUtil.SetNullableLong(_conn.GetConnectionProfile(), ps, "interaccionFK", __theObject.InteraccionFK);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", __theObject.SurrogateKey);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayCounter", __theObject.ReplayCounter);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "disableSubmit", __theObject.DisableSubmit);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.DireccionEntrega __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "idDireccionEntrega", __theObject.IdDireccionEntrega);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "razonSocial", __theObject.RazonSocial);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "CUIT", __theObject.CUIT);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "agrupacion", __theObject.Agrupacion);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "UN", __theObject.UN);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "contacto", __theObject.Contacto);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "APIES", __theObject.APIES);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "cuentaSGC", __theObject.CuentaSGC);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "cuentaLPO", __theObject.CuentaLPO);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "cuentaLP2", __theObject.CuentaLP2);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "cuentaQP1", __theObject.CuentaQP1);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "operaYER", __theObject.OperaYER);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "cantidadTarjetaYER", __theObject.CantidadTarjetaYER);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "pending", __theObject.Pending);
com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps, "pendingChange", __theObject.PendingChange);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayPending", __theObject.ReplayPending);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayFailure", __theObject.ReplayFailure);
com.sybase.afx.db.CommandUtil.SetNullableLong(_conn.GetConnectionProfile(), ps, "direccionFK", __theObject.DireccionFK);
com.sybase.afx.db.CommandUtil.SetNullableLong(_conn.GetConnectionProfile(), ps, "mailFK", __theObject.MailFK);
com.sybase.afx.db.CommandUtil.SetNullableLong(_conn.GetConnectionProfile(), ps, "telefonoFK", __theObject.TelefonoFK);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", __theObject.SurrogateKey);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayCounter", __theObject.ReplayCounter);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "disableSubmit", __theObject.DisableSubmit);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.intrnl.SISSubscription __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "deviceId", __theObject.DeviceId);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "username", __theObject.Username);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "appname", __theObject.Appname);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "enable", __theObject.Enable);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "adminLock", __theObject.AdminLock);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "interval", __theObject.Interval);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "protocol", __theObject.Protocol);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "address", __theObject.Address);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "domain", __theObject.Domain);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "package", __theObject.Package);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "syncGroup", __theObject.SyncGroup);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "clientId", __theObject.ClientId);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.CalendarioInteraccionLocal __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "tipoInteraccion", __theObject.TipoInteraccion);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "cantidadInteraccion", __theObject.CantidadInteraccion);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "diaInteraccion", __theObject.DiaInteraccion);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "mesInteraccion", __theObject.MesInteraccion);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "anioInteraccion", __theObject.AnioInteraccion);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "idTipoInteraccion", __theObject.IdTipoInteraccion);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.SeleccionFormulario __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "idMotivo", __theObject.IdMotivo);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "idNegocio", __theObject.IdNegocio);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "idFormulario", __theObject.IdFormulario);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "pending", __theObject.Pending);
com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps, "pendingChange", __theObject.PendingChange);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayPending", __theObject.ReplayPending);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayFailure", __theObject.ReplayFailure);
com.sybase.afx.db.CommandUtil.SetNullableLong(_conn.GetConnectionProfile(), ps, "negocioFK", __theObject.NegocioFK);
com.sybase.afx.db.CommandUtil.SetNullableLong(_conn.GetConnectionProfile(), ps, "motivoFK", __theObject.MotivoFK);
com.sybase.afx.db.CommandUtil.SetNullableLong(_conn.GetConnectionProfile(), ps, "formularioFK", __theObject.FormularioFK);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", __theObject.SurrogateKey);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayCounter", __theObject.ReplayCounter);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "disableSubmit", __theObject.DisableSubmit);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.ClienteFacturacion __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "sistema", __theObject.Sistema);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "CUIT", __theObject.CUIT);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "idDireccionEntrega", __theObject.IdDireccionEntrega);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "periodoMesAnio", __theObject.PeriodoMesAnio);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "grupoArticulo_CodigoSAP", __theObject.GrupoArticulo_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetDecimal(_conn.GetConnectionProfile(), ps, "volumen", __theObject.Volumen);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "unidadMedida", __theObject.UnidadMedida);
com.sybase.afx.db.CommandUtil.SetDecimal(_conn.GetConnectionProfile(), ps, "importeBruto", __theObject.ImporteBruto);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "pending", __theObject.Pending);
com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps, "pendingChange", __theObject.PendingChange);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayPending", __theObject.ReplayPending);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayFailure", __theObject.ReplayFailure);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", __theObject.SurrogateKey);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayCounter", __theObject.ReplayCounter);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "disableSubmit", __theObject.DisableSubmit);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.LocalKeyGenerator __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "firstId", __theObject.FirstId);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "lastId", __theObject.LastId);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "nextId", __theObject.NextId);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "remoteId", __theObject.RemoteId);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "batchId", __theObject.BatchId);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.LogRecordImpl __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "level", __theObject.Level);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "code", __theObject.Code);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "eisCode", __theObject.EisCode);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "message", __theObject.Message);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "component", __theObject.Component);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "entityKey", __theObject.EntityKey);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "operation", __theObject.Operation);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "requestId", __theObject.RequestId);
com.sybase.afx.db.CommandUtil.SetNullableDateTime(_conn.GetConnectionProfile(), ps, "timestamp", __theObject.Timestamp);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "pending", __theObject.Pending);
com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps, "pendingChange", __theObject.PendingChange);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayPending", __theObject.ReplayPending);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayFailure", __theObject.ReplayFailure);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "messageId", __theObject.MessageId);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayCounter", __theObject.ReplayCounter);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "disableSubmit", __theObject.DisableSubmit);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.intrnl.RepresentanteComercial_pull_pq __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "username", __theObject.Username);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "remoteId", __theObject.RemoteId);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "UsuarioParam", __theObject.UsuarioParam);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "id", __theObject.Id);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.RepresentanteComercial __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "idRepresentanteComercial", __theObject.IdRepresentanteComercial);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "usuario", __theObject.Usuario);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "nombre", __theObject.Nombre);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "apellido", __theObject.Apellido);
com.sybase.afx.db.CommandUtil.SetNullableInt(_conn.GetConnectionProfile(), ps, "idNegocio", __theObject.IdNegocio);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "codigoRRCC", __theObject.CodigoRRCC);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "codigoInterlocutor", __theObject.CodigoInterlocutor);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "pending", __theObject.Pending);
com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps, "pendingChange", __theObject.PendingChange);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayPending", __theObject.ReplayPending);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayFailure", __theObject.ReplayFailure);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", __theObject.SurrogateKey);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayCounter", __theObject.ReplayCounter);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "disableSubmit", __theObject.DisableSubmit);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.ChangeLogImpl __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps, "operationType", __theObject.OperationType);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "rootEntityType", __theObject.RootEntityType);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "rootSurrogateKey", __theObject.RootSurrogateKey);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "entityType", __theObject.EntityType);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", __theObject.SurrogateKey);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.TablaRelevamiento __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "idTablaRelevamiento", __theObject.IdTablaRelevamiento);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "nombre", __theObject.Nombre);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "pending", __theObject.Pending);
com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps, "pendingChange", __theObject.PendingChange);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayPending", __theObject.ReplayPending);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayFailure", __theObject.ReplayFailure);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", __theObject.SurrogateKey);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayCounter", __theObject.ReplayCounter);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "disableSubmit", __theObject.DisableSubmit);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.OfflineAuthentication __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetInt(_conn.GetConnectionProfile(), ps, "passwordHash", __theObject.PasswordHash);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "user", __theObject.User);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.RespuestaInteraccionFormulario __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "idInteraccion", __theObject.IdInteraccion);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "formulario_CodigoSAP", __theObject.Formulario_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "pregunta_CodigoSAP", __theObject.Pregunta_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "respuesta_CodigoSAP", __theObject.Respuesta_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "observaciones", __theObject.Observaciones);
com.sybase.afx.db.CommandUtil.SetDecimal(_conn.GetConnectionProfile(), ps, "puntaje", __theObject.Puntaje);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "pending", __theObject.Pending);
com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps, "pendingChange", __theObject.PendingChange);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayPending", __theObject.ReplayPending);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayFailure", __theObject.ReplayFailure);
com.sybase.afx.db.CommandUtil.SetNullableLong(_conn.GetConnectionProfile(), ps, "interaccionFK", __theObject.InteraccionFK);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", __theObject.SurrogateKey);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayCounter", __theObject.ReplayCounter);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "disableSubmit", __theObject.DisableSubmit);
ps.ExecuteNonQuery();
ps.Dispose();;
}
private void CreateBySQL(Sybase.Persistence.ConnectionWrapper _conn, string sql, YPF.Comercial.RRCC.SUP.Interaccion __theObject)
{
System.Data.IDbCommand ps = com.sybase.afx.db.CommandUtil.CreateCommand(_conn, sql);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "idInteraccion", __theObject.IdInteraccion);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "tipoInteraccion_CodigoSAP", __theObject.TipoInteraccion_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "titulo", __theObject.Titulo);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "tipoInteraccion_CategoriaSAP", __theObject.TipoInteraccion_CategoriaSAP);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "GUID", __theObject.GUID);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "nroOperacionSAP", __theObject.NroOperacionSAP);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "segmento_CodigoSAP", __theObject.Segmento_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "negocio_CodigoSAP", __theObject.Negocio_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "formulario_CodigoSAP", __theObject.Formulario_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetNullableDecimal(_conn.GetConnectionProfile(), ps, "puntaje", __theObject.Puntaje);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "latitud", __theObject.Latitud);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "longitud", __theObject.Longitud);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "comentarios", __theObject.Comentarios);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "notasPreparacion", __theObject.NotasPreparacion);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "notasResultado", __theObject.NotasResultado);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "notasResultadoAdministrativo", __theObject.NotasResultadoAdministrativo);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "notasResultadoComercial", __theObject.NotasResultadoComercial);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "notasResultadoOperativo", __theObject.NotasResultadoOperativo);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "notasResultadoMercado", __theObject.NotasResultadoMercado);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "notasResultadoAsesoramiento", __theObject.NotasResultadoAsesoramiento);
com.sybase.afx.db.CommandUtil.SetNullableDate(_conn.GetConnectionProfile(), ps, "fechaInicioPlanificada", __theObject.FechaInicioPlanificada);
com.sybase.afx.db.CommandUtil.SetNullableTime(_conn.GetConnectionProfile(), ps, "horaInicioPlanificada", __theObject.HoraInicioPlanificada);
com.sybase.afx.db.CommandUtil.SetNullableDate(_conn.GetConnectionProfile(), ps, "fechaFinPlanificada", __theObject.FechaFinPlanificada);
com.sybase.afx.db.CommandUtil.SetNullableTime(_conn.GetConnectionProfile(), ps, "horaFinPlanificada", __theObject.HoraFinPlanificada);
com.sybase.afx.db.CommandUtil.SetNullableDate(_conn.GetConnectionProfile(), ps, "fechaInicioReal", __theObject.FechaInicioReal);
com.sybase.afx.db.CommandUtil.SetNullableTime(_conn.GetConnectionProfile(), ps, "horaInicioReal", __theObject.HoraInicioReal);
com.sybase.afx.db.CommandUtil.SetNullableDate(_conn.GetConnectionProfile(), ps, "fechaFinReal", __theObject.FechaFinReal);
com.sybase.afx.db.CommandUtil.SetNullableTime(_conn.GetConnectionProfile(), ps, "horaFinReal", __theObject.HoraFinReal);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "idDireccionEntrega", __theObject.IdDireccionEntrega);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "direccionEntregaNombre", __theObject.DireccionEntregaNombre);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "representanteComercial_CodigoInterlocutor", __theObject.RepresentanteComercial_CodigoInterlocutor);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "representanteComercial_Nombre", __theObject.RepresentanteComercial_Nombre);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "responsable_CodigoInterlocutor", __theObject.Responsable_CodigoInterlocutor);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "responsableNombre", __theObject.ResponsableNombre);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "estadoInteraccion_CodigoSAP", __theObject.EstadoInteraccion_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetString(_conn.GetConnectionProfile(), ps, "motivo_CodigoSAP", __theObject.Motivo_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "calle", __theObject.Calle);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "direccionNro", __theObject.DireccionNro);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "codigoPostal", __theObject.CodigoPostal);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "ciudad", __theObject.Ciudad);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "provincia_CodigoSAP", __theObject.Provincia_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetNullableString(_conn.GetConnectionProfile(), ps, "pais_CodigoSAP", __theObject.Pais_CodigoSAP);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "pending", __theObject.Pending);
com.sybase.afx.db.CommandUtil.SetChar(_conn.GetConnectionProfile(), ps, "pendingChange", __theObject.PendingChange);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayPending", __theObject.ReplayPending);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayFailure", __theObject.ReplayFailure);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "surrogateKey", __theObject.SurrogateKey);
com.sybase.afx.db.CommandUtil.SetLong(_conn.GetConnectionProfile(), ps, "replayCounter", __theObject.ReplayCounter);
com.sybase.afx.db.CommandUtil.SetBoolean(_conn.GetConnectionProfile(), ps, "disableSubmit", __theObject.DisableSubmit);
ps.ExecuteNonQuery();
ps.Dispose();;
}
