/// <summary>
/// 创建餐别
/// </summary>
/// <param name="category"></param>
/// <returns></returns>
public async Task <string> CreateCategory(MealCategoryModel category)
{
using (var conn = MySqlHelper.GetConnection())
{
return(await conn.InsertAsync <string, MealCategoryModel>(category));
}
}
/// <summary>
/// 更新餐别
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <int> UpdateCategory(MealCategoryModel model)
{
using (var conn = MySqlHelper.GetConnection())
{
return(await conn.UpdateAsync(model));
}
}
/// <summary>
/// 删除餐别
/// </summary>
/// <param name="hospitalId"></param>
/// <param name="categoryGuid"></param>
/// <returns></returns>
public async Task <bool> DeleteCategory(MealCategoryModel model)
{
return(await MySqlHelper.TransactionAsync(async (conn, tran) =>
{
await conn.DeleteListAsync <MealMenuModel>("where category_guid = @categoryGuid", new { model.CategoryGuid });
await UpdateCategory(model);
return true;
}));
}
