using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Wuqi.Webdiyer;
using System.Data.SqlClient;


public partial class myjianyi : WebPage
{
    public string CurUrl = HttpContext.Current.Request.RawUrl.Replace("/", "");
    protected void Page_Load(object sender, EventArgs e)
    {
        this.VerifyPage();


        if (!Page.IsPostBack)
        {
            DataBindlist();
        }

    }

    protected void DataBindlist()
    {

        string sqlCount = string.Format("Select Count(1) From [Table_JianYi] where userid=" + CurrentUser.UserID);
        int recordcount = GetData.GetScalar(sqlCount);
        if (recordcount == 0)
        {
            this.message.Visible = true;
        }
        pagelist.AlwaysShow = true;
        pagelist.RecordCount = recordcount; //读出数据库里一共有多少条数据
        string sql = "select * from [Table_JianYi] where userid="+ CurrentUser.UserID + " order by addtime desc";
        SqlDataAdapter ad = new SqlDataAdapter(sql, GetData.strConn);
        DataSet ds = new DataSet();
        ad.Fill(ds, pagelist.PageSize * (pagelist.CurrentPageIndex - 1), pagelist.PageSize, "temp");
        rep_parent.DataSource = ds.Tables["temp"];
        rep_parent.DataBind();
    }

    protected void rep_parent_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {

        LinkButton btndel = (LinkButton)e.Item.FindControl("LinkBtnDel");
        btndel.Attributes.Add("onclick", "Delete_Confirm();");

    }

    protected void rep_parent_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        if (e.CommandName == "BtnDel")
        {
            string s = e.CommandArgument.ToString();

            JianYi jy = new JianYi();

            if (jy.Delete(int.Parse(s)))
            {
                ShowLocation(Page);
            }
            else
            {
                ShowMsg("我的建议删除失败，请重试。", Page);
            }
        }
    }

    protected void PageChanging(object src, PageChangingEventArgs e)
    {
        pagelist.CurrentPageIndex = e.NewPageIndex;
        DataBindlist();
    }
}