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)); }