Esempio n. 1
0
 public byte[] GetSyncProductLocation(int productLocationID, int productID, int branchID, DateTime modifiedDate, int action)
 {
     return(GetBytes(SynchronizationManager.GetSyncProductLocation(productLocationID, productID, branchID, modifiedDate, (DatabaseAction)action)));
 }
Esempio n. 2
0
        protected override bool SaveData()
        {
            foreach (CheckedListBoxItem item in chklstTable.Items)
            {
                if (item.CheckState != CheckState.Checked || !item.Enabled)
                {
                    continue;
                }
                var objectName   = (ObjectNames)ConvertHelper.ToInt32(item.Value);
                var modifiedDate = SynchronizationManager.GetDate(objectName, false);
                var table        = new DataTable();
                switch (objectName)
                {
                case ObjectNames.SynchronizeDate:
                    Win32Native.SetLocalTime(SynchronizationManager.GetDate(ObjectNames.None, true));
                    InitSynchronizedCheckedListBoxItem(item);
                    break;

                //case ObjectNames.SalesOrderHeader:
                //    DateTime serverDateTime = SynchronizationManager.GetDate(ObjectNames.None, true);
                //    DS_Sales.SP_GetSalesOrderHeaderDataTable header = Apothex.DataManagment.Sales.SalesManager.GetSalesOrderHeader(serverDateTime.Date, false);
                //    DS_Sales.SP_GetSalesOrderDetailDataTable detail = Apothex.DataManagment.Sales.SalesManager.GetSalesOrderDetail(serverDateTime.Date, false);
                //    DS_Card.T_CardHandleDataTable card = CardManager.GetCardHandle(serverDateTime.Date, false);
                //    using (DataSet ds = new DataSet("root"))
                //    {
                //        DataSetHelper.SetColumnMappingType(header);
                //        DataSetHelper.SetColumnMappingType(detail);
                //        DataSetHelper.SetColumnMappingType(card);

                //        DataSetHelper.RemoveColumns(header, 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
                //                                );

                //        DataSetHelper.RemoveColumns(detail, 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(card);
                //        Synchronize(objectName, ds, true);
                //        ds.Tables.Remove(detail);
                //        ds.Tables.Remove(card);

                //        DataSetHelper.RemoveColumns(header, true, header.SalesOrderIDColumn);
                //        Synchronize(objectName, ds, false);
                //        InitSynchronizedCheckedListBoxItem(item);
                //    }
                //    break;
                case ObjectNames.SalesOrderHeader:
                    SynchronizationManager.SynchronizeSalesOrder(0);
                    InitSynchronizedCheckedListBoxItem(item);
                    break;

                case ObjectNames.ProductLocation:
                    table = SynchronizationManager.GetSyncProductLocation(0, 0, GlobalVariable.BranchID, modifiedDate, DatabaseAction.Synchronize);
                    Synchronize(objectName, table, false);
                    InitSynchronizedCheckedListBoxItem(item);
                    break;

                case ObjectNames.Currency:
                    table = SynchronizationManager.GetSyncCurrency(string.Empty, modifiedDate, DatabaseAction.Synchronize);
                    Synchronize(objectName, table, false);
                    InitSynchronizedCheckedListBoxItem(item);
                    break;

                case ObjectNames.CardUnitRate:
                    table = SynchronizationManager.GetSyncCardUnitRate();
                    Synchronize(objectName, table, false);
                    InitSynchronizedCheckedListBoxItem(item);
                    break;

                case ObjectNames.CardDiscountSchema:
                    table = SynchronizationManager.GetSyncCardDiscountSchema();
                    Synchronize(objectName, table, false);
                    InitSynchronizedCheckedListBoxItem(item);
                    break;

                case ObjectNames.MyCompany:
                    var mycompany = SynchronizationManager.GetSyncMyCompany(0, modifiedDate, DatabaseAction.Synchronize);
                    if (mycompany.Count > 0)
                    {
                        var branch = BranchManager.Get(GlobalVariable.BranchID);
                        if (branch.Count > 0 && !branch[0].IsCompanyIDNull())
                        {
                            var company = PersonManager.GetCompany(branch[0].CompanyID);
                            if (company.Count > 0)
                            {
                                mycompany[0].MyCompanyName = company[0].Name;
                                mycompany[0].TaxCode       = company[0].TaxCode;
                                mycompany[0].DirectorName  = string.Empty;
                                mycompany[0].CountryCode   = company[0].CountryCode;
                                mycompany[0].City          = string.Empty;
                                mycompany[0].Address       = company[0].Address;
                                mycompany[0].Phone         = company[0].Phone;
                                mycompany[0].Fax           = company[0].Fax;
                                if (!company[0].IsBankIDNull())
                                {
                                    mycompany[0].BankID = company[0].BankID;
                                }
                                else
                                {
                                    mycompany[0].SetBankIDNull();
                                }
                                mycompany[0].BankAccountNumber = company[0].BankAccountNumber;
                            }
                        }
                    }
                    table = mycompany;
                    Synchronize(objectName, table, false);
                    InitSynchronizedCheckedListBoxItem(item);
                    break;

                case ObjectNames.Branch:
                    table = SynchronizationManager.GetSyncBranch(0, modifiedDate, DatabaseAction.Synchronize);
                    Synchronize(objectName, table, false);
                    InitSynchronizedCheckedListBoxItem(item);
                    break;

                case ObjectNames.User:
                    table = SynchronizationManager.GetSyncUser(0, GlobalVariable.BranchID, modifiedDate, DatabaseAction.Synchronize);
                    Synchronize(objectName, table, false);
                    InitSynchronizedCheckedListBoxItem(item);
                    break;

                case ObjectNames.UserPermission:
                    table = SynchronizationManager.GetSyncUserPermission(0, GlobalVariable.BranchID, modifiedDate, DatabaseAction.Synchronize);
                    Synchronize(objectName, table, false);
                    InitSynchronizedCheckedListBoxItem(item);
                    break;

                case ObjectNames.PaymentMethod:
                    table = SynchronizationManager.GetSyncPaymentMethod(0, modifiedDate, DatabaseAction.Synchronize);
                    Synchronize(objectName, table, false);
                    InitSynchronizedCheckedListBoxItem(item);
                    break;

                case ObjectNames.OperationType:
                    table = SynchronizationManager.GetOperationType();
                    Synchronize(objectName, table, false);
                    InitSynchronizedCheckedListBoxItem(item);
                    break;
                }
            }

            return(true);
        }