/// <summary> /// easymodbus连接PLC /// </summary> /// <returns></returns> //private bool ModbusConnect() //{ // try // { // string ip = "192.168.10.7"; // PLC_ModbusClient = new ModbusClient(ip, 502); // PLC_ModbusClient.Connect(); // if (PLC_ModbusClient.Connected) // { // return true; // } // else // { // return false; // } // } // catch (Exception ex) // { // // return false; // } //} private DataTable GetHomingAxisInfoByAxisID(int axisID) { DataTable DT_Temp = new DataTable(); MySqlConnectionHelp mySqlConnectionHelp = new MySqlConnectionHelp(); MySqlConnection mySqlConnection = mySqlConnectionHelp.GetMySqlCon(); string sql = "select * from sp_axis_homing_info where Axis_ID = " + axisID; MySqlCommand mySqlCommand = new MySqlCommand(sql, mySqlConnection); DT_Temp = mySqlConnectionHelp.GetDataSet(mySqlCommand).Tables[0]; mySqlConnectionHelp.CloseConn(mySqlConnection); return(DT_Temp); }
private DataTable GetHomingAxisInfoByAxisID() { try { DataTable DT_Temp = new DataTable(); MySqlConnectionHelp mySqlConnectionHelp = new MySqlConnectionHelp(); MySqlConnection mySqlConnection = mySqlConnectionHelp.GetMySqlCon(); string sql = " select * from sp_axis_homing_info "; MySqlCommand mySqlCommand = new MySqlCommand(sql, mySqlConnection); DT_Temp = mySqlConnectionHelp.GetDataSet(mySqlCommand).Tables[0]; mySqlConnectionHelp.CloseConn(mySqlConnection); return(DT_Temp); } catch (Exception ex) { MessageBox.Show(ex.Message); return(null); } }
private int GetTempletIDByTempletName(string templetName) { try { DataTable dataTable = new DataTable(); MySqlConnectionHelp mySqlConnectionHelp = new MySqlConnectionHelp(); MySqlConnection mySqlConnection = mySqlConnectionHelp.GetMySqlCon(); string sql = "select * from sp_templet_info where Templet_Name = '" + templetName + "'"; MySqlCommand mySqlCommand = new MySqlCommand(sql, mySqlConnection); dataTable = mySqlConnectionHelp.GetDataSet(mySqlCommand).Tables[0]; mySqlConnectionHelp.CloseConn(mySqlConnection); return((int)dataTable.Rows[0]["Templet_ID"]); } catch (Exception ex) { MessageBox.Show(ex.Message); return(0); } }
//检查数据库连接异常 private bool CheackDBLink() { try { MySqlConnectionHelp mySqlConnectionHelp = new MySqlConnectionHelp(); MySqlConnection mySqlConnection = mySqlConnectionHelp.GetMySqlCon(); DataTable dt = new DataTable(); string sql = "select * from tk_plc"; MySqlCommand mySqlCommand = new MySqlCommand(sql, mySqlConnection); dt = mySqlConnectionHelp.GetDataSet(mySqlCommand).Tables[0]; MainForm.PLC_IP = dt.Rows[0]["PLC_IP"].ToString(); mySqlConnectionHelp.CloseConn(mySqlConnection); return(true); } catch (Exception ex) { this.richTextBox_Load.AppendText(DateTime.Now + " " + ex.Message + "\n"); return(false); } }