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?????????????{
????????????????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??PictureManager\BLL\bin\Debug\COM.Excel.dll

?????文件????1089536??2012-02-02?18:56??PictureManager\BLL\bin\Debug\Excel.dll

?????文件?????102400??2012-02-02?18:56??PictureManager\BLL\bin\Debug\IBatisNet.Common.dll

?????文件?????249856??2012-02-02?18:56??PictureManager\BLL\bin\Debug\IBatisNet.DataMapper.dll

?????文件??????64088??2007-10-10?09:48??PictureManager\BLL\bin\Debug\Microsoft.Vbe.Interop.dll

?????文件?????369152??2012-02-02?18:56??PictureManager\BLL\bin\Debug\MySql.Data.dll

?????文件?????223800??2007-10-10?09:48??PictureManager\BLL\bin\Debug\office.dll

?????文件??????45056??2012-02-02?18:56??PictureManager\BLL\bin\Debug\OpenSmtp.dll

?????文件??????24576??2012-09-13?17:36??PictureManager\BLL\bin\Debug\PictureManager.BLL.dll

?????文件??????42496??2012-09-13?17:36??PictureManager\BLL\bin\Debug\PictureManager.BLL.pdb

?????文件??????61440??2012-09-13?17:36??PictureManager\BLL\bin\Debug\PictureManager.Common.dll

?????文件?????126464??2012-09-13?17:36??PictureManager\BLL\bin\Debug\PictureManager.Common.pdb

?????文件??????36864??2012-09-13?17:36??PictureManager\BLL\bin\Debug\PictureManager.DAL.dll

?????文件??????46592??2012-09-13?17:36??PictureManager\BLL\bin\Debug\PictureManager.DAL.pdb

?????文件??????65536??2012-09-13?17:36??PictureManager\BLL\bin\Debug\PictureManager.DBUtility.dll

?????文件?????177664??2012-09-13?17:36??PictureManager\BLL\bin\Debug\PictureManager.DBUtility.pdb

?????文件??????20480??2012-09-13?17:36??PictureManager\BLL\bin\Debug\PictureManager.Model.dll

?????文件??????30208??2012-09-13?17:36??PictureManager\BLL\bin\Debug\PictureManager.Model.pdb

?????文件?????847872??2012-02-02?18:56??PictureManager\BLL\bin\Debug\System.Data.SQLite.dll

?????文件???????6829??2012-09-12?14:12??PictureManager\BLL\BLL.csproj

?????文件???????2543??2012-02-02?18:56??PictureManager\BLL\BLL.csproj.user

?????文件???????3395??2012-09-13?14:25??PictureManager\BLL\CommonlyUsed.cs

?????文件???????4770??2012-09-12?15:17??PictureManager\BLL\ImageClass.cs

?????文件???????5181??2012-09-12?13:57??PictureManager\BLL\Images.cs

?????文件???????2756??2012-09-13?17:36??PictureManager\BLL\obj\Debug\BLL.csproj.FileListAbsolute.txt

?????文件??????24576??2012-09-13?17:36??PictureManager\BLL\obj\Debug\PictureManager.BLL.dll

?????文件??????42496??2012-09-13?17:36??PictureManager\BLL\obj\Debug\PictureManager.BLL.pdb

?????文件??????51666??2012-09-13?17:36??PictureManager\BLL\obj\Debug\ResolveAssemblyReference.cache

?????文件????????626??2012-09-12?13:57??PictureManager\BLL\Properties\AssemblyInfo.cs

?????文件???????1641??2012-09-12?13:57??PictureManager\BLL\SysManage.cs

............此處省略447個文件信息