/// <summary>
/// 変更情報を更新する。
/// </summary>
/// <param name=""></param>
/// <returns></returns>
public async Task <int> Update(BusinessCodeRegisterModel model)
{
string sql =
$@"UPDATE M_BusinessCode
SET
AccountingCodeNo = @AccountingCodeNo
,DebitBusinessCode = @DebitBusinessCode
,DebitBusinessName = @DebitBusinessName
,DebitAccountingItemCode = @DebitAccountingItemCode
,DebitAccountingAssistItemCode = @DebitAccountingAssistItemCode
,DebitTaxCode = @DebitTaxCode
,CreditBusinessCode = @CreditBusinessCode
,CreditAccountingItemCode = @CreditAccountingItemCode
,CreditAccountingAssistItemCode = @CreditAccountingAssistItemCode
,CreditTaxCode = @CreditTaxCode
,PaymentFlag = @PaymentFlag
,UpdateBy = @UpdateBy
,UpdateDateTime = GETDATE()
,DeleteFlag = @DeleteFlag
WHERE BusinessCodeNo = @BusinessCodeNo
";
DynamicParameters parameter = new DynamicParameters(model);
int result = await Connection.ExecuteAsync(sql, parameter);
return(result);
}
/// <summary>
/// 新規登録処理を行う。
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <(bool Result, string Message)> Create(BusinessCodeRegisterModel model)
{
int dupliCount = await repository.GetCodeCount(model.DebitBusinessCode, null);
if (dupliCount > 0)
{
return(Result : false, Message : "既に登録されている借方事業コードです。");
}
model.BusinessCodeNo = await CreateBusinessCodeNo();
model.PaymentFlag = model.IsPaid.AsFlag();
model.DeleteFlag = model.IsDeleted.AsFlag();
model.CreateBy = model.UpdateBy = loginUserContext.UserNo;
var result = await repository.Insert(model);
if (result == 1)
{
return(Result : true, Message : "");
}
else
{
return(Result : false, Message : "登録に失敗しました。");
}
}
/// <summary>
/// データ情報を登録する。
/// </summary>
/// <param name=""></param>
/// <returns></returns>
public async Task <int> Insert(BusinessCodeRegisterModel model)
{
string sql =
@"INSERT INTO M_BusinessCode(
BusinessCodeNo
,AccountingCodeNo
,DebitBusinessCode
,DebitBusinessName
,DebitAccountingItemCode
,DebitAccountingAssistItemCode
,DebitTaxCode
,CreditBusinessCode
,CreditAccountingItemCode
,CreditAccountingAssistItemCode
,CreditTaxCode
,PaymentFlag
,CreateBy
,CreateDateTime
,UpdateBy
,UpdateDateTime
,DeleteFlag
)VALUES (
@BusinessCodeNo
,@AccountingCodeNo
,@DebitBusinessCode
,@DebitBusinessName
,@DebitAccountingItemCode
,@DebitAccountingAssistItemCode
,@DebitTaxCode
,@CreditBusinessCode
,@CreditAccountingItemCode
,@CreditAccountingAssistItemCode
,@CreditTaxCode
,@PaymentFlag
,@CreateBy
,GETDATE()
,@UpdateBy
,GETDATE()
,@DeleteFlag
)";
DynamicParameters parameter = new DynamicParameters(model);
int result = await Connection.ExecuteAsync(sql, parameter);
return(result);
}
public async Task <ActionResult <RequestResult> > Update([FromBody] BusinessCodeRegisterModel model)
{
if (!ModelState.IsValid)
{
return(RequestResult.CreateErrorResult(ModelState));
}
var result = await service.Update(model);
if (result.Result)
{
return(RequestResult.CreateSuccessResult());
}
else
{
return(RequestResult.CreateErrorResult(result.Message));
}
}
/// <summary>
/// 更新処理を行う。
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public async Task <(bool Result, string Message)> Update(BusinessCodeRegisterModel model)
{
int dupliCount = await repository.GetCodeCount(model.DebitBusinessCode, model.BusinessCodeNo);
if (dupliCount > 0)
{
return(Result : false, Message : "既に登録されている借方事業コードです。");
}
model.PaymentFlag = model.IsPaid.AsFlag();
model.DeleteFlag = model.IsDeleted.AsFlag();
var result = await repository.UpdateM_BusinessCode(model);
if (result == 1)
{
return(Result : true, Message : "");
}
else
{
return(Result : false, Message : "登録に失敗しました。");
}
}
