Esempio n. 1
0
        public static IList <T> GetManyTListBySQL <T>(string sql, DeleObjectName2ColumnName ObjectName2ColumnName, params SqlParameter[] parms)
        {
            IList <T> lists = new List <T>();

            using (SqlDataReader rdr = SqlHelper.ExecuteReader(sql, parms))
            {
                DataView dv = rdr.GetSchemaTable().DefaultView;
                while (rdr.Read())
                {
                    T objectT = (T)Activator.CreateInstance(typeof(T));

                    SetProperties(rdr, objectT, ObjectName2ColumnName, dv);


                    lists.Add(objectT);
                }
            }

            return(lists);
        }
Esempio n. 2
0
        public static void SetProperties(System.Data.IDataReader dataReader, object Obj, DeleObjectName2ColumnName ObjectName2ColumnName, DataView dv)
        {
            System.Reflection.PropertyInfo[] propertyInfoList = Obj.GetType().GetProperties();

            string columnName;

            foreach (System.Reflection.PropertyInfo property in propertyInfoList)
            {
                if (property.CanWrite)
                {
                    columnName = ObjectName2ColumnName(property);

                    object objValue = null;

                    try
                    {
                        dv.RowFilter = "ColumnName='" + columnName + "'";
                        if (dv.Count > 0)
                        {
                            objValue = dataReader[columnName];
                        }
                    }
                    catch
                    {
                        objValue = null;
                    }

                    if (objValue != null && objValue != DBNull.Value)
                    {
                        objValue = ConvertDBNull(objValue, property.PropertyType);


                        if (property.PropertyType == typeof(decimal) &&
                            objValue.GetType() != typeof(decimal))
                        {
                            property.SetValue(Obj, Convert.ToDecimal(objValue), null);
                        }
                        else if (property.PropertyType == typeof(int) &&
                                 objValue.GetType() != typeof(int))
                        {
                            property.SetValue(Obj, Convert.ToInt32(objValue), null);
                        }
                        else if (property.PropertyType == typeof(bool) && objValue.GetType() != typeof(bool))
                        {
                            property.SetValue(Obj, Convert.ToBoolean(objValue), null);
                        }
                        else
                        {
                            property.SetValue(Obj, objValue, null);
                        }
                    }
                }
            }
        }