Esempio n. 1
0
        //获取借用信息
        public string GetMaterialBorrow(int page, int limit, ApplyFilter applyFilter)
        {
            DateTime[] applyTimes = applyFilter.GetStartAndEndTime(applyFilter.ApplyTime);
            DateTime?  applyTime0 = applyTimes?[0];
            DateTime?  applyTime1 = applyTimes?[1];

            DateTime[] startTimes = applyFilter.GetStartAndEndTime(applyFilter.StartTime);
            DateTime?  startTime0 = startTimes?[0];
            DateTime?  startTime1 = startTimes?[1];

            DateTime[] endTimes = applyFilter.GetStartAndEndTime(applyFilter.EndTime);
            DateTime?  endTime0 = endTimes?[0];
            DateTime?  endTime1 = endTimes?[1];
            int?       status   = applyFilter.Status == null ? (int?)null : Int32.Parse(applyFilter.Status);
            string     teacher  = applyFilter.Teacher == null
                ? null
                : _teacherBll.Find(applyFilter.Teacher).Teacher_Name;
            IUseApplyBll     useApplyBll = UnityContainerHelper.Server <IUseApplyBll>();
            List <Use_Apply> useApplies  = useApplyBll.GetEntities(m =>
                                                                   m.Is_Get == false &&
                                                                   (applyFilter.Teacher == null || m.Teacher_Name == teacher) &&
                                                                   (status == null || m.Apply_Status == status) &&
                                                                   ((applyTime0 == null || applyTime1 == null) || m.Apply_Time >= applyTime0 && m.Apply_Time <= applyTime1) &&
                                                                   ((startTime0 == null || startTime1 == null) || m.Start_Time >= startTime0 && m.Start_Time <= startTime1) &&
                                                                   ((endTime0 == null || endTime1 == null) || m.End_Time >= endTime0 && m.End_Time <= endTime1))
                                           .Skip((page - 1) * limit).Take(limit).ToList();

            var msg = new
            {
                code  = 0,
                msg   = "",
                total = useApplies.Count,
                data  = useApplies
            };

            return(JsonConvert.SerializeObject(msg));
        }