DataTable与Object互相转换及相关函数转换大全(DataConvert类)
作者:C/S框架网  发布日期:2011/07/16 00:34:25
DataTable与Object互相转换及相关函数转换大全(DataConvert类)

public class DataConvert
{
   /// <summary>
   /// 根据类创建表结构
   /// </summary>
   public static DataTable CreateTable(Type t)
   /// <summary>
   /// 根据对象的属性创建数据表
   /// </summary>
   private static DataTable BuiltTable(PropertyInfo[] pinfo)
   /// <summary>
   /// Object to Object. 将一个对象转换为指定类型的对象.
   /// 注意: destination内的Property必需在source内存在.
   /// </summary>
   public static object CopyProperties(object source, Type destination)
   /// <summary>
   /// 指定参数是否可用于浅拷贝
   /// </summary>
   private static bool CanShallowCopyProperty(object propValue)
   /// <summary>
   /// 复制对象属性.
   /// </summary>
   public static void CopyProperties(object source, object destObj)
   /// <summary>
   /// 复制对象. 浅拷贝.
   /// </summary>
   public static object CloneObject(object source)
   /// <summary>
   /// 复制一个对象数组.
   /// </summary>
   public static ArrayList CloneObjects(IList source)
   /// <summary>
   /// 获取对象指定属性的值
   /// </summary>
   public static object GetValueOfObject(object obj, string property)
   /// <summary>
   /// 纵对象数据组取出某一个对象. 返回对象指定属性名称(returnPropName)的值
   /// </summary>
   public static object GetObjectValueByKey(IList objects, string keyPropName, object keyValue, string returnPropName)
   /// <summary>
   /// 纵对象数据组取出某一个对象. 参数指定关键字段名称(keyPropName)及值(keyValue).
   /// </summary>
   public static object GetObjectByKey(IList objects, string keyPropName, object keyValue)
   /// <summary>
   /// 查找对象包含指定属性.
   /// </summary>
   public static bool FindProperty(object obj, string property)
   public static void SetValueofDataRow(DataRow dr, string field, object value)
   /// <summary>
   /// 设置对象某个属性的值
   /// </summary>
   public static void SetValueOfObject(object obj, string property, object value)
   public static void SetPropertyValue(object instance, PropertyInfo prop, object value)
   /// <summary>
   /// 根据IList对象创建数据表
   /// </summary>
   public static DataTable IListToDataTable(IList list)
   public static bool ColumnExists(DataTable dt, string columnName)
   /// <summary>
   /// 根据对象的属性取字段的值
   /// </summary>
   private static object GetFieldValue(DataRow row, string propertyName)
   public static DataRow UpdateDataRowFromObject(DataRow row, object o)
   public static DataRow AddDataRowFromObject(DataTable dt, object o)
   public static void SetDataRowValue(DataRow row, string fieldName, object value)
   public static void SetTwoRowValues(DataRow rowFrom, DataRow rowTo)
   /// <summary>
   /// 数据行(DataRow)转换为对象,对象的Type由type参数决定.
   /// </summary>
   public static object DataRowToObject(DataRow row, Type type)
   /// <summary>
   /// ArrayList转换为对象数组.
   /// </summary>
   public static object[] ToObjects(IList source)
   /// <summary>
   /// 对象数组转换为ArrayList.
   /// </summary>
   public static ArrayList ToArrayList(IList list)
   /// <summary>
   /// 对象数组转换为ArrayList.
   /// </summary>
   public static ArrayList ToArrayList(object[] source)
   /// <summary>
   /// 把字符串以逗号分格,转换成数据库格式in(''a'',''b'')
   /// </summary>
   public static string ToSQLInDataFormat(string input)
   /// <summary>
   /// 把字符串以逗号分格,转换成数据库格式''''a'''',''''b''''
   /// </summary>
   public static string ToSQLInDataFormatTwo(string input)
   public static string ToSQLInDataFormat(string[] input)
   /// <summary>
   /// 从table转成dataset
   /// </summary>
   /// <param name="dt"></param>
   /// <returns></returns>
   public static DataSet TableToDataSet(DataTable dt)
   public static DataSet TableToDataSet(DataTable[] dtArr)
   /// <summary>
   /// 修改对表的某列的值
   /// </summary>
   public static bool UpdateTableCol(DataTable dt, string fieldName, object value)
   /// <summary>
   /// 以逗号分格字符串,返回数组
   /// 如果第一个和最后一个字符为, 去掉
   /// </summary>
   public static string[] ToStringSplit(string str)
   /// <summary>
   /// 把一个行的数据新增一个表中
   /// </summary>
   public static DataTable AddTableRowByRow(DataTable dt, DataRow dr)
}


CDataConverter.rar


点击下载附件 点击下载附件 (如下载失败,请邮件通知我们寄回给您,或QQ:23404761留言.)
上一篇 下一篇