Devexpress 12.2.8.0 部分学习笔记1 【ASPxGridview】

<%@ Page Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="MasterDetail.aspx.cs"
    Inherits="MasterDetail_MasterDetail" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentHolder" runat="Server">
    <dx:ASPxCheckBox ID="chkSingleExpanded" runat="server" Text="Keep a single expanded row at a time"
        AutoPostBack="true" OnCheckedChanged="chkSingleExpanded_CheckedChanged" />
    <br />
    <dx:ASPxGridView ID="grid" ClientInstanceName="grid" runat="server" DataSourceID="masterDataSource"
        KeyFieldName="CustomerID" Width="100%">
        <Columns>
            <dx:GridViewDataColumn FieldName="ContactName" VisibleIndex="0" />
            <dx:GridViewDataColumn FieldName="CompanyName" VisibleIndex="1" />
            <dx:GridViewDataColumn FieldName="City" VisibleIndex="2" />
            <dx:GridViewDataColumn FieldName="Country" VisibleIndex="3" />
        </Columns>
        <Templates>
            <DetailRow>
                Contact Phone: <b>
                    <%# Eval("Phone")%></b>, Fax: <b>
                        <%# Eval("Fax")%></b>
                <br />
                <br />
                <dx:ASPxGridView ID="detailGrid" runat="server" DataSourceID="detailDataSource" KeyFieldName="OrderID"
                    Width="100%" OnBeforePerformDataSelect="detailGrid_DataSelect" OnCustomUnboundColumnData="detailGrid_CustomUnboundColumnData">
                    <Columns>
                        <dx:GridViewDataColumn FieldName="OrderID" Caption="Order Id" VisibleIndex="1" />
                        <dx:GridViewDataColumn FieldName="OrderDate" VisibleIndex="2" />
                        <dx:GridViewDataColumn FieldName="ShipName" VisibleIndex="2" />
                        <dx:GridViewDataColumn FieldName="Quantity" VisibleIndex="5" Name="Quantity" />
                        <dx:GridViewDataTextColumn FieldName="UnitPrice" VisibleIndex="4">
                            <PropertiesTextEdit DisplayFormatString="c" />
                        </dx:GridViewDataTextColumn>
                        <dx:GridViewDataTextColumn FieldName="Total" VisibleIndex="6" UnboundType="Decimal">
                            <PropertiesTextEdit DisplayFormatString="c" />
                        </dx:GridViewDataTextColumn>
                    </Columns>
                    <Settings ShowFooter="True" />
                    <TotalSummary>
                        <dx:ASPxSummaryItem FieldName="CompanyName" SummaryType="Count" />
                        <dx:ASPxSummaryItem FieldName="Total" SummaryType="Sum" />
                        <dx:ASPxSummaryItem FieldName="Quantity" SummaryType="Sum" />
                    </TotalSummary> 
                </dx:ASPxGridView>
            </DetailRow>
        </Templates>
        <SettingsDetail ShowDetailRow="true" />
    </dx:ASPxGridView>
    <asp:AccessDataSource ID="masterDataSource" runat="server" DataFile="~/App_Data/nwind.mdb"
        SelectCommand="SELECT * FROM [Customers]"></asp:AccessDataSource>
    <asp:AccessDataSource ID="detailDataSource" runat="server" DataFile="~/App_Data/nwind.mdb"
        SelectCommand="SELECT * FROM [Invoices] Where CustomerID = ?">
        <SelectParameters>
            <asp:SessionParameter Name="CustomerID" SessionField="CustomerID" Type="String" />
        </SelectParameters>
    </asp:AccessDataSource>
</asp:Content>

using System;
using System.Web.UI;
using DevExpress.Web.ASPxGridView;

public partial class MasterDetail_MasterDetail : Page {
    protected void Page_Load(object sender, EventArgs e) {
        if(!IsPostBack) {
            grid.DataBind();
            grid.DetailRows.ExpandRow(0);
        }
    }
    protected void detailGrid_DataSelect(object sender, EventArgs e) {
        Session["CustomerID"] = (sender as ASPxGridView).GetMasterRowKeyValue();
    }
    protected void detailGrid_CustomUnboundColumnData(object sender, ASPxGridViewColumnDataEventArgs e) {
        if(e.Column.FieldName == "Total") {
            decimal price = (decimal)e.GetListSourceFieldValue("UnitPrice");
            int quantity = Convert.ToInt32(e.GetListSourceFieldValue("Quantity"));
            e.Value = price * quantity;
        }
    }
    protected void chkSingleExpanded_CheckedChanged(object sender, EventArgs e) {
        grid.SettingsDetail.AllowOnlyOneMasterRowExpanded = chkSingleExpanded.Checked;
        if(grid.SettingsDetail.AllowOnlyOneMasterRowExpanded) {
            grid.DetailRows.CollapseAllRows();
        }
    }
}

 

 /// <summary>
        /// grid total
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void ASPxGridView4_CustomUnboundColumnData(object sender, ASPxGridViewColumnDataEventArgs e)
        {
            if (e.Column.FieldName  == "总计")
            {
                int unit_price =Convert .ToInt32 ( e.GetListSourceFieldValue("unit_price"));
                int quantity = Convert.ToInt32(e.GetListSourceFieldValue("quantity"));
                e.Value = unit_price * quantity;
            }
            if (e.Column.FieldName == "折后")
            {
                int unit_price = Convert.ToInt32(e.GetListSourceFieldValue("unit_price"));
                int quantity = Convert.ToInt32(e.GetListSourceFieldValue("quantity"));
                decimal   discount = Convert.ToDecimal (e.GetListSourceFieldValue("discount"));//在这里  不能直接用强制转换，要用convert，否则会报错
                e.Value = unit_price * quantity  * discount;
            }
        }

【详细和主表】

 

	绑定到数据
					数据表示基础
					对焦和导航
					数据编辑
					数据塑造和操纵
					数据格式
					主从关系
					外观定制
					布局
					模板
					出口
					ASPxGridLookup

 

主要就是这些功能

　　【绑定数据 Binding to data】

　　　　LinqServerModeDataSource

　　　　sqldatasource这个方式

　　　　

 

 

【数据表示基础 data represention basics】

　　有一个自定义窗口的特性

   

　　【对焦与导航 Focus and navigation】

　　　焦点行

　　　　ASPxGridView.FocusedRowIndex属性--->true

　　　　ASPxGridView.FocusedRowChanged

　　　　选择

　　　　multiple row selection

　　　　

　　【数据编辑 data edit】

　　　　Edit form 有一点值得注意就是，自动绑定的时候，主键那一列

　　　　会自动设为readonly=true，如果要启用编辑的话，需要把

　　　　那个column的这个属性改变，还有绑定的时候要在高级那个选项的内容勾选才能编辑

　　　　【数据验证】

using System;
using System.Collections.Generic;
using System.Web.UI;
using DevExpress.Web.ASPxGridView;

public partial class GridEditing_Validation : Page {
    protected void Page_Load(object sender, EventArgs e) {

    }
    protected void grid_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e) {
        foreach(GridViewColumn column in grid.Columns) {
            GridViewDataColumn dataColumn = column as GridViewDataColumn;
            if(dataColumn == null) continue;
            if(e.NewValues[dataColumn.FieldName] == null) {
                e.Errors[dataColumn] = "Value can't be null.";
            }
        }
        if(e.Errors.Count > 0) e.RowError = "Please, fill all fields.";
        if(e.NewValues["FirstName"] != null && e.NewValues["FirstName"].ToString().Length < 2) {
            AddError(e.Errors, grid.Columns["FirstName"], "First Name must be at least two characters long.");
        }
        if(e.NewValues["LastName"] != null && e.NewValues["LastName"].ToString().Length < 2) {
            AddError(e.Errors, grid.Columns["LastName"], "Last Name must be at least two characters long.");
        }
        if(e.NewValues["Email"] != null && !e.NewValues["Email"].ToString().Contains("@")) {
            AddError(e.Errors, grid.Columns["Email"], "Invalid e-mail.");
        }

        int age = 0;
        int.TryParse(e.NewValues["Age"] == null ? string.Empty : e.NewValues["Age"].ToString(), out age);
        if(age < 18) {
            AddError(e.Errors, grid.Columns["Age"], "Age must be greater than or equal 18.");
        }
        DateTime arrival = DateTime.MinValue;
        DateTime.TryParse(e.NewValues["ArrivalDate"] == null ? string.Empty : e.NewValues["ArrivalDate"].ToString(), out arrival);
        if(DateTime.Today.Year != arrival.Year || DateTime.Today.Month != arrival.Month) {
            AddError(e.Errors, grid.Columns["ArrivalDate"], "Arrival date is required and must belong to the current month.");
        }

        if(string.IsNullOrEmpty(e.RowError) && e.Errors.Count > 0) e.RowError = "Please, correct all errors.";
    }
    void AddError(Dictionary<GridViewColumn, string> errors, GridViewColumn column, string errorText) {
        if(errors.ContainsKey(column)) return;
        errors[column] = errorText;
    }
    protected void grid_HtmlRowPrepared(object sender, ASPxGridViewTableRowEventArgs e) {
        bool hasError = e.GetValue("FirstName").ToString().Length <= 1;
        hasError = hasError || e.GetValue("LastName").ToString().Length <= 1;
        hasError = hasError || !e.GetValue("Email").ToString().Contains("@");
        hasError = hasError || (int)e.GetValue("Age") < 18;
        DateTime arrival = (DateTime)e.GetValue("ArrivalDate");
        hasError = hasError || DateTime.Today.Year != arrival.Year || DateTime.Today.Month != arrival.Month;
        if(hasError) {
            e.Row.ForeColor = System.Drawing.Color.Red;
        }
    }
    protected void grid_StartRowEditing(object sender, DevExpress.Web.Data.ASPxStartRowEditingEventArgs e) {
        if(!grid.IsNewRowEditing) {
            grid.DoRowValidation();
        }
    }
    protected void grid_ParseValue(object sender, DevExpress.Web.Data.ASPxParseValueEventArgs e) {
        if(e.FieldName.Equals("Age")) {
            int age = 0;
            if(e.Value == null || !int.TryParse(e.Value.ToString(), out age))
                throw new Exception("Age must be an ineteger value.");
        }
    }
}

【数据汇总】

　　

 Grid Total<dx:ASPxGridView ID="ASPxGridView4" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource3" KeyFieldName="id" OnCustomUnboundColumnData="ASPxGridView4_CustomUnboundColumnData">
                        <TotalSummary>
                            <dx:ASPxSummaryItem FieldName="company_name" ShowInColumn="company_name" ShowInGroupFooterColumn="company_name" SummaryType="Count" />
                            <dx:ASPxSummaryItem DisplayFormat="c" FieldName="总计" ShowInColumn="总计" ShowInGroupFooterColumn="总计" SummaryType="Sum" Tag="Sum" />
                            <dx:ASPxSummaryItem DisplayFormat="c" FieldName="折后" ShowInColumn="折后" ShowInGroupFooterColumn="折后" SummaryType="Sum" />
                            <dx:ASPxSummaryItem FieldName="总计" ShowInColumn="总计" ShowInGroupFooterColumn="总计" SummaryType="Max" />
                            <dx:ASPxSummaryItem FieldName="总计" ShowInColumn="总计" ShowInGroupFooterColumn="总计" SummaryType="Min" ValueDisplayFormat="c" />
                            <dx:ASPxSummaryItem FieldName="unit_price" ShowInColumn="unit_price" ShowInGroupFooterColumn="unit_price" SummaryType="Max" />
                            <dx:ASPxSummaryItem FieldName="unit_price" ShowInColumn="unit_price" ShowInGroupFooterColumn="unit_price" SummaryType="Min" />
                            <dx:ASPxSummaryItem FieldName="discount" ShowInColumn="discount" ShowInGroupFooterColumn="discount" SummaryType="Max" />
                            <dx:ASPxSummaryItem FieldName="discount" ShowInColumn="discount" ShowInGroupFooterColumn="discount" SummaryType="Min" />
                        </TotalSummary>
                        <Columns>
                            <dx:GridViewDataTextColumn FieldName="id" ReadOnly="True" VisibleIndex="0">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="company_name" VisibleIndex="1">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="country" VisibleIndex="2">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="city" VisibleIndex="3">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="unit_price" VisibleIndex="4">
                                <PropertiesTextEdit DisplayFormatString="c">
                                </PropertiesTextEdit>
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="quantity" VisibleIndex="5">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="discount" VisibleIndex="6">
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataDateColumn FieldName="总计" UnboundType="Decimal" VisibleIndex="7">
                                <PropertiesDateEdit DisplayFormatString="c">
                                </PropertiesDateEdit>
                            </dx:GridViewDataDateColumn>
                            <dx:GridViewDataTextColumn FieldName="折后" UnboundType="Decimal" VisibleIndex="8">
                                <PropertiesTextEdit DisplayFormatString="c">
                                </PropertiesTextEdit>
                            </dx:GridViewDataTextColumn>
                        </Columns>
                        <Settings ShowFooter ="true" />

                    </dx:ASPxGridView>