来料检增加字段

xwt

3 天以前 8ba0722979e389a8a2f5835022a7d305ab215c08

 StandardInterface/MES.Service/service/WomcaaManager.cs

@@ -60,7 +60,7 @@
            .IgnoreColumns(true).ExecuteCommand() > 0;

        //批量插入忽略空字段
        var baOrUpdate = db.Insertable(mesWomcabs).PageSize(1)
        var baOrUpdate = db.Insertable(mesWomcabs).PageSize(10)
            .IgnoreColumnsNull()
            .ExecuteCommand() > 0;

@@ -72,13 +72,27 @@
        List<Womcab> mesWomcabs)
    {
        var decimals = mesWomcabs.Select(s => s.Id).ToArray();
        var update = base.DeleteById(mesWomcaa.Id);
        var insertOrUpdate = db
            .Deleteable<Womcab>().In(decimals)
            .ExecuteCommand() > 0;

        if (update && insertOrUpdate) return true;
        var update = true;
        if (mesWomcaa != null)
        {
            if (mesWomcaa.Id != null)
            {
                update = base.DeleteById(mesWomcaa.Id);
            }
        }
        var insertOrUpdate = true;
        if (decimals != null || decimals.Length > 0)
        {
            insertOrUpdate = db.Deleteable<Womcab>().In(decimals).ExecuteCommand() > 0;
        }

        if (update && insertOrUpdate)
        {
            return true;
        }
        throw new NotImplementedException("更新失败");
       
    }

    private Womcaa MapErpCAAtoWomcaa(ErpCAA dto)
@@ -200,8 +214,17 @@
            Typea = dto.TypeA, ///     单据状态
            RkOrg = dto.RK_ORG,           //入库组织
            Rcn=dto.RCN,                 //日产能


            Cglineid=dto.CG_LINE_ID, //采购订单行id
            Kh=dto.KH,
            Khjc=dto.KH_JCZL,
            Scph=dto.SC_PH,
            Moldno=dto.MOLd_no,
            Oldmoldno=dto.Old_mold_no,
            Jt=dto.JT,
            Xscn=dto.XS_CN,
            Sjxs=dto.SJ_xs,
            Nextgx=dto.NEXT_Gx,
            Rks=dto.RKS,
            //沃尔新增
            // WR_F_SCDD_SCTZD = dto.F_SCDD_SCTZD
            //WR_F_SCDD_XH = dto.F_SCDD_XH
@@ -237,6 +260,7 @@
                Lot = dto.FLot,                               //批号
                DepotCode = dto.FStockID,                     //仓库
                IssueType = dto.FIssueType,                   //发料方式
                Cab008 = dto.GY,            //工艺
                Cab009 = dto.FUnitID,                          //单位
                SupplyType = dto.FSupplyType,                  //供应类型
                Cab012 = Convert.ToDecimal(dto.FStdQty),        // 标准用量
@@ -264,8 +288,13 @@

            var entity = Db.Queryable<Womcab>()
                .Where(s => s.Erpid == womcab.Erpid).Single();
            if (entity != null) womcab.Id = entity.Id;

            if (entity != null)
            {
                // 删除已有的 Erpid 相关的 Womcab 数据
              //  Db.Deleteable<Womcab>().Where(s => s.Erpid == womcab.Erpid).ExecuteCommand();
                womcab.Id = entity.Id;
            }
     
            womcabList.Add(womcab);
        }