将多个采购单对应的所有的商品全部插入到入库实体中

//将多个采购单对应的所有的商品全部插入到入库实体中  其中一个采购单对应多个采购商品
// 例如现在有三个采购单，第一个采购单中的商品有a个、第二个采购单中的商品有b个、第三个采购单中的商品有c个，那么就需要在入库实体中插入的记录个数为 a+b+c条记录


 [HttpGet]
        public ExtJsListResult<RuKu> List(string QueryCondition, int PageNo, int RowCountPerPage, string[] CaiGouDanIDs, string[] GongYingShangID)
        {
            var r = new ExtJsListResult<RuKu>();
            if (CaiGouDanIDs.Length == 0)
            {
                return _ioc.Query<RuKu>()
                .QueryCondition(QueryCondition)
             
                .ToListOutIncludeFields(PageNo, RowCountPerPage, _listFields);
            }
            else
            {
                for (var j = 0; j < CaiGouDanIDs.Length; j++)
                {
                    var caiGouDan = _ioc.Query<CaiGouDan>().Where(e => e.ID.ToString("") == CaiGouDanIDs[j]).FirstOrDefault();
                    if (caiGouDan != null)
                    {
                        caiGouDan.IsRuKu = true;
                        caiGouDan.Update().OnlySaveFields(e => e.IsRuKu).SaveToDB();
                    }
                    var caiGouDanShangPin = _ioc.Query<CaiGouDanShangPin>()            //选中的采购单实体对应的采购商品的实体集合
                        .Where(e => e.CaiGouDanID. ToString("") == CaiGouDanIDs[j])
                        .ToList();
                    for (var k = 0; k < caiGouDanShangPin.Count(); k++)                             //将取到的值循环插入到空的列表中
                    {
                       // var changGongShangPing = _ioc.Query<ChangGongShangPin>().Where(e => e.GongYingShangID.ToString("") == GongYingShangID[j]).FirstOrDefault();

                        var ruKu = new RuKu()
                        {
                            ShengChanRiQi = caiGouDanShangPin[k].ShengChanRiQi,
                            YouXiaoQiZhi = caiGouDanShangPin[k].YouXiaoQiZhi,
                            ShuLiang = caiGouDanShangPin[k].ShuLiang,
                            ShengChanPiHao = caiGouDanShangPin[k].ShengChanPiHao,
                            ShangPinMingChen = caiGouDanShangPin[k].ShangPinMingChen,
                            RuKuRiQi = DateTime.Now,                      //VS中获取当前时间
                            BaoZhiQi = Convert.ToInt32(caiGouDanShangPin[k].BaoZhiQi),
                            BaoZhiJiDanWei = caiGouDanShangPin[k].BaoZhiQiDanWei,
                            ShengChanChangJia= caiGouDanShangPin[k].ShengChanChangJia,
                            ChanDi= caiGouDanShangPin[k].ChanDi,
                            PinPai = caiGouDanShangPin[k].PinPai,
                            DanJia = caiGouDanShangPin[k].DanJia,
                            ChangGongShangPinID = caiGouDanShangPin[k].ShangPinID,
                            GongYingShangID = caiGouDanShangPin[k].GongYingShangID,
                            CaiGouDanShangPinID = caiGouDanShangPin[k].ID,    // 这句代码是将【采购单商品】实体对应的ID赋值给【入库】实体的ID
                            CaiGouDanID = caiGouDanShangPin[k].CaiGouDanID,
                            ShengYuShuLiang = Convert.ToDecimal(caiGouDanShangPin[k].ShuLiang),
                            //KuGuan =                                   //给入库实体中的库管赋值
                            //JianChaRen =   
                            //JianChaRenID =
                            //JianChaRenID =
                            //QiYeMingChen = caiGouDanShangPin[h].        //获取采购单商品所对应的企业名称
                        };
                        ruKu.Insert().SaveToDB();
                    }
                }
                return r;
            }
        }

 

转载于:https://www.cnblogs.com/jiaowoyaoshu/p/9895793.html