Entity

 1 using system;
 2 using system.collections.generic;
 3 using system.linq;
 4 using system.text;
 5 using system.threading.tasks;
 6 
 7 namespace vacationoa.model
 8 {
 9     using system.componentmodel.dataannotations;
10     using system.componentmodel.dataannotations.schema;
11     /// <summary>
12     /// 审核表
13     /// </summary>
14     [table("tcheck")]
15     public class tcheck
16     {
17         /// <summary>
18         /// 审核id
19         /// </summary>
20         [key]
21         public int checkid { get; set; }
22         /// <summary>
23         /// 假条id
24         /// </summary>
25         public int leaveid { get; set; }
26         /// <summary>
27         /// 审核的部门+职位名称
28         /// </summary>
29         public string checkperson { get; set; }
30         /// <summary>
31         /// 审核时间
32         /// </summary>
33         public  datetime ? checktime { get; set; }
34         /// <summary>
35         /// 审核状态
36         /// </summary>
37         public string checkstate { get; set; }
38         /// <summary>
39         /// 备注
40         /// </summary>
41         public string explain { get; set; }
42 
43 
44     }
45 }

审核表

 1 using system;
 2 using system.collections.generic;
 3 using system.linq;
 4 using system.text;
 5 using system.threading.tasks;
 6 
 7 namespace vacationoa.model
 8 {
 9     using system.componentmodel.dataannotations;
10     using system.componentmodel.dataannotations.schema;
11     /// <summary>
12     /// 假条表
13     /// </summary>
14     [table("leave")]
15     public class leave
16     {
17         /// <summary>
18         /// 假条id
19         /// </summary>
20         [key]
21         public int leaveid { get; set; }
22         /// <summary>
23         /// 员工id
24         /// </summary>
25         public int staffid { get; set; }
26         /// <summary>
27         /// 申请时间
28         /// </summary>
29         public datetime applytime { get; set; }
30         /// <summary>
31         /// 请假开始时间
32         /// </summary>
33         public datetime starttime { get; set; }
34         /// <summary>
35         /// 请假结束时间
36         /// </summary>
37         public datetime endtime { get; set; }
38         /// <summary>
39         /// 请假总天数
40         /// </summary>
41         public int sumtime { get; set; }
42         /// <summary>
43         /// 请假事由
44         /// </summary>
45         public string reason { get; set; }
46         /// <summary>
47         /// 状态
48         /// </summary>
49         public string state { get; set; }
50         /// <summary>
51         /// 备注
52         /// </summary>
53         public string remark { get; set; }
54         /// <summary>
55         /// 部门表
56         /// </summary>
57         [notmapped]
58         public string  department{get;set;}
59         /// <summary>
60         /// 请假人姓名
61         /// </summary>
62         [notmapped]
63         public string staffname { get; set; }
64         /// <summary>
65         /// 审核时间checktime
66         /// </summary>
67         public datetime ? checktime { get; set; }
68         /// <summary>
69         /// 审核结果说明
70         /// </summary>
71         public string explain { get; set; }
72 
73     }
74 }

假条表

 1 using system;
 2 using system.collections.generic;
 3 using system.linq;
 4 using system.text;
 5 using system.threading.tasks;
 6 
 7 namespace vacationoa.model
 8 {
 9     using system.componentmodel.dataannotations;
10     using system.componentmodel.dataannotations.schema;
11     /// <summary>
12     /// 员工表
13     /// </summary>
14     [table("staff")]
15     public class staff
16     {
17         /// <summary>
18         /// 员工id
19         /// </summary>
20         [key]
21         public int staffid { get; set; }
22         /// <summary>
23         /// 员工姓名
24         /// </summary>
25         public string staffname { get; set; }
26         /// <summary>
27         /// 部门名称
28         /// </summary>
29         public string department { get; set; }
30         /// <summary>
31         /// 职位名称
32         /// </summary>
33         public string positions { get; set; }
34 
35 
36     }
37 }

员工表

 1 using system;
 2 using system.collections.generic;
 3 using system.linq;
 4 using system.text;
 5 using system.threading.tasks;
 6 
 7 namespace vacationoa.model
 8 {
 9     public class paging
10     {
11         /// <summary>
12         /// 当前页
13         /// </summary>
14         public int currentpage { get; set; }
15         /// <summary>
16         /// 总页数
17         /// </summary>
18         public int totlepage { get; set; }
19         /// <summary>
20         /// 总记录数字
21         /// </summary>
22         public int rowcounts { get; set; }
23         /// <summary>
24         /// 数据盒子
25         /// </summary>
26         public object databox { get; set; }
27     }
28 }

view code

 1 using system;
 2 using system.collections.generic;
 3 using system.linq;
 4 using system.text;
 5 using system.threading.tasks;
 6 
 7 namespace vacationoa.model
 8 {
 9  public   class likeshow
10     {
11         public int staffid { get; set; }
12         public int currentpage { get; set; }
13         public string state { get; set; }
14         public datetime ? starttime { get; set; }
15         public datetime ? endtiome { get; set; }
16         public string  department { get; set; }
17     }
18 }

view code