/// <summary> /// Copia los atributos del objeto /// </summary> /// <param name="source">Objeto origen</param> protected void CopyValues(ProveedorInfo source) { if (source == null) { return; } _base.CopyValues(source); Oid = source.Oid; }
public void CopyValues(ProveedorInfo source) { if (source == null) { return; } _record.CopyValues(source.Base.Record); _provider_base.CopyCommonValues(source); _provider_base.OidAcreedor = _record.Oid; }
/// <summary> /// Borrado inmediato, no cabe "undo" /// (La función debe ser "estática") /// </summary> /// <param name="oid"></param> public static void Delete(long oid, ETipoAcreedor providerType) { if (!CanDeleteObject()) { throw new System.Security.SecurityException(moleQule.Resources.Messages.USER_NOT_ALLOWED); } ProveedorInfo item = ProveedorInfo.Get(oid, providerType, false); ProviderBase.IsPosibleDelete(oid, item.ETipoAcreedor); DataPortal.Delete(new CriteriaCs(oid)); }
public static ProductList GetListByProveedorByFamilia(long oid, ETipoFamilia familia, bool childs) { CriteriaEx criteria = Product.GetCriteria(Product.OpenSession()); criteria.Childs = childs; ProveedorInfo item = Proveedor.New().GetInfo(); item.Oid = oid; criteria.Query = ProductList.SELECT(item, familia); ProductList list = DataPortal.Fetch <ProductList>(criteria); CloseSession(criteria.SessionCode); return(list); }
public static TrazabilidadList GetCabezasList(ProductInfo producto, ProveedorInfo proveedor, LivestockBookLineInfo bookLine, DateTime fc_ini, DateTime fc_fin, DateTime fv_ini, DateTime fv_fin) { CriteriaEx criteria = Product.GetCriteria(Product.OpenSession()); criteria.Childs = false; criteria.Query = TrazabilidadList.SELECT_CABEZA(producto, proveedor, bookLine, fc_ini, fc_fin, fv_ini, fv_fin); TrazabilidadList list = DataPortal.Fetch <TrazabilidadList>(criteria); CloseSession(criteria.SessionCode); return(list); }
public static TrazabilidadList GetList(ProductInfo producto, ProveedorInfo proveedor, DateTime fc_ini, DateTime fc_fin, DateTime fv_ini, DateTime fv_fin) { CriteriaEx criteria = Product.GetCriteria(Product.OpenSession()); criteria.Childs = false; //No criteria. Retrieve all de List if (nHManager.Instance.UseDirectSQL) { criteria.Query = TrazabilidadList.SELECT(producto, proveedor, fc_ini, fc_fin, fv_ini, fv_fin); } TrazabilidadList list = DataPortal.Fetch <TrazabilidadList>(criteria); CloseSession(criteria.SessionCode); return(list); }
public static string SELECT(ProveedorInfo item, ETipoFamilia familia) { return(Product.SELECT(item, familia, false)); }
public static string SELECT(ProveedorInfo item) { return(Product.SELECT(item, false)); }
/// <summary> /// Construye el SELECT para traer la trazabilidad de las cabezas de ganado /// </summary> /// <param name="schema"></param> /// <param name="oid"></param> /// <returns></returns> public static string SELECT_CABEZA(ProductInfo product, ProveedorInfo supplier, LivestockBookLineInfo bookLine, DateTime fc_ini, DateTime fc_fin, DateTime fv_ini, DateTime fv_fin) { string pr = nHManager.Instance.GetSQLTable(typeof(moleQule.Store.Data.ProductRecord)); string su = nHManager.Instance.GetSQLTable(typeof(moleQule.Store.Data.SupplierRecord)); string pe = nHManager.Instance.GetSQLTable(typeof(moleQule.Store.Data.BatchRecord)); string idl = nHManager.Instance.GetSQLTable(typeof(moleQule.Store.Data.InputDeliveryLineRecord)); string id = nHManager.Instance.GetSQLTable(typeof(moleQule.Store.Data.InputDeliveryRecord)); string ex = nHManager.Instance.GetSQLTable(typeof(moleQule.Store.Data.ExpedientRecord)); string lbl = nHManager.Instance.GetSQLTable(typeof(LivestockBookLineRecord)); string nv = nHManager.Instance.GetSQLTable(typeof(moleQule.Store.Data.ShippingCompanyRecord)); string tr = nHManager.Instance.GetSQLTable(typeof(moleQule.Store.Data.TransporterRecord)); string cfc = nHManager.Instance.GetSQLTable(typeof(moleQule.Invoice.Data.OutputInvoiceLineRecord)); string fc = nHManager.Instance.GetSQLTable(typeof(moleQule.Invoice.Data.OutputInvoiceRecord)); string se = nHManager.Instance.GetSQLTable(typeof(moleQule.Store.Data.SerieRecord)); string cl = nHManager.Instance.GetSQLTable(typeof(moleQule.Invoice.Data.ClientRecord)); string query; // PRODUCTOS VENDIDOS query = "SELECT 1 AS \"TIPO_CONSULTA\"" + " ,P.*" + " ,E.\"CODIGO\" AS \"NEXPEDIENTE\"" + " ,COALESCE(AP.\"FECHA\", BA.\"FECHA_COMPRA\") AS \"FECHA_COMPRA\"" + //" ,PE.\"FECHA_COMPRA\" AS \"FECHA_COMPRA\"" + " ,BA.\"OID\" AS \"OID_BATCH\"" + " ,N.\"NOMBRE\" AS \"NAVIERA\"" + " ,O.\"NOMBRE\" AS \"TRANS_ORIGEN\"" + " ,D.\"NOMBRE\" AS \"TRANS_DESTINO\"" + " ,PR.\"OID\" AS \"OID_PROVEEDOR\"" + " ,PR.\"NOMBRE\" AS \"PROVEEDOR\""+ " ,CF.\"OID\" AS \"OID_CONCEPTO\"" + " ,CF.\"CANTIDAD\" AS \"KILOS_VENDIDOS\""+ " ,F.\"FECHA\" AS \"FECHA_VENTA\"" + " ,S.\"IDENTIFICADOR\" AS \"ID_SERIE\"" + " ,S.\"NOMBRE\" AS \"SERIE\""+ " ,C.\"OID\" AS \"OID_CLIENTE\"" + " ,C.\"NOMBRE\" AS \"CLIENTE\""+ " ,LL.\"IDENTIFICADOR\" AS \"ID\"" + " ,LL.\"RAZA\" AS \"RAZA\"" + " ,LL.\"SEXO\" AS \"SEXO\"" + " ,E.\"FECHA_LLEGADA_MUELLE\" AS \"FECHA_LLEGADA_MUELLE\"" + " ,C.\"CODIGO_EXPLOTACION\" AS \"CODIGO_EXPLOTACION\"" + " FROM " + pr + " AS P " + " INNER JOIN " + pe + " AS BA ON BA.\"OID_PRODUCTO\" = P.\"OID\"" + " LEFT JOIN " + idl + " AS CAP ON CAP.\"OID_BATCH\" = BA.\"OID\"" + " LEFT JOIN " + id + " AS AP ON AP.\"OID\" = CAP.\"OID_ALBARAN\"" + " INNER JOIN " + ex + " AS E ON E.\"OID\" = BA.\"OID_EXPEDIENTE\"" + " INNER JOIN " + lbl + " AS LL ON LL.\"OID_BATCH\" = BA.\"OID\"" + " LEFT JOIN " + nv + " AS N ON N.\"OID\" = E.\"OID_NAVIERA\"" + " LEFT JOIN " + tr + " AS O ON O.\"OID\" = E.\"OID_TRANS_ORIGEN\"" + " LEFT JOIN " + tr + " AS D ON D.\"OID\" = E.\"OID_TRANS_DESTINO\"" + " INNER JOIN " + su + " AS PR ON PR.\"OID\" = BA.\"OID_PROVEEDOR\"" + " INNER JOIN " + cfc + " AS CF ON CF.\"OID_BATCH\" = BA.\"OID\"" + " INNER JOIN " + fc + " AS F ON F.\"OID\" = CF.\"OID_FACTURA\"" + " INNER JOIN " + se + " AS S ON F.\"OID_SERIE\" = S.\"OID\"" + " INNER JOIN " + cl + " AS C ON C.\"OID\" = F.\"OID_CLIENTE\"" + " WHERE (1 = 1)"; if (product != null) { query += " AND P.\"OID\" = " + product.Oid; } if (supplier != null) { query += " AND PR.\"OID\" = " + supplier.Oid; } if (bookLine != null) { query += " AND LL.\"OID\" = " + bookLine.Oid; } query += " AND \"FECHA_COMPRA\" >= '" + fc_ini.ToString("MM/dd/yyyy") + "' AND \"FECHA_COMPRA\" <= '" + fc_fin.ToString("MM/dd/yyyy") + "'"; query += " AND F.\"FECHA\" >= '" + fv_ini.ToString("MM/dd/yyyy") + "' AND F.\"FECHA\" <= '" + fv_fin.ToString("MM/dd/yyyy") + "'"; query += " ORDER BY P.\"NOMBRE\", PR.\"NOMBRE\", E.\"CODIGO\""; return(query); }