HH.BiDaoDian.Solution/BiDaoDian.BLL/AttInfoViewBLL.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 AttInfoViewBLL
    {
        Class_SqlDataBaseHelperService sqlHelper = new Class_SqlDataBaseHelperService();
        #region 查询所有信息
        #region 操作员所用到的查询(无限制)
        /// <summary>
        /// 在pageload时候操作员所看到的信息
        /// </summary>
        /// <returns>信息列表</returns>
        public List<AttInfoView> CZYGetAllInfo()
        {
            string sql = "Select * from V_AttInfo order by UserNo asc,Time asc";
            DataTable dt = sqlHelper.UnlinkSingleTableQuery(sql);
            List<AttInfoView> list = new List<AttInfoView>();
            if (dt.Rows.Count > 0)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    AttInfoView model = new AttInfoView();
                    model.UserNo = StringExtension.ToInt(dt.Rows[i]["UserNo"].ToString());
                    model.DepartmentNo = StringExtension.ToInt(dt.Rows[i]["DepartmentNo"].ToString());
                    model.DeptName = StringExtension.ToNotNullString(dt.Rows[i]["DepartmentName"].ToString());
                    model.Human_name = StringExtension.ToNotNullString(dt.Rows[i]["Human_name"].ToString());
                    model.Time = StringExtension.ToDateTime(dt.Rows[i]["Time"].ToString());
                    model.TMNo = StringExtension.ToNotNullString(dt.Rows[i]["TMNo"].ToString());
                    model.TMLoc = StringExtension.ToNotNullString(dt.Rows[i]["MachineLoc"].ToString());
                    model.Type = StringExtension.ToInt(dt.Rows[i]["Type"].ToString());
                    model.TimeInterval = StringExtension.ToNotNullString(dt.Rows[i]["TimeInterval"].ToString());
                    model.IsPass = StringExtension.ToNotNullString(dt.Rows[i]["IsPass"].ToString());
                    list.Add(model);
                }
                return list;
            }
            return null;
        }
        /// <summary>
        /// 操作员通过条件搜索获取信息
        /// </summary>
        /// <returns>下拉列表</returns>
        public List<AttInfoView> CZYGetInfoBySql(string startTime, string endTime,string userName,string tMNo)
        {
            string sql = "select * from V_AttInfo where 1=1 ";
            if (startTime != "")
            {
                sql += string.Format(" and Time>'{0}'", startTime);
            }
            if (endTime != "")
            {
                sql += string.Format(" and Time<'{0}'", endTime);