private void GenTypePage_Commit(object sender, AeroWizard.WizardPageConfirmEventArgs e)
{
if(rbGet.Checked)
{
GenType = TableQueryGenType.Get;
}
if(rbGetList.Checked)
{
GenType = TableQueryGenType.GetList;
}
if(rbPaged.Checked)
{
GenType = TableQueryGenType.Paged;
}
if(rbTop.Checked)
{
GenType = TableQueryGenType.Top;
}
if(rbExist.Checked)
{
GenType = TableQueryGenType.Exist;
}
if(rbCount.Checked)
{
GenType = TableQueryGenType.Count;
}
}
private void AddRetestLabelToWizard(AeroWizard.WizardPage wizardPage)
{
if (_retestLabel == null)
{
_retestLabel = new Label();
_retestLabel.Name = "lblRetest";
_retestLabel.BackColor = Color.LightGoldenrodYellow;
_retestLabel.ForeColor = Color.Red;
_retestLabel.Text = "RETEST";
_retestLabel.Font = new Font(_retestLabel.Font, FontStyle.Bold);
_retestLabel.TextAlign = ContentAlignment.MiddleCenter;
_retestLabel.Location = new Point(wizardPage.Width - 100, _retestLabel.Location.Y);
}
if (ProcessControl.Instance.IsRetest)
{
if (!wizardPage.Contains(_retestLabel))
wizardPage.Controls.Add(_retestLabel);
_retestLabel.Visible = true;
}
else
{
_retestLabel.Visible = false;
}
}
private void GenTypePage_Initialize(object sender, AeroWizard.WizardPageInitEventArgs e)
{
switch (GenType)
{
case TableQueryGenType.Get:
rbGet.Checked = true;
break;
case TableQueryGenType.GetList:
rbGetList.Checked = true;
break;
case TableQueryGenType.Paged:
rbPaged.Checked = true;
break;
case TableQueryGenType.Top:
rbTop.Checked = true;
break;
case TableQueryGenType.Exist:
rbExist.Checked = true;
break;
case TableQueryGenType.Count:
rbCount.Checked = true;
break;
default:
break;
}
}
private void wizardPageSummaryPart3_Initialize(object sender, AeroWizard.WizardPageInitEventArgs e)
{
if (tblSummaryPart3.RowCount == 1)
{
_testParameters.Clear();
_testParameters.Add(new Tuple<string, string>("Background RSSI", TestViewParameters.RF_BGR_RSSI));
_testParameters.Add(new Tuple<string, string>("HUB Acknowledgment", TestViewParameters.RF_HUB_ACK));
_testParameters.Add(new Tuple<string, string>("Ack RSSI value", TestViewParameters.RF_ACK_RSSI));
_testParameters.Add(new Tuple<string, string>("Accelerometer Base X", TestViewParameters.ACCELEROMETER_X_BASE));
_testParameters.Add(new Tuple<string, string>("Accelerometer Base Y", TestViewParameters.ACCELEROMETER_Y_BASE));
_testParameters.Add(new Tuple<string, string>("Accelerometer Base Z", TestViewParameters.ACCELEROMETER_Z_BASE));
_testParameters.Add(new Tuple<string, string>("Accelerometer Long Edge X", TestViewParameters.ACCELEROMETER_X_LONG_EDGE));
_testParameters.Add(new Tuple<string, string>("Accelerometer Long Edge Y", TestViewParameters.ACCELEROMETER_Y_LONG_EDGE));
_testParameters.Add(new Tuple<string, string>("Accelerometer Long Edge Z", TestViewParameters.ACCELEROMETER_Z_LONG_EDGE));
_testParameters.Add(new Tuple<string, string>("Accelerometer Short Edge X", TestViewParameters.ACCELEROMETER_X_SHORT_EDGE));
_testParameters.Add(new Tuple<string, string>("Accelerometer Short Edge Y", TestViewParameters.ACCELEROMETER_Y_SHORT_EDGE));
_testParameters.Add(new Tuple<string, string>("Accelerometer Short Edge Z", TestViewParameters.ACCELEROMETER_Z_SHORT_EDGE));
_activeTblLayoutPanel = tblSummaryPart3;
GenerateTable(_testParameters.ToArray());
}
}
private void wizardPageTransceiver_Initialize(object sender, AeroWizard.WizardPageInitEventArgs e)
{
if (tblTransceiverTest.RowCount == 1)
{
_testParameters.Clear();
_testParameters.Add(new Tuple<string, string>("Background RSSI", TestViewParameters.RF_BGR_RSSI));
_testParameters.Add(new Tuple<string, string>("HUB Acknowledgment", TestViewParameters.RF_HUB_ACK));
_testParameters.Add(new Tuple<string, string>("Ack RSSI value", TestViewParameters.RF_ACK_RSSI));
_activeTblLayoutPanel = tblTransceiverTest;
GenerateTable(_testParameters.ToArray());
}
}
private void wizardPageAccelTestStep2_Initialize(object sender, AeroWizard.WizardPageInitEventArgs e)
{
if (tblAccelerometerStep2.RowCount == 1)
{
_testParameters.Clear();
_testParameters.Add(new Tuple<string, string>("Accelerometer X", TestViewParameters.ACCELEROMETER_X_SHORT_EDGE));
_testParameters.Add(new Tuple<string, string>("Accelerometer Y", TestViewParameters.ACCELEROMETER_Y_SHORT_EDGE));
_testParameters.Add(new Tuple<string, string>("Accelerometer Z", TestViewParameters.ACCELEROMETER_Z_SHORT_EDGE));
_activeTblLayoutPanel = tblAccelerometerStep2;
GenerateTable(_testParameters.ToArray());
}
}
private void wizardPagePiezo_Initialize(object sender, AeroWizard.WizardPageInitEventArgs e)
{
if (tblPiezoPanel.RowCount == 1)
{
_testParameters.Clear();
_testParameters.Add(new Tuple<string, string>("Piezo test", TestViewParameters.PIEZO_TEST));
_testParameters.Add(new Tuple<string, string>("Reed test", TestViewParameters.REED_TEST));
_testParameters.Add(new Tuple<string, string>("Set RTC", TestViewParameters.RTC_SET));
_testParameters.Add(new Tuple<string, string>("Get RTC", TestViewParameters.RTC_GET));
_activeTblLayoutPanel = tblPiezoPanel;
GenerateTable(_testParameters.ToArray());
}
}
private void wizardPageLEDTest_Initialize(object sender, AeroWizard.WizardPageInitEventArgs e)
{
if (tbllnitialStatus.RowCount == 1)
{
_testParameters.Clear();
_testParameters.Add(new Tuple<string, string>("Firmware version", TestViewParameters.FIRMWARE_VERSION));
_testParameters.Add(new Tuple<string, string>("Node Id", TestViewParameters.NODE_ID));
_testParameters.Add(new Tuple<string, string>("Hub Id", TestViewParameters.HUB_ID));
_activeTblLayoutPanel = tblLEDTest;
GenerateTable(_testParameters.ToArray());
// Add the LED parameters after the table has been generated
_testParameters.Add(new Tuple<string, string>("Red LED", TestViewParameters.LED_RED_FLASH));
_testParameters.Add(new Tuple<string, string>("Green LED", TestViewParameters.LED_GREEN_FLASH));
}
}
private void wizardPageProgramPCB_Initialize(object sender, AeroWizard.WizardPageInitEventArgs e)
{
if (tblPCBUnitId.RowCount == 1)
{
_activeTblLayoutPanel = tblPCBUnitId;
_testParameters.Clear();
_testParameters.Add(new Tuple<string, string>("Run Current mA", TestViewParameters.RUN_CURRENT));
_testParameters.Add(new Tuple<string, string>("Sleep Current uA", TestViewParameters.SLEEP_CURRENT));
_testParameters.Add(new Tuple<string, string>("Test Node Id", TestViewParameters.NODE_ID));
_testParameters.Add(new Tuple<string, string>("Test Hub Id", TestViewParameters.HUB_ID));
GenerateTable(_testParameters.ToArray());
}
ProcessControl.Instance.TestResponseHandler += TestResponseHandler;
_timeOutTimer.Change(8000, Timeout.Infinite);
// Start the test process
_testExpired = false;
//ProcessControl.Instance.PrepareForTestRun();
}
void ShareWizzard_Commit(object sender, AeroWizard.WizardPageConfirmEventArgs e)
{
String CurrentexePath = System.Reflection.Assembly.GetExecutingAssembly().GetModules()[0].FullyQualifiedName;
string dir = Path.GetDirectoryName(CurrentexePath);
string ExePath = Path.Combine(dir, @"BetterExplorerOperations.exe");
Process proc = new Process();
var psi = new ProcessStartInfo
{
FileName = ExePath,
Verb = "runas",
UseShellExecute = true,
Arguments = "/env /user:"******"Administrator " + "\"" + ExePath + "\"",
};
proc.StartInfo = psi;
proc.Start();
Thread.Sleep(1000);
int z = WindowsAPI.sendWindowsStringMessage((int)WindowsAPI.getWindowId(null, "BetterExplorerOperations"), 0,
"Share", CurrentPath,txtShareName.Text,"");
proc.WaitForExit();
}
private void wizardPageSummaryPart2_Initialize(object sender, AeroWizard.WizardPageInitEventArgs e)
{
if (tblSummaryPart2.RowCount == 1)
{
_testParameters.Clear();
_testParameters.Add(new Tuple<string, string>("Red LED", TestViewParameters.LED_RED_FLASH));
_testParameters.Add(new Tuple<string, string>("Green LED", TestViewParameters.LED_GREEN_FLASH));
_testParameters.Add(new Tuple<string, string>("Piezo test", TestViewParameters.PIEZO_TEST));
_testParameters.Add(new Tuple<string, string>("Reed test", TestViewParameters.REED_TEST));
_testParameters.Add(new Tuple<string, string>("Set RTC", TestViewParameters.RTC_SET));
_testParameters.Add(new Tuple<string, string>("Get RTC", TestViewParameters.RTC_GET));
_testParameters.Add(new Tuple<string, string>("Key ENT", TestViewParameters.KEY_ENT));
_testParameters.Add(new Tuple<string, string>("Key 1/6", TestViewParameters.KEY_1_6));
_testParameters.Add(new Tuple<string, string>("Key 2/7", TestViewParameters.KEY_2_7));
_testParameters.Add(new Tuple<string, string>("Key 3/8", TestViewParameters.KEY_3_8));
_testParameters.Add(new Tuple<string, string>("Key 4/9", TestViewParameters.KEY_4_9));
_testParameters.Add(new Tuple<string, string>("Key 5/0", TestViewParameters.KEY_5_0));
_activeTblLayoutPanel = tblSummaryPart2;
GenerateTable(_testParameters.ToArray());
}
}
private void wizardPageSummaryPart1_Initialize(object sender, AeroWizard.WizardPageInitEventArgs e)
{
if (tblSummaryPart1.RowCount == 1)
{
_testParameters.Clear();
_testParameters.Add(new Tuple<string, string>("Firmware version", TestViewParameters.FIRMWARE_VERSION));
_testParameters.Add(new Tuple<string, string>("Node Id", TestViewParameters.NODE_ID));
_testParameters.Add(new Tuple<string, string>("Hub Id", TestViewParameters.HUB_ID));
_testParameters.Add(new Tuple<string, string>("Run current mA", TestViewParameters.RUN_CURRENT));
_testParameters.Add(new Tuple<string, string>("Sleep current uA", TestViewParameters.SLEEP_CURRENT));
_testParameters.Add(new Tuple<string, string>("Battery Volatge V", TestViewParameters.BATTERY_VOLTAGE));
_testParameters.Add(new Tuple<string, string>("Temperature C", TestViewParameters.TEMPERATURE_READING));
_testParameters.Add(new Tuple<string, string>("Ext SK3 test 1", TestViewParameters.EXT_SK3_TEST1));
_testParameters.Add(new Tuple<string, string>("Ext SK3 test 2", TestViewParameters.EXT_SK3_TEST2));
_testParameters.Add(new Tuple<string, string>("Ext SK5 test 1", TestViewParameters.EXT_SK5_TEST1));
_testParameters.Add(new Tuple<string, string>("Ext SK5 test 2", TestViewParameters.EXT_SK5_TEST2));
_testParameters.Add(new Tuple<string, string>("Ext SK5 test ADC 8", TestViewParameters.EXT_SK3_TEST_ADC8));
_testParameters.Add(new Tuple<string, string>("Ext SK5 test ADC 9", TestViewParameters.EXT_SK3_TEST_ADC9));
_testParameters.Add(new Tuple<string, string>("Ext SK5 test ADC 10", TestViewParameters.EXT_SK3_TEST_ADC10));
_activeTblLayoutPanel = tblSummaryPart1;
GenerateTable(_testParameters.ToArray());
}
}
private void wizardPage2_Initialize(object sender, AeroWizard.WizardPageInitEventArgs e)
{
headerPanel.Visible = topDivider.Visible = true;
startEndPicture.Visible = false;
}
private void wizardPageSummaryPart3_Rollback(object sender, AeroWizard.WizardPageConfirmEventArgs e)
{
}
private void OrderByPage_Initialize(object sender, AeroWizard.WizardPageInitEventArgs e)
{
ctrlOrderBy.SetOrderByItems(Table.Columns, OrderByItems);
}
private void ResultSettingPage_Commit(object sender, AeroWizard.WizardPageConfirmEventArgs e)
{
if (ResultList == null || ResultList.Count == 0)
return;
DbQueryCodeGen gen = new DbQueryCodeGen();
string code = string.Empty;
string connstr = App.Instance.DBLink.ConnectionString;
if (ResultList.Count == 1)
{
var ctrl = ResultList[0];
Module module = new Module();
module.ModuleName = ctrl.RowClassName;
module.CodeName = ctrl.RowClassName;
if (ctrl.DataTable != null)
{
foreach (DataColumn dc in ctrl.DataTable.Columns)
{
ModuleField mf = new ModuleField(module, "", dc.ColumnName, dc.ColumnName);
mf.DataType = dc.DataType;
mf.Nullable = dc.AllowDBNull;
mf.LanguageType = LanguageConvert.GetCSharpType(dc.DataType, dc.AllowDBNull);
//Debug.WriteLine("{0} ---> {1}", mf.FieldName, mf.LanguageType);
module.Fields.Add(mf);
}
}
if (ctrl.QueryExecuteType == SQLQueryExecuteType.ReadRows)
{
code = gen.GenForQueryList(this.SQL, module, connstr);
}
else if (ctrl.QueryExecuteType == SQLQueryExecuteType.ReadOneRow)
{
code = gen.GenForQueryOne(this.SQL, module, connstr);
}
else if (ctrl.QueryExecuteType == SQLQueryExecuteType.ExecuteSclor)
{
if (ctrl.DataTable != null && ctrl.DataTable.Columns != null && ctrl.DataTable.Columns.Count > 0)
{
var dc = ctrl.DataTable.Columns[0];
Type t = dc.DataType;
bool allowDBNull = dc.AllowDBNull;
code = gen.GenForExecuteScalar(this.SQL, t, allowDBNull, connstr);
}
}
else
{
code = gen.GenForExecuteNoQuery(this.SQL, connstr);
}
}
else
{
List<Module> modules = new List<Module>();
foreach (var ctrl in this.ResultList)
{
Module module = new Module();
module.ModuleName = ctrl.RowClassName;
module.CodeName = ctrl.RowClassName;
if (ctrl.DataTable != null)
{
foreach (DataColumn dc in ctrl.DataTable.Columns)
{
ModuleField mf = new ModuleField(module, "", dc.ColumnName, dc.ColumnName);
mf.DataType = dc.DataType;
mf.Nullable = dc.AllowDBNull;
mf.LanguageType = LanguageConvert.GetCSharpType(dc.DataType, dc.AllowDBNull);
//Debug.WriteLine("{0} ---> {1}", mf.FieldName, mf.LanguageType);
module.Fields.Add(mf);
}
}
modules.Add(module);
}
code = gen.GenForMultiQuery(this.SQL, modules, connstr);
}
CodeView codeView = new CodeView();
codeView.Dock = DockStyle.Fill;
ResultPage.Controls.Add(codeView);
codeView.Show(code);
}
private void wizardPageProgramPCB_Rollback(object sender, AeroWizard.WizardPageConfirmEventArgs e)
{
wizardPageProgramPCB_Leave(sender, e);
}
private void wizardPageProgramPCB_Commit(object sender, AeroWizard.WizardPageConfirmEventArgs e)
{
}
private void CodePage_Commit(object sender, AeroWizard.WizardPageConfirmEventArgs e)
{
this.SQL = txtSQL.Text;
MethodInfo.Params = GetMethodParams(this.SQL);
}
private void wizardPageAccelTestStep2_Rollback(object sender, AeroWizard.WizardPageConfirmEventArgs e)
{
wizardPageAccelTestStep2_Leave(sender, e);
}
private void OrderByPage_Commit(object sender, AeroWizard.WizardPageConfirmEventArgs e)
{
OrderByItems = ctrlOrderBy.GetOrderByItems();
DbSnippetGen gen = new DbSnippetGen();
TableQueryGenModel model = new TableQueryGenModel();
model.Table = this.Table;
model.GenType = this.GenType;
model.WhereColumns = this.WhereColumns;
model.OrderBy = this.OrderByItems;
model.ResultItemClassName = this.Table.PascalName;
string code = gen.GenTableQueryCode(model);
ctrlCodeView.Show(code);
}
private void wizardPageTransceiver_Rollback(object sender, AeroWizard.WizardPageConfirmEventArgs e)
{
wizardPageTransceiver_Leave(sender, e);
}
private void wizardPageKeyPress_Rollback(object sender, AeroWizard.WizardPageConfirmEventArgs e)
{
wizardPageKeyPress_Leave(sender, e);
}
private void QueryParamPage_Initialize(object sender, AeroWizard.WizardPageInitEventArgs e)
{
List<DataGridViewRow> rlist = new List<DataGridViewRow>();
dgvParam.Rows.Clear();
foreach (var item in MethodInfo.Params)
{
int rowIndex = dgvParam.Rows.Add();
DataGridViewRow row = dgvParam.Rows[rowIndex];
row.Cells[0].Value = item.ParamName;
DataGridViewComboBoxCell cboCol = (DataGridViewComboBoxCell)row.Cells[1];
if (!cboCol.Items.Contains(item.ParamType))
{
cboCol.Items.Add(item.ParamType);
}
row.Cells[1].Value = item.ParamType;
row.Cells[2].Value = item.AllowNull ? true : false;
row.Cells[3].Value = item.Remark;
}
dgvParam.Rows.AddRange(rlist.ToArray());
}
void ShareWizzard_Initialize(object sender, AeroWizard.WizardPageInitEventArgs e)
{
wizardControl1.CancelButtonText = "Close";
}
private void ResultSettingPage_Initialize(object sender, AeroWizard.WizardPageInitEventArgs e)
{
if (ds != null && ds.Tables != null && ds.Tables.Count > 0)
{
resultSettingPanel.Controls.Clear();
int dtcount = ds.Tables.Count;
for (int i = 0; i < dtcount; i++)
{
var dt = ds.Tables[i].Copy();
var mctrl = new SQLQueryResultControl(dt, i + 1);
ResultList.Add(mctrl);
mctrl.Location = new System.Drawing.Point(0, 160 * i);
mctrl.Size = new System.Drawing.Size(600, 160);
mctrl.HasMoreResult = dtcount > 1;
resultSettingPanel.Controls.Add(mctrl);
}
}
}
private void _finishPage_Initialize(object sender, AeroWizard.WizardPageInitEventArgs e)
{
var pattern = LocalizationManager.GetString("NewCollectionWizard.FinishPage","OK, that's all we need to get started with your new '{0}' collection.\r\nClick on the 'Finish' button.");
betterLabel1.Text = String.Format(pattern, Path.GetFileNameWithoutExtension(_collectionInfo.PathToSettingsFile));
}
private void CodePage_Initialize(object sender, AeroWizard.WizardPageInitEventArgs e)
{
txtSQL.Text = this.SQL;
}
private void wizardPageResultsStatus_Initialize(object sender, AeroWizard.WizardPageInitEventArgs e)
{
if (tbllnitialStatus.RowCount == 1)
{
_testParameters.Clear();
_testParameters.Add(new Tuple<string, string>("Voltage Supply V", TestViewParameters.VOLTAGE_SUPPLY));
_testParameters.Add(new Tuple<string, string>("Battery Voltage V", TestViewParameters.BATTERY_VOLTAGE));
_testParameters.Add(new Tuple<string, string>("Temperature C", TestViewParameters.TEMPERATURE_READING));
_testParameters.Add(new Tuple<string, string>("Ext SK3 test 1", TestViewParameters.EXT_SK3_TEST1));
_testParameters.Add(new Tuple<string, string>("Ext SK3 test 2", TestViewParameters.EXT_SK3_TEST2));
_testParameters.Add(new Tuple<string, string>("Ext SK5 test 1", TestViewParameters.EXT_SK5_TEST1));
_testParameters.Add(new Tuple<string, string>("Ext SK5 test 2", TestViewParameters.EXT_SK5_TEST2));
_testParameters.Add(new Tuple<string, string>("Ext SK5 test ADC 8", TestViewParameters.EXT_SK3_TEST_ADC8));
_testParameters.Add(new Tuple<string, string>("Ext SK5 test ADC 9", TestViewParameters.EXT_SK3_TEST_ADC9));
_testParameters.Add(new Tuple<string, string>("Ext SK5 test ADC 10", TestViewParameters.EXT_SK3_TEST_ADC10));
_activeTblLayoutPanel = tbllnitialStatus;
GenerateTable(_testParameters.ToArray());
}
}
private void QueryParamPage_Commit(object sender, AeroWizard.WizardPageConfirmEventArgs e)
{
}
