购物商城系统源码版

购物商城系统源码版，尽供大家学习使用，如有商用请与版权公司联系。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Collections;

namespace ChangeHope.Database
{
    /// 

    /// 分页程序
    /// 

    public class DataByPage
    {
        private string sql;
        private int pageSize=15;

        private string query;
        private string table;
        private string where;
        private string order;
        private string orderDesc;
        private int recordCount=0;
        private int pageCount = 0;
        private string orderby = ““;

        
        private int pageIndex = 0;
        private System.Data.SqlClient.SqlDataReader recordSet;
        private Hashtable para;
        private string pageToolBar = ““;
        private string receptionToolBar = ““;

        public string OrderBy
        {
            get { return orderby; }
            set { orderby = value; }
        }
        
        public int PageCount
        {
            get { return pageCount;}
            set { pageCount = value;}
        }

        public string Sql
        {
            get { return sql; }
            set { sql = value; }
        }

        public int PageSize
        {
            get { return pageSize; }
            set { pageSize = value; }
        }

        public System.Data.SqlClient.SqlDataReader DataReader
        {
            get { return recordSet; }
        }

        public int PageIndex
        {
            get { return pageIndex; }
            set { pageIndex = value; }
        }

        public string PageToolBar
        {
            get { return pageToolBar; }
            set { pageToolBar = value; }
        }

        public string ReceptionToolBar
        {
            get { return receptionToolBar; }
            set { receptionToolBar = value; }
        }

        public void GetRecordSetByPage（）
        {
            GetPara（）;
            SplitSql（）;
            DescOrder（）;
            GetCount（）;
            
            GetPageCount（）;
            GetToolBar（）;
            ReceptionGetToolBar（）;
            GetRecordSet（）;
        }
        public void GetRecordFreelabelByPage（）
        {
            GetPara（）;
            SplitSqlFreelabel（）;
            DescOrder（）;
            GetCount（）;

            GetPageCount（）;
            GetToolBar（）;
            ReceptionGetToolBar（）;
            GetRecordSet（）;
        }
        private string GetWhere（）
        {
            StringBuilder sqlWhere = new StringBuilder（）;
            int postion = 0;
            string key = ““;
            string value = ““;
            foreach （DictionaryEntry de in para）
            {
                key = de.Key.ToString（）;
                value = de.Value.ToString（）;
                //大于
                postion = key.ToString（）.IndexOf（“w_g_“）;
                if （postion >= 0）
                

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

     文件    5234176  2009-12-21 14:43  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Database_V4.6\YXShop_V4.6_Database

     目录          0  2009-12-21 14:58  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Database_V4.6

     文件      58368  2009-12-21 14:44  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\bin\Debug\ChangeHope.dll

     文件     210432  2009-12-21 14:44  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\bin\Debug\ChangeHope.pdb

     文件     217088  2009-12-21 14:44  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\bin\Debug\ICSharpCode.SharpZipLib.dll

     文件     777728  2009-12-21 14:44  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\bin\Debug\ICSharpCode.SharpZipLib.pdb

     文件     950272  2009-05-03 17:20  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\bin\Debug\Interop.SQLDMO.dll

     目录          0  2009-12-21 14:44  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\bin\Debug

     目录          0  2009-12-21 14:42  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\bin

     文件      14812  2009-09-22 17:03  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\ChangeHope\Database\DataByPage.cs

     文件       3069  2009-09-22 17:03  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\ChangeHope\Database\DataHelper.cs

     文件      22529  2009-09-22 17:03  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\ChangeHope\Database\SQLServerHelper.cs

    ..A.SH.       183  2009-09-29 16:05  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\ChangeHope\Database\vssver2.scc

     目录          0  2009-12-21 14:42  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\ChangeHope\Database

     目录          0  2009-12-21 14:42  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\ChangeHope

     文件       4265  2009-12-21 14:33  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\ChangeHope.csproj

     文件        168  2009-11-19 14:52  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\ChangeHope.csproj.user

     文件        276  2009-10-19 09:28  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\ChangeHope.csproj.vspscc

     文件       2015  2009-11-12 17:32  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\Common\Cookies.cs

     文件       6885  2009-08-04 10:58  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\Common\DEncryptHelper.cs

     文件       6554  2009-08-04 10:58  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\Common\EncodeHelper.cs

     文件      11818  2009-11-21 14:06  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\Common\FileHelper.cs

     文件       2514  2009-08-04 10:58  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\Common\ImagesHelper.cs

     文件       3304  2009-12-07 15:11  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\Common\NetWorkHelper.cs

     文件        830  2009-11-16 09:57  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\Common\PrompteMessageHelper .cs

     文件       2869  2009-10-12 10:28  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\Common\ServerInfo.cs

     文件       1248  2009-08-04 10:58  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\Common\SortHelper.cs

     文件       8594  2009-11-09 16:54  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\Common\StringHelper.cs

     文件       6443  2009-12-21 11:56  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\Common\UploadFile.cs

     文件      22124  2009-12-21 12:07  ChangeHope_YxShop_Sourcee_V4.6\YxShop_Sourcee_V4.6\ChangeHope\Common\UploadProcesedImages.cs

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