Grid中BoundField绑定数据为数字显示不了 - FineUI 官方论坛

<ext:Grid ID="Grid1" runat="server" BoxFlex="1" ShowBorder="true" ShowHeader="false"
EnableCheckBoxSelect="False" DataKeyNames="BuildID,BuildName" AllowSorting="true"
OnSort="Grid1_Sort" SortColumnIndex="0" SortDirection="ASC" AllowPaging="true"
IsDatabasePaging="true" OnPreDataBound="Grid1_PreDataBound" OnRowCommand="Grid1_RowCommand"
OnPageIndexChange="Grid1_PageIndexChange">
<Toolbars>
<ext:Toolbar ID="Toolbar1" runat="server">
<Items>
<ext:Button ID="btnExport" runat="server" Icon="PageExcel" EnablePostBack="false"
Text="导出">
</ext:Button>
</Items>
</ext:Toolbar>
</Toolbars>
<Columns>
<ext:BoundField DataField="BuildID" SortField="BuildID" Hidden="true" />
<ext:BoundField DataField="BuildName" SortField="BuildName" Width="180px" HeaderText="名称" />
<ext:BoundField HeaderText="总套数" TextAlign="Center" SortField="allSum" DataField="allSum" />
<ext:BoundField DataField="allCom" SortField="allCom" Width="100px" HeaderText="总欠佣金额" />
<ext:BoundField DataField="wSum" SortField="wSum" Width="100px" HeaderText="一年内套数" />
<ext:BoundField DataField="wCom" SortField="wCom" Width="100px" HeaderText="一年内总金额" />
<ext:BoundField DataField="ySum" SortField="ySum" Width="100px" HeaderText="一年以上套数" />
<ext:BoundField DataField="yCom" SortField="yCom" Width="100px" HeaderText="一年以上总金额" />
</Columns>
</ext:Grid>

复制代码

private void BindGrid()
{
SqlQuery q = new Select().From<VwSCAOweCommission>();
q.Where("1").IsEqualTo("1");
string searchText = ttbSearchMessage.Text;
if (!String.IsNullOrEmpty(searchText))
{
q.And(VwSCAOweCommission.Columns.BuildName).ContainsString(searchText);
}
Grid1.RecordCount = q.GetRecordCount();
q.OrderBys.Add(GetSortExpression(Grid1, VwSCAOweCommission.Schema));
q.Paged(Grid1.PageIndex + 1, Grid1.PageSize);
VwSCAOweCommissionCollection items = q.ExecuteAsCollection<VwSCAOweCommissionCollection>();
Grid1.DataSource = items;
Grid1.DataBind();
}

复制代码