public static InputDeliveryLineList GetByExpedienteStockList(long oid, bool childs, InputDeliveryInfo albaran) { QueryConditions conditions = new QueryConditions { Expedient = ExpedientInfo.New(oid), TipoAcreedor = new ETipoAcreedor[1] { ETipoAcreedor.Proveedor } }; InputDeliveryLineList list = GetList(InputDeliveryLineSQL.SELECT_STOCK(conditions, false), childs); List <InputDeliveryLineInfo> merge = new List <InputDeliveryLineInfo>(); foreach (InputDeliveryLineInfo ca in albaran.ConceptoAlbaranes) { if (ca.OidExpediente == oid) { merge.Add(ca); } } foreach (InputDeliveryLineInfo ca in list) { if (ca.OidAlbaran != albaran.Oid) { merge.Add(ca); } } return(InputDeliveryLineList.GetChildList(merge)); }
protected void CopyValues(ExpedientInfo source) { if (source == null) { return; } _base.CopyValues(source); if (source.Teus20) { _contenedor_teus20 = source.Contenedor; } else { _contenedor_teus40 = source.Contenedor; } _base.AyudaEstimada = source.AyudaEstimada; _base.AyudaCobrada = source.AyudaCobrada; _base.AyudaPendiente = source.AyudaPendiente; _base.StockBultos = source.StockBultos; _base.StockKilos = source.StockKilos; _base.KilosTotal = source.Kilos; _base.BultosTotal = source.Bultos; _base.Proveedor = source.Proveedor; _base.Despachante = source.Despachante; _base.NombreTransDest = source.NombreTransDest; _base.NombreTransOrig = source.NombreTransOrig; _base.Naviera = source.Naviera; }
public static string SELECT_PRODUCT(QueryConditions conditions, ExpedientInfo from, ExpedientInfo till, bool soloStock) { string query = string.Empty; query = Stock.SELECT_MOVEMENTS_PRODUCT(conditions); if (from != null) { query += " AND EX.\"CODIGO\" >='" + from.Codigo + "'"; } if (till != null) { query += " AND EX.\"CODIGO\" <='" + till.Codigo + "'"; } if (soloStock) { query += " AND (ST2.\"STOCK_KG\" > 0) AND (ST2.\"STOCK_BULTO\" > 0)"; } query += " ORDER BY ST.\"OID_PRODUCTO\", ST.\"FECHA\", ST.\"OID\""; return(query); }
public static WorkReportList GetByExpedientList(long oidExpedient, bool childs) { QueryConditions conditions = new QueryConditions { Expedient = ExpedientInfo.New(oidExpedient) }; return(GetList(SELECT(conditions), childs)); }
public static string SELECT(ExpedientInfo item) { string query = SELECT(new QueryConditions { Expedient = item }); query += " ORDER BY \"ID_PARTIDA\", ST.\"FECHA\", ST.\"OID\""; return(query); }
public static InputDeliveryList GetListByPartidasExpediente(bool childs, long oidExp) { QueryConditions conditions = new QueryConditions { Expedient = ExpedientInfo.New(oidExp) }; return(GetList(childs, SELECT(conditions))); }
public static LivestockBookLineList GetByExpedienteList(long oidExpedient, bool childs) { QueryConditions conditions = new QueryConditions { Expedient = ExpedientInfo.New(oidExpedient) }; return(GetList(SELECT_BY_EXPEDIENTE(conditions), false)); }
public static LivestockBooks GetByExpedienteList(long oidExpediente, bool childs) { QueryConditions conditions = new QueryConditions { Expedient = ExpedientInfo.New(oidExpediente), TipoExpediente = ETipoExpediente.Ganado }; return(GetList(LivestockBooks.SELECT(conditions), childs)); }
public static LineaFomentoList GetChildList(ExpedientInfo parent, bool childs) { CriteriaEx criteria = LineaFomento.GetCriteria(LineaFomento.OpenSession()); criteria.Query = LineaFomentoList.SELECT(parent); criteria.Childs = childs; LineaFomentoList list = DataPortal.Fetch <LineaFomentoList>(criteria); CloseSession(criteria.SessionCode); return(list); }
public static ExpedienteREAList GetChildList(ExpedientInfo parent, bool childs) { CriteriaEx criteria = REAExpedient.GetCriteria(REAExpedient.OpenSession()); criteria.Query = ExpedienteREAList.SELECT(parent); criteria.Childs = childs; ExpedienteREAList list = DataPortal.Fetch <ExpedienteREAList>(criteria); CloseSession(criteria.SessionCode); return(list); }
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 InputDeliveryLineList GetByExpedienteList(long oid, bool childs) { QueryConditions conditions = new QueryConditions { Expedient = ExpedientInfo.New(oid), TipoAcreedor = new ETipoAcreedor[1] { ETipoAcreedor.Proveedor } }; return(GetList(InputDeliveryLineSQL.SELECT(conditions, false), childs)); }
public static PayrollList GetList(QueryConditions conditions, ExpedientInfo ini, ExpedientInfo fin) { CriteriaEx criteria = Stock.GetCriteria(Payroll.OpenSession()); criteria.Childs = false; criteria.Query = PayrollList.SELECT(conditions, ini, fin); PayrollList list = DataPortal.Fetch <PayrollList>(criteria); CloseSession(criteria.SessionCode); return(list); }
public static PayrollList GetChildList(ExpedientInfo parent, bool childs) { CriteriaEx criteria = Payroll.GetCriteria(Payroll.OpenSession()); criteria.Query = PayrollList.SELECT(parent); criteria.Childs = childs; PayrollList list = DataPortal.Fetch <PayrollList>(criteria); CloseSession(criteria.SessionCode); return(list); }
public static ExpenseList GetList(QueryConditions conditions, ExpedientInfo fromExp, ExpedientInfo tillExp) { CriteriaEx criteria = Stock.GetCriteria(Expense.OpenSession()); criteria.Childs = false; criteria.Query = ExpenseList.SELECT(conditions, fromExp, tillExp); ExpenseList list = DataPortal.Fetch <ExpenseList>(criteria); CloseSession(criteria.SessionCode); return(list); }
public static CabezaList GetChildList(ExpedientInfo parent, bool childs) { CriteriaEx criteria = Cabeza.GetCriteria(Cabeza.OpenSession()); criteria.Query = SELECT(parent); criteria.Childs = childs; CabezaList list = DataPortal.Fetch <CabezaList>(criteria); list.CloseSession(); return(list); }
public static StockList GetChildList(ExpedientInfo parent, bool childs, bool throwStockException) { CriteriaEx criteria = Stock.GetCriteria(Stock.OpenSession()); criteria.Query = StockList.SELECT(parent); criteria.Childs = childs; StockList list = DataPortal.Fetch <StockList>(criteria); list.UpdateStocksByBatch(throwStockException); CloseSession(criteria.SessionCode); return(list); }
protected void CopyValues(ExpedientInfo source, ExpenseList list , InputDeliveryLineList conceptos , InputDeliveryList albaranes) { if (source == null) { return; } Oid = source.Oid; Expediente = source.Codigo; foreach (ExpenseInfo item in list) { if (item.OidExpediente == source.Oid) { CheckGasto(item); } } foreach (InputDeliveryLineInfo item in conceptos) { if (item.OidExpediente == source.Oid) { CheckGasto(list, albaranes.GetItem(item.OidAlbaran)); } } if (Proveedor != null) { Proveedor = Proveedor.Substring(0, Proveedor.Length - 1); } if (Naviera != null) { Naviera = Naviera.Substring(0, Naviera.Length - 1); } if (Despachante != null) { Despachante = Despachante.Substring(0, Despachante.Length - 1); } if (TransportistaOrigen != null) { TransportistaOrigen = TransportistaOrigen.Substring(0, TransportistaOrigen.Length - 1); } if (TransportistaDestino != null) { TransportistaDestino = TransportistaDestino.Substring(0, TransportistaDestino.Length - 1); } }
/// <summary> /// Retrieve the complete list from db /// </summary> /// <param name="get_childs">retrieving the childs</param> /// <returns></returns> public static InventarioValoradoList GetListStock(ETipoExpediente tipo, ExpedientInfo expediente, DateTime fecha) { CriteriaEx criteria = Product.GetCriteria(Product.OpenSession()); criteria.Childs = false; criteria.Query = InventarioValoradoList.SELECT_WITH_STOCK(tipo, expediente, fecha); InventarioValoradoList list = DataPortal.Fetch <InventarioValoradoList>(criteria); CloseSession(criteria.SessionCode); return(list); }
public static InputDeliveryLineList GetByExpedienteStockList(QueryConditions conditions , ExpedientInfo ini , ExpedientInfo fin) { CriteriaEx criteria = InputDeliveryLine.GetCriteria(InputDeliveryLine.OpenSession()); criteria.Childs = false; criteria.Query = InputDeliveryLineList.SELECT_BY_EXPEDIENTE_STOCK(conditions, ini, fin); InputDeliveryLineList list = DataPortal.Fetch <InputDeliveryLineList>(criteria); CloseSession(criteria.SessionCode); return(list); }
public static ProductList GetListByExpediente(long oid, bool childs) { CriteriaEx criteria = Product.GetCriteria(Product.OpenSession()); criteria.Childs = childs; ExpedientInfo item = Expedient.New().GetInfo(); item.Oid = oid; criteria.Query = ProductList.SELECT(item); ProductList list = DataPortal.Fetch <ProductList>(criteria); CloseSession(criteria.SessionCode); return(list); }
public static LivestockBookLines GetChildListByExpediente(LivestockBook parent, long oidExpediente, bool childs) { CriteriaEx criteria = Stock.GetCriteria(parent.SessionCode); criteria.Childs = childs; QueryConditions conditions = new QueryConditions { LibroGanadero = parent.GetInfo(false), Expedient = ExpedientInfo.New(oidExpediente) }; criteria.Query = LivestockBookLines.SELECT(conditions); return(DataPortal.Fetch <LivestockBookLines>(criteria)); }
public static Batchs GetChildListByExpediente(Almacen parent, long oidExpedient, bool childs) { CriteriaEx criteria = Stock.GetCriteria(parent.SessionCode); criteria.Childs = childs; QueryConditions conditions = new QueryConditions { Almacen = parent.GetInfo(false), Expedient = ExpedientInfo.New(oidExpedient) }; criteria.Query = Batchs.SELECT(conditions); return(DataPortal.Fetch <Batchs>(criteria)); }
public static WorkReportResourceList GetList(long oidExpedient, ETipoEntidad entityType, bool clustered, bool childs = true) { QueryConditions conditions = new QueryConditions { Expedient = ExpedientInfo.New(oidExpedient), EntityType = entityType }; if (clustered) { conditions.Groups = new GroupList(); conditions.Groups.NewGroup("OidResource", typeof(WorkReportResource)); conditions.Groups.NewGroup("EntityType", typeof(WorkReportResource)); } return(GetList(SELECT(conditions), childs)); }
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); }
public static WorkReportResourceList GetByCategoryList(long oidCategory, long oidExpedient, bool clustered, bool childs = true) { QueryConditions conditions = new QueryConditions { Expedient = (oidExpedient != 0) ? ExpedientInfo.New(oidExpedient) : null, WorkReportCategory = (oidCategory != 0) ? WorkReportCategoryInfo.New(oidCategory) : null, Orders = new OrderList() }; conditions.Orders.NewOrder("CategoryMax", ListSortDirection.Ascending, typeof(WorkReportCategory)); if (clustered) { conditions.Groups = new GroupList(); conditions.Groups.NewGroup("OidCategory", typeof(WorkReportResource)); } return(GetList(SELECT(conditions), childs)); }
public static StockList GetList(QueryConditions conditions, ExpedientInfo from, ExpedientInfo till, bool soloStock, bool throwStockException) { CriteriaEx criteria = Stock.GetCriteria(Stock.OpenSession()); criteria.Childs = true; criteria.Query = StockList.SELECT_BATCH(conditions, from, till, soloStock); StockList list = DataPortal.Fetch <StockList>(criteria); list.UpdateStocksByBatch(throwStockException); CloseSession(criteria.SessionCode); return(list); }
public static string SELECT(QueryConditions conditions, ExpedientInfo ini, ExpedientInfo fin) { string query = string.Empty; query = SELECT(conditions); if (ini != null) { query += " AND EX.\"CODIGO\" >='" + ini.Codigo + "'"; } if (fin != null) { query += " AND EX.\"CODIGO\" <='" + fin.Codigo + "'"; } query += " ORDER BY EX.\"CODIGO\", GT.\"CODIGO\""; return(query); }
public static string SELECT_BY_EXPEDIENTE_STOCK(QueryConditions conditions, ExpedientInfo ini, ExpedientInfo fin) { string query = string.Empty; query = SELECT_BY_EXPEDIENTE_STOCK(conditions); if (ini != null) { query += " AND GA.\"CODIGO\" >='" + ini.Codigo + "'"; } if (fin != null) { query += " AND GA.\"CODIGO\" <='" + fin.Codigo + "'"; } query += " GROUP BY CA.\"OID_ALBARAN\", GA.\"CODIGO\"" + " ORDER BY GA.\"CODIGO\", \"OID\""; return(query); }
public static Stocks GetListByExpediente(long oidExpedient) { if (!Stock.CanEditObject()) { throw new System.Security.SecurityException(moleQule.Resources.Messages.USER_NOT_ALLOWED); } CriteriaEx criteria = Stock.GetCriteria(Stock.OpenSession()); criteria.Childs = false; QueryConditions conditions = new QueryConditions { Expedient = ExpedientInfo.New(oidExpedient) }; criteria.Query = Stocks.SELECT(conditions); Stock.BeginTransaction(criteria.SessionCode); return(DataPortal.Fetch <Stocks>(criteria)); }