Пример #1
0
        public static MissingScanTimeCollection GetMissingScanTime(MissCanTimePara objPara)
        {
            var pars = new SqlParameter[]
            {
                new SqlParameter("@EmployeeCode", objPara.EmployeeCode),
                new SqlParameter("@StartDate", objPara.StartDate),
                new SqlParameter("@EndDate", objPara.EndDate),
                new SqlParameter("@EntityID", objPara.EntityID),
            };

            MissingScanTimeCollection collection = new MissingScanTimeCollection();

            using (var reader = SqlHelper.ExecuteReaderService(ModuleConfig.MyConnection, "USP_TMS_NotFillScanTime_Report", pars))
            {
                MissingScanTime obj = new MissingScanTime();
                while (reader.Read())
                {
                    obj = BindScanTimeData(reader);
                    collection.Add(obj);
                }
            }
            return(collection);
        }