public JsonResult BackGoodsList(PageParm parm, SearchParm searchParm)
{
var res = _backService.GetPagesAsync(parm, searchParm).Result;
var list = res.data.Items?.Select(m => new {
m.Code,
m.BackCount,
GoodsName = m.BrandName + m.StyleName + m.SeasonName,
AddDate = m.AddDate.ToShortDateString().Replace("/", "-")
});
return(Json(new { statusCode = 200, msg = "success", count = res.data.TotalPages, data = list }));
}
public JsonResult ReturnOrderGoodsList(PageParm parm, SearchParm searchParm)
{
var res = _goodsService.GetPagesAsync(parm, searchParm).Result;
var list = res.data.Items?.Select(m => new {
m.Code,
m.BrandName,
m.StyleName,
m.SeasonName,
m.Counts
});
return(Json(new { statusCode = 200, msg = "success", count = res.data.TotalPages, data = list }));
}
/// <summary>
/// 分页
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public async Task <ApiResult <Page <GoodsSkuDto> > > GetPagesAsync(PageParm parm, SearchParm searchParm)
{
var res = new ApiResult <Page <GoodsSkuDto> >();
try
{
var query = Db.Queryable <ErpInOutLog>()
.WhereIF(parm.types != 0, m => m.Types == parm.types)
.WhereIF(!string.IsNullOrEmpty(parm.key),
m => SqlFunc.Subqueryable <ErpGoodsSku>().Where(g => g.Guid == m.GoodsGuid).Select(g => g.Code).Contains(parm.key))
.WhereIF(!string.IsNullOrEmpty(parm.guid), m => m.ShopGuid == parm.guid)
.WhereIF(!string.IsNullOrEmpty(searchParm.brank),
m => SqlFunc.Subqueryable <ErpGoodsSku>().Where(g => g.Guid == m.GoodsGuid).Select(g => g.BrankGuid) == searchParm.brank)
.Where(m => m.PackGuid == searchParm.packGuid)
.OrderBy(m => m.AddDate, OrderByType.Desc)
.Select(m => new GoodsSkuDto()
{
Guid = m.Guid,
Code = m.GoodsSku,
StockSum = m.GoodsSum,
AddDate = m.AddDate,
BrankName = SqlFunc.Subqueryable <SysCode>().Where(g => g.Guid == SqlFunc.Subqueryable <ErpGoodsSku>().Where(t => t.Guid == m.GoodsGuid).Select(t => t.BrankGuid)).Select(g => g.Name),
StyleName = SqlFunc.Subqueryable <SysCode>().Where(g => g.Guid == SqlFunc.Subqueryable <ErpGoodsSku>().Where(t => t.Guid == m.GoodsGuid).Select(t => t.StyleGuid)).Select(g => g.Name)
})
.ToPageAsync(parm.page, parm.limit);
res.success = true;
res.message = "获取成功！";
res.data = await query;
}
catch (Exception ex)
{
res.message = ApiEnum.Error.GetEnumText() + ex.Message;
res.statusCode = (int)ApiEnum.Error;
}
return(await Task.Run(() => res));
}
public JsonResult SaleOrderGoodsList(PageParm parm, SearchParm searchParm)
{
var res = _goodsService.GetPagesAsync(parm, searchParm).Result;
return(Json(new { statusCode = 200, msg = "success", count = res.data.TotalPages, data = res.data.Items }));
}
/// <summary>
/// 分页
/// </summary>
/// <param name="parm"></param>
/// <returns></returns>
public async Task <ApiResult <Page <BackGoodsDto> > > GetPagesAsync(PageParm parm, SearchParm searchParm)
{
var res = new ApiResult <Page <BackGoodsDto> >();
try
{
string beginTime = string.Empty, endTime = string.Empty;
if (!string.IsNullOrEmpty(parm.time))
{
var timeRes = Utils.SplitString(parm.time, '-');
beginTime = timeRes[0].Trim();
endTime = timeRes[1].Trim();
}
var query = Db.Queryable <ErpBackGoods, ErpGoodsSku, ErpShops, ErpStaff>((ebg, eg, es, est) => new object[] {
JoinType.Left, ebg.GoodsGuid == eg.Guid,
JoinType.Left, ebg.ShopGuid == es.Guid,
JoinType.Left, ebg.AdminGuid == est.Guid
})
.WhereIF(!string.IsNullOrEmpty(searchParm.shopGuid), (ebg, eg, es, est) => ebg.ShopGuid == searchParm.shopGuid)
.WhereIF(!string.IsNullOrEmpty(searchParm.brank), (ebg, eg, es, est) => eg.BrankGuid == searchParm.brank)
.WhereIF(!string.IsNullOrEmpty(parm.key), (ebg, eg, es, est) => ebg.Number == parm.key)
.WhereIF(!string.IsNullOrEmpty(parm.time), (ebg, eg, es, est) => ebg.AddDate >= Convert.ToDateTime(beginTime) && ebg.AddDate <= Convert.ToDateTime(endTime))
.OrderBy((ebg, eg, es, est) => ebg.AddDate, OrderByType.Desc)
.Select((ebg, eg, es, est) => new BackGoodsDto()
{
Number = ebg.Guid,
Code = eg.Code,
OrderNumber = ebg.OrderNumber,
BrandName = SqlFunc.Subqueryable <SysCode>().Where(g => g.Guid == eg.BrankGuid).Select(g => g.Name),
SeasonName = SqlFunc.Subqueryable <SysCode>().Where(g => g.Guid == eg.SeasonGuid).Select(g => g.Name),
StyleName = SqlFunc.Subqueryable <SysCode>().Where(g => g.Guid == eg.StyleGuid).Select(g => g.Name),
ShopName = es.ShopName,
Operator = est.TrueName,
Mobile = est.Mobile,
BackCount = ebg.BackCount,
Money = ebg.BackMoney,
Status = ebg.Status,
Summary = ebg.Summary,
AddDate = ebg.AddDate
})
.OrderByIF(!string.IsNullOrEmpty(parm.field) && !string.IsNullOrEmpty(parm.order), parm.field + " " + parm.order)
.ToPage(parm.page, parm.limit);
res.success = true;
res.message = "获取成功！";
res.data = query;
}
catch (Exception ex)
{
res.message = ApiEnum.Error.GetEnumText() + ex.Message;
res.statusCode = (int)ApiEnum.Error;
}
return(await Task.Run(() => res));
}
public async Task <JsonResult> GetInPages(PageParm parm, SearchParm searchParm)
{
var res = await _inOutLogService.GetPagesAsync(parm, searchParm);
return(Json(new { code = 0, msg = "success", count = res.data?.TotalItems, data = res.data?.Items }));
}
/// <summary>
/// 查询多条记录
/// </summary>
/// <returns></returns>
public Task <ApiResult <Page <SaleOrderGoodsDto> > > GetPagesAsync(PageParm parm, SearchParm searchParm)
{
var res = new ApiResult <Page <SaleOrderGoodsDto> >();
try
{
var query = Db.Queryable <ErpSaleOrderGoods, ErpGoodsSku>((eso, egs) => new object[] { JoinType.Left, eso.GoodsGuid == egs.Guid })
.WhereIF(!string.IsNullOrEmpty(parm.guid), (eso, egs) => eso.OrderNumber == parm.guid)
.WhereIF(!string.IsNullOrEmpty(searchParm.shopGuid), (eso, egs) => eso.ShopGuid == searchParm.shopGuid)
.WhereIF(!string.IsNullOrEmpty(searchParm.brank), (eso, egs) => egs.BrankGuid == searchParm.brank)
.Select((eso, egs) => new SaleOrderGoodsDto()
{
Guid = eso.Guid,
BrandName = SqlFunc.Subqueryable <SysCode>().Where(g => g.Guid == egs.BrankGuid).Select(g => g.Name),
SeasonName = SqlFunc.Subqueryable <SysCode>().Where(g => g.Guid == egs.SeasonGuid).Select(g => g.Name),
StyleName = SqlFunc.Subqueryable <SysCode>().Where(g => g.Guid == egs.StyleGuid).Select(g => g.Name),
Code = egs.Code,
Counts = eso.Counts
})
.ToPage(parm.page, parm.limit);
res.success = true;
res.message = "获取成功！";
res.data = query;
}
catch (Exception ex)
{
res.message = ApiEnum.Error.GetEnumText() + ex.Message;
res.statusCode = (int)ApiEnum.Error;
}
return(Task.Run(() => res));
}
public async Task <JsonResult> GetSaleGoodsPagesByNumber(PageParm parm, SearchParm searchParm)
{
var res = await _goodService.GetPagesAsync(parm, searchParm);
return(Json(new { code = 0, msg = "success", count = res.data?.TotalItems, data = res.data?.Items }));
}
