public ListaItemsPersistencia(string nomeTabela, string chavePrimaria) { this._tabela = nomeTabela; this._chavePrimaria = chavePrimaria; this._mysql = new Mysql(); this._listaItems = new List<OItemPersistencia>(); }
public int count(string query) { try { query = query.ToLower(); this.comando.CommandText = Regex.Replace(query, @"select(.*)from", "select count(*) from"); this.conexion.Open(); return Convert.ToInt32(this.comando.ExecuteScalar()); } catch (Exception ex) { //Console.WriteLine(ex.Message); MessageBox.Show("proceso: " + ex.Message); } return 0; }
public void GetFromDatabase() { string sql = $"SELECT * FROM `receipt` WHERE `id` = '{ID}'"; CreateFromRow(Mysql.RunQueryWithReturn(sql).RowData[0]); }
private void Online() { Offline_delete(); gridOnline.Rows.Clear(); Mysql sql = new Mysql(); DataTable dt = sql.Select(@" SELECT IF( p.fecha > DATE_SUB(NOW(), INTERVAL " + minutos + @" MINUTE) ,'ONLINE' ,'OFFLINE' ) as estado ,CONCAT(o.nombre ,' ', o.apellido) as operador ,s.sector ,p.hostname ,p.vr ,DATE_FORMAT(p.fecha, '%d/%m/%Y') as fecha ,DATE_FORMAT(p.fecha, '%H:%i') as hora ,ar.area ,f.acceso from pc p left join ( select id,nombre,apellido,id_sector,id_area,flag_acceso from operador ) as o on o.id = p.id_operador left join ( select id,sector from sector ) as s on s.id = o.id_sector left join ( select flag,acceso from acceso ) as f on f.flag = o.flag_acceso left join ( select id,area from area ) as ar on ar.id = o.id_area order by estado desc "); if (dt.Rows.Count > 0) { foreach (DataRow r in dt.Rows) { gridOnline.Rows.Add( r["estado"].ToString(), r["operador"].ToString(), r["sector"].ToString(), r["area"].ToString(), r["acceso"].ToString(), r["hostname"].ToString(), r["vr"].ToString(), r["fecha"].ToString(), r["hora"].ToString() ); } } }
public List <SerializableObjects.InventorySlot> LoadInventory(Mysql mysql) { return(mysql.ReadInventory(dbid)); }
public bool ImportMastersFile() { this.Cursor = Cursors.WaitCursor; int i = 1; int ImportCount = 0; bool result = true; //ExcelTools.CheckExcellProcesses(); Excel.Application ExcelImportFile = new Excel.Application { DisplayAlerts = false }; Excel.Workbook workbook = null; Excel.Worksheet worksheet = null; try { // Открываем книгу из папки с запускаемым файлом workbook = ExcelImportFile.Workbooks.Open(eImportFile.Text); // Получаем первую таблицу worksheet = workbook.ActiveSheet as Excel.Worksheet; while (true) { i++; string fio = worksheet.Cells[i, 1].Text; string dol = worksheet.Cells[i, 2].Text; string tel = worksheet.Cells[i, 3].Text; if ((fio == "") || (dol == "") || (tel == "")) { break; } if (Mysql.FindMasterInBase(fio)) { string addition = "(число)"; for (int add = 1; add < 99999; add++) { addition = "(" + add.ToString() + ")"; if (!Mysql.FindMasterInBase(fio + addition)) { break; } } MessageBox.Show("Работник " + fio + " уже содержится в базе.\nВ базу " + fio + " будет импортирован под именем - " + fio + addition + "\nВ Форму 4 данный работник будет выгружен без дополнения '" + addition + "'"); fio += addition; if (!Mysql.AddNewMasterInBase(fio, dol, tel, ResId, Config.Companies[cbCompany.Text].Id)) { MessageBox.Show("Ошибка при импорте работника - " + fio); break; } else { ImportCount++; } } else { if (!Mysql.AddNewMasterInBase(fio, dol, tel, ResId, Config.Companies[cbCompany.Text].Id)) { MessageBox.Show("Ошибка при импорте работника - " + fio); break; } else { ImportCount++; } } } } catch (Exception ex) { MessageBox.Show(ex.Message); result = false; } finally { MessageBox.Show("Импортировано - " + ImportCount.ToString() + " работников"); workbook.Close(false, System.Reflection.Missing.Value, System.Reflection.Missing.Value); System.Runtime.InteropServices.Marshal.FinalReleaseComObject(worksheet); System.Runtime.InteropServices.Marshal.FinalReleaseComObject(workbook); ////Подготовка к убийству процесса Excel int ExcelPID = 0; int Hwnd = 0; Hwnd = ExcelImportFile.Hwnd; System.Diagnostics.Process ExcelProcess; GetWindowThreadProcessId((IntPtr)Hwnd, out ExcelPID); ExcelProcess = System.Diagnostics.Process.GetProcessById(ExcelPID); ////Конец подготовки к убийству процесса Excel ExcelImportFile.Quit(); System.Runtime.InteropServices.Marshal.FinalReleaseComObject(ExcelImportFile); GC.Collect(); GC.WaitForPendingFinalizers(); ////Убийство процесса Excel ExcelProcess.Kill(); ExcelProcess = null; //ExcelTools.KillExcel(); this.Cursor = Cursors.Default; } return(result); }
public void GetDados(StringBuilder query) { Mysql mysql = new Mysql(); this._dataSet = mysql.RecuperarDataSet(query); }
private void btn_save_Click(object sender, EventArgs e) { if (cbRes.SelectedIndex < 0) { MessageBox.Show("Необходимо выбрать РЭС."); } else { bool err = false; if ((l1.Visible) && (l1.Text == "")) { err = true; } if ((p1.Visible) && (p1.Text == "")) { err = true; } if ((p2.Visible) && (p2.Text == "")) { err = true; } if ((p3.Visible) && (p3.Text == "")) { err = true; } if ((p4.Visible) && (p4.Text == "")) { err = true; } if ((FiderId == int.MinValue) && err) { MessageBox.Show("Не все поля заполнены"); } else { if (FiderId == int.MinValue) //Если это новый фидер { if (Mysql.FindFiderInBase(edFiderName.Text)) { MessageBox.Show("В базе уже содержится " + edFiderName.Text + "\nДобавить объект с таким же именем невозможно!"); } else { int FiderType = cbTypeVL.SelectedIndex; if (Mysql.AddNewFiderInBase(edFiderName.Text, FiderType, Config.Reses[cbRes.Text].Id, Config.Companies[cbCompany.Text].Id, (int)TP.Value, (int)SZO.Value, (int)NP.Value, (int)Population.Value, P_load_l.Value, P_load_z.Value)) { this.DialogResult = DialogResult.Yes; } else { this.DialogResult = DialogResult.No; } this.Hide(); } } else //Если это редактирование фидера { if (Mysql.EditFiderFromBase(FiderId, edFiderName.Text, (int)TP.Value, (int)SZO.Value, (int)NP.Value, (int)Population.Value, P_load_l.Value, P_load_z.Value)) { this.DialogResult = DialogResult.Yes; } else { this.DialogResult = DialogResult.No; } this.Hide(); } } } }
void ScanBGetBarcodeCallback(string barcode) { if (barcode != "Error") { Mysql mysql = new Mysql(); if (mysql.Connect()) { string stm = "SELECT * FROM BODMSG WHERE SCBODBAR = '" + barcode + "' ORDER BY SIDATE DESC LIMIT 0,5"; DataSet ds = mysql.Select(stm); DataTable dt = ds.Tables["table0"]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["STATUS"] == DBNull.Value) { this.Dispatcher.Invoke(new Action(() => { AddMessage("板 " + barcode + " 状态栏位为空"); })); Fx5u_2.SetM("M2605", true);//载具扫码-未测过【B轨道】 } else { if ((string)dt.Rows[0]["STATUS"] == "OFF") { this.Dispatcher.Invoke(new Action(() => { AddMessage("板 " + barcode + " 未测试"); })); Fx5u_2.SetM("M2605", true);//载具扫码-未测过【B轨道】 } else { stm = "SELECT * FROM BARBIND WHERE SCBODBAR = '" + barcode + "' ORDER BY SIDATE DESC LIMIT 0,15"; ds = mysql.Select(stm); dt = ds.Tables["table0"]; if (dt.Rows.Count == 15) { stm = "INSERT INTO BODMSG (SCBODBAR, STATUS) VALUES('" + barcode + "','OFF')"; int rstnum = mysql.executeQuery(stm); if (rstnum > 0) { this.Dispatcher.Invoke(new Action(() => { AddMessage("板 " + barcode + " 解绑"); })); short[] result = new short[15]; bool checkrst = true; for (int i = 0; i < 15; i++) { DataRow[] drs = dt.Select(string.Format("PCSSER = '{0}'", (i + 1).ToString())); if (drs.Length == 1) { try { result[i] = short.Parse((string)drs[0]["RESULT"]); } catch (Exception ex) { this.Dispatcher.Invoke(new Action(() => { AddMessage(ex.Message); })); checkrst = false; break; } } else { this.Dispatcher.Invoke(new Action(() => { AddMessage("板 " + barcode + " 序号 " + (i + 1).ToString() + "索引数 " + drs.Length.ToString()); })); checkrst = false; break; } } if (checkrst) { string str; Fx5u_2.WriteMultD("D1020", result); str = "B_BordInfo;"; for (int i = 0; i < 15; i++) { str += result[i].ToString() + ";"; } str = str.Substring(0, str.Length - 1); this.Dispatcher.Invoke(new Action(() => { AddMessage(str); })); Fx5u_2.SetM("M2604", true);//载具扫码-已测过【B轨道】 } else { Fx5u_2.SetM("M2605", true);//载具扫码-未测过【B轨道】 } } else { this.Dispatcher.Invoke(new Action(() => { AddMessage("解绑失败"); })); Fx5u_2.SetM("M2603", true);//载具扫码NG【B轨道】 } } else { this.Dispatcher.Invoke(new Action(() => { AddMessage("板 " + barcode + " 记录数目不是15"); })); Fx5u_2.SetM("M2605", true);//载具扫码-未测过【B轨道】 } } } } else { this.Dispatcher.Invoke(new Action(() => { AddMessage("板 " + barcode + " 信息未录入"); })); Fx5u_2.SetM("M2605", true); //载具扫码-未测过【A轨道】 } Fx5u_2.SetM("M2602", true); //载具扫码OK【B轨道】 } mysql.DisConnect(); } else { this.Dispatcher.Invoke(new Action(() => { AddMessage("扫码失败"); })); Fx5u_2.SetM("M2603", true);//载具扫码NG【B轨道】 } }
public IEnumerable <Member> Get() { Mysql mysqlGet = new Mysql(); return(mysqlGet.UserList()); }
private void button1_Click_1(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(richTextBox1.Text)) { errorProvider1.SetError(richTextBox1, "Campo obligatorio"); } if (string.IsNullOrEmpty(textBox2.Text)) { errorProvider1.SetError(textBox2, "Campo obligatorio"); } if (string.IsNullOrEmpty(textBox1.Text)) { errorProvider1.SetError(textBox1, "Campo obligatorio"); } if (string.IsNullOrEmpty(textBox3.Text)) { errorProvider1.SetError(textBox3, "Campo obligatorio"); } if (string.IsNullOrEmpty(textBox4.Text)) { errorProvider1.SetError(textBox4, "Campo obligatorio"); } if (string.IsNullOrEmpty(textBox5.Text)) { errorProvider1.SetError(textBox5, "Campo obligatorio"); } if (string.IsNullOrEmpty(textBox6.Text)) { errorProvider1.SetError(textBox6, "Campo obligatorio"); } if (string.IsNullOrEmpty(textBox7.Text)) { errorProvider1.SetError(textBox7, "Campo obligatorio"); } if (string.IsNullOrEmpty(textBox8.Text)) { errorProvider1.SetError(textBox8, "Campo obligatorio"); } if (string.IsNullOrEmpty(textBox9.Text)) { errorProvider1.SetError(textBox9, "Campo obligatorio"); } if (!string.IsNullOrEmpty(textBox2.Text) && !string.IsNullOrEmpty(textBox1.Text) && !string.IsNullOrEmpty(textBox3.Text) && !string.IsNullOrEmpty(textBox4.Text) && !string.IsNullOrEmpty(textBox5.Text) && !string.IsNullOrEmpty(textBox6.Text) && !string.IsNullOrEmpty(textBox7.Text) && !string.IsNullOrEmpty(textBox8.Text) && !string.IsNullOrEmpty(textBox9.Text) && !string.IsNullOrEmpty(richTextBox1.Text)) { using (var mysql = new Mysql()) { mysql.conexion(); mysql.cadenasql = "INSERT INTO `items`(`Barcode`, `Descripcion`, `Impuesto`, `Precio`, `OnHand`, `Costo`, `Marca`, `Talla`, `Familia`, `Estilo`, `Genero`) VALUES (@ba,@de,@im,@pr,@on,@co,@ma,@ta,@fa,@es,@ge)"; mysql.comando = new MySqlCommand(mysql.cadenasql, mysql.con); mysql.comando.Parameters.AddWithValue("@ba", textBox2.Text); mysql.comando.Parameters.AddWithValue("@de", richTextBox1.Text); mysql.comando.Parameters.AddWithValue("@im", comboBox1.Text); mysql.comando.Parameters.AddWithValue("@pr", textBox1.Text); mysql.comando.Parameters.AddWithValue("@on", textBox3.Text); mysql.comando.Parameters.AddWithValue("@co", textBox4.Text); mysql.comando.Parameters.AddWithValue("@ma", textBox5.Text); mysql.comando.Parameters.AddWithValue("@ta", textBox6.Text); mysql.comando.Parameters.AddWithValue("@fa", textBox7.Text); mysql.comando.Parameters.AddWithValue("@es", textBox8.Text); mysql.comando.Parameters.AddWithValue("@ge", textBox9.Text); mysql.comando.ExecuteNonQuery(); mysql.Dispose(); MessageBox.Show("La solicitud se proceso correctamente", "Acción realizada", MessageBoxButtons.OK, MessageBoxIcon.Information); limpiar(); } } textBox2.Focus(); } catch (MySqlException my) { MessageBox.Show("Este producto ya existe.Intente con otro código", "No se aceptan códigos repetidos", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } catch (Exception exec) { Mensaje.Error(exec, "67"); } }
public void DeactivateStorageRoom() { string sql = $"UPDATE `storagerooms` SET `deactivated` = '1' WHERE `id` = '{ID}';"; Mysql.RunQuery(sql); }
private void TcpServer_Received(object sender, string e) { string restr = e.Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries)[0]; AddMessage("接收:" + restr); Task.Run(() => { try { if (Directory.Exists(WorkPath)) { DirectoryInfo folder = new DirectoryInfo(WorkPath); int cout = 0; FileInfo[] files = folder.GetFiles(restr); while (!(files.Length > 0 && !IsFileLocked(files[0])) && cout < 10) { files = folder.GetFiles(restr); cout++; System.Threading.Thread.Sleep(200); } if (cout < 10) { string[] vs = files[0].Name.Split(new string[] { "_" }, StringSplitOptions.RemoveEmptyEntries); if (vs.Length == 3) { HObject img; HOperatorSet.ReadImage(out img, files[0].FullName); CameraIamge = new HImage(img); if (!Directory.Exists(Path.Combine(ImageSavePath, vs[1]))) { Directory.CreateDirectory(Path.Combine(ImageSavePath, vs[1])); } string[] vs1 = vs[2].Split(new string[] { "." }, StringSplitOptions.RemoveEmptyEntries); if (!Directory.Exists(Path.Combine(ImageSavePath, vs[1], vs1[0]))) { Directory.CreateDirectory(Path.Combine(ImageSavePath, vs[1], vs1[0])); } File.Copy(files[0].FullName, Path.Combine(ImageSavePath, vs[1], vs1[0], files[0].Name), true); string str = files[0].FullName; File.Delete(str); Mysql mysql = new Mysql(); if (mysql.Connect()) { string stm = ""; switch (vs[1]) { case "M1": stm = $"INSERT INTO aviproductdata (BoardID,PcsIndex,ResultItem1) VALUES ('{vs[0]}',{vs1[0]},'OK')"; break; case "M2": stm = $"UPDATE aviproductdata SET ResultItem2 = 'OK' WHERE BoardID = '{vs[0]}' AND PcsIndex = {vs1[0]}"; break; case "M3": stm = $"UPDATE aviproductdata SET ResultItem3 = 'OK' WHERE BoardID = '{vs[0]}' AND PcsIndex = {vs1[0]}"; break; case "M4": stm = $"UPDATE aviproductdata SET ResultItem4 = 'OK' WHERE BoardID = '{vs[0]}' AND PcsIndex = {vs1[0]}"; break; default: break; } int result = mysql.executeQuery(stm); if (result < 1) { AddMessage("请注意,数据库插入失败"); } StatusDataBase = true; } else { AddMessage("数据库未连接"); StatusDataBase = false; } mysql.DisConnect(); AddMessage($"{str}文件处理完成"); } else { string str = files[0].FullName; File.Delete(str); AddMessage($"{str}文件名非法,已删除"); } } else { AddMessage($"获取文件{restr}超时"); } } } catch (Exception ex) { AddMessage(ex.Message); } }); }
public void crearreporte() { int y = 1; try { Workbook workbook = new Workbook(); Worksheet sheet = workbook.Worksheets[0]; for (int x = 0; x < dataGridView1.Rows.Count; x++) { using (var mysql = new Mysql()) { mysql.conexion(); mysql.cadenasql = "select count(*),Barcode,Descripcion,Precio,OnHand from items where Barcode=@co"; mysql.comando = new MySqlCommand(mysql.cadenasql, mysql.con); mysql.comando.Parameters.AddWithValue("@co", dataGridView1.Rows[x].Cells[0].Value.ToString()); mysql.comando.ExecuteNonQuery(); using (MySqlDataReader lee = mysql.comando.ExecuteReader()) { while (lee.Read()) { if (Int64.Parse(lee["count(*)"].ToString()) > 0) { if (x == 0) { updates(dataGridView1.Rows[x].Cells[0].Value.ToString(), dataGridView1.Rows[x].Cells[1].Value.ToString(), dataGridView1.Rows[x].Cells[2].Value.ToString(), dataGridView1.Rows[x].Cells[3].Value.ToString(), dataGridView1.Rows[x].Cells[4].Value.ToString(), dataGridView1.Rows[x].Cells[5].Value.ToString(), dataGridView1.Rows[x].Cells[6].Value.ToString(), dataGridView1.Rows[x].Cells[7].Value.ToString(), dataGridView1.Rows[x].Cells[8].Value.ToString(), dataGridView1.Rows[x].Cells[9].Value.ToString(), dataGridView1.Rows[x].Cells[10].Value.ToString()); sheet.Range["A" + y].Text = "Código"; sheet.Range["B" + y].Text = "Descripción"; sheet.Range["C" + y].Text = "Precio"; sheet.Range["D" + y].Text = "Cantidad"; sheet.Range["E" + y].Text = "Ingreso"; sheet.Range["F" + y].Text = "Cantidad Total"; sheet.Range["G" + y].Text = "Suma precio Total"; y++; sheet.Range["A" + y].Text = lee["Barcode"].ToString(); sheet.Range["B" + y].Text = lee["Descripcion"].ToString(); sheet.Range["C" + y].NumberValue = double.Parse(lee["Precio"].ToString()); sheet.Range["D" + y].NumberValue = Int64.Parse(lee["OnHand"].ToString()); sheet.Range["E" + y].NumberValue = Int64.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString()); sheet.Range["F" + y].NumberValue = (double.Parse(lee["OnHand"].ToString()) + double.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString())); sheet.Range["G" + y].NumberValue = ((double.Parse(lee["Precio"].ToString()) * (double.Parse(lee["OnHand"].ToString()) + double.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString())))); y++; } else { updates(dataGridView1.Rows[x].Cells[0].Value.ToString(), dataGridView1.Rows[x].Cells[1].Value.ToString(), dataGridView1.Rows[x].Cells[2].Value.ToString(), dataGridView1.Rows[x].Cells[3].Value.ToString(), dataGridView1.Rows[x].Cells[4].Value.ToString(), dataGridView1.Rows[x].Cells[5].Value.ToString(), dataGridView1.Rows[x].Cells[6].Value.ToString(), dataGridView1.Rows[x].Cells[7].Value.ToString(), dataGridView1.Rows[x].Cells[8].Value.ToString(), dataGridView1.Rows[x].Cells[9].Value.ToString(), dataGridView1.Rows[x].Cells[10].Value.ToString()); sheet.Range["A" + y].Text = lee["Barcode"].ToString(); sheet.Range["B" + y].Text = lee["Descripcion"].ToString(); sheet.Range["C" + y].NumberValue = double.Parse(lee["Precio"].ToString()); sheet.Range["D" + y].NumberValue = Int64.Parse(lee["OnHand"].ToString()); sheet.Range["E" + y].NumberValue = Int64.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString()); sheet.Range["F" + y].NumberValue = (double.Parse(lee["OnHand"].ToString()) + double.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString())); sheet.Range["G" + y].NumberValue = ((double.Parse(lee["Precio"].ToString()) * (double.Parse(lee["OnHand"].ToString()) + double.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString())))); y++; } } else { if (x == 0) { insertes(dataGridView1.Rows[x].Cells[0].Value.ToString(), dataGridView1.Rows[x].Cells[1].Value.ToString(), dataGridView1.Rows[x].Cells[2].Value.ToString(), dataGridView1.Rows[x].Cells[3].Value.ToString(), dataGridView1.Rows[x].Cells[4].Value.ToString(), dataGridView1.Rows[x].Cells[5].Value.ToString(), dataGridView1.Rows[x].Cells[6].Value.ToString(), dataGridView1.Rows[x].Cells[7].Value.ToString(), dataGridView1.Rows[x].Cells[8].Value.ToString(), dataGridView1.Rows[x].Cells[9].Value.ToString(), dataGridView1.Rows[x].Cells[10].Value.ToString()); sheet.Range["A" + y].Text = "Código"; sheet.Range["B" + y].Text = "Descripción"; sheet.Range["C" + y].Text = "Precio"; sheet.Range["D" + y].Text = "Cantidad"; sheet.Range["E" + y].Text = "Ingreso"; sheet.Range["F" + y].Text = "Cantidad Total"; sheet.Range["G" + y].Text = "Suma precio Total"; y++; sheet.Range["A" + y].Text = dataGridView1.Rows[x].Cells[0].Value.ToString(); sheet.Range["B" + y].Text = dataGridView1.Rows[x].Cells[1].Value.ToString(); sheet.Range["C" + y].NumberValue = double.Parse(dataGridView1.Rows[x].Cells[3].Value.ToString()); sheet.Range["D" + y].NumberValue = Int64.Parse(lee["OnHand"].ToString()); sheet.Range["E" + y].NumberValue = Int64.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString()); sheet.Range["F" + y].NumberValue = Int64.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString()); sheet.Range["G" + y].NumberValue = ((double.Parse(dataGridView1.Rows[x].Cells[3].Value.ToString()) * (double.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString())))); y++; } else { insertes(dataGridView1.Rows[x].Cells[0].Value.ToString(), dataGridView1.Rows[x].Cells[1].Value.ToString(), dataGridView1.Rows[x].Cells[2].Value.ToString(), dataGridView1.Rows[x].Cells[3].Value.ToString(), dataGridView1.Rows[x].Cells[4].Value.ToString(), dataGridView1.Rows[x].Cells[5].Value.ToString(), dataGridView1.Rows[x].Cells[6].Value.ToString(), dataGridView1.Rows[x].Cells[7].Value.ToString(), dataGridView1.Rows[x].Cells[8].Value.ToString(), dataGridView1.Rows[x].Cells[9].Value.ToString(), dataGridView1.Rows[x].Cells[10].Value.ToString()); sheet.Range["A" + y].Text = dataGridView1.Rows[x].Cells[0].Value.ToString(); sheet.Range["B" + y].Text = dataGridView1.Rows[x].Cells[1].Value.ToString(); sheet.Range["C" + y].NumberValue = double.Parse(dataGridView1.Rows[x].Cells[3].Value.ToString()); sheet.Range["D" + y].NumberValue = Int64.Parse(lee["OnHand"].ToString()); sheet.Range["E" + y].NumberValue = Int64.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString()); sheet.Range["F" + y].NumberValue = Int64.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString()); sheet.Range["G" + y].NumberValue = ((double.Parse(dataGridView1.Rows[x].Cells[3].Value.ToString()) * (double.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString())))); y++; } } } } mysql.Dispose(); } } workbook.SaveToFile(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "/reporteinventario.xls"); dataGridView1.DataSource = null; } catch (Exception xls) { MessageBox.Show(xls.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Hand); } }
public static void CreateNewPassword(string passwordInput) { string setQuery = $"UPDATE `admin_password` SET `admin_password` = '{SaltAndHashPassword(passwordInput)}' WHERE `id` = '1'"; Mysql.RunQuery(setQuery); }
private void Awake() { mysql = FindObjectOfType <Mysql>(); }
public IEnumerable <History> GetHistory() { Mysql mysqlGet = new Mysql(); return(mysqlGet.HistortList()); }
public override void GetFromDatabase() { string sql = $"SELECT * FROM `order_transactions` WHERE `id` = {_id}"; CreateFromRow(Mysql.RunQueryWithReturn(sql).RowData[0]); }
public string DeleteMember(int id) { Mysql mysqlGet = new Mysql(); return(mysqlGet.DeleteMember(id)); }
private void guardarcierre() { impri = false; numero = ""; try { if (!string.IsNullOrEmpty(textBox2.Text) && !string.IsNullOrEmpty(textBox3.Text) && !string.IsNullOrEmpty(textBox1.Text) && !string.IsNullOrEmpty(textBox8.Text) && !string.IsNullOrEmpty(textBox4.Text) && !string.IsNullOrEmpty(textBox10.Text) && !string.IsNullOrEmpty(textBox9.Text) && !string.IsNullOrEmpty(textBox12.Text) && !string.IsNullOrEmpty(textBox11.Text) && !string.IsNullOrEmpty(textBox13.Text) && !string.IsNullOrEmpty(textBox14.Text) && !string.IsNullOrEmpty(textBox7.Text) && !string.IsNullOrEmpty(textBox5.Text) && !string.IsNullOrEmpty(textBox6.Text)) { if (dataGridView1.Rows.Count > 0) { inicialf = Int32.Parse(dataGridView1.Rows[0].Cells[0].Value.ToString()); finalf = Int32.Parse(dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[0].Value.ToString()); } else { inicialf = 0; finalf = 0; } if (dataGridView2.Rows.Count > 0) { inicialp = Int32.Parse(dataGridView2.Rows[0].Cells[0].Value.ToString()); finalp = Int32.Parse(dataGridView2.Rows[dataGridView2.Rows.Count - 1].Cells[0].Value.ToString()); } else { inicialp = 0; finalp = 0; } if (dataGridView3.Rows.Count > 0) { iniciala = Int32.Parse(dataGridView3.Rows[0].Cells[0].Value.ToString()); finala = Int32.Parse(dataGridView3.Rows[dataGridView3.Rows.Count - 1].Cells[0].Value.ToString()); } else { iniciala = 0; finala = 0; } using (var mysql = new Mysql()) { mysql.conexion(); mysql.cadenasql = "INSERT INTO `cierre`(`Fecha`, `FacturaInicialf`, `FacturaFinalf`,`FacturaInicialp`,`FacturaFinalp`,`abonoinicial`, `abonofinal`, `VentasContado`, `Abonos`,`Fondo`,`VentasTarjeta`) VALUES (" + "'" + DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day + "'," + "'" + inicialf + "'," + "'" + finalf + "'," + "'" + inicialp + "'," + "'" + finalp + "'," + "'" + iniciala + "'," + "'" + finala + "'," + "'" + double.Parse(textBox13.Text).ToString("0.00000000", CultureInfo.InvariantCulture) + "'," + "'" + double.Parse(textBox4.Text).ToString("0.00000000", CultureInfo.InvariantCulture) + "'" + ",'" + double.Parse(textBox5.Text).ToString("0.00000000", CultureInfo.InvariantCulture) + "'" + ",'" + double.Parse(textBox14.Text).ToString("0.00000000", CultureInfo.InvariantCulture) + "')"; mysql.comando = new MySqlCommand(mysql.cadenasql, mysql.con); mysql.comando.ExecuteNonQuery(); mysql.Dispose(); impri = true; } using (var mysql2 = new Mysql()) { mysql2.conexion(); mysql2.cadenasql = "select Max(Numero) from cierre"; mysql2.comando = new MySqlCommand(mysql2.cadenasql, mysql2.con); mysql2.comando.ExecuteNonQuery(); using (var lee2 = mysql2.comando.ExecuteReader()) { while (lee2.Read()) { numero = lee2["Max(Numero)"].ToString(); } } mysql2.Dispose(); } } else { MessageBox.Show("Faltan datos", "Faltan datos", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } } catch (Exception evo) { MessageBox.Show(evo.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public string EditMember(int id, string emId, string firstname, string lastname, string card, string tel, string address) { Mysql mysqlGet = new Mysql(); return(mysqlGet.EditMember(id, emId, firstname, lastname, card, tel, address)); }
public void formatodeactura() { string otrosabonos = ""; string inicial = ""; string nombre = ""; formato = ""; try { using (var mysql = new Mysql()) { mysql.conexion2(); mysql.cadenasql = "select NumFactura,Abono,Fecha from abonos where Cedula='" + dataGridView1.CurrentRow.Cells[1].Value + "' and NumFactura='" + dataGridView1.CurrentRow.Cells[2].Value + "'"; mysql.comando = new MySqlCommand(mysql.cadenasql, mysql.con); mysql.comando.ExecuteNonQuery(); using (var reader = mysql.comando.ExecuteReader()) { while (reader.Read()) { otrosabonos += "\n" + "#" + reader["NumFactura"].ToString() + "\t " + "₡" + reader["Abono"].ToString() + "\n" + reader["Fecha"].ToString(); } } mysql.cadenasql = "select Inicial,Saldo from saldos where NumFactura='" + dataGridView1.CurrentRow.Cells[2].Value + "'"; mysql.comando = new MySqlCommand(mysql.cadenasql, mysql.con); mysql.comando.ExecuteNonQuery(); using (var reader = mysql.comando.ExecuteReader()) { while (reader.Read()) { inicial = reader["Inicial"].ToString(); saldoact = reader["Saldo"].ToString(); } } mysql.cadenasql = "select Nombre from clientes where Cedula='" + dataGridView1.CurrentRow.Cells[1].Value + "'"; mysql.comando = new MySqlCommand(mysql.cadenasql, mysql.con); mysql.comando.ExecuteNonQuery(); using (var reader = mysql.comando.ExecuteReader()) { while (reader.Read()) { nombre = reader["Nombre"].ToString(); } } mysql.cadenasql = "SELECT Fecha FROM saldos WHERE NumFactura='" + dataGridView1.CurrentRow.Cells[2].Value + "'"; mysql.comando = new MySqlCommand(mysql.cadenasql, mysql.con); mysql.comando.ExecuteNonQuery(); using (MySqlDataReader lee = mysql.comando.ExecuteReader()) { while (lee.Read()) { fechavenc = lee["Fecha"].ToString(); } } DateTime feg = DateTime.Parse(fechavenc); //mysql.cadenasql = "SELECT DATE_ADD('date("+ fechavenc + ")',INTERVAL 90 DAY) AS fe"; mysql.cadenasql = "SELECT DATE_ADD('" + feg.ToString("yyyy-MM-dd hh:mm:ss tt") + "',INTERVAL 90 DAY)"; mysql.comando = new MySqlCommand(mysql.cadenasql, mysql.con); mysql.comando.ExecuteNonQuery(); using (MySqlDataReader lee = mysql.comando.ExecuteReader()) { while (lee.Read()) { diasvencer = lee["DATE_ADD('" + feg.ToString("yyyy-MM-dd hh:mm:ss tt") + "',INTERVAL 90 DAY)"].ToString(); } } mysql.Dispose(); formato = ConfigurationManager.AppSettings["cadena2"] + "\n------------------------------------------------" + "\nFECHA DEL APARTADO:\n" + fechavenc + "\nFECHA DE VENCIMIENTO:\n" + DateTime.Parse(diasvencer) + "\n" + "\nCAJERO: " + dataGridView1.CurrentRow.Cells[5].Value + "\nCLIENTE: " + nombre + "\nSALDO INICIAL: " + inicial + "\nSALDO ACTUAL: " + saldoact + "\n------------------------------------------------" + "\n\nABONOS HASTA EL MOMENTO:" + "\n\nNo.Factura Monto abonado" + otrosabonos + "\n------------------------------------------------"; facturawr = new StreamWriter("Abonohistorico.txt"); facturawr.WriteLine(formato); facturawr.Flush(); facturawr.Close(); } } catch (Exception err_0016) { Mensaje.Error(err_0016, "329"); } }
public string SaveHistory(int EmId, string Name, string Surname, string Tel, string Date) { Mysql mysqlGet = new Mysql(); return(mysqlGet.SaveHistory(EmId, Name, Surname, Tel, Date)); }
public void Load() { Mysql mysql = FindObjectOfType <Mysql>(); Action ac = () => { try { List <ShipBaseStat> stats = mysql.ReadShipBaseStatsTable(); List <Experience> exp = mysql.ReadExperienceTable(); PlayerData data = mysql.ReadPlayerData(dbid); List <PlayerSkillLevel> skills = mysql.ReadPlayerSkills(dbid); this.stats = stats; this.exp = exp; this.data = data; this.skills = skills; if (!NetworkManager.traders.ContainsKey(dbid)) { NetworkManager.traders.Add(dbid, mysql.ReadTraders()); } List <SerializableObjects.Item> shipEquipment = LoadShipEquipment(mysql); List <SerializableObjects.Equipment> playerEquipment = LoadPlayerEquipment(mysql); List <SerializableObjects.InventorySlot> inventory = LoadInventory(mysql); List <RandomLoot> loot = mysql.LoadPlayerLoot(dbid); if (!GameServer.playerLoot.ContainsKey(id)) { GameServer.playerLoot.Add(id, null); } GameServer.playerLoot[id] = loot; foreach (RandomLoot l in loot) { ServerSend.OnLootDropped(id, l.id, l.position); } mysql.RemovePlayerLoot(dbid); List <Buff> buffs = mysql.GetPlayerBuffs(dbid); mysql.RemoveBuffs(dbid); List <PlayerBaseStat> playerStats = mysql.ReadPlayerBaseStatsTable(); ThreadManager.ExecuteOnMainThread(() => { LoadBaseStats(); //if (!data.is_on_ship) { playerInstance = Instantiate(playerPrefab, new Vector3(data.X_PLAYER, data.Y_PLAYER, data.Z_PLAYER), Quaternion.identity); playerCharacter = playerInstance.GetComponent <PlayerCharacter>(); playerMovement = playerInstance.GetComponent <PlayerMovement>(); playerCharacter.id = id; playerCharacter.data = data; playerInstance.transform.Find("PlayerSphere").GetComponent <SphereCollider>().radius = NetworkManager.visibilityRadius / 2; playerInstance.transform.eulerAngles = new Vector3(0, data.Y_ROT_PLAYER, 0); playerCharacter.pirate.transform.rotation = Quaternion.Euler(0, data.Y_ROT_PLAYER_CHILD, 0); //enable collider for ship when we have player character playerEnterCollider.enabled = true; playerCharacter.clientPosition = new Vector3(data.X_PLAYER, data.Y_PLAYER, data.Z_PLAYER); playerCharacter.clientRotation = Quaternion.Euler(0, data.Y_ROT_PLAYER, 0); playerCharacter.childRotation = Quaternion.Euler(0, data.Y_ROT_PLAYER_CHILD, 0); if (data.is_on_ship) { playerInstance.SetActive(false); } Inventory inv = this.inventory; foreach (SerializableObjects.InventorySlot slot in inventory) { inv.Add(NetworkManager.SerializableToSlot(slot)); } playerCharacter.stats = playerStats; playerCharacter.Load(); ServerSend.SpawnShip(id, this); ServerSend.OnGameStart(id, stats, playerCharacter.stats, exp, data); ShipEquipment equipment = ship_equipment; foreach (SerializableObjects.Item item in shipEquipment) { equipment.Add(NetworkManager.SerializableToItem(item), null); } foreach (SerializableObjects.Equipment eq in playerEquipment) { playerCharacter.equipment.Add(NetworkManager.SerializableToItem(eq.item), eq.slotType); } // Send the new player to all players foreach (Client _client in GameServer.clients.Values) { if (_client.player != null) { if (_client.player.id != id) { ServerSend.SpawnShip(_client.id, this); } } } // Send all players to the new player foreach (Client _client in GameServer.clients.Values) { if (_client.player != null) { if (_client.id != id) { ServerSend.SpawnShip(id, _client.player); } } } // Send the new player to all players except himself foreach (Client _client in GameServer.clients.Values) { if (_client.player != null) { if (_client.player.id != id) { //ServerSend.SpawnPlayer(_client.id, player); ServerSend.InstantiatePlayerCharacter(_client.id, id, this.playerInstance.transform.position, this.playerInstance.transform.eulerAngles.y); } } } // Send all players to the new player foreach (Client _client in GameServer.clients.Values) { if (_client.player != null) { if (_client.id != id) { /*if(!_client.player.data.is_on_ship) * ServerSend.SpawnPlayer(id, _client.player);*/ ServerSend.InstantiatePlayerCharacter(id, _client.player.id, _client.player.playerInstance.transform.position, _client.player.playerInstance.transform.eulerAngles.y); } } } spawnManager.SendAllGameObjects(id); ServerSend.Recipes(id); //send stats after all is loaded ServerSend.Stats(id); if (data.dead) { playerCharacter.Respawn(); } foreach (RandomLoot l in loot) { StartCoroutine(GameServer.DespawnLoot(id, l, l.remainingTime)); } foreach (Buff b in buffs) { playerCharacter.buffManager.AddBuff(b); } ServerSend.Buffs(id, id); }); //LoadPlayerEquipment(); } catch (Exception ex) { Debug.LogError(ex); } }; Task task = new Task(ac); task.Start(); }
public IEnumerable <Member> ShowInfo(string EmId) { Mysql mysqlGet = new Mysql(); return(mysqlGet.ShowInfoList(EmId)); }
private void Offline_delete() { Mysql sql = new Mysql(); bool rs = sql.Ejecutar("delete from pc where fecha < DATE_SUB(NOW(), INTERVAL " + minutos + " MINUTE)"); }
public async Task <Level> GetAccount(long playerId) { try { Level account = null; if (Constants.UseCacheServer) //Redis as cache server { string _Data = Redis.Players.StringGet(playerId.ToString()).ToString(); if (!string.IsNullOrEmpty(_Data) && _Data.Contains("#:#:#:#")) { string[] _Datas = _Data.Split(new string[1] { "#:#:#:#" }, StringSplitOptions.None); if (!string.IsNullOrEmpty(_Datas[0]) && !string.IsNullOrEmpty(_Datas[1])) { account = new Level(); account.Avatar.LoadFromJSON(_Datas[0]); account.LoadFromJSON(_Datas[1]); } } else { using (Mysql db = new Mysql()) { Player p = await db.Player.FindAsync(playerId); if (p != null) { account = new Level(); account.Avatar.LoadFromJSON(p.Avatar); account.LoadFromJSON(p.GameObjects); Redis.Players.StringSet(playerId.ToString(), p.Avatar + "#:#:#:#" + p.GameObjects, TimeSpan.FromHours(4)); } } ; } } else { using (Mysql db = new Mysql()) { Player p = await db.Player.FindAsync(playerId); if (p != null) { account = new Level(); account.Avatar.LoadFromJSON(p.Avatar); account.LoadFromJSON(p.GameObjects); } } } return(account); } catch (Exception) { return(null); } }
void CheckBarcode(string barcode, int index) { if (barcode != "Error") { try { Mysql mysql = new Mysql(); if (mysql.Connect()) { string stm = "SELECT * FROM BODMSG WHERE SCBODBAR = '" + barcode + "' ORDER BY SIDATE DESC LIMIT 0,5"; DataSet ds = mysql.Select(stm); DataTable dt = ds.Tables["table0"]; if (dt.Rows.Count > 0) { if (dt.Rows[0]["STATUS"] == DBNull.Value) { AddMessage("板 " + barcode + " 状态栏位为空"); switch (index) { case 0: Fx5u.SetM("M2505", true); break; case 1: Fx5u.SetM("M2507", true); break; default: break; } } else { if ((string)dt.Rows[0]["STATUS"] == "OFF") { AddMessage("板 " + barcode + " 是未测板"); switch (index) { case 0: Fx5u.SetM("M2505", true); break; case 1: Fx5u.SetM("M2507", true); break; default: break; } } else { stm = "INSERT INTO BODMSG (SCBODBAR, STATUS) VALUES('" + barcode + "','OFF')"; AddMessage("板 " + barcode + " 解绑"); mysql.executeQuery(stm); stm = "SELECT * FROM BARBIND WHERE SCBODBAR = '" + barcode + "' ORDER BY SIDATE DESC LIMIT 0,96"; ds = mysql.Select(stm); dt = ds.Tables["table0"]; if (dt.Rows.Count == 96) { //string datetimestr = (string)dt.Rows[0]["SIDATE"]; short[] result = new short[96]; bool checkrst = true; for (int i = 0; i < 96; i++) { DataRow[] drs = dt.Select(string.Format("PCSSER = '{0}'", (BordIndex[i]).ToString())); if (drs.Length == 1) { try { result[i] = short.Parse((string)drs[0]["RESULT"]); } catch (Exception ex) { AddMessage(ex.Message); checkrst = false; break; } } else { AddMessage("板 " + barcode + " 序号 " + (BordIndex[i]).ToString() + "索引数 " + drs.Length.ToString()); checkrst = false; break; } } if (checkrst) { string str; switch (index) { case 0: Fx5u.WriteMultD("D1000", result); str = "A_BordInfo;"; for (int i = 0; i < 96; i++) { str += result[i].ToString() + ";"; } str = str.Substring(0, str.Length - 1); AddMessage(str); Fx5u.SetM("M2504", true); break; case 1: Fx5u.WriteMultD("D1100", result); str = "B_BordInfo;"; for (int i = 0; i < 96; i++) { str += result[i].ToString() + ";"; } str = str.Substring(0, str.Length - 1); AddMessage(str); Fx5u.SetM("M2506", true); break; default: break; } } else { switch (index) { case 0: Fx5u.SetM("M2505", true); break; case 1: Fx5u.SetM("M2507", true); break; default: break; } } } else { AddMessage("板 " + barcode + " 产品信息条目 " + dt.Rows.Count.ToString() + " < 96"); switch (index) { case 0: Fx5u.SetM("M2505", true); break; case 1: Fx5u.SetM("M2507", true); break; default: break; } } } } } else { AddMessage("板 " + barcode + " 信息未录入"); switch (index) { case 0: Fx5u.SetM("M2505", true); break; case 1: Fx5u.SetM("M2507", true); break; default: break; } } } else { AddMessage("Mysql数据库查询失败"); switch (index) { case 0: Fx5u.SetM("M2505", true); break; case 1: Fx5u.SetM("M2507", true); break; default: break; } } mysql.DisConnect(); } catch (Exception ex) { AddMessage(ex.Message); } } else { switch (index) { case 0: Fx5u.SetM("M2505", true); break; case 1: Fx5u.SetM("M2507", true); break; default: break; } } }
void mysql_OnError(object sender, Mysql.MysqlConnection.MysqlErrorEventArgs e) { MessageBox.Show(e.getException().Message); }
public override void GetFromDatabase() { string sql = $"SELECT * FROM `temp_products` where `id` = '{ID}'"; CreateFromRow(Mysql.RunQueryWithReturn(sql).RowData[0]); }
async void UpdateUI() { while (true) { await Task.Delay(200); #region 更新界面 if (Fx5u.Connect) { EllipsePLCState.Fill = Brushes.Green; } else { EllipsePLCState.Fill = Brushes.Red; } if (Fx5u_2.Connect) { EllipsePLCState2.Fill = Brushes.Green; } else { EllipsePLCState2.Fill = Brushes.Red; } CycleText.Text = SWms.ToString() + " ms"; #endregion #region 换班 if (LastBanci != GetBanci()) { LastBanci = GetBanci(); Inifile.INIWriteValue(iniParameterPath, "Summary", "LastBanci", LastBanci); LampGreenElapse = 0; Inifile.INIWriteValue(iniParameterPath, "BigData", "LampGreenElapse", LampGreenElapse.ToString()); LampGreenFlickerElapse = 0; Inifile.INIWriteValue(iniParameterPath, "BigData", "LampGreenFlickerElapse", LampGreenFlickerElapse.ToString()); LampYellowElapse = 0; Inifile.INIWriteValue(iniParameterPath, "BigData", "LampYellowElapse", LampYellowElapse.ToString()); LampYellowFlickerElapse = 0; Inifile.INIWriteValue(iniParameterPath, "BigData", "LampYellowFlickerElapse", LampYellowFlickerElapse.ToString()); LampRedElapse = 0; Inifile.INIWriteValue(iniParameterPath, "BigData", "LampRedElapse", LampRedElapse.ToString()); await Task.Run(() => { Mysql mysql = new Mysql(); try { int _result = -999; if (mysql.Connect()) { string stm = string.Format("INSERT INTO HA_F4_LIGHT (PM,LIGHT_ID,MACID,CLASS,LIGHT,SDATE,STIME,ALARM,TIME_1,TIME_2,TIME_3,TIME_4,TIME_5,GROUP1,TRACK,WORKSTATION) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','0','0','0','0','0','{8}','{9}','{10}')" , _PM, _LIGHT_ID, _MACID, GetBanci(), LampColor.ToString(), DateTime.Now.ToString("yyyyMMdd"), DateTime.Now.ToString("HHmmss"), "NA", _GROUP1, _TRACK, _WORKSTATION); _result = mysql.executeQuery(stm); } this.Dispatcher.Invoke(new Action(() => { AddMessage("插入数据库灯信号" + _result.ToString()); })); } catch (Exception ex) { this.Dispatcher.Invoke(new Action(() => { AddMessage(ex.Message); })); } finally { mysql.DisConnect(); } }); Fx5u_2.SetM("M2606", true); CardLockFlag = true; CardLockTime = DateTime.Now; AddMessage("机台锁定!"); AddMessage(LastBanci + " 换班数据清零"); } #endregion } }
async void BigDataRun() { int _LampColor = LampColor; int count1 = 0; LampGreenSw.Start(); bool first = true; while (true) { await Task.Delay(1000);//每秒刷新 #region 报警 if (M300 != null && Fx5u_2.Connect) { for (int i = 0; i < AlarmList.Count; i++) { if (M300[i] != AlarmList[i].State && AlarmList[i].Content != "Null" && (LampGreenSw.Elapsed.TotalMinutes > 3 || first)) { first = false; LampGreenSw.Reset(); AlarmList[i].State = M300[i]; if (AlarmList[i].State) { CurrentAlarm = AlarmList[i].Content; AlarmList[i].Start = DateTime.Now; AlarmList[i].End = DateTime.Now; AddMessage(AlarmList[i].Code + AlarmList[i].Content + "发生"); AlarmAction(i);//等待报警结束 } } } } #endregion #region 灯号更新 switch (LampColor) { case 1: LampGreenElapse += 1; Inifile.INIWriteValue(iniParameterPath, "BigData", "LampGreenElapse", LampGreenElapse.ToString()); break; case 2: LampGreenFlickerElapse += 1; Inifile.INIWriteValue(iniParameterPath, "BigData", "LampGreenFlickerElapse", LampGreenFlickerElapse.ToString()); break; case 3: LampYellowElapse += 1; Inifile.INIWriteValue(iniParameterPath, "BigData", "LampYellowElapse", LampYellowElapse.ToString()); break; case 4: LampYellowFlickerElapse += 1; Inifile.INIWriteValue(iniParameterPath, "BigData", "LampYellowFlickerElapse", LampYellowFlickerElapse.ToString()); break; case 5: LampRedElapse += 1; Inifile.INIWriteValue(iniParameterPath, "BigData", "LampRedElapse", LampRedElapse.ToString()); break; default: break; } count1++; if (_LampColor != LampColor || count1 > 60) { if (LampColor == 1 && _LampColor != LampColor) { LampGreenSw.Restart(); } _LampColor = LampColor; count1 = 0; string result = await Task <string> .Run(() => { try { int _result = -999; Mysql mysql = new Mysql(); if (mysql.Connect()) { string currentAlarm = LampColor == 4 ? CurrentAlarm : "NA"; string stm = string.Format("UPDATE HA_F4_LIGHT SET LIGHT = '{3}',SDATE = '{4}',STIME = '{5}',ALARM = '{6}',TIME_1 = '{8}',TIME_2 = '{9}',TIME_3 = '{10}',TIME_4 = '{11}',TIME_5 = '{12}' WHERE PM = '{0}' AND LIGHT_ID = '{1}' AND MACID = '{2}' AND CLASS = '{7}'" , _PM, _LIGHT_ID, _MACID, LampColor.ToString(), DateTime.Now.ToString("yyyyMMdd"), DateTime.Now.ToString("HHmmss"), currentAlarm, GetBanci(), ((double)LampGreenElapse / 60).ToString("F2"), ((double)LampGreenFlickerElapse / 60).ToString("F2"), ((double)LampYellowElapse / 60).ToString("F2") , ((double)LampYellowFlickerElapse / 60).ToString("F2"), ((double)LampRedElapse / 60).ToString("F2")); _result = mysql.executeQuery(stm); } mysql.DisConnect(); return(_result.ToString()); } catch (Exception ex) { return(ex.Message); } }); //AddMessage("更新灯信号" + result); } if (LampColor != 1) { LampGreenSw.Reset(); } if (LampColor == 1 && LampGreenSw.Elapsed == TimeSpan.Zero) { LampGreenSw.Restart(); } #endregion #region 机台指标 #endregion GreenElapse.Text = LampGreenSw.Elapsed.TotalMinutes.ToString("F1") + " min"; } }
public override void GetFromDatabase() { string getQuery = $"SELECT * FROM `sale_transactions` WHERE `id` = '{_id}'"; CreateFromRow(Mysql.RunQueryWithReturn(getQuery).RowData[0]); }