public IActionResult ScoreList(OwnRequestPayload payload)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var query = _dbContext.ScoreSetting.AsQueryable();
//姓名筛选
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.ScoreName.Contains(payload.Kw));
}
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
response.SetData(list, totalCount);
return(Ok(response));
}
}
public IActionResult ChangesList1(OwnRequestPayload payload)
{
using (_dbContext)
{
var query = from cd in _dbContext.GoodsExchange
join h in _dbContext.HomeAddress
on cd.SystemUserUuid equals h.HomeAddressUuid
where cd.IsDelete == "0"
select new
{
h.Address,
h.Score,
cd.StoreExchangeUuid,
cd.Shop.ShopName,
LoginName = h.Address,
cd.ExchageTime,
cd.DeduceScore,
cd.Goods.Gname,
cd.Id,
cd.SystemUserUuid
};
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.SystemUserUuid == Guid.Parse(payload.Kw));
}
if (payload.FirstSort != null)
{
query = query.OrderByDescending(x => x.ExchageTime);
}
//分页
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
}
public IActionResult ChangesList(OwnRequestPayload payload)
{
using (_dbContext)
{
var query = from cd in _dbContext.GoodsExchange
join h in _dbContext.HomeAddress
on cd.SystemUserUuid equals h.HomeAddressUuid
where cd.IsDelete == "0"
select new
{
h.Address,
h.Score,
cd.StoreExchangeUuid,
cd.Shop.ShopName,
LoginName = h.Address,
cd.ExchageTime,
cd.DeduceScore,
cd.Goods.Gname,
cd.Id,
cd.SystemUserUuid
};
//街道筛选
if (!string.IsNullOrEmpty(payload.street))
{
query = query.Where(x => x.Address.Contains(payload.street));
}
//社区筛选
if (!string.IsNullOrEmpty(payload.ccmmunity))
{
query = query.Where(x => x.Address.Contains(payload.ccmmunity));
}
//姓名筛选
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.LoginName.Contains(payload.Kw));
}
//商品名称
if (!string.IsNullOrEmpty(payload.kw1))
{
query = query.Where(x => x.ShopName.Contains(payload.kw1));
}
//时间筛选
if (!string.IsNullOrEmpty(payload.kw2[0]) && !string.IsNullOrEmpty(payload.kw2[1]))
{
var date1 = Convert.ToDateTime(payload.kw2[0]).ToString("yyyy-MM-dd HH:mm:ss");
var date2 = Convert.ToDateTime(payload.kw2[1]).ToString("yyyy-MM-dd HH:mm:ss");
query = query.Where(x => x.ExchageTime.CompareTo(date1) >= 0 && x.ExchageTime.CompareTo(date2) <= 0);
}
if (payload.FirstSort != null)
{
query = query.OrderByDescending(x => x.ExchageTime);
}
var entity = query.ToList().GroupBy(x => x.Address).Select(g => g.First());
//分页
var list = entity.AsQueryable().Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = entity.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
}
public IActionResult List(OwnRequestPayload payload)
{
using (_dbContext)
{
var query = _dbContext.Ownsource.Select(x => new
{
x.HomeAddressUuid,
x.Address,
x.Ccmmunity,
x.Town,
x.Resregion,
//x.used,//已使用积分
all = x.Alls, //累计积分
//x.can, //可用积分
x.LastScore,
x.NewScore,
State = x.State == 0 ? "未兑换" : "已兑换"
});;
//var query = from cd in _dbContext.HomeAddress
// select new
// {
// cd.HomeAddressUuid,
// cd.Address,
// cd.Ccmmunity,
// cd.Town,
// cd.Resregion,
// used = GetUsedScore(cd.HomeAddressUuid),//已使用积分
// all = GetAllScore(cd.HomeAddressUuid), //累计积分
// can = GetAllScore(cd.HomeAddressUuid) - GetUsedScore(cd.HomeAddressUuid) //可用积分
// };
if (AuthContextService.CurrentUser.Streets == "" && AuthContextService.CurrentUser.Community == "" && AuthContextService.CurrentUser.Biotope != "")
{
var Biotope = AuthContextService.CurrentUser.Biotope.Split(',');
query = query.Where(x => Biotope.Contains(x.Resregion));
}
else if (AuthContextService.CurrentUser.Streets == "" && AuthContextService.CurrentUser.Community != "" && AuthContextService.CurrentUser.Biotope == "")
{
var Community = AuthContextService.CurrentUser.Community.Split(',');
query = query.Where(x => Community.Contains(x.Ccmmunity));
}
else if (AuthContextService.CurrentUser.Streets != "" && AuthContextService.CurrentUser.Community == "" && AuthContextService.CurrentUser.Biotope == "")
{
var Streets = AuthContextService.CurrentUser.Streets.Split(',');
query = query.Where(x => Streets.Contains(x.Town));
}
else if (AuthContextService.CurrentUser.Streets != "" && AuthContextService.CurrentUser.Community != "" && AuthContextService.CurrentUser.Biotope == "")
{
var Streets = AuthContextService.CurrentUser.Streets.Split(',');
var Community = AuthContextService.CurrentUser.Community.Split(',');
query = query.Where(x => Streets.Contains(x.Town) || Community.Contains(x.Ccmmunity));
}
else if (AuthContextService.CurrentUser.Streets != "" && AuthContextService.CurrentUser.Community == "" && AuthContextService.CurrentUser.Biotope != "")
{
var Streets = AuthContextService.CurrentUser.Streets.Split(',');
var Biotope = AuthContextService.CurrentUser.Biotope.Split(',');
query = query.Where(x => Streets.Contains(x.Town) || Biotope.Contains(x.Resregion));
}
else if (AuthContextService.CurrentUser.Streets == "" && AuthContextService.CurrentUser.Community != "" && AuthContextService.CurrentUser.Biotope != "")
{
var Community = AuthContextService.CurrentUser.Community.Split(',');
var Biotope = AuthContextService.CurrentUser.Biotope.Split(',');
query = query.Where(x => Community.Contains(x.Ccmmunity) || Biotope.Contains(x.Resregion));
}
else if (AuthContextService.CurrentUser.Streets != "" && AuthContextService.CurrentUser.Community != "" && AuthContextService.CurrentUser.Biotope != "")
{
var Streets = AuthContextService.CurrentUser.Streets.Split(',');
var Community = AuthContextService.CurrentUser.Community.Split(',');
var Biotope = AuthContextService.CurrentUser.Biotope.Split(',');
query = query.Where(x => Streets.Contains(x.Town) || Community.Contains(x.Ccmmunity) || Biotope.Contains(x.Resregion));
}
//街道筛选
if (!string.IsNullOrEmpty(payload.street))
{
query = query.Where(x => x.Address.Contains(payload.street));
}
//社区筛选
if (!string.IsNullOrEmpty(payload.ccmmunity))
{
query = query.Where(x => x.Address.Contains(payload.ccmmunity));
}
//地址筛选
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.Address.Contains(payload.Kw));
}
if (payload.FirstSort != null)
{
query = query.OrderByDescending(x => x.all);
}
//if (payload.IsDeleted > CommonEnum.IsDeleted.All)
//{
// query = query.Where(x => (CommonEnum.IsDeleted)int.Parse(x.IsDeleted) == payload.IsDeleted);
//}
//分页
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
var response = ResponseModelFactory.CreateResultInstance;
response.SetData(list, totalCount);
return(Ok(response));
}
}
