private static void WCFSendValues(Service.InputCommon input)
{
Service.PairDataParam[] pairs = new Service.PairDataParam[input.ListDataParams.Count];
for (int i = 0; i < input.ListDataParams.Count; i++)
{
pairs[i].ID = input.ListDataParams[i].ID;
pairs[i].Value = input.ListDataParams[i].Value;
}
wcfMain.SetValue(pairs);
}
private static void WriteToBD(Service.InputCommon input)
{
foreach (Service.DataParam param in input.ListDataParams)
{
try {
SQLiteCommand sqlCmd = new SQLiteCommand(dbConn);
sqlCmd.CommandText = "CREATE TABLE IF NOT EXISTS '" + param.Title + "|" + param.ParamUnit.Title + "' (id INTEGER PRIMARY KEY AUTOINCREMENT, value real, dt text, numwork int )";
sqlCmd.ExecuteNonQuery();
sqlCmd.CommandText = "INSERT INTO '" + param.Title + "|" + param.ParamUnit.Title + "' ('value', 'dt', 'numwork') values ('" +
param.Value + "' , '" +
DateTime.Now + "', '" +
NumWork + "')";
sqlCmd.ExecuteNonQuery();
} catch {
}
}
}
public static void SendStart(string titleInput)
{
foreach (SerialPort port in SerialPorts)
{
if (GetInputByCOMPort(port.PortName).Title == titleInput)
{
port.Write("start\r");
Service.InputCommon input = GetInputByCOMPort(port.PortName);
foreach (Service.DataParam param in input.ListDataParams)
{
if (param.ParamType.Title == "Кол-во труб")
{
param.Value = 0;
PipeCounterHelpers[0].Reset();
}
}
WCFSendValues(input);
WriteToBD(input);
}
}
}
