From 5421f9a6e5e2b28cc32aa8aa6dec9becd0c1eb3c Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期三, 04 一月 2023 10:19:57 +0800 Subject: [PATCH] 业务经理意向和合作客户只能1000,90天意向不转合作就制空业务经理,查询没有业务经理的档案客户和合作客户 --- zhengcaioa/Model/zhengcaioaContext.cs | 2635 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 2,627 insertions(+), 8 deletions(-) diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs index 17456be..cde8ff5 100644 --- a/zhengcaioa/Model/zhengcaioaContext.cs +++ b/zhengcaioa/Model/zhengcaioaContext.cs @@ -21,30 +21,51 @@ public virtual DbSet<SimBindView> SimBindView { get; set; } public virtual DbSet<SimCost> SimCost { get; set; } public virtual DbSet<SimCostView> SimCostView { get; set; } + 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<AdmAskzczbwsy> AdmAskzczbwsies { get; set; } + public virtual DbSet<AdmAskzczbwsydtl> AdmAskzczbwsydtls { 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; } public virtual DbSet<AdmDocBase> AdmDocBases { get; set; } public virtual DbSet<AdmDocDoc> AdmDocDocs { get; set; } public virtual DbSet<AdmEvaluate> AdmEvaluates { get; set; } + public virtual DbSet<AdmPhoneMessage> AdmPhoneMessages { get; set; } 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; } public virtual DbSet<CooperVisit> CooperVisits { get; set; } public virtual DbSet<CooperatecustomCustomer> CooperatecustomCustomers { get; set; } + public virtual DbSet<CusFangwenjilu> CusFangwenjilus { get; set; } public virtual DbSet<FiAccount> FiAccounts { get; set; } public virtual DbSet<FiAccountRecord> FiAccountRecords { get; set; } + public virtual DbSet<FiCustomerrecievemoney> FiCustomerrecievemoneys { get; set; } public virtual DbSet<FiOrderrecievemoney> FiOrderrecievemoneys { get; set; } public virtual DbSet<FiPiecerate> FiPiecerates { get; set; } public virtual DbSet<FiSubject> FiSubjects { get; set; } @@ -60,11 +81,18 @@ 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; } + public virtual DbSet<IntentionVisitDuanxin> IntentionVisitDuanxins { get; set; } public virtual DbSet<Liaotian> Liaotians { get; set; } + public virtual DbSet<LiaotianShoucang> LiaotianShoucangs { get; set; } + public virtual DbSet<LZhuanjiahuidum> LZhuanjiahuida { get; set; } public virtual DbSet<Oayouhui> Oayouhuis { get; set; } + public virtual DbSet<OrderBanci> OrderBancis { get; set; } + public virtual DbSet<OrderBanciDtl> OrderBanciDtls { get; set; } + public virtual DbSet<OrderBanciOrder> OrderBanciOrders { get; set; } public virtual DbSet<PltAuth> PltAuths { get; set; } public virtual DbSet<PltPage> PltPages { get; set; } public virtual DbSet<PltRole> PltRoles { get; set; } @@ -77,9 +105,11 @@ 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; } + public virtual DbSet<SysUpdatetime> SysUpdatetimes { get; set; } public virtual DbSet<WfApplytype> WfApplytypes { get; set; } public virtual DbSet<WfHistory> WfHistories { get; set; } public virtual DbSet<WfLog> WfLogs { get; set; } @@ -89,24 +119,492 @@ 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<TChallengeRequestInfo> TChallengeRequestInfos { 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; } + + + public virtual DbSet<Zxdsfxl> Zxdsfxls { get; set; } + + protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { if (!optionsBuilder.IsConfigured) { #warning To protect potentially sensitive information in your connection string, you should move it out of source code. You can avoid scaffolding the connection string by using the Name= syntax to read it from configuration - see https://go.microsoft.com/fwlink/?linkid=2131148. For more guidance on storing connection strings, see http://go.microsoft.com/fwlink/?LinkId=723263. - optionsBuilder.UseSqlServer("Data Source=.;Initial Catalog=zhengcaioa;User ID=sa;Password=123456"); + optionsBuilder.UseSqlServer("Data Source=172.26.97.147;Initial Catalog=zhengcaioa;User ID=sa;Password=Za20222812"); } } 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 => + { + entity.ToTable("ADM_AskCar"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.CarLaiyuan).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.Feiyong) + .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.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<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) + .HasColumnName("shenpi_status") + .HasDefaultValueSql("('D')"); + + entity.Property(e => e.Tittle) + .HasMaxLength(50) + .HasColumnName("tittle"); + }); + + modelBuilder.Entity<AdmAskcost>(entity => + { + entity.ToTable("ADM_Askcost"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Cost) + .HasColumnType("money") + .HasDefaultValueSql("((0))"); + + 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<AdmAskGood>(entity => + { + entity.ToTable("ADM_AskGoods"); + + 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.GoodsId).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.Shuliang) + .HasColumnType("money") + .HasDefaultValueSql("((0))"); + + 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 => { entity.ToTable("ADM_AskLeave"); @@ -239,6 +737,260 @@ entity.Property(e => e.Tittle) .HasMaxLength(100) .HasColumnName("tittle"); + }); + + modelBuilder.Entity<AdmAskovertime>(entity => + { + entity.ToTable("ADM_Askovertime"); + + 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.Jiabantime) + .HasColumnType("datetime") + .HasColumnName("jiabantime"); + + 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.Overtime) + .HasColumnType("money") + .HasColumnName("overtime") + .HasDefaultValueSql("((0))"); + + 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<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<AdmAskzczbwsy>(entity => + { + entity.ToTable("ADM_Askzczbwsy"); + + 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.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.Shiyongstandard) + .HasMaxLength(50) + .HasColumnName("shiyongstandard"); + + entity.Property(e => e.Tittle) + .HasMaxLength(50) + .HasColumnName("tittle"); + }); + + modelBuilder.Entity<AdmAskzczbwsydtl>(entity => + { + entity.ToTable("ADM_Askzczbwsydtl"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.AskzczbwsyId) + .IsRequired() + .HasMaxLength(50); + + entity.Property(e => e.CustomerId).HasMaxLength(50); + + entity.Property(e => e.Customertype).HasMaxLength(50); + + entity.Property(e => e.Customername).HasMaxLength(500); + + entity.Property(e => e.Phone) + .HasMaxLength(500) + .HasColumnName("phone"); + }); + + modelBuilder.Entity<AdmAskMarketingCost>(entity => + { + entity.ToTable("ADM_AskMarketingCost"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.BreakPrecedentId) + .HasMaxLength(50) + .HasColumnName("break_precedentId"); + + 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.Feiyong) + .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.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.ToUserId).HasMaxLength(50); }); modelBuilder.Entity<AdmAttendance>(entity => @@ -665,6 +1417,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"); @@ -1032,6 +1856,22 @@ .HasComment("浜哄憳id"); }); + modelBuilder.Entity<AdmPhoneMessage>(entity => + { + entity.ToTable("ADM_PhoneMessage"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime") + .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.Phone).HasMaxLength(50); + entity.Property(e => e.Message).HasColumnName("message").HasMaxLength(100); + + }); + modelBuilder.Entity<AdmGoodsClassify>(entity => { entity.ToTable("adm_goods_classify"); @@ -1110,6 +1950,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") @@ -1125,6 +1969,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() @@ -1198,6 +2047,10 @@ .HasColumnName("remark") .HasComment("宸ヤ綔鍐呭"); + entity.Property(e => e.Shuliang) + .HasColumnType("money") + .HasColumnName("shuliang"); + entity.Property(e => e.UserId) .HasMaxLength(50) .HasColumnName("userId") @@ -1213,6 +2066,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 => @@ -1287,6 +2250,14 @@ .HasColumnName("createtime") .HasDefaultValueSql("(getdate())"); + entity.Property(e => e.HuifangJdr) + .HasMaxLength(100) + .HasColumnName("huifang_jdr"); + + entity.Property(e => e.HuifangKehuyijian) + .HasMaxLength(500) + .HasColumnName("huifang_kehuyijian"); + entity.Property(e => e.HuifangStatus) .HasMaxLength(2) .HasColumnName("huifang_status") @@ -1325,6 +2296,18 @@ .HasColumnType("numeric(18, 2)") .HasColumnName("money") .HasComment("閲戦"); + + entity.Property(e => e.Jichumoney) + .HasColumnType("numeric(18, 2)") + .HasColumnName("jichumoney"); + + entity.Property(e => e.Xmcode) + .HasMaxLength(50) + .HasColumnName("xmcode"); + + entity.Property(e => e.Xmname) + .HasMaxLength(500) + .HasColumnName("xmname"); entity.Property(e => e.OrderNo) .HasMaxLength(100) @@ -1413,11 +2396,23 @@ .HasColumnName("shr_tel") .HasComment("鑱旂郴鐢佃瘽"); + entity.Property(e => e.SonghuoDanhao) + .HasMaxLength(100) + .HasColumnName("songhuo_danhao"); + + entity.Property(e => e.SonghuoGongsi) + .HasMaxLength(100) + .HasColumnName("songhuo_gongsi"); + entity.Property(e => e.SonghuoStatus) .HasMaxLength(2) .HasColumnName("songhuo_status") .HasDefaultValueSql("('D')") .HasComment("閫佽揣鐘舵��"); + + entity.Property(e => e.SonghuoTime1) + .HasColumnType("datetime") + .HasColumnName("songhuo_time"); entity.Property(e => e.Songhuoer) .HasMaxLength(50) @@ -1607,6 +2602,11 @@ .HasColumnName("f_tel") .HasComment("鑱旂郴鐢佃瘽"); + entity.Property(e => e.HuiyuanId) + .HasMaxLength(50) + .HasColumnName("huiyuanId") + .HasComment("浼氬憳Id"); + entity.Property(e => e.Hyfl) .HasMaxLength(50) .HasColumnName("hyfl") @@ -1679,6 +2679,10 @@ .HasColumnName("sheng") .HasComment("鐪�"); + entity.Property(e => e.Shifoutianjiaweixin) + .HasMaxLength(1) + .HasColumnName("shifoutianjiaweixin"); + entity.Property(e => e.ShrAddress) .HasMaxLength(500) .HasColumnName("shr_address") @@ -1704,6 +2708,22 @@ .HasColumnName("url") .HasComment("缃戝潃"); + entity.Property(e => e.Weixin) + .HasMaxLength(50) + .HasColumnName("weixin"); + + entity.Property(e => e.Weixiner) + .HasMaxLength(50) + .HasColumnName("weixiner"); + + entity.Property(e => e.Weixintime) + .HasColumnType("datetime") + .HasColumnName("weixintime"); + + entity.Property(e => e.Ywjltime) + .HasColumnType("datetime") + .HasColumnName("ywjltime"); + entity.Property(e => e.YwName) .HasMaxLength(500) .HasColumnName("yw_name") @@ -1723,6 +2743,68 @@ .HasMaxLength(50) .HasColumnName("ywjl") .HasComment("涓氬姟缁忕悊"); + + entity.Property(e => e.Yufukuan) + .HasColumnType("money") + .HasColumnName("yufukuan"); + + entity.Property(e => e.Shouxinedu) + .HasColumnType("money") + .HasColumnName("shouxinedu"); + + entity.Property(e => e.Shenyushouxin) + .HasColumnType("money") + .HasColumnName("shenyushouxin"); + entity.Property(e => e.Taocanjianshu) + .HasColumnType("int") + .HasColumnName("taocanjianshu"); + }); + + modelBuilder.Entity<CusFangwenjilu>(entity => + { + entity.ToTable("cus_fangwenjilu"); + + 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.Fasongfangshi) + .HasMaxLength(50) + .HasColumnName("fasongfangshi"); + + entity.Property(e => e.Fasongneirong) + .HasMaxLength(4000) + .HasColumnName("fasongneirong"); + + entity.Property(e => e.Jieshouren) + .HasMaxLength(2000) + .HasColumnName("jieshouren"); + + 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<FiAccount>(entity => @@ -1850,6 +2932,72 @@ entity.Property(e => e.RecordTypeId).HasMaxLength(50); entity.Property(e => e.Remark).HasMaxLength(500); + + entity.Property(e => e.SubjectId).HasMaxLength(50); + }); + + modelBuilder.Entity<FiCustomerrecievemoney>(entity => + { + entity.ToTable("fi_Customerrecievemoney"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.AccountId).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.CustomerId) + .HasMaxLength(50) + .HasComment("瀹㈡埛id"); + + 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.PayTime) + .HasColumnType("datetime") + .HasColumnName("pay_time") + .HasDefaultValueSql("(getdate())") + .HasComment("鏀舵鏃ユ湡"); + + entity.Property(e => e.PayType) + .HasMaxLength(50) + .HasColumnName("pay_type") + .HasComment("鏀舵鏂瑰紡"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Recievemoney) + .HasColumnType("numeric(18, 2)") + .HasColumnName("recievemoney") + .HasComment("鏀舵閲戦"); + + entity.Property(e => e.RecordTypeId).HasMaxLength(50); + + entity.Property(e => e.Remark) + .HasMaxLength(4000) + .HasColumnName("remark") + .HasComment("鏀舵澶囨敞"); entity.Property(e => e.SubjectId).HasMaxLength(50); }); @@ -2079,6 +3227,10 @@ .HasColumnName("danjia") .HasComment("鍗曚环"); + entity.Property(e => e.Jifen) + .HasColumnType("money") + .HasColumnName("jifen"); + entity.Property(e => e.Modifier) .IsRequired() .HasMaxLength(50) @@ -2119,8 +3271,12 @@ .HasColumnName("huifei") .HasComment("浼氳垂"); + entity.Property(e => e.Jifen) + .HasColumnType("money") + .HasColumnName("jifen"); + entity.Property(e => e.MemberAuthority) - .HasMaxLength(100) + .HasMaxLength(500) .HasColumnName("member_authority") .HasComment("浼氬憳鏉冮檺"); @@ -2168,6 +3324,10 @@ .HasColumnType("money") .HasColumnName("feiyong") .HasComment("璐圭敤"); + + entity.Property(e => e.Jifen) + .HasColumnType("money") + .HasColumnName("jifen"); entity.Property(e => e.Modifier) .IsRequired() @@ -2813,6 +3973,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"); @@ -2851,6 +4054,10 @@ .HasColumnType("datetime") .HasColumnName("createtime") .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.Dianxiaozhuanyuan) + .HasMaxLength(50) + .HasColumnName("dianxiaozhuanyuan"); entity.Property(e => e.Email) .HasMaxLength(500) @@ -2891,6 +4098,10 @@ .HasMaxLength(50) .HasColumnName("khlx") .HasComment("瀹㈡埛绫诲瀷"); + + entity.Property(e => e.HuiyuanId) + .HasMaxLength(50) + .HasColumnName("huiyuanId"); entity.Property(e => e.Khly) .HasMaxLength(50) @@ -2944,6 +4155,10 @@ .HasColumnName("sheng") .HasComment("鐪�"); + entity.Property(e => e.Shifoutianjiaweixin) + .HasMaxLength(1) + .HasColumnName("shifoutianjiaweixin"); + entity.Property(e => e.ShrAddress) .HasMaxLength(500) .HasColumnName("shr_address") @@ -2969,6 +4184,26 @@ .HasColumnName("url") .HasComment("缃戝潃"); + entity.Property(e => e.Weixin) + .HasMaxLength(50) + .HasColumnName("weixin"); + + entity.Property(e => e.Weixiner) + .HasMaxLength(50) + .HasColumnName("weixiner"); + + entity.Property(e => e.Weixintime) + .HasColumnType("datetime") + .HasColumnName("weixintime"); + + entity.Property(e => e.Ywjltime) + .HasColumnType("datetime") + .HasColumnName("ywjltime"); + + entity.Property(e => e.Yixiang).HasMaxLength(50); + + entity.Property(e => e.Yixiangtime).HasColumnType("datetime"); + entity.Property(e => e.YwName) .HasMaxLength(500) .HasColumnName("yw_name") @@ -2988,6 +4223,10 @@ .HasMaxLength(50) .HasColumnName("ywjl") .HasComment("涓氬姟缁忕悊"); + + entity.Property(e => e.Zuijinzhuizongtime) + .HasColumnType("datetime") + .HasColumnName("zuijinzhuizongtime"); }); modelBuilder.Entity<IntentionOrder>(entity => @@ -3083,6 +4322,10 @@ .HasColumnName("createtime") .HasDefaultValueSql("(getdate())"); + entity.Property(e => e.DuanxinNeirong) + .HasMaxLength(500) + .HasColumnName("duanxin_neirong"); + entity.Property(e => e.Jdr) .HasMaxLength(500) .HasColumnName("jdr") @@ -3152,6 +4395,49 @@ .HasComment("鑱屽姟"); }); + modelBuilder.Entity<IntentionVisitDuanxin>(entity => + { + entity.ToTable("IntentionVisit_duanxin"); + + 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.DuanxinNeirong) + .HasMaxLength(500) + .HasColumnName("duanxin_neirong"); + + entity.Property(e => e.DuanxinTitle) + .HasMaxLength(50) + .HasColumnName("duanxin_title"); + + 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<Liaotian>(entity => { entity.ToTable("Liaotian"); @@ -3169,9 +4455,15 @@ .HasMaxLength(4000) .HasColumnName("anwser"); + entity.Property(e => e.ChushuStatus) + .HasMaxLength(1) + .HasColumnName("chushu_status") + .HasDefaultValueSql("('D')"); + entity.Property(e => e.Clientid) .HasMaxLength(50) - .HasColumnName("clientid"); + .HasColumnName("clientid") + .HasDefaultValueSql("('a')"); entity.Property(e => e.Creater) .IsRequired() @@ -3214,9 +4506,112 @@ .HasColumnName("rec_status") .HasDefaultValueSql("('a')"); + entity.Property(e => e.Shenheer) + .HasMaxLength(50) + .HasColumnName("shenheer"); + + entity.Property(e => e.Shenhetime) + .HasColumnType("datetime") + .HasColumnName("shenhetime"); + entity.Property(e => e.Shiyongfatiao) - .HasMaxLength(500) + .HasMaxLength(1000) .HasColumnName("shiyongfatiao"); + }); + modelBuilder.Entity<LiaotianShoucang>(entity => + { + entity.ToTable("Liaotian_shoucang"); + + 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.LiaotianId) + .HasMaxLength(50) + .HasColumnName("Liaotian_id"); + + 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<LZhuanjiahuidum>(entity => + { + entity.ToTable("l_zhuanjiahuida"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Anwser) + .HasMaxLength(4000) + .HasColumnName("anwser"); + + 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.Question) + .HasMaxLength(500) + .HasColumnName("question"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.HuidaStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("huida_status") + .HasDefaultValueSql("('D')"); + + entity.Property(e => e.Userid) + .HasMaxLength(50) + .HasColumnName("userid"); + + entity.Property(e => e.Username) + .HasMaxLength(100) + .HasColumnName("username"); }); modelBuilder.Entity<Oayouhui>(entity => @@ -3269,6 +4664,221 @@ entity.Property(e => e.Youtype) .HasMaxLength(50) .HasComment("浼樻儬绫诲瀷"); + }); + + modelBuilder.Entity<OrderBanci>(entity => + { + entity.ToTable("order_banci"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Mingcheng) + .HasMaxLength(100) + .HasColumnName("mingcheng"); + + entity.Property(e => e.Banci) + .HasMaxLength(100) + .HasColumnName("banci"); + + 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.Didian) + .HasMaxLength(500) + .HasColumnName("didian"); + + 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.Renshu) + .HasColumnName("renshu"); + + entity.Property(e => e.Shijian) + .HasColumnType("datetime") + .HasColumnName("shijian"); + + entity.Property(e => e.Shijianend) + .HasColumnType("datetime") + .HasColumnName("shijianend"); + }); + + modelBuilder.Entity<OrderBanciDtl>(entity => + { + entity.ToTable("order_banci_dtl"); + + 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.OrderBanciId) + .HasMaxLength(50) + .HasColumnName("order_banci_id"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Shangxiawu) + .HasMaxLength(100) + .HasColumnName("shangxiawu"); + + entity.Property(e => e.Shijian) + .HasMaxLength(100) + .HasColumnName("shijian"); + + entity.Property(e => e.Shixiamg) + .HasMaxLength(500) + .HasColumnName("shixiamg"); + + entity.Property(e => e.Sort) + .HasColumnName("sort") + .HasDefaultValueSql("((0))"); + + entity.Property(e => e.Zhujiangren) + .HasMaxLength(100) + .HasColumnName("zhujiangren"); + + entity.Property(e => e.Jiage) + .HasColumnType("numeric(18, 2)") + .HasColumnName("jiage"); + + entity.Property(e => e.Jifen) + .HasColumnType("numeric(18, 2)") + .HasColumnName("Jifen"); + }); + + modelBuilder.Entity<OrderBanciOrder>(entity => + { + entity.ToTable("order_banci_order"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.BanciId) + .HasMaxLength(50) + .HasColumnName("banci_id"); + + entity.Property(e => e.Baomingrenshu).HasColumnName("baomingrenshu"); + + entity.Property(e => e.Baomingtime) + .HasColumnType("datetime") + .HasColumnName("baomingtime"); + + 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.Jine) + .HasColumnType("money") + .HasColumnName("jine"); + + entity.Property(e => e.Jifen) + .HasColumnType("money") + .HasColumnName("jifen"); + + entity.Property(e => e.Kechengleixing) + .HasMaxLength(100) + .HasColumnName("kechengleixing"); + + entity.Property(e => e.KechengleixingId) + .HasMaxLength(50) + .HasColumnName("kechengleixing_id"); + + entity.Property(e => e.Lianxidianhua) + .HasMaxLength(100) + .HasColumnName("lianxidianhua"); + + 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.Peixunbanci) + .HasMaxLength(100) + .HasColumnName("peixunbanci"); + + entity.Property(e => e.PersonId) + .HasMaxLength(100) + .HasColumnName("person_id"); + + entity.Property(e => e.OrderId) + .HasMaxLength(100) + .HasColumnName("order_id"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .HasDefaultValueSql("('A')"); + + entity.Property(e => e.Shenfenzheng) + .HasMaxLength(100) + .HasColumnName("shenfenzheng"); + + entity.Property(e => e.Xingming) + .HasMaxLength(100) + .HasColumnName("xingming"); + + entity.Property(e => e.Xuefei) + .HasColumnType("money") + .HasColumnName("xuefei"); }); modelBuilder.Entity<PltAuth>(entity => @@ -3739,6 +5349,8 @@ entity.Property(e => e.ShiyongDateEnd).HasColumnType("datetime"); + entity.Property(e => e.HetongDateEnd).HasColumnType("datetime"); + entity.Property(e => e.ShiyongPrice).HasColumnType("numeric(18, 2)"); entity.Property(e => e.Tel) @@ -3775,6 +5387,10 @@ .HasColumnName("usernumber"); entity.Property(e => e.Weixin).HasMaxLength(50); + + entity.Property(e => e.Yaoqingma) + .HasMaxLength(50) + .HasColumnName("yaoqingma"); entity.Property(e => e.Zhengzhi).HasMaxLength(50); @@ -3885,6 +5501,7 @@ .HasMaxLength(50) .HasColumnName("userId"); }); + modelBuilder.Entity<Project>(entity => { entity.ToTable("Project"); @@ -3912,6 +5529,10 @@ .HasColumnName("caigourenname") .HasDefaultValueSql("('')") .HasComment("閲囪喘浜哄悕绉�"); + + entity.Property(e => e.Caigouyusuan) + .HasColumnType("money") + .HasColumnName("caigouyusuan"); entity.Property(e => e.Cgfs) .HasMaxLength(50) @@ -3950,9 +5571,37 @@ .HasDefaultValueSql("('')") .HasComment("閲囪喘浜哄悕绉�"); + entity.Property(e => e.DehxTousuchengli) + .HasMaxLength(1) + .HasColumnName("dehx_tousuchengli"); + + entity.Property(e => e.DehxTousushijian) + .HasColumnType("datetime") + .HasColumnName("dehx_tousushijian"); + + entity.Property(e => e.DehxTousustatus) + .HasMaxLength(1) + .HasColumnName("dehx_tousustatus"); + + entity.Property(e => e.DehxZhiyichengli) + .HasMaxLength(1) + .HasColumnName("dehx_zhiyichengli"); + + entity.Property(e => e.DehxZhiyishijian) + .HasColumnType("datetime") + .HasColumnName("dehx_zhiyishijian"); + + entity.Property(e => e.DehxZhiyistatus) + .HasMaxLength(1) + .HasColumnName("dehx_zhiyistatus"); + entity.Property(e => e.Drhx) .HasMaxLength(500) .HasColumnName("drhx"); + + entity.Property(e => e.DrhxDefen) + .HasColumnType("money") + .HasColumnName("drhx_defen"); entity.Property(e => e.DrhxPrice) .HasMaxLength(500) @@ -3962,9 +5611,37 @@ .HasMaxLength(500) .HasColumnName("dshx"); + entity.Property(e => e.DshxDefen) + .HasColumnType("money") + .HasColumnName("dshx_defen"); + entity.Property(e => e.DshxPrice) .HasMaxLength(500) .HasColumnName("dshx_price"); + + entity.Property(e => e.DshxTousuchengli) + .HasMaxLength(1) + .HasColumnName("dshx_tousuchengli"); + + entity.Property(e => e.DshxTousushijian) + .HasColumnType("datetime") + .HasColumnName("dshx_tousushijian"); + + entity.Property(e => e.DshxTousustatus) + .HasMaxLength(1) + .HasColumnName("dshx_tousustatus"); + + entity.Property(e => e.DshxZhiyichengli) + .HasMaxLength(1) + .HasColumnName("dshx_zhiyichengli"); + + entity.Property(e => e.DshxZhiyishijian) + .HasColumnType("datetime") + .HasColumnName("dshx_zhiyishijian"); + + entity.Property(e => e.DshxZhiyistatus) + .HasMaxLength(1) + .HasColumnName("dshx_zhiyistatus"); entity.Property(e => e.Fblx).HasMaxLength(500); @@ -3973,6 +5650,8 @@ entity.Property(e => e.Feibiaocishu) .HasMaxLength(100) .HasColumnName("feibiaocishu"); + + entity.Property(e => e.Fencha).HasColumnType("money"); entity.Property(e => e.Modifier) .IsRequired() @@ -4054,6 +5733,30 @@ entity.Property(e => e.Reasonremark) .HasMaxLength(500) .HasColumnName("reasonremark"); + + entity.Property(e => e.WxTousuchengli) + .HasMaxLength(1) + .HasColumnName("wx_tousuchengli"); + + entity.Property(e => e.WxTousushijian) + .HasColumnType("datetime") + .HasColumnName("wx_tousushijian"); + + entity.Property(e => e.WxTousustatus) + .HasMaxLength(1) + .HasColumnName("wx_tousustatus"); + + entity.Property(e => e.WxZhiyichengli) + .HasMaxLength(1) + .HasColumnName("wx_zhiyichengli"); + + entity.Property(e => e.WxZhiyishijian) + .HasColumnType("datetime") + .HasColumnName("wx_zhiyishijian"); + + entity.Property(e => e.WxZhiyistatus) + .HasMaxLength(1) + .HasColumnName("wx_zhiyistatus"); }); modelBuilder.Entity<Projectyouxiao>(entity => @@ -4077,6 +5780,30 @@ entity.Property(e => e.ProjectId) .IsRequired() .HasMaxLength(50); + + entity.Property(e => e.YxTousuchengli) + .HasMaxLength(1) + .HasColumnName("yx_tousuchengli"); + + entity.Property(e => e.YxTousushijian) + .HasColumnType("datetime") + .HasColumnName("yx_tousushijian"); + + entity.Property(e => e.YxTousustatus) + .HasMaxLength(1) + .HasColumnName("yx_tousustatus"); + + entity.Property(e => e.YxZhiyichengli) + .HasMaxLength(1) + .HasColumnName("yx_zhiyichengli"); + + entity.Property(e => e.YxZhiyishijian) + .HasColumnType("datetime") + .HasColumnName("yx_zhiyishijian"); + + entity.Property(e => e.YxZhiyistatus) + .HasMaxLength(1) + .HasColumnName("yx_zhiyistatus"); }); modelBuilder.Entity<Projectzhongbiao>(entity => @@ -4090,6 +5817,10 @@ .HasMaxLength(50) .HasColumnName("zhongbiaoId"); + entity.Property(e => e.Defen) + .HasColumnType("money") + .HasColumnName("defen"); + entity.Property(e => e.Names) .HasMaxLength(500) .HasColumnName("names"); @@ -4101,6 +5832,30 @@ entity.Property(e => e.ProjectId) .IsRequired() .HasMaxLength(50); + + entity.Property(e => e.ZbTousuchengli) + .HasMaxLength(1) + .HasColumnName("zb_tousuchengli"); + + entity.Property(e => e.ZbTousushijian) + .HasColumnType("datetime") + .HasColumnName("zb_tousushijian"); + + entity.Property(e => e.ZbTousustatus) + .HasMaxLength(1) + .HasColumnName("zb_tousustatus"); + + entity.Property(e => e.ZbZhiyichengli) + .HasMaxLength(1) + .HasColumnName("zb_zhiyichengli"); + + entity.Property(e => e.ZbZhiyishijian) + .HasColumnType("datetime") + .HasColumnName("zb_zhiyishijian"); + + entity.Property(e => e.ZbZhiyistatus) + .HasMaxLength(1) + .HasColumnName("zb_zhiyistatus"); }); modelBuilder.Entity<SysAttachment>(entity => @@ -4152,6 +5907,53 @@ .HasColumnType("datetime") .HasColumnName("modifytime") .HasDefaultValueSql("(getdate())"); + + entity.Property(e => e.RecStatus) + .IsRequired() + .HasMaxLength(1) + .HasColumnName("rec_status") + .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() @@ -4242,11 +6044,11 @@ entity.Property(e => e.Comments) .IsRequired() - .HasMaxLength(50) + .HasMaxLength(100) .HasColumnName("comments"); entity.Property(e => e.Contents) - .HasMaxLength(300) + .HasMaxLength(500) .HasColumnName("contents"); entity.Property(e => e.Creater) @@ -4396,6 +6198,23 @@ .HasColumnName("wedding_leave") .HasComment("濠氬亣澶╂暟"); }); + + modelBuilder.Entity<SysUpdatetime>(entity => + { + entity.ToTable("sys_updatetime"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Updatename) + .IsRequired() + .HasMaxLength(100) + .HasColumnName("updatename"); + + entity.Property(e => e.Updatetime) + .HasColumnType("datetime") + .HasColumnName("updatetime"); + }); + modelBuilder.Entity<WfApplytype>(entity => { entity.ToTable("wf_applytype"); @@ -4743,6 +6562,10 @@ .HasColumnName("danjuId") .HasComment("鍗曟嵁Id"); + entity.Property(e => e.Deelurl) + .HasMaxLength(500) + .HasColumnName("deelurl"); + entity.Property(e => e.Modifier) .IsRequired() .HasMaxLength(50) @@ -4828,7 +6651,6 @@ .HasColumnName("expertType"); entity.Property(e => e.IdCard) - .IsRequired() .HasMaxLength(18) .HasColumnName("idCard"); @@ -4880,6 +6702,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"); @@ -4887,7 +6713,6 @@ entity.Property(e => e.ReviewItem).HasMaxLength(50); entity.Property(e => e.Sex) - .IsRequired() .HasMaxLength(50) .HasColumnName("sex"); @@ -5033,6 +6858,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 => { @@ -5190,6 +7287,528 @@ 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(4000) + .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.Questionname) + .HasMaxLength(500) + .HasColumnName("questionname"); + + 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<TChallengeRequestInfo>(entity => + { + entity.ToTable("t_challenge_requestInfo"); + + entity.Property(e => e.Id).HasColumnName("id"); + + entity.Property(e => e.ChallengeId) + .HasMaxLength(50) + .HasColumnName("challenge_id"); + + entity.Property(e => e.RequestInfo) + .HasMaxLength(50) + .HasColumnName("requestInfo"); + + entity.Property(e => e.RequestInfoname) + .HasMaxLength(500) + .HasColumnName("requestInfoname"); + }); + + 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(4000) + .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.Questionname) + .HasMaxLength(500) + .HasColumnName("questionname"); + + 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"); + }); + + + modelBuilder.Entity<Zxdsfxl>(entity => + { + entity.ToTable("zxdsfxls"); + + 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.Huiyuanid) + .HasMaxLength(50) + .HasColumnName("huiyuanid"); + + entity.Property(e => e.Huiyuanname) + .HasMaxLength(100) + .HasColumnName("huiyuanname"); + + entity.Property(e => e.Leixing) + .HasMaxLength(1) + .HasColumnName("leixing"); + + 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.Token) + .HasMaxLength(500) + .HasColumnName("token"); + + entity.Property(e => e.Visittime) + .HasColumnType("datetime") + .HasColumnName("visittime"); + }); + OnModelCreatingPartial(modelBuilder); } -- Gitblit v1.9.1