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 sendvouchersearch : WebPage
{
    public string _username = "";
    public string _orders = "";
    public string _bdate = "";
    public string _edate = "";

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

        try
        {
            _username = Request.QueryString.Get("u");
            _orders = Request.QueryString["o"];
            _bdate = Request.QueryString["b"];
            _edate = Request.QueryString["e"];
        }
        catch { }

        this.pcuser.Value = _username;
        this.pcorder.SelectedValue = _orders;
        this.pcbtime.Value = _bdate;
        this.pcetime.Value = _edate;

        if (CheckCurUser())
        {

            if (!Page.IsPostBack)
            {
                DataBindlist();
            }
        }
        else
        {
            this.message.Visible = true;
        }

    }

    

    public bool CheckCurUser()
    {
        bool ret = false;

        if (CurrentUser.UserPID == -1)
            ret = true;
        else
            ret = false;

        return ret;

    }


    protected void DataBindlist()
    {
        string mysql = "";

        if (_username != "")
        {
            mysql += " and ToUserName like '%" + _username + "%'";
        }
        if (_orders != "")
        {
            mysql += " and Ration = '" + _orders + "'";
        }
        if (_bdate != "" && _edate != "")
        {
            mysql += " and CDate between '" + _bdate + "' and '" + _edate + "' ";
        }

       
        string sqlCount = string.Format("Select Count(1) From [Table_AddRecord] where 1=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_AddRecord] where 1=1" + mysql + " order by CDate 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();
    }
}