1 public class WBIDbContext : DbContext
2 {
3 public DbSet<SysUserMdl> Users { get; set; }
4 public DbSet<SysUserGroupMdl> UserGroups { get; set; }
5 public DbSet<SysMenuModuleMdl> MenuModules { get; set; }
6 public DbSet<SysMenuItemMdl> MenuItems { get; set; }
7
8 public DbSet<VidCameraMdl> Cameras { get; set; }
9
10 public DbSet<DevDevtypeMdl> DevType { get; set; }//增加设备表的读取
11
12 // public DbSet<VidDiskRecorderMdl> VideoHosts { get; set; }
13
14 public WBIDbContext()
15 : base("DefaultConnection")
16 {
17 }
18 }
1 public class WBIContextFactory
2 {
3 private const string KEY_DB_CONTEXT = "WBIDbContext";
4
5 public static WBIDbContext GetCurrentContext()
6 {
7 WBIDbContext dbContext =
8 CallContext.GetData(KEY_DB_CONTEXT) as WBIDbContext;
9
10 if (dbContext == null)
11 {
12 dbContext = new WBIDbContext();
13 CallContext.SetData(KEY_DB_CONTEXT, dbContext);
14 }
15
16 return dbContext;
17 }
18 }
1 //设备类型
2 [Table("t_dev_devtype")]
3 public class DevDevtypeMdl
4 {
5 [Key]
6 [Display(Name="设备编号")]
7 public string devid { get; set; }
8 [Display(Name = "设备编码")]
9 public string devtype { get; set; }
10 [Display(Name = "名称描述")]
11 public string devdesc { get; set; }
12 [Display(Name = "排序")]
13 public string devorder { get; set; }
14 [Display(Name = "设备备注")]
15 public string devmemo { get; set; }
16 }