qlhb/Ropin.Inspection.Repository/VMC/VmcCameraTemplateRepository.cs

using Ropin.Inspection.Model.Entities;
using Ropin.Inspection.Model.SearchModel.LGS;
using Ropin.Inspection.Model.SearchModel.VMC;
using Ropin.Inspection.Model.ViewModel.LGS;
using Ropin.Inspection.Model.ViewModel.VMC;
using Ropin.Inspection.Repository.LGS.Interface;
using Ropin.Inspection.Repository.VMC.Interface;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Ropin.Inspection.Repository.VMC
{
    //摄像头模板-Repository
    public class VmcCameraTemplateRepository : RepositoryBase<TVMC_CameraTemplate, string>, IVmcCameraTemplateRepository
    {
        public VmcCameraTemplateRepository(InspectionDbContext dbContext) : base(dbContext)
        {
        }
        public Task<IEnumerable<VmcCameraTemplateViewModel>> GetConditionAsync(VmcCameraTemplateSearch searchModel)
        {
            MySqlConnector.MySqlParameter[] parameters = new[] {
                new MySqlConnector.MySqlParameter("Status", searchModel?.C_Status),
                new MySqlConnector.MySqlParameter("name",  "%"+searchModel?.C_Name+"%"),
                new MySqlConnector.MySqlParameter("Id ", searchModel?.C_ID)
            };
            StringBuilder sql = new StringBuilder();
            sql.Append(@"select * from (
select c.*,u.C_Name as C_CreateName from TVMC_CameraTemplate c
LEFT JOIN TSYS_User u on (c.C_CreateBy=u.C_UserID)
) tab Where 1=1");

            if (!string.IsNullOrEmpty(searchModel.C_Status))
            {
                sql.Append(" and C_Status=@Status ");
            }
            if (!string.IsNullOrEmpty(searchModel.C_Name))
            {
                sql.Append(" and C_Name like @name");
            }
            if (!string.IsNullOrEmpty(searchModel.C_ID))
            {
                sql.Append(" and C_ID=@Id ");
            }
            sql.Append(" order by I_Sort asc,D_CreateOn desc ");

            IEnumerable<VmcCameraTemplateViewModel> recordItemlist = EntityFrameworkCoreExtensions.GetList<VmcCameraTemplateViewModel>(DbContext.Database, sql.ToString(), parameters);
            searchModel.TotalCount = recordItemlist.First() != null ? recordItemlist.ToList().Count : 0;
            if (recordItemlist.Count() == 1 && recordItemlist.First() == null)
            {
                recordItemlist = null;
            }
            return Task.FromResult(searchModel.IsPagination ? recordItemlist?.Skip((searchModel.PageIndex - 1) * searchModel.PageSize).Take(searchModel.PageSize) : recordItemlist);
        }
    }
}