示例#1
0
        /// <summary>
        /// 获取数据列表 带参数化
        /// </summary>
        /// <typeparam name="T">实体</typeparam>
        /// <param name="commandText">SQL语句</param>
        /// <param name="countTable">分页获取总数的表名及条件</param>
        /// <returns></returns>
        public List <T> GetList <T>(string commandText, UtilityPager utilityPager = null, string countTable = null, SqlParameter[] parmarr = null) where T : BaseTO, new()
        {
            MSSQLSqlHelper db   = new MSSQLSqlHelper(connectionkey);
            List <T>       list = new List <T>();

            //是否需要分页
            if (utilityPager != null)
            {
                string sqlcount = string.Format("select count(*) from {0}", countTable);
                utilityPager.Count = int.Parse(db.ExecuteScalar(sqlcount, CommandType.Text, parmarr).ToString());
                commandText        = PagingAll(commandText, utilityPager.PageIndex, utilityPager.PageSize);
            }
            using (SqlDataReader reader = db.ExecuteReader(commandText, CommandType.Text, parmarr))
            {
                if (reader.HasRows)
                {
                    while (reader.Read())
                    {
                        T to = new T();
                        to.Initialize(reader);
                        list.Add(to);
                    }
                }
            }
            return(list);
        }
示例#2
0
        /// <summary>
        /// 返回结果中第一行第一列结果
        /// </summary>
        /// <param name="commandText">SQL语句</param>
        /// <returns></returns>
        public object GetUniqueResult(string commandText)
        {
            MSSQLSqlHelper db = new MSSQLSqlHelper(connectionkey);

            return(db.ExecuteScalar(commandText));
        }