using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using web;

public partial class adminforyoyo_cpexchangehistory : System.Web.UI.Page
{
    protected static int rcount;
    protected static DataSet ds;
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnsearch_Click(object sender, EventArgs e)
    {
        string sql = @"select * from MHLOG..TB_LOGITEMMONEY a left join MHCMEMBER..Web_Item b
on a.ItemIdx = b.ItemID where 1=1 
";
        if (!string.IsNullOrEmpty(FromChrIdx.Text.Trim()))
        {
            sql += " AND FromChrIdx like '%" + FromChrIdx.Text.Trim() + "%'";
        }
        if (!string.IsNullOrEmpty(FromChrName.Text.Trim()))
        {
            sql += " AND FromChrName like '%" + FromChrName.Text.Trim() + "%'";
        }
        if (!string.IsNullOrEmpty(ToChrIdx.Text.Trim()))
        {
            sql += " AND ToChrIdx like '%" + ToChrIdx.Text.Trim() + "%'";
        }
        if (!string.IsNullOrEmpty(ToChrName.Text.Trim()))
        {
            sql += " AND ToChrName like '%" + ToChrName.Text.Trim() + "%'";
        }
        if (!string.IsNullOrEmpty(ItemIdx.Text.Trim()))
        {
            sql += " AND ItemIdx like '%" + ItemIdx.Text.Trim() + "%'";
        }
        if (!string.IsNullOrEmpty(Name.Text.Trim()))
        {
            sql += " AND Name like '%" + Name.Text.Trim() + "%'";
        }
        if (!string.IsNullOrEmpty(ItemDBIdx.Text.Trim()))
        {
            sql += " AND ItemDBIdx = " + ItemDBIdx.Text.Trim();
        }
        if (!string.IsNullOrEmpty(t1.Text.Trim()))
        {
            sql += " AND RegDate >= '" + t1.Text.Trim()+"'";
        }
        if (!string.IsNullOrEmpty(t2.Text.Trim()))
        {
            sql += " AND RegDate <= '" + t2.Text.Trim() + "'";
        }
        sql += " order by RegDate desc ";
        ds = new DataProviders().ExecuteSqlDs(sql, "DataGrid1");
        system xx = new system();
        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {
            ds.Tables[0].Rows[i]["ToChrName"] =  xx.ConvertToBig5(ds.Tables[0].Rows[i]["ToChrName"].ToString(), 950);
            ds.Tables[0].Rows[i]["FromChrName"] = xx.ConvertToBig5(ds.Tables[0].Rows[i]["FromChrName"].ToString(), 950);
            //ds.Tables[0].Rows[i]["Name"] = xx.ConvertToBig5(ds.Tables[0].Rows[i]["Name"].ToString(), 950);
        }
        this.DataGrid1.DataSource = ds;
        this.DataGrid1.CurrentPageIndex = 0;
        this.DataGrid1.DataBind();
        rcount = ds.Tables[0].Rows.Count;
    }
    protected void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {
        this.DataGrid1.CurrentPageIndex = e.NewPageIndex;
        this.DataGrid1.DataSource = ds;
        this.DataGrid1.DataBind();
    }
}