From 0d96ff4e0833d6a2813a969e1ae0a48f27eee497 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期一, 27 三月 2023 14:24:05 +0800 Subject: [PATCH] 会员发送app后台消息 --- zhengcaioa/Model/zhengcaioaContext.cs | 431 +++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 424 insertions(+), 7 deletions(-) diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs index 4315705..cb8e88d 100644 --- a/zhengcaioa/Model/zhengcaioaContext.cs +++ b/zhengcaioa/Model/zhengcaioaContext.cs @@ -10,6 +10,7 @@ { public zhengcaioaContext() { + this.Database.SetCommandTimeout(60); } public zhengcaioaContext(DbContextOptions<zhengcaioaContext> options) @@ -37,6 +38,8 @@ 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; } @@ -49,6 +52,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; } @@ -59,6 +63,9 @@ public virtual DbSet<CooperOrder> CooperOrders { get; set; } public virtual DbSet<CooperVisit> CooperVisits { get; set; } public virtual DbSet<CooperatecustomCustomer> CooperatecustomCustomers { get; set; } + public virtual DbSet<CustomerYwjl> CustomerYwjls { get; set; } + public virtual DbSet<CustomerGuanlianhuiyuan> CustomerGuanlianhuiyuans { get; set; } + public virtual DbSet<CustomerGuanlian> CustomerGuanlians { get; set; } public virtual DbSet<CusFangwenjilu> CusFangwenjilus { get; set; } public virtual DbSet<FiAccount> FiAccounts { get; set; } public virtual DbSet<FiAccountRecord> FiAccountRecords { get; set; } @@ -101,6 +108,7 @@ public virtual DbSet<Projectreason> Projectreasons { get; set; } public virtual DbSet<Projectyouxiao> Projectyouxiaos { get; set; } public virtual DbSet<Projectzhongbiao> Projectzhongbiaos { get; set; } + public virtual DbSet<Projectfasongxiaoxi> Projectfasongxiaoxis { get; set; } public virtual DbSet<SysAttachment> SysAttachments { get; set; } public virtual DbSet<SysBaimingdan> SysBaimingdans { get; set; } public virtual DbSet<SysCode> SysCodes { get; set; } @@ -131,6 +139,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; } @@ -854,6 +863,81 @@ 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"); @@ -948,6 +1032,11 @@ entity.Property(e => e.Kuanggong) .HasColumnType("decimal(18, 4)") .HasColumnName("kuanggong"); + + entity.Property(e => e.Daixinjia) + .HasColumnType("decimal(18, 4)") + .HasColumnName("daixinjia") + .HasDefaultValueSql("(0)"); entity.Property(e => e.Modifier) .IsRequired() @@ -1055,6 +1144,11 @@ entity.Property(e => e.Qingjia) .HasColumnType("decimal(18, 4)") .HasColumnName("qingjia"); + + entity.Property(e => e.Daixinjia) + .HasColumnType("decimal(18, 4)") + .HasColumnName("daixinjia") + .HasDefaultValueSql("(0)"); entity.Property(e => e.RecStatus) .IsRequired() @@ -1775,6 +1869,22 @@ .HasMaxLength(50) .HasColumnName("user_Id") .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 => @@ -2625,6 +2735,10 @@ .HasColumnType("datetime") .HasColumnName("weixintime"); + entity.Property(e => e.Ywjltime) + .HasColumnType("datetime") + .HasColumnName("ywjltime"); + entity.Property(e => e.YwName) .HasMaxLength(500) .HasColumnName("yw_name") @@ -2659,6 +2773,88 @@ entity.Property(e => e.Taocanjianshu) .HasColumnType("int") .HasColumnName("taocanjianshu"); + }); + + + modelBuilder.Entity<CustomerYwjl>(entity => + { + entity.ToTable("Customer_Ywjl"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime"); + + entity.Property(e => e.UserId) + .HasMaxLength(50) + .HasColumnName("userId"); + + entity.Property(e => e.YwjlId) + .HasMaxLength(50) + .HasColumnName("ywjlId"); + }); + + modelBuilder.Entity<CustomerGuanlianhuiyuan>(entity => + { + entity.ToTable("CustomerGuanlianhuiyuan"); + + 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.Customerid) + .HasMaxLength(50) + .HasColumnName("customerid"); + + entity.Property(e => e.Customertype) + .HasMaxLength(50) + .HasColumnName("customertype"); + + entity.Property(e => e.Huiyuanid) + .HasMaxLength(50) + .HasColumnName("huiyuanid"); + + 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<CustomerGuanlian>(entity => + { + entity.ToTable("CustomerGuanlian"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.CustomerId).HasMaxLength(50); + + entity.Property(e => e.Customertype).HasMaxLength(50); + + entity.Property(e => e.SecCustomerId).HasMaxLength(50); + + entity.Property(e => e.SecCustomertype).HasMaxLength(50); }); modelBuilder.Entity<CusFangwenjilu>(entity => @@ -3128,6 +3324,10 @@ .HasColumnName("danjia") .HasComment("鍗曚环"); + entity.Property(e => e.Jifen) + .HasColumnType("money") + .HasColumnName("jifen"); + entity.Property(e => e.Modifier) .IsRequired() .HasMaxLength(50) @@ -3167,6 +3367,10 @@ .HasColumnType("money") .HasColumnName("huifei") .HasComment("浼氳垂"); + + entity.Property(e => e.Jifen) + .HasColumnType("money") + .HasColumnName("jifen"); entity.Property(e => e.MemberAuthority) .HasMaxLength(500) @@ -3217,6 +3421,10 @@ .HasColumnType("money") .HasColumnName("feiyong") .HasComment("璐圭敤"); + + entity.Property(e => e.Jifen) + .HasColumnType("money") + .HasColumnName("jifen"); entity.Property(e => e.Modifier) .IsRequired() @@ -3586,6 +3794,10 @@ entity.Property(e => e.Jibengongzi) .HasColumnType("money") .HasColumnName("jibengongzi"); + + entity.Property(e => e.Jiabangongzi) + .HasColumnType("money") + .HasColumnName("jiabangongzi"); entity.Property(e => e.Modifier) .IsRequired() @@ -3988,6 +4200,10 @@ .HasColumnName("khlx") .HasComment("瀹㈡埛绫诲瀷"); + entity.Property(e => e.HuiyuanId) + .HasMaxLength(50) + .HasColumnName("huiyuanId"); + entity.Property(e => e.Khly) .HasMaxLength(50) .HasColumnName("khly") @@ -4080,6 +4296,10 @@ 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); @@ -4663,6 +4883,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 => @@ -4695,6 +4923,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) @@ -5220,6 +5452,8 @@ entity.Property(e => e.HetongDateEnd).HasColumnType("datetime"); + entity.Property(e => e.FenpeiDate).HasColumnType("datetime"); + entity.Property(e => e.ShiyongPrice).HasColumnType("numeric(18, 2)"); entity.Property(e => e.Tel) @@ -5399,6 +5633,10 @@ .HasDefaultValueSql("('')") .HasComment("閲囪喘浜哄悕绉�"); + entity.Property(e => e.Caigouyusuan) + .HasColumnType("money") + .HasColumnName("caigouyusuan"); + entity.Property(e => e.Cgfs) .HasMaxLength(50) .HasColumnName("cgfs"); @@ -5436,6 +5674,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"); @@ -5443,10 +5705,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) @@ -5463,6 +5721,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); @@ -5554,6 +5836,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 => @@ -5577,6 +5883,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 => @@ -5590,6 +5920,10 @@ .HasMaxLength(50) .HasColumnName("zhongbiaoId"); + entity.Property(e => e.Defen) + .HasColumnType("money") + .HasColumnName("defen"); + entity.Property(e => e.Names) .HasMaxLength(500) .HasColumnName("names"); @@ -5602,8 +5936,64 @@ .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<Projectfasongxiaoxi>(entity => + { + entity.ToTable("Projectfasongxiaoxi"); + + entity.Property(e => e.Id).HasMaxLength(50); + + entity.Property(e => e.Createtime) + .HasColumnType("datetime") + .HasColumnName("createtime"); + + entity.Property(e => e.ProjectId).HasMaxLength(50); + + entity.Property(e => e.ProjectmingxiId).HasMaxLength(50); + + entity.Property(e => e.RecStatus) + .HasMaxLength(1) + .HasColumnName("rec_status"); + + entity.Property(e => e.Xiaoxileixing) + .HasMaxLength(50) + .HasColumnName("xiaoxileixing"); + + entity.Property(e => e.Xiaoxizhonglei) + .HasMaxLength(50) + .HasColumnName("xiaoxizhonglei"); + + entity.Property(e => e.Gyszl) + .HasMaxLength(50) + .HasColumnName("gyszl"); + + entity.Property(e => e.Khname) + .HasMaxLength(50) + .HasColumnName("khname"); }); modelBuilder.Entity<SysAttachment>(entity => @@ -5796,7 +6186,7 @@ .HasColumnName("comments"); entity.Property(e => e.Contents) - .HasMaxLength(300) + .HasMaxLength(500) .HasColumnName("contents"); entity.Property(e => e.Creater) @@ -7063,6 +7453,10 @@ .HasMaxLength(300) .HasColumnName("question"); + entity.Property(e => e.Questionname) + .HasMaxLength(500) + .HasColumnName("questionname"); + entity.Property(e => e.Sort).HasColumnName("sort"); }); @@ -7185,6 +7579,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"); @@ -7211,6 +7624,10 @@ .HasMaxLength(300) .HasColumnName("question"); + entity.Property(e => e.Questionname) + .HasMaxLength(500) + .HasColumnName("questionname"); + entity.Property(e => e.Sort).HasColumnName("sort"); }); -- Gitblit v1.9.1