資源簡(jiǎn)介
一個(gè)用于學(xué)習(xí)Asp.NET C#編程的簡(jiǎn)單三層架構(gòu)新聞發(fā)布系統(tǒng),此源碼是我學(xué)習(xí)三層架構(gòu)時(shí)做的一個(gè)新聞發(fā)布系統(tǒng),供學(xué)習(xí)三層的朋友們參考。
源碼中涉及用到的技術(shù):
C#,Sql Server2005存儲(chǔ)過程,觸發(fā)器,Div+Css,jQuery,
系統(tǒng)實(shí)現(xiàn)功能:
1,后臺(tái)新聞分類增刪改;
2,后臺(tái)新聞內(nèi)容增刪改查,添加新聞?dòng)玫紽reeTextBox控件,分頁用到AspNetPager分頁控件,源碼中都帶有最新版的相關(guān)控件;
3,后臺(tái)對(duì)新聞評(píng)論信息查看,刪除;
3,前臺(tái)新聞瀏覽,查詢,最新新聞,熱點(diǎn)新聞,
4,前臺(tái)針對(duì)每條新聞可以做評(píng)價(jià),
數(shù)據(jù)庫在newsSystem\App_Data\newsSystem.bak,恢復(fù)數(shù)據(jù)庫到Sql 2005中即可。
后臺(tái)登陸用戶名密碼:admin

代碼片段和文件信息
/*
?*?創(chuàng)建人:ttok
?*?創(chuàng)建時(shí)間:2010-11-8
?*?說明:新聞?lì)悇e表的業(yè)務(wù)類
?*?版權(quán)所有:ttok@2010
?*/
using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Data;
using?Model;
using?DAL;
namespace?BLL
{
????public?class?CategoryManager
????{
???????private?CategoryDAO?cdao?=?null;
????????public?CategoryManager()
????????{
????????????cdao?=?new?CategoryDAO();
????????}
????????#region??返回類別表
????????///?
????????///?返回類別表
????????///?
????????///?
????????public?DataTable?GetCateGory()
????????{
????????????return?cdao.SelectAll();
????????}
????????#endregion
????????#region?根據(jù)類別ID返回類別表
????????///?
????????///?根據(jù)類別ID返回類別表
????????///?
????????///?類別ID
????????///?
????????public?DataTable?SelctByID(int?caid)
????????{?return?cdao.SelectByID(caid);?}
????????#endregion
????????#region?添加類別
????????///?
????????///?添加類別
????????///?
????????///?類別名稱
????????///?
????????public?bool?insertCaName(Category?ca)
????????{
???????????//?Category?ca?=?new?Category(0ca.Name);
????????????if?(IsExists(ca.Name))
????????????{
????????????????return?false;
????????????}
????????????return?(cdao.Insert(ca));
????????}
????????#endregion
????????#region?修改類別表
????????///?
????????///?修改類別表
????????///?
????????///?類別id
????????///?類別名稱
????????///?
????????public?bool?UpdateCategory(Category?ca)
????????{
????????????if?(string.IsNullOrEmpty(ca.Name)||IsExists(ca.Name))
????????????{
????????????????return?false;
????????????}
????????????return?cdao.Update(ca);
????????}
????????#endregion
????????#region?刪除類別表
????????///?
????????///?刪除類別表
????????///?
????????///?類別ID
????????///?
????????public?bool?DeleteCategory(int?id)
????????{
????????????return?cdao.Delete(id);
????????}
????????#endregion
????????#region?判斷類別名稱是否已存在
????????///?
????????///?判斷類別名稱是否已存在
????????///?
????????///?類別名稱
????????///?
????????public?bool?IsExists(string?caName)
????????{?
????????????Category?ca=new?Category(0caName);
????????????return?cdao.IsExists(ca);
????????}
????????#endregion
????}
}
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件??????10696??2011-01-19?15:30??4.gif
?????文件???????2301??2010-11-07?00:49??newsSystem.sln
????..A..H.?????97792??2011-01-19?15:44??newsSystem.suo
?????文件????????577??2011-01-19?16:01??說明.txt
?????文件???????6656??2011-01-19?15:36??BLL\bin\Debug\BLL.dll
?????文件??????28160??2011-01-19?15:36??BLL\bin\Debug\BLL.pdb
?????文件??????11776??2011-01-19?15:36??BLL\bin\Debug\DAL.dll
?????文件??????34304??2011-01-19?15:36??BLL\bin\Debug\DAL.pdb
?????文件???????6656??2011-01-19?15:36??BLL\bin\Debug\Model.dll
?????文件??????28160??2011-01-19?15:36??BLL\bin\Debug\Model.pdb
?????文件???????2990??2010-12-09?22:22??BLL\BLL.csproj
?????文件???????2781??2010-12-13?00:30??BLL\CategoryManager.cs
?????文件???????1310??2010-11-08?20:50??BLL\CommentManager.cs
?????文件????????998??2011-01-17?17:24??BLL\LoginManager.cs
?????文件???????4301??2011-01-19?02:19??BLL\NewsManager.cs
?????文件????????801??2011-01-18?02:02??BLL\obj\Debug\BLL.csproj.FileListAbsolute.txt
?????文件???????6656??2011-01-19?15:36??BLL\obj\Debug\BLL.dll
?????文件??????28160??2011-01-19?15:36??BLL\obj\Debug\BLL.pdb
?????文件???????4096??2010-11-16?19:49??BLL\obj\Debug\Refactor\BLL.dll
?????文件???????6227??2011-01-19?15:36??BLL\obj\Debug\ResolveAssemblyReference.cache
?????文件???????1350??2010-11-06?00:28??BLL\Properties\AssemblyInfo.cs
?????文件??????11776??2011-01-19?15:36??DAL\bin\Debug\DAL.dll
?????文件??????34304??2011-01-19?15:36??DAL\bin\Debug\DAL.pdb
?????文件???????6656??2011-01-19?15:36??DAL\bin\Debug\Model.dll
?????文件??????28160??2011-01-19?15:36??DAL\bin\Debug\Model.pdb
?????文件???????3578??2010-11-16?17:22??DAL\CategoryDAO.cs
?????文件???????1673??2010-11-08?15:15??DAL\CommentDAO.cs
?????文件???????2859??2010-11-08?13:26??DAL\DAL.csproj
?????文件???????7916??2011-01-19?01:47??DAL\NewsDAO.cs
?????文件????????629??2011-01-18?02:02??DAL\obj\Debug\DAL.csproj.FileListAbsolute.txt
............此處省略989個(gè)文件信息
- 上一篇:c#編寫的oracle導(dǎo)出到excel
- 下一篇:史上最好的C#記事本
評(píng)論
共有 條評(píng)論