資源簡介
一個完整的三層架構的DB2數據庫demo,增刪改查功能完善,注釋齊全,適合新手學習。

代碼片段和文件信息
using?System;
using?System.Data;
using?System.Collections.Generic;
using?DB2.Model;
namespace?DB2.BLL
{
///?
///?STUDENT
///?
public?partial?class?STUDENT
{
private?readonly?DB2.DAL.STUDENT?dal=new?DB2.DAL.STUDENT();
public?STUDENT()
{}
#region??BasicMethod
///?
///?增加一條數據
///?
public?bool?Add(DB2.Model.STUDENT?model)
{
return?dal.Add(model);
}
///?
///?更新一條數據
///?
public?bool?Update(DB2.Model.STUDENT?model)
{
return?dal.Update(model);
}
///?
///?刪除一條數據
///?
public?bool?Delete()
{
//該表無主鍵信息,請自定義主鍵/條件字段
return?dal.Delete();
}
????????/////?
????????/////?得到一個對象實體
????????/////?
????????//public?DB2.Model.STUDENT?GetModel()
????????//{
????????//????//該表無主鍵信息,請自定義主鍵/條件字段
????????//????return?dal.GetModel();
????????//}
????????/////?
????????/////?得到一個對象實體,從緩存中
????????/////?
????????//public?DB2.Model.STUDENT?GetModelByCache()
????????//{
????????//????//該表無主鍵信息,請自定義主鍵/條件字段
????????//????string?CacheKey?=?“STUDENTModel-“?;
????????//????object?objModel?=?Maticsoft.Common.DataCache.GetCache(CacheKey);
????????//????if?(objModel?==?null)
????????//????{
????????//????????try
????????//????????{
????????//????????????objModel?=?dal.GetModel();
????????//????????????if?(objModel?!=?null)
????????//????????????{
????????//????????????????int?ModelCache?=?Maticsoft.Common.ConfigHelper.GetConfigInt(“ModelCache“);
????????//????????????????Maticsoft.Common.DataCache.SetCache(CacheKey?objModel?DateTime.Now.AddMinutes(ModelCache)?TimeSpan.Zero);
????????//????????????}
????????//????????}
????????//????????catch{}
????????//????}
????????//????return?(DB2.Model.STUDENT)objModel;
????????//}
????????/////?
????????/////?獲得數據列表
????????/////?
????????//public?DataSet?GetList(string?strWhere)
????????//{
????????//????return?dal.GetList(strWhere);
????????//}
????????/////?
????????/////?獲得數據列表
????????/////?
????????//public?List?GetModelList(string?strWhere)
????????//{
????????//????DataSet?ds?=?dal.GetList(strWhere);
????????//????return?DataTableToList(ds.Tables[0]);
????????//}
????????/////?
????????/////?獲得數據列表
????????/////?
????????//public?List?DataTableToList(DataTable?dt)
????????//{
????????//????List?modelList?=?new?List();
????????//????int?rowsCount?=?dt.Rows.Count;
????????//????if?(rowsCount?>?0)
????????//????{
????????//????????DB2.Model.STUDENT?model;
????????//????????for?(int?n?=?0;?n?????????//????????{
????????//????????????model?=?dal.DataRowToModel(dt.Rows[n]);
????????//????????????if?(model?!=?null)
????????//????????????{
????????//????????????????modelList.Add(model);
????????//????????????}
????
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????4608??2016-08-04?17:15??DB2_practice_IBMDB2\BLL\bin\Debug\BLL.dll
?????文件??????11776??2016-08-04?17:15??DB2_practice_IBMDB2\BLL\bin\Debug\BLL.pdb
?????文件???????5632??2016-08-04?17:15??DB2_practice_IBMDB2\BLL\bin\Debug\DAL.dll
?????文件??????13824??2016-08-04?17:15??DB2_practice_IBMDB2\BLL\bin\Debug\DAL.pdb
?????文件??????13312??2016-08-04?17:15??DB2_practice_IBMDB2\BLL\bin\Debug\Db2Utility.dll
?????文件??????34304??2016-08-04?17:15??DB2_practice_IBMDB2\BLL\bin\Debug\Db2Utility.pdb
?????文件????1377640??2012-04-05?01:29??DB2_practice_IBMDB2\BLL\bin\Debug\IBM.Data.DB2.dll
?????文件???????4608??2016-08-04?17:15??DB2_practice_IBMDB2\BLL\bin\Debug\Model.dll
?????文件??????13824??2016-08-04?17:15??DB2_practice_IBMDB2\BLL\bin\Debug\Model.pdb
?????文件???????2905??2016-08-04?17:15??DB2_practice_IBMDB2\BLL\BLL.csproj
?????文件????????864??2016-08-04?17:15??DB2_practice_IBMDB2\BLL\obj\Debug\BLL.csproj.FileListAbsolute.txt
?????文件??????18193??2016-08-04?17:15??DB2_practice_IBMDB2\BLL\obj\Debug\BLL.csprojResolveAssemblyReference.cache
?????文件???????4608??2016-08-04?17:15??DB2_practice_IBMDB2\BLL\obj\Debug\BLL.dll
?????文件??????11776??2016-08-04?17:15??DB2_practice_IBMDB2\BLL\obj\Debug\BLL.pdb
?????文件???????6764??2016-08-05?08:40??DB2_practice_IBMDB2\BLL\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件???????1326??2016-08-04?17:02??DB2_practice_IBMDB2\BLL\Properties\AssemblyInfo.cs
?????文件???????4330??2016-08-04?17:07??DB2_practice_IBMDB2\BLL\STUDENT.cs
?????文件???????5632??2016-08-04?17:15??DB2_practice_IBMDB2\DAL\bin\Debug\DAL.dll
?????文件??????13824??2016-08-04?17:15??DB2_practice_IBMDB2\DAL\bin\Debug\DAL.pdb
?????文件??????13312??2016-08-04?17:15??DB2_practice_IBMDB2\DAL\bin\Debug\Db2Utility.dll
?????文件??????34304??2016-08-04?17:15??DB2_practice_IBMDB2\DAL\bin\Debug\Db2Utility.pdb
?????文件????1377640??2012-04-05?01:29??DB2_practice_IBMDB2\DAL\bin\Debug\IBM.Data.DB2.dll
?????文件???????4608??2016-08-04?17:15??DB2_practice_IBMDB2\DAL\bin\Debug\Model.dll
?????文件??????13824??2016-08-04?17:15??DB2_practice_IBMDB2\DAL\bin\Debug\Model.pdb
?????文件???????3008??2016-08-04?17:15??DB2_practice_IBMDB2\DAL\DAL.csproj
?????文件????????730??2016-08-04?17:15??DB2_practice_IBMDB2\DAL\obj\Debug\DAL.csproj.FileListAbsolute.txt
?????文件??????13706??2016-08-04?17:15??DB2_practice_IBMDB2\DAL\obj\Debug\DAL.csprojResolveAssemblyReference.cache
?????文件???????5632??2016-08-04?17:15??DB2_practice_IBMDB2\DAL\obj\Debug\DAL.dll
?????文件??????13824??2016-08-04?17:15??DB2_practice_IBMDB2\DAL\obj\Debug\DAL.pdb
?????文件???????6757??2016-08-04?17:12??DB2_practice_IBMDB2\DAL\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
............此處省略103個文件信息
評論
共有 條評論