DBTable.cs 1.7 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81
using SQLite;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace UnitTestProject1.Model
{

    [Table("book")]
    public class Book
    {
        [Key]
        [PropertyIndex(0)]
        public Int64 ID { get; set; }

        /// <summary>
        /// 书名
        /// </summary>
        [PropertyIndex(1)]
        public string BookName { get; set; }

        /// <summary>
        /// 页数
        /// </summary>
        [PropertyIndex(2)]
        public int PageCount { get; set; }

        /// <summary>
        /// 印刷日期
        /// </summary>
        [PropertyIndex(3)]
        public DateTime PrintTime { get; set; }
    }
    public class Book2
    {
        [Key]
        [PropertyIndex(0)]
        public Int64 ID { get; set; }

        /// <summary>
        /// 书名
        /// </summary>
        [PropertyIndex(1)]
        public string BookName { get; set; }

        /// <summary>
        /// 页数
        /// </summary>
        [PropertyIndex(2)]
        public long PageCount { get; set; }

        /// <summary>
        /// 印刷日期
        /// </summary>
        public DateTime PrintTime { get; set; }
    }

    [Table("user")]
    public class User
    {
        [Key]
        [PropertyIndex(0)]
        public Int64 ID { get; set; }

        /// <summary>
        /// 姓名
        /// </summary>
        [PropertyIndex(1)]
        public string Name { get; set; }

        /// <summary>
        /// 拥有的书的ID
        /// </summary>
        [PropertyIndex(2)]
        public string BookIDs { get; set; }
    }
}