HH.BiDaoDian.Solution/BiDaoDian.BLL/AttdanInfoCheckBLL.cs

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

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

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

namespace BiDaoDian.BLL
{
    public class AttdanInfoCheckBLL
    {
        Class_SqlDataBaseHelperService sqlHelper = new Class_SqlDataBaseHelperService();
        #region 操作员汇总所有人信息
        public List<AttdanInfoCheckModel> CZYGetAttInfo(string startTime, string endTime, int userNo)
        {
            string sql = "select UserNo,count(*) as AttdanInfoCount from V_AttInfo  group by UserNo having 1=1";
            if (startTime != "")
            {
                sql += string.Format(" and Time>'{0}'", startTime);
            }
            if (endTime != "")
            {
                sql += string.Format(" and Time<'{0}' ", endTime);
            }
            if (userNo != -1)
            {
                sql += string.Format(" and UserNo={0}", userNo);
            }
            List<AttdanInfoCheckModel> list = new List<AttdanInfoCheckModel>();
            DataTable dt1 = sqlHelper.UnlinkSingleTableQuery(sql);
            if (dt1.Rows.Count > 0)
            {
                for (int i = 0; i < dt1.Rows.Count; i++)
                {
                    AttdanInfoCheckModel model = new AttdanInfoCheckModel();
                    int userNoFromDt1 = StringExtension.ToInt(dt1.Rows[i]["UserNo"].ToString());
                    sql = string.Format("select * from V_AttInfo where UserNo={0}",userNoFromDt1);
                    DataTable dt2 = sqlHelper.UnlinkSingleTableQuery(sql);
                    model.UserNo = StringExtension.ToInt(dt2.Rows[0]["UserNo"].ToString());
                    model.Human_name = StringExtension.ToNotNullString(dt2.Rows[0]["Human_name"].ToString());
                    model.DepartmentNo = StringExtension.ToInt(dt2.Rows[0]["DepartmentNo"].ToString());
                    model.AttdanInfoCount = StringExtension.ToInt(dt1.Rows[i]["AttdanInfoCount"].ToString());
                    list.Add(model);
                }
                return list;
            }
            return null;
        }
        public List<AttdanInfoCheckModel> CZYGetInfoBySql(string startTime, string endTime, int deptNo,string userName)
        {
            string sql = "select UserNo,DepartmentNo,Human_name,Count(UserNo) as AttdanInfoCount from V_AttInfo where 1=1 ";
            if (startTime != "")
            {
                sql += string.Format(" and Time>'{0}'", startTime);
            }
            if (endTime != "")
            {
                sql += string.Format(" and Time<'{0}' ", endTime);