using?System;
using?System.Collections.Generic;
using?System.Text;
using?hrModel;
using?DataAccess.Data;
using?System.Data;
using?System.Data.Common;
namespace?hrBll
{
????public?class?BllAttendance
????{
????????///?

????????///?增加一條數據
????????///?

????????public?static?int?Add（Attendance?model?DbTransaction?trans）
????????{
????????????StringBuilder?sb?=?new?StringBuilder（）;
????????????sb.Append（“INSERT?INTO?Attendance（AttenDate?EmpNo?Adsum?Fact?Late?Leave?Absent?Overtime?NotIn?NotOut?Outgo“）;
????????????sb.Append（“WorkOut?WorkTime?NumCount?[In]?Out?Artificial?[Work]?Illness?Thing?Family）“）;
????????????sb.Append（“VALUES?（@AttenDate?@EmpNo@Adsum?@Fact?@Late?@Leave?@Absent?@Overtime?@NotIn?@NotOut?@Outgo“）;
????????????sb.Append（“?@WorkOut?@WorkTime?@NumCount?@In@Out@Artificial?@Work?@Illness?@Thing?@Family）“）;
????????????return?DbHelperSQL.Instance.ExcuteTransNonQuery（sb.ToString（）?DbHelperSQL.Instance.CreateParamters（sb.ToString（）?model）?trans）;
????????}

????????///?

????????///?更新一條數據
????????///?

????????public?static?int?Update（Attendance?model）
????????{
????????????StringBuilder?sb?=?new?StringBuilder（）;
????????????sb.Append（“UPDATE?Attendance?SET?Adsum=@Adsum?Fact?=@Fact?Late?=@Late?Leave?=@Leave?Absent?=@Absent?Overtime?=@Overtime“）;
????????????sb.Append（“?NotIn?=@NotIn?NotOut?=@NotOut??Outgo?=@Outgo?WorkOut?=@WorkOut?WorkTime?=@WorkTime?NumCount?=@NumCount“）;
????????????sb.Append（“?[In]?=@In?Artificial?=@Artificial?Out?=@Out?[Work]?=@WorkIllness?=@Illness?Thing?=@Thing?Family?=@Family?WHERE?EmpNo?=@EmpNo“）;
????????????return?DbHelperSQL.Instance.ExcuteNonQuery（sb.ToString（）?DbHelperSQL.Instance.CreateParamters（sb.ToString（）?model））;
????????}

????????///?

????????///?刪除一條數據
????????///?

????????public?static?int?Delete（string?EmpNo）
????????{
????????????StringBuilder?sb?=?new?StringBuilder（）;
????????????sb.Append（String.Format（“DELETE?FROM?Attendance?WHERE?EmpNo=‘{0}‘“?EmpNo））;
????????????return?DbHelperSQL.Instance.ExcuteNonQuery（sb.ToString（））;
????????}
????????public?static?DataTable?GetAttenddanceDataTable（）
????????{
????????????StringBuilder?sb?=?new?StringBuilder（）;
????????????sb.Append（“SELECT?AttenDate?EmpNo?Adsum?Fact?Late?Leave?Absent?Overtime?NotIn?NotOut“）;
????????????sb.Append（“?Outgo?WorkOut?WorkTime?NumCount?[In]?Out?Artificial?[Work]?Illness?ThingFamily?FROM?Attendance?“）;
????????????return?DbHelperSQL.Instance.GetDataTable（sb.ToString（））;
????????}
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????目錄??????????0??2008-01-25?17:10??人事工資考勤管理系統（C#源碼）

?????文件????1458688??2008-01-21?15:35??人事工資考勤管理系統（C#源碼）\HR.bak

?????目錄??????????0??2008-01-25?17:10??人事工資考勤管理系統（C#源碼）\hrBll

?????目錄??????????0??2008-01-25?17:10??人事工資考勤管理系統（C#源碼）\hrBll\bin

?????目錄??????????0??2008-01-25?17:10??人事工資考勤管理系統（C#源碼）\hrBll\bin\Debug

?????文件?????122880??2007-12-24?15:33??人事工資考勤管理系統（C#源碼）\hrBll\bin\Debug\CustomException.Err.dll

?????文件??????56832??2007-12-24?15:33??人事工資考勤管理系統（C#源碼）\hrBll\bin\Debug\CustomException.Err.pdb

?????文件??????24576??2008-01-25?15:55??人事工資考勤管理系統（C#源碼）\hrBll\bin\Debug\DataAccess.dll

?????文件??????42496??2008-01-25?15:55??人事工資考勤管理系統（C#源碼）\hrBll\bin\Debug\DataAccess.pdb

?????文件??????21155??2008-01-25?15:55??人事工資考勤管理系統（C#源碼）\hrBll\bin\Debug\DataAccess.xml

?????文件??????32768??2008-01-25?16:27??人事工資考勤管理系統（C#源碼）\hrBll\bin\Debug\DBUtilities.dll

?????文件??????62976??2008-01-25?16:27??人事工資考勤管理系統（C#源碼）\hrBll\bin\Debug\DBUtilities.pdb

?????文件?????946176??2007-08-29?19:37??人事工資考勤管理系統（C#源碼）\hrBll\bin\Debug\Excel.dll

?????文件??????65536??2008-01-25?17:16??人事工資考勤管理系統（C#源碼）\hrBll\bin\Debug\hrBll.dll

?????文件??????95744??2008-01-25?17:16??人事工資考勤管理系統（C#源碼）\hrBll\bin\Debug\hrBll.pdb

?????文件??????36864??2008-01-25?17:16??人事工資考勤管理系統（C#源碼）\hrBll\bin\Debug\hrModel.dll

?????文件?????134656??2008-01-25?17:16??人事工資考勤管理系統（C#源碼）\hrBll\bin\Debug\hrModel.pdb

?????文件???????2659??2007-12-20?15:36??人事工資考勤管理系統（C#源碼）\hrBll\BllAttendance.cs

?????文件???????3510??2007-12-03?16:56??人事工資考勤管理系統（C#源碼）\hrBll\BLLDepartment.cs

?????文件???????7483??2008-01-25?16:58??人事工資考勤管理系統（C#源碼）\hrBll\BLLEmployee.cs

?????文件???????3723??2007-12-03?20:43??人事工資考勤管理系統（C#源碼）\hrBll\BllEvaluation.cs

?????文件???????3996??2007-12-18?16:47??人事工資考勤管理系統（C#源碼）\hrBll\BllExperience.cs

?????文件???????3706??2007-12-19?15:36??人事工資考勤管理系統（C#源碼）\hrBll\BLLGongZ.cs

?????文件???????5360??2007-12-07?21:09??人事工資考勤管理系統（C#源碼）\hrBll\BLLLogin.cs

?????文件????????742??2008-01-02?16:38??人事工資考勤管理系統（C#源碼）\hrBll\BllMain.cs

?????文件???????4666??2007-12-03?11:57??人事工資考勤管理系統（C#源碼）\hrBll\BLLPicture.cs

?????文件???????3732??2007-12-04?12:40??人事工資考勤管理系統（C#源碼）\hrBll\BllPrize.cs

?????文件???????3906??2007-12-18?16:48??人事工資考勤管理系統（C#源碼）\hrBll\BllRelation.cs

?????文件???????4654??2007-12-04?14:21??人事工資考勤管理系統（C#源碼）\hrBll\BLLSalary.cs

?????文件???????4768??2007-12-04?16:06??人事工資考勤管理系統（C#源碼）\hrBll\BllSalaryItem.cs

............此處省略305個文件信息