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