private void LoadSettlementConfig(SqlConnection connection)
{
string sqlStatement = "select SensorId,RefPoint,InitValue,Description from SettlementConfig";
SqlCommand command = new SqlCommand(sqlStatement, connection);
using (SqlDataReader reader = command.ExecuteReader())
{
Dictionary <string, SettlementConfig> configCollection = new Dictionary <string, SettlementConfig>();
while (reader.Read())
{
string sensorId = reader.GetString(0);
string ref1 = reader.GetString(1);
double init = reader.GetDouble(2);
string desc = reader.GetString(3);
SettlementConfig ssv = new SettlementConfig(sensorId, init, ref1);
configCollection.Add(sensorId, ssv);
string[] viewItem = { sensorId, sensorId, desc.ToString() };
ListViewItem listItem = new ListViewItem(viewItem);
this.listView1.Items.Add(listItem);
}
SettlementSolve actSolver = new SettlementSolve(configCollection, 300, redis, redisDbIndex, textBoxLog, dataQueue);
solverCollection.Add(actSolver);
}
}
private void BackgroundWorker_DoWork(object sender, DoWorkEventArgs e)
{
BackgroundWorker bgWorker = sender as BackgroundWorker;
string stamp = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string str = "";
str += stamp + " ";
if (redis.IsConnected)
{
}
else
{
str += "redis server is not connected";
//lthis.AppendLog(str);
return;
}
Dictionary <RedisKey, RedisValue> pair = new Dictionary <RedisKey, RedisValue>();
try
{
IDatabase db_raw = this.redis.GetDatabase(0);
IDatabase db_result = this.redis.GetDatabase(redisDbIndex);
List <RedisKey> keyCollection = new List <RedisKey>();
foreach (string k in list.Keys)
{
keyCollection.Add(k);
//keyCollection.Add(k + "-020");
}
RedisKey[] keys = keyCollection.ToArray();
RedisValue[] vals = db_raw.StringGet(keys);
foreach (RedisValue rv in vals)
{
if (!rv.IsNull)
{
BGK3475DM_Data dv = JsonConvert.DeserializeObject <BGK3475DM_Data>((string)rv);
string inageKey = dv.SensorId;
SettlementConfig ptv = list[inageKey];
if (ptv.Stamp != dv.TimeStamp)
{
ptv.IsUpdated = true;
ptv.Value = dv.Innage;
ptv.Stamp = dv.TimeStamp;
}
}
}
foreach (string key in list.Keys)
{
SettlementConfig ptv = list[key];
if (ptv.IsUpdated == false)
{
//this.AppendLog(stamp + " " + key + "is not updated");
continue;
}
str += "InitValue: " + ptv.InitValue.ToString() + "\r\n";
str += ptv.SensorId + " " + ptv.Stamp + " " + "020" + " " + ptv.Value + "\r\n";
string offsetKey = ptv.SensorId + "-007";
double offset = Math.Round(ptv.Value - ptv.InitValue, 3);
DataValue temp = new DataValue();
temp.SensorId = ptv.SensorId;
temp.TimeStamp = ptv.Stamp;
temp.ValueType = "007";
temp.Value = offset;
string result = JsonConvert.SerializeObject(temp);
pair[offsetKey] = result;
temp.ValueType = "020";
temp.Value = ptv.Value;
string innageKey = ptv.SensorId + "-020";
result = JsonConvert.SerializeObject(temp);
pair[innageKey] = result;
Settlement_Data sd = new Settlement_Data();
sd.SensorId = ptv.SensorId;
sd.TimeStamp = ptv.Stamp;
sd.Innage = ptv.Value;
sd.DeltaInnage = offset;
string mq_string = "";
//db.StringSet(offsetKey, result);
str += temp.SensorId + " " + temp.TimeStamp + " " + temp.ValueType + " " + temp.Value + "\r\n";
if (ptv.RefPoint == "null")
{
mq_string = JsonConvert.SerializeObject(sd);
//send mq_string
RabbitMsg rmsg = new RabbitMsg();
rmsg.RouteKey = ptv.SensorId;
rmsg.Body = mq_string;
dataQueue.Enqueue(rmsg);
//pair[ptv.SensorId] = mq_string;
//lthis.AppendLog(str);
continue;
}
string deflectionKey = ptv.SensorId + "-010";
string refKey = ptv.RefPoint.Split('-')[0];
SettlementConfig refPoint = list[refKey];
if (!refPoint.IsUpdated)
{
mq_string = JsonConvert.SerializeObject(sd);
//send mq_string
RabbitMsg rmsg = new RabbitMsg();
rmsg.RouteKey = ptv.SensorId;
rmsg.Body = mq_string;
dataQueue.Enqueue(rmsg);
//pair[ptv.SensorId] = mq_string;
//this.AppendLog(stamp + " " + ptv.RefPoint + "ref point is not updated");
continue;
}
double refOffset = Math.Round(refPoint.Value - refPoint.InitValue, 3);
double deflection = Math.Round(offset - refOffset, 3);
//str += temp.SensorId + " " + temp.TimeStamp + " " + temp.ValueType + " " + temp.Value + "\r\n";
temp.ValueType = "010";
temp.Value = deflection;
result = JsonConvert.SerializeObject(temp);
pair[deflectionKey] = result;
sd.Deflection = deflection;
mq_string = JsonConvert.SerializeObject(sd);
//send mq_string
RabbitMsg msg = new RabbitMsg();
msg.RouteKey = ptv.SensorId;
msg.Body = mq_string;
dataQueue.Enqueue(msg);
//pair[ptv.SensorId] = mq_string;
if (bgWorker.CancellationPending == true)
{
if (pair.Count > 0)
{
db_result.StringSet(pair.ToArray());
pair.Clear();
}
e.Cancel = true;
break;
}
str += temp.SensorId + " " + temp.TimeStamp + " " + temp.ValueType + " " + temp.Value + "\r\n";
//lthis.AppendLog(str);
}
if (pair.Count > 0)
{
db_result.StringSet(pair.ToArray());
pair.Clear();
}
foreach (string key in list.Keys)
{
SettlementConfig ptv = list[key];
ptv.IsUpdated = false;
}
}
catch (Exception ex)
{
this.AppendLog(ex.Message);
using (StreamWriter sw = new StreamWriter(@"ErrLog.txt", true))
{
sw.WriteLine(stamp + " " + ex.Message + " \r\n" + ex.StackTrace.ToString());
sw.WriteLine("---------------------------------------------------------");
sw.Close();
}
}
}