Ejemplo n.º 1
0
        /// <summary>
        /// Search supplier goodsin line by given parameter
        /// Call Proc [usp_itemsearch_SupplierInvoice_GoodsInLine]
        /// </summary>
        /// <param name="clientId"></param>
        /// <param name="orderBy"></param>
        /// <param name="sortDir"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="companyNo"></param>
        /// <param name="includeInvoiced"></param>
        /// <param name="giLineDateFrom"></param>
        /// <param name="giLineDateTo"></param>
        /// <returns></returns>
        public static List <SupplierInvoiceLine> ItemSearch(System.Int32?clientId, System.Int32?orderBy, System.Int32?sortDir, System.Int32?pageIndex, System.Int32?pageSize, System.Int32 companyNo, System.Boolean?includeInvoiced, System.DateTime?giLineDateFrom, System.DateTime?giLineDateTo, System.Int32?goodsInNo, System.Boolean?IsPoHub, bool?isClientInvoice, System.Int32?poNoLo, System.Int32?poNoHi)
        {
            List <SupplierInvoiceLineDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.SupplierInvoiceLine.ItemSearch(clientId, orderBy, sortDir, pageIndex, pageSize, companyNo, includeInvoiced, giLineDateFrom, giLineDateTo, goodsInNo, IsPoHub, isClientInvoice, poNoLo, poNoHi);

            if (lstDetails == null)
            {
                return(new List <SupplierInvoiceLine>());
            }
            else
            {
                List <SupplierInvoiceLine> lst = new List <SupplierInvoiceLine>();
                foreach (SupplierInvoiceLineDetails objDetails in lstDetails)
                {
                    Rebound.GlobalTrader.BLL.SupplierInvoiceLine obj = new Rebound.GlobalTrader.BLL.SupplierInvoiceLine();
                    obj.GoodsInLineNo       = objDetails.GoodsInLineNo;
                    obj.GoodsInNumber       = objDetails.GoodsInNumber;
                    obj.Part                = objDetails.Part;
                    obj.PurchaseOrderNumber = objDetails.PurchaseOrderNumber;
                    obj.QtyReceived         = objDetails.QtyReceived;
                    obj.Price               = objDetails.Price;
                    obj.ShipInCost          = objDetails.ShipInCost;
                    obj.NPRPrinted          = objDetails.NPRPrinted;
                    obj.CurrencyNo          = objDetails.CurrencyNo;
                    obj.CurrencyCode        = objDetails.CurrencyCode;
                    obj.RowNum              = objDetails.RowNum;
                    obj.RowCnt              = objDetails.RowCnt;
                    obj.DateReceived        = objDetails.DateReceived;
                    obj.GoodsInNo           = objDetails.GoodsInNo;
                    lst.Add(obj);
                    obj = null;
                }
                lstDetails = null;
                return(lst);
            }
        }
Ejemplo n.º 2
0
        /// <summary>
        /// Get supplierinvoiceline by ID
        /// Call Proc [usp_selectAll_SupplierInvoiceLine_for_SupplierInvoice]
        /// </summary>
        /// <param name="SupplierInvoiceId"></param>
        /// <returns></returns>
        public static List <SupplierInvoiceLine> GetListForSupplierInvoiceLine(System.Int32?SupplierInvoiceId)
        {
            List <SupplierInvoiceLineDetails> lstDetails = Rebound.GlobalTrader.DAL.SiteProvider.SupplierInvoiceLine.GetListForSupplierInvoiceLine(SupplierInvoiceId);

            if (lstDetails == null)
            {
                return(new List <SupplierInvoiceLine>());
            }
            else
            {
                List <SupplierInvoiceLine> lst = new List <SupplierInvoiceLine>();
                foreach (SupplierInvoiceLineDetails objDetails in lstDetails)
                {
                    Rebound.GlobalTrader.BLL.SupplierInvoiceLine obj = new Rebound.GlobalTrader.BLL.SupplierInvoiceLine();
                    obj.SupplierInvoiceLineId = objDetails.SupplierInvoiceLineId;
                    obj.SupplierInvoiceNo     = objDetails.SupplierInvoiceNo;
                    obj.GoodsInNo             = objDetails.GoodsInNo;
                    obj.GoodsInNumber         = objDetails.GoodsInNumber;
                    obj.Part          = objDetails.Part;
                    obj.SupplierPart  = objDetails.SupplierPart;
                    obj.UnitPrice     = objDetails.UnitPrice;
                    obj.QtyReceived   = objDetails.QtyReceived;
                    obj.Landedcost    = objDetails.Landedcost;
                    obj.DateReceived  = objDetails.DateReceived;
                    obj.StockNo       = objDetails.StockNo;
                    obj.ROHS          = objDetails.ROHS;
                    obj.DLUP          = objDetails.DLUP;
                    obj.UpdatedBy     = objDetails.UpdatedBy;
                    obj.CurrencyNo    = objDetails.CurrencyNo;
                    obj.CurrencyCode  = objDetails.CurrencyCode;
                    obj.GoodsInLineNo = objDetails.GoodsInLineNo;

                    obj.PackageNo                   = objDetails.PackageNo;
                    obj.ProductName                 = objDetails.ProductName;
                    obj.CountryOfManufacture        = objDetails.CountryOfManufacture;
                    obj.DateCode                    = objDetails.DateCode;
                    obj.InternalPurchaseOrderId     = objDetails.InternalPurchaseOrderId;
                    obj.InternalPurchaseOrderNumber = objDetails.InternalPurchaseOrderNumber;
                    obj.ShipInCost                  = objDetails.ShipInCost;
                    obj.BuyerName                   = objDetails.BuyerName;
                    obj.BuyerNo = objDetails.BuyerNo;

                    lst.Add(obj);
                    obj = null;
                }
                lstDetails = null;
                return(lst);
            }
        }