public static PaymentList GetList(ETipoAcreedor providerType,
long oidProvider,
DateTime from,
DateTime till,
EStepGraph step,
CriteriaEx criteria,
bool childs)
{
QueryConditions conditions = new QueryConditions()
{
PagingInfo = (criteria != null) ? criteria.PagingInfo : null,
Filters = (criteria != null) ? criteria.Filters : null,
Orders = (criteria != null) ? criteria.Orders : null,
TipoAcreedor = new ETipoAcreedor[1] {
providerType
},
Acreedor = (oidProvider != 0) ? ProviderBaseInfo.New(oidProvider, providerType) : null,
PaymentType = providerType == ETipoAcreedor.Empleado ? ETipoPago.Nomina : ETipoPago.Factura,
FechaIni = from,
FechaFin = till,
Step = step,
};
string query = SELECT(conditions);
if (criteria != null)
{
criteria.PagingInfo = conditions.PagingInfo;
}
return(GetList(query, criteria, childs));
}
internal void UpdateTipo(ETipoAcreedor oldProviderType)
{
CriteriaEx criteria = Proveedor.GetCriteria(SessionCode);
QueryConditions conditions = new QueryConditions
{
Acreedor = this.GetInfo(false),
TipoAcreedor = new ETipoAcreedor[1] {
oldProviderType
},
PaymentType = ETipoPago.Factura
};
criteria.Query = InputDelivery.UPDATE_TIPO(conditions);
ExecuteSQL(criteria);
criteria.Query = InputInvoiceSQL.UPDATE_TIPO(conditions);
ExecuteSQL(criteria);
criteria.Query = ProductoProveedor.UPDATE_TIPO(conditions);
ExecuteSQL(criteria);
//PagoFactura antes que Pago porque si modificamos el tipo del pago antes luego no coinciden
criteria.Query = TransactionPayment.UPDATE_TIPO(conditions);
ExecuteSQL(criteria);
criteria.Query = Payment.UPDATE_TIPO(conditions);
ExecuteSQL(criteria);
}
public PedidoProveedorAddForm(ETipoAcreedor tipo, Form parent)
: base(-1, tipo, true, parent)
{
InitializeComponent();
SetFormData();
_mf_type = ManagerFormType.MFAdd;
}
public static void IsPosibleDelete(long oid, ETipoAcreedor providerType)
{
QueryConditions conditions = new QueryConditions
{
TipoAcreedor = new ETipoAcreedor[1] {
providerType
},
Acreedor = ProviderBaseInfo.New(oid, providerType),
Estado = EEstado.NoAnulado
};
InputDeliveryList albaranes = InputDeliveryList.GetList(conditions, false);
if (albaranes.Count > 0)
{
throw new iQException(Resources.Messages.ALBARANES_ASOCIADOS);
}
InputInvoiceList facturas = InputInvoiceList.GetList(conditions, false);
if (facturas.Count > 0)
{
throw new iQException(Resources.Messages.FACTURAS_ASOCIADAS);
}
conditions.PaymentType = ETipoPago.Factura;
PaymentList pagos = PaymentList.GetList(conditions, false);
if (pagos.Count > 0)
{
throw new iQException(Resources.Messages.PAGOS_ASOCIADOS);
}
}
protected override void GetFormSourceData(long oid, object[] parameters)
{
ETipoAcreedor tipo = (ETipoAcreedor)parameters[0];
_entity = PedidoProveedor.Get(oid, tipo);
_entity.BeginEdit();
}
public ProveedorViewForm(long oid, ETipoAcreedor providerType, Form parent)
: base(oid, providerType, true, parent)
{
InitializeComponent();
SetFormData();
_mf_type = ManagerFormType.MFView;
}
public static InputDeliveryList GetList(bool childs,
ETipoAcreedor providerType,
long oidProvider,
long oidSerie,
ETipoAlbaranes deliveryType,
ETipoFactura invoiceType,
DateTime from,
DateTime till)
{
QueryConditions conditions = new QueryConditions
{
Acreedor = (oidProvider != 0) ? ProviderBaseInfo.New(oidProvider, providerType) : null,
TipoAcreedor = new ETipoAcreedor[1] {
providerType
},
Serie = (oidSerie != 0) ? Serie.SerieInfo.New(oidSerie) : null,
TipoAlbaranes = deliveryType,
TipoFactura = invoiceType,
FechaIni = from,
FechaFin = till,
};
if (oidSerie != 0)
{
conditions.Serie.Oid = oidSerie;
}
return(GetList(childs, SELECT(conditions)));
}
protected override void GetFormSourceData(long oid, object[] parameters)
{
ETipoAcreedor tipo = (ETipoAcreedor)parameters[0];
_entity = PedidoProveedorInfo.Get(oid, tipo, true);
_mf_type = ManagerFormType.MFView;
}
public PedidoProveedorForm(long oid, ETipoAcreedor tipo, bool isModal, Form parent)
: base(oid, new object[1] {
tipo
}, isModal, parent)
{
InitializeComponent();
}
internal static string FIELDS(ETipoAcreedor tipo)
{
string query = @"
SELECT A.""OID"" AS ""OID_AGENTE""
," + (long)tipo + @" AS ""TIPO_AGENTE""
,A.""CODIGO""";
switch (tipo)
{
case ETipoAcreedor.Empleado:
query += @"
,A.""APELLIDOS"" || ', ' || A.""NOMBRE"" AS ""NOMBRE""";
break;
default:
query += @"
,A.""NOMBRE""";
break;
}
query += @"
,A.""OBSERVACIONES"" AS ""OBSERVACIONES_ACREEDOR""
,COALESCE(""TOTAL_FACTURADO"",0) AS ""TOTAL_FACTURADO""
,COALESCE(""TOTAL_ESTIMADO"", 0) AS ""TOTAL_ESTIMADO""
,COALESCE(""TOTAL_PAGADO"",0) AS ""TOTAL_PAGADO""
,COALESCE(""EFECTOS_NEGOCIADOS"",0) AS ""EFECTOS_NEGOCIADOS""
,COALESCE(""EFECTOS_DEVUELTOS"",0) AS ""EFECTOS_DEVUELTOS""
,COALESCE(""EFECTOS_PTES_VTO"",0) AS ""EFECTOS_PTES_VTO""";
return query;
}
public static void OpenEditFormAction(ETipoAcreedor providerType, long oid, Form parent)
{
switch (providerType)
{
case ETipoAcreedor.Acreedor:
case ETipoAcreedor.Proveedor:
{
ProveedorEditForm form = new ProveedorEditForm(oid, providerType, parent);
form.ShowDialog(parent);
}
break;
case ETipoAcreedor.Naviera:
{
NavieraEditForm form = new NavieraEditForm(oid, parent);
form.ShowDialog(parent);
}
break;
case ETipoAcreedor.Despachante:
{
DespachanteEditForm form = new DespachanteEditForm(oid, parent);
form.ShowDialog(parent);
}
break;
case ETipoAcreedor.TransportistaOrigen:
case ETipoAcreedor.TransportistaDestino:
{
TransporterEditForm form = new TransporterEditForm(oid, providerType, parent);
form.ShowDialog(parent);
}
break;
}
}
public static InputInvoiceViewModel Get(long oid, ETipoAcreedor providerType)
{
InputInvoiceViewModel obj = new InputInvoiceViewModel();
obj.CopyFrom(InputInvoiceInfo.Get(oid, providerType));
return(obj);
}
protected override void GetFormSourceData(long oid, object[] parameters)
{
ETipoAcreedor tipo = (ETipoAcreedor)parameters[0];
_entity = InputDeliveryInfo.Get(oid, tipo, true);
_deliveryType = _entity.Contado ? ETipoAlbaranes.Agrupados : ETipoAlbaranes.Todos;
}
public static InputInvoiceList GetList(ETipoAcreedor providerType,
long oidProvider,
long oidSerie,
ETipoFacturas invoicesType,
ETipoFactura invoiceType,
DateTime from,
DateTime till,
bool childs)
{
QueryConditions conditions = new QueryConditions
{
Acreedor = (oidProvider != 0) ? ProviderBaseInfo.New(oidProvider, providerType) : null,
TipoAcreedor = new ETipoAcreedor[1] {
providerType
},
Serie = (oidSerie != 0) ? Serie.Serie.New().GetInfo() : null,
TipoFacturas = invoicesType,
TipoFactura = invoiceType,
FechaIni = from,
FechaFin = till,
};
if (oidSerie != 0)
{
conditions.Serie.Oid = oidSerie;
}
return(GetList(InputInvoiceSQL.SELECT(conditions), childs));
}
protected override void GetFormSourceData(object[] parameters)
{
ETipoAcreedor providerType = (ETipoAcreedor)parameters[0];
_entity = Transporter.New(providerType);
_entity.BeginEdit();
}
public TransporterAddForm(Form parent, ETipoAcreedor providerType)
: base(-1, providerType, parent)
{
InitializeComponent();
SetFormData();
_mf_type = ManagerFormType.MFAdd;
}
public InputInvoiceViewForm(long oid, ETipoAcreedor tipo, Form parent)
: base(oid, tipo, true, parent)
{
InitializeComponent();
SetFormData();
_mf_type = ManagerFormType.MFView;
}
public TransporterForm(long oid, ETipoAcreedor providerType, bool isModal, Form parent)
: base(oid, new object[2] {
providerType, null
}, isModal, parent)
{
InitializeComponent();
}
public void ActivateAcreedor(ETipoAcreedor tipo, string table)
{
TProviderBase acreedor = new TProviderBase();
acreedor.Table = table;
acreedor.Tipo = tipo;
_active_acreedores.Add(tipo, acreedor);
}
public static string SELECT_ESTIMADO(ETipoAcreedor providerType)
{
return(PaymentSummary.SELECT_ESTIMADO(new QueryConditions {
TipoAcreedor = new ETipoAcreedor[1] {
providerType
}
}));
}
public static ProviderViewModel Get(long oid, ETipoAcreedor providerType)
{
ProviderViewModel obj = new ProviderViewModel();
obj.ReadOnlyObj = ProviderBaseInfo.Get(oid, providerType, false);
obj.CopyFrom(obj.ReadOnlyObj);
return(obj);
}
public PedidoProveedorViewForm(long oid, ETipoAcreedor tipo, Form parent)
: base(oid, tipo, true, parent)
{
InitializeComponent();
SetFormData();
this.Text = Resources.Labels.PEDIDOPROVEEDOR_DETAIL_TITLE + " " + EntityInfo.Codigo.ToUpper();
_mf_type = ManagerFormType.MFView;
}
protected override void GetFormSourceData(object[] parameters)
{
ETipoAcreedor tipo = (ETipoAcreedor)parameters[0];
_entity = PedidoProveedor.New();
_entity.ETipoAcreedor = tipo;
_entity.BeginEdit();
}
internal static string SELECT_BASE(QueryConditions conditions, ETipoAcreedor tipo)
{
string query;
query = SELECT_BASE() +
INNER_ACREEDOR(tipo) +
WHERE(conditions);
return(query);
}
public InputDeliveryViewForm(long oid, ETipoAcreedor tipo, Form parent)
: base(oid, new object[1] {
tipo
}, true, parent)
{
InitializeComponent();
SetFormData();
this.Text = _entity.Codigo;
_mf_type = ManagerFormType.MFView;
}
public ProveedorEditForm(long oid, ETipoAcreedor providerType, Form parent)
: base(oid, providerType, parent)
{
InitializeComponent();
if (_entity != null)
{
SetFormData();
}
_mf_type = ManagerFormType.MFEdit;
}
public static PaymentSummaryList GetList(ETipoAcreedor providerType, bool childs)
{
QueryConditions conditions = new QueryConditions {
TipoAcreedor = new ETipoAcreedor[1] {
providerType
}
};
return(GetList(SELECT(conditions)));
}
public InputDeliverySelectForm(Form parent, ETipoAlbaranes tipo, ETipoAcreedor tipo_acreedor, long oid_serie, long oid_cliente)
: base(true, parent, tipo, tipo_acreedor)
{
InitializeComponent();
_view_mode = molView.Select;
_oid_cliente = oid_cliente;
_oid_serie = oid_serie;
_action_result = DialogResult.Cancel;
}
public static ETipoTransportista ToETipoTransportista(ETipoAcreedor source)
{
switch (source)
{
case ETipoAcreedor.TransportistaOrigen: return(ETipoTransportista.Origen);
case ETipoAcreedor.TransportistaDestino: return(ETipoTransportista.Destino);
}
return(ETipoTransportista.Todos);
}
public static InputInvoiceList GetListNoAsignadas(ETipoAcreedor providerType, bool childs)
{
QueryConditions conditions = new QueryConditions
{
TipoAcreedor = new ETipoAcreedor[1] {
providerType
}
};
return(GetList(InputInvoiceSQL.SELECT_SIN_EXPEDIENTE(conditions), childs));
}
