예제 #1
0
        private void cmdBuildFilter_Click(System.Object eventSender, System.EventArgs eventArgs)
        {
            System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
            System.Windows.Forms.Application.DoEvents();
            modRecordSet.cnnDB.Execute("DELETE FROM systemStockItemPricing;");
            modRecordSet.cnnDB.Execute("INSERT INTO systemStockItemPricing ( systemStockItemPricing ) SELECT StockItem.StockItemID From StockItem " + gFilterSQL);
            modRecordSet.cnnDB.Execute("UPDATE POSCatalogueChannelLnk INNER JOIN CatalogueChannelLnk ON (POSCatalogueChannelLnk.POSCatalogueChannelLnk_Quantity = CatalogueChannelLnk.CatalogueChannelLnk_Quantity) AND (POSCatalogueChannelLnk.POSCatalogueChannelLnk_ChannelID = CatalogueChannelLnk.CatalogueChannelLnk_ChannelID) AND (POSCatalogueChannelLnk.POSCatalogueChannelLnk_StockItemID = CatalogueChannelLnk.CatalogueChannelLnk_StockItemID) SET CatalogueChannelLnk.CatalogueChannelLnk_Price = [POSCatalogueChannelLnk]![POSCatalogueChannelLnk_Price] WHERE (((CatalogueChannelLnk.CatalogueChannelLnk_Price)<>[POSCatalogueChannelLnk]![POSCatalogueChannelLnk_Price]));");
            //UPGRADE_WARNING: Screen property Screen.MousePointer has a new behavior. Click for more: 'ms-help://MS.VSCC.v90/dv_commoner/local/redirect.htm?keyword="6BA9B8D2-2A32-4B6E-8D36-44949974A5B4"'
            System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
            //frmUpdateCatalogue.show 1, Me
            frmUpdatePOS frmPOS = null;

            if (gParameters & gUpdateWarnin == 512)
            {
                frmPOS.Show();
            }
            else
            {
                if (My.MyProject.Forms.frmUpdateWarning.loadItem())
                {
                    frmPOS.Show();
                }
            }
            this.Close();
            //If frmUpdateWarning.loadItem() Then frmUpdatePOS.show 1, Me
        }
예제 #2
0
        private void cmdBuildChanges_Click(System.Object eventSender, System.EventArgs eventArgs)
        {
            System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.WaitCursor;
            System.Windows.Forms.Application.DoEvents();
            modRecordSet.cnnDB.Execute("DELETE FROM systemStockItemPricing;");
            modRecordSet.cnnDB.Execute("INSERT INTO systemStockItemPricing ( systemStockItemPricing ) SELECT tempStockItem.tempStockItemID FROM tempStockItem;");
            modRecordSet.cnnDB.Execute("UPDATE POSCatalogueChannelLnk INNER JOIN CatalogueChannelLnk ON (POSCatalogueChannelLnk.POSCatalogueChannelLnk_Quantity = CatalogueChannelLnk.CatalogueChannelLnk_Quantity) AND (POSCatalogueChannelLnk.POSCatalogueChannelLnk_ChannelID = CatalogueChannelLnk.CatalogueChannelLnk_ChannelID) AND (POSCatalogueChannelLnk.POSCatalogueChannelLnk_StockItemID = CatalogueChannelLnk.CatalogueChannelLnk_StockItemID) SET CatalogueChannelLnk.CatalogueChannelLnk_Price = [POSCatalogueChannelLnk]![POSCatalogueChannelLnk_Price] WHERE (((CatalogueChannelLnk.CatalogueChannelLnk_Price)<>[POSCatalogueChannelLnk]![POSCatalogueChannelLnk_Price]));");
            System.Windows.Forms.Cursor.Current = System.Windows.Forms.Cursors.Default;
            frmUpdateCatalogue frmUpdate = null;
            frmUpdatePOS       frmPOS    = null;

            frmUpdate.Show();

            if (gParameters & gUpdateWarnin == 512)
            {
                frmPOS.Show();
            }
            else
            {
                if (My.MyProject.Forms.frmUpdateWarning.loadItem())
                {
                    frmPOS.Show();
                }
            }
            this.Close();
            //If frmUpdateWarning.loadItem() Then frmUpdatePOS.show 1, Me
        }