C#指纹机考勤查询系统源码

C#指纹机考勤查询系统源码

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 < dt.Rows.Count; 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个文件信息