using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?BiDaoDian.Model;
using?DatabaseHelper;
using?System.Data;
using?System.Collections;
using?Common;

namespace?BiDaoDian.BLL
{
????public?class?AttdanInfoBLL
????{
????????Class_SqlDatabaseHelperService?sqlHelper?=?new?Class_SqlDatabaseHelperService（）;
????????///?

????????///?新增一條考勤記錄
????????///?

????????///?傳入的考勤記錄模型
????????///?如果插入成功返回true，否則返回false
????????public?bool?AddOneInfo（AttdanInfoModel?model）
????????{
????????????string?sql?=?string.Format（“insert?into?AttdanInfo?values（{0}{1}‘{2}‘{3}{4}{5}‘{6}‘0‘是‘）“
????????????????????????????????????????????????model.TMNo
????????????????????????????????????????????????model.EnNo
????????????????????????????????????????????????model.Name
????????????????????????????????????????????????model.GMNo
????????????????????????????????????????????????model.Type
????????????????????????????????????????????????model.Action
????????????????????????????????????????????????model.Time
????????????????????????????????????????????????model.TimeInterval
????????????????????????????????????????????????model.IsPass
????????????????????????????????????????????????）;
????????????return?sqlHelper.linkSqlNonQuery（sql）?>?0;
????????}
????????///?

????????///?獲取全部信息
????????///?

????????///?
????????public?List?GetAllAttdanInfo（）
????????{
????????????List?list?=?new?List（）;
????????????string?sql?=?“select?*?from?AttdanInfo“;
????????????DataTable?dt?=?sqlHelper.UnlinkSingleTableQuery（sql）;
????????????if?（dt.Rows.Count?>?0）
????????????{
????????????????for?（int?i?=?0;?i?????????????????{
????????????????????AttdanInfoModel?model?=?new?AttdanInfoModel（）;
????????????????????model.No?=?StringExtension.ToInt（dt.Rows[i][“No“].ToString（））;
????????????????????model.Action?=?StringExtension.ToInt（dt.Rows[i][“Action“].ToString（））;
????????????????????model.EnNo?=?StringExtension.ToInt（dt.Rows[i][“EnNo“].ToString（））;
????????????????????model.GMNo?=?StringExtension.ToInt（dt.Rows[i][“GMNo“].ToString（））;
????????????????????model.Name?=?StringExtension.ToNotNullString（dt.Rows[i][“Name“].ToString（））;
????????????????????model.Time?=?StringExtension.ToDateTime（dt.Rows[i][“Time“].ToString（））;
????????????????????model.TMNo?=?StringExtension.ToNotNullString（dt.Rows[i][“TMNo“].ToString（））;
????????????????????model.Type?=?StringExtension.ToInt（dt.Rows[i][“Type“].ToString（））;
????????????????????model.TimeInterval?=?StringExtension.ToInt（dt.Rows[i][“TimeInterval“].ToString（））;
????????????????????model.IsPass?=?StringExtension.ToNotNullString（dt.Rows[i][“IsPass“].ToString（））;
????????????????????list.Add（model）;
????????????????}
????????????????return?list;
????????????}
????????????return

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2016-05-17?18:41??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\
?????目錄???????????0??2013-10-11?14:29??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\DB\
?????文件?????4259840??2013-10-11?14:29??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\DB\BiDaoDian.mdf
?????文件?????1064960??2013-10-11?14:29??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\DB\BiDaoDian_log.ldf
?????目錄???????????0??2013-10-11?14:37??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\
?????文件????????6841??2013-10-11?14:37??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution.sln
?????文件???????54784??2013-10-11?14:37??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution.suo
?????目錄???????????0??2013-10-09?13:04??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\
?????文件????????3108??2013-08-01?23:27??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\AttdanInfoBLL.cs
?????文件???????10897??2013-08-02?00:48??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\AttdanInfoCheckBLL.cs
?????文件???????12987??2013-08-01?23:58??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\AttInfoViewBLL.cs
?????文件????????3139??2013-08-01?20:59??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\BiDaoDian.BLL.csproj
?????目錄???????????0??2013-10-09?13:04??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\bin\
?????目錄???????????0??2013-10-11?14:04??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\bin\Debug\
?????文件???????20480??2013-10-11?14:04??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\bin\Debug\BiDaoDian.BLL.dll
?????文件???????52736??2013-10-11?14:04??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\bin\Debug\BiDaoDian.BLL.pdb
?????文件???????11264??2013-10-11?14:04??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\bin\Debug\BiDaoDian.Model.dll
?????文件????????7680??2013-10-11?14:04??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\bin\Debug\BiDaoDian.Model.pdb
?????文件????????4608??2013-10-11?14:04??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\bin\Debug\Common.dll
?????文件???????15872??2013-10-11?14:04??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\bin\Debug\Common.pdb
?????文件????????5632??2013-10-11?14:04??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\bin\Debug\DatabaseHelper.dll
?????文件???????15872??2013-10-11?14:04??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\bin\Debug\DatabaseHelper.pdb
?????目錄???????????0??2013-10-11?11:56??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\bin\Release\
?????文件?????????302??2013-08-01?20:08??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\DeptBLL.cs
?????文件????????1244??2013-07-31?14:58??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\MachineBLL.cs
?????目錄???????????0??2013-10-09?13:04??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\obj\
?????目錄???????????0??2013-10-11?14:04??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\obj\Debug\
?????文件????????5934??2013-10-11?14:04??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\obj\Debug\BiDaoDian.BLL.csproj.FileListAbsolute.txt
?????文件???????17190??2013-10-11?14:04??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\obj\Debug\BiDaoDian.BLL.csprojResolveAssemblyReference.cache
?????文件???????20480??2013-10-11?14:04??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\obj\Debug\BiDaoDian.BLL.dll
?????文件???????52736??2013-10-11?14:04??WFMAttendance?_d2fe43e2-cbc5-4e50-abf2-9edc17b36502\HH.BiDaoDian.Solution\BiDaoDian.BLL\obj\Debug\BiDaoDian.BLL.pdb
............此處省略159個文件信息