using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Configuration;
using OPCAutomation;
using MySql.Data;
using MySql.Data.MySqlClient;
using System.Data;
using System.Threading;
using System.Threading.Tasks;
namespace tyDoorOpcSync
{
class Program
{
static void Main(string[] args)
{
OPCServer opcServer = new OPCServer();
OPCGroups opcGroups;
OPCGroup opcGroup;
OPCItems opcItems;
OPCItem DoorDesc,DoorOnOff,DoorAlarm,ReaderDesc,ReaderCard;
Object DoorDescValue, DoorOnOffValue, DoorAlarmValue, ReaderDescValue, ReaderCardValue;
Object DoorDescQty, DoorOnOffQty, DoorAlarmQty, ReaderDescQty, ReaderCardQty;
Object DoorDescTime, DoorOnOffTime, DoorAlarmTime, ReaderDescTime, ReaderCardTime;
opcServer.Connect("************");
Console.WriteLine(DateTime.Now.ToLocalTime().ToString() + ":OPC Server已经连接!");
opcGroups = opcServer.OPCGroups;
opcGroup = opcGroups.Add("tyDR");
opcItems = opcGroup.OPCItems;
while (true)
{
string connStr = ConfigurationManager.AppSettings["ConnectionString"];
MySqlConnection mycon = new MySqlConnection(connStr);
mycon.Open();
string sql = "select * from *******";
MySqlCommand cmd = new MySqlCommand(sql, mycon);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
DoorDesc = opcGroup.OPCItems.AddItem(Convert.ToString(reader["#"]), 0);
DoorOnOff = opcGroup.OPCItems.AddItem(Convert.ToString(reader["#"]), 0);
DoorAlarm = opcGroup.OPCItems.AddItem(Convert.ToString(reader["#"]), 0);
ReaderDesc = opcGroup.OPCItems.AddItem(Convert.ToString(reader["#"]), 0);
ReaderCard = opcGroup.OPCItems.AddItem(Convert.ToString(reader["#"]), 0
C# 关于OPC数据处理相关代码优化处理
最新推荐文章于 2021-03-23 09:43:40 发布