public void CreateDogStatSymbol(DogStatSymbol dogStatSymbol) { using (var tx = Database.BeginTransaction()) { var delSql = $"delete from t_dog_stat_symbol where SymbolName=@symbolName and StatDate=@StatDate and UserName=@UserName"; Database.Execute(delSql, new { symbolName = dogStatSymbol.SymbolName, StatDate = dogStatSymbol.StatDate, UserName = dogStatSymbol.UserName }); Database.Insert(dogStatSymbol); tx.Commit(); } }
public void UpdateDogStatSymbol(DogStatSymbol dogStatSymbol) { var sql = $"update t_dog_stat_symbol set EarnAmount=@EarnAmount where SymbolName=@SymbolName and StatDate=@StatDate and UserName=@UserName"; Database.ExecuteAsync(sql, dogStatSymbol); }