C# SqlHelper.ExecuteReader方法代码示例

       public IList<ReviewInfo> GetReview(ReviewType rt, int ID)
       {
           SqlHelper objSqlHelper = new SqlHelper();
           List<ReviewInfo> reviews = new List<ReviewInfo>();
           SqlParameter[] objParams = new SqlParameter[2];
           objParams[0] = new SqlParameter("@reviewType", SqlDbType.Int, 4);
           objParams[1] = new SqlParameter("@ID", SqlDbType.Int, 4);
           objParams[0].Value = (int)rt;
           objParams[1].Value = ID;
           SqlDataReader reader = objSqlHelper.ExecuteReader("je_Reviews_GetReview", objParams);
           while (reader.Read())
           {
               ReviewInfo item = new ReviewInfo();
               item.ReviewID = reader.GetInt32(reader.GetOrdinal("ReviewID"));
               item.BookID = reader.GetInt32(reader.GetOrdinal("bookID"));
               item.PostIP = reader.GetString(reader.GetOrdinal("postIP"));
               item.PostTime = reader.GetDateTime(reader.GetOrdinal("postTime"));
               item.RateID = reader.GetInt32(reader.GetOrdinal("rate"));
               item.UserName = reader.GetString(reader.GetOrdinal("userName"));
               item.StatusID = reader.GetInt32(reader.GetOrdinal("status"));
               item.Content = reader.GetString(reader.GetOrdinal("content"));
               reviews.Add(item);
           }
           reader.Close();

           return reviews;
       }

        public AddressInfo GetAddressByID()
        {
            SqlHelper objSqlHelper = new SqlHelper();
            SqlParameter[] objParams = new SqlParameter[1];
            objParams[0] = new SqlParameter("@userName", SqlDbType.VarChar);

            objParams[0].Value = GetUserName();
            SqlDataReader reader = objSqlHelper.ExecuteReader("je_Ad_GetAddressByID", objParams);
            AddressInfo item = new AddressInfo();
            while (reader.Read())
            {
                item.UserName = reader.GetString(reader.GetOrdinal("userName"));
                item.AddressName = reader.GetString(reader.GetOrdinal("addressName"));
                item.Address = reader.GetString(reader.GetOrdinal("address"));
                item.Post = reader.GetString(reader.GetOrdinal("Post"));
                item.Telephone = reader.GetString(reader.GetOrdinal("Telephone"));
                item.Province = reader.GetString(reader.GetOrdinal("Province"));
                item.City = reader.GetString(reader.GetOrdinal("City"));
                item.SendType = reader.GetInt32(reader.GetOrdinal("SendType"));
                item.PayType = reader.GetInt32(reader.GetOrdinal("PayType"));
                item.Name = reader.GetString(reader.GetOrdinal("Name"));
                item.Price = reader.GetDecimal(reader.GetOrdinal("Price"));
                item.Balance = reader.GetDecimal(reader.GetOrdinal("Balance"));
            }
            reader.Close();
            return item;
        }

        public IList<FriendLinkInfo> GetLinks(LinkItemType linkType)
        {
            SqlHelper objSqlHelper = new SqlHelper();
            List<FriendLinkInfo> friendlinks = new List<FriendLinkInfo>();
            SqlParameter[] objParams = new SqlParameter[1];
            objParams[0] = new SqlParameter("@linkType", SqlDbType.Int, 4);
            objParams[0].Value = (int)linkType;
            SqlDataReader reader = objSqlHelper.ExecuteReader("je_Link_GetLinks", objParams); ;

            objParams[0].Value = (int)linkType;

            while (reader.Read())
            {
                FriendLinkInfo item = new FriendLinkInfo();
                item.LinkID = reader.GetInt32(reader.GetOrdinal("linkID"));
                item.LinkName = reader.GetString(reader.GetOrdinal("linkName"));
                item.LinkURL = reader.GetString(reader.GetOrdinal("linkURL"));
                item.LinkLogo = reader.GetString(reader.GetOrdinal("linkLogo"));
                item.LinkOrder = reader.GetInt32(reader.GetOrdinal("linkOrder"));
                item.IsMain = reader.GetBoolean(reader.GetOrdinal("linkMain"));
                item.IsArrow = reader.GetBoolean(reader.GetOrdinal("linkArrow"));
                friendlinks.Add(item);
            }
            reader.Close();
            return friendlinks;
        }

 public IList<AddressInfo> GetAddress(int userID)
 {
     SqlHelper objSqlHelper = new SqlHelper();
     List<AddressInfo> Addresss = new List<AddressInfo>();
     SqlParameter[] objParams = new SqlParameter[1];
     objParams[0] = new SqlParameter("@userID", SqlDbType.Int, 4);
     objParams[0].Value = userID;
     SqlDataReader reader = objSqlHelper.ExecuteReader("je_Ad_GetAddress", objParams);
     while (reader.Read())
     {
         AddressInfo item = new AddressInfo();
         item.AddressID = reader.GetInt32(reader.GetOrdinal("addressID"));
         item.AddressName = reader.GetString(reader.GetOrdinal("addressName"));
         item.Address = reader.GetString(reader.GetOrdinal("address"));
         item.Post = reader.GetString(reader.GetOrdinal("Post"));
         item.Telephone = reader.GetString(reader.GetOrdinal("Telephone"));
         item.IsDefault = reader.GetBoolean(reader.GetOrdinal("isDefault"));
         item.Province = reader.GetString(reader.GetOrdinal("Province"));
         item.City = reader.GetString(reader.GetOrdinal("City"));
         item.SendType = reader.GetInt32(reader.GetOrdinal("SendType"));
         item.Name = reader.GetString(reader.GetOrdinal("Name"));
         Addresss.Add(item);
     }
     reader.Close();
     return Addresss;
 }

       public IList<CategoryInfo> GetCategory(CategoryType categoryType, int categoryID)
       {
           SqlHelper objSqlHelper = new SqlHelper();
           
           List<CategoryInfo> categorys = new List<CategoryInfo>();
           SqlParameter[] objParams = new SqlParameter[2];
           objParams[0] = new SqlParameter("@categoryType", SqlDbType.Int, 4);
           objParams[1] = new SqlParameter("@categoryID", SqlDbType.Int, 4);
           objParams[0].Value = (int)categoryType;
           objParams[1].Value = categoryID;

           SqlDataReader reader = objSqlHelper.ExecuteReader("je_Cat_GetCategory", objParams); ;
           while (reader.Read())
           {
               
               CategoryInfo item = new CategoryInfo();
               item.CategoryID = reader.GetInt32(reader.GetOrdinal("categoryID"));
               item.CategoryName = reader.GetString(reader.GetOrdinal("categoryName"));
               item.ParentID = reader.GetInt32(reader.GetOrdinal("parentID"));
               item.IsMain = reader.GetBoolean(reader.GetOrdinal("IsMain"));
               categorys.Add(item);
           }
           reader.Close();
           objSqlHelper.close();
           
           return categorys;
       }

 public BookInfo GetBookByID(int bookID)
 {
     SqlHelper objSqlHelper = new SqlHelper();
     List<BookInfo> books = new List<BookInfo>();
     SqlParameter[] objParams = new SqlParameter[1];
     objParams[0] = new SqlParameter("@bookID", SqlDbType.Int, 4);
     objParams[0].Value = bookID;
     SqlDataReader reader = objSqlHelper.ExecuteReader("je_Book_GetBookByID", objParams);
     BookInfo item = new BookInfo();
     while (reader.Read())
     {
         //图书编号
         item.BookID = reader.GetInt32(reader.GetOrdinal("BookID"));
         //图书名字，分类，价格，会员价格,大图,小图
         item.BookName = reader.GetString(reader.GetOrdinal("BookName"));
         item.Category = reader.GetInt32(reader.GetOrdinal("bookCategory"));
         item.Price = reader.GetDecimal(reader.GetOrdinal("bookPrice"));
         item.MemberPrice = reader.GetDecimal(reader.GetOrdinal("bookMemberPrice"));
         item.BookPublish = reader.GetString(reader.GetOrdinal("BookPublish"));
         item.BookImage = reader.GetString(reader.GetOrdinal("BookImage"));
         item.BookSmallImage = reader.GetString(reader.GetOrdinal("bookSmallImage"));
         //是否发布，是否推荐，是否特价，是否热卖，是否允许评论,库存数量
         item.IsRelease = reader.GetBoolean(reader.GetOrdinal("isRelease"));
         item.IsGood = reader.GetBoolean(reader.GetOrdinal("isGood"));
         item.IsCheap = reader.GetBoolean(reader.GetOrdinal("isCheap"));
         item.IsSaleGood = reader.GetBoolean(reader.GetOrdinal("isSaleGood"));
         item.ReviewEnable = reader.GetBoolean(reader.GetOrdinal("reviewEnable"));
         item.Stock = reader.GetInt32(reader.GetOrdinal("bookStock"));
         //图书简介，作者，出版时间，国际编号，出版社，页数，版次
         item.SmallBookDec = reader.GetString(reader.GetOrdinal("smallBookDesc"));
         item.BookAuthor = reader.GetString(reader.GetOrdinal("bookAuthor"));
         item.PublishTime = reader.GetDateTime(reader.GetOrdinal("bookPublishTime"));
         item.BookISBN = reader.GetString(reader.GetOrdinal("bookISBN"));
         item.BookPublish = reader.GetString(reader.GetOrdinal("bookPublish"));
         item.BookPages = reader.GetInt32(reader.GetOrdinal("bookPages"));
         item.BookEditions = reader.GetString(reader.GetOrdinal("bookEditions"));
         //是否为期书,搜索关键字,加入时间,具体介绍
         item.IsExpect = reader.GetBoolean(reader.GetOrdinal("isExpect"));
         item.SearchKey = reader.GetString(reader.GetOrdinal("searchKey"));
         item.BookDec = reader.GetString(reader.GetOrdinal("BookDec"));
         item.ReadCount = reader.GetInt32(reader.GetOrdinal("bookReadCount"));
         item.ReviewCount = reader.GetInt32(reader.GetOrdinal("bookCommentCount"));
         //
         item.TeacherID = reader.GetInt32(reader.GetOrdinal("TeacherID"));
         item.CatenaID = reader.GetInt32(reader.GetOrdinal("CatenaID"));
         item.Rate = reader.GetDecimal(reader.GetOrdinal("bookRate"));
         //折扣，团队折扣，团队价格
         item.Rebate = reader.GetInt32(reader.GetOrdinal("Rebate"));
         item.VipRebate = reader.GetInt32(reader.GetOrdinal("VipRebate"));
         item.VipPrice = reader.GetDecimal(reader.GetOrdinal("VipPrice"));
         item.IsMain = reader.GetBoolean(reader.GetOrdinal("IsMain"));
     }
     reader.Close();
     return item;
 }

 /// <summary>
 /// 获取今日订单信息
 /// </summary>
 /// <returns></returns>
 public IList<OrdersInfo> GetTodayOrders()
 {
     SqlHelper objSqlHelper = new SqlHelper();
     List<OrdersInfo> orders = new List<OrdersInfo>();
     SqlDataReader reader = objSqlHelper.ExecuteReader("je_Order_GetTodayOrders");
     while (reader.Read())
     {
         OrdersInfo item = GetOrdersByID(reader.GetInt64(reader.GetOrdinal("OrderID")));
         orders.Add(item);
     }
     reader.Close();
     return orders;
 }

 public IList<EmailFormatInfo> GetEmailFormat()
 {
     SqlHelper objSqlHelper = new SqlHelper();
     List<EmailFormatInfo> emails = new List<EmailFormatInfo>();
     SqlDataReader reader = objSqlHelper.ExecuteReader("je_Email_GetEmailFormat");
     while (reader.Read())
     {
         EmailFormatInfo item =GetEmailFormatByID( reader.GetInt32(reader.GetOrdinal("ID")));
         emails.Add(item);
     }
     reader.Close();
     return emails;
 }

 public List<string> GetAllName()
 {
     List<string> allName = new List<string>();
     SqlHelper helper = new SqlHelper();
     var Reader = helper.ExecuteReader("P_GetAllName");
     while (Reader.Read())
     {
         allName.Add(Reader["Name"].ToString());
     }
     if (!Reader.IsClosed)
         Reader.Close();
     return allName;
 }

 public IList<PollInfo> GetPoll()
 {
     SqlHelper objSqlHelper = new SqlHelper();
     List<PollInfo> pl = new List<PollInfo>();
     SqlDataReader reader = objSqlHelper.ExecuteReader("je_Poll_GetPoll");
     while (reader.Read())
     {
         PollInfo item = GetPollByID(reader.GetInt32(reader.GetOrdinal("PollID")));
         pl.Add(item);
     }
     reader.Close();
     return pl;
 }

 public IList<PublishInfo> GetMainPublishs()
 {
     SqlHelper objSqlHelper = new SqlHelper();
     List<PublishInfo> publishs = new List<PublishInfo>();
     SqlDataReader reader = objSqlHelper.ExecuteReader("je_Pb_GetMainPublishs");
     while (reader.Read())
     {
         PublishInfo item = GetPublishByID(reader.GetInt32(reader.GetOrdinal("publishID")));
         publishs.Add(item);
     }
     reader.Close();
     return publishs;
 }

 public IList<HelpClassInfo> GetMainHelpClass()
 {
     SqlHelper objSqlHelper = new SqlHelper();
     List<HelpClassInfo> helpClass = new List<HelpClassInfo>();
     SqlDataReader reader = objSqlHelper.ExecuteReader("je_HC_GetMainHelpClass");
     while (reader.Read())
     {
         HelpClassInfo item = GetHelpClassByID(reader.GetInt32(reader.GetOrdinal("ClassID")));
         helpClass.Add(item);
     }
     reader.Close();
     return helpClass;
 }

  /// <summary>
  /// 获取下载排行
  /// </summary>
  /// <returns></returns>
 public IList<DownLoadInfo> GetTopDownLoad()
 {
     SqlHelper objSqlHelper = new SqlHelper();
     List<DownLoadInfo> downLoads = new List<DownLoadInfo>();
     SqlDataReader reader = objSqlHelper.ExecuteReader("je_DL_GetTopDownLoad");
     while (reader.Read())
     {
         DownLoadInfo item = GetDownLoadByID(reader.GetInt32(reader.GetOrdinal("DownID")));
         downLoads.Add(item);
     }
     reader.Close();
     return downLoads;
 }

 public IList<SendAreaInfo> GetSendArea()
 {
     SqlHelper objSqlHelper = new SqlHelper();
     List<SendAreaInfo> sendAreas = new List<SendAreaInfo>();
     SqlDataReader reader = objSqlHelper.ExecuteReader("je_Area_GetArea");
     while (reader.Read())
     {
         SendAreaInfo item = GetSendAreaByID(reader.GetInt32(reader.GetOrdinal("AreaID")));
         sendAreas.Add(item);
     }
     reader.Close();
     return sendAreas;
 }

 public IList<HelpInfo> GetHelp()
   {
     
       SqlHelper objSqlHelper = new SqlHelper();
       List<HelpInfo> helps = new List<HelpInfo>();
       SqlDataReader reader = objSqlHelper.ExecuteReader("je_Help_GetHelp");
       while (reader.Read())
       {
           HelpInfo item = GetHelpByID(reader.GetInt32(reader.GetOrdinal("helpID")));
           helps.Add(item);
       }
       reader.Close();
       return helps;
   }