zhengcaioa/Model/zhengcaioaContext.cs
@@ -21,6 +21,9 @@
        public virtual DbSet<SimBindView> SimBindView { get; set; }
        public virtual DbSet<SimCost> SimCost { get; set; }
        public virtual DbSet<SimCostView> SimCostView { get; set; }
        public virtual DbSet<HrSalaryAppeal> HrSalaryAppeal { get; set; }
        public virtual DbSet<SimCostYearView> SimCostYearView { get; set; }
        public virtual DbSet<AdmAskLeave> AdmAskLeaves { get; set; }
        public virtual DbSet<AdmAskLeaveOff> AdmAskLeaveOffs { get; set; }
@@ -43,6 +46,7 @@
        public virtual DbSet<CooperOrder> CooperOrders { get; set; }
        public virtual DbSet<CooperVisit> CooperVisits { get; set; }
        public virtual DbSet<CooperatecustomCustomer> CooperatecustomCustomers { get; set; }
        public virtual DbSet<CusFangwenjilu> CusFangwenjilus { get; set; }
        public virtual DbSet<FiAccount> FiAccounts { get; set; }
        public virtual DbSet<FiAccountRecord> FiAccountRecords { get; set; }
        public virtual DbSet<FiOrderrecievemoney> FiOrderrecievemoneys { get; set; }
@@ -63,8 +67,14 @@
        public virtual DbSet<IntentionCustomer> IntentionCustomers { get; set; }
        public virtual DbSet<IntentionOrder> IntentionOrders { get; set; }
        public virtual DbSet<IntentionVisit> IntentionVisits { get; set; }
        public virtual DbSet<IntentionVisitDuanxin> IntentionVisitDuanxins { get; set; }
        public virtual DbSet<Liaotian> Liaotians { get; set; }
        public virtual DbSet<LiaotianShoucang> LiaotianShoucangs { get; set; }
        public virtual DbSet<LZhuanjiahuidum> LZhuanjiahuida { get; set; }
        public virtual DbSet<Oayouhui> Oayouhuis { get; set; }
        public virtual DbSet<OrderBanci> OrderBancis { get; set; }
        public virtual DbSet<OrderBanciDtl> OrderBanciDtls { get; set; }
        public virtual DbSet<OrderBanciOrder> OrderBanciOrders { get; set; }
        public virtual DbSet<PltAuth> PltAuths { get; set; }
        public virtual DbSet<PltPage> PltPages { get; set; }
        public virtual DbSet<PltRole> PltRoles { get; set; }
@@ -341,10 +351,6 @@
                    .HasMaxLength(50)
                    .HasColumnName("attendance_id");
                entity.Property(e => e.Chidaofenzhong)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("chidaofenzhong");
                entity.Property(e => e.Creater)
                    .IsRequired()
                    .HasMaxLength(50)
@@ -355,6 +361,10 @@
                    .HasColumnType("datetime")
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");
                entity.Property(e => e.Iswork)
                   .HasMaxLength(1)
                   .HasColumnName("iswork");
                entity.Property(e => e.Kuanggongtianshu)
                    .HasColumnType("decimal(18, 4)")
@@ -393,13 +403,25 @@
                    .HasColumnType("datetime")
                    .HasDefaultValueSql("(getdate())");
                entity.Property(e => e.Shangwuchidaofenzhong)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("shangwuchidaofenzhong");
                entity.Property(e => e.Shangwuzaotuifenzhong)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("shangwuzaotuifenzhong");
                entity.Property(e => e.Xiaojia)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("xiaojia");
                entity.Property(e => e.Zaotuifenzhong)
                entity.Property(e => e.Xiawuchidaofenzhong)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("zaotuifenzhong");
                    .HasColumnName("xiawuchidaofenzhong");
                entity.Property(e => e.Xiawuzaotuifenzhong)
                    .HasColumnType("decimal(18, 4)")
                    .HasColumnName("xiawuzaotuifenzhong");
            });
            modelBuilder.Entity<AdmAttendanceRule>(entity =>
@@ -1275,6 +1297,14 @@
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");
                entity.Property(e => e.HuifangJdr)
                    .HasMaxLength(100)
                    .HasColumnName("huifang_jdr");
                entity.Property(e => e.HuifangKehuyijian)
                    .HasMaxLength(500)
                    .HasColumnName("huifang_kehuyijian");
                entity.Property(e => e.HuifangStatus)
                    .HasMaxLength(2)
                    .HasColumnName("huifang_status")
@@ -1401,11 +1431,23 @@
                    .HasColumnName("shr_tel")
                    .HasComment("联系电话");
                entity.Property(e => e.SonghuoDanhao)
                    .HasMaxLength(100)
                    .HasColumnName("songhuo_danhao");
                entity.Property(e => e.SonghuoGongsi)
                    .HasMaxLength(100)
                    .HasColumnName("songhuo_gongsi");
                entity.Property(e => e.SonghuoStatus)
                    .HasMaxLength(2)
                    .HasColumnName("songhuo_status")
                    .HasDefaultValueSql("('D')")
                    .HasComment("送货状态");
                entity.Property(e => e.SonghuoTime1)
                    .HasColumnType("datetime")
                    .HasColumnName("songhuo_time");
                entity.Property(e => e.Songhuoer)
                    .HasMaxLength(50)
@@ -1667,6 +1709,10 @@
                    .HasColumnName("sheng")
                    .HasComment("省");
                entity.Property(e => e.Shifoutianjiaweixin)
                    .HasMaxLength(1)
                    .HasColumnName("shifoutianjiaweixin");
                entity.Property(e => e.ShrAddress)
                    .HasMaxLength(500)
                    .HasColumnName("shr_address")
@@ -1692,6 +1738,10 @@
                    .HasColumnName("url")
                    .HasComment("网址");
                entity.Property(e => e.Weixin)
                    .HasMaxLength(50)
                    .HasColumnName("weixin");
                entity.Property(e => e.YwName)
                    .HasMaxLength(500)
                    .HasColumnName("yw_name")
@@ -1711,6 +1761,53 @@
                    .HasMaxLength(50)
                    .HasColumnName("ywjl")
                    .HasComment("业务经理");
            });
            modelBuilder.Entity<CusFangwenjilu>(entity =>
            {
                entity.ToTable("cus_fangwenjilu");
                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.Fasongfangshi)
                    .HasMaxLength(50)
                    .HasColumnName("fasongfangshi");
                entity.Property(e => e.Fasongneirong)
                    .HasMaxLength(4000)
                    .HasColumnName("fasongneirong");
                entity.Property(e => e.Jieshouren)
                    .HasMaxLength(2000)
                    .HasColumnName("jieshouren");
                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<FiAccount>(entity =>
@@ -2108,7 +2205,7 @@
                    .HasComment("会费");
                entity.Property(e => e.MemberAuthority)
                    .HasMaxLength(100)
                    .HasMaxLength(500)
                    .HasColumnName("member_authority")
                    .HasComment("会员权限");
@@ -2840,6 +2937,10 @@
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");
                entity.Property(e => e.Dianxiaozhuanyuan)
                    .HasMaxLength(50)
                    .HasColumnName("dianxiaozhuanyuan");
                entity.Property(e => e.Email)
                    .HasMaxLength(500)
                    .HasColumnName("email")
@@ -2932,6 +3033,10 @@
                    .HasColumnName("sheng")
                    .HasComment("省");
                entity.Property(e => e.Shifoutianjiaweixin)
                    .HasMaxLength(1)
                    .HasColumnName("shifoutianjiaweixin");
                entity.Property(e => e.ShrAddress)
                    .HasMaxLength(500)
                    .HasColumnName("shr_address")
@@ -2957,6 +3062,14 @@
                    .HasColumnName("url")
                    .HasComment("网址");
                entity.Property(e => e.Weixin)
                    .HasMaxLength(50)
                    .HasColumnName("weixin");
                entity.Property(e => e.Yixiang).HasMaxLength(50);
                entity.Property(e => e.Yixiangtime).HasColumnType("datetime");
                entity.Property(e => e.YwName)
                    .HasMaxLength(500)
                    .HasColumnName("yw_name")
@@ -2976,6 +3089,10 @@
                    .HasMaxLength(50)
                    .HasColumnName("ywjl")
                    .HasComment("业务经理");
                entity.Property(e => e.Zuijinzhuizongtime)
                    .HasColumnType("datetime")
                    .HasColumnName("zuijinzhuizongtime");
            });
            modelBuilder.Entity<IntentionOrder>(entity =>
@@ -3071,6 +3188,10 @@
                    .HasColumnName("createtime")
                    .HasDefaultValueSql("(getdate())");
                entity.Property(e => e.DuanxinNeirong)
                    .HasMaxLength(500)
                    .HasColumnName("duanxin_neirong");
                entity.Property(e => e.Jdr)
                    .HasMaxLength(500)
                    .HasColumnName("jdr")
@@ -3140,6 +3261,49 @@
                    .HasComment("职务");
            });
            modelBuilder.Entity<IntentionVisitDuanxin>(entity =>
            {
                entity.ToTable("IntentionVisit_duanxin");
                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.DuanxinNeirong)
                    .HasMaxLength(500)
                    .HasColumnName("duanxin_neirong");
                entity.Property(e => e.DuanxinTitle)
                    .HasMaxLength(50)
                    .HasColumnName("duanxin_title");
                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<Liaotian>(entity =>
            {
                entity.ToTable("Liaotian");
@@ -3156,6 +3320,11 @@
                    .IsRequired()
                    .HasMaxLength(4000)
                    .HasColumnName("anwser");
                entity.Property(e => e.ChushuStatus)
                   .HasMaxLength(1)
                   .HasColumnName("chushu_status")
                   .HasDefaultValueSql("('D')");
                entity.Property(e => e.Clientid)
                    .HasMaxLength(50)
@@ -3205,6 +3374,102 @@
                entity.Property(e => e.Shiyongfatiao)
                    .HasMaxLength(500)
                    .HasColumnName("shiyongfatiao");
            });
            modelBuilder.Entity<LiaotianShoucang>(entity =>
            {
                entity.ToTable("Liaotian_shoucang");
                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.LiaotianId)
                    .HasMaxLength(50)
                    .HasColumnName("Liaotian_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.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('a')");
            });
            modelBuilder.Entity<LZhuanjiahuidum>(entity =>
            {
                entity.ToTable("l_zhuanjiahuida");
                entity.Property(e => e.Id).HasMaxLength(50);
                entity.Property(e => e.Anwser)
                    .HasMaxLength(4000)
                    .HasColumnName("anwser");
                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.Question)
                    .HasMaxLength(500)
                    .HasColumnName("question");
                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");
                entity.Property(e => e.HuidaStatus)
                   .IsRequired()
                   .HasMaxLength(1)
                   .HasColumnName("huida_status")
                   .HasDefaultValueSql("('D')");
                entity.Property(e => e.Userid)
                    .HasMaxLength(50)
                    .HasColumnName("userid");
                entity.Property(e => e.Username)
                    .HasMaxLength(100)
                    .HasColumnName("username");
            });
            modelBuilder.Entity<Oayouhui>(entity =>
@@ -3257,6 +3522,205 @@
                entity.Property(e => e.Youtype)
                    .HasMaxLength(50)
                    .HasComment("优惠类型");
            });
            modelBuilder.Entity<OrderBanci>(entity =>
            {
                entity.ToTable("order_banci");
                entity.Property(e => e.Id).HasMaxLength(50);
                entity.Property(e => e.Mingcheng)
                    .HasMaxLength(100)
                    .HasColumnName("mingcheng");
                entity.Property(e => e.Banci)
                   .HasMaxLength(100)
                   .HasColumnName("banci");
                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.Didian)
                    .HasMaxLength(500)
                    .HasColumnName("didian");
                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.Renshu)
                    .HasColumnName("renshu");
                entity.Property(e => e.Shijian)
                    .HasColumnType("datetime")
                    .HasColumnName("shijian");
                entity.Property(e => e.Shijianend)
                    .HasColumnType("datetime")
                    .HasColumnName("shijianend");
            });
            modelBuilder.Entity<OrderBanciDtl>(entity =>
            {
                entity.ToTable("order_banci_dtl");
                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.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)
                    .HasColumnName("modifier")
                    .HasDefaultValueSql("('1')");
                entity.Property(e => e.Modifytime)
                    .HasColumnType("datetime")
                    .HasColumnName("modifytime")
                    .HasDefaultValueSql("(getdate())");
                entity.Property(e => e.OrderBanciId)
                    .HasMaxLength(50)
                    .HasColumnName("order_banci_id");
                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");
                entity.Property(e => e.Shangxiawu)
                    .HasMaxLength(100)
                    .HasColumnName("shangxiawu");
                entity.Property(e => e.Shijian)
                    .HasMaxLength(100)
                    .HasColumnName("shijian");
                entity.Property(e => e.Shixiamg)
                    .HasMaxLength(500)
                    .HasColumnName("shixiamg");
                entity.Property(e => e.Sort)
                    .HasColumnName("sort")
                    .HasDefaultValueSql("((0))");
                entity.Property(e => e.Zhujiangren)
                    .HasMaxLength(100)
                    .HasColumnName("zhujiangren");
            });
            modelBuilder.Entity<OrderBanciOrder>(entity =>
            {
                entity.ToTable("order_banci_order");
                entity.Property(e => e.Id).HasMaxLength(50);
                entity.Property(e => e.BanciId)
                    .HasMaxLength(50)
                    .HasColumnName("banci_id");
                entity.Property(e => e.Baomingrenshu).HasColumnName("baomingrenshu");
                entity.Property(e => e.Baomingtime)
                    .HasColumnType("datetime")
                    .HasColumnName("baomingtime");
                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.Jine)
                    .HasColumnType("money")
                    .HasColumnName("jine");
                entity.Property(e => e.Kechengleixing)
                    .HasMaxLength(100)
                    .HasColumnName("kechengleixing");
                entity.Property(e => e.KechengleixingId)
                    .HasMaxLength(50)
                    .HasColumnName("kechengleixing_id");
                entity.Property(e => e.Lianxidianhua)
                    .HasMaxLength(100)
                    .HasColumnName("lianxidianhua");
                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.Peixunbanci)
                    .HasMaxLength(100)
                    .HasColumnName("peixunbanci");
                entity.Property(e => e.PersonId)
                    .HasMaxLength(100)
                    .HasColumnName("person_id");
                entity.Property(e => e.RecStatus)
                    .IsRequired()
                    .HasMaxLength(1)
                    .HasColumnName("rec_status")
                    .HasDefaultValueSql("('A')");
                entity.Property(e => e.Shenfenzheng)
                  .HasMaxLength(100)
                  .HasColumnName("shenfenzheng");
                entity.Property(e => e.Xingming)
                    .HasMaxLength(100)
                    .HasColumnName("xingming");
                entity.Property(e => e.Xuefei)
                    .HasColumnType("money")
                    .HasColumnName("xuefei");
            });
            modelBuilder.Entity<PltAuth>(entity =>
@@ -3873,6 +4337,7 @@
                    .HasMaxLength(50)
                    .HasColumnName("userId");
            });
            modelBuilder.Entity<Project>(entity =>
            {
                entity.ToTable("Project");
@@ -3942,6 +4407,10 @@
                    .HasMaxLength(500)
                    .HasColumnName("drhx");
                entity.Property(e => e.DrhxDefen)
                    .HasColumnType("money")
                    .HasColumnName("drhx_defen");
                entity.Property(e => e.DrhxPrice)
                    .HasMaxLength(500)
                    .HasColumnName("drhx_price");
@@ -3949,6 +4418,10 @@
                entity.Property(e => e.Dshx)
                    .HasMaxLength(500)
                    .HasColumnName("dshx");
                entity.Property(e => e.DshxDefen)
                    .HasColumnType("money")
                    .HasColumnName("dshx_defen");
                entity.Property(e => e.DshxPrice)
                    .HasMaxLength(500)
@@ -3961,6 +4434,8 @@
                entity.Property(e => e.Feibiaocishu)
                    .HasMaxLength(100)
                    .HasColumnName("feibiaocishu");
                entity.Property(e => e.Fencha).HasColumnType("money");
                entity.Property(e => e.Modifier)
                    .IsRequired()
@@ -4089,6 +4564,9 @@
                entity.Property(e => e.ProjectId)
                    .IsRequired()
                    .HasMaxLength(50);
                entity.Property(e => e.Defen).HasColumnType("money")
                    .HasColumnName("defen"); ;
            });
            modelBuilder.Entity<SysAttachment>(entity =>
@@ -4731,6 +5209,10 @@
                    .HasColumnName("danjuId")
                    .HasComment("单据Id");
                entity.Property(e => e.Deelurl)
                    .HasMaxLength(500)
                    .HasColumnName("deelurl");
                entity.Property(e => e.Modifier)
                    .IsRequired()
                    .HasMaxLength(50)