Example #1
0
        /// <summary>
        /// 查询结果集封装对象
        /// </summary>
        /// <param name="coll"></param>
        /// <returns></returns>
        private HashSet <SalOutStockBillInfo> BuildSalOutStockBillInfo(DynamicObjectCollection coll)
        {
            HashSet <SalOutStockBillInfo> bills = new HashSet <SalOutStockBillInfo>();
            SalOutStockBillInfo           bill  = null;

            List <SalOutStockEntry> entries = null;
            SalOutStockEntry        entry   = null;

            if (coll != null && coll.Count > 0)
            {
                var groups = from l in coll group l by l.DynamicObjectType.Properties.Contains("FBillNo") into g select g;

                foreach (var group in groups)
                {
                    if (group != null && group.Count() > 0)
                    {
                        bill    = new SalOutStockBillInfo();
                        entries = new List <SalOutStockEntry>();

                        bill.SrcNo            = SQLUtils.GetFieldValue(group.ElementAt(0), "FBillNo");
                        bill.OrderBillNo      = SQLUtils.GetFieldValue(group.ElementAt(0), "FBillNo");
                        bill.CustomerNo       = SQLUtils.GetFieldValue(group.ElementAt(0), "customerID");
                        bill.CarriageNO       = SQLUtils.GetFieldValue(group.ElementAt(0), "FCARRYBILLNO");
                        bill.DeliDate         = SQLUtils.GetFieldValue(group.ElementAt(0), "F_HS_DeliDate");
                        bill.LogisticsChannel = SQLUtils.GetLogisticsChannelNo(this.Context, SQLUtils.GetFieldValue(group.ElementAt(0), "F_HS_Channel"));
                        bill.QueryURL         = SQLUtils.GetFieldValue(group.ElementAt(0), "F_HS_QueryURL");

                        foreach (var item in group)
                        {
                            if (item != null)
                            {
                                entry            = new SalOutStockEntry();
                                entry.MaterialNo = SQLUtils.GetFieldValue(item, "materialNO");
                                entry.Quantity   = Convert.ToDecimal(SQLUtils.GetFieldValue(item, "QTY"));
                                entries.Add(entry);
                            }
                        }

                        bill.StockEntry = entries;
                        bills.Add(bill);
                    }
                }
            }

            return(bills);
        }
        /// <summary>
        /// 查询结果集封装对象
        /// </summary>
        /// <param name="coll"></param>
        /// <returns></returns>
        private List <SalOutStockBillInfo> BuildSalOutStockBillInfo(DynamicObjectCollection coll)
        {
            List <SalOutStockBillInfo> bills = new List <SalOutStockBillInfo>();
            SalOutStockBillInfo        bill  = null;
            SalOutStockEntry           entry = null;

            if (coll != null && coll.Count > 0)
            {
                foreach (var item in coll)
                {
                    if (item != null)
                    {
                        bill = new SalOutStockBillInfo();

                        bill.SrcNo            = SQLUtils.GetFieldValue(item, "FDeliBillNo");
                        bill.BillNo           = SQLUtils.GetFieldValue(item, "FDeliBillNo");
                        bill.OrderBillNo      = SQLUtils.GetFieldValue(item, "FBillNo");
                        bill.CustomerNo       = SQLUtils.GetFieldValue(item, "customerID");
                        bill.CarriageNO       = SQLUtils.GetFieldValue(item, "F_HS_CARRYBILLNO");
                        bill.DeliDate         = SQLUtils.GetFieldValue(item, "F_HS_DeliDate");
                        bill.LogisticsChannel = SQLUtils.GetLogisticsChannelNo(this.K3CloudContext, SQLUtils.GetFieldValue(item, "F_HS_Channel"));
                        bill.QueryURL         = SQLUtils.GetFieldValue(item, "F_HS_QueryURL");

                        entry                    = new SalOutStockEntry();
                        entry.StockName          = SQLUtils.GetFieldValue(item, "F_HS_STOCKHSNAME");
                        entry.MaterialNo         = SQLUtils.GetFieldValue(item, "materialNO");
                        entry.Quantity           = Convert.ToDecimal(SQLUtils.GetFieldValue(item, "QTY"));
                        entry.Price              = Math.Round(Convert.ToDecimal(SQLUtils.GetFieldValue(item, "price")), 4);
                        entry.IntegralReturnRate = Convert.ToDecimal(SQLUtils.GetFieldValue(item, "F_HS_IntegralReturnRate"));
                        bill.StockEntry.Add(entry);
                        bills.Add(bill);
                    }
                }
            }

            return(bills);
        }
        /// <summary>
        /// 获取明细信息
        /// </summary>
        /// <param name="bills"></param>
        /// <returns></returns>
        private static List <SalOutStockEntry> GetSalOutStockEntry(List <SalOutStockBillInfo> bills)
        {
            List <SalOutStockEntry> entries = null;
            SalOutStockEntry        entry   = null;

            if (bills != null && bills.Count > 0)
            {
                entries = new List <SalOutStockEntry>();

                foreach (var bill in bills)
                {
                    if (bill != null)
                    {
                        if (bill.StockEntry != null && bill.StockEntry.Count > 0)
                        {
                            foreach (var en in bill.StockEntry)
                            {
                                if (en != null)
                                {
                                    entry = new SalOutStockEntry();

                                    entry.StockName          = en.StockName;
                                    entry.MaterialNo         = en.MaterialNo;
                                    entry.Quantity           = en.Quantity;
                                    entry.Price              = en.Price;
                                    entry.IntegralReturnRate = en.IntegralReturnRate;
                                    entries.Add(entry);
                                }
                            }
                        }
                    }
                }
            }

            return(entries);
        }