public static DS_SyncSalesOrderDetail.T_SalesOrderDetail_InvalidDataTable GetInvalidSalesOrderDetail() { var serverDateTime = SynchronizationManager.GetDate(ObjectNames.None, true); using (var ds = new DataSet("root")) { var header = SalesManager.GetSalesOrderHeader(serverDateTime.Date, false); var detail = SalesManager.GetSalesOrderDetail(serverDateTime.Date, false); header.RemoveColumns(true, header.SalesOrderIDColumn, header.BranchIDColumn, header.OrderDateColumn, header.OverheadNumberColumn, header.CustomerIDColumn, header.SubTotalColumn, header.TaxAmtColumn, header.FreightColumn, header.CurrencyCodeColumn, header.CurrencyRateIDColumn, header.PaymentMethodIDColumn, header.RevisionNumberColumn, header.StatusColumn, header.ModifiedUserIDColumn, header.ModifiedDateColumn, header.ApproverUserIDColumn, header.rowguidColumn ); detail.RemoveColumns(true, detail.SalesOrderDetailIDColumn, detail.SalesOrderIDColumn, detail.ProductLocationIDColumn, detail.SaleQtyColumn, detail.UnitPriceColumn, detail.UnitPriceDiscountColumn, detail.OrdinalNumberColumn, detail.ModifiedUserIDColumn, detail.ModifiedDateColumn, detail.ActionColumn ); ds.Tables.Add(header); ds.Tables.Add(detail); ds.SetColumnMappingType(); return(GetInvalidSalesOrderDetail(ds.GetBytesData())); } }
public static void SynchronizeSalesOrder(int id, DataTable cardhandle, DataTable operation) { var serverDateTime = SynchronizationManager.GetDate(ObjectNames.None, true); var header = id == 0 ? SalesManager.GetSalesOrderHeader(serverDateTime.Date, false) : SalesManager.GetSalesOrderHeader(id, false); var detail = id == 0 ? SalesManager.GetSalesOrderDetail(serverDateTime.Date, false) : SalesManager.GetSalesOrderDetail(id, false); if (cardhandle == null) { cardhandle = id == 0 ? CardManager.GetCardHandle(serverDateTime.Date, false) : CardManager.GetCardHandle(id, false); } if (operation == null) { operation = new DS_Operation.T_OperationDataTable(); } using (var ds = new DataSet("root")) { header.RemoveColumns(true, header.SalesOrderIDColumn, header.BranchIDColumn, header.OrderDateColumn, header.OverheadNumberColumn, header.CustomerIDColumn, header.SubTotalColumn, header.TaxAmtColumn, header.FreightColumn, header.CurrencyCodeColumn, header.CurrencyRateIDColumn, header.PaymentMethodIDColumn, header.RevisionNumberColumn, header.StatusColumn, header.ModifiedUserIDColumn, header.ModifiedDateColumn, header.ApproverUserIDColumn, header.rowguidColumn ); detail.RemoveColumns(true, detail.SalesOrderDetailIDColumn, detail.SalesOrderIDColumn, detail.ProductLocationIDColumn, detail.SaleQtyColumn, detail.UnitPriceColumn, detail.UnitPriceDiscountColumn, detail.OrdinalNumberColumn, detail.ModifiedUserIDColumn, detail.ModifiedDateColumn, detail.ActionColumn ); ds.Tables.Add(header); ds.Tables.Add(detail); ds.Tables.Add(cardhandle); ds.Tables.Add(operation); ds.SetColumnMappingType(); Synchronize(ObjectNames.SalesOrderHeader, BaseGlobalVariable.UserID, BaseGlobalVariable.ServerDateTime, DatabaseAction.Synchronize, true, ds.GetBytesData()); ds.Tables.Remove(detail); ds.Tables.Remove(cardhandle); ds.Tables.Remove(operation); header.RemoveColumns(true, header.SalesOrderIDColumn); Synchronize(ObjectNames.SalesOrderHeader, BaseGlobalVariable.UserID, BaseGlobalVariable.ServerDateTime, DatabaseAction.Synchronize, false, ds.GetBytesData()); } }