/// <summary>
/// 判断二维码是否有效
/// </summary>
/// <param name="code"></param>
/// <returns></returns>
public static string CheckSn(string sn, string openid)
{
//验证二维码是否有效
var code = RedPack.Confusion(sn); //解码
string sql = string.Format(@"SELECT a.State,b.IsPreSend,b.IsRealSend ,b.OpenId FROM Hfh_RedPackQrCode a
LEFT JOIN Hfh_RedPackSendRecord b ON b.QrcId = a.QrcId
WHERE a.state = 1 and a.Code = '{0}'", code);
DataTable dt = SqlHelper2.ExecuteDataTable(sql);
if (dt.Rows.Count == 1)
{
//var state = Convert.ToInt16(dt.Rows[0]["State"]).ToString();
var IsPreSend = dt.Rows[0]["IsPreSend"] == null ? "0" : dt.Rows[0]["IsPreSend"].ToString();
var IsRealSend = dt.Rows[0]["IsRealSend"] == null ? "0" : dt.Rows[0]["IsRealSend"].ToString();
var sendopenid = dt.Rows[0]["OpenId"] == null ? "" : dt.Rows[0]["OpenId"].ToString();
if (IsRealSend == "1")
{
return("二维码已失效：红包已成功发送");
}
else
{
if (IsPreSend == "1")
{
if (sendopenid == openid)
{
return("请关注公众号领取红包");
}
else
{
return("二维码已失效:红包已被他人领取");
}
}
else
{
return("succ");
}
}
}
else
{
return("fail");
}
}
/// <summary>
/// 生成红包算法
/// </summary>
/// <param name="nowdayscan">当日扫码次数</param>
/// <param name="openid">微信id</param>
/// <param name="nowmonth">当前月份</param>
/// <returns></returns>
public static double GetMoney(int allScan, string openid, string nowmonth)
{
double money = 0.08;
try
{
if (allScan == 0)
{
money = 1.08; //第一次默认是1.08元,以后随机
}
else
{
double limitMoney = Convert.ToDouble(ConfigurationManager.AppSettings[nowmonth + "LimitMoney"]); //每月限定金额
int firstScanCount = Convert.ToInt32(ConfigurationManager.AppSettings[nowmonth + "FirstScanCount"]); //每月设定的参与人数,即第一次扫码的次数
int otherScanCount = Convert.ToInt32(ConfigurationManager.AppSettings[nowmonth + "OtherScanCount"]); //每月设定的除去第一次扫码次数
string sql = "";
Random r = new Random();
Random r2 = new Random();
sql = string.Format(@"
SELECT ISNULL(SUM(a.Money),0) MonthTotal , ISNULL(MIN(c.FirstScanCount),0) FirstScanCount ,
ISNULL(MIN(b.OtherScanCount),0) OtherScanCount,MIN(d.LargeMoneyCount) LargeMoneyCount
FROM dbo.RedPackScanRecord a
LEFT JOIN (SELECT COUNT(1) OtherScanCount FROM RedPackScanRecord WHERE ScanMonth = '{1}' AND IsFirst = 0
) b ON 1=1
LEFT JOIN (SELECT COUNT(1) FirstScanCount FROM RedPackScanRecord WHERE ScanMonth = '{1}' AND IsFirst = 1
) c ON 1=1
LEFT JOIN (SELECT COUNT(1) LargeMoneyCount FROM RedPackScanRecord WHERE Money >10 AND OpenId = '{0}') d ON 1=1
WHERE a.ScanMonth = '{1}' ", openid, nowmonth);
DataTable dt2 = SqlHelper2.ExecuteDataTable(sql);
double monthTotal = Convert.ToDouble(dt2.Rows[0]["MonthTotal"]); //当月累计金额
int mFirstScanCount = Convert.ToInt32(dt2.Rows[0]["FirstScanCount"]); //当月实际参与人数
int mOtherScanCount = Convert.ToInt32(dt2.Rows[0]["OtherScanCount"]); //当月除去第一次扫描后的扫描次数
int largeMoneyCount = Convert.ToInt32(dt2.Rows[0]["LargeMoneyCount"]); // 该openid是否有中大奖的记录
int aa = 0;
int bb = 0;
//不是第一次扫码的次数总和 大于设定的浏览次数
//或者当月扫码总金额大于累计金额
if (mOtherScanCount >= otherScanCount || monthTotal >= limitMoney)
{
money = 0.08;
}
else
{
if (largeMoneyCount == 0) //没有中大奖的记录
{
aa = r.Next(0, 10001);
bb = 0;
if (aa > 9998) //中大奖30-80元
{
bb = r2.Next(3000, 8801);
money = Convert.ToDouble(((float)bb / 100).ToString("0.00"));
}
else if (aa > 9980)//中大奖10-30元
{
bb = r2.Next(1000, 3000);
money = Convert.ToDouble(((float)bb / 100).ToString("0.00"));
}
else
{
double minMoney = Convert.ToDouble(ConfigurationManager.AppSettings["MinMoney"]); //最大值
double maxMoney = Convert.ToDouble(ConfigurationManager.AppSettings["MaxMoney"]); //最小值
//当月剩余金额=当月总金额-当月已经抽中的金额-(预设的当月扫码人数-当月已经扫码的人数)*1.08-(预设的当月的非第1次扫码次数-当月已经非第1次扫码次数)*0.08
//(预设的当月扫码人数-当月已经扫码的人数)*1.08 ：确保剩下的金额足够分配剩下的人第一次扫码金额
//(预设的当月的非第1次扫码次数-当月已经非第1次扫码次数)*0.08:确保剩下的非第一次扫码次数分配最低值
double remainMoney = limitMoney - monthTotal - (firstScanCount - mFirstScanCount) * 1.08 - (otherScanCount - mOtherScanCount - 1) * minMoney;
//double remainMoney = limitmoney - monthtotal - (sdcanyucount - montycanyucount - 1) * minmoney;
int remainCount = otherScanCount - mOtherScanCount;
if (remainMoney < remainCount * minMoney)
{
money = 0.18;
}
else if (remainCount == 1)
{
if (remainMoney > 10) //防止最后一个过大
{
money = 0.88;
}
else
{
money = Convert.ToDouble(remainMoney.ToString("0.00"));
}
}
else
{
//(_redPacket.remainMoney - (_redPacket.remainCount - 1) * min)：保存剩余金额可以足够的去分配剩余的红包数量
double max = (remainMoney - (remainCount - 1) * minMoney) / remainCount * 2;
money = r.NextDouble() * max;
money = Convert.ToDouble((money <= minMoney ? minMoney : money).ToString("0.00"));
}
}
}
else //有中大奖的记录后生成个小红包
{
aa = r.Next(8, 108);
money = Convert.ToDouble(((float)aa / 100).ToString("0.00"));
}
}
}
}
catch (Exception ex) //有异常返回0.18
{
money = 0.18;
RedPack.AddAlertLog(openid, ex.ToString(), "scan生成红包时异常");
}
if (money < 0.08 || money > 88) //抽中的金额异常处理
{
money = 0.18;
}
return(money);
}