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

//将多个采购单对应的所有的商品全部插入到入库实体中  其中一个采购单对应多个采购商品
// 例如现在有三个采购单,第一个采购单中的商品有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; } }

 

posted on 2018-11-02 13:40  叫我谣叔  阅读(341)  评论(0编辑  收藏  举报