From e9f8d150668099ffe648b7c9ab9df290c3276db8 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期一, 29 十一月 2021 14:05:22 +0800 Subject: [PATCH] 提交 --- zhengcaioa/Model/zhengcaioaContext.cs | 527 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 524 insertions(+), 3 deletions(-) diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs index e07f6f2..e60d401 100644 --- a/zhengcaioa/Model/zhengcaioaContext.cs +++ b/zhengcaioa/Model/zhengcaioaContext.cs @@ -77,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; } @@ -117,12 +118,23 @@ 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; } + + protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { if (!optionsBuilder.IsConfigured) @@ -3751,6 +3763,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"); @@ -5632,7 +5687,7 @@ entity.Property(e => e.Comments) .IsRequired() - .HasMaxLength(50) + .HasMaxLength(100) .HasColumnName("comments"); entity.Property(e => e.Contents) @@ -6239,7 +6294,6 @@ .HasColumnName("expertType"); entity.Property(e => e.IdCard) - .IsRequired() .HasMaxLength(18) .HasColumnName("idCard"); @@ -6291,6 +6345,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"); @@ -6298,7 +6356,6 @@ entity.Property(e => e.ReviewItem).HasMaxLength(50); entity.Property(e => e.Sex) - .IsRequired() .HasMaxLength(50) .HasColumnName("sex"); @@ -6466,6 +6523,10 @@ .HasColumnName("createtime") .HasDefaultValueSql("(getdate())"); + entity.Property(e => e.Jiexi) + .HasMaxLength(4000) + .HasColumnName("jiexi"); + entity.Property(e => e.JiexiStatus) .HasMaxLength(1) .HasColumnName("jiexi_status") @@ -6615,6 +6676,101 @@ 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 琛屾斂绠$悊瀹炰綋绫� @@ -6774,6 +6930,371 @@ 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.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.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).HasColumnName("is_notice"); + + entity.Property(e => e.IsResultnotice).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(50) + .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(50) + .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"); + }); + OnModelCreatingPartial(modelBuilder); } -- Gitblit v1.9.1