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


    //将多个采购单对应的所有的商品全部插入到入库实体中  其中一个采购单对应多个采购商品
    // 例如现在有三个采购单,第一个采购单中的商品有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; } }
  • 相关阅读:
    Angular笔记
    Angular数据双向绑定机制
    块级元素垂直居中
    Linux文件系统硬/软连接
    Javascript 操作select控件大全(新增、修改、删除、选中、清空、判断存在等)
    Js获取当前日期时间及其它操作
    escape()、encodeURI()、encodeURIComponent()区别详解
    for (var i in obj/array){}
    setInterval中传递参数
    PHOTOSHOP常用快捷键大全
  • 原文地址:https://www.cnblogs.com/jiaowoyaoshu/p/9895793.html
Copyright © 2020-2023  润新知