public static int UpdateLogLuckyWheelUserlotteryCount(LuckyWheelUserlotteryCountModel model)
{
string sql = "";
if (IsNullOrWhiteSpace(model.HashKey))//大翻盘 【老逻辑】
{
sql = @"update Tuhu_Log..LuckyWheelUserlotteryCount with(rowlock) set Count=Count+@Count,Record=Record+@Record,UpdateDateTime=@UpdateDateTime where UserId= @UserId and userGroup=@UserGroup";
}
else
{
sql = @"update Tuhu_Log..LuckyWheelUserlotteryCount with(rowlock) set Count=Count+@Count,Record=Record+@Record,UpdateDateTime=@UpdateDateTime where UserId= @UserId and HashKey=@HashKey";
}
using (var dbHelper = DbHelper.CreateLogDbHelper())
{
using (var cmd = new SqlCommand(sql))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@UserId", model.UserId);
cmd.Parameters.AddWithValue("@UserGroup", model.UserGroup);
cmd.Parameters.AddWithValue("@Count", model.Count);
cmd.Parameters.AddWithValue("@CreateDateTime", model.CreateDateTime);
cmd.Parameters.AddWithValue("@UpdateDateTime", model.UpdateDateTime);
cmd.Parameters.AddWithValue("@HashKey", model.HashKey);
cmd.Parameters.AddWithValue("@Record", model.Record);
return(Convert.ToInt32(dbHelper.ExecuteNonQuery(cmd)));
}
}
}
public static int InsertLogLuckyWheelUserlotteryCountAsync(LuckyWheelUserlotteryCountModel model)
{
using (var dbHelper = DbHelper.CreateLogDbHelper())
{
using (var cmd = new SqlCommand(@"insert into Tuhu_Log..LuckyWheelUserlotteryCount (UserId,UserGroup,Count,Record)
values(@UserId,@UserGroup,@Count,0)"))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@UserId", model.UserId);
cmd.Parameters.AddWithValue("@UserGroup", model.UserGroup);
cmd.Parameters.AddWithValue("@Count", model.Count);
return(Convert.ToInt32(dbHelper.ExecuteNonQuery(cmd)));
}
}
}
