From db227144dedfb5fb5b1e94e8c8b14eab9eb7462f Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期四, 01 十二月 2022 13:32:50 +0800 Subject: [PATCH] 中国政采网的四川数据 发送验证码 --- zhengcaioa/Model/zhengcaioaContext.cs | 282 ++++++++++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 274 insertions(+), 8 deletions(-) diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs index a30d55d..3cce961 100644 --- a/zhengcaioa/Model/zhengcaioaContext.cs +++ b/zhengcaioa/Model/zhengcaioaContext.cs @@ -49,6 +49,7 @@ 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; } @@ -131,6 +132,7 @@ 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; } @@ -138,12 +140,15 @@ 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"); } } @@ -1774,6 +1779,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"); @@ -2198,6 +2219,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) @@ -2641,6 +2674,9 @@ entity.Property(e => e.Shenyushouxin) .HasColumnType("money") .HasColumnName("shenyushouxin"); + entity.Property(e => e.Taocanjianshu) + .HasColumnType("int") + .HasColumnName("taocanjianshu"); }); modelBuilder.Entity<CusFangwenjilu>(entity => @@ -3110,6 +3146,10 @@ .HasColumnName("danjia") .HasComment("鍗曚环"); + entity.Property(e => e.Jifen) + .HasColumnType("money") + .HasColumnName("jifen"); + entity.Property(e => e.Modifier) .IsRequired() .HasMaxLength(50) @@ -3149,6 +3189,10 @@ .HasColumnType("money") .HasColumnName("huifei") .HasComment("浼氳垂"); + + entity.Property(e => e.Jifen) + .HasColumnType("money") + .HasColumnName("jifen"); entity.Property(e => e.MemberAuthority) .HasMaxLength(500) @@ -3199,6 +3243,10 @@ .HasColumnType("money") .HasColumnName("feiyong") .HasComment("璐圭敤"); + + entity.Property(e => e.Jifen) + .HasColumnType("money") + .HasColumnName("jifen"); entity.Property(e => e.Modifier) .IsRequired() @@ -4645,6 +4693,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 => @@ -4677,6 +4733,10 @@ 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) @@ -5200,6 +5260,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) @@ -5379,6 +5441,10 @@ .HasDefaultValueSql("('')") .HasComment("閲囪喘浜哄悕绉�"); + entity.Property(e => e.Caigouyusuan) + .HasColumnType("money") + .HasColumnName("caigouyusuan"); + entity.Property(e => e.Cgfs) .HasMaxLength(50) .HasColumnName("cgfs"); @@ -5416,6 +5482,30 @@ .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"); @@ -5423,10 +5513,6 @@ entity.Property(e => e.DrhxDefen) .HasColumnType("money") .HasColumnName("drhx_defen"); - - entity.Property(e => e.Caigouyusuan) - .HasColumnType("money") - .HasColumnName("caigouyusuan"); entity.Property(e => e.DrhxPrice) .HasMaxLength(500) @@ -5443,6 +5529,30 @@ 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); @@ -5534,6 +5644,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 => @@ -5557,6 +5691,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 => @@ -5570,6 +5728,10 @@ .HasMaxLength(50) .HasColumnName("zhongbiaoId"); + entity.Property(e => e.Defen) + .HasColumnType("money") + .HasColumnName("defen"); + entity.Property(e => e.Names) .HasMaxLength(500) .HasColumnName("names"); @@ -5582,8 +5744,29 @@ .IsRequired() .HasMaxLength(50); - entity.Property(e => e.Defen).HasColumnType("money") - .HasColumnName("defen"); ; + 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 => @@ -5776,7 +5959,7 @@ .HasColumnName("comments"); entity.Property(e => e.Contents) - .HasMaxLength(300) + .HasMaxLength(500) .HasColumnName("contents"); entity.Property(e => e.Creater) @@ -7043,6 +7226,10 @@ .HasMaxLength(300) .HasColumnName("question"); + entity.Property(e => e.Questionname) + .HasMaxLength(500) + .HasColumnName("questionname"); + entity.Property(e => e.Sort).HasColumnName("sort"); }); @@ -7165,6 +7352,25 @@ .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"); @@ -7190,6 +7396,10 @@ 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"); }); @@ -7454,6 +7664,62 @@ .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