/// <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
));
}
