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 parenttask : WebPage
{

    protected void Page_Load(object sender, EventArgs e)
    {
        this.VerifyPage();

        this.pcbtime.Value = DateTime.Now.Date.ToString();
        this.pcetime.Value = DateTime.Now.ToString();

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

    }

    public void BindUsers()
    {
        string sql = "";

        if (CurrentUser.UserType == 1)
            sql += "select UserID,UserName from [Table_MyUsers] where (UserID=" + CurrentUser.UserID + ") or (UserPID=" + CurrentUser.UserID + ") order by userid asc";
        else
            sql += "select UserID,UserName from [Table_MyUsers] where (UserID=" + CurrentUser.UserID + ") order by userid asc";

        DataSet ds = GetData.GetDataFromDB(sql);
        if (ds.Tables[0].Rows.Count > 0)
        {
            pcuser.DataSource = ds;
            pcuser.DataValueField = "UserID";
            pcuser.DataTextField = "Username";
            pcuser.DataBind();
        }
    }

    protected void DataBindlist()
    {

        string mysql = " and (UserID=" + CurrentUser.UserID + " or UserPID=" + CurrentUser.UserID + ")";
        string sqlCount = string.Format("Select Count(1) From [Table_OutBox] where SendFlag=1" + mysql);
        int recordcount = GetData.GetScalar(sqlCount);
        if (recordcount == 0)
        {
            this.message.Visible = true;
        }
        pagelist.AlwaysShow = true;
        pagelist.RecordCount = recordcount; //读出数据库里一共有多少条数据
        string sql = "select * from [Table_OutBox] where SendFlag=1"+ mysql + " order by id 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 PageChanging(object src, PageChangingEventArgs e)
    {
        pagelist.CurrentPageIndex = e.NewPageIndex;
        DataBindlist();
    }
}