From 0c7b13e91cd472e21e4a620355e6fcabc11f695a Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期二, 04 一月 2022 13:56:24 +0800
Subject: [PATCH] 计件登记，汇总，打印
---
zhengcaioa/Model/zhengcaioaContext.cs | 603 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 600 insertions(+), 3 deletions(-)
diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs
index e07f6f2..f569e87 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,25 @@
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)
@@ -3751,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");
@@ -5632,7 +5689,7 @@
entity.Property(e => e.Comments)
.IsRequired()
- .HasMaxLength(50)
+ .HasMaxLength(100)
.HasColumnName("comments");
entity.Property(e => e.Contents)
@@ -6239,7 +6296,6 @@
.HasColumnName("expertType");
entity.Property(e => e.IdCard)
- .IsRequired()
.HasMaxLength(18)
.HasColumnName("idCard");
@@ -6291,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");
@@ -6298,7 +6358,6 @@
entity.Property(e => e.ReviewItem).HasMaxLength(50);
entity.Property(e => e.Sex)
- .IsRequired()
.HasMaxLength(50)
.HasColumnName("sex");
@@ -6466,6 +6525,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 +6678,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 +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