public List <CEntityTSRain> QueryForAll(string stationid, DateTime start, DateTime end) { List <CEntityTSRain> results = null; string sql = "select * from " + CT_TableName + " where stationid= " + stationid + " and between '" + start + "' and '" + end + "' order by datatime desc;"; SqlDataAdapter adapter = new SqlDataAdapter(sql, CDBManager.GetInstacne().GetConnection()); DataTable dataTableTemp = new DataTable(); adapter.Fill(dataTableTemp); for (int rowid = 0; rowid < dataTableTemp.Rows.Count; ++rowid) { CEntityTSRain rain = new CEntityTSRain(); rain.StationID = dataTableTemp.Rows[rowid][CN_StationId].ToString(); rain.TimeCollect = DateTime.Parse(dataTableTemp.Rows[rowid][CN_DataTime].ToString()); if (dataTableTemp.Rows[rowid][CN_TotalRain].ToString() != "") { rain.TotalRain = decimal.Parse(dataTableTemp.Rows[rowid][CN_TotalRain].ToString()); } else { rain.TotalRain = -9999; } try { rain.TimeCollect = DateTime.Parse(dataTableTemp.Rows[rowid][CN_DataTime].ToString()); #pragma warning disable CS0168 // 声明了变量“e”,但从未使用过 }catch (Exception e) #pragma warning restore CS0168 // 声明了变量“e”,但从未使用过 { } try { rain.TimeRecieved = DateTime.Parse(dataTableTemp.Rows[rowid][CN_RecvDataTime].ToString()); } #pragma warning disable CS0168 // 声明了变量“e”,但从未使用过 catch (Exception e) #pragma warning restore CS0168 // 声明了变量“e”,但从未使用过 { } try { //rain.MessageType = dataTableTemp.Rows[rowid][CN_MsgType])); } #pragma warning disable CS0168 // 声明了变量“e”,但从未使用过 catch (Exception e) #pragma warning restore CS0168 // 声明了变量“e”,但从未使用过 { } results.Add(rain); } return(results); }
public void AddNewRow(CEntityTSRain rain) { m_mutexDataTable.WaitOne(); //等待互斥量 DataRow row = m_tableDataAdded.NewRow(); row[CN_StationId] = rain.StationID; row[CN_DataTime] = rain.TimeCollect.ToString(CDBParams.GetInstance().DBDateTimeFormat); row[CN_TotalRain] = rain.TotalRain; row[CN_TransType] = CEnumHelper.ChannelTypeToDBStr(rain.ChannelType); row[CN_MsgType] = CEnumHelper.MessageTypeToDBStr(rain.MessageType); row[CN_RecvDataTime] = rain.TimeRecieved.ToString(CDBParams.GetInstance().DBDateTimeFormat); m_tableDataAdded.Rows.Add(row); m_mutexDataTable.ReleaseMutex(); AddDataToDB(); }
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); }