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));
}
public static InputInvoiceList 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,
FechaIni = from,
FechaFin = till,
Step = step,
};
string query = InputInvoiceSQL.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 static InputInvoiceList GetListByPago(long oid, bool childs)
{
QueryConditions conditions = new QueryConditions {
Payment = PaymentInfo.New(oid, ETipoPago.Todos)
};
return(GetList(InputInvoiceSQL.SELECT_BY_PAGO(conditions), childs));
}
public static InputInvoiceList GetExplotacionList(DateTime from, DateTime till, bool childs)
{
QueryConditions conditions = new QueryConditions
{
FechaIni = from,
FechaFin = till,
};
return(GetList(InputInvoiceSQL.SELECT_EXPLOTACION(conditions), childs));
}
public static InputInvoiceList GetListByDate(DateTime from, DateTime till, bool childs)
{
QueryConditions conditions = new QueryConditions
{
FechaIni = from,
FechaFin = till
};
return(GetList(InputInvoiceSQL.SELECT_CONTROL_PAGOS(conditions), childs));
}
public static InputInvoiceList GetListByModelo(EModelo model, DateTime from, DateTime till, bool childs)
{
QueryConditions conditions = new QueryConditions
{
EModelo = model,
FechaIni = from,
FechaFin = till
};
return(GetList(InputInvoiceSQL.SELECT_BY_MODELO(conditions), childs));
}
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));
}
public static InputInvoiceList GetListByAcreedor(long oid, ETipoAcreedor providerType, bool childs)
{
QueryConditions conditions = new QueryConditions
{
TipoAcreedor = new ETipoAcreedor[1] {
providerType
},
Acreedor = ProviderBaseInfo.New(oid, providerType)
};
return(GetList(InputInvoiceSQL.SELECT(conditions), childs));
}
public static InputInvoiceList GetCostesByExpedienteList(long oid, bool childs)
{
QueryConditions conditions = new QueryConditions
{
Expedient = ExpedientInfo.New(oid),
TipoAcreedor = new ETipoAcreedor[1] {
ETipoAcreedor.Proveedor
},
};
return(GetList(InputInvoiceSQL.SELECT_COSTES_EXPEDIENTE(conditions), childs));
}
public static InputInvoiceList GetListNoAsignadasByAcreedor(long oid, ETipoAcreedor providerType, bool childs)
{
QueryConditions conditions = new QueryConditions
{
Acreedor = ProviderBaseInfo.New(oid, providerType),
TipoAcreedor = new ETipoAcreedor[1] {
providerType
},
};
return(GetList(InputInvoiceSQL.SELECT_SIN_EXPEDIENTE(conditions), childs));
}
public static InputInvoiceList GetPendientesList(long oidProvider, ETipoAcreedor providerType, bool childs)
{
QueryConditions conditions = new QueryConditions
{
TipoFacturas = ETipoFacturas.Pendientes,
Acreedor = ProviderBaseInfo.New(oidProvider, providerType),
TipoAcreedor = new ETipoAcreedor[1] {
providerType
}
};
return(GetList(InputInvoiceSQL.SELECT(conditions), childs));
}
public static InputInvoiceList GetPendientesList(DateTime expirationFrom,
DateTime expirationTill,
EMedioPago paymentMethod,
bool childs)
{
QueryConditions conditions = new QueryConditions
{
TipoFacturas = ETipoFacturas.Pendientes,
FechaAuxIni = expirationFrom,
FechaAuxFin = expirationTill,
MedioPago = paymentMethod
};
return(GetList(InputInvoiceSQL.SELECT(conditions), childs));
}
/// <summary>
/// Retrieve the complete list from db
/// </summary>
/// <param name="get_childs">retrieving the childs</param>
/// <returns>FacturaRecibidaList</returns>
public static InputInvoiceList GetChildList(bool childs)
{
CriteriaEx criteria = InputInvoice.GetCriteria(InputInvoice.OpenSession());
criteria.Childs = childs;
if (nHManager.Instance.UseDirectSQL)
{
criteria.Query = InputInvoiceSQL.SELECT();
}
InputInvoiceList list = DataPortal.Fetch <InputInvoiceList>(criteria);
CloseSession(criteria.SessionCode);
return(list);
}
public static InputInvoiceList GetListByExpediente(long oid, bool childs)
{
CriteriaEx criteria = InputInvoice.GetCriteria(InputInvoice.OpenSession());
criteria.Childs = childs;
QueryConditions conditions = new QueryConditions
{
Expedient = ExpedientInfo.New(oid)
};
criteria.Query = InputInvoiceSQL.SELECT_EXPEDIENTES(conditions);
InputInvoiceList list = DataPortal.Fetch <InputInvoiceList>(criteria);
CloseSession(criteria.SessionCode);
return(list);
}
// called to retrieve data from database
protected override void Fetch(CriteriaEx criteria)
{
this.RaiseListChangedEvents = false;
SessionCode = criteria.SessionCode;
Childs = criteria.Childs;
try
{
if (nHMng.UseDirectSQL)
{
IDataReader reader = nHManager.Instance.SQLNativeSelect(criteria.Query, Session());
IsReadOnly = false;
while (reader.Read())
{
InputInvoiceInfo item = InputInvoiceInfo.GetChild(SessionCode, reader, Childs);
if (this.GetItem(item.Oid) == null)
{
this.AddItem(item);
}
}
IsReadOnly = true;
if (criteria.PagingInfo != null)
{
reader = nHManager.Instance.SQLNativeSelect(InputInvoiceSQL.SELECT_COUNT(criteria), criteria.Session);
if (reader.Read())
{
criteria.PagingInfo.TotalItems = Format.DataReader.GetInt32(reader, "TOTAL_ROWS");
}
}
}
}
catch (Exception ex)
{
iQExceptionHandler.TreatException(ex, new object[] { criteria.Query });
}
this.RaiseListChangedEvents = true;
}
public static InputInvoiceList GetList(QueryConditions conditions, bool childs)
{
return(GetList(InputInvoiceSQL.SELECT(conditions), childs));
}
public static InputInvoices GetList(bool childs = true)
{
return(GetList(childs, InputInvoiceSQL.SELECT()));
}
public static InputInvoices GetList(Library.Store.QueryConditions conditions, bool childs, int sessionCode)
{
return(GetList(childs, InputInvoiceSQL.SELECT(conditions), sessionCode));
}
public static InputInvoices GetChildList(int sessionCode, List <long> oid_list, bool childs)
{
return(GetChildList(sessionCode, InputInvoiceSQL.SELECT(new QueryConditions {
OidList = oid_list
}), childs));
}
