using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data;
using?Wuqi.Webdiyer;

namespace?BLL
{
????///?

????///?業(yè)務(wù)邏輯層
????///?

????public?class?Business
????{
????????///?

????????///?驗證登陸用戶
????????///?

????????///?
????????///?
????????public?DataTable?DtRead（Model.Admin?User）
????????{
????????????string?sql?=?“select?*?from?[Admin]?where?Admin_Name?=?‘“?+?User.AdminName?+?“‘?and?Admin_Pwd=?‘“?+?User.AdminPwd?+?“‘“;
????????????DAL.Database?Pn163?=?new?DAL.Database（）;
????????????return?Pn163.GetDataTable（sql）;
????????}

????????///?

????????///?判斷管理用戶名是否重復(fù)
????????///?

????????///?
????????///?
????????public?bool?ReadAdmin（string?Admin）
????????{
????????????string?sql?=?“select?*?from?[Admin]?where?Admin_Name=?‘“?+?Admin?+?“‘“;
????????????DAL.Database?Pn163?=?new?DAL.Database（）;
????????????DataTable?Dt?=?Pn163.GetDataTable（sql）;
????????????if?（Dt.Rows.Count?>?0）
????????????{
????????????????return?true;
????????????}
????????????else?return?false;
????????}

????????///?

????????///?判斷文檔名稱是否重復(fù)
????????///?

????????///?
????????///?
????????public?bool?ReadDocName（string?DocName）
????????{
????????????string?sql?=?“select?*?from?[anomaly_doc]?where?DocName=?‘“?+?DocName?+?“‘“;
????????????DAL.Database?Pn163?=?new?DAL.Database（）;
????????????DataTable?Dt?=?Pn163.GetDataTable（sql）;
????????????if?（Dt.Rows.Count?>?0）
????????????{
????????????????return?true;
????????????}
????????????else?return?false;
????????}

????????///?

????????///?添加文檔
????????///?

????????///?傳入數(shù)據(jù)實體
????????///?
????????public?int?AddDoc（Model.Document?User）
????????{
????????????string?sql?=?“Insert?Into?[anomaly_doc]（DocName[anomaly_writer]dept_sumitupload_timeinvest_datestore_docabstract[DownUrl]SizeMemoAdderanomaly_typeexist_timeanomaly_investeranomaly_Conclstart_timedateAnomaly_address）?values（‘“
????????????????+?User.DocName?+?“‘‘“
????????????????+?User.DocWriter?+?“‘‘“
????????????????+?User.DocSumit?+?“‘‘“
????????????????+?User.DocUpTime?+?“‘‘“
????????????????+?User.DocInvTime?+?“‘‘“
????????????????+?User.DocStore?+?“‘‘“
????????????????+?User.Abstract?+?“‘‘“
????????????????+?User.DownUrl?+?“‘‘“
????????????????+?User.Size?+?“‘‘“
????????????????+?User.Memo?+?“‘‘“
????????????????+?User.Adder?+?“‘‘“
????????????????+?User.Type?+?“‘‘“
????????????????+?User.Exist?+?“‘‘“
????????????????+?User.Invester?+?“‘‘“
????????????????+?User.Concl?+?“‘‘“
????????????????+?User.Start?+?“‘‘“
????????????????+?User.Date?+?“‘‘“
????????????????+?User.address?+?“‘）“;
????????????DAL.Database?Pn163?=?new?DAL.Database（）;
????????????return?Pn163

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件?????110592??2008-01-26?22:17??dadaDocument\BLL\bin\Debug\AspNetPager.dll

?????文件??????15360??2009-01-05?23:53??dadaDocument\BLL\bin\Debug\BLL.dll

?????文件??????30208??2009-01-05?23:53??dadaDocument\BLL\bin\Debug\BLL.pdb

?????文件???????6144??2008-12-20?12:37??dadaDocument\BLL\bin\Debug\DAL.dll

?????文件??????15872??2008-12-20?12:37??dadaDocument\BLL\bin\Debug\DAL.pdb

?????文件?????122880??2006-02-09?20:35??dadaDocument\BLL\bin\Debug\MagicAjax.dll

?????文件???????9216??2008-12-20?12:36??dadaDocument\BLL\bin\Debug\Model.dll

?????文件??????40448??2008-12-20?12:36??dadaDocument\BLL\bin\Debug\Model.pdb

?????文件???????3099??2008-07-19?10:26??dadaDocument\BLL\BLL.csproj

?????文件???????9860??2008-12-20?20:23??dadaDocument\BLL\Business.cs

?????文件???????4016??2009-06-19?09:54??dadaDocument\BLL\Message.cs

?????文件????????503??2008-12-20?12:29??dadaDocument\BLL\obj\Debug\BLL.csproj.FileListAbsolute.txt

?????文件??????15360??2009-01-05?23:53??dadaDocument\BLL\obj\Debug\BLL.dll

?????文件??????30208??2009-01-05?23:53??dadaDocument\BLL\obj\Debug\BLL.pdb

?????文件??????19452??2009-06-19?09:43??dadaDocument\BLL\obj\Debug\ResolveAssemblyReference.cache

?????文件???????1362??2008-06-30?18:26??dadaDocument\BLL\Properties\AssemblyInfo.cs

?????文件???????5118??2009-01-05?23:52??dadaDocument\BLL\Search.cs

?????文件????????515??2008-07-02?13:01??dadaDocument\BLL\ve-AA.tmp

?????文件?????110592??2008-01-26?22:17??dadaDocument\DAL\bin\Debug\AspNetPager.dll

?????文件???????6144??2008-12-20?12:37??dadaDocument\DAL\bin\Debug\DAL.dll

?????文件??????15872??2008-12-20?12:37??dadaDocument\DAL\bin\Debug\DAL.pdb

?????文件???????9216??2008-12-20?12:36??dadaDocument\DAL\bin\Debug\Model.dll

?????文件??????40448??2008-12-20?12:36??dadaDocument\DAL\bin\Debug\Model.pdb

?????文件???????2655??2008-07-20?14:32??dadaDocument\DAL\DAL.csproj

?????文件???????4500??2008-07-31?11:48??dadaDocument\DAL\Database.cs

?????文件????????371??2008-07-20?14:32??dadaDocument\DAL\obj\Debug\DAL.csproj.FileListAbsolute.txt

?????文件???????6144??2008-12-20?12:37??dadaDocument\DAL\obj\Debug\DAL.dll

?????文件??????15872??2008-12-20?12:37??dadaDocument\DAL\obj\Debug\DAL.pdb

?????文件???????7511??2008-12-20?12:37??dadaDocument\DAL\obj\Debug\ResolveAssemblyReference.cache

?????文件???????1362??2008-06-30?18:25??dadaDocument\DAL\Properties\AssemblyInfo.cs

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