public int Insert(ClientIpInfoModel model)
{
string sql = "INSERT INTO client_ipinfo (NAME,CODE,ip,PORT,timeouts,STATUS) VALUES ('{0}','{1}','{2}','{3}',{4},1) ";
sql = string.Format(sql, model.Name, model.Code, model.IP, model.Port, model.Timeouts);
int o = MySqlHelper.ExecuteNonQuery(sql);
return(o);
}
private void Form1_Load(object sender, EventArgs e)
{
RobotInfo.DeviceCode = ConfigurationManager.AppSettings["devicecode"];
List <ClientIpInfoModel> list = new List <ClientIpInfoModel>();
DataTable dt = new ClientInfoDal().GetDS();
if (dt != null && dt.Rows.Count > 0)
{
int width = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
ClientIpInfoModel model = new ClientIpInfoModel();
model.Id = Convert.ToInt32(dt.Rows[i]["id"].ToString());
model.Code = dt.Rows[i]["code"].ToString();
model.Name = dt.Rows[i]["name"].ToString();
model.IP = dt.Rows[i]["ip"].ToString();
model.Port = dt.Rows[i]["port"].ToString();
model.Timeouts = Convert.ToInt32(dt.Rows[i]["timeouts"].ToString());
model.Status = Convert.ToInt32(dt.Rows[i]["status"].ToString());
list.Add(model);
PCUserControl pc = new PCUserControl();
pc.LabelText(model.Name);
pc.Location = new Point(width, 0);
width = width + pc.Width;
panelPC.Controls.Add(pc);
}
}
AppInfo.ClientInfoList = list;
//串口打开
try
{
if (!serialPort1.IsOpen)
{
serialPort1.Open();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "错误提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
public int Update(ClientIpInfoModel model)
{
string sql = @"UPDATE client_ipinfo
set
NAME='{0}',
CODE='{1}',
ip='{2}',
PORT='{3}',
timeouts={4},
STATUS={5}
WHERE id=" + model.Id;
sql = string.Format(sql, model.Name, model.Code, model.IP, model.Port, model.Timeouts, model.Status);
int o = MySqlHelper.ExecuteNonQuery(sql);
return(o);
}
private void btnSure_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(tbIpName.Text.Trim()))
{
MessageBox.Show("设备名称不能为空");
return;
}
if (string.IsNullOrEmpty(tbCode.Text.Trim()))
{
MessageBox.Show("设备代号不能为空");
return;
}
if (string.IsNullOrEmpty(tbIp.Text.Trim()))
{
MessageBox.Show("设备IP不能为空");
return;
}
if (string.IsNullOrEmpty(tbIpPort.Text.Trim()))
{
MessageBox.Show("设备端口不能为空");
return;
}
if (string.IsNullOrEmpty(tbIpTimoOut.Text.Trim()))
{
MessageBox.Show("超时时间不能为空");
return;
}
int timeout = 0;
try
{
timeout = Convert.ToInt16(tbIpTimoOut.Text.Trim());
if (timeout < 0)
{
MessageBox.Show("超时时间不能小于0");
return;
}
}
catch (Exception ex)
{
MessageBox.Show("超时时间请输入数字");
return;
}
ClientIpInfoModel model = new ClientIpInfoModel();
if (rb0.Checked)
{
model.Status = 0;
}
else
{
model.Status = 1;
}
model.Id = id;
model.Name = tbIpName.Text.Trim();
model.Code = tbCode.Text.Trim();
model.IP = tbIp.Text.Trim();
model.Port = tbIpPort.Text.Trim();
model.Timeouts = timeout;
new ClientInfoDal().Update(model);
this.DialogResult = DialogResult.OK;
}
catch (Exception ex)
{
MessageBox.Show("出现异常:" + ex.Message);
}
}
private void Form1_Load(object sender, EventArgs e)
{
//当前设备编码
RobotInfo.DeviceCode = ConfigurationManager.AppSettings["devicecode"];
this.Text = this.Text + RobotInfo.DeviceCode;//当前编码
SystemInfo.ClientInfoList = new List <ClientInfo>();
SystemInfo.clientRequestCQ = new ConcurrentQueue <ClientRquestInfo>();
List <ClientIpInfoModel> list = new List <ClientIpInfoModel>();
DataTable dt = new ClientInfoDal().GetDS();
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ClientIpInfoModel model = new ClientIpInfoModel();
model.Id = Convert.ToInt32(dt.Rows[i]["id"].ToString());
model.Code = dt.Rows[i]["code"].ToString();
model.Name = dt.Rows[i]["name"].ToString();
model.IP = dt.Rows[i]["ip"].ToString();
model.Port = dt.Rows[i]["port"].ToString();
model.Timeouts = Convert.ToInt32(dt.Rows[i]["timeouts"].ToString());
model.Status = Convert.ToInt32(dt.Rows[i]["status"].ToString());
list.Add(model);
ClientInfo info = new ClientInfo();
info.Code = dt.Rows[i]["code"].ToString();
info.Name = dt.Rows[i]["name"].ToString();
info.Ip = dt.Rows[i]["ip"].ToString();
SystemInfo.ClientInfoList.Add(info);
}
}
AppInfo.ClientInfoList = list;
LoadFctPos();
LoadIOPos();
SystemInfo.FctPosList = fctPosList;
SystemInfo.IoInfoList = ioInfoList;
try
{
button1_Click(null, null);
}
catch (Exception ex)
{
LogHelper.Log("服务端启动失败" + ex.Message);
MessageBox.Show("服务端启动失败" + ex.Message);
return;
}
u1 = new UcFlow();
tabPage5.Controls.Add(u1);
ioCard = RobotApp.IoCard;
homeControl = new HomeControl();
homeControl.Dock = DockStyle.Fill;
panel2.Controls.Add(homeControl);
TaskContinue.Start(delegate
{
if (!RobotApp.BRun)
{
return(false);
}
bool b = true;
if (bRefresh)
{
b = ioCard.RefreshDI();
}
return(b);
}, 100, "IoCard");
u1.ConsoleMsgEvent += u1_ConsoleMsgEvent;
u1.SendMessageEvent += u1_SendMessageEvent;
u1.RobotStatusEvent += u1_RobotStatusEvent;
homeControl.SendMessageEvent += u1_SendMessageEvent;
Task.Factory.StartNew(() => {
WriteLog();
});
//日志处理
}