政采招标oa系统
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
username@email.com
2022-12-01 db227144dedfb5fb5b1e94e8c8b14eab9eb7462f 
 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; }


@@ -62,6 +63,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; }


@@ -130,9 +132,15 @@




        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; }


        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 +148,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");


            }


        }




@@ -1771,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");


@@ -2195,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)


@@ -2626,6 +2662,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 +2851,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 +3146,10 @@


                    .HasColumnName("danjia")


                    .HasComment("单价");




                entity.Property(e => e.Jifen)


                   .HasColumnType("money")


                   .HasColumnName("jifen");




                entity.Property(e => e.Modifier)


                    .IsRequired()


                    .HasMaxLength(50)


@@ -3068,6 +3189,10 @@


                    .HasColumnType("money")


                    .HasColumnName("huifei")


                    .HasComment("会费");




                entity.Property(e => e.Jifen)


                    .HasColumnType("money")


                    .HasColumnName("jifen");




                entity.Property(e => e.MemberAuthority)


                    .HasMaxLength(500)


@@ -3118,6 +3243,10 @@


                    .HasColumnType("money")


                    .HasColumnName("feiyong")


                    .HasComment("费用");




                entity.Property(e => e.Jifen)


                  .HasColumnType("money")


                  .HasColumnName("jifen");




                entity.Property(e => e.Modifier)


                    .IsRequired()


@@ -4564,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 =>


@@ -4597,6 +4734,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 +4768,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()


@@ -5115,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)


@@ -5294,6 +5441,10 @@


                    .HasDefaultValueSql("('')")


                    .HasComment("采购人名称");




                entity.Property(e => e.Caigouyusuan)


                    .HasColumnType("money")


                    .HasColumnName("caigouyusuan");




                entity.Property(e => e.Cgfs)


                    .HasMaxLength(50)


                    .HasColumnName("cgfs");


@@ -5331,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");


@@ -5338,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)


@@ -5358,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);




@@ -5449,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 =>


@@ -5472,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 =>


@@ -5485,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");


@@ -5497,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 =>


@@ -5691,7 +5959,7 @@


                    .HasColumnName("comments");




                entity.Property(e => e.Contents)


                    .HasMaxLength(300)


                    .HasMaxLength(500)


                    .HasColumnName("contents");




                entity.Property(e => e.Creater)


@@ -6943,16 +7211,24 @@


                    .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)


                    .HasColumnName("question");




                entity.Property(e => e.Questionname)


                 .HasMaxLength(500)


                 .HasColumnName("questionname");




                entity.Property(e => e.Sort).HasColumnName("sort");


            });


@@ -7076,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");


@@ -7087,16 +7382,24 @@


                    .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)


                    .HasColumnName("question");




                entity.Property(e => e.Questionname)


                .HasMaxLength(500)


                .HasColumnName("questionname");




                entity.Property(e => e.Sort).HasColumnName("sort");


            });


@@ -7186,9 +7489,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 +7520,7 @@


                    .HasColumnName("purchaser_name");




                entity.Property(e => e.Questioned)


                    .HasMaxLength(50)


                    .HasMaxLength(300)


                    .HasColumnName("questioned");




                entity.Property(e => e.RequestInfo)


@@ -7225,7 +7532,7 @@


                    .HasColumnName("respond_date");




                entity.Property(e => e.Respondent)


                    .HasMaxLength(50)


                    .HasMaxLength(300)


                    .HasColumnName("respondent");




                entity.Property(e => e.ResultnoticeDate)


@@ -7295,6 +7602,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);


        }