示例#1
0
        /// <summary>
        /// 通过设备号提取前N个数据的方法
        /// </summary>
        /// <param name="num"></param>
        /// <param name="to"></param>
        /// <returns></returns>
        public IList<OriginalDataInfo> GetTopNDatasByDeviceID(int num, int deviceid)
        {

            IList<OriginalDataInfo> originaldata = new List<OriginalDataInfo>();

            //创建一个新的查询字符串并赋值
            StringBuilder sql = new StringBuilder(SQL_SELECT_TOPN_ORIGINALDATA_BY_DEVICE);
            string sqlSearch = string.Format(sql.ToString(), num);

           

            //新建参数列表
            SqlParameter parm = new SqlParameter(PARAM_DEVICEID, System.Data.SqlDbType.Int);
            //绑定参数
            parm.Value = deviceid;

            using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sqlSearch, parm))
            {
                while (rdr.Read())
                {
                    OriginalDataInfo oridata = new OriginalDataInfo(rdr.GetInt64(0), rdr.GetInt32(1), rdr.GetDateTime(2), rdr.GetInt32(3), (float)rdr.GetDouble(4));
                    originaldata.Add(oridata);
                }

            }

            return originaldata;
        }
示例#2
0
        /// <summary>
        /// 提取最后N个数据的方法
        /// </summary>
        /// <param name="num"></param>
        /// <returns></returns>
        public IList<OriginalDataInfo> GetTopNDatas(int num)
        {
            IList<OriginalDataInfo> originaldata = new List<OriginalDataInfo>();

            //创建一个新的查询字符串并赋值
            StringBuilder sql = new StringBuilder(SQL_SELECT_TOPN_ORIGINALDATA);
            string sqlSearch = string.Format(sql.ToString(), num);

            using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sqlSearch, null))
            {
                while (rdr.Read())
                {
                    OriginalDataInfo oridata = new OriginalDataInfo(rdr.GetInt64(0), rdr.GetInt32(1), rdr.GetDateTime(2), rdr.GetInt32(3), (float)rdr.GetDouble(4));
                    originaldata.Add(oridata);
                }
            }

            return originaldata;
        }
示例#3
0
        public IList<OriginalDataInfo> GetTopNDatasByDeviceIDAndParamID(int num, int deviceid, int paramid)
        {

            IList<OriginalDataInfo> originaldata = new List<OriginalDataInfo>();

            //创建一个新的查询字符串并赋值
            StringBuilder sql = new StringBuilder(SQL_SELECT_TOPN_ORIGINALDATA_BY_DEVICE_AND_PARAM);
            string sqlSearch = string.Format(sql.ToString(), num);

            SqlParameter[] parms = SqlHelper.GetCachedParameters(sqlSearch);

            // 如果参数为空,创建新的参数
            if (parms == null)
            {
                parms = new SqlParameter[]
                { 
                    new SqlParameter(PARAM_DEVICEID,SqlDbType.Int),
                    new SqlParameter(PARAM_PARAMID,SqlDbType.Int),
                };
                SqlHelper.CacheParameters(sqlSearch, parms);
            }

            // 设置新的参数
            parms[0].Value = deviceid;
            parms[1].Value = paramid;

            using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, sqlSearch, parms))
            {
                while (rdr.Read())
                {
                    OriginalDataInfo oridata = new OriginalDataInfo(rdr.GetInt64(0), rdr.GetInt32(1), rdr.GetDateTime(2), rdr.GetInt32(3), (float)rdr.GetDouble(4));
                    originaldata.Add(oridata);
                }

            }

            return originaldata;
        }
示例#4
0
        /// <summary>
        /// 通过设备id,开始结束时间提取此设备期间内数据的方法
        /// </summary>
        /// <param name="deviceid"></param>
        /// <param name="from"></param>
        /// <param name="to"></param>
        /// <returns></returns>
        public IList<OriginalDataInfo> GetDataByDeviceBetweenTimes(int deviceid, DateTime from, DateTime to)
        {
            IList<OriginalDataInfo> originaldata = new List<OriginalDataInfo>();

            SqlParameter[] parms = SqlHelper.GetCachedParameters(SQL_SELECT_ORIGINALDATA_BY_DEVICEID_BETWEEN_TIMES);

            // 如果参数为空,创建新的参数
            if (parms == null)
            {
                parms = new SqlParameter[]
                { 
                    new SqlParameter(PARAM_DEVICEID,SqlDbType.Int),
                    new SqlParameter(PARAM_DATETIME_FROM,SqlDbType.DateTime),
                    new SqlParameter(PARAM_DATETIME_TO,SqlDbType.DateTime),
                };
                SqlHelper.CacheParameters(SQL_SELECT_ORIGINALDATA_BY_DEVICEID_BETWEEN_TIMES, parms);
            }

            // 设置新的参数
            parms[0].Value = deviceid;
            parms[1].Value = from;
            parms[2].Value = to;

            using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, System.Data.CommandType.Text, SQL_SELECT_ORIGINALDATA_BY_DEVICEID_BETWEEN_TIMES, parms))
            {
                while (rdr.Read())
                {
                    OriginalDataInfo oridata = new OriginalDataInfo(rdr.GetInt64(0), rdr.GetInt32(1), rdr.GetDateTime(2), rdr.GetInt32(3), (float)rdr.GetDouble(4));
                    originaldata.Add(oridata);
                }

            }

            return originaldata;
        }