From d14b82fec13361486c49165371b5dee1b7089c09 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期四, 09 十二月 2021 13:35:23 +0800 Subject: [PATCH] 提交 --- zhengcaioa/Model/zhengcaioaContext.cs | 1374 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 1,370 insertions(+), 4 deletions(-) diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs index 39f2cf5..f569e87 100644 --- a/zhengcaioa/Model/zhengcaioaContext.cs +++ b/zhengcaioa/Model/zhengcaioaContext.cs @@ -24,18 +24,25 @@ public virtual DbSet<HrSalaryAppeal> HrSalaryAppeal { get; set; } public virtual DbSet<SimCostYearView> SimCostYearView { get; set; } + public virtual DbSet<AdmAskBaiFang> AdmAskBaiFangs { get; set; } public virtual DbSet<AdmAskCar> AdmAskCars { get; set; } + public virtual DbSet<AdmAskCiZhi> AdmAskCiZhis { get; set; } public virtual DbSet<AdmAskcost> AdmAskcosts { get; set; } public virtual DbSet<AdmAskGood> AdmAskGoods { get; set; } + public virtual DbSet<AdmGoodsRecord> AdmGoodsRecords { get; set; } + public virtual DbSet<AdmAskJiaojie> AdmAskJiaojies { get; set; } + public virtual DbSet<AdmAskJiaojieDtl> AdmAskJiaojieDtls { get; set; } public virtual DbSet<AdmAskLeave> AdmAskLeaves { get; set; } public virtual DbSet<AdmAskLeaveOff> AdmAskLeaveOffs { get; set; } public virtual DbSet<AdmAskMarketingCost> AdmAskMarketingCosts { get; set; } public virtual DbSet<AdmAskovertime> AdmAskovertimes { get; set; } + public virtual DbSet<AdmAskYouHui> AdmAskYouHuis { get; set; } public virtual DbSet<AdmAttendance> AdmAttendances { get; set; } public virtual DbSet<AdmAttendanceDtl> AdmAttendanceDtls { get; set; } public virtual DbSet<AdmAttendanceRule> AdmAttendanceRules { get; set; } public virtual DbSet<AdmAttendanceRulesDtl> AdmAttendanceRulesDtls { get; set; } public virtual DbSet<AdmBreakPrecedent> AdmBreakPrecedents { get; set; } + public virtual DbSet<AdmCustomerWithdrawal> AdmCustomerWithdrawals { get; set; } public virtual DbSet<AdmHoldPhone> AdmHoldPhones { get; set; } public virtual DbSet<AdmMemoBook> AdmMemoBooks { get; set; } public virtual DbSet<AdmSignIn> AdmSignIns { get; set; } @@ -45,6 +52,8 @@ public virtual DbSet<AdmGoodsClassify> AdmGoodsClassifies { get; set; } public virtual DbSet<AdmGoodsManage> AdmGoodsManages { get; set; } public virtual DbSet<AdmPieceCheck> AdmPieceChecks { get; set; } + public virtual DbSet<AdmTongxunlu> AdmTongxunlus { get; set; } + public virtual DbSet<AdmZhanghaomima> AdmZhanghaomimas { get; set; } public virtual DbSet<Area> Areas { get; set; } public virtual DbSet<Cgf> Cgfs { get; set; } public virtual DbSet<CooperOrder> CooperOrders { get; set; } @@ -68,6 +77,7 @@ public virtual DbSet<HrJixiaoticheng> HrJixiaotichengs { get; set; } public virtual DbSet<HrPosition> HrPositions { get; set; } public virtual DbSet<HrSalary> HrSalaries { get; set; } + public virtual DbSet<HrShebao> HrShebaos { get; set; } public virtual DbSet<IntentionCustomer> IntentionCustomers { get; set; } public virtual DbSet<IntentionOrder> IntentionOrders { get; set; } public virtual DbSet<IntentionVisit> IntentionVisits { get; set; } @@ -91,6 +101,7 @@ public virtual DbSet<Projectyouxiao> Projectyouxiaos { get; set; } public virtual DbSet<Projectzhongbiao> Projectzhongbiaos { get; set; } public virtual DbSet<SysAttachment> SysAttachments { get; set; } + public virtual DbSet<SysBaimingdan> SysBaimingdans { get; set; } public virtual DbSet<SysCode> SysCodes { get; set; } public virtual DbSet<SysCodeDtl> SysCodeDtls { get; set; } public virtual DbSet<Systemsetting> Systemsettings { get; set; } @@ -104,12 +115,28 @@ public virtual DbSet<Expert> Experts { get; set; } public virtual DbSet<ExpertOrderDispatch> ExpertOrderDispatches { get; set; } public virtual DbSet<ExpertPromote> ExpertPromotes { get; set; } + public virtual DbSet<ExpertTestTopic> ExpertTestTopics { get; set; } + public virtual DbSet<ExpertTestTopicanwser> ExpertTestTopicanwsers { get; set; } + public virtual DbSet<ExpertTestTopicjiexi> ExpertTestTopicjiexis { get; set; } + public virtual DbSet<ExpertTestResult> ExpertTestResults { get; set; } + public virtual DbSet<ExpertTestTopicpeizhi> ExpertTestTopicpeizhis { get; set; } #region 琛屾斂绠$悊 public virtual DbSet<AskLeave> AskLeaves { get; set; } public virtual DbSet<AskLeaveOff> AskLeaveOffs { get; set; } public virtual DbSet<SignIn> SignIns { get; set; } #endregion + + + public virtual DbSet<TChallengeItem> TChallengeItems { get; set; } + public virtual DbSet<TChallengeletter> TChallengeletters { get; set; } + public virtual DbSet<TComplaintItem> TComplaintItems { get; set; } + public virtual DbSet<TComplaintRespondent> TComplaintRespondents { get; set; } + public virtual DbSet<TComplaintletter> TComplaintletters { get; set; } + public virtual DbSet<TComplaintGongyingshang> TComplaintGongyingshangs { get; set; } + public virtual DbSet<TComplaintShouquandaibiao> TComplaintShouquandaibiaos { get; set; } + + protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { if (!optionsBuilder.IsConfigured) @@ -122,6 +149,64 @@ protected override void OnModelCreating(ModelBuilder modelBuilder) { modelBuilder.HasAnnotation("Relational:Collation", "Chinese_PRC_CI_AS"); + + modelBuilder.Entity<AdmAskBaiFang>(entity => + { + entity.ToTable("ADM_AskBaiFang"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.BaiFangtime).HasColumnType("datetime"); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.CreaterName) + .HasMaxLength(50) + .HasColumnName("createrName"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.CustomerId).HasMaxLength(500); + + entity.Property(e => e.Jtype).HasMaxLength(50); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Remark).HasMaxLength(500); + + entity.Property(e => e.ShenpiStatus) + .HasMaxLength(1) + .HasColumnName("shenpi_status") + .HasDefaultValueSql("('D')"); + + entity.Property(e => e.Tittle) + .HasMaxLength(50) + .HasColumnName("tittle"); + + entity.Property(e => e.VisType).HasMaxLength(50); + }); modelBuilder.Entity<AdmAskCar>(entity => { @@ -168,6 +253,70 @@ .HasDefaultValueSql("('A')"); entity.Property(e => e.Remark).HasMaxLength(500); + + entity.Property(e => e.ShenpiStatus) + .HasMaxLength(1) + .HasColumnName("shenpi_status") + .HasDefaultValueSql("('D')"); + + entity.Property(e => e.Tittle) + .HasMaxLength(50) + .HasColumnName("tittle"); + }); + + modelBuilder.Entity<AdmAskCiZhi>(entity => + { + entity.ToTable("ADM_AskCiZhi"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.CreaterName) + .HasMaxLength(50) + .HasColumnName("createrName"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.CreatetimeName).HasMaxLength(50); + + entity.Property(e => e.DeptName).HasMaxLength(50); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.OrderType).HasMaxLength(50); + + entity.Property(e => e.Outtime).HasColumnType("datetime"); + + entity.Property(e => e.PostName).HasMaxLength(50); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Remark).HasMaxLength(2000); + + entity.Property(e => e.RuzhitimeName).HasMaxLength(50); + + entity.Property(e => e.JiaojieUser).HasMaxLength(500); entity.Property(e => e.ShenpiStatus) .HasMaxLength(1) @@ -287,6 +436,165 @@ entity.Property(e => e.Tittle) .HasMaxLength(50) .HasColumnName("tittle"); + }); + + modelBuilder.Entity<AdmGoodsRecord>(entity => + { + entity.ToTable("adm_goods_record"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.GoodsId) + .HasMaxLength(50) + .HasColumnName("goodsId"); + + entity.Property(e => e.GoodsLeft) + .HasColumnType("numeric(18, 2)") + .HasColumnName("goods_left"); + + entity.Property(e => e.GoodsNum) + .HasColumnType("numeric(18, 2)") + .HasColumnName("goods_num"); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.OperationalMatters).HasMaxLength(500); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.RecordTypeId).HasMaxLength(50); + + entity.Property(e => e.Remark).HasMaxLength(500); + }); + + modelBuilder.Entity<AdmAskJiaojie>(entity => + { + entity.ToTable("ADM_AskJiaojie"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.CiZhiId).HasMaxLength(50); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.CreaterName) + .HasMaxLength(50) + .HasColumnName("createrName"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Remark).HasMaxLength(500); + + entity.Property(e => e.ShenpiStatus) + .HasMaxLength(1) + .HasColumnName("shenpi_status") + .HasDefaultValueSql("('D')"); + + entity.Property(e => e.Tittle) + .HasMaxLength(50) + .HasColumnName("tittle"); + }); + + modelBuilder.Entity<AdmAskJiaojieDtl>(entity => + { + entity.ToTable("ADM_AskJiaojieDtl"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.JiaojieId).HasMaxLength(50); + + entity.Property(e => e.JiaojieNeirong).HasMaxLength(500); + + entity.Property(e => e.JiaojieStatus) + .HasMaxLength(1) + .HasColumnName("jiaojie_status") + .HasDefaultValueSql("('D')"); + + entity.Property(e => e.JiaojieType).HasMaxLength(50); + + entity.Property(e => e.JiaojieUserId).HasMaxLength(50); + + entity.Property(e => e.Jiaojietime).HasColumnType("datetime"); + + entity.Property(e => e.JieShoutime).HasColumnType("datetime"); + + entity.Property(e => e.Kehudanwei).HasMaxLength(500); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); }); modelBuilder.Entity<AdmAskLeave>(entity => @@ -480,6 +788,66 @@ entity.Property(e => e.Tittle) .HasMaxLength(50) .HasColumnName("tittle"); + }); + + modelBuilder.Entity<AdmAskYouHui>(entity => + { + entity.ToTable("ADM_AskYouHui"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.CreaterName) + .HasMaxLength(50) + .HasColumnName("createrName"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.CustomerId).HasMaxLength(50); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.OrderType).HasMaxLength(50); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Remark).HasMaxLength(500); + + entity.Property(e => e.ShenpiStatus) + .HasMaxLength(1) + .HasColumnName("shenpi_status") + .HasDefaultValueSql("('D')"); + + entity.Property(e => e.Tittle) + .HasMaxLength(50) + .HasColumnName("tittle"); + + entity.Property(e => e.YouHui) + .HasColumnType("money") + .HasDefaultValueSql("((0))"); + + entity.Property(e => e.Youhuistandard).HasMaxLength(50); }); modelBuilder.Entity<AdmAskMarketingCost>(entity => @@ -966,6 +1334,78 @@ .HasComment("鍛樺伐"); }); + modelBuilder.Entity<AdmCustomerWithdrawal>(entity => + { + entity.ToTable("ADM_Customer_withdrawal"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.CreaterName) + .HasMaxLength(50) + .HasColumnName("createrName"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.HuiyuanId).HasMaxLength(50); + + entity.Property(e => e.HuiyuanName).HasMaxLength(100); + + entity.Property(e => e.HuiyuanPhone).HasMaxLength(50); + + entity.Property(e => e.BankAcount).HasMaxLength(50); + + entity.Property(e => e.BankName).HasMaxLength(50); + + entity.Property(e => e.Username).HasMaxLength(50); + + entity.Property(e => e.Jine) + .HasColumnType("money") + .HasDefaultValueSql("((0))"); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.OrderNo).HasMaxLength(50); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Remark).HasMaxLength(500); + + entity.Property(e => e.ShenpiStatus) + .HasMaxLength(1) + .HasColumnName("shenpi_status") + .HasDefaultValueSql("('D')"); + + entity.Property(e => e.Shenqingtime) + .HasColumnType("datetime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.Tittle) + .HasMaxLength(50) + .HasColumnName("tittle"); + }); + modelBuilder.Entity<AdmHoldPhone>(entity => { entity.ToTable("ADM_HoldPhone"); @@ -1411,6 +1851,10 @@ .HasColumnName("goods_name") .HasComment("鐗╁搧鍚嶇О"); + entity.Property(e => e.ISBN) + .HasMaxLength(500) + .HasColumnName("ISBN"); + entity.Property(e => e.GoodsNum) .HasColumnType("numeric(18, 2)") .HasColumnName("goods_num") @@ -1426,6 +1870,11 @@ .HasColumnName("goods_status") .HasDefaultValueSql("('A')") .HasComment("鐗╁搧鐘舵��"); + + entity.Property(e => e.HaocaiStatus) + .HasMaxLength(1) + .HasColumnName("haocai_status") + .HasDefaultValueSql("('D')"); entity.Property(e => e.Modifier) .IsRequired() @@ -1518,6 +1967,116 @@ .HasColumnName("work_time") .HasDefaultValueSql("(getdate())") .HasComment("宸ヤ綔鏃堕棿"); + }); + + modelBuilder.Entity<AdmTongxunlu>(entity => + { + entity.ToTable("adm_tongxunlu"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Beuzhu) + .HasMaxLength(500) + .HasColumnName("beuzhu"); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.DanweiName) + .HasMaxLength(100) + .HasColumnName("danwei_name"); + + entity.Property(e => e.Lianxidianhua) + .HasMaxLength(100) + .HasColumnName("lianxidianhua"); + + entity.Property(e => e.Lianxiren) + .HasMaxLength(100) + .HasColumnName("lianxiren"); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.TypeId) + .HasMaxLength(50) + .HasColumnName("type_id"); + }); + + modelBuilder.Entity<AdmZhanghaomima>(entity => + { + entity.ToTable("adm_zhanghaomima"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Chanpinxiangmu) + .HasMaxLength(100) + .HasColumnName("chanpinxiangmu"); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.Mibao) + .HasMaxLength(100) + .HasColumnName("mibao"); + + entity.Property(e => e.Mima) + .HasMaxLength(100) + .HasColumnName("mima"); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.TypeId) + .HasMaxLength(50) + .HasColumnName("type_id"); + + entity.Property(e => e.Zhanghao) + .HasMaxLength(100) + .HasColumnName("zhanghao"); }); modelBuilder.Entity<Area>(entity => @@ -3206,6 +3765,49 @@ .HasColumnName("yufagongziheji"); }); + modelBuilder.Entity<HrShebao>(entity => + { + entity.ToTable("hr_shebao"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Shebaodanwei) + .HasColumnType("money") + .HasColumnName("shebaodanwei"); + + entity.Property(e => e.Shebaogeren) + .HasColumnType("money") + .HasColumnName("shebaogeren"); + }); + modelBuilder.Entity<IntentionCustomer>(entity => { entity.ToTable("IntentionCustomer"); @@ -3697,7 +4299,7 @@ .HasColumnName("shenhetime"); entity.Property(e => e.Shiyongfatiao) - .HasMaxLength(500) + .HasMaxLength(1000) .HasColumnName("shiyongfatiao"); }); modelBuilder.Entity<LiaotianShoucang>(entity => @@ -4739,6 +5341,10 @@ .HasColumnType("money") .HasColumnName("drhx_defen"); + entity.Property(e => e.Caigouyusuan) + .HasColumnType("money") + .HasColumnName("caigouyusuan"); + entity.Property(e => e.DrhxPrice) .HasMaxLength(500) .HasColumnName("drhx_price"); @@ -4954,6 +5560,53 @@ .HasDefaultValueSql("('A')"); }); + modelBuilder.Entity<SysBaimingdan>(entity => + { + entity.ToTable("sys_baimingdan"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.BaimingdanName) + .HasMaxLength(200) + .HasColumnName("baimingdan_name"); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.PostSeq) + .HasMaxLength(50) + .HasColumnName("post_seq"); + + entity.Property(e => e.PostType) + .HasMaxLength(50) + .HasColumnName("post_type"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + }); + modelBuilder.Entity<SysCode>(entity => { entity.ToTable("sys_code"); @@ -5036,7 +5689,7 @@ entity.Property(e => e.Comments) .IsRequired() - .HasMaxLength(50) + .HasMaxLength(100) .HasColumnName("comments"); entity.Property(e => e.Contents) @@ -5643,7 +6296,6 @@ .HasColumnName("expertType"); entity.Property(e => e.IdCard) - .IsRequired() .HasMaxLength(18) .HasColumnName("idCard"); @@ -5695,6 +6347,10 @@ .HasMaxLength(1) .HasColumnName("rec_status"); + entity.Property(e => e.YearJiou) + .HasMaxLength(1) + .HasColumnName("year_jiou"); + entity.Property(e => e.Remark) .HasMaxLength(1000) .HasColumnName("remark"); @@ -5702,7 +6358,6 @@ entity.Property(e => e.ReviewItem).HasMaxLength(50); entity.Property(e => e.Sex) - .IsRequired() .HasMaxLength(50) .HasColumnName("sex"); @@ -5848,6 +6503,278 @@ .IsUnicode(false) .HasColumnName("sort"); }); + + modelBuilder.Entity<ExpertTestTopic>(entity => + { + entity.ToTable("expert_test_topic"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Area) + .HasMaxLength(50) + .HasColumnName("area"); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.Jiexi) + .HasMaxLength(4000) + .HasColumnName("jiexi"); + + entity.Property(e => e.JiexiStatus) + .HasMaxLength(1) + .HasColumnName("jiexi_status") + .HasDefaultValueSql("('D')"); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.ShenpiStatus) + .HasMaxLength(1) + .HasColumnName("shenpi_status") + .HasDefaultValueSql("('D')"); + + entity.Property(e => e.Topic) + .HasMaxLength(4000) + .HasColumnName("topic"); + + entity.Property(e => e.Topictype) + .HasMaxLength(50) + .HasColumnName("topictype"); + + entity.Property(e => e.Zhishitype) + .HasMaxLength(50) + .HasColumnName("zhishitype"); + + entity.Property(e => e.Zhongdian) + .HasMaxLength(1) + .HasColumnName("zhongdian"); + }); + + modelBuilder.Entity<ExpertTestTopicanwser>(entity => + { + entity.ToTable("expert_test_topicanwser"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Anwser) + .HasMaxLength(500) + .HasColumnName("anwser"); + + entity.Property(e => e.Anwserno) + .HasMaxLength(50) + .HasColumnName("anwserno"); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Shifouzhengqu) + .HasMaxLength(1) + .HasColumnName("shifouzhengqu") + .HasDefaultValueSql("('D')"); + + entity.Property(e => e.Topic) + .HasMaxLength(50) + .HasColumnName("topic"); + }); + + modelBuilder.Entity<ExpertTestTopicjiexi>(entity => + { + entity.ToTable("expert_test_topicjiexi"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.Falv) + .HasMaxLength(50) + .HasColumnName("falv"); + + entity.Property(e => e.Flag) + .HasMaxLength(1) + .HasColumnName("flag"); + + entity.Property(e => e.Fatiao) + .HasMaxLength(500) + .HasColumnName("fatiao"); + + entity.Property(e => e.Jiexi) + .HasMaxLength(4000) + .HasColumnName("jiexi"); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Topic) + .HasMaxLength(50) + .HasColumnName("topic"); + }); + modelBuilder.Entity<ExpertTestResult>(entity => + { + entity.ToTable("expert_test_result"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Result) + .HasMaxLength(100) + .HasColumnName("result"); + + entity.Property(e => e.Resulttype) + .HasMaxLength(50) + .HasColumnName("resulttype"); + }); + + modelBuilder.Entity<ExpertTestTopicpeizhi>(entity => + { + entity.ToTable("expert_test_topicpeizhi"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Creater) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("creater") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.Fenshu) + .HasColumnType("numeric(18, 4)") + .HasColumnName("fenshu"); + + entity.Property(e => e.Fenzhi) + .HasColumnType("numeric(18, 4)") + .HasColumnName("fenzhi"); + + entity.Property(e => e.Modifier) + .IsRequired() + .HasMaxLength(50) + .HasColumnName("modifier") + .HasDefaultValueSql("('1')"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.ShijianId).HasMaxLength(50); + + entity.Property(e => e.Topictype) + .HasMaxLength(50) + .HasColumnName("topictype"); + + entity.Property(e => e.Zhishitype) + .HasMaxLength(50) + .HasColumnName("zhishitype"); + }); + #region 琛屾斂绠$悊瀹炰綋绫� modelBuilder.Entity<SignIn>(entity => { @@ -6005,6 +6932,445 @@ entity.Property(e => e.StratTime).HasColumnType("datetime"); }); #endregion + + + modelBuilder.Entity<TChallengeItem>(entity => + { + entity.ToTable("t_challenge_items"); + + entity.Property(e => e.Id).HasColumnName("id"); + + entity.Property(e => e.ChallengeId) + .HasMaxLength(50) + .HasColumnName("challenge_id"); + + entity.Property(e => e.Evidential) + .HasMaxLength(300) + .HasColumnName("evidential"); + + entity.Property(e => e.Law) + .HasMaxLength(300) + .HasColumnName("law"); + + entity.Property(e => e.Lawcoment) + .HasMaxLength(300) + .HasColumnName("lawcoment"); + + entity.Property(e => e.Question) + .HasMaxLength(300) + .HasColumnName("question"); + + entity.Property(e => e.Sort).HasColumnName("sort"); + }); + + modelBuilder.Entity<TChallengeletter>(entity => + { + entity.ToTable("t_challengeletter"); + + entity.Property(e => e.Id) + .HasMaxLength(50) + .HasColumnName("id"); + + entity.Property(e => e.Creater) + .HasMaxLength(50) + .HasColumnName("creater"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime"); + + entity.Property(e => e.DocumentsDate) + .HasColumnType("datetime") + .HasColumnName("documents_date"); + + entity.Property(e => e.GysAddress) + .HasMaxLength(100) + .HasColumnName("gys_address"); + + entity.Property(e => e.GysContacts) + .HasMaxLength(30) + .HasColumnName("gys_contacts"); + + entity.Property(e => e.GysId) + .HasMaxLength(50) + .HasColumnName("gys_id"); + + entity.Property(e => e.GysName) + .HasMaxLength(50) + .HasColumnName("gys_name"); + + entity.Property(e => e.GysPhone) + .HasMaxLength(30) + .HasColumnName("gys_phone"); + + entity.Property(e => e.GysPostcode) + .HasMaxLength(10) + .HasColumnName("gys_postcode"); + + entity.Property(e => e.IsReply).HasColumnName("is_reply"); + + entity.Property(e => e.Modifier) + .HasMaxLength(50) + .HasColumnName("modifier"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime"); + + entity.Property(e => e.OrderId) + .HasMaxLength(50) + .HasColumnName("order_id"); + + entity.Property(e => e.PrintNum).HasColumnName("print_num"); + + entity.Property(e => e.PurchaserName) + .HasMaxLength(50) + .HasColumnName("purchaser_name"); + + entity.Property(e => e.RequestInfo) + .HasMaxLength(300) + .HasColumnName("request_info"); + + entity.Property(e => e.RespondDate) + .HasColumnType("datetime") + .HasColumnName("respond_date"); + + entity.Property(e => e.RespondInfo) + .HasMaxLength(500) + .HasColumnName("respond_info"); + + entity.Property(e => e.Respondent) + .HasMaxLength(50) + .HasColumnName("respondent"); + + entity.Property(e => e.SqdbAddress) + .HasMaxLength(100) + .HasColumnName("sqdb_address"); + + entity.Property(e => e.SqdbId) + .HasMaxLength(50) + .HasColumnName("sqdb_id"); + + entity.Property(e => e.SqdbName) + .HasMaxLength(50) + .HasColumnName("sqdb_name"); + + entity.Property(e => e.SqdbPhone) + .HasMaxLength(30) + .HasColumnName("sqdb_phone"); + + entity.Property(e => e.SqdbPostcode) + .HasMaxLength(10) + .HasColumnName("sqdb_postcode"); + + entity.Property(e => e.Status).HasColumnName("status"); + + entity.Property(e => e.XmCode) + .HasMaxLength(30) + .HasColumnName("xm_code"); + + entity.Property(e => e.XmId) + .HasMaxLength(50) + .HasColumnName("xm_id"); + + entity.Property(e => e.XmName) + .HasMaxLength(100) + .HasColumnName("xm_name"); + + entity.Property(e => e.XmPackage) + .HasMaxLength(30) + .HasColumnName("xm_package"); + }); + + modelBuilder.Entity<TComplaintItem>(entity => + { + entity.ToTable("t_complaint_items"); + + entity.Property(e => e.Id).HasColumnName("id"); + + entity.Property(e => e.ComplaintId) + .HasMaxLength(50) + .HasColumnName("complaint_id"); + + entity.Property(e => e.Evidential) + .HasMaxLength(300) + .HasColumnName("evidential"); + + entity.Property(e => e.Law) + .HasMaxLength(300) + .HasColumnName("law"); + + entity.Property(e => e.Lawcoment) + .HasMaxLength(300) + .HasColumnName("lawcoment"); + + entity.Property(e => e.Question) + .HasMaxLength(300) + .HasColumnName("question"); + + entity.Property(e => e.Sort).HasColumnName("sort"); + }); + + modelBuilder.Entity<TComplaintRespondent>(entity => + { + entity.ToTable("t_complaint_respondents"); + + entity.Property(e => e.Id).HasColumnName("id"); + + entity.Property(e => e.Address) + .HasMaxLength(100) + .HasColumnName("address"); + + entity.Property(e => e.ComplaintId) + .HasMaxLength(50) + .HasColumnName("complaint_id"); + + entity.Property(e => e.Contacts) + .HasMaxLength(30) + .HasColumnName("contacts"); + + entity.Property(e => e.Phone) + .HasMaxLength(30) + .HasColumnName("phone"); + + entity.Property(e => e.Postcode) + .HasMaxLength(10) + .HasColumnName("postcode"); + + entity.Property(e => e.Respondent) + .HasMaxLength(50) + .HasColumnName("respondent"); + + entity.Property(e => e.Sort).HasColumnName("sort"); + }); + + modelBuilder.Entity<TComplaintletter>(entity => + { + entity.ToTable("t_complaintletter"); + + entity.Property(e => e.Id) + .HasMaxLength(50) + .HasColumnName("id"); + + entity.Property(e => e.Agency) + .HasMaxLength(50) + .HasColumnName("agency"); + + entity.Property(e => e.ChallengeDate) + .HasColumnType("datetime") + .HasColumnName("challenge_date"); + + entity.Property(e => e.Creater) + .HasMaxLength(50) + .HasColumnName("creater"); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime"); + + entity.Property(e => e.DocumentsDate) + .HasColumnType("datetime") + .HasColumnName("documents_date"); + + entity.Property(e => e.GysAddress) + .HasMaxLength(100) + .HasColumnName("gys_address"); + + entity.Property(e => e.GysContacts) + .HasMaxLength(30) + .HasColumnName("gys_contacts"); + + entity.Property(e => e.GysId) + .HasMaxLength(50) + .HasColumnName("gys_id"); + + entity.Property(e => e.GysName) + .HasMaxLength(50) + .HasColumnName("gys_name"); + + entity.Property(e => e.GysPhone) + .HasMaxLength(30) + .HasColumnName("gys_phone"); + + entity.Property(e => e.GysPostcode) + .HasMaxLength(10) + .HasColumnName("gys_postcode"); + + entity.Property(e => e.IsNotice) + .HasMaxLength(1) + .HasColumnName("is_notice"); + + entity.Property(e => e.IsResultnotice) + .HasMaxLength(1) + .HasColumnName("is_resultnotice"); + + entity.Property(e => e.Modifier) + .HasMaxLength(50) + .HasColumnName("modifier"); + + entity.Property(e => e.Modifytime) + .HasColumnType("datetime") + .HasColumnName("modifytime"); + + entity.Property(e => e.NoticeDate) + .HasColumnType("datetime") + .HasColumnName("notice_date"); + + entity.Property(e => e.OrderId) + .HasMaxLength(50) + .HasColumnName("order_id"); + + entity.Property(e => e.PrintNum).HasColumnName("print_num"); + + entity.Property(e => e.PurchaserName) + .HasMaxLength(50) + .HasColumnName("purchaser_name"); + + entity.Property(e => e.Questioned) + .HasMaxLength(300) + .HasColumnName("questioned"); + + entity.Property(e => e.RequestInfo) + .HasMaxLength(300) + .HasColumnName("request_info"); + + entity.Property(e => e.RespondDate) + .HasColumnType("datetime") + .HasColumnName("respond_date"); + + entity.Property(e => e.Respondent) + .HasMaxLength(300) + .HasColumnName("respondent"); + + entity.Property(e => e.ResultnoticeDate) + .HasColumnType("datetime") + .HasColumnName("resultnotice_date"); + + entity.Property(e => e.SqdbAddress) + .HasMaxLength(100) + .HasColumnName("sqdb_address"); + + entity.Property(e => e.SqdbId) + .HasMaxLength(50) + .HasColumnName("sqdb_id"); + + entity.Property(e => e.SqdbName) + .HasMaxLength(50) + .HasColumnName("sqdb_name"); + + entity.Property(e => e.SqdbPhone) + .HasMaxLength(30) + .HasColumnName("sqdb_phone"); + + entity.Property(e => e.SqdbPostcode) + .HasMaxLength(10) + .HasColumnName("sqdb_postcode"); + + entity.Property(e => e.Status).HasColumnName("status"); + + entity.Property(e => e.TsrAddress) + .HasMaxLength(100) + .HasColumnName("tsr_address"); + + entity.Property(e => e.TsrCorporation) + .HasMaxLength(30) + .HasColumnName("tsr_corporation"); + + entity.Property(e => e.TsrId) + .HasMaxLength(50) + .HasColumnName("tsr_id"); + + entity.Property(e => e.TsrName) + .HasMaxLength(50) + .HasColumnName("tsr_name"); + + entity.Property(e => e.TsrPhone) + .HasMaxLength(30) + .HasColumnName("tsr_phone"); + + entity.Property(e => e.TsrPostcode) + .HasMaxLength(10) + .HasColumnName("tsr_postcode"); + + entity.Property(e => e.XmCode) + .HasMaxLength(30) + .HasColumnName("xm_code"); + + entity.Property(e => e.XmId) + .HasMaxLength(50) + .HasColumnName("xm_id"); + + entity.Property(e => e.XmName) + .HasMaxLength(100) + .HasColumnName("xm_name"); + + entity.Property(e => e.XmPackage) + .HasMaxLength(30) + .HasColumnName("xm_package"); + }); + + modelBuilder.Entity<TComplaintGongyingshang>(entity => + { + entity.ToTable("t_complaint_gongyingshang"); + + entity.Property(e => e.Id).HasColumnName("id"); + + entity.Property(e => e.ComplaintId) + .HasMaxLength(50) + .HasColumnName("complaint_id"); + + entity.Property(e => e.Dizhi) + .HasMaxLength(300) + .HasColumnName("dizhi"); + + entity.Property(e => e.Gongytingshang) + .HasMaxLength(300) + .HasColumnName("gongytingshang"); + + entity.Property(e => e.Lianxidianhua) + .HasMaxLength(300) + .HasColumnName("lianxidianhua"); + + entity.Property(e => e.Lianxiren) + .HasMaxLength(300) + .HasColumnName("lianxiren"); + + entity.Property(e => e.Sort).HasColumnName("sort"); + + entity.Property(e => e.Youbian) + .HasMaxLength(300) + .HasColumnName("youbian"); + }); + + modelBuilder.Entity<TComplaintShouquandaibiao>(entity => + { + entity.ToTable("t_complaint_shouquandaibiao"); + + entity.Property(e => e.Id).HasColumnName("id"); + + entity.Property(e => e.ComplaintId) + .HasMaxLength(50) + .HasColumnName("complaint_id"); + + entity.Property(e => e.Dizhi) + .HasMaxLength(300) + .HasColumnName("dizhi"); + + entity.Property(e => e.Lianxidianhua) + .HasMaxLength(300) + .HasColumnName("lianxidianhua"); + + entity.Property(e => e.Shouquandaibiao) + .HasMaxLength(300) + .HasColumnName("shouquandaibiao"); + + entity.Property(e => e.Sort).HasColumnName("sort"); + + entity.Property(e => e.Youbian) + .HasMaxLength(300) + .HasColumnName("youbian"); + }); + OnModelCreatingPartial(modelBuilder); } -- Gitblit v1.9.1