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)); }
public static InputDeliveryLineList GetByAlbaranList(long oid, bool childs) { QueryConditions conditions = new QueryConditions { InputDelivery = InputDeliveryInfo.New(oid) }; return(GetList(InputDeliveryLineSQL.SELECT(conditions, false), childs)); }
public static string SELECT(InputDelivery delivery) { string query; QueryConditions conditions = new QueryConditions { InputDelivery = delivery.GetInfo(false) }; query = InputDeliveryLineSQL.SELECT(conditions, true); return(query); }
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 string SELECT_BY_EXPEDIENTE_STOCK(QueryConditions conditions) { return(InputDeliveryLineSQL.SELECT_STOCK(conditions, false)); }
public static string SELECT(QueryConditions conditions) { return(InputDeliveryLineSQL.SELECT(conditions, false)); }