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); } } }