三层业务类（DAL）必用的通用方法之一

Myth丶恋晨 2024-02-18 19:53 23阅读 0赞

写代码有两年多的时间了，越来越觉得代码的通用性是衡量一个程序员的标准。

![ContractedBlock.gif][] ![ExpandedBlockStart.gif][] 代码

#region
        
        
          SqlDataReader => List
        
        
         
    
        
        
         ///
        
        
          
        
        
         <summary>
        
        
         
    
        
        
         ///
        
        
          author:Stone_W
    
        
        
         ///
        
        
          date:2010.11.29
    
        
        
         ///
        
        
          desc:SqlDataReader 转 List
    
        
        
         ///
        
        
          
        
        
         </summary>
        
        
         
    
        
        
         ///
        
        
          
        
        
         <param name="dr">
        
        
         SqlDataReader
        
        
         </param>
        
        
         
    
        
        
         ///
        
        
          
        
        
         <returns>
        
        
         List
        
        
         </returns>
        
        
         
    
        
        
         private
        
        
          
        
        
         static
        
        
          List
        
        
         <
        
        
         object
        
        
         >
        
        
          sqlDrToList(SqlDataReader dr)
    {
          
        List
        
        
         <
        
        
         object
        
        
         >
        
        
          list 
        
        
         =
        
        
          
        
        
         null
        
        
         ;
        
        
        
         if
        
        
          (
        
        
         null
        
        
          
        
        
         !=
        
        
          dr)
        {
          
            list 
        
        
         =
        
        
          
        
        
         new
        
        
          List
        
        
         <
        
        
         object
        
        
         >
        
        
         ();
            
        
        
         object
        
        
          obj
        
        
         ;
            
        
        
         try
        
        
         
            {
          
                
        
        
         while
        
        
          (dr.Read())
                {
          
                    ... 
        
        
         //
        
        
          业务
        
        
         
    
        
        
                     }
            }
            
        
        
         catch
        
        
          (Exception ex) { }
            
        
        
         finally
        
        
         
            {
          
                
        
        
         if
        
        
          (
        
        
         null
        
        
          
        
        
         !=
        
        
          dr 
        
        
         &&
        
        
          dr.IsClosed 
        
        
         ==
        
        
          
        
        
         false
        
        
         )
                {
          
                    dr.Close();
                }
            }
        }
        
        
        
         return
        
        
          list;
    }
    
        
        
         #endregion

[ContractedBlock.gif]: https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif
[ExpandedBlockStart.gif]: https://image.dandelioncloud.cn/pgy_files/images/2024/01/29/af1861486ce94e769497cb1b70b94f7f.png