protected void Page_Load(object sender, EventArgs e) { if (null != Common.Common.NoHtml(Request.QueryString["action"])) { strAction = Common.Common.NoHtml(Request.QueryString["action"]); } if (null != Common.Common.NoHtml(Request.QueryString["id"])) { strID = Common.Common.NoHtml(Request.QueryString["id"]); } JC_ScoreDAL dal = new JC_ScoreDAL(); switch (strAction) { case "del": if (dal.UpdateJCScoreState(strID)) { strMessage = "操作成功!"; } else { strMessage = "操作失败!"; } break; default: break; } Response.Write(strMessage); Response.End(); }
void losewindatalistbind() { JC_ScoreDAL dal = new JC_ScoreDAL(); DataSet ds = null; if (Session["losewin"] != null && Session["losewin"].ToString() != "") { ds = dal.GetLoseWin(quizID, GetLoseWin()); GuessTooTip.Text = "竞猜输赢"; } else { ds = dal.GetRightGuessTop(quizID); GuessTooTip.Text = "竞猜比分"; } DataView dv = ds.Tables[0].DefaultView; AspNetPager1.RecordCount = dv.Count; PagedDataSource pds = new PagedDataSource(); pds.DataSource = dv; pds.AllowPaging = true; pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1; pds.PageSize = AspNetPager1.PageSize; sortrepeat.DataSource = pds; sortrepeat.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (null == Request.QueryString["sitecode"] && !string.IsNullOrEmpty(Request.QueryString["sitecode"].ToString())) { return; } if (null == Request.QueryString["openid"] && !string.IsNullOrEmpty(Request.QueryString["openid"].ToString())) { return; } string strSiteCode = Common.Common.NoHtml(Request.QueryString["sitecode"].ToString()); string strOpenID = string.Empty; if (Request.QueryString["openid"].ToString().Length > 29 || Request.QueryString["openid"].ToString().Length < 25) { strOpenID = Common.Common.NoHtml(Request.QueryString["openid"].ToString()); } else { strOpenID = Request.QueryString["openid"].ToString(); } //取最新抢购的优惠活动 List <Model.JC.MyQuiz> liQuizScroe = new List <Model.JC.MyQuiz>(); JC_ScoreDAL dalQuizScroe = new JC_ScoreDAL(); DataSet ds = dalQuizScroe.GetJCScoreList(" a.OpenID = '" + strOpenID + "' "); if (null != ds && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { Model.JC.MyQuiz model = DataConvert.DataRowToModel <Model.JC.MyQuiz>(row); liQuizScroe.Add(model); } } else { strInfo = "亲,你还没有参加过竞猜!"; } //读取模板内容 string text = System.IO.File.ReadAllText(Server.MapPath("Themes/Quiz/MyQuiz.html")); JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext(); context.TempData["sitecode"] = strSiteCode; context.TempData["openid"] = strOpenID; context.TempData["title"] = "竞猜列表"; context.TempData["quizlist"] = liQuizScroe; context.TempData["couponinfo"] = strInfo; context.TempData["footer"] = "奥琦微商易"; JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text); t.Render(Response.Output); }
void SaveJCGScore() { string hscorevalue = string.Empty; string vscorevalue = string.Empty; if (Request["qid"] != null && Request["qid"] != "") { JC_ScoreDAL dal = new JC_ScoreDAL(); if (dal.ExistJCScore(Request["qid"], strOpenID)) { Response.Write("{\"message\":\"您已经操作过了,请不要重复操作!\"}"); } else { JC_Score model = new JC_Score(); model.ID = Guid.NewGuid().ToString("N").ToUpper(); model.OpenID = strOpenID; model.QuizId = Request["qid"].ToString(); if (Request["hscore"] != null && Request["hscore"] != "") { hscorevalue = Request["hscore"]; } else { hscorevalue = "0"; } if (Request["vscore"] != null && Request["vscore"] != "") { vscorevalue = Request["vscore"]; } else { vscorevalue = "0"; } model.GuessScore = hscorevalue + ":" + vscorevalue; model.State = 0; model.SiteCode = Session["strSiteCode"].ToString(); if (dal.AddJCScore(model)) { Response.Write("{\"message\":\"操作成功!\"}"); } else { Response.Write("{\"message\":\"操作失败,请核对后再操作!\"}"); } } } else { Response.Write("{\"message\":\"操作失败,请核对后再操作!\"}"); } Response.End(); }
/// <summary> /// 加载数据 /// </summary> /// <param name="strWhere">条件</param> void LoadData(string strWhere) { Session.Remove("sort"); JC_ScoreDAL dal = new JC_ScoreDAL(); DataSet ds = dal.GetJCScoreListByState(strWhere); DataView dv = ds.Tables[0].DefaultView; AspNetPager1.RecordCount = dv.Count; PagedDataSource pds = new PagedDataSource(); pds.DataSource = dv; pds.AllowPaging = true; pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1; pds.PageSize = AspNetPager1.PageSize; Repeater1.DataSource = pds; Repeater1.DataBind(); }
protected void btnCoupon_Click(object sender, EventArgs e) { string strWhere = " "; if (Session["strRoleCode"].ToString() != "ADMIN") { strWhere = " a.SiteCode = '" + Session["strSiteCode"].ToString() + "' "; } if (ddlselectName.SelectedValue.Trim() != null && ddlselectName.SelectedValue.Trim() != "" && ddlselectName.SelectedValue.Trim() != "0") { if (strWhere.Trim() != null && strWhere.Trim() != "") { strWhere = strWhere + " AND "; } strWhere = strWhere + " b.ID='" + ddlselectName.SelectedValue + "' "; } if (ddlselectName.SelectedValue.Trim() != null && ddlselectName.SelectedValue.Trim() != "" && ddlselectName.SelectedValue.Trim() != "0") { if (strWhere.Trim() != null && strWhere.Trim() != "") { strWhere = strWhere + " AND "; } string arrow = GetLoseWin(ddlselectName.SelectedValue); if (arrow == "0") { MessageBox.Show(this, "请设置正确的比赛结果再做统计!"); return; } strWhere = strWhere + " [dbo].[split](GuessScore,':',0) " + arrow + " [dbo].[split](GuessScore,':',1) "; } else { MessageBox.Show(this, "操作失败,请选择相应的赛事!"); return; } JC_ScoreDAL dal = new JC_ScoreDAL(); DataSet ds = dal.GetJCScoreListByStateNO(strWhere); //取正确比分 foreach (DataRow row in ds.Tables[0].Rows) { string strOpenID = row["OpenID"].ToString(); string strScoreID = row["ID"].ToString(); string strGuessScore = row["GuessScore"].ToString(); string strRightScore = row["RightScore"].ToString(); //修改竞猜状态; dal.UpdateJCScoreState(strScoreID); //写入优惠券 //AC87CE288FC24F23B7B68CE8F3D93D13 string strGuid = Guid.NewGuid().ToString("N"); CouponDAL cdal = new CouponDAL(); string strSiteCode = Session["strSiteCode"].ToString(); Model.ACT.Coupon coupon = null; if (strGuessScore == strRightScore) { coupon = new Model.ACT.Coupon() { ID = strGuid, SiteCode = Session["strSiteCode"].ToString(), SiteActivityID = "AC87CE288FC24F23B7B68CE8F3D93D18", OpenID = strOpenID, CouponStatus = 0 }; } else { coupon = new Model.ACT.Coupon() { ID = strGuid, SiteCode = Session["strSiteCode"].ToString(), SiteActivityID = "AC87CE288FC24F23B7B68CE8F3D93D22", OpenID = strOpenID, CouponStatus = 0 }; } cdal.InsertInfo(coupon); } MessageBox.Show(this, "优惠券发放完成!"); }
void SaveJCGScore() { string hscorevalue = string.Empty; string vscorevalue = string.Empty; if (strQuizID != null && strQuizID != "") { JC_ScoreDAL dal = new JC_ScoreDAL(); if (!string.IsNullOrEmpty(strOpenID)) { if (dal.ExistJCScore(strQuizID, strOpenID)) { Response.Write("{\"message\":\"不能重复提交!\"}"); } else { JC_Score model = new JC_Score(); model.ID = Guid.NewGuid().ToString("N").ToUpper(); model.OpenID = strOpenID; model.QuizId = strQuizID; string hscore = Common.Common.NoHtml(Request["hscore"]); string vscore = Common.Common.NoHtml(Request["vscore"]); if (hscore != null && hscore != "") { hscorevalue = hscore; } else { hscorevalue = "0"; } if (vscore != null && vscore != "") { vscorevalue = vscore; } else { vscorevalue = "0"; } model.GuessScore = hscorevalue + ":" + vscorevalue; model.State = 0; model.SiteCode = Session["strSiteCode"].ToString(); if (dal.AddJCScore(model)) { Response.Write("{\"message\":\"操作成功!\"}"); } else { Response.Write("{\"message\":\"操作失败!\"}"); } } } else { Response.Write("{\"message\":\"不能重复提交!\"}"); } } else { Response.Write("{\"message\":\"操作失败!\"}"); } Response.End(); }