private void GetCaiShengInfo(GodWealthRecordInfo wealthInfo)
{
if (wealthInfo != null)
{
GodHeadImage = wealthInfo.GodImage;
GodShowName = wealthInfo.ShowName;
FriendNum = wealthInfo.FriendNum;
}
}
//检测此次活动红包状态
public static int CheckRedPacketStatus()
{
try
{
//若没有登录，则根据OpenId先去活动表中查询Userid
string openId = GlobalUtils.OpenId;
if (openId.IsEmpty())
{
return(0);
}
GodWealthRecordInfo recordInfo = GetUserGodWealthInfo(openId);
if (recordInfo == null || recordInfo.UserName.ToText().IsEmpty())
{
return(0);
}
if (recordInfo.ExpirationDate == null || recordInfo.ExpirationDate.HasValue == false)
{
#region
//using (SqlConnection connection = WealthPage.OpenConnection(1))
//{
// string strSQL = " SELECT IsUsed, IsReceive FROM UserPrize WITH(NOLOCK) WHERE RuleId='918f88a9-f3f7-4687-b239-8db70c4e483b' AND UserId=@UserId";
// DynamicParameters dyParams = new DynamicParameters();
// if (WebUserAuth.IsAuthenticated)
// {
// //判断有登录时，根据UserId查询
// dyParams.Add("@UserId", WebUserAuth.UserId.Value);
// }
// else
// {
// //若没有登录，则根据OpenId先去活动表中查询Userid
// using (SqlConnection con = WealthPage.OpenConnection(2))
// {
// string tmpSQL = "select top 1 UserId from Activity_GodWealth_Record where WXOpenId=@WXOpenId";
// DynamicParameters tmpParams = new DynamicParameters();
// tmpParams.Add("@WXOpenId", openId);
// Guid? userId = con.Query<Guid?>(tmpSQL, tmpParams).FirstOrDefault();
// if (userId == null || userId.HasValue == false)
// return 0;
// else
// dyParams.Add("@UserId", userId.Value);
// }
// }
// //当前红包状态 0：未领取 1:已领取未使用 2:红包已使用 3:红包已过期
// UserPrizeInfo prizeInfo = connection.Query<UserPrizeInfo>(strSQL, dyParams).FirstOrDefault();
// if (prizeInfo == null || prizeInfo.IsReceive == false)
// {
// return 0;
// }
// if (prizeInfo.IsReceive && !prizeInfo.IsUsed)
// {
// return 1;
// }
// if (prizeInfo.IsUsed)
// return 2;
//}
#endregion
}
else
{
if (recordInfo.ExpirationDate < DateTime.Now)
{
return(3);
}
}
return(0);
}
catch
{
return(0);
}
}
