| | |
| | | var baOrUpdate = db.Insertable(mesWomcabs).PageSize(1) |
| | | .IgnoreColumnsNull() |
| | | .ExecuteCommand() > 0; |
| | | |
| | | |
| | | if (orUpdate && baOrUpdate) return true; |
| | | throw new NotImplementedException("插入或更新失败"); |
| | | } |
| | |
| | | Caa006 = dto.FMaterialId, /// 产品编码 |
| | | Caa009 = dto.FUnitId, /// 单位 |
| | | Caa012 = !string.IsNullOrEmpty(dto.FQty) |
| | | ? Convert.ToInt32(dto.FQty) |
| | | ? Convert.ToDecimal(dto.FQty) |
| | | : null, /// 数量 |
| | | WorkGroupId = dto.FWorkGroupId, /// 计划组 |
| | | PlanId = dto.FPlannerID, /// 计划员 |
| | |
| | | //Caa015 = dto.F_UNW_Text_xsddh, /// 销售订单号 |
| | | ErpSczz = Convert.ToInt32(dto.FPrdOrgId), /// 生产组织ID |
| | | ErpWtzz = Convert.ToInt32(dto.FEnTrustOrgId), /// 委托组织ID |
| | | Btbz = dto.Btbz, /// 委托组织ID |
| | | //Caa015Head = dto.F_XIFG_Integer_tzk, /// 销售订单行号 |
| | | //MainProductNo = dto.F_XIFG_Base_w5c, /// 主产品编码 |
| | | // MainProductQty = |
| | |
| | | { |
| | | var womcab = new Womcab |
| | | { |
| | | Erpid = Convert.ToInt32(dto.FENTRYID), /// ERPID |
| | | Erpid = Convert.ToInt32(dto.Id), /// ERPID |
| | | Cab001 = dto.FBillNo, /// 工单单号 |
| | | Cab002 = dto.FSeq, /// 序号 |
| | | Cab002 = Convert.ToInt32(dto.FSeq), /// 序号 |
| | | Cab003 = dto.FMaterialID, /// 材料编码 |
| | | Cab006 = !string.IsNullOrEmpty(dto.FNeedQty) |
| | | ? Convert.ToInt32(dto.FNeedQty) |
| | | ? Convert.ToDecimal(dto.FNeedQty) |
| | | : null, /// 需领用量 |
| | | Cab007 = !string.IsNullOrEmpty(dto.FPickedQty) |
| | | ? Convert.ToInt32(dto.FPickedQty) |
| | |
| | | Cab009 = dto.FUnitID, /// 单位 |
| | | SupplyType = dto.FSupplyType, /// 供应类型(C采购 Z自制 W委外) |
| | | Cab012 = !string.IsNullOrEmpty(dto.FStdQty) |
| | | ? Convert.ToInt32(dto.FStdQty) |
| | | ? Convert.ToDecimal(dto.FStdQty) |
| | | : null, /// 组成用量 |
| | | Cab014 = dto.FIsKeyItem, /// 是否替料 |
| | | Numerator = dto.FNumerator, /// 分子 |
| | |
| | | Eid = Convert.ToInt32(dto.Id), /// ERP ID |
| | | |
| | | Scrapqty = dto.FFixScrapQty, /// 固定损耗 |
| | | Scraprate = dto.FScrapRate /// 变动损耗率 |
| | | Scraprate = dto.FScrapRate, /// 变动损耗率 |
| | | Freplacegroup = Convert.ToInt32(dto.FReplaceGroup), |
| | | UseRate = Convert.ToDecimal(dto.FUseRate), |
| | | MaterialType = dto.FMaterialType, |
| | | MustQty = Convert.ToDecimal(dto.FMustQty) |
| | | // Fsaleorderno = dto.FSALEORDERNO, /// 销售订单 |
| | | // |
| | | // CustomerItemNumber = dto.F_XIFG_Text_re5, /// 客户货号 |
| | |
| | | }; |
| | | |
| | | var entity = Db.Queryable<Womcab>() |
| | | .Where(s => s.Erpid == womcab.Erpid).Single(); |
| | | .Where(s => s.Eid == womcab.Eid).Single(); |
| | | if (entity != null) womcab.Guid = entity.Guid; |
| | | |
| | | womcabList.Add(womcab); |