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 parenttaskx : 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=0" + 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=0"+ 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 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();

            //News ns = new News();
            OutBox ob = new OutBox();

            if (ob.UpdateOutBoxSuss(s))
            {
                ShowMsg("短信审批通过！", Page);
            }
            else
            {

            }

            DataBindlist();
            //if (ns.Delete(int.Parse(s)))
            //{
            //    ShowLocation(Page);
            //}
            //else
            //{
            //    ShowMsg("公告信息删除失败，请重试。", Page);
            //}
        }
    }


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