private async void btnLoadAllMachine_Click(object sender, EventArgs e) { waitForm.Show(main_parent); WebRequest request = new WebRequest(); HttpResponseMessage httpmachine = request.getmachine().Result; HttpResponseMessage httpzone = request.getzone().Result; HttpResponseMessage httpline = request.getline().Result; HttpResponseMessage httpprocess = request.getprocess().Result; HttpResponseMessage httpmodel = request.getmodel().Result; string machinedata = await httpmachine.Content.ReadAsStringAsync(); string zonedata = await httpzone.Content.ReadAsStringAsync(); string linedata = await httpline.Content.ReadAsStringAsync(); string modeldata = await httpmodel.Content.ReadAsStringAsync(); string processdata = await httpprocess.Content.ReadAsStringAsync(); if (chbdatabase.Checked) { try { machines = JsonConvert.DeserializeObject <List <Proc_Machines_Result> >(machinedata); zones = JsonConvert.DeserializeObject <List <Proc_FindAll_CM_Zone_Result> >(zonedata); lines = JsonConvert.DeserializeObject <List <Proc_FindAll_CM_Line_Result> >(linedata); models = JsonConvert.DeserializeObject <List <Proc_FindAll_CM_Model_Result> >(modeldata); process = JsonConvert.DeserializeObject <List <Proc_FindAll_CM_Process_Result> >(processdata); procMachinesResultBindingSource.DataSource = machines; cMZoneBindingSource.DataSource = zones; cMLineBindingSource.DataSource = lines; cMModelBindingSource.DataSource = models; cMProcessBindingSource.DataSource = process; lblquantitymc.Text = machines.Count.ToString(); } catch (Exception ex) { MetroFramework.MetroMessageBox.Show(this, ex.Message, "Information"); } } waitForm.Close(); }
//Большущая кнопка "Сгенерировать" private void b_gen_Click(object sender, EventArgs e) { if (!PathsAreCorrect()) { return; //Проверка введенных путей } //Генерируем тексты вариантов и ответы к ним List <TestVersion> testVersions = GenerateTestVersions(num_of_versions_.Value); //Сохраняем тексты вариантов _waitWindow.Show(); foreach (TestVersion version in testVersions) { if (_usersConfirmFormResult == DialogResult.Cancel && _applyToAll == true) { return; //Если пользователь отменил } //сохранение всех файлов //выходим _workWithWordDelegate d = new _workWithWordDelegate(SaveToWordFile); IAsyncResult result = d.BeginInvoke(way_for_versions_.Text, version.VersionText, version.VersionNum, FileContent.Tasks, null, null); d.EndInvoke(result); } //Сохраняем ответы foreach (TestVersion version in testVersions) { if (_usersConfirmFormResult == DialogResult.Cancel && _applyToAll == true) { return; //Если пользователь отменил } //сохранение всех файлов //выходим _workWithWordDelegate d = new _workWithWordDelegate(SaveToWordFile); IAsyncResult result = d.BeginInvoke(way_for_versions_.Text, version.AnswersText, version.VersionNum, FileContent.Answers, null, null); d.EndInvoke(result); } _waitWindow.Close(); _usersConfirmFormResult = DialogResult.None; _applyToAll = false; }
private void mergeToOneFile() // function to merge to one file { WaitWndFun waitForm = new WaitWndFun(); waitForm.Show(); string destFile = lsFileNames[0]; destFile.Remove(destFile.IndexOf('.')); destFile += "_merged.accdb"; //get destination file name System.IO.File.Copy(lsFileNames[0], destFile, true); //get db connection for destination file MyAccessDBController destDbController = new MyAccessDBController(destFile); //clear all tables except selected table destDbController.dropAllTablesExceptSelectedTable(strTableName); List <string> mergedColumns = new List <string>(); Dictionary <string, OleDbType> columnDataTypes = new Dictionary <string, OleDbType>(); // get necessary columns which will be merged for (int i = 0; i < gridColumns.Rows.Count; i++) { //get column type string column = gridColumns.Rows[i].Cells[1].Value.ToString(); mergedColumns.Add(column); columnDataTypes[column] = destDbController.getColumnType(column, strTableName); } //delete all columns except multiple columns destDbController.dropNotNecessaryColumns(mergedColumns, strTableName); //clear all records destDbController.makeEmptyTable(strTableName); outputPane.AppendText("Destination File : " + destFile + Environment.NewLine + Environment.NewLine); int totalLines = 0; // merge records one by one foreach (string fileName in lsFileNames) { int copiedLines = 0, skippedLines = 0; MyAccessDBController dbController = new MyAccessDBController(fileName); OleDbDataReader reader = dbController.getRecordReader(mergedColumns, strTableName); while (reader.Read()) { List <KeyValuePair <string, object> > record = new List <KeyValuePair <string, object> >(); int iterIndex = 0; foreach (string column in mergedColumns) { record.Add(new KeyValuePair <string, object>(column, reader[column])); // add to value list } for (iterIndex = 0; iterIndex < record.Count; iterIndex++) { if (record[iterIndex].Key == strIterColumnName) { break; } } string quato = ""; switch (columnDataTypes[record[iterIndex].Key]) { case OleDbType.Char: case OleDbType.Binary: case OleDbType.WChar: case OleDbType.VarChar: case OleDbType.LongVarChar: case OleDbType.VarWChar: case OleDbType.LongVarWChar: case OleDbType.VarBinary: case OleDbType.LongVarBinary: quato = "\'"; break; } if (record[iterIndex].Value.ToString() == "") { continue; } if (!destDbController.isExistField(record[iterIndex].Value.ToString(), strIterColumnName, strTableName, quato)) { destDbController.insertRecord(record, strTableName); copiedLines++; } else { skippedLines++; } } outputPane.AppendText(copiedLines.ToString() + " lines are copied from " + fileName + Environment.NewLine); outputPane.AppendText(skippedLines.ToString() + " lines are skipped from " + fileName + Environment.NewLine); outputPane.AppendText(Environment.NewLine); totalLines += copiedLines; } waitForm.Close(); outputPane.AppendText(Environment.NewLine + "Total Lines: " + totalLines.ToString() + Environment.NewLine); MessageBox.Show("Merge Completed"); }
private async void onLogin_Click(object sender, EventArgs e) { waitForm.Show(main_parent); if (string.IsNullOrEmpty(txtPassword.Text.Trim())) { MetroFramework.MetroMessageBox.Show(this, "Please input password", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (string.IsNullOrEmpty(txtUsername.Text.Trim())) { MetroFramework.MetroMessageBox.Show(this, "Please input Username", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } WebRequest request = new WebRequest(); HttpResponseMessage acc = request.getaccount().Result; string account = await acc.Content.ReadAsStringAsync(); var accounts = JsonConvert.DeserializeObject <List <CM_Account> >(account); var passmd5 = Helpers.ToMD5(txtPassword.Text.Trim()); var user_valid = accounts.Exists(a => a.GEN.Trim() == txtUsername.Text.Trim() && a.password.Trim() == passmd5); if (user_valid) { if (chkmemo.Checked) { if (Helpers.isExistsSetting("remembercheck")) { Helpers.SetSetting("remembercheck", "1"); Helpers.SetSetting("username", txtUsername.Text.Trim()); } else { Helpers.AddSetting("remembercheck", "1"); Helpers.AddSetting("username", txtUsername.Text.Trim()); } } else { if (Helpers.isExistsSetting("remembercheck")) { Helpers.SetSetting("remembercheck", "0"); Helpers.SetSetting("username", txtUsername.Text.Trim()); } else { Helpers.AddSetting("remembercheck", "0"); Helpers.AddSetting("username", txtUsername.Text.Trim()); } } UDllUpdate dashboard = new UDllUpdate(); dashboard.Dock = DockStyle.Fill; Main.Instance.MetroContainer.Controls.Clear(); Main.Instance.MetroContainer.Controls.Add(dashboard); } else { MetroFramework.MetroMessageBox.Show(this, "Please check user or password", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); Clear_Input(); } waitForm.Close(); }