对象列表转换为DataTable或DataTable转换为对象列表.

/**********************************************************************************/
//  说明: 数据转换工具.
//  注意: 对象列表转换为DataTable或DataTable转换为对象列表.
//        字段参照由对象的PropertyName决定.
//        数据模型类的属性名必需与字段名一致, 包括大小写一致.
/**********************************************************************************/

using System;
using System.Reflection;
using System.Collections;
using System.Data;
using System.Collections.Generic;
using System.Text;
using System.ComponentModel;
using System.Xml;
using System.Web.UI;

namespace vjsdn.converter
{
    public class CDataConvert
    {

        /// <summary>
        /// 根据类创建表结构
        /// </summary>
        /// <param name="t"></param>
        /// <returns></returns>
        public static DataTable CreateTable(Type t)
        {
            return BuiltTable(t.GetProperties());
        }

        /// <summary>
        /// 根据对象的属性创建数据表
        /// </summary>
        private static DataTable BuiltTable(PropertyInfo[] pinfo)
        {
            try
            {
                if (pinfo == null) return null;
                DataTable table = new DataTable();
                foreach (PropertyInfo info in pinfo)
                {
                    Type type = info.PropertyType;
                    if (info.PropertyType.IsGenericType)
                        type = info.PropertyType.GetGenericArguments()[0];
                    DataColumn column = new DataColumn(info.Name, type);
                    column.AllowDBNull = true;
                    table.Columns.Add(column);
                }
                return table;
            }
            catch { return null; }
        }

        /// <summary>
        /// Object to Object. 将一个对象转换为指定类型的对象.
        /// 注意: destination内的Property必需在source内存在.
        /// </summary>
        public static object CopyProperties(object source, Type destination)
        {
            try
            {
                if (source == null) return null;
                object destObj = destination.Assembly.CreateInstance(destination.FullName);
                PropertyInfo[] propsDest = destObj.GetType().GetProperties();
                foreach (PropertyInfo infoDest in propsDest)
                {
                    object value = GetValueOfObject(source, infoDest.Name);
                    if (CanShallowCopyProperty(value)) SetPropertyValue(destObj, infoDest, value);
                }
                return destObj;
            }
            catch { return null; }
        }

        /// <summary>
        /// 指定参数是否可用于浅拷贝
        /// </summary>
        private static bool CanShallowCopyProperty(object propValue)
        {
            if (propValue == null) return true;
            if (propValue.GetType().IsValueType || propValue is string) return true;
            return false;
        }

        /// <summary>
        /// 复制对象属性.
        /// </summary>
        public static void CopyProperties(object source, object destObj)
        {
            try
            {
                if (source == null || destObj == null) return;
                PropertyInfo[] propsDest = destObj.GetType().GetProperties();
                foreach (PropertyInfo infoDest in propsDest)
                {
                    object value = GetValueOfObject(source, infoDest.Name);
                    if (CanShallowCopyProperty(value)) SetPropertyValue(destObj, infoDest, value);
                }
            }
            catch { }
        }

        /// <summary>
        /// 复制对象. 浅拷贝.
        /// </summary>
        public static object CloneObject(object source)
        {
            try
            {
                if (source == null) return null;
                Type objType = source.GetType();
                object destObj = objType.Assembly.CreateInstance(objType.FullName);
                PropertyInfo[] propsSource = objType.GetProperties();
                foreach (PropertyInfo infoSource in propsSource)
                {
                    object value = GetValueOfObject(source, infoSource.Name);
                    if (CanShallowCopyProperty(value)) SetPropertyValue(destObj, infoSource, value);
                }
                return destObj;
            }
            catch { return null; }
        }

        /// <summary>
        /// 复制一个对象数组.
        /// </summary>
        public static ArrayList CloneObjects(IList source)
        {
            if (source == null) return null;
            ArrayList ret = new ArrayList();
            foreach (object o in source) ret.Add(CloneObject(o));
            return ret;
        }

        /// <summary>
        /// 获取对象指定属性的值
        /// </summary>
        public static object GetValueOfObject(object obj, string property)
        {
            try
            {
                if (obj == null) return null;
                Type type = obj.GetType();
                PropertyInfo[] pinfo = type.GetProperties();
                foreach (PropertyInfo info in pinfo)
                {
                    if (info.Name.ToUpper() == property.ToUpper())
                        return info.GetValue(obj, null);
                }
                return null;
            }
            catch { return null; }
        }

        /// <summary>
        /// 纵对象数据组取出某一个对象. 返回对象指定属性名称(returnPropName)的值
        /// </summary>
        public static object GetObjectValueByKey(IList objects, string keyPropName, object keyValue, string returnPropName)
        {
            object o = GetObjectByKey(objects, keyPropName, keyValue);
            if (o != null)
                return GetValueOfObject(o, returnPropName);
            else
                return null;
        }

        /// <summary>
        /// 纵对象数据组取出某一个对象. 参数指定关键字段名称(keyPropName)及值(keyValue).
        /// </summary>
        public static object GetObjectByKey(IList objects, string keyPropName, object keyValue)
        {
            foreach (object o in objects)
            {
                object value = GetValueOfObject(o, keyPropName);
                if (value == null) continue;
                if (value.ToString().ToLower() == keyValue.ToString().ToLower())
                {
                    return o;
                }
            }
            return null;
        }

        /// <summary>
        /// 查找对象包含指定属性.
        /// </summary>
        public static bool FindProperty(object obj, string property)
        {
            try
            {
                if (obj == null) return false;
                Type type = obj.GetType();
                PropertyInfo[] pinfo = type.GetProperties();
                foreach (PropertyInfo info in pinfo)
                {
                    if (info.Name.ToUpper() == property.ToUpper())
                        return true;
                }
                return false;
            }
            catch { return false; }
        }

        public static void SetValueofDataRow(DataRow dr, string field, object value)
        {
            try
            {
                if (dr == null) return;
                dr[field] = value;

            }
            catch
            {

            }
        }

        /// <summary>
        /// 设置对象某个属性的值
        /// </summary>
        public static void SetValueOfObject(object obj, string property, object value)
        {
            try
            {
                if (obj == null) return;
                Type type = obj.GetType();
                PropertyInfo[] pinfo = type.GetProperties();
                foreach (PropertyInfo info in pinfo)
                {
                    if (info.Name.ToUpper() == property.ToUpper())
                    {
                        SetPropertyValue(obj, info, value);
                        break;
                    }
                }
            }
            catch { }
        }

        public static void SetPropertyValue(object instance, PropertyInfo prop, object value)
        {
            try
            {
                if (prop == null) return;
                if (prop.PropertyType.ToString() == "System.String")
                { }
                else if (prop.PropertyType.ToString() == "System.Decimal")
                    value = Decimal.Parse(value.ToString());
                else if (prop.PropertyType.ToString() == "System.Int32")
                    value = int.Parse(value.ToString());
                else if (prop.PropertyType.ToString() == "System.Single")
                    value = Single.Parse(value.ToString());
                else if (prop.PropertyType.ToString() == "System.DateTime")
                    value = DateTime.Parse(value.ToString());
                prop.SetValue(instance, value, null);
            }
            catch { }
        }

        public static IList CSharpDataTypes()
        {
            ArrayList list = new ArrayList();
            list.Add(typeof(System.DateTime));
            list.Add(typeof(System.Byte));
            list.Add(typeof(System.SByte));
            list.Add(typeof(System.Int16));
            list.Add(typeof(System.Int32));
            list.Add(typeof(System.Int64));
            list.Add(typeof(System.IntPtr));
            list.Add(typeof(System.UInt16));
            list.Add(typeof(System.UInt32));
            list.Add(typeof(System.UInt64));
            list.Add(typeof(System.UIntPtr));
            list.Add(typeof(System.Single));
            list.Add(typeof(System.Double));
            list.Add(typeof(System.Decimal));
            list.Add(typeof(System.Boolean));
            list.Add(typeof(System.Char));
            list.Add(typeof(System.String));
            return list;
        }

        /// <summary>
        /// 根据IList对象创建数据表
        /// </summary>
        public static DataTable IListToDataTable(IList list)
        {
            try
            {
                if (list == null) return null;
                if (list.Count <= 0) return null;
                Type type = list[0].GetType();
                PropertyInfo[] pinfo = type.GetProperties();

                DataTable table = BuiltTable(pinfo);//创建表
                DataRow row = null;
                foreach (object o in list)
                {
                    row = table.NewRow();
                    foreach (PropertyInfo info in pinfo)
                    {
                        object v = info.GetValue(o, null);
                        if (!ColumnExists(table, info.Name)) continue;
                        if (null == v)
                            row[info.Name] = DBNull.Value;
                        else
                            row[info.Name] = v;
                    }
                    table.Rows.Add(row);
                }
                return table;
            }
            catch { return null; }
        }

        public static bool ColumnExists(DataTable dt, string columnName)
        {
            if (dt == null) return false;
            foreach (DataColumn col in dt.Columns)
            {
                if (col.ColumnName.ToLower() == columnName.ToLower())
                    return true;
            }
            return false;
        }

        /// <summary>
        /// 数据表转换为IList对象,Type参数:对象类型
        /// </summary>
        public static IList DataTableToIList(DataTable table, Type type)
        {
            try
            {
                if (table == null) return null;
                IList list = new object[table.Rows.Count];
                object o = null;
                PropertyInfo[] pinfo = type.GetProperties();
                int idx = 0;
                foreach (DataRow row in table.Rows)
                {
                    o = type.Assembly.CreateInstance(type.FullName);
                    foreach (PropertyInfo info in pinfo)
                    {
                        SetPropertyValue(o, info, GetFieldValue(row, info.Name));
                    }
                    list[idx] = o;
                    idx += 1;
                }
                return list;
            }
            catch { return null; }
        }

        /// <summary>
        /// 根据对象的属性取字段的值
        /// </summary>
        private static object GetFieldValue(DataRow row, string propertyName)
        {
            if (row == null) return null;
            if (row.Table.Columns.IndexOf(propertyName) >= 0)
            {
                object value = row[propertyName];
                if (value != null && value is DateTime)
                {
                    if ((DateTime)value <= DateTime.MinValue.AddDays(1))
                        value = null;
                }
                return value;
            }
            return null;
        }

        public static DataRow UpdateDataRowFromObject(DataRow row, object o)
        {
            PropertyInfo[] pinfo = o.GetType().GetProperties();
            foreach (PropertyInfo info in pinfo)
            {
                if (row.Table.Columns.IndexOf(info.Name) >= 0)
                    row[info.Name] = info.GetValue(o, null);
            }
            return row;
        }

        public static DataRow AddDataRowFromObject(DataTable dt, object o)
        {
            DataRow row = dt.NewRow();
            PropertyInfo[] pinfo = o.GetType().GetProperties();
            foreach (PropertyInfo info in pinfo)
            {
                if (dt.Columns.IndexOf(info.Name) >= 0)
                    row[info.Name] = info.GetValue(o, null);
            }
            dt.Rows.Add(row);
            return row;
        }

        public static void SetTwoRowValues(DataRow rowFrom, DataRow rowTo)
        {
            for (int i = 0; i < rowFrom.Table.Columns.Count; i++)
            {
                rowTo[i] = rowFrom[i];
            }
        }

        /// <summary>
        /// 从源行中对相同字段名的列付值
        /// </summary>
        /// <param name="drSouce"></param>
        /// <param name="drTo"></param>
        public static void SetTwoRowSameColValue(DataRow drSource, DataRow drTo)
        {
            for (int i = 0; i < drSource.Table.Columns.Count; i++)
            {
                string fieldname = drSource.Table.Columns[i].ColumnName;
                DataColumn col = drTo.Table.Columns[fieldname];
                if (col != null)
                {
                    drTo[fieldname] = drSource[fieldname];
                }
            }

        }

        /// <summary>
        /// 数据行(DataRow)转换为对象,对象的Type由type参数决定.
        /// </summary>
        public static object DataRowToObject(DataRow row, Type type)
        {
            if (null == row) return null;
            try
            {
                object o = type.Assembly.CreateInstance(type.FullName);
                PropertyInfo[] pinfo = type.GetProperties();
                foreach (PropertyInfo info in pinfo)
                {
                    //字段名称与对象属性相符才赋值
                    if (row.Table.Columns.IndexOf(info.Name) >= 0)
                    {
                        object v = GetFieldValue(row, info.Name);
                        SetPropertyValue(o, info, v);
                    }
                }
                return o;
            }
            catch { return null; }
        }

        /// <summary>
        /// ArrayList转换为对象数组.
        /// </summary>
        public static object[] ToObjects(IList source)
        {
            if (null == source) return null;
            object[] ret = new object[source.Count];
            for (int i = 0; i < source.Count; i++) ret[i] = source[i];
            return ret;
        }

        /// <summary>
        /// 对象数组转换为ArrayList.
        /// </summary>
        public static ArrayList ToArrayList(IList list)
        {
            if (list == null) return null;
            ArrayList arrlist = new ArrayList();
            foreach (object o in list) arrlist.Add(o);
            return arrlist;
        }

        /// <summary>
        /// 对象数组转换为ArrayList.
        /// </summary>
        public static ArrayList ToArrayList(object[] source)
        {
            if (null != source)
                return new ArrayList((ICollection)source);
            else //如果来源数据为null,返回一个空的ArrayList.
                return new ArrayList();
        }

        /// <summary>
        /// 把字符串以逗号分格，转换成数据库格式in('a','b') 
        /// </summary>
        /// <param name="input"></param>
        /// <returns></returns>
        public static string ToSQLInDataFormat(string input)
        {
            string HQL = string.Empty;
            if (input == string.Empty)
                return HQL;

            string[] sArray = input.Split(',');
            foreach (string str in sArray)
            {
                if (str.Length == 0) continue;
                HQL += "'" + str + "',";
            }
            if (HQL.Substring(HQL.Length - 1, 1) == ",")
                HQL = HQL.Substring(0, HQL.Length - 1);
            return HQL;

        }

        /// <summary>
        /// 把字符串以逗号分格，转换成数据库格式''a'',''b'' 
        /// </summary>
        public static string ToSQLInDataFormatTwo(string input)
        {
            string HQL = string.Empty;
            if (input == string.Empty)
                return HQL;

            string[] sArray = input.Split(',');
            foreach (string str in sArray)
            {
                if (str.Length == 0) continue;
                HQL += "''" + str + "'',";
            }
            if (HQL.Substring(HQL.Length - 1, 1) == ",")
                HQL = HQL.Substring(0, HQL.Length - 1);
            return HQL;
        }


        public static string ToSQLInDataFormat(string[] input)
        {
            string HQL = string.Empty;
            if (input.Length == 0)
                return HQL;

            foreach (string str in input)
            {
                HQL += "'" + str + "',";
            }
            if (HQL.Substring(HQL.Length - 1, 1) == ",")
                HQL = HQL.Substring(0, HQL.Length - 1);
            return HQL;

        }

        /// <summary>
        /// 从table转成dataset
        /// </summary>
        /// <param name="dt"></param>
        /// <returns></returns>
        public static DataSet TableToDataSet(DataTable dt)
        {
            DataSet ds = new DataSet();
            ds.Tables.Add(dt);
            return ds;
        }


        public static DataSet TableToDataSet(DataTable[] dtArr)
        {
            DataSet ds = new DataSet();
            for (int i = 0; i < dtArr.Length; i++)
            {
                ds.Tables.Add(dtArr[i]);
            }
            return ds;
        }

        /// <summary>
        /// 修改对表的某列的值
        /// </summary>
        /// <param name="dt"></param>
        /// <param name="value"></param>
        public static bool UpdateTableCol(DataTable dt, string fieldName, object value)
        {
            try
            {
                if (dt.Columns.IndexOf(fieldName) < 0)
                    throw new Exception("表没有" + fieldName + "列！");

                foreach (DataRow dr in dt.Rows)
                {
                    dr[fieldName] = value;
                }

                return true;
            }
            catch
            {
                return false;
            }


        }

        /// <summary>
        /// 以逗号分格字符串，返回数组
        /// 如果第一个和最后一个字符为, 去掉
        /// </summary>
        /// <param name="str"></param>
        /// <returns></returns>
        public static string[] ToStringSplit(string str)
        {
            if (str.Length > 0)
            {
                if (str[0] == ',')
                    str = str.Substring(1, str.Length - 1);
                if (str[str.Length - 1] == ',')
                    str = str.Substring(0, str.Length - 1);
            }
            string[] sArray = str.Split(',');
            return sArray;
        }


        /// <summary>
        /// 把一个行的数据新增一个表中
        /// </summary>
        /// <param name="dt"></param>
        /// <param name="dr"></param>
        /// <returns></returns>
        public static DataTable AddTableRowByRow(DataTable dt, DataRow dr)
        {

            bool b = false;
            DataRow drNew = dt.NewRow();
            for (int i = 0; i < dr.Table.Columns.Count; i++)
            {
                string colname = dr.Table.Columns[i].ColumnName;
                if (dt.Columns.IndexOf(colname) >= 0)
                {
                    drNew[colname] = dr[colname];
                    b = true;
                }
            }

            if (b)
                dt.Rows.Add(drNew);
            return dt;
        }

    }

    /// <summary>
    /// 对字符或字符串的处理
    /// </summary>
    public class DOString
    {
        /// <summary>
        /// 把字符转成大写并去两边空格
        /// </summary>
        public static string ToTrimAndUpper(string str)
        {
            return str.Trim().ToUpper();
        }

        public static string ToTrimAndUpper(object o)
        {
            return o.ToString().Trim().ToUpper();
        }

        public static string ToTrimAndBigToSmall(object o)
        {
            return BigToSmall(o.ToString().Trim(), 1);
        }

        /// <summary>
        /// 返回一个半角 去左右空格 大写的字符串
        /// </summary>
        public static string ToTUBS(object o)
        {
            return BigToSmall(o.ToString().Trim().ToUpper(), 1);
        }

        /// <summary>
        /// 判断字符是否是数字。是返回true 
        /// </summary>
        /// <param name="c"></param>
        /// <returns></returns>
        public static bool NuNumber(char c)
        {
            if ((int)c >= 48 && (int)c <= 57)
                return true;
            else
                return false;

        }

        /// <summary>
        /// 去除千分号
        /// </summary>
        public static object OffkiloSign(object obj)
        {
            if (obj == null)
                return obj;
            string s = obj.ToString();
            return s.Replace(",", string.Empty);
        }


        /// <summary>
        /// 全角半角间转换 direction =-1 (半角转全角)
        /// </summary>

        public static string BigToSmall(string content, int direction)
        {
            string strBig, to_strBig;
            strBig = "ＡＢＣＤＥＦＧＨＩＪＫＬＭＮＯＰＱＲＳＴＵＶＷＸＹＺ０１２３４５６７８９　＇﹃﹄『』＄／ａｂｃｄｅｆｇｈｉｊｋｌｍｎｏｐｑｒｓｔｕｖｗｘｙｚ．＊";
            to_strBig = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789 '“”“”$/abcdefghijklmnopqrstuvwxyz.*";
            int i;
            for (i = 0; i < strBig.Length; i++)
            {
                if (direction != -1)
                {
                    content = content.Replace(strBig[i], to_strBig[i]);
                }
                else
                {
                    content = content.Replace(to_strBig[i], strBig[i]);
                }
            }
            return content;
        }

        /// <summary>
        /// 对比两个字符串的ASCII值大小，要是X1>X2,将X1,X2交换        
        /// </summary>
        public static void CompareStringASCII(ref string x1, ref string x2)
        {
            if (string.IsNullOrEmpty(x1) || string.IsNullOrEmpty(x2))
                return;
            string y1 = x1.ToUpper();
            string y2 = x2.ToUpper();
            int iLength = y1.Length;
            if (y2.Length < iLength)
                iLength = y2.Length;
            for (int i = 0; i < iLength; i++)
            {
                int iASC1 = (int)y1[i];
                int iASC2 = (int)y2[i];
                if (iASC1 > iASC2)
                {
                    string tmp = x1;
                    x1 = x2;
                    x2 = tmp;
                    break;
                }

                if (iASC1 < iASC2)
                    break;

            }
        }

        /// <summary>
        /// 查找出text中含有spilt字符串从第几个字符结束的位置数组
        /// </summary>
        /// <param name="text">"12345678901234567890"</param>
        /// <param name="spilt">"12"</param>
        /// <returns>2，13</returns>
        public static int[] DoStringIndexArray(string text, string spilt)
        {
            int[] ret = null;
            try
            {
                int iStart = 0;
                int iEnd = text.Length - 1;
                int spiltLength = spilt.Length;
                ArrayList list = new ArrayList();
                while (iStart <= iEnd)
                {
                    int index = text.IndexOf(spilt, iStart);
                    iStart = index + spiltLength;
                    if (iStart <= iEnd)
                    {
                        list.Add(iStart);
                    }
                }
                ret = new int[list.Count];
                for (int i = 0; i < ret.Length; i++)
                {
                    ret[i] = Convert.ToInt32(list[i]);
                }
            }
            catch
            {
                ret = null;
            }
            return ret;
        }


    }

}