From 727a27340fc49d41bf9f7efd81a9a44ade7a9677 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期二, 28 六月 2022 13:15:52 +0800 Subject: [PATCH] 合同盖章 --- zhengcaioa/Model/zhengcaioaContext.cs | 273 +++++++++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 266 insertions(+), 7 deletions(-) diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs index e60d401..564d792 100644 --- a/zhengcaioa/Model/zhengcaioaContext.cs +++ b/zhengcaioa/Model/zhengcaioaContext.cs @@ -62,6 +62,7 @@ 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; } @@ -133,6 +134,11 @@ 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) @@ -140,7 +146,7 @@ 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"); } } @@ -2196,6 +2202,18 @@ .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) .HasColumnName("order_no") @@ -2626,6 +2644,21 @@ .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 => @@ -2800,6 +2833,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); }); @@ -3029,6 +3128,10 @@ .HasColumnName("danjia") .HasComment("鍗曚环"); + entity.Property(e => e.Jifen) + .HasColumnType("money") + .HasColumnName("jifen"); + entity.Property(e => e.Modifier) .IsRequired() .HasMaxLength(50) @@ -3068,6 +3171,10 @@ .HasColumnType("money") .HasColumnName("huifei") .HasComment("浼氳垂"); + + entity.Property(e => e.Jifen) + .HasColumnType("money") + .HasColumnName("jifen"); entity.Property(e => e.MemberAuthority) .HasMaxLength(500) @@ -3118,6 +3225,10 @@ .HasColumnType("money") .HasColumnName("feiyong") .HasComment("璐圭敤"); + + entity.Property(e => e.Jifen) + .HasColumnType("money") + .HasColumnName("jifen"); entity.Property(e => e.Modifier) .IsRequired() @@ -4564,6 +4675,14 @@ 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 => @@ -4597,6 +4716,10 @@ .HasColumnType("money") .HasColumnName("jine"); + entity.Property(e => e.Jifen) + .HasColumnType("money") + .HasColumnName("jifen"); + entity.Property(e => e.Kechengleixing) .HasMaxLength(100) .HasColumnName("kechengleixing"); @@ -4627,6 +4750,10 @@ 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() @@ -5114,6 +5241,8 @@ entity.Property(e => e.ShiyongDate).HasColumnType("datetime"); entity.Property(e => e.ShiyongDateEnd).HasColumnType("datetime"); + + entity.Property(e => e.HetongDateEnd).HasColumnType("datetime"); entity.Property(e => e.ShiyongPrice).HasColumnType("numeric(18, 2)"); @@ -6943,12 +7072,16 @@ .HasColumnName("challenge_id"); entity.Property(e => e.Evidential) - .HasMaxLength(300) + .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) @@ -7087,12 +7220,16 @@ .HasColumnName("complaint_id"); entity.Property(e => e.Evidential) - .HasMaxLength(300) + .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) @@ -7186,9 +7323,13 @@ .HasMaxLength(10) .HasColumnName("gys_postcode"); - entity.Property(e => e.IsNotice).HasColumnName("is_notice"); + entity.Property(e => e.IsNotice) + .HasMaxLength(1) + .HasColumnName("is_notice"); - entity.Property(e => e.IsResultnotice).HasColumnName("is_resultnotice"); + entity.Property(e => e.IsResultnotice) + .HasMaxLength(1) + .HasColumnName("is_resultnotice"); entity.Property(e => e.Modifier) .HasMaxLength(50) @@ -7213,7 +7354,7 @@ .HasColumnName("purchaser_name"); entity.Property(e => e.Questioned) - .HasMaxLength(50) + .HasMaxLength(300) .HasColumnName("questioned"); entity.Property(e => e.RequestInfo) @@ -7225,7 +7366,7 @@ .HasColumnName("respond_date"); entity.Property(e => e.Respondent) - .HasMaxLength(50) + .HasMaxLength(300) .HasColumnName("respondent"); entity.Property(e => e.ResultnoticeDate) @@ -7295,6 +7436,124 @@ .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