/// <summary> /// 加载数据 /// </summary> /// <param name="strWhere">条件</param> void LoadData(string strWhere) { VoteUsersDAL dal = new VoteUsersDAL(); DataSet ds = dal.GetVoteUserlist(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(); }
void votesave() { if (Request["action"] != null && Request["action"] != "") { if (Request["openid"] != null && Request["openid"] != "") { strOpenID = Request.QueryString["openid"].ToString(); } } string voteID = string.Empty; string subID = string.Empty; string phonenum = string.Empty; if (Request["option"] != null && Request["option"] != "") { voteID = Common.Common.NoHtml(Request.QueryString["option"].ToString()); } if (Request["voteid"] != null && Request["voteid"] != "") { subID = Common.Common.NoHtml(Request.QueryString["voteid"].ToString()); } if (Request["phonenum"] != null && Request["phonenum"] != "") { phonenum = Common.Common.NoHtml(Request.QueryString["phonenum"].ToString()); } if (strOpenID.Trim() == null || strOpenID.Trim() == "") { if (phonenum.Trim() == null || phonenum.Trim() == "") { Response.Write("{\"message\":\"操作失败,未找到相关的用户信息!\"}"); return; } } if (voteID.Trim() != null && voteID.Trim() != "") { VoteUsers modeluser = new VoteUsers(); VoteUsersDAL daluser = new VoteUsersDAL(); if (strOpenID.Trim() != null && strOpenID.Trim() != "") { if (daluser.VoteIsRepeat(voteID, strOpenID)) { Response.Write("{\"message\":\"不能重复提交!\"}"); return; } else { if (daluser.SubjectIsRepeat(subID, strOpenID)) { Response.Write("{\"message\":\"您已经投过票了!\"}"); return; } } } else { if (phonenum.Trim() != null && phonenum.Trim() != "") { if (daluser.UsreIsRepeat(voteID, phonenum)) { Response.Write("{\"message\":\"不能重复提交!\"}"); return; } else { if (daluser.SubjectIsRepeatUser(subID, phonenum)) { Response.Write("{\"message\":\"您已经投过票了!\"}"); return; } } } else { Response.Write("{\"message\":\"请输入相关信息后再操作!\"}"); return; } } string struip = Request.UserHostAddress; if (daluser.UserIsRepeat(struip, voteID) > 100) { //Response.Write("{\"message\":\"您已经投过了!\"}"); return; } modeluser.ID = Guid.NewGuid().ToString("N").ToUpper(); modeluser.VoteID = voteID; modeluser.IsDel = 1; modeluser.UserIP = struip; if (strOpenID.Trim() != null && strOpenID.Trim() != "") { modeluser.OpenID = strOpenID; } if (phonenum.Trim() != null && phonenum.Trim() != "") { modeluser.UserName = phonenum; } modeluser.SubjectID = subID; if (daluser.AddVoteUsers(modeluser)) { Response.Write("{\"message\":\"操作成功!\"}"); return; } else { Response.Write("{\"message\":\"操作失败!\"}"); return; } } else { Response.Write("{\"message\":\"操作失败!\"}"); return; } Response.End(); }
protected void Page_Load(object sender, EventArgs e) { if (null == Request.QueryString["sitecode"] && !string.IsNullOrEmpty(Request.QueryString["sitecode"].ToString())) { return; } if (Request["openid"] == null || Request["openid"] == "") { if (Request["username"] == null || Request["username"] == "") { return; } } string strSiteCode = Common.Common.NoHtml(Request.QueryString["sitecode"].ToString()); string strOpenID = string.Empty; string strUserName = string.Empty; if (Request["openid"] != null && Request["openid"] != "") { 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(); } } else { strUserName = Common.Common.NoHtml(Request["username"]); } //取最新抢购的优惠活动 List <VOTE_Option> MyVoteList = new List <VOTE_Option>(); VoteUsersDAL voteuserdal = new VoteUsersDAL(); DataSet myvoteds; if (Request["openid"] != null && Request["openid"] != "") { myvoteds = voteuserdal.GetMyVoteList(" AND a.OpenID = '" + strOpenID + "' "); } else { myvoteds = voteuserdal.GetMyVoteList(" AND a.UserName = '******' "); } string VoteTitle = string.Empty; string VoteIco = string.Empty; string VoteContent = string.Empty; if (null != myvoteds && myvoteds.Tables.Count > 0 && myvoteds.Tables[0].Rows.Count > 0) { foreach (DataRow row in myvoteds.Tables[0].Rows) { //VoteUsers model = DataConvert.DataRowToModel<VoteUsers>(row); VOTE_Option model = DataConvert.DataRowToModel <VOTE_Option>(row); MyVoteList.Add(model); } } else { strInfo = "亲,你还没有参加过任何投票!"; } //读取模板内容 string text = System.IO.File.ReadAllText(Server.MapPath("Themes/Vote/MyVote.html")); JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext(); context.TempData["sitecode"] = strSiteCode; context.TempData["openid"] = strOpenID; context.TempData["title"] = "投票列表"; context.TempData["MyVoteList"] = MyVoteList; context.TempData["noinfo"] = strInfo; context.TempData["footer"] = "奥琦微商易"; JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text); t.Render(Response.Output); }