From fd865638a82d6691a7904ce1aaccff1e050c7c14 Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期五, 09 七月 2021 13:18:02 +0800 Subject: [PATCH] 订单管理: 订单数量默认1 列表 订单类别 显示三级 收货人默认客户资料的收货人 订单批量打印 打印需要批量打印 回访:需要增加 接待人,回访情况,用户评价.客户意见, 送货。 送货公司,单号,时间 --- zhengcaioa/Model/zhengcaioaContext.cs | 496 ++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 489 insertions(+), 7 deletions(-) diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs index 09d641c..ec20a40 100644 --- a/zhengcaioa/Model/zhengcaioaContext.cs +++ b/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) -- Gitblit v1.9.1