仿淘宝图片空间自己做的一个图片管理小系统

using System;
using System.Data;
using System.Collections.Generic;
using Maticsoft.Common;
using PictureManager.Model;
using System.Data.SqlClient;
namespace PictureManager.BLL
{
    /// 

    /// UserTable
    /// 

    public partial class CommonlyUsed
    {
        private readonly PictureManager.DAL.CommonlyUsed dal = new PictureManager.DAL.CommonlyUsed（）;
        public CommonlyUsed（）
        { }
        #region  Method


        public DataSet Query（string sql SqlParameter par）
        {
            return dal.Query（sql par）;
        }
        public DataSet Query（string sql）
        {
            return dal.Query（sql）;
        }
        public int GetRecordCount（string sql）
        {
            return dal.GetRecordCount（sql）;
           
        }
        /// 

        /// 返回页面序号列表链接
        /// 

        /// 链接的目的
        /// 总页数
        /// 当前页数
        /// 字符串类型
        public string ShowPageList（string funClick int countNum int currentPage）
        {
            int stepNum = 9;
            int pageRoot = 1;
            string pageStr = ““;
            pageStr = ““;
            if （currentPage - stepNum > 1）
            {
                pageRoot = currentPage - stepNum;
            }
            int pageFoot = countNum;
            if （currentPage + stepNum < countNum）
            {
                pageFoot = currentPage + stepNum;
            }
            if （pageRoot == 1）
            {
                if （currentPage == 1）
                {
                    pageStr += “<  “;
                }
                else
                {
                    pageStr += “tle=‘上页‘>< “;
                }
            }
            else
            {
                pageStr += “tle=‘上页‘><...“;
            }
            for （int i = pageRoot; i <= pageFoot; i++）
            {
                if （i == currentPage）
                {
                    pageStr += ““ + i.ToString（） + ““;
                }
                else
                {
                    pageStr += ““ + i.ToString（） + ““;
                }
                if （i == countNum）
                    break;
            }
            if （pageFoot == countNum）
            {
                if （countNum == currentPage）
                {
                    pageStr += “> “;
                }
                else
                {
                    pageStr += “tle=‘下页‘>>

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件      15360  2012-02-02 18:56  PictureManagerBLLinDebugCOM.Excel.dll

     文件    1089536  2012-02-02 18:56  PictureManagerBLLinDebugExcel.dll

     文件     102400  2012-02-02 18:56  PictureManagerBLLinDebugIBatisNet.Common.dll

     文件     249856  2012-02-02 18:56  PictureManagerBLLinDebugIBatisNet.DataMapper.dll

     文件      64088  2007-10-10 09:48  PictureManagerBLLinDebugMicrosoft.Vbe.Interop.dll

     文件     369152  2012-02-02 18:56  PictureManagerBLLinDebugMySql.Data.dll

     文件     223800  2007-10-10 09:48  PictureManagerBLLinDebugoffice.dll

     文件      45056  2012-02-02 18:56  PictureManagerBLLinDebugOpenSmtp.dll

     文件      24576  2012-09-13 17:36  PictureManagerBLLinDebugPictureManager.BLL.dll

     文件      42496  2012-09-13 17:36  PictureManagerBLLinDebugPictureManager.BLL.pdb

     文件      61440  2012-09-13 17:36  PictureManagerBLLinDebugPictureManager.Common.dll

     文件     126464  2012-09-13 17:36  PictureManagerBLLinDebugPictureManager.Common.pdb

     文件      36864  2012-09-13 17:36  PictureManagerBLLinDebugPictureManager.DAL.dll

     文件      46592  2012-09-13 17:36  PictureManagerBLLinDebugPictureManager.DAL.pdb

     文件      65536  2012-09-13 17:36  PictureManagerBLLinDebugPictureManager.DBUtility.dll

     文件     177664  2012-09-13 17:36  PictureManagerBLLinDebugPictureManager.DBUtility.pdb

     文件      20480  2012-09-13 17:36  PictureManagerBLLinDebugPictureManager.Model.dll

     文件      30208  2012-09-13 17:36  PictureManagerBLLinDebugPictureManager.Model.pdb

     文件     847872  2012-02-02 18:56  PictureManagerBLLinDebugSystem.Data.SQLite.dll

     文件       6829  2012-09-12 14:12  PictureManagerBLLBLL.csproj

     文件       2543  2012-02-02 18:56  PictureManagerBLLBLL.csproj.user

     文件       3395  2012-09-13 14:25  PictureManagerBLLCommonlyUsed.cs

     文件       4770  2012-09-12 15:17  PictureManagerBLLImageClass.cs

     文件       5181  2012-09-12 13:57  PictureManagerBLLImages.cs

     文件       2756  2012-09-13 17:36  PictureManagerBLLobjDebugBLL.csproj.FileListAbsolute.txt

     文件      24576  2012-09-13 17:36  PictureManagerBLLobjDebugPictureManager.BLL.dll

     文件      42496  2012-09-13 17:36  PictureManagerBLLobjDebugPictureManager.BLL.pdb

     文件      51666  2012-09-13 17:36  PictureManagerBLLobjDebugResolveAssemblyReference.cache

     文件        626  2012-09-12 13:57  PictureManagerBLLPropertiesAssemblyInfo.cs

     文件       1641  2012-09-12 13:57  PictureManagerBLLSysManage.cs

............此处省略447个文件信息