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