檢測空值，以及會不會出現mapping類型不一致的問題

標籤：iter   oda   code   tor   convert   public   registry   for   context   

   /// <summary>        /// 檢測空值，以及會不會出現mapping類型不一致的問題        /// </summary>        /// <typeparam name="T"></typeparam>        /// <param name="nullsb1"></param>        /// <param name="errorsb"></param>        public static void CheckHibernateMappingType<T>(out StringBuilder nullsb1,out StringBuilder errorsb) where T:Framework.Domain.Entity,new()        {            nullsb1 = new StringBuilder();            errorsb = new StringBuilder();            var ctx = Spring.Context.Support.ContextRegistry.GetContext();            var Dao = GetDao();            var mapping = ((Spring.Data.NHibernate.LocalSessionFactoryObject)ctx.GetObject("&SessionFactory")).Configuration.GetClassMapping(typeof(T));            var pmap = mapping.PropertyIterator;            var tableName1 = mapping.Table.Name;            var table = Dao.ExecuteDataSet(new QueryInfo() { CustomSQL = "select * from " + tableName1 }).Tables[0];            Hashtable columnsType = new Hashtable();            foreach (DataColumn col in table.Columns)            {                columnsType.Add(col.ColumnName, col.DataType.Name);            }            string primaryKey = ((NHibernate.Mapping.Column)(mapping.Key.ColumnIterator.FirstOrDefault())).Name;            StringBuilder sb = new StringBuilder();            StringBuilder sb1 = new StringBuilder();            foreach (DataRow dr in table.Rows)            {                foreach (var item in pmap)                {                    NHibernate.Mapping.Column c = (NHibernate.Mapping.Column)item.ColumnIterator.FirstOrDefault();                    //1對多的屬性如children沒有對應的列                    if (c != null)                    {                        string columnTypeName = columnsType[c.Name].ToString();                        try                        {                            if (dr[c.Name] is DBNull)                            {                                nullsb1.Append("主鍵" + dr[primaryKey].ToString() + "列" + c.Name + "約定類型為:" + columnTypeName + "值為:NULL\r\n");                                continue;                            }                            switch (columnTypeName)                            {                                case "String":                                    break;                                case "Int16":                                    Convert.ToInt16(dr[c.Name]);                                    break;                                case "Int32":                                    Convert.ToInt32(dr[c.Name]);                                    break;                                case "Int64":                                    Convert.ToInt64(dr[c.Name]);                                    break;                                case "Decimal":                                    Convert.ToDecimal(dr[c.Name]);                                    break;                                case "DateTime":                                    Convert.ToDateTime(dr[c.Name]);                                    break;                                case "Boolean":                                case "bool":                                    Convert.ToBoolean(dr[c.Name]);                                    break;                                default:                                    break;                            }                        }                        catch (Exception ex)                        {                            sb.Append("主鍵" + dr[primaryKey].ToString() + "列" + c.Name + "約定類型為:" + columnTypeName + "值為:" + dr[c.Name] + "??類型轉換異常\r\n");                        }                    }                }            }        }

 

檢測空值，以及會不會出現mapping類型不一致的問題