c#計算access的數(shù)據(jù)最大值，最小值，平均值。textBox65.Text == "厭氧系統(tǒng)數(shù)據(jù)")cha1 = "select MIN(厭氧罐液位) from 厭氧系統(tǒng) where 日期時間 BETWEEN ''''''''" + textBox65.Text + "'''''''' and ''''''''" + textBox66.Text + "''''''''";cha2 = "select Avg(厭氧罐液位) from 厭氧系統(tǒng) where 日期時間 BETWEEN ''''''''" + textBox65.Text + "'''''''' and ''''''''" + textBox66.Text + "''''''''";OleDbCommand cmd = new OleDbCommand(cha1, connection);

【告一段落】C#與西門子S7-200smart&s7-1200&s7-1500采集數(shù)據(jù)并做簡單報表。為了實時監(jiān)視餐廚垃圾處理廠的現(xiàn)場三臺PLC（S7-1200,S7-1500,S7-200 smart）數(shù)據(jù)，經(jīng)過幾天的C#編程，現(xiàn)在基本能滿足數(shù)據(jù)監(jiān)視功能。float value1 = ((uint)plc2.Read(textBox53.textBox55.float value2 = ((uint)plc2.Read(textBox54.textBox56.float value3 = ((uint)plc2.Read(textBox57.float value4 = ((uint)plc2.Read(textBox58.

Text == "厭氧系統(tǒng)數(shù)據(jù)")cha1 = "select ID,日期時間,沼氣流量,厭氧罐液位,厭氧罐溫度,沼液罐液位 from 厭氧系統(tǒng) where 日期時間 BETWEEN ''''''''" + start_date + "'''''''' and ''''''''" + textBox66.Text + "''''''''order by 日期時間";DataTable table = new DataTable();

C#采集S7-1500 and S7-1200數(shù)據(jù)顯示及存access數(shù)據(jù)庫。if (this.textBox60.string reg = "insert into 厭氧系統(tǒng)(日期時間,沼氣流量,厭氧罐液位,厭氧罐溫度,沼液罐液位) values(''''''''" + dateString + "'''''''',''''''''" + this.textBox55.Text + "'''''''',''''''''" + this.textBox56.Text + "'''''''',''''''''" + this.textBox59.Text + "'''''''',''''''''" + this.textBox60.Text + "'''''''')";OleDbCommand cmd = new OleDbCommand(reg, connection);

IF (#pump_CM = 1) AND #Pump_remote1 AND #Pump_remote2 THEN.IF ((#pump_auto_no = 0) AND NOT #Pump_faultfk1 AND #auto_S AND NOT #pump_drive2) OR ((#pump_auto_no = 1) AND #Pump_faultfk2) THEN.IF ((#pump_auto_no = 1) AND NOT #Pump_faultfk2 AND #auto_S AND NOT #pump_drive1) OR ((#pump_auto_no = 0) AND #Pump_faultfk1) THEN.IF NOT #Pump_faultfk1 AND (#pump_auto_drive1 OR #pump_man_drive1) THEN.

西門子S7-200smart正反轉(zhuǎn)實現(xiàn)，C#仿真。a = ((bool)plc.b = ((bool)plc.private void btn_正轉(zhuǎn)啟動_Click(object sender, EventArgs e)if (plc.MessageBox.Show("未連接PLC!", "連接提示", MessageBoxButtons.OK);Show("請檢查輸入的“地址”或“值”是否錯誤！" + Ex, "輸入提示", MessageBoxButtons.OK);private void btn_停止_Click(object sender, EventArgs e)private void btn_反轉(zhuǎn)啟動_Click(object sender, EventArgs e)

int intValue = ((byte)plc.string hexValue = intValue.int intValue1 = ((byte)plc.string hexValue1 = intValue1.int intValue2 = ((byte)plc.string hexValue2 = intValue2.int intValue5 = ((byte)plc.string hexValue5 = intValue5.int intValue3 = ((byte)plc.string hexValue3 = intValue3.string hexValue4 = intValue4.

實測c#與S7-1500的數(shù)據(jù)讀取。② 連接西門子S7-1500PLC.plc1 = new Plc(CpuType.S71500, textBox1.plc1.③單次讀取數(shù)據(jù)。首先要建立一個線程xc.private void button3_Click(object sender, EventArgs e)//線程連續(xù)讀取。void dataR()//建立線程執(zhí)行程序。double value = ((uint)plc1.Read(textBox6.double value2 = ((uint)plc1.

C#對access進(jìn)行數(shù)據(jù)寫入。MessageBox.string conf = "select PLC_type from data where PLC_type = ''''''''" + this.txb_data1.//PLC_type.OleDbCommand cmdc = new OleDbCommand(conf, connection);Show("數(shù)據(jù)已存在");if (this.txb_data1.string reg = "insert into data(PLC_type,information) values(''''''''" + this.txb_data1.Text + "'''''''',''''''''" + this.txb_data2.OleDbCommand cmd = new OleDbCommand(reg, connection);

S7-200 Smart讀取溫濕度控制器，測試c#(1)編寫PLC通訊程序。采用的是SB板子，所以調(diào)用的MB_CTRL2.單個地址采集，直接為了方便，采用秒脈沖實現(xiàn)數(shù)據(jù)更新。與PLC連接后，讀取溫度和濕度數(shù)據(jù)。(2)編寫C#程序。//讀取溫濕度。double value1 = ((uint)plc.WD.Text = value1.double value2 = ((uint)plc.SD.Text = value2.其余程序可以參看：有興趣的同志也可以用RS485型溫濕度來測試一下。

C#通過modbus tcp與S7-200 smart通信測試。一、編寫S7-200 Smart的MODBUS TCP SERVER程序段。其中M0.0為使能服務(wù)器通訊，IP_Port為端口，最大輸入輸出為256，最大模擬量為56，寄存器100個（對應(yīng)地址：40001~40099），PLC寄存器從VB0開始。using System;using System.ModbusClient modbusClient = new ModbusClient();modbusClient.IPAddress = txb_IP.Text;// 服務(wù)器IP地址。// 從地址0開始讀取100個保持寄存器的數(shù)據(jù)。測試效果：

C#與OPC鏈接測試。Opc.this.button1_Click(null,null);private void Form1_Load(object sender, EventArgs e)private OPCServer KepServer;private void button1_Click(object sender, EventArgs e)//刷新節(jié)點。private void ServerNode_SelectedIndexChanged(object sender, EventArgs e)if(KepServer==null)KepServer = new OPCServer();Object serverlist=KepServer.private void button2_Click(object sender, EventArgs e)

控制路燈

西門子PLC實現(xiàn)開關(guān)燈時間，C#設(shè)計測試系統(tǒng)。Plc plc;private void Open_PLC_Click(object sender, EventArgs e)plc = new Plc(CpuType.private void Close_PLC_Click(object sender, EventArgs e)int intValue = ((byte)plc.int intValue1 = ((byte)plc.int intValue2 = ((byte)plc.int intValue5 = ((byte)plc.int intValue3 = ((byte)plc.int intValue4 = ((byte)plc.PLC_date.int hour1 = ((byte)plc.int min1 = ((byte)plc.

C#讀寫西門子S7-200smart的M區(qū)及按鈕顏色變化設(shè)置。先在畫面建立兩個按鈕，分別命名為“開始模擬”和“停止模擬”當(dāng)M0.0==1時，將按鈕顏色設(shè)置為綠色（green）；開始模擬.BackColor = Color.Green;停止模擬.BackColor = Color.FromArgb(0xdd2378);開始模擬.BackColor = Color.FromArgb(0xdd2378);停止模擬.BackColor = Color.Red;

C#設(shè)計調(diào)試軟件----西門子S7-200mart.某小系統(tǒng)因未配置觸摸屏和上位機(jī)，方便現(xiàn)場非自控人員調(diào)試，便設(shè)計一個小軟件用于系統(tǒng)調(diào)試。以前有研究和測試過利用C#平臺實現(xiàn)與西門子控制器的通訊：double value = ((uint)plc.plc.plc = new Plc(CpuType.//創(chuàng)建plc實例。IsConnected)//檢查plc是否連接上。Show("與PLC連接成功！");Show("與PLC連接失敗！");安裝完成后，測試軟件。

設(shè)備遷改

水處理脫泥設(shè)備--疊螺機(jī)。初步判斷非電氣故障，應(yīng)為機(jī)械故障，檢查發(fā)現(xiàn)螺旋出泥口堵塞，出口縫隙很小。3-疊螺機(jī)切換到正轉(zhuǎn)，開啟，直到內(nèi)部堵料排空(一般20分鐘左右)，將壓板調(diào)到15cm(出泥口縫隙)左右。5-污泥池濃度高了，泥多水少，就要把疊螺機(jī)的出泥口縫隙放大，變頻器轉(zhuǎn)速調(diào)到30~35HZ處理。6-每天晚上下班前必須要把疊螺機(jī)里面的污泥排空，把污泥泵和加藥泵關(guān)閉，把疊螺機(jī)再開20分鐘排空。