checkdoc.aspx.cs

java 最出色的报表工具代码,愿分享....

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using Infragistics.WebUI.UltraWebGrid;
using System.Threading;
using System.Globalization;
public partial class Admin_Frameset_Operation_CheckDoc : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        { 
            Vouchers voucher = new Vouchers();
            this.WebGridChecked.DataSource = voucher.GetDs("select * from vouchers where Checked='Y'");
            this.DataBind();
            GridNChecked.DataSource = voucher.GetDs("select * from vouchers where Checked='N'");
            this.DataBind();
            WebGridXGrid.DataSource = voucher.GetDs("select * from vouchers where Checked='X'");
            this.DataBind();

            WebGridChecked.DisplayLayout.SelectTypeRowDefault = SelectType.Single;
            WebGridChecked.DisplayLayout.SelectedRows.Add(WebGridChecked.Rows[0]);
            WebGridChecked.DisplayLayout.SelectTypeColDefault = SelectType.Single;
            WebGridChecked.DisplayLayout.AllowUpdateDefault = AllowUpdate.Yes;
            WebGridChecked.DisplayLayout.AllowColSizingDefault = AllowSizing.Free;
            WebGridChecked.DisplayLayout.TableLayout = TableLayout.Fixed;

            GridNChecked.DisplayLayout.SelectTypeRowDefault = SelectType.Single;
            GridNChecked.DisplayLayout.SelectedRows.Add(GridNChecked.Rows[0]);
            GridNChecked.DisplayLayout.SelectTypeColDefault = SelectType.Single;
            GridNChecked.DisplayLayout.AllowUpdateDefault = AllowUpdate.Yes;
            GridNChecked.DisplayLayout.AllowColSizingDefault = AllowSizing.Free;
            GridNChecked.DisplayLayout.TableLayout = TableLayout.Fixed;

            WebGridXGrid.DisplayLayout.SelectTypeRowDefault = SelectType.Single;
            WebGridXGrid.DisplayLayout.SelectedRows.Add(WebGridXGrid.Rows[0]);
            WebGridXGrid.DisplayLayout.SelectTypeColDefault = SelectType.Single;
            WebGridXGrid.DisplayLayout.AllowUpdateDefault = AllowUpdate.Yes;
            WebGridXGrid.DisplayLayout.AllowColSizingDefault = AllowSizing.Free;
            WebGridXGrid.DisplayLayout.TableLayout = TableLayout.Fixed;
             }
         
          
       
         
      
    }
    public void bind()
    {
        Vouchers voucher = new Vouchers();
         this.WebGridChecked.DataSource=voucher.GetDs("select * from vouchers where Checked='Y'");
         this.WebGridChecked.DataBind();
    }
    public void bindNgrid()
    {
        Vouchers voucher = new Vouchers();
        this.GridNChecked.DataSource = voucher.GetDs("select * from vouchers where Checked='N'");
        this.GridNChecked.DataBind();
    
    }
    public void bindXgrid()
    {
        Vouchers voucher = new Vouchers();
        this.WebGridXGrid.DataSource = voucher.GetDs("select * from vouchers where Checked='X'");
        this.WebGridXGrid.DataBind();
    }

    protected void WebGridChecked_InitializeLayout(object sender, LayoutEventArgs e)
    {
        e.Layout.Bands[0].DataKeyField = "htcode";
        e.Layout.Pager.AllowPaging = true;
        e.Layout.Pager.PageSize = 4;
    }
    protected void WebGridChecked_PageIndexChanged(object sender, Infragistics.WebUI.UltraWebGrid.PageEventArgs e)
    {
        WebGridChecked.DisplayLayout.Pager.CurrentPageIndex = e.NewPageIndex;
        bind();
    }
    protected void GridNChecked_InitializeLayout(object sender, LayoutEventArgs e)
    {
        e.Layout.Bands[0].DataKeyField = "htcode";
        e.Layout.Pager.AllowPaging = true;
        e.Layout.Pager.PageSize = 8;
    }
    protected void GridNChecked_PageIndexChanged(object sender, Infragistics.WebUI.UltraWebGrid.PageEventArgs e)
    {
        GridNChecked.DisplayLayout.Pager.CurrentPageIndex = e.NewPageIndex;
        bindNgrid();
    }
    protected void WebGridXGrid_InitializeLayout(object sender, LayoutEventArgs e)
    {
        e.Layout.Bands[0].DataKeyField = "htcode";
        e.Layout.Pager.AllowPaging = true;
        e.Layout.Pager.PageSize = 2;
    }
    protected void WebGridXGrid_PageIndexChanged(object sender, Infragistics.WebUI.UltraWebGrid.PageEventArgs e)
    {
        WebGridXGrid.DisplayLayout.Pager.CurrentPageIndex = e.NewPageIndex;
        bindXgrid();
    }

   //察看
    protected void WebLook_Click(object sender, Infragistics.WebUI.WebDataInput.ButtonEventArgs e)
    {
     
        if (this.WebGridChecked.DisplayLayout.SelectedRows.Count > 0)
           Response.Redirect("CheckLook.aspx?htcode=" + this.WebGridChecked.DisplayLayout.SelectedRows[0].Cells[0].Value.ToString() + "");
    }
    protected void WebLook0_Click(object sender, Infragistics.WebUI.WebDataInput.ButtonEventArgs e)
    {
        if (this.GridNChecked.DisplayLayout.SelectedRows.Count > 0)
            Response.Redirect("CheckLook.aspx?htcode=" + this.GridNChecked.DisplayLayout.SelectedRows[0].Cells[0].Value.ToString() + "");
    }
    protected void WebLook1_Click(object sender, Infragistics.WebUI.WebDataInput.ButtonEventArgs e)
    {
        if (this.WebGridXGrid.DisplayLayout.SelectedRows.Count > 0)
            Response.Redirect("CheckLook.aspx?htcode=" + this.WebGridXGrid.DisplayLayout.SelectedRows[0].Cells[0].Value.ToString() + "");
    }
}