public void Button_replace_Click(Object sender, System.EventArgs e)
{
int wid2;
string str1;
try {
classE1_1.Open();
// add code del current whatif results, //zstblwhatifaudit, clear glngwid, set recalc / save indicators
wid2 = classE1_1.glngwid;
// replace results
classE1_1.runsqlado("DELETE tblRsEquip.WID, tblRsEquip.* FROM tblRsEquip WHERE (((tblRsEquip.WID)=0));");
classE1_1.runsqlado("DELETE tblRsProd.WID, tblRsProd.* FROM tblRsProd WHERE (((tblRsProd.WID)=0));");
classE1_1.runsqlado("DELETE tblRsSummary.WID, tblRsSummary.* FROM tblRsSummary WHERE (((tblRsSummary.WID)=0));");
classE1_1.runsqlado("DELETE tblRsOper.WID, tblRsOper.* FROM tblRsOper WHERE (((tblRsOper.WID)=0));");
classE1_1.runsqlado("DELETE tblRsLabor.WID, tblRsLabor.* FROM tblRsLabor WHERE (((tblRsLabor.WID)=0));");
classE1_1.runsqlado("UPDATE tblRsEquip SET tblRsEquip.WID = 0, tblRsEquip.Whatif = 'Base Case' WHERE (((tblRsEquip.WID)=" + wid2 + ")); ");
classE1_1.runsqlado("UPDATE tblRsLabor SET tblRsLabor.WID = 0, tblRsLabor.Whatif = 'Base Case' WHERE (((tblRsLabor.WID)=" + wid2 + ")); ");
classE1_1.runsqlado("UPDATE tblRsOper SET tblRsOper.WID = 0, tblRsOper.Whatif = 'Base Case' WHERE (((tblRsOper.WID)=" + wid2 + ")); ");
classE1_1.runsqlado("UPDATE tblRsSummary SET tblRsSummary.WID = 0, tblRsSummary.Whatif = 'Base Case' WHERE (((tblRsSummary.WID)=" + wid2 + ")); ");
classE1_1.runsqlado("UPDATE tblRsProd SET tblRsProd.WID = 0, tblRsProd.Whatif = 'Base Case' WHERE (((tblRsProd.WID)=" + wid2 + ")); ");
classE1_1.DeleteWhatIfAudit(wid2);
str1 = "DELETE [ZstblwhatifAudit].* FROM [ZstblwhatifAudit];";
classE1_1.runsqlado(str1);
classE1_1.glngwid = 0;
classE1_1.saveWid();
classE1_1.saveRecalcNeeded(0, -1);
classE1_1.model_modified = -1;
classE1_1.saveModel_modified();
Master.PassCurrentWhatifName("");
Master.SetCurrentWhatifLabel();
updatingdatasource();
ShowWhatifs();
classE1_1.dowhatif_all_start();
classE1_1.runsqlado("UPDATE zs0tblWhatif SET display = -1 WHERE WID = 0;");
MPXWhatfcontrolChoices.SetActiveView(PageR1);
classE1_1.Close();
} catch (Exception ex) {
logFiles.ErrorLog(ex);
Master.ShowErrorMessage("MPX internal error has occured.");
}
}
