C#_自訂簡單ORM(二)代碼下載

標籤：test   code   實體   測試   技術分享   div   column   datetime   file   

 

測試實體：

    [TableAttribute("TEST_STUDENT")]    public class Student : MyBaseClass    {        /// <summary>        ///         /// </summary>        [ColumnAttribute("GUID", DbType.AnsiString, IsPK = true)]        public string Guid        { get; set; }        [ColumnAttribute("Name", DbType.AnsiString)]        public string Name        { get; set; }        [ColumnAttribute("Age", DbType.Int32)]        public Int32? Age        { get; set; }        [ColumnAttribute("Height", DbType.Decimal)]        public Decimal? Height        { get; set; }        [ColumnAttribute("Birthday", DbType.DateTime)]        public DateTime? Birthday        { get; set; }    }

測試代碼：

private void SelectTest(ISqlHelper helper)        {            MyDbHelper fh = new MyDbHelper(helper);            List<Student> lst = null;            Student stu = new Student();            stu.SetHelper(helper);            stu.Name = "chyun";            lst = fh.Select<Student>(stu);            lst = stu.Select<Student>();            stu = new Student();            stu.SetHelper(helper);            stu.Age = 26;            lst = fh.Select<Student>(stu);            lst = stu.Select<Student>();            stu = new Student();            stu.SetHelper(helper);            stu.Age = 26;            stu.Height = 1.78M;            lst = fh.Select<Student>(stu);            lst = stu.Select<Student>();            stu = new Student();            stu.SetHelper(helper);            stu.Height = 1.78M;            lst = fh.Select<Student>(stu);            lst = stu.Select<Student>();        }        private void InsertTest(ISqlHelper helper)        {            Student stu = new Student();            stu.SetHelper(helper);            stu.Guid = "E47F2C60EF00488B9F48747FACC41EC5";            stu.Name = "chyun";            stu.Age = 26;            stu.Height = 1.78M;            stu.Birthday = DateTime.Parse("1988-06-07 10:30:00");            stu.Insert();            stu = new Student();            stu.SetHelper(helper);            stu.Guid = Guid.NewGuid().ToString();            stu.Name = "chyun";            //stu.Age = 26;            stu.Height = 1.78M;            stu.Birthday = DateTime.Parse("1988-06-07 10:31:00");            stu.Insert();            stu = new Student();            stu.SetHelper(helper);            stu.Guid = Guid.NewGuid().ToString();            stu.Name = "chyun";            stu.Age = 27;            stu.Height = 1.781M;            stu.Birthday = DateTime.Parse("1988-06-07 10:32:00");            stu.Insert();        }        private void UpdateTest(ISqlHelper helper)        {            Student stu = new Student();            stu.SetHelper(helper);            stu.Guid = "E47F2C60EF00488B9F48747FACC41EC5";            stu.Name = "chyun";            stu.Age = 16;            stu.Height = 1.785M;            stu.Birthday = DateTime.Parse("1988-06-07 10:30:30");            stu.UpdateByPk();        }        private void DeleteTest(ISqlHelper helper)        {            Student stu = new Student();            stu.SetHelper(helper);            stu.Guid = "E47F2C60EF00488B9F48747FACC41EC5";            stu.Name = "chyun";            stu.Age = 16;            stu.Height = 1.785M;            stu.Birthday = DateTime.Parse("1988-06-07 10:30:30");            stu.DeleteByPk();        }

 歡迎指正 點擊下載代碼  

QQ:519409748

C#_自訂簡單ORM(二)代碼下載