Silverlight DataGrid行详细信息的动态绑定--DataGrid.RowDetailsTemplate

为感谢烈火の炎的无私热心帮助下才能实现这个功能，特别整理出来给大家分享一下。

1、WCFService.svc

public class WCFService : IWCFClass //这个是引用新增的一个类文件IWCFClass.cs，分页在这个类里。

{

 

      //一级表

      [OperationContract]
        public List<PageBj> PageBjFilter(int? PageSize, int PageIndex, string filter)
        {
            PageBj data = new PageBj();
            List<PageBj> sources = data.CreatePageSources(PageSize, PageIndex, filter);
            return sources.ToList();
        }

        [OperationContract]
        public int PageBjCount(string filter)
        {
            string strWhere = "";
            if (filter != "")
            {
                strWhere = " 1=1 AND " + filter;
            }
            else
            {
                strWhere = " 1=1 ";
            }
            int Bjcount = int.Parse(MssqlHelper.ExecuteScalar("SELECT COUNT(1) FROM View_bj where " + strWhere + "").ToString());
            return Bjcount;
        }

 

        //二级表

        [OperationContract]
        public List<BjDetailInfo> GetBjDetailInfo(int bj_id)
        {
            List<BjDetailInfo> DetectionList = new List<BjDetailInfo>();
            string strsql = @"SELECT brand.brand_name, bj_detection.id, bj_detection.bz_name, bj_detection.brand_id, bj_detection.bj_id,bj_detection.brand_price, bj_detection.temp_id, bj_detection.shop_price FROM bj_detection LEFT OUTER JOIN brand ON bj_detection.brand_id = brand.id where bj_id=" + bj_id + " order by bj_detection.brand_id desc";
            DataTable dt = MssqlHelper.ExecuteDataTable(strsql);
            if (dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    DetectionList.Add(new BjDetailInfo()
                    {
                        brand_name = dr["brand_name"].ToString(),
                        bz_id = dr["id"].ToString(),
                        bz_name = dr["bz_name"].ToString(),
                        brand_id = dr["brand_id"].ToString(),
                        bj_id = dr["bj_id"].ToString(),
                        brand_price = dr["brand_price"].ToString(),
                        shop_price = dr["shop_price"].ToString(),
                        temp_id = dr["temp_id"].ToString()
                    });
                }
            }
            return DetectionList;
        }

 

 

    public class BjDetailInfo
    {
        public string brand_name { get; set; }
        public string bz_id { get; set; }
        public string bz_name { get; set; }
        public string brand_id { get; set; }
        public string bj_id { get; set; }
        public string brand_price { get; set; }
        public string temp_id { get; set; }
        public string shop_price { get; set; }
    }

}

 

2、IWCFClass.cs //新增的自定义类文件

public class IWCFClass
 {

       public class PageBj
        {
            public string Id { get; set; }
            public string bj_name { get; set; }
            public string bj_Sample { get; set; }
            public string cdate { get; set; }
            public string bj_remarks { get; set; }
            public string cId { get; set; }
            public string cName { get; set; }
            public List<BjDetailInfo> BjDetailInfo { get; set; } //二级表

            public List<PageBj> CreatePageSources(int? PageSize, int PageIndex, string filter)
            {
                List<PageBj> entitys = new List<PageBj>();
                string strWhere = filter;
                string strSort = "id desc";
                string strTable = "View_bj";
                DataSet ds = new DataSet();
                int Count = 0;
                int tempPageSize = 0;
                if (PageSize.HasValue)
                {
                    tempPageSize = PageSize.Value;
                }
                ds = MssqlHelper.GetList(tempPageSize, PageIndex, strTable, strWhere, strSort, out Count);
                DataTable dt = ds.Tables[0];
                if (dt.Rows.Count > 0)
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        entitys.Add(new PageBj()
                        {
                            Id = dr["Id"].ToString(),
                            bj_name = dr["bj_name"].ToString(),
                            bj_Sample = dr["bj_Sample"].ToString(),
                            cdate = dr["cdate"].ToString(),
                            bj_remarks = dr["bj_remarks"].ToString(),
                            cId = dr["cId"].ToString(),
                            cName = dr["cName"].ToString()
                        });
                    }
                }
                else
                {
                    entitys = null;
                }
                return entitys;
            }
        }

 

}

 

3、BjList.xaml

<sdk:DataGrid Margin="10,6,16,0"  Name="dataGrid1" AutoGenerateColumns="False" RowDetailsVisibilityChanged="dataGrid1_LoadingRowDetails"  RowDetailsVisibilityMode="VisibleWhenSelected" >

 <sdk:DataGrid.Columns>
                            <sdk:DataGridTextColumn Header="编号" IsReadOnly="True" Binding="{Binding Id,Mode=OneWay}"  />
                            <sdk:DataGridTextColumn Header="分类" IsReadOnly="True" Binding="{Binding cName,Mode=OneWay}"  />
                            <sdk:DataGridTextColumn Header="项目" IsReadOnly="True" Binding="{Binding bj_name,Mode=OneWay}"  />

</sdk:DataGrid.Columns>
                        <sdk:DataGrid.RowDetailsTemplate>
                            <DataTemplate>
                                <sdk:DataGrid Name="dataGridDetail1" AutoGenerateColumns="False"  ItemsSource="{Binding BjDetailInfo, Mode=OneWay}"  >
                                    <sdk:DataGrid.Columns>
                                        <sdk:DataGridTextColumn Width="100"
                                         Header="二级字段A"
                                         Binding="{Binding brand_name,Mode=OneWay}"/>
                                        <sdk:DataGridTextColumn Width="100"
                                         Header="二级字段B"
                                         Binding="{Binding bz_name,Mode=OneWay}"/>
                                        <sdk:DataGridTextColumn Width="100"
                                         Header="二级字段C"
                                         Binding="{Binding brand_price,Mode=OneWay}"/>
                                        <sdk:DataGridTextColumn Width="100"
                                         Header="二级字段D"
                                         Binding="{Binding shop_price,Mode=OneWay}"/>
                                    </sdk:DataGrid.Columns>
                                </sdk:DataGrid>
                            </DataTemplate>
                        </sdk:DataGrid.RowDetailsTemplate>
</sdk:DataGrid>
<sdk:DataPager Height="26" Name="dataPager1" PageSize="10" Width="200" PageIndexChanged="dataPager1_PageIndexChanged" HorizontalAlignment="Left"  Margin="10,10,0,0"/>

 

4、BjList.xaml.cs文件：

        IWCFClassPageBj fi = new IWCFClassPageBj();
        WCFServiceClient client = new WCFServiceClient();

       public BjList()
        {

           Filter(wherestr);

         }

 

        #region 分页事件
        private void dataPager1_PageIndexChanged(object sender, EventArgs e)
        {

            Filter(wherestr);
        }

        private void Filter(string wherestr)
        {

            client.PageBjCountCompleted += new EventHandler<PageBjCountCompletedEventArgs>(client_PageBjCountCompleted);
            client.PageBjCountAsync(wherestr);
        }

        void client_PageBjCountCompleted(object sender, PageBjCountCompletedEventArgs e)
        {
            if (e.Result < 1)
                return;
            SetPageSource(e.Result);

            var pageIndex = dataPager1.PageIndex + 1;
            client.PageBjFilterCompleted += new EventHandler<PageBjFilterCompletedEventArgs>(client_PageBjFilterCompleted);
            client.PageBjFilterAsync(dataPager1.PageSize, pageIndex, wherestr);
        }

        void client_PageBjFilterCompleted(object sender, PageBjFilterCompletedEventArgs e)
        {
            dataGrid1.ItemsSource = e.Result;
        }

        private void SetPageSource(int resultCount)
        {
            if (dataPager1.Source != null && (dataPager1.Source as PagedCollectionView).TotalItemCount == resultCount)
                return;
            List<int> source = new List<int>();
            for (int i = 0; i < resultCount; i++)
            {
                source.Add(i);
            }

            PagedCollectionView pagedCollection = new PagedCollectionView(source);
            dataPager1.Source = pagedCollection;
        }
        #endregion

 

        private void dataGrid1_LoadingRowDetails(object sender, DataGridRowDetailsEventArgs e)
        {
            fi = e.Row.DataContext as IWCFClassPageBj;
            client.GetBjDetailInfoCompleted += new EventHandler<GetBjDetailInfoCompletedEventArgs>(client_GetBjDetailInfoCompleted);
            client.GetBjDetailInfoAsync(int.Parse(fi.Id));
        }
        void client_GetBjDetailInfoCompleted(object sender, GetBjDetailInfoCompletedEventArgs e)
        {
            fi.BjDetailInfo = e.Result as ObservableCollection<BjDetailInfo>;
        }

 

服务端分页方法其实可以只读一次就可以的，只是我们这次讨论的是详细信息的动态列表绑定，就不说这个了。再次感谢烈火の炎的技术支持，向烈火の炎学习，希望能帮得上有需要的人。

转载于:https://www.cnblogs.com/charmfeel/archive/2012/05/21/2511682.html