public async Task <Category> GetByIDAsync(int id)
{
string sql = @"SELECT Id
,Name
FROM category
WHERE Id = @Id";
return(await _context.QueryFirstOrDefaultAsync <Category>(sql, new { Id = id }));
}
public async Task <Products> GetByIDAsync(int id)
{
string sql = @"SELECT ProductID
,ProductName
,QuantityPerUnit
,UnitPrice
,CategoryID
FROM Products
WHERE ProductID = @ProductID";
return(await _context.QueryFirstOrDefaultAsync <Products>(sql, new { ProductID = id }));
}
public async Task <Product> GetByIDAsync(int id)
{
string sql = @"SELECT Id
,Name
,Quantity
,Price
,CategoryId
FROM Product
WHERE Id = @Id";
return(await _context.QueryFirstOrDefaultAsync <Product>(sql, new { Id = id }));
}
public async Task <UserAddress> GetByIdAsync(int id)
{
return(await _context.QueryFirstOrDefaultAsync <UserAddress>("SELECT * FROM UserAddress WHERE Id=@Id", new { Id = id }));
}
public async Task <int> GetTotalCount(string sWhere, Dapper.DynamicParameters param)
{
string sql = string.Format("select count(1) from Sys_AlarmLevel where 1=1 {0}", sWhere);
return(await _context.QueryFirstOrDefaultAsync <int>(sql, param));
}
public async Task <Product> GetByIdAsync(int id)
{
return(await _context.QueryFirstOrDefaultAsync <Product>("SELECT * FROM Product WHERE Id=@Id", new { Id = id }));
}
/// <summary>
/// 获取详情-sql通用查询
/// </summary>
/// <typeparam name="TEnity">根据sql定义Model</typeparam>
/// <param name="sql"></param>
/// <param name="param"></param>
/// <param name="isCommandTypeText"></param>
/// <param name="isInvoke">是否是委托方法里的执行sql</param>
/// <returns></returns>
public Task <TEnity> SQLQueryFirstOrDefaultAsync <TEnity>(string sql, object param = null, bool isCommandTypeText = true, bool isInvoke = false)
{
return(_context.QueryFirstOrDefaultAsync <TEnity>(sql, param, isCommandTypeText ? CommandType.Text : CommandType.StoredProcedure, isInvoke));
}