HH.BiDaoDian.Solution/BiDaoDian.BLL/AttdanInfoBLL.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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();
        /// <summary>
        /// 新增一条考勤记录
        /// </summary>
        /// <param name="model">传入的考勤记录模型</param>
        /// <returns>如果插入成功返回true，否则返回false</returns>
        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;
        }
        /// <summary>
        /// 获取全部信息
        /// </summary>
        /// <returns></returns>
        public List<AttdanInfoModel> GetAllAttdanInfo()
        {
            List<AttdanInfoModel> list = new List<AttdanInfoModel>();
            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);