public bool GetLastData(ref Nullable <Decimal> lastVoltage, ref Nullable <DateTime> lastDayTime, ref Nullable <EChannelType> lastChannelType, ref Nullable <EMessageType> lastMessageType, string stationId)
{
// 获取计算雨量值所需的数据
try
{
// 获取最近一条的雨量值
string sql = string.Format("select top 1 * from {0} where {1} = '{2}' order by {3} desc;",
CT_TableName,
CN_StationId, stationId,
CN_DataTime);
SqlDataAdapter adapter = new SqlDataAdapter(sql, CDBManager.GetInstacne().GetConnection());
DataTable dataTableTmp = new DataTable();
adapter.Fill(dataTableTmp);
if (dataTableTmp.Rows.Count > 0)
{
lastVoltage = Decimal.Parse(dataTableTmp.Rows[0][CN_Voltage].ToString());
lastDayTime = DateTime.Parse(dataTableTmp.Rows[0][CN_DataTime].ToString());
lastChannelType = CEnumHelper.DBStrToChannelType(dataTableTmp.Rows[0][CN_TransType].ToString());
lastMessageType = CEnumHelper.DBStrToMessageType(dataTableTmp.Rows[0][CN_MsgType].ToString());
}
else
{
// Debug.WriteLine(string.Format("查询电压表为空,站点{0}", stationId));
}
return(true);
}
catch (System.Exception ex)
{
Debug.WriteLine(ex.ToString());
return(false);
}
finally
{
}
}
private List <CEntityTSWater> CopyDataToList(int key, int startRow)
{
List <CEntityTSWater> result = new List <CEntityTSWater>();
// 取最小值 ，保证不越界
int endRow = Math.Min(m_mapDataTable[key].Rows.Count, startRow + CDBParams.GetInstance().UIPageRowCount);
DataTable table = m_mapDataTable[key];
for (; startRow < endRow; ++startRow)
{
CEntityTSWater water = new CEntityTSWater();
// water.WaterID = long.Parse(table.Rows[startRow][CN_WaterID].ToString());
water.StationID = table.Rows[startRow][CN_StationId].ToString();
water.TimeCollect = DateTime.Parse(table.Rows[startRow][CN_DataTime].ToString());
//水位
if (!table.Rows[startRow][CN_WaterStage].ToString().Equals(""))
{
water.WaterStage = Decimal.Parse(table.Rows[startRow][CN_WaterStage].ToString());
}
else
{
//11.12
water.WaterStage = -9999;
}
//流量
water.TimeRecieved = DateTime.Parse(table.Rows[startRow][CN_RecvDataTime].ToString());
water.ChannelType = CEnumHelper.DBStrToChannelType(table.Rows[startRow][CN_TransType].ToString());
water.MessageType = CEnumHelper.DBStrToMessageType(table.Rows[startRow][CN_MsgType].ToString());
result.Add(water);
}
return(result);
}
private List <CEntityOBS> CopyDataToList(int key, int startRow)
{
List <CEntityOBS> result = new List <CEntityOBS>();
try
{
// 取最小值 ，保证不越界
int endRow = Math.Min(m_mapDataTable[key].Rows.Count, startRow + CDBParams.GetInstance().UIPageRowCount);
DataTable table = m_mapDataTable[key];
for (; startRow < endRow; ++startRow)
{
CEntityOBS obs = new CEntityOBS();
// rain.RainID = long.Parse(table.Rows[startRow][CN_RainID].ToString());
obs.StationID = table.Rows[startRow][CN_StationId].ToString();
obs.TimeCollect = DateTime.Parse(table.Rows[startRow][CN_DataTime].ToString());
if (!table.Rows[startRow][CN_Depth].ToString().Equals(""))
{
obs.Depth = Decimal.Parse(table.Rows[startRow][CN_Depth].ToString());
}
if (!table.Rows[startRow][CN_NTU].ToString().Equals(""))
{
obs.NTU = Decimal.Parse(table.Rows[startRow][CN_NTU].ToString());
}
if (!table.Rows[startRow][CN_ppm].ToString().Equals(""))
{
obs.ppm = Decimal.Parse(table.Rows[startRow][CN_ppm].ToString());
}
if (!table.Rows[startRow][CN_Temperature].ToString().Equals(""))
{
obs.Temperature = Decimal.Parse(table.Rows[startRow][CN_Temperature].ToString());
}
//obs.maxTime = DateTime.Parse(table.Rows[startRow][CN_maxTime].ToString());
if (!table.Rows[startRow][CN_Conductivity].ToString().Equals(""))
{
obs.Conductivity = Decimal.Parse(table.Rows[startRow][CN_Conductivity].ToString());
}
if (!table.Rows[startRow][CN_Salinity].ToString().Equals(""))
{
obs.Salinity = Decimal.Parse(table.Rows[startRow][CN_Salinity].ToString());
}
if (!table.Rows[startRow][CN_Batt].ToString().Equals(""))
{
obs.Batt = Decimal.Parse(table.Rows[startRow][CN_Batt].ToString());
}
obs.BState = 1;
obs.ChannelType = CEnumHelper.DBStrToChannelType(table.Rows[startRow][CN_transtype].ToString());
obs.MessageType = CEnumHelper.DBStrToMessageType(table.Rows[startRow][CN_messagetype].ToString());
obs.TimeRecieved = DateTime.Parse(table.Rows[startRow][CN_recvdatatime].ToString());
result.Add(obs);
}
}
catch (Exception e)
{
Debug.WriteLine("" + e.ToString());
}
return(result);
}
// 将Map中由key指定的DataTable,从startRow开始返回界面最大行数的集合
private List <CEntityWater> CopyDataToList(int key, int startRow)
{
List <CEntityWater> result = new List <CEntityWater>();
// 取最小值 ，保证不越界
int endRow = Math.Min(m_mapDataTable[key].Rows.Count, startRow + CDBParams.GetInstance().UIPageRowCount);
DataTable table = m_mapDataTable[key];
for (; startRow < endRow; ++startRow)
{
CEntityWater water = new CEntityWater();
// water.WaterID = long.Parse(table.Rows[startRow][CN_WaterID].ToString());
water.StationID = table.Rows[startRow][CN_StationId].ToString();
water.TimeCollect = DateTime.Parse(table.Rows[startRow][CN_DataTime].ToString());
//水位
if (!table.Rows[startRow][CN_WaterStage].ToString().Equals(""))
{
water.WaterStage = Decimal.Parse(table.Rows[startRow][CN_WaterStage].ToString());
}
else
{
//11.12
water.WaterStage = -9999;
}
//流量
string tmp = table.Rows[startRow][CN_WaterFlow].ToString();
if (!tmp.Equals(""))
{
water.WaterFlow = Decimal.Parse(table.Rows[startRow][CN_WaterFlow].ToString());
}
else
{
//11.12
water.WaterFlow = -9999;
}
if (table.Rows[startRow][CN_State].ToString() != "")
{
try
{
water.state = int.Parse(table.Rows[startRow][CN_State].ToString());
}
#pragma warning disable CS0168 // 声明了变量“ex”，但从未使用过
catch (Exception ex) { }
#pragma warning restore CS0168 // 声明了变量“ex”，但从未使用过
}
else
{
water.state = 1;
}
water.TimeRecieved = DateTime.Parse(table.Rows[startRow][CN_RecvDataTime].ToString());
water.ChannelType = CEnumHelper.DBStrToChannelType(table.Rows[startRow][CN_TransType].ToString());
water.MessageType = CEnumHelper.DBStrToMessageType(table.Rows[startRow][CN_MsgType].ToString());
result.Add(water);
}
return(result);
}
// 将Map中由key指定的DataTable,从startRow开始返回界面最大行数的集合
private List <CEntityVoltage> CopyDataToList(int key, int startRow)
{
List <CEntityVoltage> result = new List <CEntityVoltage>();
// 取最小值 ，保证不越界
int endRow = Math.Min(m_mapDataTable[key].Rows.Count, startRow + CDBParams.GetInstance().UIPageRowCount);
DataTable table = m_mapDataTable[key];
for (; startRow < endRow; ++startRow)
{
CEntityVoltage voltage = new CEntityVoltage();
// voltage.VoltageID = long.Parse(table.Rows[startRow][CN_VoltageID].ToString());
voltage.StationID = table.Rows[startRow][CN_StationId].ToString();
voltage.TimeCollect = DateTime.Parse(table.Rows[startRow][CN_DataTime].ToString());
if (!table.Rows[startRow][CN_Voltage].ToString().Equals(""))
{
voltage.Voltage = Decimal.Parse(table.Rows[startRow][CN_Voltage].ToString());
}
else
{
voltage.Voltage = -9999;
}
if (table.Rows[startRow][CN_State].ToString() != "")
{
try
{
voltage.state = int.Parse(table.Rows[startRow][CN_State].ToString());
}
catch (Exception ex) { }
}
else
{
voltage.state = 1;
}
voltage.TimeRecieved = DateTime.Parse(table.Rows[startRow][CN_RecvDataTime].ToString());
voltage.ChannelType = CEnumHelper.DBStrToChannelType(table.Rows[startRow][CN_TransType].ToString());
voltage.MessageType = CEnumHelper.DBStrToMessageType(table.Rows[startRow][CN_MsgType].ToString());
result.Add(voltage);
}
return(result);
}
private List <PWDData> CopyDataToList(int key, int startRow)
{
List <PWDData> result = new List <PWDData>();
try
{
// 取最小值 ，保证不越界
int endRow = Math.Min(m_mapDataTable[key].Rows.Count, startRow + CDBParams.GetInstance().UIPageRowCount);
DataTable table = m_mapDataTable[key];
for (; startRow < endRow; ++startRow)
{
PWDData pwd = new PWDData();
// rain.RainID = long.Parse(table.Rows[startRow][CN_RainID].ToString());
pwd.StationID = table.Rows[startRow][CN_StationId].ToString();
pwd.TimeCollect = DateTime.Parse(table.Rows[startRow][CN_DataTime].ToString());
if (!table.Rows[startRow][CN_Visi1min].ToString().Equals(""))
{
pwd.Visi1min = Decimal.Parse(table.Rows[startRow][CN_Visi1min].ToString());
}
if (!table.Rows[startRow][CN_Visi10min].ToString().Equals(""))
{
pwd.Visi10min = Decimal.Parse(table.Rows[startRow][CN_Visi10min].ToString());
}
pwd.BState = 1;
pwd.ChannelType = CEnumHelper.DBStrToChannelType(table.Rows[startRow][CN_transtype].ToString());
pwd.MessageType = CEnumHelper.DBStrToMessageType(table.Rows[startRow][CN_messagetype].ToString());
pwd.TimeRecieved = DateTime.Parse(table.Rows[startRow][CN_recvdatatime].ToString());
result.Add(pwd);
}
}
catch (Exception e)
{
Debug.WriteLine("" + e.ToString());
}
return(result);
}
private List <CEntityTSRain> CopyDataToList(int key, int startRow)
{
List <CEntityTSRain> result = new List <CEntityTSRain>();
// 取最小值 ，保证不越界
int endRow = Math.Min(m_mapDataTable[key].Rows.Count, startRow + CDBParams.GetInstance().UIPageRowCount);
DataTable table = m_mapDataTable[key];
for (; startRow < endRow; ++startRow)
{
CEntityTSRain rain = new CEntityTSRain();
// rain.RainID = long.Parse(table.Rows[startRow][CN_RainID].ToString());
rain.StationID = table.Rows[startRow][CN_StationId].ToString();
rain.TimeCollect = DateTime.Parse(table.Rows[startRow][CN_DataTime].ToString());
if (!table.Rows[startRow][CN_TotalRain].ToString().Equals(""))
{
rain.TotalRain = Decimal.Parse(table.Rows[startRow][CN_TotalRain].ToString());
}
rain.TimeRecieved = DateTime.Parse(table.Rows[startRow][CN_RecvDataTime].ToString());
rain.ChannelType = CEnumHelper.DBStrToChannelType(table.Rows[startRow][CN_TransType].ToString());
rain.MessageType = CEnumHelper.DBStrToMessageType(table.Rows[startRow][CN_MsgType].ToString());
result.Add(rain);
}
return(result);
}
/// <summary>
/// 获取某个站点最新的数据，如果没有，lastData = null
/// </summary>
/// <param name="lastData"></param>
/// <returns></returns>
public bool GetLastStationData(string stationId, out CEntitySoilData lastData)
{
lastData = null;
string sql = string.Format("select top 1 * from {0} where {1} = {2} order by {3} desc",
CT_TableName,
CN_StationId, stationId,
CN_DataTime);
SqlDataAdapter adapter = new SqlDataAdapter(sql, CDBManager.GetInstacne().GetConnection());
DataTable dataTableTmp = new DataTable();
adapter.Fill(dataTableTmp);
// 只有一行噻？不然怎么玩？？
if (dataTableTmp.Rows.Count == 1)
{
int rowid = 0;
CEntitySoilData data = new CEntitySoilData();
data.StationID = dataTableTmp.Rows[rowid][CN_StationId].ToString();
data.DataTime = DateTime.Parse(dataTableTmp.Rows[rowid][CN_DataTime].ToString());
data.DVoltage = decimal.Parse(dataTableTmp.Rows[rowid][CN_Voltage].ToString());
data.MessageType = CEnumHelper.DBStrToMessageType(dataTableTmp.Rows[rowid][CN_MessageType].ToString());
data.ChannelType = CEnumHelper.DBStrToChannelType(dataTableTmp.Rows[rowid][CN_ChannelType].ToString());
data.Voltage10 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Voltage10]);
data.Moisture10 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Moisture10]);
data.Voltage20 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Voltage20]);
data.Moisture20 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Moisture20]);
data.Voltage30 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Voltage30]);
data.Moisture30 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Moisture30]);
data.Voltage40 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Voltage40]);
data.Moisture40 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Moisture40]);
data.Voltage60 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Voltage60]);
data.Moisture60 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Moisture60]);
try
{
if (dataTableTmp.Rows[rowid][CN_RecvTime].ToString() != "")
{
data.reciveTime = DateTime.Parse(dataTableTmp.Rows[rowid][CN_RecvTime].ToString());
}
}
catch (Exception e)
{
data.reciveTime = DateTime.Now;
}
try
{
if (dataTableTmp.Rows[rowid][CN_State].ToString() != "")
{
data.state = int.Parse(dataTableTmp.Rows[rowid][CN_State].ToString());
}
}
catch (Exception e)
{
data.state = 1;
}
lastData = data;
}
// Debug.WriteLine(string.Format("查询站点{0}最新墒情数据完成", stationId));
return(true);
}
/// <summary>
/// 根据起始时间以及结束时间还有站点ID,查询墒情数据
/// </summary>
/// <param name="stationId"></param>
/// <param name="timeStart"></param>
/// <param name="timeEnd"></param>
/// <returns></returns>
public List <CEntitySoilData> QueryByStationAndTime(string stationId, DateTime timeStart, DateTime timeEnd)
{
////传递得参数
//Dictionary<string, object> param = new Dictionary<string, object>();
////TODO添加datatime转string timeStart timeEnd
////查询条件
//Dictionary<string, string> paramInner = new Dictionary<string, string>();
//paramInner["stationid"] = stationId;
////paramInner["strttime"] = timeStart.ToString("yyyy-MM-dd HH:mm:ss");
//paramInner["strttime"] = timeStart.ToString();
////paramInner["endtime"] = timeEnd.ToString("yyyy-MM-dd HH:mm:ss");
//paramInner["endtime"] = timeEnd.ToString();
////返回结果
//List<CEntitySoilData> soildataList = new List<CEntitySoilData>();
////string suffix = "/subcenter/getSubcenter";
//string url = "http://127.0.0.1:8088/soildata/getSoildata";
//string jsonStr = HttpHelper.SerializeDictionaryToJsonString(paramInner);
//param["soildata"] = jsonStr;
//try
//{
// string resultJson = HttpHelper.Post(url, param);
// soildataList = (List<CEntitySoilData>)HttpHelper.JsonToObject(resultJson, new List<CEntitySoilData>());
//}
//catch (Exception e)
//{
// Debug.WriteLine("查询墒情信息失败");
// throw e;
//}
//return soildataList;
List <CEntitySoilData> results = new List <CEntitySoilData>();
try
{
string sql = string.Format("select * from {0} where {1} = {2} and {3} between {4} and {5} order by {6} desc",
CT_TableName,
CN_StationId, stationId,
CN_DataTime, DateTimeToDBStr(timeStart), DateTimeToDBStr(timeEnd),
CN_DataTime);
SqlDataAdapter adapter = new SqlDataAdapter(sql, CDBManager.GetInstacne().GetConnection());
DataTable dataTableTmp = new DataTable();
adapter.Fill(dataTableTmp);
for (int rowid = 0; rowid < dataTableTmp.Rows.Count; ++rowid)
{
CEntitySoilData data = new CEntitySoilData();
data.StationID = dataTableTmp.Rows[rowid][CN_StationId].ToString();
data.DataTime = DateTime.Parse(dataTableTmp.Rows[rowid][CN_DataTime].ToString());
data.DVoltage = decimal.Parse(dataTableTmp.Rows[rowid][CN_Voltage].ToString());
data.MessageType = CEnumHelper.DBStrToMessageType(dataTableTmp.Rows[rowid][CN_MessageType].ToString());
data.ChannelType = CEnumHelper.DBStrToChannelType(dataTableTmp.Rows[rowid][CN_ChannelType].ToString());
data.Voltage10 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Voltage10]);
data.Moisture10 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Moisture10]);
data.Voltage20 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Voltage20]);
data.Moisture20 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Moisture20]);
data.Voltage30 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Voltage30]);
data.Moisture30 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Moisture30]);
data.Voltage40 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Voltage40]);
data.Moisture40 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Moisture40]);
data.Voltage60 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Voltage60]);
data.Moisture60 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Moisture60]);
data.reciveTime = DateTime.Parse(dataTableTmp.Rows[rowid][CN_DataTime].ToString());
try
{
if (dataTableTmp.Rows[rowid][CN_RecvTime].ToString() != "")
{
data.reciveTime = DateTime.Parse(dataTableTmp.Rows[rowid][CN_RecvTime].ToString());
}
}
catch (Exception e)
{
data.reciveTime = DateTime.Now;
}
try
{
if (dataTableTmp.Rows[rowid][CN_State].ToString() != "")
{
data.state = int.Parse(dataTableTmp.Rows[rowid][CN_State].ToString());
}
}
catch (Exception e)
{
data.state = 1;
}
results.Add(data);
}
}
catch (System.Exception ex)
{
Debug.WriteLine(ex.ToString());
}
return(results);
}
public List <CEntityWaterSpeed> QueryByTime(string station, DateTime start, DateTime end)
{
List <CEntityWaterSpeed> results = new List <CEntityWaterSpeed>();
String sql = "select * from " + CT_TableName + " where STCD=" + station + " and DT between '" + start + "'and '" + end + "'" + "order by DT desc;";
SqlDataAdapter adapter = new SqlDataAdapter(sql, CDBManager.GetInstacne().GetConnection());
DataTable dataTableTemp = new DataTable();
adapter.Fill(dataTableTemp);
int flag = dataTableTemp.Rows.Count;
if (flag == 0)
{
}
else
{
for (int rowid = 0; rowid < dataTableTemp.Rows.Count; ++rowid)
{
CEntityWaterSpeed waterSpeed = new CEntityWaterSpeed();
waterSpeed.STCD = dataTableTemp.Rows[rowid][CN_StationId].ToString();
waterSpeed.DT = DateTime.Parse(dataTableTemp.Rows[rowid][CN_DataTime].ToString());
if (dataTableTemp.Rows[rowid][CN_WaterStage].ToString() != null && dataTableTemp.Rows[rowid][CN_WaterStage].ToString() != "")
{
waterSpeed.W1 = decimal.Parse(dataTableTemp.Rows[rowid][CN_WaterStage].ToString());
}
else
{
waterSpeed.W1 = null;
}
if (dataTableTemp.Rows[rowid][CN_V1].ToString() != null && dataTableTemp.Rows[rowid][CN_V1].ToString() != "")
{
waterSpeed.AvgV1 = decimal.Parse(dataTableTemp.Rows[rowid][CN_V1].ToString());
}
else
{
waterSpeed.AvgV1 = null;
}
if (dataTableTemp.Rows[rowid][CN_V2].ToString() != null && dataTableTemp.Rows[rowid][CN_V2].ToString() != "")
{
waterSpeed.AvgV2 = decimal.Parse(dataTableTemp.Rows[rowid][CN_V2].ToString());
}
else
{
waterSpeed.AvgV2 = null;
}
if (dataTableTemp.Rows[rowid][CN_V3].ToString() != null && dataTableTemp.Rows[rowid][CN_V3].ToString() != "")
{
waterSpeed.AvgV3 = decimal.Parse(dataTableTemp.Rows[rowid][CN_V3].ToString());
}
else
{
waterSpeed.AvgV3 = null;
}
if (dataTableTemp.Rows[rowid][CN_V4].ToString() != null && dataTableTemp.Rows[rowid][CN_V4].ToString() != "")
{
waterSpeed.AvgV4 = decimal.Parse(dataTableTemp.Rows[rowid][CN_V4].ToString());
}
else
{
waterSpeed.AvgV4 = null;
}
if (dataTableTemp.Rows[rowid][CN_WaterFlowMc].ToString() != null && dataTableTemp.Rows[rowid][CN_WaterFlowMc].ToString() != "")
{
waterSpeed.rawQ = decimal.Parse(dataTableTemp.Rows[rowid][CN_WaterFlowMc].ToString());
}
else
{
waterSpeed.rawQ = null;
}
if (dataTableTemp.Rows[rowid][CN_WaterFlow].ToString() != null && dataTableTemp.Rows[rowid][CN_WaterFlow].ToString() != "")
{
waterSpeed.Q = decimal.Parse(dataTableTemp.Rows[rowid][CN_WaterFlow].ToString());
}
else
{
waterSpeed.Q = null;
}
//waterSpeed.AvgV1 = decimal.Parse(dataTableTemp.Rows[rowid][CN_V1].ToString());
//waterSpeed.AvgV2 = decimal.Parse(dataTableTemp.Rows[rowid][CN_V2].ToString());
//waterSpeed.AvgV3 = decimal.Parse(dataTableTemp.Rows[rowid][CN_V3].ToString());
//waterSpeed.AvgV4 = decimal.Parse(dataTableTemp.Rows[rowid][CN_V4].ToString());
//waterSpeed.rawQ = decimal.Parse(dataTableTemp.Rows[rowid][CN_WaterFlowMc].ToString());
//waterSpeed.Q = decimal.Parse(dataTableTemp.Rows[rowid][CN_WaterFlow].ToString());
waterSpeed.RevtDT = DateTime.Parse(dataTableTemp.Rows[rowid][CN_RecvDataTime].ToString());
waterSpeed.ChannelType = CEnumHelper.DBStrToChannelType(dataTableTemp.Rows[rowid][CN_TransType].ToString());
waterSpeed.MessageType = CEnumHelper.DBStrToMessageType(dataTableTemp.Rows[rowid][CN_MsgType].ToString());
results.Add(waterSpeed);
}
}
return(results);
}
/// <summary>
/// 根据起始时间以及结束时间还有站点ID,查询墒情数据
/// </summary>
/// <param name="stationId"></param>
/// <param name="timeStart"></param>
/// <param name="timeEnd"></param>
/// <returns></returns>
public List <CEntitySoilData> QueryByStationAndTime(string stationId, DateTime timeStart, DateTime timeEnd)
{
List <CEntitySoilData> results = new List <CEntitySoilData>();
try
{
string sql = string.Format("select * from {0} where {1} = {2} and {3} between {4} and {5} order by {6}",
CT_TableName,
CN_StationId, stationId,
CN_DataTime, DateTimeToDBStr(timeStart), DateTimeToDBStr(timeEnd),
CN_DataTime);
SqlDataAdapter adapter = new SqlDataAdapter(sql, CDBManager.GetInstacne().GetConnection());
DataTable dataTableTmp = new DataTable();
adapter.Fill(dataTableTmp);
for (int rowid = 0; rowid < dataTableTmp.Rows.Count; ++rowid)
{
CEntitySoilData data = new CEntitySoilData();
data.StationID = dataTableTmp.Rows[rowid][CN_StationId].ToString();
data.DataTime = DateTime.Parse(dataTableTmp.Rows[rowid][CN_DataTime].ToString());
data.DVoltage = decimal.Parse(dataTableTmp.Rows[rowid][CN_Voltage].ToString());
data.MessageType = CEnumHelper.DBStrToMessageType(dataTableTmp.Rows[rowid][CN_MessageType].ToString());
data.ChannelType = CEnumHelper.DBStrToChannelType(dataTableTmp.Rows[rowid][CN_ChannelType].ToString());
data.Voltage10 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Voltage10]);
data.Moisture10 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Moisture10]);
data.Voltage20 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Voltage20]);
data.Moisture20 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Moisture20]);
data.Voltage30 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Voltage30]);
data.Moisture30 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Moisture30]);
data.Voltage40 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Voltage40]);
data.Moisture40 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Moisture40]);
data.Voltage60 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Voltage60]);
data.Moisture60 = GetCellFloatValue(dataTableTmp.Rows[rowid][CN_Moisture60]);
data.reciveTime = DateTime.Parse(dataTableTmp.Rows[rowid][CN_DataTime].ToString());
try
{
if (dataTableTmp.Rows[rowid][CN_RecvTime].ToString() != "")
{
data.reciveTime = DateTime.Parse(dataTableTmp.Rows[rowid][CN_RecvTime].ToString());
}
}
#pragma warning disable CS0168 // 声明了变量“e”，但从未使用过
catch (Exception e)
#pragma warning restore CS0168 // 声明了变量“e”，但从未使用过
{
data.reciveTime = DateTime.Now;
}
try
{
if (dataTableTmp.Rows[rowid][CN_State].ToString() != "")
{
data.state = int.Parse(dataTableTmp.Rows[rowid][CN_State].ToString());
}
}
#pragma warning disable CS0168 // 声明了变量“e”，但从未使用过
catch (Exception e)
#pragma warning restore CS0168 // 声明了变量“e”，但从未使用过
{
data.state = 1;
}
results.Add(data);
}
}
catch (System.Exception ex)
{
Debug.WriteLine(ex.ToString());
}
return(results);
}