Infragistics2.WebUI.UltraWebGrid.v6.2 中的父子表展示示范

下面是.aspx页面

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="MonthQuantity_query.aspx.cs" Inherits="Query_ProjectPhase_MonthQuantity_query" %>

<%@ OutputCache Duration="1" VaryByParam="*" %>

<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>

<%@ Register TagPrefix="iewc" Namespace="Microsoft.Web.UI.WebControls" Assembly="Microsoft.Web.UI.WebControls, Version=1.0.2.116, Culture=neutral, PublicKeyToken=31bf3856ad364e35" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<%@ Register Assembly="Infragistics2.WebUI.UltraWebGrid.v6.2, Version=6.2.20062.34, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb"

Namespace="Infragistics.WebUI.UltraWebGrid" TagPrefix="igtbl" %>

<HEAD>

<title>工程量月报【报表编制】</title>

<!--

function checkAll(flag)

{

var myGrid = igtbl_getGridById("uwg_MountMonth");

for (i=0; i < myGrid.Rows.length; i++)

{

myGrid.Rows.getRow(i).getCellFromKey("Select").setValue(flag);

}

//-->

</script>

</HEAD>

<TR>

</TD>

</TR>

<TR>

</TD>

</TR>

</TABLE>

<asp:label id="lbl_RecCount" runat="server"></asp:label>

<TR>

<igtbl:UltraWebGrid ID="dg_main" runat="server" OnDataBinding="dg_main_DataBinding"

Width="100%" Height="100%" OnInitializeLayout="dg_main_InitializeLayout" >

<Bands>

<igtbl:UltraGridBand Key="Single">

</AddNewRow>

<FilterDropDownStyle BackColor="White" BorderColor="Silver" BorderStyle="Solid" BorderWidth="1px"

CustomRules="overflow:auto;" Font-Names="Verdana,Arial,Helvetica,sans-serif"

Font-Size="11px" Width="200px">

</FilterDropDownStyle>

</FilterHighlightRowStyle>

</FilterOptions>

<igtbl:UltraGridColumn BaseColumnName="PM_ROWID" HeaderText="主键" Hidden="True" Key="Pm_RowId">

</Header>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="Project_Name" HeaderText="项目名称" Key="ProName">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="ISSUENO" HeaderText="编号">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="CONTRACTNAME" HeaderText="合同名称" Key="Contract_Name">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="TNAME" DataType="" Format="" HeaderText="乙方单位">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="YEARMONTH" DataType="" Format="" HeaderText="年月"

Width="50px">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="STARTDAY" DataType="System.DateTime" Format="yyyy-MM-dd"

HeaderText="开始日期" Key="tInvestSum">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="ENDDAY" HeaderText="结束日期">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="JZREQUITEMONEY" HeaderText="建筑申请款(元)">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="AZREQUITEMONEY" HeaderText="安装申请款(元)">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="QTREQUITEMONEY" HeaderText="汇总申请款(元)">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="JZCONFIRMMONEY" HeaderText="建筑审批金额(元)">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="AZREQUITEMONEY" HeaderText="安装审批金额(元)">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="QTCONFIRMMONEY" HeaderText="汇总审批金额(元)">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="WRITEMAN" HeaderText="编制人" Width="50px">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="WRITEDAY" DataType="System.DateTime" Format="yyyy-MM-dd"

HeaderText="编制日期" Width="80px">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="CONFIRMMAN" HeaderText="审批人" Width="50px">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="CONFIRMDAY" DataType="System.DateTime" Format="yyyy-MM-dd"

HeaderText="审批日期" Width="80px">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="REMARK" HeaderText="备注">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

</Columns>

</igtbl:UltraGridBand>

<igtbl:UltraGridBand Key="Sub">

</AddNewRow>

<FilterDropDownStyle BackColor="White" BorderColor="Silver" BorderStyle="Solid" BorderWidth="1px"

CustomRules="overflow:auto;" Font-Names="Verdana,Arial,Helvetica,sans-serif"

Font-Size="11px" Width="200px">

</FilterDropDownStyle>

</FilterHighlightRowStyle>

</FilterOptions>

<igtbl:UltraGridColumn BaseColumnName="PM_ROWID" HeaderText="主键" Hidden="True" Key="Pm_RowId">

</Header>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="TASKNAME" HeaderText="工程量名称" Key="ProName"

Width="130px">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="MEASUREUNIT" HeaderText="计量单位" Width="50px">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="PRICE" DataType="" Format="" HeaderText="单价" Width="50px">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="CHECKAMOUNT" DataType="" Format="" HeaderText="数量"

Width="50px">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

<igtbl:UltraGridColumn BaseColumnName="HJ" Format="" HeaderText="合价" Key="tInvestSum" Width="50px">

</Header>

</CellStyle>

</Footer>

</igtbl:UltraGridColumn>

</Columns>

</igtbl:UltraGridBand>

</Bands>

<DisplayLayout AllowColSizingDefault="Free" AllowSortingDefault="OnClient" AllowUpdateDefault="Yes"

AutoGenerateColumns="False" BorderCollapseDefault="Separate" HeaderClickActionDefault="SortMulti"

Name="dgxmain" RowHeightDefault="18px" SelectTypeCellDefault="Extended" SelectTypeColDefault="Extended"

SelectTypeRowDefault="Single" StationaryMargins="Header" TableLayout="Fixed"

Version="4.00" ViewType="Hierarchical" JavaScriptFileName="" JavaScriptFileNameCommon="">

</GroupByBox>

</GroupByRowStyleDefault>

</FooterStyleDefault>

</RowStyleDefault>

<FilterOptionsDefault AllowRowFiltering="OnClient" AllString="(全部)" EmptyString="(为空)"

NonEmptyString="(不为空)">

<FilterDropDownStyle BackColor="White" BorderColor="Silver" BorderStyle="Solid" BorderWidth="1px"

CustomRules="overflow:auto;" Font-Names="Verdana,Arial,Helvetica,sans-serif"

Font-Size="11px" Width="200px">

</FilterDropDownStyle>

</FilterHighlightRowStyle>

</FilterOptionsDefault>

</HeaderStyleDefault>

</EditCellStyleDefault>

<FrameStyle BackColor="Window" BorderColor="InactiveCaption" BorderStyle="Solid"

BorderWidth="1px" Font-Names="Microsoft Sans Serif" Font-Size="8.25pt" Height="100%"

Width="100%">

</FrameStyle>

<Pager>

</Style>

</Pager>

</Style>

</AddNewBox>

<ImageUrls BlankImage="" CollapseImage="" CurrentEditRowImage="" CurrentRowImage=""

ExpandImage="" FilterAppliedImage="" FilterImage="" FixedHeaderOffImage="" FixedHeaderOnImage=""

GridCornerImage="" GroupByImage="" GroupDownArrow="" GroupUpArrow="" ImageDirectory=""

NewRowImage="" RowLabelBlankImage="" SortAscending="" SortDescending="" UnGroupByImage="" />

</DisplayLayout>

</igtbl:UltraWebGrid></TD>

</TR>

</TABLE>

<TR>

<webdiyer:AspNetPager ID="AspNetPager1" runat="server" FirstPageText="第一页 " HorizontalAlign="Right"

LastPageText="最后一页" NextPageText="下一页" NumericButtonCount="5" NumericButtonTextFormatString="[{0}]"

OnPageChanged="AspNetPager1_PageChanged" PageSize="20" PrevPageText="上一页" ShowBoxThreshold="2"

ShowCustomInfoSection="Left" SubmitButtonText="转到">

</webdiyer:AspNetPager>

<asp:Button ID="btn_Return" runat="server" OnClick="btn_Return_Click" Text="返回" /></TD>

</TR>

</TABLE>

<!--

if(window.document.all("ip_infor").value!="")

{

window.alert(window.document.all("ip_infor").value);

window.document.all("ip_infor").value="";

}

-->

</script>

</form>

</body>

</html>

下面是.aspx.cs页面

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 Temco.EPMS.BusinessRules;

public partial class Query_ProjectPhase_MonthQuantity_query : System.Web.UI.Page

{

DataSet ds = new DataSet();

private string pri_str_filter, pri_str_sort, pri_str_PageIndex,strYearMonth=string.Empty,strContractId=string.Empty;

protected void Page_Load(object sender, System.EventArgs e)

{

try

{

string str_OverTime = Session["CurrProCode"].ToString();

}

catch (System.Exception myEx)

{

Response.Redirect("../LogPrompt.aspx?Flag=OverTime");

UIUtility.Log(myEx.Message, Request.PhysicalPath);

//Server.Transfer("../../../error.aspx");

}

if (Request.QueryString["YearMonth"] != null )

{

strYearMonth = Request.QueryString["YearMonth"].ToString();

int index = strYearMonth.IndexOf('|');

if(index > 0)

{

if(strYearMonth.Length == 6)

{

strYearMonth = strYearMonth.Replace('|','0');

}

else

{

strYearMonth = strYearMonth.Replace('|',' ');

}

if (Request.QueryString["ContractID"] != null)

{

strContractId = Request.QueryString["ContractID"].ToString();

}

try

{

if (!Page.IsPostBack)

{

//设置导航路径，并返回主页

if (Request.QueryString["pagepmrowid"] != null && Request.QueryString["pagepmrowid"].ToString() != "")

{

string str_pagerowid = Request.QueryString["pagepmrowid"].ToString();

UIUtility.EntryPageNavigationBar(str_pagerowid, Request.ApplicationPath.ToString(), ref this.menu, ref this.lbl_Caption2);

}

else

{

}

catch (System.Exception myEx)

{

UIUtility.Log(myEx.Message, Request.PhysicalPath);

}

this.dg_main.DataBind();

}

protected void dg_main_DataBinding(object sender, EventArgs e)

{

GetSequencesBui dbhelper = new GetSequencesBui();

DataTable dt, dtSub;

//if (AspNetPager1.CurrentPageIndex == 0)

//{

// AspNetPager1.CurrentPageIndex = 1;

//}

//AspNetPager1.RecordCount = count;

string sql = @"select p.PM_ROWID,PROJECT_NAME,ISSUENO,CONTRACTNAME,TNAME,YEARMONTH,STARTDAY,ENDDAY,

JZREQUITEMONEY,AZREQUITEMONEY,QTREQUITEMONEY,JZCONFIRMMONEY,AZREQUITEMONEY,QTCONFIRMMONEY,

WRITEMAN,WRITEDAY,CONFIRMMAN,CONFIRMDAY,p.REMARK from PROJECTAMOUNTMONTH p left join project

pr on pr.project_code=p.firstpcode left join contract c on p.CONTRACTID=c.PM_ROWID left join department d on c.UnitID=d.PM_ROWID where 1=1 ";

if (strContractId != "")

{

sql += " and p.CONTRACTID =" + strContractId;

}

if (strYearMonth != "")

{

sql += " and p.YEARMONTH ='" + strYearMonth.Trim() + "'";

}

//工程量月报

dt = dbhelper.getBySelfSql(sql);

//工程量月报明细

dtSub = dbhelper.getBySelfSql(@"select PM_ROWID,MONTHREPORTID,TASKNAME,MEASUREUNIT,PRICE,CHECKAMOUNT,HJ from PROJECTAMOUNTMONTHDTL ");

try

{

ds.Tables.Clear();

ds.Tables.Add(dt);

ds.Tables[0].TableName = "MonthPro";

ds.Tables.Add(dtSub);

ds.Tables[1].TableName = "DtlPro";

}

catch (System.Exception ex)

{

}

try

{

ds.Relations.Clear();

ds.Relations.Add("MonthRelSub",

ds.Tables["MonthPro"].Columns["PM_ROWID"],

ds.Tables["DtlPro"].Columns["MONTHREPORTID"]);

}

catch

{

}

this.dg_main.DataSource = ds.Tables["MonthPro"].DefaultView;

//动态设置用户自定义文本内容

//AspNetPager1.CustomInfoText = UIUtility.GetCustomSectionTextInfo(AspNetPager1.RecordCount, AspNetPager1.PageCount, AspNetPager1.CurrentPageIndex);

}

protected void AspNetPager1_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e)

{

AspNetPager1.CurrentPageIndex = e.NewPageIndex;

this.dg_main.DataBind();

}

protected void dg_main_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e)

{

//分页控制

dg_main.DisplayLayout.Pager.AllowPaging = true;

dg_main.DisplayLayout.Pager.QuickPages = 4;

dg_main.DisplayLayout.Pager.PageSize = 10;

dg_main.DisplayLayout.Pager.Pattern = "<table width=100%><tr><td align=left>页码：[currentpageindex]/[pagecount] 每页:[pagesize]</td><td align=right>[default]<td></tr></table>";

}

protected void btn_Return_Click(object sender, EventArgs e)

{

Response.Redirect(UIUtility.PopReturn(Session));

}

posted on 2007-09-12 09:59 程序缘阅读(2068) 评论(2) 收藏举报

刷新页面返回顶部

程序是我的生命,我对它的执着一万年不变

Infragistics2.WebUI.UltraWebGrid.v6.2 中的父子表展示示范

导航

公告