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