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", ""); }