/// <summary>
///
/// </summary>
/// <param name="deviceID"></param>
/// <param name="d"></param>
public void InsertVPump100Data(int deviceID, VPump100Data data)
{
string s = " insert into tblPumpData(deviceid, DT, instantFlux, efficiency, TotalAmount, RemainAmount, pumpStatus, forceStatus, vibrateStatus, powerStatus) " +
" values(@deviceID, @dt, @instantFlux, @efficiency, @totalAmount, @remainAmount, @pumpStatus, @forceStatus, @vibrateStatus, @powerStatus)";
ListDictionary list = new ListDictionary();
list.Add("DeviceID", deviceID);
list.Add("Dt", data.DT);
list.Add("InstantFlux", data.InstantFlux);
list.Add("Efficiency", data.Efficiency);
list.Add("TotalAmount", data.TotalAmount);
list.Add("RemainAmount", data.RemainAmount);
list.Add("pumpStatus", data.PumpStatus);
list.Add("forceStatus", data.ForceStartStatus);
list.Add("vibrateStatus", data.VibrateStatus);
list.Add("powerStatus", data.PowerStatus);
ExecuteScalar(s, list);
if (base.IsAccessDataBase())
{
int gateDataIDLast = GetPumpDataIDMax(deviceID);
this.DeletePumpDataLast(deviceID);
this.InsertPumpDataLast(deviceID, gateDataIDLast);
}
}
/// <summary>
///
/// </summary>
/// <param name="recordsBytes"></param>
/// <param name="recordCount"></param>
private VPump100Data[] ProcessRecord(byte[] recordsBytes, byte recordCount)
{
List <VPump100Data> list = new List <VPump100Data> ();
for (int i = 0; i < recordCount; i++)
{
VPump100Data data = VPump100Data.ToVPump100Data(
recordsBytes,
i * VPump100Data.BytesCountOfVPumpData);
list.Add(data);
}
return(list.ToArray());
}
static private VPump100Data[] ConvertToVPump100Datas(DataTable datatable, out int createCount)
{
NullOrDBNullConverter nc = new NullOrDBNullConverter(0f);
createCount = 0;
List <VPump100Data> list = new List <VPump100Data>();
foreach (DataRow row in datatable.Rows)
{
DateTime dt = Convert.ToDateTime(row[ColumnNamesForPump.StrTime]);
float instantFlux = Convert.ToSingle(nc.Convert(row[ColumnNamesForPump.Flux]));
float efficienty = Convert.ToSingle(nc.Convert(row[ColumnNamesForPump.Efficiency]));
float sum = Convert.ToSingle(nc.Convert(row[ColumnNames.TuWater]));
float remain = Convert.ToSingle(nc.Convert(row[ColumnNames.ReWater]));
PumpStatus pumpStatus = VPumpStatusParser.ParsePumpStatus(row[ColumnNamesForPump.PumpStatus].ToString());
ForceStartStatus forceStatus = VPumpStatusParser.ParseForceStartStatus(row[ColumnNamesForPump.ForceRun].ToString());
VibrateStatus vibrateStatus = VPumpStatusParser.ParseVibrateStatus(row[ColumnNamesForPump.Vibrate].ToString());
PumpPowerStatus powerStatus = VPumpStatusParser.ParsePowerStatus(row[ColumnNamesForPump.Power].ToString());
VPump100Data data = new VPump100Data();
data.DT = dt;
data.InstantFlux = instantFlux;
data.Efficiency = efficienty;
data.TotalAmount = sum;
data.RemainAmount = remain;
data.PumpStatus = pumpStatus;
data.ForceStartStatus = forceStatus;
data.VibrateStatus = vibrateStatus;
data.PowerStatus = powerStatus;
list.Add(data);
if (list.Count >= 5)
{
break;
}
}
createCount = list.Count;
while (list.Count < 5)
{
list.Add(new VPump100Data());
}
return(list.ToArray());
}
