protected void Page_Load(object sender, EventArgs e)
{
StarNum = WEBRequest.GetFormInt("jsondata", 0);
if (WEBRequest.GetFormString("jsondata") == "")
{
StarNum = WEBRequest.GetQueryInt("StarNum", 0);
}
returnUrl = "/Activity/HighSpeedGame/LotteryDraw.aspx?StarNum=" + StarNum;
if (!IsPostBack)
{
WeiXinApi jssdk = new WeiXinApi();
jssdk.InitApi();
System.Collections.Hashtable hs = jssdk.getSignPackage();
AppId = hs["appId"].ToString();
NonceStr = hs["nonceStr"].ToString();
TimeStamp = hs["timestamp"].ToInt(0);
Signature = hs["signature"].ToString();
Guid?userId = WebUserAuth.UserId;
if (userId != null && userId.Value != Guid.Empty)
{
IsLogin = true;
}
//判断答题星星数是否正确
if (StarNum < 1 || StarNum > 3)
{
Response.Redirect("/Activity/HighSpeedGame/GameIndex.aspx");
}
}
}
//蛋糕排行榜前10名
public void GetTopDoCakeUserRank()
{
string code = WEBRequest.GetFormString("code");
int pageIndex = WEBRequest.GetFormInt("pageindex", 1);
string selfOpenId = GetCurrentOpenId(code);
// using (SqlConnection connection = CelebHelper.OpenConnection(2))
// {
// string strSQL = @"SELECT @total=COUNT(1) from Activity_ThreeYearGame_Record;
// WITH oa AS(
// SELECT * FROM (
// SELECT ROW_NUMBER() OVER(ORDER BY A.CakeNum DESC) AS RankNo, A.UserId,
// CASE WHEN isnull(A.NickName,'')!='' THEN A.NickName ELSE (SELECT TOP 1 ISNULL(NickName,'未知') FROM Activity_ThreeYearGame_Friend sub WHERE sub.WXOpenId=A.WXOpenId and sub.WXOpenId=sub.FriendOpenId) END AS NickName,
// A.CakeNum,
// 0 IsSelf, 0 as Tag
// FROM Activity_ThreeYearGame_Record A
// ) Main WHERE Main.CakeNum>0 AND Main.RankNo<=50
// UNION ALL
// SELECT * FROM (
// SELECT ROW_NUMBER() OVER(ORDER BY A.CakeNum DESC) AS RankNo, A.UserId, CASE WHEN isnull(A.NickName,'')!='' THEN A.NickName ELSE (SELECT TOP 1 ISNULL(NickName,'未知') FROM Activity_ThreeYearGame_Friend sub WHERE sub.WXOpenId=A.WXOpenId and sub.WXOpenId=sub.FriendOpenId) END AS NickName,
// A.CakeNum,
// CASE WHEN A.WXOpenId=@WXOpenId THEN 1 ELSE 0 END AS IsSelf, 1 as Tag
// FROM Activity_ThreeYearGame_Record A
// ) Main WHERE Main.IsSelf=1
// )
// SELECT * FROM oa WHERE RankNo between (@pageIndex-1)*@pageSize+1 and @pageIndex*@pageSize OR Tag=1
// ORDER BY Tag, cakenum DESC ";
// DynamicParameters dyParams = new DynamicParameters();
// dyParams.Add("@WXOpenId", selfOpenId);
// dyParams.Add("@pageIndex", pageIndex);
// dyParams.Add("@pageSize", 10);
// dyParams.Add("@total", 0, DbType.Int32, ParameterDirection.Output);
// List<TopUserCakeRank> dataList = new List<TopUserCakeRank>();
// dataList = connection.Query<TopUserCakeRank>(strSQL, dyParams).ToList();
// //获取总记录数
// int totalCount = dyParams.Get<int>("@total");
// int pageCount = totalCount > 50 ? 5 : GetPageCount(totalCount, 10);
// if (dataList.Any())
// {
// var responseObj = new { status = "1", msg = "", list = dataList, pagecount = pageCount };
// PrintJson(responseObj);
// }
// else
// {
// var responseObj = new { status = "0", msg = "没有找到数据!" };
// PrintJson(responseObj);
// }
// }
}
public void AnswerQuestion()
{
int examId = WEBRequest.GetFormInt("ExamId", 0);
string rightAnswer = WEBRequest.GetFormString("Answer");
int chkResult = GameHelper.Instance.CheckAnswerIsRight(examId, rightAnswer);
if (chkResult == -1)
{
PrintJson("-1", "所答题目不存在!");
return;
}
else if (chkResult == 0)
{
PrintJson("0", "答错了!");
return;
}
PrintJson("1", "恭喜您，答对了!");
}
//投资排行榜前10名
public void GetTopInvestUserRank()
{
string userId = "";
string strSQL = "";
int pageIndex = WEBRequest.GetFormInt("pageindex", 1);
if (WebUserAuth.IsAuthenticated)
{
userId = WebUserAuth.UserId.Value.ToString();
}
else
{
//根据OpenId反查询出用户ID
string code = WEBRequest.GetFormString("code");
string wxopenid = GetCurrentOpenId(code);
//using (SqlConnection connection = CelebHelper.OpenConnection(2))
//{
// strSQL = "select convert(varchar(40),UserId) as userid from Activity_ThreeYearGame_Record where WXOpenId=@WXOpenId";
// DynamicParameters dyParams = new DynamicParameters();
// dyParams.Add("@WXOpenId", wxopenid);
// userId = connection.Query<string>(strSQL, dyParams).FirstOrDefault();
//}
}
// using (SqlConnection connection = CelebHelper.OpenConnection(1))
// {
// DateTime startDate = CelebHelper.ActivityStartDate;
// DateTime endDate = CelebHelper.ActivityEndDate;
// strSQL = @"SELECT @total=COUNT( DISTINCT A.SubscribeUserId) from Subscribe A WHERE A.TenderMode=6 AND A.[Status]>1 AND A.AddDate>=@StartDate AND A.AddDate<=@EndDate ;
// WITH oa AS(
// SELECT * FROM (
// SELECT ROW_NUMBER() OVER(ORDER BY sum(A.Amount) DESC) AS RankNo, A.SubscribeUserId AS UserId, C.NickName,
// sum(A.Amount) as Amount, 0 AS IsSelf, 0 AS Tag
// FROM Subscribe A
// INNER JOIN dbo.UserBasicInfo C ON C.Id=A.SubscribeUserId
// WHERE A.TenderMode=6 AND A.[Status]>1 AND A.AddDate>=@StartDate AND A.AddDate<=@EndDate
// GROUP BY A.SubscribeUserId, C.NickName
// ) Main WHERE Main.RankNo<=50
// UNION ALL
// SELECT * FROM (
// SELECT ROW_NUMBER() OVER(ORDER BY sum(A.Amount) DESC) AS RankNo, A.SubscribeUserId AS UserId, C.NickName,
// sum(A.Amount) as Amount, CASE WHEN A.SubscribeUserId=@UserId THEN 1 ELSE 0 END AS IsSelf, 1 AS Tag
// FROM Subscribe A
// INNER JOIN dbo.UserBasicInfo C ON C.Id=A.SubscribeUserId
// WHERE A.TenderMode=6 AND A.[Status]>1 AND A.AddDate>=@StartDate AND A.AddDate<=@EndDate
// GROUP BY A.SubscribeUserId, C.NickName
// ) Main WHERE Main.IsSelf=1
// )
// SELECT * FROM oa WHERE RankNo between (@pageIndex-1)*@pageSize+1 and @pageIndex*@pageSize OR Tag=1
// ORDER BY Tag, Amount DESC ";
// DynamicParameters dyParams = new DynamicParameters();
// dyParams.Add("@UserId", userId);
// dyParams.Add("@StartDate", startDate);
// dyParams.Add("@EndDate", endDate);
// dyParams.Add("@pageIndex", pageIndex);
// dyParams.Add("@pageSize", 10);
// dyParams.Add("@total", 0, DbType.Int32, ParameterDirection.Output);
// List<TopUserInvestRank> dataList = new List<TopUserInvestRank>();
// dataList = connection.Query<TopUserInvestRank>(strSQL, dyParams).ToList();
// //获取总记录数
// int totalCount = dyParams.Get<int>("@total");
// int pageCount = totalCount > 50 ? 5 : GetPageCount(totalCount, 10);
// if (dataList.Any())
// {
// var responseObj = new { status = "1", msg = "", list = dataList, pagecount = pageCount };
// PrintJson(responseObj);
// }
// else
// {
// var responseObj = new { status = "0", msg = "没有找到数据!" };
// PrintJson(responseObj);
// }
// }
}
//private readonly string sqlconnection = TuanDai.Config.BaseConfig.ConnectionString;
//private readonly string sqlActivityConn = TuanDai.Config.BaseConfig.ActivityConnectionString;
#region 高铁游戏抽奖
//开始抽奖
public void StartLottery()
{
Guid?userId = WebUserAuth.UserId;
GamePrizeResultInfor resultObj = new GamePrizeResultInfor();
resultObj.Msg = resultObj.Title = resultObj.PrizeName = "";
//判断是否登陆，得到用户ID
if (userId == Guid.Empty)
{
resultObj.Status = 2;
resultObj.Msg = "对不起，你未登录，请先登录!";
PrintJson(resultObj);
return;
}
int starNum = WEBRequest.GetFormInt("StarNum", 0);
if (starNum <= 0)
{
resultObj.Status = 0;
resultObj.Msg = "对不起,您的财经敏感度为0,不能进行抽奖!";
PrintJson(resultObj);
return;
}
UserBLL userBll = new UserBLL();
UserBasicInfoInfo userInfor = userBll.GetUserBasicInfoModelById(userId.Value);
int isNewUser = 0;
var param = new DynamicParameters();
param.Add("@userId", userId);
param.Add("@userName", userInfor.UserName);
param.Add("@StarNum", starNum);
param.Add("@userAddDate", userInfor.AddDate);
param.Add("@outStatus", 0, System.Data.DbType.Int32, System.Data.ParameterDirection.Output);
param.Add("@PrizeId", Guid.Empty, System.Data.DbType.Guid, System.Data.ParameterDirection.Output);
param.Add("@PrizeType", 0, System.Data.DbType.Int32, System.Data.ParameterDirection.Output);
param.Add("@PrizeValue", 0, System.Data.DbType.Decimal, System.Data.ParameterDirection.Output);
param.Add("@PrizeName", "", System.Data.DbType.String, System.Data.ParameterDirection.Output);
param.Add("@TargetProductId", Guid.Empty, System.Data.DbType.Guid, System.Data.ParameterDirection.Output);
param.Add("@IsNewUser", 0, System.Data.DbType.Int32, System.Data.ParameterDirection.Output);
param.Add("@PrizeRecordId", Guid.Empty, System.Data.DbType.Guid, System.Data.ParameterDirection.Output);
/*
* @userId UNIQUEIDENTIFIER , --申购人
* @userName NVARCHAR(50) ,--申购人姓名
* @StarNum INT, --答题所得星星数
* @outStatus INT OUTPUT , --1:已中奖 -1:活动未开始 -2:活动未已结束 -3:无抽奖机会 -4:奖品已全部抽完 -5 未抽中奖品
* @PrizeId UNIQUEIDENTIFIER OUTPUT, --奖品ID
* @PrizeType INT OUTPUT,--奖品类型
* @PrizeValue DECIMAL(18, 2) OUTPUT,--奖品价值
* @PrizeName NVARCHAR(200) OUTPUT , --中奖名称
* @TargetProductId UNIQUEIDENTIFIER OUTPUT --实物ID
*/
int status = 0, PrizeType = 0;
string prizeName = "";
Guid? PrizeId = null;
Guid? TargetProductId = null;
Guid? PrizeRecordId = null;
decimal PrizeValue = 0;
//using (SqlConnection connection = OpenConnection(2))
//{
// connection.Execute("p_Activity_GetPrize_HighSpeedGame", param, null, null, CommandType.StoredProcedure);
// status = param.Get<int>("@outStatus");
// PrizeType = param.Get<int>("@PrizeType");
// prizeName = param.Get<string>("@PrizeName");
// PrizeId = param.Get<Guid?>("@PrizeId");
// TargetProductId = param.Get<Guid?>("@TargetProductId");
// PrizeValue = param.Get<decimal>("@PrizeValue");
// isNewUser = param.Get<int>("@IsNewUser");
// PrizeRecordId = param.Get<Guid?>("@PrizeRecordId");
// resultObj.IsNewUser = isNewUser;
// connection.Close();
// connection.Dispose();
//}
//if (status == 1)
//{
// #region 写入团宝箱
// using (SqlConnection connection = OpenConnection(1))
// {
// try
// {
// //param = new DynamicParameters();
// //param.Add("@UserId", userId);
// //param.Add("@Type", PrizeType);
// //param.Add("@SubTypeId", 1);
// //param.Add("@ActivityCode", "20150619_" + PrizeRecordId.Value.ToString());//为了插入数据不重复,此处为两个值串联
// //param.Add("@PrizeName", prizeName);
// //param.Add("@PrizeValue", PrizeValue);
// //param.Add("@TargetProductId", TargetProductId);
// //param.Add("@Description", "高铁广告小游戏抽奖活动");
// ////0赠送失败，1赠送成功,-1提现券无库存
// //param.Add("@outStatus", 0, System.Data.DbType.Int32, System.Data.ParameterDirection.Output);
// ////调用此过程必须要用到事务
// //connection.Execute("p_sendUserPrize", param, null, null, CommandType.StoredProcedure);
// //
// SendUserPrizeInfo prizeInfo = new SendUserPrizeInfo();
// prizeInfo.UserId = userId.Value;
// prizeInfo.RuleId = Guid.Parse("d6f32f98-a85f-4180-b180-57f3bef8cfa2");//规则Id
// prizeInfo.PrizeName = prizeName;
// prizeInfo.PrizeValue = PrizeValue;
// prizeInfo.Description = "高铁广告小游戏抽奖活动";
// int outStatus = -1;
// userBll.SendUserPrizeNew(prizeInfo, out outStatus);
// if (outStatus != 1)
// {
// //写入失败时，回滚之前数据
// status = -5;
// this.RollBackGamePrizeData(userId.Value, PrizeId.Value);
// }
// }
// finally
// {
// connection.Close();
// connection.Dispose();
// }
// }
// #endregion
//}
//-- -1:活动未开始 -2:活动未已结束 -3:无抽奖机会 -4:奖品已全部抽完 -5 未抽中奖品 1:已中奖
switch (status)
{
case 1:
{
//有抽到奖品
resultObj.Status = 1;
resultObj.IsPrized = 1;
resultObj.PrizeName = GetShowPrizeName(prizeName);
if (isNewUser == 0)
{
//老用户抽中奖
resultObj.Title = "恭喜您!";
}
else
{
resultObj.Title = "这次大发啦!!";
}
}
break;
case -5:
{
resultObj.Status = 3;
if (isNewUser == 0)
{
//老用户抽中奖
resultObj.Title = "很遗憾!";
resultObj.PrizeName = "谢谢您的参与传递力量分享吧";
}
else
{
resultObj.Title = "恭喜您!";
resultObj.PrizeName = "获得团贷网388元新手现金红包";
}
}
break;
case -1:
resultObj.Status = 0;
resultObj.Msg = "您来得太早了，活动还未开始!";
break;
case -2:
resultObj.Status = 0;
resultObj.Msg = "对不起，您来晚了,活动已结束了!";
break;
case -3:
resultObj.Status = 4;
resultObj.Msg = "每个账号只有一次机会，您已抽过奖!";
break;
case -4:
resultObj.Status = 0;
resultObj.Msg = "您来晚了,奖品已全部抽完!";
break;
case 0:
resultObj.Status = 0;
resultObj.Msg = "抽奖失败，请重试!";
break;
}
PrintJson(resultObj);
}
public void SubmitZhphLoan()
{
PrintJson("-1", "触屏版不支持正合普惠借款，请前往PC或APP");
return;
Guid userId = WebUserAuth.UserId.Value;
int ApplyType = WEBRequest.GetFormInt("ApplyType", 0);
if (!ApplyType.ToString().IsIn("1", "2", "3", "4"))
{
PrintJson("0", "借款方案不支持");
return;
}
var userbll = new UserBLL();
var user = userbll.GetUserBasicInfoModelById(userId);
if (user == null)
{
this.PrintJson("-2", "用户不存在");
}
string code = WEBRequest.GetFormString("code");
string telno = WEBRequest.GetFormString("phone");
if (telno.IsEmpty())
{
PrintJson("0", "手机号不能为空!");
return;
}
if (code.IsEmpty())
{
PrintJson("0", "验证码不能为空!");
return;
}
int msgCode = new TuanDai.PortalSystem.BLL.CodeRecordBLL().CheckCodeRecord(code, telno, MsCodeType.PhoneCode, MsCodeType2.ZhphFastLoanCode, userId, true);
/*1：验证通过；0:参数错误；-1：验证码不存在；-2：验证码已过期；-3：验证码已使用；-4：验证已过期*/
string msg = string.Empty;
switch (msgCode)
{
case 0:
msg = "参数错误";
break;
case -1:
msg = "验证码不存在";
break;
case -2:
msg = "验证码已过期";
break;
case -3:
msg = "验证码已使用";
break;
case -4:
msg = "验证已过期";
break;
default:
break;
}
if (msgCode != 1)
{
PrintJson(msgCode.ToString(), msg);
return;
}
ProjectBLL projectbll = new ProjectBLL();
TuanDai.PortalSystem.Model.WXZhphApplyLoanInfo loanInfo = new TuanDai.PortalSystem.Model.WXZhphApplyLoanInfo();
loanInfo.Id = Guid.NewGuid();
loanInfo.AppTypeId = ApplyType;
loanInfo.UserId = userId;
loanInfo.AddDate = DateTime.Now;
loanInfo.AppName = WEBRequest.GetFormString("name");
loanInfo.Phone = WEBRequest.GetFormString("phone");
loanInfo.Provice = WEBRequest.GetFormString("sel_city1");
loanInfo.City = WEBRequest.GetFormString("sel_city2");
loanInfo.AreaCode = WEBRequest.GetFormString("areacode");
//1:pc 2: ios 3:android 4:触屏版 5：服务号
loanInfo.DeviceType = 4;
if (GlobalUtils.IsWeiXinBrowser)
{
loanInfo.DeviceType = 5;
}
bool isSave = projectbll.SubmitZhphLoan(loanInfo);
if (!isSave)
{
PrintJson("0", "数据保存异常，请重试!");
return;
}
PrintJson("1", "");
}
