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