C# 批量复制文件

using  System;
using  System.Data;
using  System.Configuration;
using  System.Collections;
using  System.Web;
using  System.Web.Security;
using  System.Web.UI;
using  System.Web.UI.WebControls;
using  System.Web.UI.WebControls.WebParts;
using  System.Web.UI.HtmlControls;
using  System.IO;
using  System.Data.SqlClient;

public  partial  class  page_FilesAsEasy : System.Web.UI.Page
{
     protected   void  Page_Load( object  sender, EventArgs e)
    {
        ArrayList arr  =   new  ArrayList();
        SqlConnection conn  =   new  SqlConnection();
        conn.ConnectionString  =   @" Data Source=.\;Initial Catalog=test;User ID=test;Password=test " ;
        conn.Open();
         string  sqlcmd;
        sqlcmd  =   @" select * from test " ;
        SqlCommand cmd  =   new  SqlCommand(sqlcmd, conn);
        SqlDataReader sdr  =  cmd.ExecuteReader();
         while  (sdr.Read())
        {
            FileVO vo  =   new  FileVO();
            vo.Client_Name  =  sdr[ " clientname " ].ToString();
            vo.Client_ID  =  sdr[ " linkshop " ].ToString();
            vo.Category  =  sdr[ " category " ].ToString();
            vo.Filename  =  sdr[ " filename " ].ToString();
            arr.Add(vo);
        }
        sdr.Close();
        conn.Dispose();

        Response.Write( " 开始拷贝文件..<br/><br/> " );
        Response.Flush();

         foreach  ( object  var  in  arr)
        {
             try
            {
                FileVO item  =  (FileVO)var;
                 // 这是经过重新命名的文件的path
                 string  from  =   @" E:\files\ "   +  item.Client_ID.Trim()  +   " _ "   +  item.Category.Trim()  +   " _ "   +  item.Filename.Trim()  +   " .xls " ;
                 string  Category  =   string .Empty;
                 switch  (item.Category)
                {
                     case   " 1 " :
                        Category  =   " 出售 " ;
                         break ;
                     case   " 2 " :
                        Category  =   " 出租 " ;
                         break ;
                     default :
                        Category  =   " 购入 " ;
                         break ;
                }
                 // 重新命名
                 string  to  =   @" F:\xlsdata\ "   +  item.Client_Name.Trim()  +   " _ "   +  Category.Trim()  +   " .xls " ;
                 // 拷贝文件
                File.Copy(from, to,  true );
                 // 设置文件属性
                File.SetAttributes(to, FileAttributes.Normal);
            }
             catch  (Exception ex)
            {
                Response.Write(ex.Message  +   " <br/> " );
                 return ;
            }
        }
        Response.Write( " <br/>拷贝文件结束.. " );
    }
     class  FileVO
    {
         private   string  _Client_ID;
         ///   <summary>
         ///  客户代号
         ///   </summary>
         public   string  Client_ID
        {
             get  {  return  _Client_ID; }
             set  { _Client_ID  =  value; }
        }

         private   string  _Category;
         ///   <summary>
         ///  业务类型
         ///   </summary>
         public   string  Category
        {
             get  {  return  _Category; }
             set  { _Category  =  value; }
        }

         private   string  _Filename;
         ///   <summary>
         ///  文件名
         ///   </summary>
         public   string  Filename
        {
             get  {  return  _Filename; }
             set  { _Filename  =  value; }
        }

         private   string  _Client_Name;
         ///   <summary>
         ///  客户名称
         ///   </summary>
         public   string  Client_Name
        {
             get  {  return  _Client_Name; }
             set  { _Client_Name  =  value; }
        }
    }
}

// 拷贝文件
File.Copy(from, to,  true );
// 设置文件属性
File.SetAttributes(to, FileAttributes.Normal);

The process cannot access the file 'F:\xlsdata\xxx_xxx.xls' because it is being used by another process.