private static OutputInvoiceLineList GetList(string query, bool childs) { CriteriaEx criteria = OutputInvoiceLine.GetCriteria(OutputInvoiceLine.OpenSession()); criteria.Childs = childs; criteria.Query = query; OutputInvoiceLineList list = DataPortal.Fetch <OutputInvoiceLineList>(criteria); CloseSession(criteria.SessionCode); return(list); }
public static OutputInvoiceLineList GetChildList(OutputInvoiceInfo parent, bool childs) { CriteriaEx criteria = OutputInvoiceLine.GetCriteria(OutputInvoiceLine.OpenSession()); criteria.Query = SELECT(parent); criteria.Childs = childs; OutputInvoiceLineList list = DataPortal.Fetch <OutputInvoiceLineList>(criteria); list.CloseSession(); return(list); }
public static long GetCountByExpediente(long oid_exp) { CriteriaEx criteria = OutputInvoiceLine.GetCriteria(OutputInvoiceLine.OpenSession()); criteria.Childs = false; criteria.Query = OutputInvoiceLine.COUNT_BY_EXPEDIENTE(oid_exp); IDataReader reader = nHManager.Instance.SQLNativeSelect(criteria.Query, criteria.Session); reader.Read(); long cuenta = Convert.ToInt64(reader["CUENTA"]); CloseSession(criteria.SessionCode); return(cuenta); }
/// <summary> /// Retrieve the complete list from db /// </summary> /// <param name="get_childs">retrieving the childs</param> /// <returns>ConceptoFacturaList</returns> public static OutputInvoiceLineList GetChildList(bool childs) { CriteriaEx criteria = OutputInvoiceLine.GetCriteria(OutputInvoiceLine.OpenSession()); criteria.Childs = childs; if (nHManager.Instance.UseDirectSQL) { criteria.Query = SELECT(); } OutputInvoiceLineList list = DataPortal.Fetch <OutputInvoiceLineList>(criteria); CloseSession(criteria.SessionCode); return(list); }
public static OutputInvoiceLineList GetListByExpediente(long oidExpedient, bool childs) { CriteriaEx criteria = OutputInvoiceLine.GetCriteria(OutputInvoiceLine.OpenSession()); criteria.Childs = childs; Library.Invoice.QueryConditions conditions = new Library.Invoice.QueryConditions { Expediente = ExpedientInfo.New(oidExpedient) }; criteria.Query = OutputInvoiceLineList.SELECT(conditions); OutputInvoiceLineList list = DataPortal.Fetch <OutputInvoiceLineList>(criteria); CloseSession(criteria.SessionCode); return(list); }
public void CopyValues(OutputInvoiceLine source) { if (source == null) { return; } _record.CopyValues(source.Base.Record); _oid_almacen = source.OidAlmacen; _store = source.Almacen; _store_id = source.StoreID; _expediente = source.Expediente; _cuenta_contable = source.CuentaContable; _n_factura = source.NFactura; _fecha_factura = source.FechaFactura; _cliente = source.Cliente; }
public static string SELECT(Library.Invoice.QueryConditions conditions) { return(OutputInvoiceLine.SELECT(conditions, false)); }
public static string SELECT() { return(OutputInvoiceLine.SELECT(new QueryConditions(), false)); }
public void CopyFrom(OutputInvoiceLine source) { _base.CopyValues(source); }