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