public TicketParam getTicketItem(string openId, string ticketCode) { string sql = "select b.brand,b.price,t.img,t.ticketCode,t.shopName from t_daigou_brand b,t_daigou_ticket t where b.ticketCode =t.ticketCode and b.ticketCode = '" + ticketCode + "' and t.openId = '" + openId + "'"; DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "t_daigou_ticket").Tables[0]; if (dt.Rows.Count > 0) { TicketParam tp = new TicketParam(); tp.imgbasesrc = dt.Rows[0]["img"].ToString(); tp.shopName = dt.Rows[0]["shopName"].ToString(); tp.ticketNum = dt.Rows[0]["ticketCode"].ToString(); tp.goodsAll = new List <BrandParam>(); for (int i = 0; i < dt.Rows.Count; i++) { BrandParam bp = new BrandParam(); bp.goodsName = dt.Rows[i]["brand"].ToString(); bp.goodsPrice = dt.Rows[i]["price"].ToString(); tp.goodsAll.Add(bp); } return(tp); } else { return(null); } }
public async Task <Result> Post([FromBody] BrandParam model) { var brand = new Brand { Name = model.Name, Slug = model.Slug, Description = model.Description, IsPublished = model.IsPublished }; await _brandService.Create(brand); return(Result.Ok()); }
public async Task <Result> Put(int id, [FromBody] BrandParam model) { var brand = await _brandRepository.FirstOrDefaultAsync(id); if (brand == null) { return(Result.Fail("单据不存在")); } brand.Description = model.Description; brand.Name = model.Name; brand.Slug = model.Slug; brand.IsPublished = model.IsPublished; await _brandService.Update(brand); return(Result.Ok()); }
public async Task <string> QueryPagedAsync([FromQuery] BrandParam param) { var filter = param.SearchLambda <Brand, BrandParam>(); var result = await _brandRepository.QueryPagedAsync(param.PageNum, param.PageSize, null, filter); var pageData = new PagedDto <Brand> { Code = 200, Msg = "获取数据成功", Total = result.TotalResults, PageSize = param.PageSize, Data = result.Items.ToList() }; var json = pageData.ToString(); return(json); }
public async Task <Result> Get(int id) { var brand = await _brandRepository.FirstOrDefaultAsync(id); if (brand == null) { return(Result.Fail("单据不存在")); } var model = new BrandParam { Id = brand.Id, Name = brand.Name, Slug = brand.Slug, Description = brand.Description, IsPublished = brand.IsPublished }; return(Result.Ok(model)); }