username@email.com
2023-11-02 558dae4a18d393ac38daa43a354e8bc9a22e4e26
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; }
@@ -90,6 +97,7 @@
        public virtual DbSet<OrderBanci> OrderBancis { get; set; }
        public virtual DbSet<OrderBanciDtl> OrderBanciDtls { get; set; }
        public virtual DbSet<OrderBanciOrder> OrderBanciOrders { get; set; }
        public virtual DbSet<OrderBanciZuowei> OrderBanciZuoweis { get; set; }
        public virtual DbSet<PltAuth> PltAuths { get; set; }
        public virtual DbSet<PltPage> PltPages { get; set; }
        public virtual DbSet<PltRole> PltRoles { get; set; }
@@ -101,6 +109,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; }
@@ -855,6 +864,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");
@@ -949,6 +1033,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()
@@ -1056,6 +1145,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()
@@ -1776,6 +1870,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 =>
@@ -2626,6 +2736,18 @@
                    .HasColumnType("datetime")
                    .HasColumnName("weixintime");
                entity.Property(e => e.Kuaidistatus)
                    .HasMaxLength(1)
                    .HasColumnName("kuaidistatus");
                entity.Property(e => e.Kuaiditime)
                    .HasColumnType("datetime")
                    .HasColumnName("kuaiditime");
                entity.Property(e => e.Ywjltime)
                    .HasColumnType("datetime")
                    .HasColumnName("ywjltime");
                entity.Property(e => e.YwName)
                    .HasMaxLength(500)
                    .HasColumnName("yw_name")
@@ -2660,6 +2782,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 =>
@@ -3600,6 +3804,10 @@
                    .HasColumnType("money")
                    .HasColumnName("jibengongzi");
                entity.Property(e => e.Jiabangongzi)
                   .HasColumnType("money")
                   .HasColumnName("jiabangongzi");
                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
@@ -4001,6 +4209,10 @@
                    .HasColumnName("khlx")
                    .HasComment("客户类型");
                entity.Property(e => e.HuiyuanId)
                   .HasMaxLength(50)
                   .HasColumnName("huiyuanId");
                entity.Property(e => e.Khly)
                    .HasMaxLength(50)
                    .HasColumnName("khly")
@@ -4093,6 +4305,18 @@
                entity.Property(e => e.Weixintime)
                    .HasColumnType("datetime")
                    .HasColumnName("weixintime");
                entity.Property(e => e.Kuaidistatus)
                  .HasMaxLength(1)
                  .HasColumnName("kuaidistatus");
                entity.Property(e => e.Kuaiditime)
                    .HasColumnType("datetime")
                    .HasColumnName("kuaiditime");
                entity.Property(e => e.Ywjltime)
                  .HasColumnType("datetime")
                  .HasColumnName("ywjltime");
                entity.Property(e => e.Yixiang).HasMaxLength(50);
@@ -4610,6 +4834,12 @@
                entity.Property(e => e.Renshu)
                    .HasColumnName("renshu");
                entity.Property(e => e.Hang)
                  .HasColumnName("hang");
                entity.Property(e => e.Lie)
                  .HasColumnName("lie");
                entity.Property(e => e.Shijian)
                    .HasColumnType("datetime")
                    .HasColumnName("shijian");
@@ -4721,6 +4951,14 @@
                 .HasColumnType("money")
                 .HasColumnName("jifen");
                entity.Property(e => e.SeatID)
                  .HasMaxLength(50)
                  .HasColumnName("SeatID");
                entity.Property(e => e.SeatName)
                  .HasMaxLength(50)
                  .HasColumnName("SeatName");
                entity.Property(e => e.Kechengleixing)
                    .HasMaxLength(100)
                    .HasColumnName("kechengleixing");
@@ -4773,6 +5011,61 @@
                entity.Property(e => e.Xuefei)
                    .HasColumnType("money")
                    .HasColumnName("xuefei");
            });
            modelBuilder.Entity<OrderBanciZuowei>(entity =>
            {
                entity.ToTable("order_banci_zuowei");
                entity.Property(e => e.Id).HasMaxLength(50);
                entity.Property(e => e.BanciId)
                    .HasMaxLength(50)
                    .HasColumnName("banciId");
                entity.Property(e => e.ColNo).HasColumnName("colNo");
                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.RowNo).HasColumnName("rowNo");
                entity.Property(e => e.SeatNo)
                    .HasMaxLength(50)
                    .HasColumnName("seatNo");
                entity.Property(e => e.Status)
                    .HasMaxLength(1)
                    .HasColumnName("status");
                entity.Property(e => e.ZuoweiId)
                    .HasMaxLength(50)
                    .HasColumnName("zuoweiId");
            });
            modelBuilder.Entity<PltAuth>(entity =>
@@ -5245,6 +5538,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)
@@ -5424,6 +5719,10 @@
                    .HasDefaultValueSql("('')")
                    .HasComment("采购人名称");
                entity.Property(e => e.Caigouyusuan)
                    .HasColumnType("money")
                    .HasColumnName("caigouyusuan");
                entity.Property(e => e.Cgfs)
                    .HasMaxLength(50)
                    .HasColumnName("cgfs");
@@ -5461,6 +5760,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");
@@ -5468,10 +5791,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)
@@ -5488,6 +5807,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);
@@ -5579,6 +5922,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 =>
@@ -5602,6 +5969,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 =>
@@ -5615,6 +6006,10 @@
                    .HasMaxLength(50)
                    .HasColumnName("zhongbiaoId");
                entity.Property(e => e.Defen)
                    .HasColumnType("money")
                    .HasColumnName("defen");
                entity.Property(e => e.Names)
                    .HasMaxLength(500)
                    .HasColumnName("names");
@@ -5627,8 +6022,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 =>