資源簡介
通過sqlserver及VS做的一款管理系統,并附有相應論文

代碼片段和文件信息
using?System;
using?System.Data;
using?System.Collections.Generic;
using?Maticsoft.Common;
using?OA.Model;
namespace?OA.BLL
{
///?
///?考勤
///?
public?partial?class?Attendance
{
private?readonly?OA.DAL.Attendance?dal=new?OA.DAL.Attendance();
public?Attendance()
{}
#region??BasicMethod
///?
///?得到最大ID
///?
public?int?GetMaxId()
{
return?dal.GetMaxId();
}
///?
///?是否存在該記錄
///?
public?bool?Exists(int?id)
{
return?dal.Exists(id);
}
///?
///?增加一條數據
///?
public?int??Add(OA.Model.Attendance?model)
{
return?dal.Add(model);
}
///?
///?更新一條數據
///?
public?bool?Update(OA.Model.Attendance?model)
{
return?dal.Update(model);
}
///?
///?刪除一條數據
///?
public?bool?Delete(int?id)
{
return?dal.Delete(id);
}
///?
///?刪除一條數據
///?
public?bool?DeleteList(string?idlist?)
{
return?dal.DeleteList(idlist?);
}
///?
///?得到一個對象實體
///?
public?OA.Model.Attendance?GetModel(int?id)
{
return?dal.GetModel(id);
}
///?
///?得到一個對象實體,從緩存中
///?
public?OA.Model.Attendance?GetModelByCache(int?id)
{
string?CacheKey?=?“AttendanceModel-“?+?id;
object?objModel?=?Maticsoft.Common.DataCache.GetCache(CacheKey);
if?(objModel?==?null)
{
try
{
objModel?=?dal.GetModel(id);
if?(objModel?!=?null)
{
int?ModelCache?=?Maticsoft.Common.ConfigHelper.GetConfigInt(“ModelCache“);
Maticsoft.Common.DataCache.SetCache(CacheKey?objModel?DateTime.Now.AddMinutes(ModelCache)?TimeSpan.Zero);
}
}
catch{}
}
return?(OA.Model.Attendance)objModel;
}
///?
///?獲得數據列表
///?
public?DataSet?GetList(string?strWhere)
{
return?dal.GetList(strWhere);
}
///?
///?獲得前幾行數據
///?
public?DataSet?GetList(int?Topstring?strWherestring?filedOrder)
{
return?dal.GetList(TopstrWherefiledOrder);
}
///?
///?獲得數據列表
///?
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)
{
OA.Model.Attendance?model;
for?(int?n?=?0;?n? {
model?=?dal.DataRowToModel(dt.Rows[n]);
if?(model?!=?null)
{
modelList.Add(model);
}
}
}
return?modelList;
}
///?
///?獲得數據列表
///?
public?DataSet?GetAllList()
{
return?GetList
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????3913??2013-05-23?00:57??JXGL\BLL\Attendance.cs
?????文件??????96256??2013-04-03?15:46??JXGL\BLL\bin\Debug\Maticsoft.Common.dll
?????文件??????28672??2013-05-23?01:10??JXGL\BLL\bin\Debug\OA.BLL.dll
?????文件??????85504??2013-05-23?01:10??JXGL\BLL\bin\Debug\OA.BLL.pdb
?????文件??????49152??2013-05-23?01:10??JXGL\BLL\bin\Debug\OA.DAL.dll
?????文件??????93696??2013-05-23?01:10??JXGL\BLL\bin\Debug\OA.DAL.pdb
?????文件??????28672??2013-05-23?00:57??JXGL\BLL\bin\Debug\OA.DBUtility.dll
?????文件??????54784??2013-05-23?00:57??JXGL\BLL\bin\Debug\OA.DBUtility.pdb
?????文件??????20480??2013-05-23?01:10??JXGL\BLL\bin\Debug\OA.Model.dll
?????文件??????67072??2013-05-23?01:10??JXGL\BLL\bin\Debug\OA.Model.pdb
?????文件???????6047??2013-04-01?13:45??JXGL\BLL\BLL.csproj
?????文件???????2445??2013-05-23?01:10??JXGL\BLL\BLL.csproj.user
?????文件???????3829??2013-05-23?00:57??JXGL\BLL\cars.cs
?????文件???????3883??2013-05-23?00:57??JXGL\BLL\Complain.cs
?????文件???????3823??2013-05-23?00:57??JXGL\BLL\INFO.cs
?????文件???????1702??2013-05-26?13:12??JXGL\BLL\obj\BLL.csproj.FileListAbsolute.txt
?????文件???????2636??2013-04-24?13:56??JXGL\BLL\obj\Debug\BLL.csproj.FileListAbsolute.txt
?????文件??????28672??2013-05-23?01:10??JXGL\BLL\obj\Debug\OA.BLL.dll
?????文件??????85504??2013-05-23?01:10??JXGL\BLL\obj\Debug\OA.BLL.pdb
?????文件??????23550??2013-05-23?01:10??JXGL\BLL\obj\Debug\ResolveAssemblyReference.cache
?????文件???????3853??2013-05-23?00:57??JXGL\BLL\Result.cs
?????文件???????3885??2013-05-23?00:57??JXGL\BLL\students.cs
?????文件???????3862??2013-05-23?00:57??JXGL\BLL\Tearcher.cs
?????文件???????3792??2013-05-23?00:57??JXGL\BLL\users.cs
?????文件???????7802??2013-05-23?00:57??JXGL\DAL\Attendance.cs
?????文件??????96256??2013-04-03?15:46??JXGL\DAL\bin\Debug\Maticsoft.Common.dll
?????文件?????369152??2013-04-06?18:15??JXGL\DAL\bin\Debug\MySql.Data.dll
?????文件??????49152??2013-05-23?01:10??JXGL\DAL\bin\Debug\OA.DAL.dll
?????文件??????93696??2013-05-23?01:10??JXGL\DAL\bin\Debug\OA.DAL.pdb
?????文件??????28672??2013-05-23?00:57??JXGL\DAL\bin\Debug\OA.DBUtility.dll
............此處省略327個文件信息
評論
共有 條評論