using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?Utility;
using?System.Data.SqlClient;
using?System.Data;
using?Model;

namespace?DAL
{
????///?

????///?數據訪問類:Articles
????///?

????public?class?Articles
????{
????????#region?Constructors

????????public?Articles（）
????????{?}

????????#endregion


????????#region??Public?Methods

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

????????///?得到最大ID
????????///?

????????public?int?GetMaxId（）
????????{
????????????return?DbHelperSQL.GetMaxID（“ArtId“?“Articles“）;
????????}

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

????????///?是否存在該記錄
????????///?

????????public?bool?Exists（int?ArtId）
????????{
????????????StringBuilder?strSql?=?new?StringBuilder（）;
????????????strSql.Append（“select?count（1）?from?Articles“）;
????????????strSql.Append（“?where?ArtId=@ArtId“）;
????????????SqlParameter[]?parameters?=?{
					new?SqlParameter（“@ArtId“?SqlDbType.Int4）
};
????????????parameters[0].Value?=?ArtId;

????????????return?DbHelperSQL.Exists（strSql.ToString（）?parameters）;
????????}


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

????????///?增加一條數據
????????///?

????????public?int?Add（Model.Articles?model）
????????{
????????????StringBuilder?strSql?=?new?StringBuilder（）;
????????????strSql.Append（“insert?into?Articles（“）;
????????????strSql.Append（“LemIdtitleInformationCreateTimeUserNameScanTimesIP）“）;
????????????strSql.Append（“?values?（“）;
????????????strSql.Append（“@LemId@title@Information@CreateTime@UserName@ScanTimes@IP）“）;
????????????strSql.Append（“;select?@@IDENTITY“）;
????????????SqlParameter[]?parameters?=?{
					new?SqlParameter（“@LemId“?SqlDbType.Int4）
					new?SqlParameter（“@title“?SqlDbType.VarChar200）
					new?SqlParameter（“@Information“?SqlDbType.Text）
					new?SqlParameter（“@CreateTime“?SqlDbType.DateTime）
					new?SqlParameter（“@UserName“?SqlDbType.VarChar50）
					new?SqlParameter（“@ScanTimes“?SqlDbType.Int4）
					new?SqlParameter（“@IP“?SqlDbType.Char15）};
????????????parameters[0].Value?=?model.LemId;
????????????parameters[1].Value?=?model.title;
????????????parameters[2].Value?=?model.Information;
????????????parameters[3].Value?=?model.CreateTime;
????????????parameters[4].Value?=?model.UserName;
????????????parameters[5].Value?=?model.ScanTimes;
????????????parameters[6].Value?=?model.IP;

????????????object?obj?=?DbHelperSQL.GetSingle（strSql.ToString（）?parameters）;
????????????if?（obj?==?null）
????????????{
????????????????return?0;
????????????}
????????????else
????????????{
????????????????return?Convert.ToInt32（obj）;
????????????}
????????}

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

????????///?更新一條數據
????????///?

????????public?bool?Update（Model.Articles?model）
????????{
????????????StringBuilder?strSql?=?new?StringBuilder（）;
????????????strSql.Append（“update?Articles?set?“）;
????????????strSql.Append（“LemId=@LemId“）;
????????????strSql.Append（“Titl

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-04-26?22:50??Wiki\
?????目錄???????????0??2012-04-26?22:50??Wiki\DAL\
?????文件???????14384??2012-06-07?20:33??Wiki\DAL\Articles.cs
?????目錄???????????0??2012-04-26?22:50??Wiki\DAL\bin\
?????目錄???????????0??2012-04-26?22:50??Wiki\DAL\bin\Debug\
?????文件???????50688??2012-06-07?20:34??Wiki\DAL\bin\Debug\DAL.dll
?????文件???????97792??2012-06-07?20:34??Wiki\DAL\bin\Debug\DAL.pdb
?????文件???????11776??2012-04-20?23:08??Wiki\DAL\bin\Debug\Model.dll
?????文件???????62976??2012-04-20?23:08??Wiki\DAL\bin\Debug\Model.pdb
?????文件???????21504??2012-04-20?23:08??Wiki\DAL\bin\Debug\Utility.dll
?????文件???????52736??2012-04-20?23:08??Wiki\DAL\bin\Debug\Utility.pdb
?????目錄???????????0??2012-04-26?22:50??Wiki\DAL\bin\Release\
?????文件????????2939??2012-04-20?23:08??Wiki\DAL\DAL.csproj
?????文件???????10055??2012-04-20?23:08??Wiki\DAL\Lemmas.cs
?????文件???????16274??2012-04-20?23:08??Wiki\DAL\NetDisk.cs
?????目錄???????????0??2012-04-26?22:50??Wiki\DAL\obj\
?????目錄???????????0??2012-04-26?22:50??Wiki\DAL\obj\Debug\
?????文件????????1347??2012-06-07?20:34??Wiki\DAL\obj\Debug\DAL.csproj.FileListAbsolute.txt
?????文件???????50688??2012-06-07?20:34??Wiki\DAL\obj\Debug\DAL.dll
?????文件???????97792??2012-06-07?20:34??Wiki\DAL\obj\Debug\DAL.pdb
?????文件????????5834??2012-06-07?20:34??Wiki\DAL\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件???????19437??2012-04-27?21:14??Wiki\DAL\obj\Debug\ResolveAssemblyReference.cache
?????目錄???????????0??2012-04-26?22:50??Wiki\DAL\obj\Debug\TempPE\
?????目錄???????????0??2012-04-26?22:50??Wiki\DAL\Properties\
?????文件????????1356??2012-04-20?23:08??Wiki\DAL\Properties\AssemblyInfo.cs
?????文件???????13704??2012-04-20?23:08??Wiki\DAL\Publish.cs
?????文件???????13478??2012-04-20?23:08??Wiki\DAL\Reply.cs
?????文件???????10983??2012-04-20?23:08??Wiki\DAL\Sections.cs
?????文件???????10868??2012-04-20?23:08??Wiki\DAL\SubsArticles.cs
?????文件???????10459??2012-04-20?23:08??Wiki\DAL\SubsLemmas.cs
?????文件???????12221??2012-04-20?23:08??Wiki\DAL\Users.cs
............此處省略2348個文件信息