public async Task <bool> InsertGFBankRedemptionCodeTask(GFBankRedemptionCodeTask task)
{
var sql = @"INSERT INTO Tuhu_groupon..GFBankRedemptionCodeTask
( UserId ,
Mobile ,
RedemptionCode ,
BusinessType ,
Status ,
SourceFileName ,
CreatedDateTime ,
UpdatedDateTime
)
VALUES ( @UserId ,
@Mobile ,
@RedemptionCode ,
@BusinessType ,
@Status ,
@SourceFileName ,
GETDATE() ,
GETDATE()
);";
using (var dbHelper = DbHelper.CreateDbHelper(Tuhu_Groupon_Write_Str))
using (var cmd = dbHelper.CreateCommand(sql))
{
cmd.Parameters.Add(new SqlParameter("@UserId", task.UserId));
cmd.Parameters.Add(new SqlParameter("@Mobile", task.Mobile));
cmd.Parameters.Add(new SqlParameter("@RedemptionCode", task.RedemptionCode));
cmd.Parameters.Add(new SqlParameter("@BusinessType", task.BusinessType));
cmd.Parameters.Add(new SqlParameter("@Status", task.Status));
cmd.Parameters.Add(new SqlParameter("@SourceFileName", task.SourceFileName));
return((await dbHelper.ExecuteNonQueryAsync(cmd)) > 0);
}
}
public GFRedemptionTaskExecutor(GFBankRedemptionCodeTask task)
{
this._task = task;
}
