public List <GPS> QueryGPS(string TEID, DateTime StartTime, DateTime EndTime, int Top)
{
int nStartCode = StartTime.ToPartCode();
int nEndCode = EndTime.ToPartCode();
int nTable = SqlTemplate.FindTableMod(TEID);
Dictionary <string, object> dicPars = new Dictionary <string, object>();
dicPars.Add(SqlTemplate.TEIDKey, TEID);
string sqlQuery = string.Format(SqlTemplate.QueryGPS, nTable, nStartCode, nEndCode, Top);
DataTable dtRows = null;
using (var con = SqlHelper.GetConnection(SqlConnectString)) {
dtRows = SqlHelper.ExecuteDataset(con, sqlQuery, dicPars);
}
List <GPS> list = new List <GPS>();
if (dtRows != null)
{
foreach (DataRow drItem in dtRows.Rows)
{
GPS gps = new GPS {
ID = Convert.ToInt32(drItem[SqlTemplate.RKeyID]),
GetTime = Convert.ToDateTime(drItem[SqlTemplate.RKeyGetTime]),
InputTime = Convert.ToDateTime(drItem[SqlTemplate.RKeyInputTime]),
Lat = Convert.ToDecimal(drItem[SqlTemplate.RKeyLat]),
Lng = Convert.ToDecimal(drItem[SqlTemplate.RkeyLng]),
TEID = drItem[SqlTemplate.RKeyTEID].ToString(),
PartitionCode = Convert.ToInt32(drItem[SqlTemplate.RKeyPartitionCode])
};
list.Add(gps);
}
}
return(list);
}
public int AddR(GPS gps, OBD obd)
{
int nTable = SqlTemplate.FindTableMod(gps.TEID);
Dictionary <string, object> dicPars = new Dictionary <string, object>();
dicPars.Add(SqlTemplate.TEIDKey, gps.TEID);
int nCode = gps.GetTime.ToPartCode();
string timeStr = gps.GetTime.ToString("yyyy-MM-dd HH:mm:ss");
string sqlInsert = string.Format(SqlTemplate.InsertGPS, nTable, nCode, timeStr, gps.Lng, gps.Lng);
using (var con = SqlHelper.GetConnection(SqlConnectString)) {
System.Data.DataTable dtID = SqlHelper.ExecuteDataset(con, sqlInsert, dicPars);
int nID = Convert.ToInt32(dtID.Rows[0][0]);
string sqlInto2 = string.Format(SqlTemplate.InsertOBD, nTable, nID, nCode, timeStr, obd.Speed, obd.Rotate
, obd.Restrictor, obd.WaterT, obd.OilT, obd.OilPressure, obd.OilRemain);
SqlHelper.ExecuteNonQuery(con, sqlInto2, dicPars);
return(nID);
}
}
public List <OBD> QueryOBD(string TEID, DateTime StartTime, DateTime EndTime, int Top)
{
int nStartCode = StartTime.ToPartCode();
int nEndCode = EndTime.ToPartCode();
int nTable = SqlTemplate.FindTableMod(TEID);
Dictionary <string, object> dicPars = new Dictionary <string, object>();
dicPars.Add(SqlTemplate.TEIDKey, TEID);
string sqlQuery = string.Format(SqlTemplate.QueryOBD, nTable, nStartCode, nEndCode, Top);
DataTable dtRows = null;
using (var con = SqlHelper.GetConnection(SqlConnectString)) {
dtRows = SqlHelper.ExecuteDataset(con, sqlQuery, dicPars);
}
List <OBD> list = new List <OBD>();
if (dtRows != null)
{
foreach (DataRow drItem in dtRows.Rows)
{
OBD obd = new OBD {
ID = Convert.ToInt32(drItem[SqlTemplate.RKeyID]),
GetTime = Convert.ToDateTime(drItem[SqlTemplate.RKeyGetTime]),
InputTime = Convert.ToDateTime(drItem[SqlTemplate.RKeyInputTime]),
Speed = Convert.ToInt32(drItem[SqlTemplate.RKeySpeed]),
Rotate = Convert.ToInt32(drItem[SqlTemplate.RKeyRotate]),
Restrictor = Convert.ToInt32(drItem[SqlTemplate.RkeyRestrictor]),
WaterT = Convert.ToInt32(drItem[SqlTemplate.RKeyWaterT]),
OilT = Convert.ToInt32(drItem[SqlTemplate.RKeyOilT]),
OilPressure = Convert.ToInt32(drItem[SqlTemplate.RKeyOilPressure]),
OilRemain = Convert.ToInt32(drItem[SqlTemplate.RKeyOilRemain]),
TEID = drItem[SqlTemplate.RKeyTEID].ToString(),
PartitionCode = Convert.ToInt32(drItem[SqlTemplate.RKeyPartitionCode])
};
list.Add(obd);
}
}
return(list);
}
