/// <summary> /// 更新公众号领红包统计 /// </summary> /// <param name="dbHelper"></param> /// <param name="setting"></param> /// <returns></returns> public static async Task <bool> UpdateOARedEnvelopeStatisticsAsync(BaseDbHelper dbHelper, OARedEnvelopeStatisticsModel setting) { var sql = @" UPDATE Activity.[dbo].[tbl_OARedEnvelopeStatistics] SET [StatisticsDate] = @StatisticsDate ,[DayMaxMoney] = @DayMaxMoney ,[UserCount] = @UserCount ,[RedEnvelopeCount] = @RedEnvelopeCount ,[RedEnvelopeSumMoney] = @RedEnvelopeSumMoney ,[RedEnvelopeAvg] = @RedEnvelopeAvg ,[OfficialAccountType] = @OfficialAccountType ,[LastUpdateDateTime] = getdate() WHERE pkid = @pkid "; using (var cmd = new SqlCommand(sql)) { cmd.AddParameter("@pkid", setting.PKID); cmd.AddParameter("@StatisticsDate", setting.StatisticsDate); cmd.AddParameter("@DayMaxMoney", setting.DayMaxMoney); cmd.AddParameter("@UserCount", setting.UserCount); cmd.AddParameter("@RedEnvelopeCount", setting.RedEnvelopeCount); cmd.AddParameter("@RedEnvelopeSumMoney", setting.RedEnvelopeSumMoney); cmd.AddParameter("@RedEnvelopeAvg", setting.RedEnvelopeAvg); cmd.AddParameter("@OfficialAccountType", setting.OfficialAccountType); var result = await dbHelper.ExecuteNonQueryAsync(cmd); return(result > 0); } }
/// <summary> /// 保存公众号领红包统计 /// </summary> /// <param name="dbHelper"></param> /// <param name="setting"></param> /// <returns></returns> public static async Task <long> InsertOARedEnvelopeStatisticsAsync(BaseDbHelper dbHelper, OARedEnvelopeStatisticsModel setting) { var sql = @"INSERT INTO [Activity].[dbo].[tbl_OARedEnvelopeStatistics] ([StatisticsDate] ,[DayMaxMoney] ,[UserCount] ,[RedEnvelopeCount] ,[RedEnvelopeSumMoney] ,[RedEnvelopeAvg] ,[OfficialAccountType] ,[CreateDatetime] ,[LastUpdateDateTime]) VALUES ( @StatisticsDate ,@DayMaxMoney ,@UserCount ,@RedEnvelopeCount ,@RedEnvelopeSumMoney ,@RedEnvelopeAvg ,@OfficialAccountType ,getdate() ,getdate() ); SELECT SCOPE_IDENTITY(); "; using (var cmd = new SqlCommand(sql)) { cmd.AddParameter("@StatisticsDate", setting.StatisticsDate); cmd.AddParameter("@DayMaxMoney", setting.DayMaxMoney); cmd.AddParameter("@UserCount", setting.UserCount); cmd.AddParameter("@RedEnvelopeCount", setting.RedEnvelopeCount); cmd.AddParameter("@RedEnvelopeSumMoney", setting.RedEnvelopeSumMoney); cmd.AddParameter("@RedEnvelopeAvg", setting.RedEnvelopeAvg); cmd.AddParameter("@OfficialAccountType", setting.OfficialAccountType); var result = await dbHelper.ExecuteScalarAsync(cmd); return(Convert.ToInt64(result)); } }