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

namespace?SimpleNS.DAL
{
??public?class?CategoryDAL
????{
????????//?AccessHelper?helper?=?new?AccessHelper（）;
??????NewsDBHelper?helper?=?new?NewsDBHelper（）;
????????///?
獲取實(shí)體類
????????///?
????????///?

????????///?
????????///?
????????public?SimpleNS.Model.Category?GetModel（int?id）
????????{
????????????string?sql?=?“select?*?from?SimpleNS_Category?where?id=“?+?id;
????????????DataTable?dt?=?helper.ExecQuery（sql）;
????????????if?（dt.Rows.Count?==?0）
????????????{
????????????????return?null;
????????????}
????????????SimpleNS.Model.Category?model?=?new?SimpleNS.Model.Category（）;
????????????model.Caname?=?dt.Rows[0][“caname“].ToString（）;
????????????model.Id?=?int.Parse（dt.Rows[0][“id“].ToString（））;
????????????model.Createdate?=?DateTime.Parse（dt.Rows[0][“createdate“].ToString（））;
????????????return?model;
????????}

????????///?
新增
????????///?
????????///?

????????///?
????????///?
????????public?bool?Add（Model.Category?model）
????????{
????????????string?sql_ins?=?“insert?into?SimpleNS_Category（caname?pid）?values（‘“?+?model.Caname?+?“‘?“?+?model.Pid?+?“）“;
????????????return?helper.ExecNonQuery（sql_ins）;
????????}

????????///?
新增
????????///?
????????///?

????????///?
????????///?
????????public?bool?Delete（int?id）
????????{
????????????string?sql?=?“delete?from?SimpleNS_Category?where?id=“?+?id;
????????????return?helper.ExecNonQuery（sql）;
????????}

????????///?
選擇所有分類
????????///?
????????///?

????????///?
????????public?DataTable?GetList（）
????????{
????????????string?sql_sel?=?“select?*?from??SimpleNS_Category“;
????????????return?helper.ExecQuery（sql_sel）;
????????}

????????///?
判斷caname是否存在
????????///?
????????///?

????????///?
????????///?
????????public?bool?IsExists（string?caname）
????????{
????????????string?sql?=?“select?count（1）?from?SimpleNS_Category?where?caname=‘“?+?caname?+?“‘“;
????????????int?res?=?int.Parse（helper.ExecScalar（sql）.ToString（））;
????????????if?（res?>?0）
????????????{
????????????????return?true;
????????????}
????????????return?false;
????????}
????}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2011-07-01?09:20??簡(jiǎn)易新聞發(fā)布\
?????目錄???????????0??2011-07-01?09:20??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\
?????目錄???????????0??2011-07-01?09:20??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\bin\
?????目錄???????????0??2011-07-01?09:20??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\bin\Debug\
?????文件???????20480??2011-06-30?22:05??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\bin\Debug\SimpleNS.DAL.dll
?????文件???????22016??2011-06-30?22:05??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\bin\Debug\SimpleNS.DAL.pdb
?????文件???????16384??2011-06-30?22:05??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\bin\Debug\SimpleNS.Model.dll
?????文件???????19968??2011-06-30?22:05??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\bin\Debug\SimpleNS.Model.pdb
?????文件????????2570??2011-06-30?22:05??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\CategoryDAL.cs
?????文件????????5562??2011-06-30?22:05??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\NewsDAL.cs
?????文件????????2321??2011-06-30?22:05??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\NewsDBHelper.cs
?????目錄???????????0??2011-07-01?09:20??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\obj\
?????目錄???????????0??2011-07-01?09:31??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\obj\Debug\
?????目錄???????????0??2011-07-01?09:20??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\obj\Debug\Refactor\
?????文件???????16384??2011-06-30?22:05??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\obj\Debug\Refactor\SimpleNS.DAL.dll
?????文件????????5136??2011-07-01?09:31??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\obj\Debug\ResolveAssemblyReference.cache
?????文件???????20480??2011-06-30?22:05??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\obj\Debug\SimpleNS.DAL.dll
?????文件???????22016??2011-06-30?22:05??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\obj\Debug\SimpleNS.DAL.pdb
?????目錄???????????0??2011-06-30?22:05??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\obj\Debug\TempPE\
?????文件?????????214??2011-06-30?22:05??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\obj\SimpleNS.DAL.csproj.FileList.txt
?????文件????????2252??2011-07-01?09:42??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\obj\SimpleNS.DAL.csproj.FileListAbsolute.txt
?????目錄???????????0??2011-07-01?09:20??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\Properties\
?????文件????????1343??2011-06-30?22:05??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\Properties\AssemblyInfo.cs
?????文件????????2277??2011-06-30?22:05??簡(jiǎn)易新聞發(fā)布\SimpleNS.DAL\SimpleNS.DAL.csproj
?????目錄???????????0??2011-07-01?09:20??簡(jiǎn)易新聞發(fā)布\SimpleNS.Model\
?????目錄???????????0??2011-07-01?09:20??簡(jiǎn)易新聞發(fā)布\SimpleNS.Model\bin\
?????目錄???????????0??2011-07-01?09:20??簡(jiǎn)易新聞發(fā)布\SimpleNS.Model\bin\Debug\
?????文件???????16384??2011-06-30?22:05??簡(jiǎn)易新聞發(fā)布\SimpleNS.Model\bin\Debug\SimpleNS.Model.dll
?????文件???????19968??2011-06-30?22:05??簡(jiǎn)易新聞發(fā)布\SimpleNS.Model\bin\Debug\SimpleNS.Model.pdb
?????文件?????????775??2011-06-30?22:05??簡(jiǎn)易新聞發(fā)布\SimpleNS.Model\Category.cs
?????文件????????1256??2011-06-30?22:05??簡(jiǎn)易新聞發(fā)布\SimpleNS.Model\News.cs
............此處省略54個(gè)文件信息