public static void tableRefresh(In2SqlSvcTool.CurrentTableRecords vCTR, int vIsUndoList = 1) { var vActivCell = SqlEngine.currExcelApp.ActiveCell; if (vCTR.TypeConnection.Contains("ODBC")) { vActivCell.ListObject.QueryTable.CommandText = vCTR.Sql; objRefreshHistory(vActivCell.ListObject, vIsUndoList); if (vIsUndoList == 1) { In2SqlSvcUndoManagment.addToUndoList(vActivCell.ListObject.Name, vCTR.Sql); } } if (vCTR.TypeConnection.Contains("CLOUD")) { In2SqlVBAEngineCloud.createExTable( vCTR.CurrCloudName , vCTR.TableName , vCTR.Sql , 1 , vCTR.CurrCloudExTName); In2SqlSvcTool.addSqlLog(vCTR.Sql); if (vIsUndoList == 1) { In2SqlSvcUndoManagment.addToUndoList(vCTR.CurrCloudExTName, vCTR.Sql); } } }
public static void Redo() { try { var vActivCell = SqlEngine.currExcelApp.ActiveCell; if ((vActivCell.ListObject == null) == false) { In2SqlSvcTool.CurrentTableRecords vCTR = In2SqlSvcTool.getCurrentSql(); string vSql = In2SqlSvcUndoManagment.getLastSqlActionRedo(vActivCell.ListObject.Name); if ((vSql == null) == false) { vCTR.Sql = vSql; tableRefresh(vCTR, 0); } GetSelectedTab(); return; } MessageBox.Show(" Please, select cell from the table", " Refresh error"); } catch { MessageBox.Show(" Please, select cell from the table", " Refresh error"); } GetSelectedTab(); }
public static void objRefreshHistory(Microsoft.Office.Interop.Excel.ListObject vCurrObject, int vIsUndoList = 1) { // SqlEngine.currExcelApp.EnableEvents = false; vCurrObject.QueryTable.CommandText = setSqlLimit(getOdbcNameFromObject(vCurrObject.QueryTable.Connection), vCurrObject.QueryTable.CommandText); In2SqlSvcTool.addSqlLog(vCurrObject.QueryTable.CommandText); objRefresh(vCurrObject); if (vIsUndoList == 1) { In2SqlSvcUndoManagment.addToUndoList(vCurrObject.Name, vCurrObject.QueryTable.CommandText); } }