public override void OnProcess(ITask task, IParseResult pr)
{
if (pr.IsSuccess)
{
if (StringHelper.Equal(task.Opera.Name, "ReadReal"))
{
Xd202Data data = new Xd202Data();
data.BeforeWL = Convert.ToDouble(task.LastParseResult.Results["BeforeWL"]);
data.BehindWL = Convert.ToDouble(task.LastParseResult.Results["BehindWL"]);
data.Height = Convert.ToDouble(task.LastParseResult.Results["Height"]);
data.InstantFlux = Convert.ToDouble(task.LastParseResult.Results["IF"]);
data.RemainedAmount = Convert.ToDouble(task.LastParseResult.Results["RemainedAmount"]);
data.UsedAmount = 0 - data.RemainedAmount;
data.BeforeWL = CM2M(data.BeforeWL);
data.BehindWL = CM2M(data.BehindWL);
data.Height = CM2M(data.Height);
task.Device.DeviceDataManager.Last = data;
int id = GuidHelper.ConvertToInt32(task.Device.Guid);
DBI.Instance.InsertXd202Data(id, data);
}
}
}
/// <summary>
///
/// </summary>
/// <param name="deviceID"></param>
/// <param name="data"></param>
public void InsertXd202Data(int deviceID, Xd202Data data)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = @"INSERT INTO tblMeasureSluiceData(
[DeviceID], [DT], [BeforeWL], [BehindWL], [InstantFlux], [Height], [RemainedAmount], [UsedAmount])
VALUES(
@DeviceID, @DT, @BeforeWL, @BehindWL, @InstantFlux, @Height, @RemainedAmount, @UsedAmount)";
DBIBase.AddSqlParameter(cmd, "deviceID", deviceID);
DBIBase.AddSqlParameter(cmd, "dt", data.DT);
DBIBase.AddSqlParameter(cmd, "BeforeWL", data.BeforeWL);
DBIBase.AddSqlParameter(cmd, "BehindWL", data.BehindWL);
DBIBase.AddSqlParameter(cmd, "InstantFlux", data.InstantFlux);
DBIBase.AddSqlParameter(cmd, "Height", data.Height);
DBIBase.AddSqlParameter(cmd, "RemainedAmount", data.RemainedAmount);
DBIBase.AddSqlParameter(cmd, "UsedAmount", data.UsedAmount);
ExecuteScalar(cmd);
}
/// <summary>
///
/// </summary>
/// <param name="deviceID"></param>
/// <param name="data"></param>
public void InsertXd202Data(int deviceID, Xd202Data data)
{
string sql = @"INSERT INTO tblMeasureSluiceData(
[DeviceID], [DT], [BeforeWL], [BehindWL], [InstantFlux], [Height], [RemainedAmount], [UsedAmount])
VALUES(
@DeviceID, @DT, @BeforeWL, @BehindWL, @InstantFlux, @Height, @RemainedAmount, @UsedAmount)";
ListDictionary listDict = new ListDictionary();
//listDict.Add ( 1,2);
listDict.Add("deviceID", deviceID);
listDict.Add("dt", data.DT);
listDict.Add("BeforeWL", data.BeforeWL);
listDict.Add("BehindWL", data.BehindWL);
listDict.Add("InstantFlux", data.InstantFlux);
listDict.Add("Height", data.Height);
listDict.Add("RemainedAmount", data.RemainedAmount);
listDict.Add("UsedAmount", data.UsedAmount);
//ExecuteScalar(cmd);
ExecuteScalar(sql, listDict);
}
public override void OnProcess(ITask task, IParseResult pr)
{
if (pr.IsSuccess)
{
if (StringHelper.Equal(task.Opera.Name, "ReadReal"))
{
Xd202Data data = new Xd202Data();
data.BeforeWL = Convert.ToDouble(task.LastParseResult.Results["BeforeWL"]);
data.BehindWL = Convert.ToDouble(task.LastParseResult.Results["BehindWL"]);
data.Height = Convert.ToDouble(task.LastParseResult.Results["Height"]);
data.InstantFlux = Convert.ToDouble(task.LastParseResult.Results["IF"]);
data.RemainedAmount = Convert.ToDouble(task.LastParseResult.Results["RemainedAmount"]);
data.UsedAmount = 0 - data.RemainedAmount;
data.BeforeWL = CM2M(data.BeforeWL);
data.BehindWL = CM2M(data.BehindWL);
data.Height = CM2M(data.Height);
task.Device.DeviceDataManager.Last = data;
int id = GuidHelper.ConvertToInt32(task.Device.Guid);
DBI.Instance.InsertXd202Data(id, data);
}
}
}