<div> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr><td align="center" style="color:#039" mce_style="color:#039" colspan=3><h3></h3></td></tr> <tr><td width="40%"></td><td width="27%" align="center"style="color:#039"><h5>在册罪犯总数:<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label></h5></td><td width="33%"></td></tr> <tr> <td colspan=3> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ssodsn %>" SelectCommand="SELECT a.*,b.dept_name as sname,c.dept_name as dname FROM [dbo].[B_prinson] a inner join (select max(addtime) as addtime,deptid from B_prinson a group by deptid)m on a.addtime =m.addtime inner join B_department b on a.deptid=b.id inner join B_department c on a.deptidb=c.id order by a.autoid desc"></asp:SqlDataSource> <dxwpg:ASPxPivotGrid ID="ASPxPivotGrid1" SortBySummaryInfo-SummaryType="Max" runat="server" CssClass="" DataSourceID="SqlDataSource1" OnCustomFieldSort="ASPxPivotGrid1_CustomFieldSort" Font-Bold="True" Font-Size="Medium" Width="100%" OnCustomSummary="ASPxPivotGrid1_CustomSummary"> <Styles CssFilePath="~/App_Themes/Glass/{0}/styles.css" CssPostfix="Glass"> <HeaderStyle BackColor="White"> <HoverStyle> <BackgroundImage ImageUrl="~/App_Themes/Glass/PivotGrid/pgHeaderBackHot.gif" Repeat="RepeatX" /> </HoverStyle> <BackgroundImage ImageUrl="~/App_Themes/Glass/PivotGrid/pgHeaderBack.gif" Repeat="RepeatX" /> </HeaderStyle> <FilterAreaStyle> <BackgroundImage ImageUrl="~/App_Themes/Glass/PivotGrid/pgFilterAreaBack.gif" Repeat="RepeatX" /> </FilterAreaStyle> <FilterButtonPanelStyle> <BackgroundImage ImageUrl="~/App_Themes/Glass/PivotGrid/pgFilterPanelBack.gif" Repeat="RepeatX" /> </FilterButtonPanelStyle> <TotalCellStyle Font-Bold="True" ForeColor="Red"> </TotalCellStyle> <GrandTotalCellStyle Font-Bold="True" Font-Size="14px" ForeColor="#003399"> </GrandTotalCellStyle> </Styles> <Fields> <dxwpg:PivotGridField ID="field1" Area="RowArea" AreaIndex="0" Name="field1" FieldName="dname" GroupIndex="0" InnerGroupIndex="0" SortMode="Custom" > <ValueStyle ForeColor="#003399" Font-Bold="True" Font-Size="13px"> </ValueStyle> </dxwpg:PivotGridField> <dxwpg:PivotGridField ID="field2" Area="RowArea" AreaIndex="1" Name="field2" FieldName="sname" GroupIndex="0" InnerGroupIndex="1" SortMode="Custom"> <ValueStyle ForeColor="#003399" Font-Bold="True" Font-Size="13px" > </ValueStyle> </dxwpg:PivotGridField> <dxwpg:PivotGridField ID="field3" Area="DataArea" AreaIndex="0" Name="field3" FieldName="pnum1" Caption="在册数"> <CellStyle HorizontalAlign="Center"> </CellStyle> <ValueStyle ForeColor="#003399" Font-Bold="True" Font-Size="Medium" CssClass="tdwd"> </ValueStyle> </dxwpg:PivotGridField> <dxwpg:PivotGridField ID="field4" Area="DataArea" AreaIndex="1" Caption="在押数" Name="field4" FieldName="pnum2"> <ValueStyle ForeColor="#003399" Font-Bold="True" Font-Size="Medium" CssClass="tdwd"> </ValueStyle> <CellStyle HorizontalAlign="Center"> </CellStyle> </dxwpg:PivotGridField> <dxwpg:PivotGridField ID="field5" Area="DataArea" AreaIndex="2" Caption="出工" Name="field5" FieldName="pnum3" > <ValueStyle ForeColor="#003399" Font-Bold="True" Font-Size="Medium" CssClass="tdwd"> </ValueStyle> <CellStyle HorizontalAlign="Center"> </CellStyle> </dxwpg:PivotGridField> <dxwpg:PivotGridField ID="field6" Area="DataArea" AreaIndex="3" Caption="留监" Name="field6" FieldName="pnum4"> <ValueStyle ForeColor="#003399" Font-Bold="True" Font-Size="Medium" CssClass="tdwd"> </ValueStyle> <CellStyle HorizontalAlign="Center"> </CellStyle> </dxwpg:PivotGridField> <dxwpg:PivotGridField ID="field7" Area="DataArea" AreaIndex="4" Caption="禁闭" Name="field7" FieldName="pnum5" > <ValueStyle ForeColor="#003399" Font-Bold="True" Font-Size="Medium" CssClass="tdwd"> </ValueStyle> <CellStyle HorizontalAlign="Center"> </CellStyle> </dxwpg:PivotGridField> <dxwpg:PivotGridField ID="field8" Area="DataArea" AreaIndex="5" Caption="严管" Name="field8" FieldName="pnum6"> <ValueStyle ForeColor="#003399" Font-Bold="True" Font-Size="Medium" CssClass="tdwd"> </ValueStyle> <CellStyle HorizontalAlign="Center"> </CellStyle> </dxwpg:PivotGridField> <dxwpg:PivotGridField ID="field9" Area="DataArea" AreaIndex="6" Caption="留医" Name="field9" FieldName="pnum7"> <ValueStyle ForeColor="#003399" Font-Bold="True" Font-Size="Medium" CssClass="tdwd"> </ValueStyle> <CellStyle HorizontalAlign="Center"> </CellStyle> </dxwpg:PivotGridField> <dxwpg:PivotGridField ID="field10" Area="DataArea" AreaIndex="7" Caption="其他" Name="field10" FieldName="pnum8"> <ValueStyle ForeColor="#003399" Font-Bold="True" Font-Size="Medium" CssClass="tdwd"> </ValueStyle><CellStyle HorizontalAlign="Center"> </CellStyle> </dxwpg:PivotGridField> <dxwpg:PivotGridField ID="field" Area="ColumnArea" AreaIndex="0" Name="field" > <ValueTemplate> <%-- <asp:Label ID="Label1" Width="600px" runat="server" Text="福州监狱当日罪犯分布情况" Font-Bold="true" ForeColor="red" Font-Size="15pt"></asp:Label> --%> </ValueTemplate> <CellStyle Font-Bold="True" ForeColor="Red"> </CellStyle> </dxwpg:PivotGridField> <dxwpg:PivotGridField ID="field11" Area="RowArea" AreaIndex="2" FieldName="deptid" Name="field11" Visible="False"> </dxwpg:PivotGridField> <dxwpg:PivotGridField ID="field12" Area="RowArea" AreaIndex="3" FieldName="deptidb" Name="field12" Visible="False"> </dxwpg:PivotGridField> </Fields> <EmptyAreaTemplate>0</EmptyAreaTemplate> <Images ImageFolder="~/App_Themes/Glass/{0}/"> </Images> <OptionsView ShowContextMenusForAllFieldValues="False" ShowColumnGrandTotals="False" ShowColumnHeaders="False" ShowDataHeaders="False" ShowFilterHeaders="False" ShowRowTotals="False" ShowRowHeaders="False" ShowColumnTotals="False" ShowRowGrandTotals="False" /> <StylesPrint TotalCell-BackColor="Red" /> <Groups> <dxwpg:PivotGridWebGroup /> </Groups> <OptionsPager RowsPerPage="50"> </OptionsPager> </dxwpg:ASPxPivotGrid> </td> </tr> </table> </div> 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 DevExpress.XtraPivotGrid.Localization; using System.Collections.Generic; using DevExpress.Web.ASPxPivotGrid; using DevExpress.XtraPivotGrid; public partial class allperson : System.Web.UI.Page { ArrayList order = new ArrayList(new object[] { "一大队", "二大队", "三大队", "四大队", "五大队", "六大队", "七大队", "出入监大队", "" }); ArrayList order1 = new ArrayList(new object[] { "一大队一中队", "一大队二中队", "一大队三中队", "二大队一中队", "二大队二中队", "二大队三中队", "三大队一中队", "三大队二中队", "三大队三中队", "四大队一中队", "四大队二中队", "四大队三中队", "五大队一中队", "五大队二中队", "五大队三中队", "六大队一中队", "六大队二中队", "六大队三中队", "七大队总仓", "七大队后勤队", "入监队", "集训队", "回归中心", "医院" }); static allperson() { MyPivotGridLocalizer.Active = new MyPivotGridLocalizer(); } protected void Page_Load(object sender, EventArgs e) { } protected void ASPxPivotGrid1_CustomFieldSort(object sender, PivotGridCustomFieldSortEventArgs e) { if (e.Field.FieldName == "dname") { if (Equals(e.Value1, e.Value2)) { e.Result = 0; } else { e.Result = (order.IndexOf(e.Value1) > order.IndexOf(e.Value2)) ? 1 : -1; } } else if (e.Field.FieldName == "sname") { if (Equals(e.Value1, e.Value2)) { e.Result = 0; } else { e.Result = (order1.IndexOf(e.Value1) > order1.IndexOf(e.Value2)) ? 1 : -1; } } else return; e.Handled = true; } protected void ASPxPivotGrid1_CustomSummary(object sender, PivotGridCustomSummaryEventArgs e) { if (e.FieldName == "pnum1") { this.Label1.Text=e.SummaryValue.CustomValue.ToString(); } } } public class MyPivotGridLocalizer : PivotGridLocalizer { public override string GetLocalizedString(DevExpress.XtraPivotGrid.Localization.PivotGridStringId id) { switch (id) { case PivotGridStringId.GrandTotal: return "<div style="font-weight:bold; color:#003399; font-size:16px" mce_style="font-weight:bold; color:#003399; font-size:16px">合 计 </div>"; } return base.GetLocalizedString(id); } }