예제 #1
0
        public List <GL_QADetectionPointDTO> GetGLQADetectionPoint(GLQAReportVM model, Page page)
        {
            var query = from M in DataContext.GL_QADetectionPoint
                        select new GL_QADetectionPointDTO
            {
                QADetectionPointID = M.QADetectionPointID,
                WIP           = M.WIP,
                ScanIN        = M.ScanIN,
                ScanOUT       = M.ScanOUT,
                ScanNG        = M.ScanNG,
                ScanBACK      = M.ScanBACK,
                IsEnabled     = M.IsEnabled,
                StationID     = M.StationID,
                StationName   = M.GL_Station.StationName,
                Modified_UID  = M.System_Users.Account_UID,
                Modified_Date = M.Modified_Date,
                Modifieder    = M.System_Users.User_Name
            };

            if (model.StationID != 0)
            {
                query = query.Where(m => m.StationID == model.StationID);
            }
            query = query.Where(m => m.IsEnabled == true);
            query = query.OrderByDescending(m => m.Modified_Date).GetPage(page);
            return(query.ToList());
        }
예제 #2
0
 /// <summary>
 /// 初始化检测点列表
 /// </summary>
 /// <param name="model"></param>
 /// <param name="page"></param>
 /// <returns></returns>
 public List <GL_QADetectionPointDTO> GetGLQADetectionPoint(GLQAReportVM model, Page page)
 {
     return(gL_QADetectionPointRepository.GetGLQADetectionPoint(model, page));
 }