| | |
| | | // ? 1 |
| | | // : 0; |
| | | case "3": |
| | | return UpdateData(db, mesSalesOrder, mesSalesOrderDatas) ? 1 : 0; |
| | | return SaveOrUpdateData(db, mesSalesOrder, mesSalesOrderDatas, erpSalesOrderDto.Type) |
| | | ? 1 |
| | | : 0; ;//UpdateData(db, mesSalesOrder, mesSalesOrderDatas) ? 1 : 0;//反审核不删除,做update。 |
| | | case "2": |
| | | case "4": |
| | | case "5": |
| | | return SaveOrUpdateData(db, mesSalesOrder, mesSalesOrderDatas, erpSalesOrderDto.Type) |
| | | ? 1 |
| | | : 0; |
| | |
| | | { |
| | | //if (mesSalesOrder.Id != null) base.DeleteById(mesSalesOrder.Id); |
| | | |
| | | if (type == "3" || (mesSalesOrder.DocumentStatus != null && mesSalesOrder.DocumentStatus != "C")) |
| | | { |
| | | mesSalesOrder.BillNo = mesSalesOrder.BillNo + "F" + mesSalesOrder.ErpID.ToString(); |
| | | } |
| | | |
| | | if (mesSalesOrder.ErpID != null) |
| | | db.Deleteable<SalesOrder>() |
| | | .Where(s => s.ErpID == mesSalesOrder.ErpID).ExecuteCommand(); |
| | |
| | | var baOrUpdate = db.Insertable(mesSalesOrderDatas).PageSize(1) |
| | | .IgnoreColumnsNull() |
| | | .ExecuteCommand() > 0; |
| | | if (orUpdate && baOrUpdate) return true; |
| | | if (orUpdate && baOrUpdate) |
| | | { |
| | | db.Ado.ExecuteCommand("exec [dbo].[prc_unit_check] @billno, @ModuleType", |
| | | new { billno = mesSalesOrder.BillNo, ModuleType = "销售订单" }); |
| | | |
| | | return true; |
| | | } |
| | | |
| | | throw new NotImplementedException("插入或更新失败"); |
| | | } |
| | |
| | | ///ChargeId = erpDto.FChargeId, // 付款方 |
| | | ///LinkPhone = erpDto.FLinkPhone, // 联系电话 |
| | | CreatorId = erpDto.FCreatorId, // 创建人 |
| | | CreateDate = ParseDateTime(erpDto.FCreateDate) ?? null, // 创建日期 |
| | | //CreateDate = ParseDateTime(erpDto.FCreateDate) ?? null, // 创建日期 |
| | | CreateDate = DateTime.TryParse(erpDto.FCreateDate, out var conveyDate) |
| | | ? (conveyDate <= new DateTime(1900, 1, 1) ? null : conveyDate) |
| | | : null, // 创建日期 |
| | | ModifierId = erpDto.FModifierId, // 最后修改人 |
| | | ModifyDate = ParseDateTime(erpDto.FModifyDate) ?? null, // 最后修改日期 |
| | | ApproveDate = ParseDateTime(erpDto.FApproveDate) ?? null, // 审核日期 |
| | | CloserId = erpDto.FCloserId, // 关闭人 |
| | | //CloseDate = ParseDateTime(erpDto.FCloseDate) ?? null, // 关闭日期 |
| | | ChangeDate = ParseDateTime(erpDto.FChangeDate) ?? null, // 变更日期 |
| | | //ChangeDate = ParseDateTime(erpDto.FChangeDate) ?? null, // 变更日期 |
| | | ChangeDate = DateTime.TryParse(erpDto.FChangeDate, out var ChangeDate) |
| | | ? (ChangeDate <= new DateTime(1900, 1, 1) ? null : ChangeDate) |
| | | : null, // 变更日期 |
| | | CancelStatus = erpDto.FCancelStatus, // 作废状态 |
| | | CancellerId = erpDto.FCancellerId, // 作废人 |
| | | VersionNo = Convert.ToDouble(erpDto.FVersionNo), // 版本号 |
| | | ChangerId = erpDto.FChangerId, // 变更人 |
| | | SynchronousDate = DateTime.Now |
| | | //EntryNote = erpDto.FEntryNote // 备注 |
| | | //ParseDateTime() ?? null |
| | | //long.Parse() |