Silverlight日记：动态生成DataGrid、行列装换、动态加载控件

本文主要针对使用DataGrid动态绑定数据对象，并实现行列转换效果。

一，前台绑定

<sdk:DataGrid x:Name="dataGrid2" Style="{StaticResource ResourceKey=safeDataGrid2}" />

using System;
using System.Collections;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Linq;
using System.Net;
using System.Reflection;
using System.Reflection.Emit;
using System.Text;
using System.Text.RegularExpressions;
using System.Threading;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Controls.Primitives;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Markup;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;
using System.Windows.Threading;
using Test.Util;

namespace Test
{
    public partial class MainPage : UserControl
    {
        public Md Model = null;
        private DispatcherTimer timer;
        int index = 0;
        /// <summary>
        /// 
        /// </summary>
        public ObservableCollection<Obj> objs = new ObservableCollection<Obj>();

        public MainPage()
        {
            InitializeComponent();
            init();
            timer = new DispatcherTimer();
            timer.Interval = new TimeSpan(0, 0, 8);
            timer.Tick += timer_Tick;
            timer.Start();
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void timer_Tick(object sender, EventArgs e)
        {
            var ramd = new Random();
            foreach (var tag in Model.Tags)
            {
                foreach (var para in Consts.Params)
                {
                    var rv = index % 2 == 0 ? ramd.Next(2, 10) : ramd.Next(1, 5);
                    var o = new Obj
                    {
                        IsAlarm = false,
                        Value = (0.5 + rv).ToString(),
                        State = index % 2 == 0 ? 1 : 0,
                        MeterId = tag.F_METER_ID,
                        MeterName = tag.F_METER_NAME,
                        ParaId = para.Id
                    };
                    if (para.Id == "10")
                    {
                        o.IsAlarm = false;
                        o.ParaId = string.Empty;
                        o.State = 0;
                        o.Value = string.Empty;
                    }
                    var temp = objs.FirstOrDefault(i => i.MeterName.Equals(o.MeterName) && i.ParaId == o.ParaId);
                    if (temp != null)
                    {
                        temp.IsAlarm = o.IsAlarm;
                        temp.State = o.State;
                        temp.Value = o.Value;
                    }
                    else
                        objs.Add(o);
                }
            }
            //CommHelper.GetSource(Model.Tags, objs, ref this.dataGrid2);
            CommHelper.BindData(Model.Tags, objs, ref this.dataGrid2);
            index++;
        }


        /// <summary>
        /// 
        /// </summary>
        void init()
        {
            Model = new Md();
            Model.Tags = new List<T_METER>();
            Model.Eles = new List<Param>();
            for (int i = 0; i < 1; i++)
            {
                var temp = new T_METER
                {
                    F_BUILD_ID = "440300B059",
                    F_METER_ID = string.Format("TAG_{0}", i),
                    F_METER_NAME = string.Format("CM-{0}", i)
                };
                if (i == 0)
                    temp.F_EQT_TYPE = "D";
                else if (i == 1)
                    temp.F_EQT_TYPE = "C";
                else if (i == 2)
                    temp.F_EQT_TYPE = "E";
                else
                    temp.F_EQT_TYPE = "A";
                Model.Tags.Add(temp);
            }
            this.dataGrid1.ItemsSource = Consts.Params;
            CommHelper.CreateDataGrid(Model.Tags, ref this.dataGrid2);
        }
    }

    /// <summary>
    /// 
    /// </summary>
    public class Md
    {
        /// <summary>
        /// 参数集合
        /// </summary>
        public List<Param> Eles { get; set; }
        /// <summary>
        /// 电表集合
        /// </summary>
        public List<T_METER> Tags { get; set; }
    }
    /// <summary>
    /// 
    /// </summary>
    public class T_METER
    {
        public string F_BUILD_ID { get; set; }
        public string F_METER_ID { get; set; }

        public string F_METER_NAME { get; set; }

        public string F_EQT_TYPE { get; set; }

        public string F_VALUE { get; set; }
    }

    /// <summary>
    /// 参数
    /// </summary>
    public class Param
    {
        public string Id { get; set; }

        public string Name { get; set; }
    }

    /// <summary>
    /// 绑定数据对象
    /// </summary>
    public class Obj
    {
        /// <summary>
        /// 对应参数编号
        /// </summary>
        public string ParaId { get; set; }

        public string MeterId { get; set; }
        /// <summary>
        /// 电表名称
        /// </summary>
        public string MeterName { get; set; }
        /// <summary>
        /// 开关状态0-关，1-开
        /// </summary>
        public int State { get; set; }
        /// <summary>
        /// OPC读取值
        /// </summary>
        public string Value { get; set; }
        /// <summary>
        /// 是否报警
        /// </summary>
        public bool IsAlarm { get; set; }

    }

}

　　

二，动态列对象

using System.Collections.Generic;

namespace Test.Util
{
    /* ==============================
     * Desc：DynamicColumn  
     * Author：hezp
     * Date：2014/8/14 15:49:17
     * ==============================*/
    public class DynamicColumn
    {
        /// <summary>
        /// 列名
        /// </summary>
        public string ColumnName { get; set; } 
        /// <summary>
        /// 列对应集合
        /// </summary>
        public List<string> Values { get; set; }
    }
}

三，DataGrid动态生成类

using System;
using System.Linq;
using System.Collections;
using System.Collections.Generic;
using System.Net;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Documents;
using System.Windows.Ink;
using System.Windows.Input;
using System.Windows.Markup;
using System.Windows.Media;
using System.Windows.Media.Animation;
using System.Windows.Shapes;
using System.Text.RegularExpressions;
using System.Collections.ObjectModel;

namespace Test.Util
{
    /* ==============================
     * Desc：CommHelper  
     * Author：hezp
     * Date：2014/8/14 15:58:26
     * ==============================*/
    public class CommHelper
    {
        /// <summary>
        /// 
        /// </summary>
        /// <param name="columnBindName"></param>
        /// <param name="columnHeaderName"></param>
        /// <param name="width"></param>
        /// <param name="index"></param>
        /// <returns></returns>
        private static DataGridTemplateColumn CreateDataGridTextColumn(string columnBindName, string columnHeaderName, T_METER tag)
        {
            DataGridTemplateColumn dgColumn = new DataGridTemplateColumn();
            dgColumn.Header = columnHeaderName;
            dgColumn.IsReadOnly = true;
            var w = 70;
            if (tag != null)
            {
                if (tag.F_EQT_TYPE.Equals("D"))
                {
                    dgColumn.HeaderStyle = ResourcesWrapper.GetStyle<Style>("safeByqStyle");
                    w = 120;
                }
                else if (tag.F_EQT_TYPE.Equals("B"))
                {
                    dgColumn.HeaderStyle = ResourcesWrapper.GetStyle<Style>("safeSingleDrStyle");
                    w = 90;
                }
                else if (tag.F_EQT_TYPE.Equals("C"))
                {
                    dgColumn.HeaderStyle = ResourcesWrapper.GetStyle<Style>("safeDoubleDrStyle");
                    w = 150;
                }
                else if (tag.F_EQT_TYPE.Equals("E"))
                {
                    dgColumn.HeaderStyle = ResourcesWrapper.GetStyle<Style>("safeHookStyle");
                    w = 98;
                }
                else
                    dgColumn.HeaderStyle = ResourcesWrapper.GetStyle<Style>("safeMeterStyle");
            }
            else
                dgColumn.HeaderStyle = ResourcesWrapper.GetStyle<Style>("safeMeterStyle");

            dgColumn.CellStyle = ResourcesWrapper.GetStyle<Style>("safeCellStyle");

            StringBuilder cellTemplate = new StringBuilder();
            cellTemplate.Append("<DataTemplate  ");
            cellTemplate.Append(" xmlns='http://schemas.microsoft.com/client/2007' ");
            cellTemplate.Append(" xmlns:x='http://schemas.microsoft.com/winfx/2006/xaml' ");
            cellTemplate.Append(" xmlns:c='clr-namespace:Test.Controls;assembly=Test.Controls' ");
            cellTemplate.Append(" xmlns:local = 'Test");
            cellTemplate.Append(";assembly=Test'>");
            cellTemplate.Append(string.Format("<c:CustomCell Width='{1}' Text='{{Binding {0}}}'/>", columnBindName, w));
            cellTemplate.Append("</DataTemplate>");
            dgColumn.CellTemplate = (DataTemplate)XamlReader.Load(cellTemplate.ToString());
            dgColumn.CellTemplate.LoadContent();

            return dgColumn;
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="SourceList"></param>
        /// <returns></returns>
        private static IEnumerable<IDictionary> GetEnumerable(List<Dictionary<string, string>> SourceList)
        {
            for (int i = 0; i < SourceList.Count; i++)
            {
                var dict = new Dictionary<string, string>();
                dict = SourceList[i];
                yield return dict;
            }
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="list"></param>
        /// <param name="objs"></param>
        /// <returns></returns>
        private static List<DynamicColumn> Grenartor(List<T_METER> list, ObservableCollection<Obj> objs)
        {
            var columns = new List<DynamicColumn>();
            if (null == list) return null;
            var ms = from p in list
                     group p by new { p.F_BUILD_ID, p.F_METER_ID, p.F_METER_NAME } into gg
                     select gg.Key;
            var ramd = new System.Random();
            foreach (var m in ms)
            {
                var column = new DynamicColumn
                {
                    ColumnName = string.Format("{0}____{1}", m.F_METER_NAME, 0)//格式：支路名称|开关状态值
                };
                if (objs != null)
                {
                    var obj = objs.FirstOrDefault(i => i.MeterName.Equals(m.F_METER_NAME));
                    if (obj != null)
                        column.ColumnName = string.Format("{0}____{1}", obj.MeterName, obj.State);
                }
                column.Values = new List<string>();
                var count = Consts.Params.Count;
                for (int i = 0; i < count; i++)
                {
                    var v = false;//是否显示按钮
                    if (i == count - 1)
                        v = true;
                    if (objs != null)
                    {
                        var temp = objs.FirstOrDefault(j => j.MeterName.Equals(m.F_METER_NAME) && !string.IsNullOrEmpty(j.ParaId) && j.ParaId.Equals(Consts.Params[i].Id));
                        if (temp != null)
                            column.Values.Add(string.Format("{0}____{1}____{2}____{3}____{4}____{5}____{6}", m.F_BUILD_ID, m.F_METER_ID, m.F_METER_NAME, temp.Value, v, temp.IsAlarm, Consts.Params[i].Id));
                        else
                            column.Values.Add(string.Format("{0}____{1}____{2}____{3}____{4}____{5}____{6}", m.F_BUILD_ID, m.F_METER_ID, m.F_METER_NAME, "-", v, false, Consts.Params[i].Id));//格式：建筑编号____支路编号____支路名称____数值____是否是按钮____是否报警  
                    }
                    else
                        column.Values.Add(string.Format("{0}____{1}____{2}____{3}____{4}____{5}____{6}", m.F_BUILD_ID, m.F_METER_ID, m.F_METER_NAME, "-", v, false, Consts.Params[i].Id));
                }
                columns.Add(column);
            }
            return columns;
        }
        /// <summary>
        /// 绑定数据
        /// </summary>
        /// <param name="tags"></param>
        /// <param name="objs"></param>
        /// <param name="datagrid"></param>
        public static void BindData(List<T_METER> tags, ObservableCollection<Obj> objs, ref DataGrid datagrid)
        {
            var list = Grenartor(tags, objs);
            var dataSources = new List<Dictionary<string, string>>();
            for (int j = 0; j < 10; j++)
            {
                var dict = new Dictionary<string, string>();//数据行（Key:列名，Value：列值）
                list.ForEach(item =>
                {
                    dict.Add(item.ColumnName.Replace(" ", "_").Replace("-", "_"), item.Values[j]);
                });
                dataSources.Add(dict);
            }
            foreach (var item in list)
            {
                var index = list.IndexOf(item);
                var arr = Regex.Split(item.ColumnName, "____", RegexOptions.IgnoreCase);
                var tag = tags.FirstOrDefault(i => i.F_METER_NAME.ToUpper().Equals(arr[0].ToUpper()));
                var column = CreateDataGridTextColumn(item.ColumnName.Replace(" ", "_").Replace("-", "_"), item.ColumnName, tag);
                var cl = datagrid.Columns.FirstOrDefault(i => i.Header.ToString().StartsWith(tag.F_METER_NAME));
                if (cl != null)
                    cl = column;
                else
                    datagrid.Columns.Add(column);
            }
            datagrid.ItemsSource = GetEnumerable(dataSources).ToDataSource();
        }

        public static void GetSource(List<T_METER> tags, ObservableCollection<Obj> objs, ref DataGrid datagrid)
        {
            var list = Grenartor(tags, objs);
            var dataSources = new List<Dictionary<string, string>>();
            for (int j = 0; j < 10; j++)
            {
                var dict = new Dictionary<string, string>();//数据行（Key:列名，Value：列值）
                list.ForEach(item =>
                {
                    dict.Add(item.ColumnName.Replace(" ", "_").Replace("-", "_"), item.Values[j]);
                });
                dataSources.Add(dict);
            }            
            datagrid.ItemsSource = GetEnumerable(dataSources).ToDataSource();
        }

        public static void CreateDataGrid(List<T_METER> tags, ref DataGrid datagrid)
        {
            var list = Grenartor(tags, null);
            var dataSources = new List<Dictionary<string, string>>();
            for (int j = 0; j < 10; j++)
            {
                var dict = new Dictionary<string, string>();//数据行（Key:列名，Value：列值）
                list.ForEach(item =>
                {
                    dict.Add(item.ColumnName.Replace(" ", "_").Replace("-", "_"), item.Values[j]);
                });
                dataSources.Add(dict);
            }
            foreach (var item in list)
            {
                var index = list.IndexOf(item);
                var arr = Regex.Split(item.ColumnName, "____", RegexOptions.IgnoreCase);
                var tag = tags.FirstOrDefault(i => i.F_METER_ID.ToUpper().Equals(arr[0].ToUpper()));
                var column = CreateDataGridTextColumn(item.ColumnName.Replace(" ", "_").Replace("-", "_"), item.ColumnName, tag);
                var cl = datagrid.Columns.FirstOrDefault(i => i.Header.ToString().StartsWith(tag.F_METER_NAME));
                if (cl != null)
                    cl = column;
                else
                    datagrid.Columns.Add(column);
            }
            datagrid.ItemsSource = GetEnumerable(dataSources).ToDataSource();
        }
    }
}

四，数据源构造（实现行列转换）类

using System;
using System.Collections;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Reflection;
using System.Reflection.Emit;

namespace Test.Util
{
    /* ==============================
     * Desc：DataSourceCreator  
     * Author：hezp
     * Date：2014/8/14 15:51:04
     * ==============================*/
    public static class DataSourceCreator
    {
        public static ObservableCollection<object> ToDataSource(this IEnumerable<IDictionary> list)
        {
            IDictionary firstDict = null;
            bool hasData = false;
            foreach (IDictionary currentDict in list)
            {
                hasData = true;
                firstDict = currentDict;
                break;
            }
            if (!hasData)
            {
                return new ObservableCollection<object> { };
            }
            if (firstDict == null)
            {
                throw new ArgumentException("IDictionary entry cannot be null");
            }
            Type objectType = null;
            TypeBuilder tb = GetTypeBuilder(list.GetHashCode());
            ConstructorBuilder constructor =
                        tb.DefineDefaultConstructor(
                                    MethodAttributes.Public |
                                    MethodAttributes.SpecialName |
                                    MethodAttributes.RTSpecialName);
            foreach (DictionaryEntry pair in firstDict)
            {

                CreateProperty(tb,
                                Convert.ToString(pair.Key),
                                pair.Value == null ?
                                            typeof(object) :
                                            pair.Value.GetType());

            }
            objectType = tb.CreateType();
            return GenerateArray(objectType, list, firstDict);
        }
        private static ObservableCollection<object> GenerateArray(Type objectType, IEnumerable<IDictionary> list, IDictionary firstDict)
        {
            var itemsSource = new ObservableCollection<object>();
            foreach (var currentDict in list)
            {
                object row = Activator.CreateInstance(objectType);
                foreach (DictionaryEntry pair in firstDict)
                {
                    if (currentDict.Contains(pair.Key))
                    {
                        PropertyInfo property =
                            objectType.GetProperty(Convert.ToString(pair.Key));
                        property.SetValue(
                            row,
                            Convert.ChangeType(
                                    currentDict[pair.Key],
                                    property.PropertyType,
                                    null),
                            null);
                    }
                }
                itemsSource.Add(row);
            }
            return itemsSource;
        }
        private static TypeBuilder GetTypeBuilder(int code)
        {
            AssemblyName an = new AssemblyName("TempAssembly" + code);
            AssemblyBuilder assemblyBuilder =
                AppDomain.CurrentDomain.DefineDynamicAssembly(
                    an, AssemblyBuilderAccess.Run);
            ModuleBuilder moduleBuilder = assemblyBuilder.DefineDynamicModule("MainModule");
            TypeBuilder tb = moduleBuilder.DefineType("TempType" + code
                                , TypeAttributes.Public |
                                TypeAttributes.Class |
                                TypeAttributes.AutoClass |
                                TypeAttributes.AnsiClass |
                                TypeAttributes.BeforeFieldInit |
                                TypeAttributes.AutoLayout
                                , typeof(object));
            return tb;
        }
        private static void CreateProperty(TypeBuilder tb, string propertyName, Type propertyType)
        {
            FieldBuilder fieldBuilder = tb.DefineField("_" + propertyName,
                                                        propertyType,
                                                        FieldAttributes.Private);

            PropertyBuilder propertyBuilder =
                tb.DefineProperty(
                    propertyName, PropertyAttributes.HasDefault, propertyType, null);
            MethodBuilder getPropMthdBldr =
                tb.DefineMethod("get_" + propertyName,
                    MethodAttributes.Public |
                    MethodAttributes.SpecialName |
                    MethodAttributes.HideBySig,
                    propertyType, Type.EmptyTypes);
            ILGenerator getIL = getPropMthdBldr.GetILGenerator();
            getIL.Emit(OpCodes.Ldarg_0);
            getIL.Emit(OpCodes.Ldfld, fieldBuilder);
            getIL.Emit(OpCodes.Ret);
            MethodBuilder setPropMthdBldr =
                tb.DefineMethod("set_" + propertyName,
                  MethodAttributes.Public |
                  MethodAttributes.SpecialName |
                  MethodAttributes.HideBySig,
                  null, new Type[] { propertyType });
            ILGenerator setIL = setPropMthdBldr.GetILGenerator();
            setIL.Emit(OpCodes.Ldarg_0);
            setIL.Emit(OpCodes.Ldarg_1);
            setIL.Emit(OpCodes.Stfld, fieldBuilder);
            setIL.Emit(OpCodes.Ret);
            propertyBuilder.SetGetMethod(getPropMthdBldr);
            propertyBuilder.SetSetMethod(setPropMthdBldr);
        }
    }
}

五，显示效果