| | |
| | | .IgnoreColumns(true).ExecuteCommand() > 0; |
| | | |
| | | //批量插入忽略空字段 |
| | | var baOrUpdate = db.Insertable(mesWomcabs).PageSize(1) |
| | | var baOrUpdate = db.Insertable(mesWomcabs).PageSize(10) |
| | | .IgnoreColumnsNull() |
| | | .ExecuteCommand() > 0; |
| | | |
| | |
| | | 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) |
| | |
| | | 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 |
| | |
| | | Lot = dto.FLot, //批号 |
| | | DepotCode = dto.FStockID, //仓库 |
| | | IssueType = dto.FIssueType, //发料方式 |
| | | Cab008 = dto.GY, //工艺 |
| | | Cab009 = dto.FUnitID, //单位 |
| | | SupplyType = dto.FSupplyType, //供应类型 |
| | | Cab012 = Convert.ToDecimal(dto.FStdQty), // 标准用量 |
| | |
| | | |
| | | 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); |
| | | } |
| | | |