<script runat="server">
   
            protected System.Data.SqlClient.SqlConnection Sqlconn;
            protected System.Data.SqlClient.SqlCommand sqlCmd;

            private int Id;
            private string VideoFilePath;    //目标视频文件全路径
            private string ImgFilePath;        //图片文件文件全路径
            private string ImgFileDir;        //图片文件所在路径
            private string VideoFileName;   //目标视频文件名称
            private string ImgFileName;     //图片文件名称
            private string ImgFileExtName;   //图片文件括展名
           

            /// <summary>
            /// 获取数据库连接
            /// </summary>
            public static SqlConnection Instance
            {
                get
                {
                    //获取连接字符串并返回连接对象
                    string sqlStr = "Server=127.0.0.1; uid=sa; pwd=000000; DataBase=show5";
                    return new SqlConnection(sqlStr);
                }
            }
           
           
            /// <summary>
            /// 开始执行重命名文件名
            /// </summary>
            /// <param name="sender"></param>
            /// <param name="e"></param>
            protected void btnGo_Click(object sender, EventArgs e)
            {
                int StarID = Int32.Parse(this.txtStartID.Text);
                int EndID = Int32.Parse(this.txtEndID.Text);

                #region 构造 SQL 语句

                string cmdText = "select 目标视频文件,图片文件, Id from 队列 Where Id>=" + StarID + " and Id<=" + EndID + " order by Id";

                SqlConnection sqlConn = Instance;
                SqlCommand sqlCmd = new SqlCommand(cmdText, sqlConn);
                sqlCmd.CommandType = CommandType.Text;

                #endregion

                try
                {
                    sqlConn.Open();
                    SqlDataReader dr = sqlCmd.ExecuteReader();

                    while (dr.Read())
                    {
                        Id = Int32.Parse(dr["Id"].ToString());
                        VideoFilePath = dr["目标视频文件"].ToString();   //读取目标视频文件地址
                        ImgFilePath = dr["图片文件"].ToString().Replace(",", "");   //读取图片文件

                        //检查目标视频文件及图片文件是否存在，如其中有一个不存在则不进行重命名操作
                        if (this.CheckFile(VideoFilePath) == true && this.CheckFile(ImgFilePath) == true)
                        {
                            VideoFileName = System.IO.Path.GetFileNameWithoutExtension(VideoFilePath);  //获取视频文件文件名，不包扩展名
                            ImgFileDir = System.IO.Path.GetDirectoryName(ImgFilePath) + "/";      //获取图片所在目录
                            ImgFileName = System.IO.Path.GetFileNameWithoutExtension(ImgFilePath);  //获取图片文件名，不包扩展名
                            ImgFileExtName = System.IO.Path.GetExtension(ImgFilePath);  //获取图片文件括展名

                            System.IO.File.Move(ImgFilePath, ImgFileDir + VideoFileName + ImgFileExtName);

                            #region 构造 SQL 语句

                            string cmdText2 = "UPDATE 队列 SET 图片文件 = '" + ImgFileDir + VideoFileName + ImgFileExtName + "," + "' WHERE Id =" + Id + "";

                            SqlConnection sqlConn2 = Instance;
                            SqlCommand sqlCmd2 = new SqlCommand(cmdText2, sqlConn2);
                            sqlCmd2.CommandType = CommandType.Text;

                            #endregion

                            try
                            {
                                sqlConn2.Open();
                                sqlCmd2.ExecuteNonQuery();
                            }
                            catch (Exception ex)
                            {
                                throw ex;
                            }
                            finally
                            {
                                sqlConn2.Close();
                            }
                        }
                    }

                    lblMsg.Text = "处理完毕";

                }
                catch (Exception ex)
                {
                    throw ex;
                }
                finally
                {
                    sqlConn.Close();
                }
            }

            /// <summary>
            /// 检查文件是否存在，返回真假傎
            /// </summary>
            /// <param name="FileUrl">文件地址</param>
            /// <returns></returns>
            private bool CheckFile(string FileUrl)
            {
                if (System.IO.File.Exists(FileUrl))
                {
                    return true;
                }
                return false;
            }
           
        </script>

       
    </form>
</body>
</html>