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
}
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
}