DbCommand生成器测试案例 - DbCommandGenerator.cs

            //isid是自增字段
            sys_Log log = new sys_Log
            {
                DocNo = "doc0123412341234",
                GUID32 = "2345234523452435",
                LogDate = DateTime.Now,
                LogUser = "admin",
                OPType = 1,
            };

            var conn = "Server=.;Database=CSFrameworkV5_Normal;User ID=sa;Password=test; Max Pool Size=512; Pooling=true;Connect Timeout=30";
            IDatabase db = DatabaseFactory.CreateSqlDatabase(conn);

            //实例化DbCommand生成器
            DbCommandGenerator g = new DbCommandGenerator(db);

            //测试案例1 - 获取标识有特性(Attribute)的字段
            var list = g.GetAttributeFields(typeof(sys_Log), typeof(KeyField));
            var list2 = g.GetAttributeFields(typeof(sys_Log), typeof(IgnoreField));

            //测试案例2
            var m5 = g.GetTableName(typeof(sys_Log));
            var m1 = g.GetDeleteCommand(typeof(sys_Log));
            var m2 = g.GetDeleteCommand<sys_Log>(log);
            var m3 = g.GetInsertCommand(typeof(sys_Log));
            var m4 = g.GetInsertCommand<sys_Log>(log);            
            var m6 = g.GetUpdateCommand(typeof(sys_Log));
            var m7 = g.GetUpdateCommand<sys_Log>(log);

 [TableInfoAttribute("sys_Log")]
    public class sys_Log
    {
        [KeyField]
        public string GUID32 { get; set; }

        [IgnoreField]
        public int isid { get; set; }

        public string DocNo { get; set; }

        public string LogUser { get; set; }

        public int OPType { get; set; }

        public DateTime LogDate { get; set; }

        public bool IsProcess { get; set; }

        [IgnoreField]
        public string IgnoreField1 { get; set; }

        [IgnoreField]
        public string IgnoreField2 { get; set; }
    }