public APIResult GetList([FromBody] GetListArgsModel args)
{
if (!args.ShopBrandId.HasValue)
{
throw new ArgumentNullException("ShopBrandId");
}
var brandId = args.ShopBrandId.Value;
CheckShopBrandActor(brandId, ShopBrandActorType.超级管理员);
var query = db.Query <ShopBrandCommodityParameter>()
.Where(m => !m.IsDel)
.Where(m => m.ShopBrandId == args.ShopBrandId);
var list = query
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
AddIp = m.AddIp,
AddTime = m.AddTime,
AddUser = m.AddUser,
Id = m.Id,
IsDel = m.IsDel,
Name = m.Name,
Flag = m.Flag,
ShopBrandId = m.ShopBrandId
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
var query = db.Query <ShopCommodityStock>()
.Where(m => !m.IsDel);
var list = query
.Where(m => m.ShopId == args.ShopId)
.Where(m => m.Sku.CommodityId == args.CommodityId)
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
CostPrice = m.CostPrice,
Id = m.Id,
SalePrice = m.SalePrice,
MarketPrice = m.MarketPrice,
SkuId = m.SkuId,
Stock = m.Stock
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
var query = db.Query <ShopBrandActor>()
.Where(m => !m.IsDel);
if (args.ShopBrandId.HasValue)
{
query = query.Where(m => m.ShopBrandId == args.ShopBrandId);
}
var list = query
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
AddIp = m.AddIp,
AddTime = m.AddTime,
AddUser = m.AddUser,
Id = m.Id,
ActorType = m.ActorType,
MemberId = m.MemberId,
ShopBrandId = m.ShopBrandId,
ShopBrandName = m.ShopBrand.Name
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
var query = db.Query <CommercialDistrictShop>()
.Where(m => !m.IsDel);
if (args.CommercialDistrictId.HasValue)
{
query = query.Where(m => m.CommercialDistrictId == args.CommercialDistrictId);
}
var list = query
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
AddIp = m.AddIp,
AddTime = m.AddTime,
AddUser = m.AddUser,
Id = m.Id,
IsDel = m.IsDel,
ShopName = m.Shop.Name
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
if (!args.ShopId.HasValue)
{
throw new ArgumentNullException("ShopId");
}
CheckShopActor(args.ShopId.Value, ShopActorType.超级管理员);
var query = db.Query <ShopCommodityStock>()
.Where(m => !m.IsDel);
var list = query
.Where(m => m.ShopId == args.ShopId.Value)
.Where(m => m.Sku.CommodityId == args.CommodityId)
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
CostPrice = m.CostPrice,
Id = m.Id,
SalePrice = m.SalePrice,
MarketPrice = m.MarketPrice,
SkuId = m.SkuId,
Stock = m.Stock
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
var query = db.Query <ShopBrandCommodityParameter>()
.Where(m => !m.IsDel);
if (args.ShopBrandId.HasValue)
{
query = query.Where(m => m.ShopBrandId == args.ShopBrandId);
}
var list = query
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
AddIp = m.AddIp,
AddTime = m.AddTime,
AddUser = m.AddUser,
Id = m.Id,
IsDel = m.IsDel,
Name = m.Name,
Flag = m.Flag,
ShopBrandId = m.ShopBrandId
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult <GetListModel> GetList([FromBody] GetListArgsModel args)
{
var query = wechatCoreDb.QueryRobotMessage()
.Where(m => !m.IsDel);
if (args.Status.HasValue)
{
query = query.Where(m => m.Status == args.Status.Value);
}
if (!string.IsNullOrEmpty(args.Question))
{
query = query.Where(m => m.Question.Contains(args.Question));
}
if (args.QuestionType.HasValue)
{
query = query.Where(m => m.QuestionType == args.QuestionType.Value);
}
var list = query
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
Id = m.Id,
Question = m.Question,
QuestionType = m.QuestionType,
Answer = m.Answer,
Status = m.Status
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
if (!args.ShopId.HasValue)
{
throw new ArgumentNullException("ShopId");
}
CheckShopActor(args.ShopId.Value, ShopActorType.超级管理员);
var query = db.Query <ShopCallingQueueProduct>()
.Where(m => !m.IsDel);
var list = query
.Where(m => m.ShopId == args.ShopId.Value)
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
Detail = m.Detail,
Status = m.Status,
Title = m.Title,
Name = m.Name,
Id = m.Id,
ShopId = m.ShopId
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
var query = db.Query <ShopCallingQueue>()
.Where(m => !m.IsDel);
var list = query
.Where(m => m.ShopId == args.ShopId)
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
AddTime = m.AddTime,
CanShareTable = m.CanShareTable,
ProductId = m.ProductId,
QueueIndex = m.QueueIndex,
QueueNumber = m.QueueNumber,
RefuseReason = m.RefuseReason,
Remark = m.Remark,
Status = m.Status,
Title = m.Title,
Id = m.Id,
MemberId = m.MemberId,
ShopId = m.ShopId,
IsUsed = m.IsUsed
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
var query = db.Query <ShopOrder>()
.Where(m => !m.IsDel);
var list = query
.Where(m => m.ShopId == args.ShopId)
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
AddTime = m.AddTime,
Remark = m.Remark,
Status = m.Status,
Phone = m.Phone,
Id = m.Id,
MemberId = m.MemberId,
ShopId = m.ShopId,
AddIp = m.AddIp,
AddUser = m.AddUser,
Amount = m.Amount,
FinishTime = m.FinishTime,
Flag = m.Flag,
PayTime = m.PayTime
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
var query = db.Query <ShopBooking>()
.Where(m => !m.IsDel);
var list = query
.Where(m => m.ShopId == args.ShopId)
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
AddTime = m.AddTime,
RefuseReason = m.RefuseReason,
Remark = m.Remark,
Status = m.Status,
DinnerTime = m.DinnerTime,
Nickname = m.Nickname,
Phone = m.Phone,
Users = m.Users,
Id = m.Id,
MemberId = m.MemberId,
ShopId = m.ShopId,
IsUsed = m.IsUsed
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult <GetListModel> GetList([FromBody] GetListArgsModel args)
{
if (!args.CommodityId.HasValue)
{
throw new ArgumentNullException("CommodityId");
}
CheckShopBrandActorByCommodityId(args.CommodityId.Value, ShopBrandActorType.超级管理员);
var skuIds = db.Query <ShopBrandCommoditySku>()
.Where(m => !m.IsDel)
.Where(m => m.CommodityId == args.CommodityId.Value)
.Select(m => m.Id)
.ToList();
var list = db.Query <ShopBrandCommoditySkuItem>()
.Where(m => !m.IsDel)
.Where(m => !m.ParameterValue.IsDel)
.Where(m => skuIds.Contains(m.SkuId))
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
ParameterName = m.Parameter.Name,
ParameterId = m.ParameterId,
ParameterValue = m.ParameterValue.Value,
ParameterValueId = m.ParameterValueId
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
//[Authorize(AuthenticationSchemes = "jwt")]
public APIResult GetList([FromBody] GetListArgsModel args)
{
if (string.IsNullOrEmpty(args.ShopFlag))
{
throw new Exception("ShopFlag不能为空");
}
var query = db.Query <ShopPart>()
.Where(m => !m.IsDel)
.Where(m => m.Shop.Flag == args.ShopFlag);
var list = query
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
Detail = m.Detail,
Flag = m.Flag,
Id = m.Id,
ShopId = m.ShopId,
Title = m.Title
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
var skuIds = db.Query <ShopBrandCommoditySku>()
.Where(m => !m.IsDel)
.Where(m => m.CommodityId == args.CommodityId)
.Select(m => m.Id)
.ToList();
var list = db.Query <ShopBrandCommoditySkuItem>()
.Where(m => !m.IsDel)
.Where(m => skuIds.Contains(m.SkuId))
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
ParameterName = m.Parameter.Name,
ParameterId = m.ParameterId,
ParameterValue = m.ParameterValue.Value,
ParameterValueId = m.ParameterValueId
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
using (var db = dbFactory.Create(_communityService, args.CommunityFlag, args.AppFlag))
{
var query = db.Query <SettingBase>()
.Where(m => !m.IsDel);
var list = query
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
Detail = m.Detail,
Flag = m.Flag,
GroupFlag = m.GroupFlag,
Id = m.Id,
IsDel = m.IsDel,
SettingType = m.SettingType,
Value = m.Value
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
if (!args.ShopId.HasValue)
{
throw new ArgumentNullException("ShopId");
}
CheckShopActor(args.ShopId.Value, ShopActorType.超级管理员);
var query = db.Query <ShopPart>()
.Where(m => !m.IsDel);
var list = query
.Where(m => m.ShopId == args.ShopId.Value)
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
AddIp = m.AddIp,
AddTime = m.AddTime,
AddUser = m.AddUser,
Detail = m.Detail,
Flag = m.Flag,
Id = m.Id,
IsDel = m.IsDel,
ShopId = m.ShopId,
Title = m.Title
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
var query = db.Query <CommercialDistrict>()
.Where(m => !m.IsDel);
var list = query
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
AddIp = m.AddIp,
AddTime = m.AddTime,
AddUser = m.AddUser,
Flag = m.Flag,
Id = m.Id,
Address = m.Address,
Detail = m.Detail,
IsDel = m.IsDel,
Name = m.Name,
Status = m.Status,
Latitude = m.Latitude,
Longitude = m.Longitude
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult <GetListForVueRouteModel> GetListForVueRoute([FromBody] GetListArgsModel args)
{
var username = GetUsername();
var items = _communityService.GetList(username);
return(Success <GetListForVueRouteModel>(new GetListForVueRouteModel(items)));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
var query = db.Query <ShopBrandCommodityCategory>()
.Where(m => !m.IsDel);
if (args.ShopBrandId.HasValue)
{
var brandId = args.ShopBrandId.Value;
query = query.Where(m => m.ShopBrandId == brandId);
}
var list = query
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
Id = m.Id,
Name = m.Name,
OrderWeight = m.OrderWeight,
Detail = m.Detail,
ParentName = m.Parent.Name,
PId = m.PId,
Flag = m.Flag,
Ico = m.Ico,
IsDel = m.IsDel,
Keywords = m.Keywords,
Description = m.Description,
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult <GetListModel> GetList([FromBody] GetListArgsModel args)
{
var username = GetUsername();
var items = _communityService.GetListForBase(username);
return(Success <GetListModel>(new GetListModel
{
Items = items
}));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
try
{
var username = GetUsername();
var items = _communityService.GetListForBase(username);
return(Success <GetListModel>(new GetListModel
{
Items = items
}));
}
catch (Exception ex)
{
_logger.LogError(0, ex, "GetList有错误发生");
return(Error(ex.Message));
}
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
if (string.IsNullOrEmpty(args.ShopFlag))
{
throw new Exception("ShopFlag不能为空");
}
var query = db.Query <ShopCommodityStock>()
.Where(m => !m.IsDel)
.Where(m => m.Shop.Flag == args.ShopFlag);
if (!string.IsNullOrEmpty(args.CategoryFlag))
{
query = query.Where(m => m.Sku.Commodity.Category.Flag == args.CategoryFlag);
}
var items = query
.Select(m => new
{
Name = m.Sku.Commodity.Name,
CommodityId = m.Sku.CommodityId,
SalesForMonth = m.Sku.Commodity.SalesForMonth,
Upvote = m.Sku.Commodity.Upvote,
Cover = m.Sku.Commodity.Cover,
SalePrice = m.SalePrice,
MarketPrice = m.MarketPrice,
Detail = m.Sku.Commodity.Detail
})
.GroupBy(m => m.CommodityId)
.Select(m => new CommodityRowitem
{
Name = m.First().Name,
SalesForMonth = m.First().SalesForMonth,
Upvote = m.First().Upvote,
SalePrice = m.First().SalePrice,
Cover = m.First().Cover,
MarketPrice = m.First().MarketPrice,
Detail = m.First().Detail,
})
.ToList();
return(Success(new GetListModel()
{
Items = items
}));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
if (!args.ShopId.HasValue)
{
throw new ArgumentNullException("ShopId");
}
CheckShopActor(args.ShopId.Value, ShopActorType.超级管理员);
var list = db.Query <ShopOrderMoneyOff>()
.Where(m => !m.IsDel)
.Where(m => m.ShopId == args.ShopId.Value)
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
if (!args.ShopBrandId.HasValue)
{
throw new ArgumentNullException("ShopBrandId");
}
var brandId = args.ShopBrandId.Value;
CheckShopBrandActor(brandId, ShopBrandActorType.超级管理员);
var query = db.Query <ShopBrandCommodity>()
.Where(m => !m.IsDel)
.Where(m => m.ShopBrandId == args.ShopBrandId);
var list = query
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
AddIp = m.AddIp,
AddTime = m.AddTime,
AddUser = m.AddUser,
Flag = m.Flag,
Id = m.Id,
Detail = m.Detail,
IsDel = m.IsDel,
Name = m.Name,
Cover = m.Cover,
IsRecommand = m.IsRecommand,
Price = m.Price,
SalesForMonth = m.SalesForMonth,
ShopBrandId = m.ShopBrandId,
Summary = m.Summary,
Unit = m.Unit,
Upvote = m.Upvote,
CategoryName = m.Category.Name,
CategoryId = m.CategoryId
})
.ToList();
return(Success(new ShopBrandCommoditySetAPIModels.GetListModel()
{
Items = list
}));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
if (!args.ShopBrandId.HasValue)
{
throw new ArgumentNullException("ShopBrandId");
}
var brandId = args.ShopBrandId.Value;
CheckShopBrandActor(brandId, ShopBrandActorType.超级管理员);
var query = db.Query <ShopBrandCommodityCategory>()
.Where(m => !m.IsDel)
.Where(m => m.ShopBrandId == brandId);
var list = query
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
Id = m.Id,
Name = m.Name,
OrderWeight = m.OrderWeight,
Detail = m.Detail,
ParentName = m.Parent.Name,
PId = m.PId,
Flag = m.Flag,
Ico = m.Ico,
IsDel = m.IsDel,
Keywords = m.Keywords,
Description = m.Description,
})
.ToList();
list.Add(new RowItem()
{
Name = "套餐",
Id = 0
});
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
var query = db.Query <Shop>()
.Where(m => !m.IsDel);
if (args.ShopBrandId.HasValue)
{
query = query.Where(m => m.ShopBrandId == args.ShopBrandId);
}
var list = query
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
AddIp = m.AddIp,
AddTime = m.AddTime,
AddUser = m.AddUser,
Flag = m.Flag,
Logo = m.Logo,
Id = m.Id,
Address = m.Address,
AddressGuide = m.AddressGuide,
Detail = m.Detail,
IsDel = m.IsDel,
Latitude = m.Latitude,
Longitude = m.Longitude,
Name = m.Name,
OpenTime = m.OpenTime,
ScoreValue = m.ScoreValue,
Tel = m.Tel,
UsePerUser = m.UsePerUser,
ShopBrandId = m.ShopBrandId,
IsShowApplets = m.IsShowApplets
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult <GetListModel> GetList([FromBody] GetListArgsModel args)
{
var query = memberDb.QueryMember()
.Where(m => !m.IsDel);
if (args.Status.HasValue)
{
query = query.Where(m => m.Status == args.Status.Value);
}
if (!string.IsNullOrEmpty(args.Email))
{
query = query.Where(m => m.Email.Contains(args.Email));
}
if (!string.IsNullOrEmpty(args.Truename))
{
query = query.Where(m => m.Truename.Contains(args.Truename));
}
var list = query
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
Id = m.Id,
Email = m.Email,
EmailIsValid = m.EmailIsValid,
LastLoginIP = m.LastLoginIP,
LastLoginTime = m.LastLoginTime,
LoginCount = m.LoginCount,
Truename = m.Truename,
RegIP = m.RegIP,
RegTime = m.RegTime,
Status = m.Status
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
var query = db.Query <ShopBrandCommodity>()
.Where(m => !m.IsDel);
if (args.ShopBrandId.HasValue)
{
query = query.Where(m => m.ShopBrandId == args.ShopBrandId);
}
var list = query
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
AddIp = m.AddIp,
AddTime = m.AddTime,
AddUser = m.AddUser,
Flag = m.Flag,
Id = m.Id,
Detail = m.Detail,
IsDel = m.IsDel,
Name = m.Name,
Cover = m.Cover,
IsRecommand = m.IsRecommand,
Price = m.Price,
SalesForMonth = m.SalesForMonth,
ShopBrandId = m.ShopBrandId,
Summary = m.Summary,
Unit = m.Unit,
Upvote = m.Upvote,
CategoryName = m.Category.Name,
CategoryId = m.CategoryId
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
if (!args.ShopId.HasValue)
{
throw new ArgumentNullException("ShopId");
}
CheckShopActor(args.ShopId.Value, ShopActorType.超级管理员);
var query = db.Query <ShopOrder>()
.Where(m => !m.IsDel);
var list = query
.Where(m => m.ShopId == args.ShopId.Value)
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
AddTime = m.AddTime,
Remark = m.Remark,
Status = m.Status,
Phone = m.Phone,
Id = m.Id,
MemberId = m.MemberId,
ShopId = m.ShopId,
ShopPartTitle = m.ShopPart.Title,
ShopPartId = m.ShopPartId,
AddIp = m.AddIp,
AddUser = m.AddUser,
Amount = m.Amount,
FinishTime = m.FinishTime,
Flag = m.Flag,
PayTime = m.PayTime
})
.ToList();
return(Success(new ShopOrderSetAPIModels.GetListModel()
{
Items = list
}));
}
public APIResult GetList([FromBody] GetListArgsModel args)
{
var query = db.Query <ShopCallingQueueProduct>()
.Where(m => !m.IsDel);
var list = query
.Where(m => m.ShopId == args.ShopId)
.OrderByDescending(m => m.Id)
.Select(m => new RowItem()
{
Detail = m.Detail,
Status = m.Status,
Title = m.Title,
Id = m.Id,
ShopId = m.ShopId
})
.ToList();
return(Success(new GetListModel()
{
Items = list
}));
}
