Esempio n. 1
0
        /// <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();
        }
Esempio n. 2
0
 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();
 }
Esempio n. 3
0
        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);
        }