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();
}
