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);
}
