【转 http://blog.csdn.net/RonoTian/article/details/2912349】

看到有同学反馈，说MiniORM代码有Bug，也不知道怎么用，所以今天我就写了些测试代码。希望能够给点帮助。 同时也发现了两Bug，一并罗列出： 1、MiniORM.PubFuncs.GetObjectType()函数：

  1. publicstatic Type GetObjectType(string assemblyname, string namespacename, string classname)
  2. {
  3.     Type objType = (Type)_HashObjectType[assemblyname + namespacename + classname];
  5.     if (objType == null)
  6.     {
  7.         object obj = _HashObjectType[assemblyname + namespacename + classname];
  9.         obj = Assembly.Load(assemblyname).CreateInstance(namespacename + "." + classname);
  11.         _HashObjectType[assemblyname + namespacename + classname] = obj.GetType();
  13.         //需要增加这句
  14.         objType = (Type)_HashObjectType[assemblyname + namespacename + classname];
  15.     }
  17.     return objType;
  18. }

2、MiniORM.OrmWriter.CheckValidate()函数：

  1. publicvoid CheckValidate(object ModelObject)
  2.         {
  3.             PropertyInfo[] infos = ModelObject.GetType().GetProperties();
  4.             object[] CustomerAttributes = null;
  5.             object[] CustomerAttributes1 = null;
  7.             //SELECT ID FROM TableName WHERE @A='' OR @B=''
  8.             string strSQL = "SELECT ID FROM {0} WHERE {1}";
  9.             string strTablename = PubFuncs.GetTableName(ModelObject);
  10.             string strWOA = "";
  11.             string strWHERE = "";
  12.             string strFieldMessage = "";
  13.            
  14.             foreach (PropertyInfo info in infos)
  15.             {
  16.                 CustomerAttributes = info.GetCustomAttributes(typeof(MiniORMAttribute.DataFieldNotDoubleAttribute), false);
  17.                 CustomerAttributes1 = info.GetCustomAttributes(typeof(MiniORMAttribute.DataFieldAttribute), false);
  19.                 if (CustomerAttributes != null && CustomerAttributes1 != null)
  20.                 {
  21.                     for (int i = 0; i < CustomerAttributes.Length; i++)
  22.                     {
  23.                         strWHERE += strWOA + ((MiniORMAttribute.DataFieldAttribute)CustomerAttributes1[0]).FieldName + "='" + info.GetValue(ModelObject, null) + "'";
  24.                         strFieldMessage += ((MiniORMAttribute.DataFieldAttribute)CustomerAttributes1[0]).FieldName;
  25.                         strWOA = " OR ";
  26.                     }
  27.                 }
  28.             }
  30.             //这里需要做strWHERE不为空的判断
  31.             if (strWHERE.Trim() != "")
  32.             {
  33.                 strSQL = string.Format(strSQL, newstring[] { strTablename, strWHERE });
  35.                 using (SqlConnection conn = new SqlConnection(PubFuncs.ConnectionStr))
  36.                 {
  37.                     conn.Open();
  38.                     SqlCommand cmd = new SqlCommand();
  39.                     cmd.Connection = conn;
  40.                     cmd.CommandType = CommandType.Text;
  41.                     cmd.CommandText = strSQL;
  43.                     using (SqlDataReader rdr = cmd.ExecuteReader())
  44.                     {
  45.                         if (rdr.Read())
  46.                         {
  47.                             thrownew Exception("下列字段值不能重复：" + strFieldMessage);
  48.                         }
  49.                     }
  50.                 }
  51.             }
  52.         }

测试代码如下： 首先是类关系图：

 

数据库表：

Person表：

Hand表：

Head表：

 

测试代码如下：

下面是类代码：

  1. [DataObjectAttribute("Person", "ID", "")]
  2. publicclass Person
  3. {
  4.     privateint _ID;
  5.     privatestring _Name;
  6.     privateint _Age;
  7.     privatestring _Sex;
  8.     private Head _Head;
  9.     private Hand _LeftHand;
  10.     private Hand _RightHand;
  12.     [DataFieldAttribute("ID", true)]
  13.     publicint ID
  14.     {
  15.         get { return _ID; }
  16.         set { _ID = value; }
  17.     }
  19.     [SubDataObjectAttribute(SubDataObjectFieldType.Object, "MiniORM", "MiniORM", "Head")]
  20.     public Head Head
  21.     {
  22.         get { return _Head; }
  23.         set { _Head = value; }
  24.     }
  26.     [SubDataObjectAttribute(SubDataObjectFieldType.Object, "MiniORM", "MiniORM", "Hand")]
  27.     public Hand LeftHand
  28.     {
  29.         get { return _LeftHand; }
  30.         set { _LeftHand = value; }
  31.     }
  33.     [SubDataObjectAttribute(SubDataObjectFieldType.Object, "MiniORM", "MiniORM", "Hand")]
  34.     public Hand RightHand
  35.     {
  36.         get { return _RightHand; }
  37.         set { _RightHand = value; }
  38.     }
  40.     [DataFieldAttribute("name", "NvarChar")]
  41.     publicstring Name
  42.     {
  43.         get { returnthis._Name; }
  44.         set { this._Name = value; }
  45.     }
  47.     [DataFieldAttribute("age", "int")]
  48.     publicint Age
  49.     {
  50.         get { returnthis._Age; }
  51.         set { this._Age = value; }
  52.     }
  54.     [DataFieldAttribute("sex", "NvarChar")]
  55.     publicstring Sex
  56.     {
  57.         get { returnthis._Sex; }
  58.         set { this._Sex = value; }
  59.     }
  61.     public Hand Hand
  62.     {
  63.         get
  64.         {
  65.             thrownew System.NotImplementedException();
  66.         }
  67.         set
  68.         {
  69.         }
  70.     }
  72.     public Head Head1
  73.     {
  74.         get
  75.         {
  76.             thrownew System.NotImplementedException();
  77.         }
  78.         set
  79.         {
  80.         }
  81.     }
  82. }
  84. [DataObjectAttribute("Hand", "ID", "PersonID")]
  85. publicclass Hand
  86. {
  87.     privateint _ID;
  88.     privateint _PersonID;
  89.     privatestring _Name;
  91.     [DataFieldAttribute("ID", true)]
  92.     publicint ID
  93.     {
  94.         get { returnthis._ID; }
  95.         set { this._ID = value; }
  96.     }
  98.     [DataFieldAttribute("PersonID")]
  99.     publicint PersonID
  100.     {
  101.         get { returnthis._PersonID; }
  102.         set { this._PersonID = value; }
  103.     }
  105.     [DataFieldAttribute("name", "NvarChar")]
  106.     publicstring Name
  107.     {
  108.         get { return _Name; }
  109.         set { _Name = value; }
  110.     }
  111. }
  113. [DataObjectAttribute("Head", "ID", "PersonID")]
  114. publicclass Head
  115. {
  116.     privateint _ID;
  117.     privateint _PersonID;
  118.     privatestring _Name;
  120.     [DataFieldAttribute("ID", true)]
  121.     publicint ID
  122.     {
  123.         get { returnthis._ID; }
  124.         set { this._ID = value; }
  125.     }
  127.     [DataFieldAttribute("PersonID")]
  128.     publicint PersonID
  129.     {
  130.         get { returnthis._PersonID; }
  131.         set { this._PersonID = value; }
  132.     }
  134.     [DataFieldAttribute("name", "NvarChar")]
  135.     publicstring Name
  136.     {
  137.         get { return _Name; }
  138.         set { _Name = value; }
  139.     }
  140. }

下面是测试代码：

  1. [STAThread]
  2. staticvoid Main()
  3. {
  4.     //插入测试
  5.     WriteTest();
  7.     //读取测试
  8.     ReadTest();
  9. }
  11. privatestaticvoid WriteTest()
  12. {
  13.     Person person = new Person();
  14.     person.Name = "snoopy";
  15.     person.Age = 5;
  16.     person.Sex = "male";
  18.     Hand lefthand = new Hand();
  19.     lefthand.Name = "左手";
  21.     Hand righthand = new Hand();
  22.     righthand.Name = "右手";
  24.     Head head = new Head();
  25.     head.Name = "大笨脑袋";
  27.     person.LeftHand = lefthand;
  28.     person.RightHand = righthand;
  29.     person.Head = head;
  31.     MiniORM.OrmWriter write = new OrmWriter();
  32.     write.Write(person);
  33. }
  35. privatestaticvoid ReadTest()
  36. {
  37.     MiniORM.OrmReader reader = new OrmReader();
  38.     Person person = (Person)reader.Read(new Person(), 1);
  41.     Console.WriteLine("person.Name:" + person.Name);
  42.     Console.WriteLine("person.Age:" + person.Age);
  43.     Console.WriteLine("person.Sex:" + person.Sex);
  44.     Console.WriteLine("LeftHand.Name:" + person.LeftHand.Name);
  45.     Console.WriteLine("RightHand.Name:" + person.RightHand.Name);
  46.     Console.WriteLine("Head.Name:" + person.Head.Name);
  48.     Console.Read();
  49. }

ReadTest的测试结果如：

好了，各位，你可以使用这个调试代码来试试了。。。