Beispiel #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string chanle = Request.QueryString["tp"].Trim();
            HiddenFieldchanle.Value = chanle;
            tpname     = typeget(chanle);
            this.Title = tpname + "列表";
            string filterType = Request.QueryString["filter_type"];
            // string s = "select top 5 * from View_LvLines where kindof='" + Request.QueryString["tp"] + "' order by id desc";
            string s = "";
            if (filterType == "" || filterType == null)
            {
                s = "select top 100 * from View_LvLines where kindof='" + chanle + "' and  enddate >getdate() order by id desc";
            }
            else
            {
                s = "select top 100 * from View_LvLines where kindof='" + chanle + "' and  enddate >getdate() order by " + filterType + " desc";
            }
            DataSet ds = DBCLASSFORWEIXIN.DAL.DbHelperSQL.Query(s, null);
            Repeater1.DataSource = ds.Tables[0];

            Repeater1.DataBind();

            //绑定广告幻灯片
            DataSet dss = new BaseClass.Dal.App_Ad().GetList("");
            Repeater2.DataSource = dss.Tables[0];
            Repeater2.DataBind();

            //最新通知
            BaseClass.Model.App_Notices am = new BaseClass.Dal.App_Notices().GetLastModel();
            LabelNotice.Text = am.Title;
        }
    }
Beispiel #2
0
    //protected string openid = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.QueryString["code"] != null)
        {
            //微信渠道登陆
            UserAuthorizationModel userInfo = UserAuthorization.userLogin(this.Page);
        }
        string  s  = "select top 10 * ,(1000*adultzkPrice/adultTicketPrice) as zk from View_LvLines where enddate >getdate()  order by zk  ";
        DataSet ds = DBCLASSFORWEIXIN.DAL.DbHelperSQL.Query(s, null);

        Repeater1.DataSource = ds.Tables[0];
        Repeater1.DataBind();

        //最新通知
        BaseClass.Model.App_Notices am = new BaseClass.Dal.App_Notices().GetLastModel();
        LabelNotice.Text = am.Title;

        //绑定广告幻灯片
        //DataSet dss = new BaseClass.Dal.App_Ad().GetList("");

        //Repeater2.DataSource = dss.Tables[0];
        //Repeater2.DataBind();
    }