| | |
| | | int update = 0; |
| | | int insertOrUpdate = 0; |
| | | |
| | | if (mesSalesOrder.ErpID != null) |
| | | if (mesSalesOrder.ErpId != null) |
| | | { |
| | | update = db.Deleteable<SalesOrder>() |
| | | .Where(s => s.ErpID == mesSalesOrder.ErpID) |
| | | .Where(s => s.ErpId == mesSalesOrder.ErpId) |
| | | .ExecuteCommand(); |
| | | } |
| | | |
| | | if (mesSalesOrderDatas.Count > 0 && mesSalesOrder.ErpID != null) |
| | | if (mesSalesOrderDatas.Count > 0 && mesSalesOrder.ErpId != null) |
| | | { |
| | | insertOrUpdate = db.Deleteable<SalesOrderDetail>() |
| | | .Where(s => s.EHID == mesSalesOrder.ErpID) |
| | | .Where(s => s.EHid == mesSalesOrder.ErpId) |
| | | .ExecuteCommand(); |
| | | } |
| | | |
| | |
| | | { |
| | | //if (mesSalesOrder.Id != null) base.DeleteById(mesSalesOrder.Id); |
| | | |
| | | if (mesSalesOrder.ErpID != null) |
| | | if (mesSalesOrder.ErpId != null) |
| | | db.Deleteable<SalesOrder>() |
| | | .Where(s => s.ErpID == mesSalesOrder.ErpID).ExecuteCommand(); |
| | | .Where(s => s.ErpId == mesSalesOrder.ErpId).ExecuteCommand(); |
| | | |
| | | if (mesSalesOrderDatas.Count > 0) |
| | | db.Deleteable<SalesOrderDetail>() |
| | | .Where(s => s.EHID == mesSalesOrder.ErpID).ExecuteCommand(); |
| | | .Where(s => s.EHid == mesSalesOrder.ErpId).ExecuteCommand(); |
| | | |
| | | //var orUpdate = base.Insert(mesSalesOrder); |
| | | //var baOrUpdate = _SalesOrderDetailManager.InsertRange(mesSalesOrderDatas); |
| | |
| | | { |
| | | Id = Guid.NewGuid(), |
| | | BillNo = erpDto.FBillNo, |
| | | ErpID = Convert.ToDecimal(erpDto.ErpID), |
| | | ErpId = Convert.ToDecimal(erpDto.ErpID), |
| | | FDate = ParseDateTime(erpDto.FDate) ?? null, |
| | | BillTypeId = erpDto.FBillTypeID, // 单据类型 |
| | | DocumentStatus = erpDto.FDocumentStatus, // 单据状态 |
| | |
| | | : null, // 变更日期 |
| | | CancelStatus = erpDto.FCancelStatus, // 作废状态 |
| | | CancellerId = erpDto.FCancellerId, // 作废人 |
| | | VersionNo = Convert.ToDouble(erpDto.FVersionNo), // 版本号 |
| | | VersionNo = !string.IsNullOrEmpty(erpDto.FVersionNo) |
| | | ? Convert.ToInt32(erpDto.FVersionNo) |
| | | : 0, // 版本号 |
| | | ChangerId = erpDto.FChangerId, // 变更人 |
| | | SynchronousDate = DateTime.Now |
| | | //EntryNote = erpDto.FEntryNote // 备注 |
| | |
| | | ? (DateTime?)null |
| | | : DateTime.ParseExact(erpDto.FCloseDate, "yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture); |
| | | |
| | | var single = base.GetSingle(it => it.ErpID == Convert.ToDecimal(erpDto.ErpID)); |
| | | var single = base.GetSingle(it => it.ErpId == Convert.ToDecimal(erpDto.ErpID)); |
| | | if (single != null) salesOrder.Id = single.Id; |
| | | |
| | | // CUST_ID => MES_CUSTOMER.id |
| | | if (!string.IsNullOrEmpty(salesOrder.CustId)) |
| | | { |
| | | var customer = Db.Queryable<MesCustomer>() |
| | | .Where(c => c.CustNo == salesOrder.CustId) |
| | | .Select(c => c.Id) |
| | | .First(); |
| | | if (customer != null) |
| | | { |
| | | salesOrder.CustId = customer.ToString(); |
| | | } |
| | | } |
| | | |
| | | // SALE_DEPT_ID => SYS_DEPARTMENT.id |
| | | if (!string.IsNullOrEmpty(salesOrder.SaleDeptId)) |
| | | { |
| | | var department = Db.Queryable<SysDepartment>() |
| | | .Where(d => d.Departmentcode == salesOrder.SaleDeptId) |
| | | .Select(d => d.Id) |
| | | .First(); |
| | | if (department != null) |
| | | { |
| | | salesOrder.SaleDeptId = department.ToString(); |
| | | } |
| | | } |
| | | |
| | | // SALE_ORG_ID => 1 (固定值) |
| | | salesOrder.SaleOrgId = "1"; |
| | | |
| | | return salesOrder; |
| | | } |
| | |
| | | var salesOrderSub = new SalesOrderDetail |
| | | { |
| | | Pid = salesOrder.Id, |
| | | ErpID = Convert.ToDecimal(erpDto.ErpID), |
| | | EHID = Convert.ToDecimal(erpDto.EHID), |
| | | ErpId = !string.IsNullOrEmpty(erpDto.ErpID) |
| | | ? Convert.ToInt32(erpDto.ErpID) |
| | | : 0, |
| | | EHid = !string.IsNullOrEmpty(erpDto.EHID) |
| | | ? Convert.ToInt32(erpDto.EHID) |
| | | : 0, |
| | | MaterialId = erpDto.FMaterialId, |
| | | MapId = erpDto.FMapId, |
| | | MapName = erpDto.FMapName, |
| | | MapSpec = erpDto.FMapSpec, |
| | | Seq = Convert.ToInt32(erpDto.Seq), |
| | | Seq = !string.IsNullOrEmpty(erpDto.Seq) |
| | | ? Convert.ToInt32(erpDto.Seq) |
| | | : 0, |
| | | UnitId = erpDto.FUnitID, |
| | | Qty = Convert.ToDecimal(erpDto.FQty), |
| | | Qty = !string.IsNullOrEmpty(erpDto.FQty) |
| | | ? Convert.ToDecimal(erpDto.FQty) |
| | | : 0, |
| | | PriceUnitId = erpDto.FPriceUnitId, |
| | | PriceUnitQty = Convert.ToDecimal(erpDto.FPriceUnitQty), |
| | | DeliveryDate = Convert.ToDateTime(erpDto.FDeliveryDate), |
| | | PriceUnitQty = !string.IsNullOrEmpty(erpDto.FPriceUnitQty) |
| | | ? Convert.ToDecimal(erpDto.FPriceUnitQty) |
| | | : 0, |
| | | DeliveryDate = !string.IsNullOrEmpty(erpDto.FDeliveryDate) |
| | | ? Convert.ToDateTime(erpDto.FDeliveryDate) |
| | | : DateTime.MinValue, |
| | | IsFree = erpDto.FIsFree, |
| | | SupplyOrgId = erpDto.FSupplyOrgId, |
| | | StockOrgId = erpDto.FStockOrgId, |
| | |
| | | EntryNote = erpDto.FEntryNote, |
| | | MtoNo = erpDto.FMtoNo, |
| | | Lot = erpDto.FLot, |
| | | DeliveryMaxQty = Convert.ToDecimal(erpDto.FDeliveryMaxQty), |
| | | DeliveryMinQty = Convert.ToDecimal(erpDto.FDeliveryMinQty), |
| | | DeliveryMaxQty = !string.IsNullOrEmpty(erpDto.FDeliveryMaxQty) |
| | | ? Convert.ToDecimal(erpDto.FDeliveryMaxQty) |
| | | : 0, |
| | | DeliveryMinQty = !string.IsNullOrEmpty(erpDto.FDeliveryMinQty) |
| | | ? Convert.ToDecimal(erpDto.FDeliveryMinQty) |
| | | : 0, |
| | | OutLmtUnitId = erpDto.FOutLmtUnitID, |
| | | MrpCloseStatus = erpDto.FMrpCloseStatus, |
| | | MrpTerminateStatus = erpDto.FMrpTerminateStatus, |
| | |
| | | TerminaterId = erpDto.FTerminatorId, |
| | | SrcType = erpDto.FSrcType, |
| | | SrcBillNo = erpDto.FSrcBillNo, |
| | | DeliQty = Convert.ToDecimal(erpDto.FDeliQty), |
| | | StockOutQty = Convert.ToDecimal(erpDto.FStockOutQty), |
| | | BaseRetNoticeQty = Convert.ToDecimal(erpDto.FBaseRetNoticeQty), |
| | | BaseReturnQty = Convert.ToDecimal(erpDto.FBaseReturnQty), |
| | | BaseRemainOutQty = Convert.ToDecimal(erpDto.FBaseRemainOutQty), |
| | | BASEARQTY = Convert.ToDecimal(erpDto.FBASEARQTY), |
| | | |
| | | DeliQty = !string.IsNullOrEmpty(erpDto.FDeliQty) |
| | | ? Convert.ToDecimal(erpDto.FDeliQty) |
| | | : 0, |
| | | StockOutQty = !string.IsNullOrEmpty(erpDto.FStockOutQty) |
| | | ? Convert.ToDecimal(erpDto.FStockOutQty) |
| | | : 0, |
| | | BaseRetNoticeQty = !string.IsNullOrEmpty(erpDto.FBaseRetNoticeQty) |
| | | ? Convert.ToDecimal(erpDto.FBaseRetNoticeQty) |
| | | : 0, |
| | | BaseReturnQty = !string.IsNullOrEmpty(erpDto.FBaseReturnQty) |
| | | ? Convert.ToDecimal(erpDto.FBaseReturnQty) |
| | | : 0, |
| | | BaseRemainOutQty = !string.IsNullOrEmpty(erpDto.FBaseRemainOutQty) |
| | | ? Convert.ToDecimal(erpDto.FBaseRemainOutQty) |
| | | : 0, |
| | | Basearqty = !string.IsNullOrEmpty(erpDto.FBASEARQTY) |
| | | ? Convert.ToDecimal(erpDto.FBASEARQTY) |
| | | : 0, |
| | | }; |
| | | |
| | | if (!string.IsNullOrEmpty(salesOrderSub.TerminaterId)) |
| | |
| | | : DateTime.ParseExact(erpDto.FTerminateDate, "yyyy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture); |
| | | |
| | | var single = _SalesOrderDetailManager.GetSingle(it => |
| | | it.ErpID == Convert.ToDecimal(salesOrderSub.ErpID)); |
| | | it.ErpId == Convert.ToDecimal(salesOrderSub.ErpId)); |
| | | if (single != null) salesOrderSub.Id = single.Id; |
| | | |
| | | // material_id => MES_ITEMS.id |
| | | if (!string.IsNullOrEmpty(salesOrderSub.MaterialId)) |
| | | { |
| | | var item = Db.Queryable<MesItems>() |
| | | .Where(i => i.ItemNo == salesOrderSub.MaterialId) |
| | | .Select(i => i.Id) |
| | | .First(); |
| | | if (item != null) |
| | | { |
| | | salesOrderSub.MaterialId = item.ToString(); |
| | | } |
| | | } |
| | | |
| | | // UNIT_ID => MES_UNIT.id |
| | | if (!string.IsNullOrEmpty(salesOrderSub.UnitId)) |
| | | { |
| | | var unit = Db.Queryable<MesUnit>() |
| | | .Where(u => u.Fnumber == salesOrderSub.UnitId) |
| | | .Select(u => u.Id) |
| | | .First(); |
| | | if (unit != null) |
| | | { |
| | | salesOrderSub.UnitId = unit.ToString(); |
| | | } |
| | | } |
| | | |
| | | // PRICE_UNIT_ID => MES_UNIT.id |
| | | if (!string.IsNullOrEmpty(salesOrderSub.PriceUnitId)) |
| | | { |
| | | var priceUnit = Db.Queryable<MesUnit>() |
| | | .Where(u => u.Fnumber == salesOrderSub.PriceUnitId) |
| | | .Select(u => u.Id) |
| | | .First(); |
| | | if (priceUnit != null) |
| | | { |
| | | salesOrderSub.PriceUnitId = priceUnit.ToString(); |
| | | } |
| | | } |
| | | |
| | | // OUT_LMT_UNIT_ID => MES_UNIT.id |
| | | if (!string.IsNullOrEmpty(salesOrderSub.OutLmtUnitId)) |
| | | { |
| | | var outLmtUnit = Db.Queryable<MesUnit>() |
| | | .Where(u => u.Fnumber == salesOrderSub.OutLmtUnitId) |
| | | .Select(u => u.Id) |
| | | .First(); |
| | | if (outLmtUnit != null) |
| | | { |
| | | salesOrderSub.OutLmtUnitId = outLmtUnit.ToString(); |
| | | } |
| | | } |
| | | |
| | | // SUPPLY_ORG_ID => 1 (固定值) |
| | | salesOrderSub.SupplyOrgId = "1"; |
| | | |
| | | // STOCK_ORG_ID => 1 (固定值) |
| | | salesOrderSub.StockOrgId = "1"; |
| | | |
| | | // SETTLE_ORG_IDS => 1 (固定值) |
| | | salesOrderSub.SettleOrgIds = "1"; |
| | | |
| | | salesOrderSubList.Add(salesOrderSub); |
| | | } |
| | | |