/// <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);
}
}
