This is a tutorial of showing how to collect data from OPC server which connected to Distributed Control System(DCS) or PLC system. We also provide some reference tutorial to get your hands into Centum DCS. DCS solution is often seen in energy, oil, gas, and chemica industries. The entire DCS solution can provide users to operate and monitor the manufacturing process in a remote office.
- Introduction
- What You See - Human Interface Station (HIS)
- 2.1 Equipment Naming Practice
- 2.2 Interprete Values on the Screen
- 2.2.1 PV, SV, MV
- 2.2.2 AUT, MAN, CAS
- Behind the Scenes - Engineering Station (ENG)
- How We Collect - OPC Data Access
- 4.1 Connect to OPC Steps
- 4.2 Codes
- 4.3 Make Console Application to Service (optional)
- 4.3.1 Convert the App
- 4.3.2 Register and run the service
- 4.4 DCS Alarm
Let's take a quick look of the system structure in the brochure from Yokogawa Centum VP (link,PDF) to know how does DCS embedded in a factory. Yokogawa is an industry well known DCS solution pioneer originated in Japan since 1915. Other well known DCS solution provider such as Siemens, Honeywell, ABB, Rockwell, GE, Mitsubishi.
We will only focus on HIS(Human Interface Station), ENG(Engineering Station) and FCS(Field Control Station) in this tutorial. The following system structure is within this tutorial's scope. You will notice OPC(Open Platform Communications) in the structure which is optional to the whole system and only play the role of exchanging data in the automation devices.
What is the role and relationship between each elements? Let's take a look at following table.
Element | Detail |
---|---|
Field Control Station (FCS) | This is a small computer which can take analog or digital input/output and provide computing power (like our PC take keyboard, mouse as input and output to monitor). The communication between FCS and electronics, transmitter(flow, temperature, pressure), or hardwares (motor, actuator, pump) can be wired or wireless. Each input/output will be mapped to a memory address which is important when developing logic and program on ENG. There are two types of input and output (I/O) functions: Process I/O exchanges data with field devices outside FCS; and software I/O is for virtual data exchange within the FCS. FCS can be far away from the physical equipments and located in remote DCS office.
In a large plant, you might have multiple FCS, each FCS will be assigned with an IPv4 so that HIS, ENG, OPC can reach out to these FCS via network. FCS is comprised of the following components: Field control unit (FCU, like brain, CPU), Node unit (NU, with communication module), ESB bus/Optical ESB bus (wiring between FCU and NU), House Keeping Unit(HKU). |
Human Interface Station (HIS) | DCS or remote office operators can monitor and take action on HIS to control DCS system. It includes some user interface, keyboard, and touchscreen. |
Engineering Station (ENG) | Engineer, technichian, electrician, and developer can use this station to develop logic, program, user interface, chart, and so on. The program should be downloaded to FCS and HIS for functioning. |
Open Platform Communications (OPC) | OPC can be devided into server and client. Server will be the one to communicate with FCS, while client will be the one to ask server to communicate and then receive data in FCS. Client can then process these data. There are multiple vendor (such as Kepware, OPC Expert, Advosol) who can provide OPC server software and corresponding library for development. These vendors should provide industry standard, so the program you developed should be able to run on different OPC server with a little twist. For example, the program I developed on Kepserver (Kepware) to collect data can also run on Yokogawa's EXAOPC server when appyling vendor's library. You can use VB or .NET to develop client program. |
FCS reference: Reference_1_1_1, PDF
The simplify process to build a DCS solution is as following:
- Wire the electronics or hardwares from the field or production line into FCS.
- Use ENG to develop programs and logic and download it to FCS so that FCS can process input and output signal.
- Use ENG to develop user interface(UI) and download it to HIS operator station so that user can interact with DCS.
- Use OPC server to collect FCS data on behalf of client program. The data can be stored in SQL database for later processing.
Let's take a look at what a DCS operator would see on their screen on the HIS. You can see browser bar, graphics, some alarm, silo, piping, valve, pumps, and some values. The graphic (piping and instrument diagram) abstract the production process (process flow diagram), equipments, control function, and process real time value. The user interface program directly asks data from FCS or send command to the FCS therefore monitor and control the production process value. (Reference_2_0_1, PDF)
In a production line, there are large amount of controller, devices and equipments. Usually, we will name each of them into tag name(some alphabet and numbers) which can make the user interface more clean and neat and better management. The nameing convention can be seen in the following (Reference_2_1_1, PDF)
Devices | Alphabetic Abbreviation |
---|---|
Flow Transmitter | FT |
Valve | HV, FV |
Limit Switch | LSL (Low), LSH (High) |
Loop Control | FIC, PIC |
Pushbutton/Switch | HS, HIS |
Photoeye, Proximity Switch | ZS |
Motor Starter | M |
Pressure Transmitter | PT, PIT |
Temperature Indicating Control | TIC |
For example, we have 25 Temperature Indicater on the production line, we therefore name the first one as TIC001, and the second one as TIC002, .... and all the way to TIC025.
We will now explain what shows on the below graphic (see Reference_2_0_1 page 3-7 ~ 3-8)
Instrument Faceplate View (click to view larger image)
Let's first see a simple example. We have an equipment, car(tag name: CAR001). We want to have the car to run at 50 mph (setpoint value, SV) no matter on what kind of surrounding. Car is stop at the begining without break. By pushing the gas pedal 50%, the real time car speed (process variable, PV) will gradually and quickly start from 0 MPH to 50 MPH, then we can mantain the car speed 50 mph on a flat road with gas pedal 30%. However, when the car encounter a hill, the car will become slower (PV will go down probably to 35 mph) if the gas pedal still at 30%. In order for the car to reach the setpoint value(SV, 50 mph) during the uphill, the loop control will take in charge and press more on the gas pedal (probably 60%) so that we can mantain the car speed to 50 mph.
Likewise, on the HIS user interface, you can see tag name represents the equipment. PV indicating the current process variable of the equipment, and the SV indicating the setpoint value from the user. For the car example, the whole tag name for the process variable will become CAR001.PV and the setpoint value will be CAR001.SV. You might also see MV which represent manipulated output value. You can think of MV as the effort for FCS to make PV close to SV, for example 30% or 50% on the gas pedal.
Data Item Name | Detail |
---|---|
Process Variable (PV) | The current measured value of a particular part of a process. |
Setpoint Value (SV) | The desired or target value for an essential variable, or process value of a system. |
Manipulated Output Value (MV) | The results of control computation processing performed by the control blocks are output as manipulated output values. |
These abbrevation indicate control modes (Reference_2_2_1, PDF), (Reference_2_2_2, PDF)
Control Mode | Detail |
---|---|
Manual mode (MAN) | also called "open-loop control" is where the control element (usually a control valve) is controlled by the operator (a human, usually). He manipulates the control valve and hopes that he can maintain the process at the required setpoint. Eventually he gets tired and switches it over to automatic mode. |
Automatic mode (AUT or AUTO) | also called "closed-loop control" is where the control element is controlled by the controller (not a human, definitely). It checks the process, compares it to the setpoint and adjusts the control valve to bring the process back to the setpoint. Controller automatically adjusts its output to try to keep PV = SP. Setpoint value set “locally” by human operator. |
Cascade mode (CAS) | Cascade control is not a mode. It's a control scheme like Feedback, Feedforward, and Ratio control. Cascade control always involves two controllers each measuring separate but inter-related processes. One controller is the master and the other is the slave. The master provides the setpoint being used by the slave. Controller automatically adjusts its output to try to keep PV = SP. Setpoint value set “remotely” by primary (master) controller. |
We will discuss the technical side and design logic of the DCS in this section. (Reference_3_0_1)
Please go the the following Youtube link: Introduction to FCS Programming with 'Plant in a Box' (1hr) to learn the basic usage of user interface and how to abstract the production process into HIS windows graphic. The following link is the screenshot of the video of each step: Video Screenshot folder.
Take a look at the following project design level against the physical hardware level.
Under a project, you can have multiple FCS and multiple HIS based on your existed DCS structure and design. Under a FCS, you can have multiple but limited Node. Under a Node, you can have multiple but limited I/O Module (input/output).
In the following image, you can see the folder tree which represents the hierarchy of the project and its components.
You can have multiple project folders under system view (red line). Under each project (blue line), you can have multiple FCS and HIS. Under each FCS (green line), you can see IOM folder and FUNCTION_BLOCK folder. Under IOM folder, you can have multiple Node, and each node can contain multiple but limited quantity I/O Module (Analog, Digital, Analog/Digital). Each I/O module contains multiple terminal (physically call channel). There are limited items under FUNCTION_BLOCK folder. In each HIS folder, there is a WINDOW folder, and there are multiple Graphic and Trend folders in the WINDOW folder.Input/Output (I/O) and communication modules are mounted on Node unit (NU). And NU transmits those module data to FCS. Some module can handle analog I/O, some can hanle digital I/O, while some can handle both analog and digital I/O. Please refer to Reference_1_1_1 page 2-9 to see different model of module and their capability. Different node unit can hold different limited amount of I/O module.
Let's say we have a model AAB841 I/O module (Reference_1_1_1 page 2-9). It is an analog I/O module with 8 channel input and 8 channel output, 1 to 5 V Input, 4 to 20 mA Output. When you add the node module model in the FCS, you will be able to see the terminals (channel) of the I/O module by double click on the node I/O module (shown in the following imgae), 8 terminal for input and the other 8 for output. You can use the Terminal number (such as %Z033101) in function blocks.
For tag name and label, the setting items may vary, depending on Type. For analog I/O, only user-defined label can be set. Tag name cannot be set. For digital I/O, tag name or user-defined label can be set.
You can find common switches and global switch when you click on SWITCH folder.
Switch | Detail |
---|---|
Common switches | Common switches are internal switches used by various control functions for holding the share logical values in an FCS. The logical value of a common switch cannot be directly output to the I/O interface but can be used by various control functions in an FCS for testing conditions and reflecting status. |
Global switch | Global switch is an internal switch with the same logical value on all stations in the same domain. |
Message Output | Detail |
---|---|
Annunciator Message Output | When the alarm occurrence status changes, the annunciator message informs the HIS of the occurrence or recovery of the message. When an alarm occurs, the alarm symbol will flash to prompt the operator for acknowledgment. The alarm symbol will stop flashing once it has been acknowledged. |
Operator Guide Message | It alert the operator to the operator guide view in real-time situations. Messages can be triggered by a sequence table, timer, or counter. |
Printout Message | They are triggered by the sequence control function to printout the message to indicate certain timing of the process. |
Function block is a big topic, so we will talk about it in section 3.4.
By performing the I/O connection, data can be exchanged between a function block and the connection destination according to the connection method.
Connection Destination
Connection Destination | Detail |
---|---|
Process I/O | Analog I/O, Contact I/O |
Software I/O | Internal switch (common switch), Message output |
Communication I/O and Expanded Communication I/O | Word data, Bit data |
Fieldbus I/O | Parameter of fieldbus block. |
Other Function Blocks | Data items of other function blocks, I/O terminals of other function blocks |
Connection Methods
Connection Methods | Detail |
---|---|
Data Connection | This is the I/O connection method used for reading and setting data with respect to the process I/O, software I/O, communication I/O and expanded communication I/O, fieldbus I/O or other function blocks. It is used when exchanging data values and data status between a function block and the data item of the element specified as the connection destination. Data reference: reading data from the connection destination of the function block’s input terminal. Data setting: writing data into the connection destination from the function block's output terminal. |
Terminal Connection | This is the I/O connection method used when connecting between cascade control function blocks or connecting function blocks via a selector switch block. Data is exchanged between the terminals of two function blocks. |
Sequence Connection | This is the I/O connection method used for testing whether or not the connection destination data used by the sequence control satisfies the conditional expression, or for changing block mode, alarm status, data, etc. of the connection destination. |
Main data itmes are as follows: Block mode, Block status, Alarm status, Data status, Process variable (PV), Setpoint value(SV), Manipulated output value (MV). We will explain the first four item while the rest have been explained in section 2.2.
Data Item | Detail |
---|---|
Block mode (MODE) | It is the information that represents the control state and the output state of a function block. The different types of function blocks have different kinds of operation mode. In general there are 9 kinds of basic block mode, and some other block modes that are the composition of those basic block modes. |
Block status (BSTS) | Block status is the information that represents the operating state of a function block. Block status and block mode simultaneously reflect an overall operation state of a function block. The different type of function blocks have different kinds of block status. Some function blocks do not have any block status. A function block may check itself and display the result via block status. The block status is categorized by priority levels. Example of block status for Timer Block (TM) are as follows: PAUS, PALM, CTUP, NR, RUN and STOP. |
Alarm status (ALRM) | The process alarm may be monitored and managed via alarm statuses of data items. Some function blocks do not have any alarm status. When multiple alarms are occurring, the alarm status with the highest alarm display priority will be displayed. The alarm status is NR if no alarm occurs. The other alarm status and their priority are as following: IOP > IOP- > HH > LL > HI > LO > VEL+ > VEL- > CNF > CERR |
Data status | A data status is the information that represents the reliability of data. For the data obtained from I/O module, their status pass from one function block to another. Data status is observed when various exceptional events occurred due to abnormality in the process or calculation. Status such as BAD (normal data cannot be obtained), QST (data cannot be determined whether normal or bad) |
Processing Functions | Detail |
---|---|
Input Processing | It changes an input signal read from the input terminal of the function block into data that is suitable for calculation processing. Various types of input processing are performed according to the type of the function block and the input signal format. |
Calculation Processing | It reads data obtained by input processing, performs calculation processing according to the type of the function block, and outputs the processing result. |
Output Processing | It outputs data obtained by calculation processing to the connection destination of the output terminal as an output signal. Various types of output processing are performed according to the type of the function block and the output signal format. |
Alarm Processing | It performs various types of alarm check during input processing, calculation processing and output processing in order to detect a process error.When an error is detected, the alarm processing reflects the detection of an alarm in the “alarm status” that is one of the data items of the function block, and also notifies a message indicating the detection result to the operation and monitoring. |
More detail content will be showed in section 3.4
The input signal conversion is the function that converts the input signal read from the input module or other function blocks into process variable (PV) or calculated input value (RV) according to the signal type.
Function Block | Type of Input Signal Conversion |
---|---|
Regulatory Control Blocks and Calculation Blocks | •No Conversion •Square Root •Pulse-train/ Control Priority Type Pulse Train Input/ Exact Totalization Pulse Train Input •Communications |
Logic Operation Blocks | •Bitwise Logic Operation Blocks, Logic Operation Blocks other than Relational Operation Blocks •Bitwise Logic Operation Blocks •Relational Operation Blocks |
Motor Control Blocks (MC-2, MC-2E, MC-3, and MC-3E) | •Feedback Input Signal Conversion •Answerback Input Signal Conversion •Feedback Input to Answerback Input Conversion |
Weight-Totalizing Batch Set Block (BSETU-3) | •Weight Measurement Conversion •SUM Conversion •ΔSUM Conversion |
Pulse Count Input Block (PTC) | Input Signal Conversion for PTC Block |
The digital filter is a function to remove the noises from process input signals. The following is the computational expression for the digital filter:
OPC server will be the one to ask data from each FCS on behalf of us. We will now explain how to write program as OPC client to ask OPC server to retrieve data. (Link, Reference_4_0_1), (Link, Reference_4_0_2)
The following is the core steps to communicate with OPC server. You can wrape it inside your program logic. For example, you can first connect to your SQL database to know whatever tag names need to be asked. After asking OPC server and retrieved data, identify the quality of the data, and then insert these data into SQL database.
Create a C# Console Application. Make sure you have the dynamic library which vendor provided to you to access OPC server function. Then, you need to add the library to your program reference.
using OPCAutomation;
//string Connect_str = "Data Source = 172.17.216.5; Initial Catalog=DatabaseName; UID=sa; pwd=some_password; Timeout=10";
//string query_str = "SELECT * FROM TABLE_NAME WHERE 1=1 AND ...."
static void OPC_Collect_Function(string Connect_str, string query_str, string insert_str)
{
string[] TagWholeName = new string[1000];
int[] TagCHandles = new int[1000];
DataTable ReadTagNameTable = new DataTable();
ReadTagNameTable = ReadTagName_IP_String(Connect_str, query_str);
int NumItem = ReadTagNameTable.Rows.Count;
if (NumItem > 0 && NumItem < 1000)
{
for (int j = 1; j <= NumItem; j++)
{
TagWholeName[j] = ReadTagNameTable.Rows[j - 1]["TagName"].ToString();
TagCHandles[j] = j;
}
}
else
{
return;
}
OPCServer _OPCServer = new OPCServer();
_OPCServer.Connect(KEPServerVersion, KEPServerIP);
_OPCServer.Logon("enguser", "");
OPCGroups groups;
OPCGroup group;
OPCItems items;
OPCItem item;
Array strItemIDs;
Array lClientHandles;
Array lserverhandles;
Array lErrors;
object RequestedDataTypes = null;
object AccessPaths = null;
groups = _OPCServer.OPCGroups;
groups.DefaultGroupIsActive = true; //Set the group collection to be active by default
groups.DefaultGroupDeadband = 0; //Set dead zone
groups.DefaultGroupUpdateRate = 200;//Set the update frequency
group = groups.Add(null);
group.IsActive = true;
//group.IsSubscribed = true; //subscribe
group.UpdateRate = 200; //Update refresh frequency
_OPCServer.OPCGroups.DefaultGroupDeadband = 0;
group.DataChange += new DIOPCGroupEvent_DataChangeEventHandler(KepGroup_DataChange);
items = group.OPCItems;
strItemIDs = (Array)TagWholeName;
lClientHandles = (Array)TagCHandles;
items.AddItems(NumItem, ref strItemIDs, ref lClientHandles, out lserverhandles, out lErrors, RequestedDataTypes, AccessPaths);
object qualities = new object(); //opc server will store the quality of the item
object timestamps = new object(); //store the timestamp of the read
Array values; //opc server will store the values in this array
Array errors; //opc server will store any errors in this array
//read directly from device
group.SyncRead((short)OPCDataSource.OPCDevice, NumItem, ref lserverhandles, out values, out errors, out qualities, out timestamps);
Array qualities_array = (Array)qualities;
int insert_result = InsertData_IP_String(ReadTagNameTable, values, qualities_array, Connect_str, insert_str);
groups.RemoveAll();
_OPCServer.Disconnect();
}
Noticed that we only allowed 1000 tag names because we only assign an array to hold 1000 value. You also need to make sure your OPC server allows 1000 data query once. You can also see in the first for loop, we shift the whole table by one row.
Also notice that the OPC server requires credential to be applied, so there is logon
method in OPCServer object. Other vendor's OPC dll library might not provide this logon method.
Functions: Connect to database and retrieve tag name information
using System.Data.SqlClient;
static DataTable ReadTagName_IP_String(string Connect_str, string Select_str)
{
DataTable tempTable = new DataTable();
string querystring = Select_str;
try
{
using (SqlConnection Myconn2 = new SqlConnection(Connect_str))
using (SqlCommand Mycomm2 = new SqlCommand(querystring, Myconn2))
{
Myconn2.Open();
//Mycomm2.Parameters.Add("@CNO", CNO);
SqlDataAdapter MyAd2 = new SqlDataAdapter();
MyAd2.SelectCommand = Mycomm2;
MyAd2.Fill(tempTable);
}
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
return tempTable;
}
Functions: Insert to database with retrieved tag name data
using System.Data.SqlClient;
static int InsertData_IP_String(DataTable dt, Array values, Array Quality, string Connect_str, string insert_str)
{
string insertstring = insert_str;
string currentTime = DateTime.Now.ToString("yyyyMMddHHmmss");
Int16 Code;
Int16 Quality_Good_Code = 190;
Int16 Quality_Uncertain_Code = 64;
using (SqlConnection Myconn2 = new SqlConnection(Connect_str))
using (SqlCommand Mycomm2 = new SqlCommand(insertstring, Myconn2))
{
try
{
Myconn2.Open();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (Int16.TryParse(Quality.GetValue(i + 1).ToString(), out Code))
{
if (Code > Quality_Good_Code)
{
Mycomm2.Parameters.Clear();
Mycomm2.Parameters.AddWithValue("@tagname", dt.Rows[i]["TagName"].ToString());
Mycomm2.Parameters.AddWithValue("@tagvalue", values.GetValue(i + 1).ToString());
Mycomm2.Parameters.AddWithValue("@tagtime", currentTime);
Mycomm2.ExecuteNonQuery();
string success_string_log = string.Format("TagName: {0} , value: {1} insert successful", dt.Rows[i]["TagName"].ToString(), values.GetValue(i + 1).ToString());
Console.WriteLine(success_string_log);
log_string_file(success_string_log);
}
else if (Code >= Quality_Uncertain_Code)
{
Mycomm2.Parameters.Clear();
Mycomm2.Parameters.AddWithValue("@tagname", dt.Rows[i]["TagName"].ToString());
Mycomm2.Parameters.AddWithValue("@tagvalue", values.GetValue(i + 1).ToString());
Mycomm2.Parameters.AddWithValue("@tagtime", currentTime);
Mycomm2.ExecuteNonQuery();
string success_string_log = string.Format("TagName: {0} , value: {1} insert successful. Quality is Uncertain. Quality Code: {2}", dt.Rows[i]["TagName"].ToString(), values.GetValue(i + 1).ToString(), Code.ToString());
Console.WriteLine(success_string_log);
}
else
{
string tagvalue = " ";
if (values.GetValue(i + 1) != null)
{
tagvalue = values.GetValue(i + 1).ToString();
Mycomm2.Parameters.Clear();
Mycomm2.Parameters.AddWithValue("@tagname", new_tagname);
Mycomm2.Parameters.AddWithValue("@tagvalue", values.GetValue(i + 1).ToString());
Mycomm2.Parameters.AddWithValue("@tagtime", currentTime);
Mycomm2.ExecuteNonQuery();
}
string error_string_log = string.Format("TagName: {0} Quality is bad, read value: {2}. Quality Code: {1} >>>>>>>", dt.Rows[i]["TagName"].ToString(), Code.ToString(), tagvalue);
Console.WriteLine(error_string_log);
log_string_file(error_string_log);
}
}
else
{
string error_quality_string_log = string.Format("TagName: {0} Cannot get Quality, skip this value", dt.Rows[i]["TagName"].ToString());
Console.WriteLine(error_quality_string_log);
}
}
Myconn2.Close();
return 0;
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
return 1;
}
}
}
You will se quality code in the above code. The quality of a given OPC tag is used to represent the validity of the tag's value (in other words, whether or not an OPC client can trust the data). OPC quality is divided into three main categories: Good (generally indicates the data is valid), Bad (generally indicates the data is not valid), or Uncertain (generally indicates the data is speculative in some manner). Each category is further divided into sub-categories; the exact criteria for using a particular sub-category may vary depending on the end protocol and vendor (link, Reference_4_2_1)
Function
static void KepGroup_DataChange(int TransactionID, int NumItems, ref Array ClientHandles, ref Array ItemValues, ref Array Qualities, ref Array TimeStamps)
{
for (int i = 1; i < NumItems + 1; i++)
{
if (Convert.ToInt32(ClientHandles.GetValue(i)) == i)
{
if (ItemValues.GetValue(i) != null)
{
Console.WriteLine(ItemValues.GetValue(i).ToString());
}
}
}
}
Function
static void KepGroup_DataChange(int TransactionID, int NumItems, ref Array ClientHandles, ref Array ItemValues, ref Array Qualities, ref Array TimeStamps)
{
for (int i = 1; i < NumItems + 1; i++)
{
if (Convert.ToInt32(ClientHandles.GetValue(i)) == i)
{
if (ItemValues.GetValue(i) != null)
{
Console.WriteLine(ItemValues.GetValue(i).ToString());
}
}
}
}
This step is optional. (Link, Reference_4_3_1)
First step, right click on the console application solution, add new item, select Windows Service.
Second step, right click on the new create Service1.cs
view code.
using System.ServiceProcess;
using System.Threading;
namespace Your_Solution_Name
{
public partial class Your_Service_Name : ServiceBase
{
readonly Program _application = new Program();
static void Main()
{
ServiceBase[] servicesToRun = { new Your_Service_Name() };
Run(servicesToRun);
}
public Your_Service_Name()
{
InitializeComponent();
}
protected override void OnStart(string[] args)
{
Thread thread = new Thread(() => _application.Start());
thread.Start();
}
protected override void OnStop()
{
Thread thread = new Thread(() => _application.Stop());
thread.Start();
}
}
}
Then you should slightly modify the console application program Program.cs
. The original public void Main(arg[])
should change to other name so that it will not conflict with the Main function we created in Service.cs file. There is only one Main function can stay in a program. So we change the original Main() to Main_APP() in Program.cs
.
static void Main_APP(){
//connect to database
.....
//connect to OPC server and disconnect
.....
//insert into database
......
}
public void Start()
{
Main_APP();
}
public void Stop()
{
Environment.Exit(1); //console app
}
Double click on the Service1.cs, right click on Service1.cs designer page, click on Add Installer
, then a ProjectInstaller.cs will be created. You can click on the ProjectInstaller.cs Design page and click on serviceInstaller1
icon and try to add some detail in the Properties such as service display name, service description. These information will be display when you install this service to Windows Services. In the serviceProcessInstaller1
(also in ProjectInstaller.cs Design page), you can change the Account type (LocalSystem, LocalService, NetworkService, User) in Misc. Rebuild the solution.
Place the solution folder in C drive (contain program solution as well)
From the Start menu, select the Visual Studio directory, then select Developer Command Prompt for VS and run as Administrator
Key in
installutil C:\Solution_Folder\Solution_Name\bin\Debug\Solution_Name.exe
and press enter. You should see
The Commit phase completed successfully. The transacted install has completed
Finally, go to Services. Right click on Service Name you created in the the solution, click “Start”.
You can use some parsing program to read from the following alarm history in the following location