/// <summary>
        /// 把DataTable填充到数据容器中,方便填充数据到DataWindow
        /// </summary>
        /// <param name="dataTable">数据容器</param>
        /// <param name="dt">DataTable</param>
        /// <Author>jianghaoqun 2007-06-07</Author>
        public static void Fill(LiteDataTable dataTable, DataTable dt)
        {
            int columnsCount = dataTable.Columns.Count;

            if (columnsCount == 0)
            {
                columnsCount = dt.Columns.Count;
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    dataTable.Columns.Add(new LiteDataColumn(dt.Columns[i].ColumnName, dt.Columns[i].DataType));
                }
            }

            foreach (DataRow dr in dt.Rows)
            {
                var row = dataTable.NewRow();
                for (int i = 0; i < columnsCount; i++)
                {
                    var value = dr[i];
                    if (value != DBNull.Value)
                    {
                        row[i] = value;
                    }
                }
                dataTable.Rows.Add(row);
            }
        }
        /// <summary>
        /// 根据SQL Command返回的IDataReader填充数据容器
        /// <para>
        /// 对于DBNull的值,填充null
        /// </para>
        /// </summary>
        /// <param name="dataTable">数据容器</param>
        /// <param name="reader">SQL语句返回的</param>
        public static void Fill(LiteDataTable dataTable, IDataReader reader)
        {
            if (dataTable.Columns.Count == 0)
            {
                AddColumns(dataTable, reader);
            }

            int columnsCount = dataTable.Columns.Count;

            while (reader.Read())
            {
                var row = dataTable.NewRow();
                for (int i = 0; i < columnsCount; i++)
                {
                    var value = reader[i];
                    if (value != DBNull.Value)
                    {
                        row[i] = value;
                    }
                }
                dataTable.Rows.Add(row);
            }
        }
        /// <summary>
        /// 根据SQL Command返回的IDataReader填充数据容器
        /// <para>
        /// 对于DBNull的值,填充null
        /// </para>
        /// </summary>
        /// <param name="dataTable">数据容器</param>
        /// <param name="reader">SQL语句返回的</param>
        public static void Fill(LiteDataTable dataTable, IDataReader reader)
        {
            if (dataTable.Columns.Count == 0)
            {
                AddColumns(dataTable, reader);
            }

            int columnsCount = dataTable.Columns.Count;

            while (reader.Read())
            {
                var row = dataTable.NewRow();
                for (int i = 0; i < columnsCount; i++)
                {
                    var value = reader[i];
                    if (value != DBNull.Value)
                    {
                        row[i] = value;
                    }
                }
                dataTable.Rows.Add(row);
            }
        }
        /// <summary>
        /// 把DataTable填充到数据容器中,方便填充数据到DataWindow
        /// </summary>
        /// <param name="dataTable">数据容器</param>
        /// <param name="dt">DataTable</param>
        /// <Author>jianghaoqun 2007-06-07</Author>
        public static void Fill(LiteDataTable dataTable, DataTable dt)
        {
            int columnsCount = dataTable.Columns.Count;
            if (columnsCount == 0)
            {
                columnsCount = dt.Columns.Count;
                for (int i = 0; i < dt.Columns.Count; i++)
                {
                    dataTable.Columns.Add(new LiteDataColumn(dt.Columns[i].ColumnName, dt.Columns[i].DataType));
                }
            }

            foreach (DataRow dr in dt.Rows)
            {
                var row = dataTable.NewRow();
                for (int i = 0; i < columnsCount; i++)
                {
                    var value = dr[i];
                    if (value != DBNull.Value)
                    {
                        row[i] = value;
                    }
                }
                dataTable.Rows.Add(row);
            }
        }