/// <summary> /// 待批准列表 /// JDZT:100 111 /// </summary> /// <param name="input"></param> /// <returns></returns> public PagedResultDto <VW_SJCL_100> GetPagedDpzmxs(GetVwSjmxsInput input) { if (!AbpSession.UserId.HasValue) { return(null); } Expression <Func <VW_SJCL_100, bool> > newExp = p => p.Id > 0; if (!input.WTDH.IsNullOrWhiteSpace()) { newExp = newExp.And(p => (p.sjdid.Contains(input.WTDH))); newExp = newExp.Or(p => (p.DWMC.Contains(input.WTDH))); newExp = newExp.Or(p => (p.ccbh.Contains(input.WTDH))); } newExp = newExp.And(p => p.JDZT == 200); var totalCount = _vwsjclDapperRepository.Count(newExp); IEnumerable <VW_SJCL_100> ret = _vwsjclDapperRepository.GetAllPaged( newExp, input.SkipCount / input.MaxResultCount, input.MaxResultCount, input.Sorting, input.Order == "desc"); // input.Order=="asc" true/false List <VW_SJCL_100> tempList2 = ObjectMapper.Map <List <VW_SJCL_100> >(ret); return(new PagedResultDto <VW_SJCL_100>( totalCount, tempList2 )); }
/// <summary> /// 待检列表 /// JDZT:100 111 /// </summary> /// <param name="input"></param> /// <returns></returns> public PagedResultDto <VW_SJCL_100> GetPagedDhymxs(GetVwSjmxsInput input) { if (!AbpSession.UserId.HasValue) { return(null); } long id = (long)AbpSession.UserId; var roles = GetJDRolesList(id); Expression <Func <VW_SJCL_100, bool> > newExp = p => p.Id > 0; if (roles.Length > 0) { ParameterExpression parameter = Expression.Parameter(typeof(VW_SJCL_100), "p"); MemberExpression member = Expression.PropertyOrField(parameter, "QJMCBM"); MethodInfo method = typeof(string).GetMethod("Equals", new[] { typeof(string) }); ConstantExpression constant = Expression.Constant(roles[0], typeof(string)); newExp = newExp.And(Expression.Lambda <Func <VW_SJCL_100, bool> >(Expression.Call(member, method, constant), parameter)); for (int i = 1; i < roles.Length; i++) { newExp = newExp.Or(Expression.Lambda <Func <VW_SJCL_100, bool> >(Expression.Call(member, method, Expression.Constant(roles[i], typeof(string))), parameter)); } } if (!input.FilterText.IsNullOrWhiteSpace()) { newExp = newExp.And(p => (p.QJMCBM == input.FilterText)); } if (!input.WTDH.IsNullOrWhiteSpace()) { newExp = newExp.And(p => (p.sjdid.Contains(input.WTDH))); newExp = newExp.Or(p => (p.DWMC.Contains(input.WTDH))); newExp = newExp.Or(p => (p.ccbh.Contains(input.WTDH))); } newExp = newExp.And(p => p.JDZT == 122); var totalCount = _vwsjclDapperRepository.Count(newExp); IEnumerable <VW_SJCL_100> ret = _vwsjclDapperRepository.GetAllPaged( newExp, input.SkipCount / input.MaxResultCount, input.MaxResultCount, input.Sorting, input.Order == "desc"); // input.Order=="asc" true/false List <VW_SJCL_100> tempList2 = ObjectMapper.Map <List <VW_SJCL_100> >(ret); return(new PagedResultDto <VW_SJCL_100>( totalCount, tempList2 )); }
/// <summary> /// 首页未完成列表 /// JDZT<222 /// </summary> /// <param name="input"></param> /// <returns></returns> public PagedResultDto <VW_SJCL_100> GetPagedTasks(GetVwSjmxsInput input) { // 数据库里面必须有 SJMX 实体或者视图 Expression <Func <VW_SJCL_100, bool> > predicate = p => p.Id > 0; if (!input.FilterText.IsNullOrWhiteSpace()) { predicate = predicate.And(p => (p.DWMC.Contains(input.FilterText) || p.ccbh.Contains(input.FilterText) || p.xhggmc.Contains(input.FilterText) || p.QJMC.Contains(input.FilterText))); } predicate = predicate.And(p => p.JDZT < 222); var totalCount = _vwsjclDapperRepository.Count(predicate); IEnumerable <VW_SJCL_100> ret = _vwsjclDapperRepository.GetAllPaged( predicate, input.SkipCount / input.MaxResultCount, input.MaxResultCount, input.Sorting, input.Order == "desc"); // input.Order=="asc" true/false List <VW_SJCL_100> tempList2 = ObjectMapper.Map <List <VW_SJCL_100> >(ret); return(new PagedResultDto <VW_SJCL_100>( totalCount, tempList2 )); }
/* * // 待检定列表 - SJCLAppServices/GetPagedDjmxs * public IEnumerable<SJMX> ListDjmxs(string q) * { * string strSQL = @"select top 20 a.id,a.sjdid,qjmc,djrq,xhggmc,b.xhggbm,ccbh,zzcnr as zzc,jdy,a.bzsm,g.jdrq,g.jwrq,f.dwmc as wtdw,DATEADD(day, 14, djrq) as yqjcrq,a.jdzt as jdzt1, * g.jdzt as jdzt2,e.sjdid as wtdh * FROM dbo.YQSF_SJMX AS a LEFT JOIN * dbo.YQSF_SJD as e on a.sjdid = e.id LEFT JOIN * dbo.YQSF_KH as f on e.khid = f.khid LEFT JOIN * dbo.JCXX_XHGG_BM AS b ON a.XHGGBM = b.XHGGBM LEFT JOIN * dbo.JCXX_ZZC_BM AS c ON b.ZZCBM = c.ZZCBM LEFT JOIN * dbo.JCXX_QJMC_BM AS d ON b.QJMCBM = d.QJMCBM LEFT JOIN * dbo.SJCL_CHYQ as g on g.id = a.id * where d.QJMCBM = 1000 and e.djrq > '2019-04-21'"; // 查询searchAll * * strSQL += " and g.jdzt is null and a.jdzt<>'检完'"; // 待检:JDZT is null * * if (q != "") * { * strSQL += " and (ccbh like '%" + q + "%' or xhggmc like '%" + q + "%'"; * strSQL += ")"; * } * * IEnumerable<SJMX> ret = _sjmxDapperRepository.Query(strSQL); * return ret; * } * * public async Task<PagedResultDto<SJMXListDto>> GetPagedSjmxs(GetVwSjmxsInput input) * { * Expression<Func<SJMX, bool>> predicate = p => (p.Id != 1); * * var totalCount = _sjmxDapperRepository.Count(predicate); * * * var entityList = await _sjmxDapperRepository.GetAll() * .OrderByDescending(t => t.Id) * .PageBy(input) * .ToListAsync(); * var entityListDtos = ObjectMapper.Map<List<SJMXListDto>>(entityList); * * return new PagedResultDto<SJMXListDto>(totalCount, entityListDtos); * } */ public PagedResultDto <SJMX> GetPagedSjmxs(GetVwSjmxsInput input) { // 数据库里面必须有 SJMX 实体或者视图 // Expression<Func<SJMX, bool>> predicate = p => p.qjmc == "全站仪"; Expression <Func <SJMX, bool> > predicate = p => p.Id > 0; if (!input.FilterText.IsNullOrWhiteSpace()) { predicate = predicate.And(p => (p.xhggmc.Contains(input.FilterText) || p.ccbh.Contains(input.FilterText) || p.wtdh.Contains(input.FilterText) || p.wtdw.Contains(input.FilterText))); } var totalCount = _sjmxDapperRepository.Count(predicate); IEnumerable <SJMX> ret = _sjmxDapperRepository.GetAllPaged( predicate, input.SkipCount / input.MaxResultCount, input.MaxResultCount, input.Sorting, input.Order == "desc"); // input.Order=="asc" true/false List <SJMX> tempList2 = ObjectMapper.Map <List <SJMX> >(ret); return(new PagedResultDto <SJMX>( totalCount, tempList2 )); }
public PagedResultDto <VW_SJMX> GetPagedVwSjmxs(GetVwSjmxsInput input) { /* 方法一 * Expression condition = null; * ParameterExpression param = Expression.Parameter(typeof(VW_SJMX), "p"); * Expression right = Expression.Constant("-1"); * Expression left = Expression.Property(param, typeof(VW_SJMX).GetProperty("送检单号")); * Expression filter = Expression.NotEqual(left, right); // 送检单号 != -1 * condition = filter; * * right = Expression.Constant("12345"); * left = Expression.Property(param, typeof(VW_SJMX).GetProperty("送检单号")); * filter = Expression.Equal(left, right); * condition = Expression.And(condition, filter); * var predicate = Expression.Lambda<Func<VW_SJMX, bool>>(condition, param); */ /* 方法二 */ Expression <Func <VW_SJMX, bool> > predicate = p => p.器具名称 == "全站仪"; //if (input.From != null) // DateTime? 会有问题 if (input.From > DateTime.MinValue) { predicate = predicate.And(p => p.送检日期 >= DateTime.Parse(input.From.ToString())); // input.From } if (input.To > DateTime.MinValue) // != null { predicate = predicate.And(p => p.送检日期 <= DateTime.Parse(input.To.ToString())); // input.To } //if (!input.Filter.IsNullOrWhiteSpace()) if (!input.WTDH.IsNullOrWhiteSpace()) { predicate = predicate.And(p => p.送检单号.Contains(input.WTDH)); } if (!input.WTDW.IsNullOrWhiteSpace()) { predicate = predicate.And(p => p.单位名称.Contains(input.WTDW)); } var totalCount = _vwsjmxDapperRepository.Count(predicate); /* - 固定查询条件 * var totalCount1 = _vwsjmxDapperRepository.Count( * a => (a.器具名称 == "全站仪") && * a.送检单号.Contains(input.Filter) && * a.送检日期 >= input.From && * a.送检日期 <= input.To * ); * //IEnumerable<VW_SJMX> ret = _vwsjmxDapperRepository.GetAllPaged(x => x.器具名称 == "全站仪", 2, 20, "ID"); * //IEnumerable<VW_SJMX> ret = _vwsjmxDapperRepository.GetAllPaged(a =>(a.器具名称 == "全站仪") && a.送检单号.Contains(input.Filter), input.SkipCount/input.MaxResultCount, input.MaxResultCount, input.Sorting); */ //Logger.Info("input.Filter.IsNullOrWhiteSpace():" + input.Filter.IsNullOrWhiteSpace()); //Logger.Info("input.Filter.IsNullOrEmpty():" + input.Filter.IsNullOrEmpty()); //Logger.Info("input.Filter == ''" + (input.Filter == "")); //Logger.Info(predicate.Body.ToString()); //Logger.Info(predicate.Body.ToString()); IEnumerable <VW_SJMX> ret = _vwsjmxDapperRepository.GetAllPaged( predicate, input.SkipCount / input.MaxResultCount, input.MaxResultCount, input.Sorting, input.Order == "asc"); // input.Order=="asc" true/false /* * List<VW_SJMX> tempList = new List<VW_SJMX>(); * IEnumerator<VW_SJMX> currentEnumerator = ret.GetEnumerator(); * if (currentEnumerator != null) * { * for (int count = 0; currentEnumerator.MoveNext(); count++) * { * tempList.Add(currentEnumerator.Current); * } * } */ List <VW_SJMX> tempList2 = ObjectMapper.Map <List <VW_SJMX> >(ret); return(new PagedResultDto <VW_SJMX>( totalCount, tempList2 )); }