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個文件信息