/// <summary>
/// 新增商户班次模板
/// </summary>
/// <param name="model">班次模板model</param>
/// <param name="workShifts">班次model集合</param>
/// <param name="details">班次详细model集合</param>
/// <returns></returns>
public async Task <bool> AddWorkShiftTemplateAsync(MerchantWorkShiftTemplateModel model, List <MerchantWorkShiftModel> workShifts, List <MerchantWorkShiftDetailModel> details)
{
return(await MySqlHelper.TransactionAsync(async (conn, tran) =>
{
if (string.IsNullOrEmpty(await conn.InsertAsync <string, MerchantWorkShiftTemplateModel>(model)))
{
return false;
}
foreach (var item in workShifts)
{
if (string.IsNullOrEmpty(await conn.InsertAsync <string, MerchantWorkShiftModel>(item)))
{
return false;
}
}
foreach (var item in details)
{
if (string.IsNullOrEmpty(await conn.InsertAsync <string, MerchantWorkShiftDetailModel>(item)))
{
return false;
}
}
return true;
}));
}
/// <summary>
/// 修改商户班次模板
/// </summary>
/// <param name="model"></param>
/// <param name="workShifts"></param>
/// <param name="details"></param>
/// <returns></returns>
public async Task <bool> ModifyWorkShiftTemplateAsync(MerchantWorkShiftTemplateModel model, List <MerchantWorkShiftModel> workShifts, List <MerchantWorkShiftDetailModel> details)
{
return(await MySqlHelper.TransactionAsync(async (conn, tran) =>
{
var para = new { templateGuid = model.TemplateGuid };
if (await conn.UpdateAsync(model) == 0)
{
return false;
}
var sqlDeleteDetail = "delete a from t_merchant_work_shift_detail a inner join t_merchant_work_shift b on a.work_shift_guid=b.work_shift_guid where b.template_guid=@templateGuid";
await conn.ExecuteAsync(sqlDeleteDetail, para);
await conn.DeleteListAsync <MerchantWorkShiftModel>("where template_guid=@templateGuid", para);
foreach (var item in workShifts)
{
if (string.IsNullOrEmpty(await conn.InsertAsync <string, MerchantWorkShiftModel>(item)))
{
return false;
}
}
foreach (var item in details)
{
if (string.IsNullOrEmpty(await conn.InsertAsync <string, MerchantWorkShiftDetailModel>(item)))
{
return false;
}
}
return true;
}));
}
