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.