/// <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 void AlarmRecord(bool hasTemplet, string alarmType, string alarmInfo) { MySqlConnectionHelp mySqlConnectionHelp = new MySqlConnectionHelp(); MySqlConnection mySqlConnection = mySqlConnectionHelp.GetMySqlCon(); string sql; if (hasTemplet) { if (this.comboBox_selectProduct.SelectedIndex > -1 && this.comboBox_selectProduct.Text != "System.Data.DataRowView") { int templetId; string templetName = ""; bool isNum = int.TryParse(this.comboBox_selectProduct.SelectedValue.ToString(), out templetId); templetName = this.comboBox_selectProduct.Text; if (isNum) { sql = "insert into sp_alarm_info(Templet_ID,Templet_Name,Alarm_Type,Alarm_Info,Alarm_Time,Alarm_Date)" + " values( '" + templetId + "' , '" + templetName + "' ,'" + alarmType + "' ,'" + alarmInfo + "' ,'" + DateTime.Now + "' ,'" + DateTime.Now.Date + "' )"; } else { sql = "insert into sp_alarm_info(Alarm_Type,Alarm_Info,Alarm_Time,Alarm_Date)" + " values( '" + alarmType + "' ,'" + alarmInfo + "' ,'" + DateTime.Now + "' ,'" + DateTime.Now.Date + "' )"; } } else { sql = "insert into sp_alarm_info(Alarm_Type,Alarm_Info,Alarm_Time,Alarm_Date)" + " values( '" + alarmType + "' ,'" + alarmInfo + "' ,'" + DateTime.Now + "' ,'" + DateTime.Now.Date + "' )"; } } else { sql = "insert into sp_alarm_info(Alarm_Type,Alarm_Info,Alarm_Time,Alarm_Date)" + " values( '" + alarmType + "' ,'" + alarmInfo + "' ,'" + DateTime.Now + "' ,'" + DateTime.Now.Date + "' )"; } MySqlCommand mySqlCommand = new MySqlCommand(sql, mySqlConnection); int returnCode_Mysql = mySqlCommand.ExecuteNonQuery();//3.执行插入、删除、更改语句。执行成功返回受影响的数据的 mySqlConnectionHelp.CloseConn(mySqlConnection); if (returnCode_Mysql <= 0) { MessageBox.Show("报警信息保存失败"); return; } }
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); } }
private void btn_Command_Save_Click(object sender, EventArgs e) { try { if (this.TextBox_Init.Text.Trim() == "" || this.TextBox_ErasureAll.Text.Trim() == "" || this.TextBox_Write_Calibration.Text.Trim() == "" || this.TextBox_ErasurePart.Text.Trim() == "" || this.TextBox_Write_User_Procedure.Text.Trim() == "" || this.TextBox_Read_Protect.Text.Trim() == "") { MessageBox.Show("请填写完整"); } else { bool modify_flag = false; string STLlink_EXE_Address = TextBox_STLink.Text.Trim(); //ST-LINK本机安装地址 string Directive_Init = TextBox_Init.Text.Trim(); //初始化指令 string Directive_Erasure_All = TextBox_ErasureAll.Text.Trim(); //全部擦除指令 string Directive_WriteCheckFile = TextBox_Write_Calibration.Text.Trim(); //写入校准程序指令 string Directive_Erasure_Part = TextBox_ErasurePart.Text.Trim(); //部分擦除指令 string Directive_WriteUserFile = TextBox_Write_User_Procedure.Text.Trim(); //写入用户程序指令 string Directive_ReadProtection = TextBox_Read_Protect.Text.Trim(); //读保护指令 MySqlConnectionHelp mySqlConnectionHelp = new MySqlConnectionHelp(); MySqlConnection mySqlConnection = mySqlConnectionHelp.GetMySqlCon(); string sql; //修改 sql = "update tk_command set Command_Info='" + STLlink_EXE_Address + "',Create_Time ='" + DateTime.Now + "' where Command_Name = 'STLlink_EXE_Address' "; MySqlCommand mySqlCommand = new MySqlCommand(sql, mySqlConnection); int returnCode_Mysql = mySqlCommand.ExecuteNonQuery();//3.执行插入、删除、更改语句。执行成功返回受影响的数据的 if (returnCode_Mysql <= 0) { modify_flag = true; } sql = "update tk_command set Command_Info='" + Directive_Init + "',Create_Time ='" + DateTime.Now + "' where Command_Name = 'Directive_Init' "; mySqlCommand = new MySqlCommand(sql, mySqlConnection); returnCode_Mysql = mySqlCommand.ExecuteNonQuery(); //3.执行插入、删除、更改语句。执行成功返回受影响的数据的 if (returnCode_Mysql <= 0) { modify_flag = true; } sql = "update tk_command set Command_Info='" + Directive_Erasure_All + "',Create_Time ='" + DateTime.Now + "' where Command_Name = 'Directive_Erasure_All' "; mySqlCommand = new MySqlCommand(sql, mySqlConnection); returnCode_Mysql = mySqlCommand.ExecuteNonQuery(); //3.执行插入、删除、更改语句。执行成功返回受影响的数据的 if (returnCode_Mysql <= 0) { modify_flag = true; } sql = "update tk_command set Command_Info='" + Directive_WriteCheckFile + "',Create_Time ='" + DateTime.Now + "' where Command_Name = 'Directive_WriteCheckFile' "; mySqlCommand = new MySqlCommand(sql, mySqlConnection); returnCode_Mysql = mySqlCommand.ExecuteNonQuery(); //3.执行插入、删除、更改语句。执行成功返回受影响的数据的 if (returnCode_Mysql <= 0) { modify_flag = true; } sql = "update tk_command set Command_Info='" + Directive_Erasure_Part + "',Create_Time ='" + DateTime.Now + "' where Command_Name = 'Directive_Erasure_Part' "; mySqlCommand = new MySqlCommand(sql, mySqlConnection); returnCode_Mysql = mySqlCommand.ExecuteNonQuery(); //3.执行插入、删除、更改语句。执行成功返回受影响的数据的 if (returnCode_Mysql <= 0) { modify_flag = true; } sql = "update tk_command set Command_Info='" + Directive_WriteUserFile + "',Create_Time ='" + DateTime.Now + "' where Command_Name = 'Directive_WriteUserFile' "; mySqlCommand = new MySqlCommand(sql, mySqlConnection); returnCode_Mysql = mySqlCommand.ExecuteNonQuery(); //3.执行插入、删除、更改语句。执行成功返回受影响的数据的 if (returnCode_Mysql <= 0) { modify_flag = true; } sql = "update tk_command set Command_Info='" + Directive_ReadProtection + "',Create_Time ='" + DateTime.Now + "' where Command_Name = 'Directive_ReadProtection' "; mySqlCommand = new MySqlCommand(sql, mySqlConnection); returnCode_Mysql = mySqlCommand.ExecuteNonQuery(); //3.执行插入、删除、更改语句。执行成功返回受影响的数据的 if (returnCode_Mysql <= 0) { modify_flag = true; } if (modify_flag) { MessageBox.Show("修改失败"); } else { MessageBox.Show("修改成功"); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }