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 | 472 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 471 insertions(+), 1 deletions(-)
diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs
index 17456be..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; }
@@ -1287,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")
@@ -1413,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)
@@ -1679,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")
@@ -1704,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")
@@ -1723,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 =>
@@ -2120,7 +2205,7 @@
.HasComment("浼氳垂");
entity.Property(e => e.MemberAuthority)
- .HasMaxLength(100)
+ .HasMaxLength(500)
.HasColumnName("member_authority")
.HasComment("浼氬憳鏉冮檺");
@@ -2852,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")
@@ -2944,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")
@@ -2969,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")
@@ -2988,6 +3089,10 @@
.HasMaxLength(50)
.HasColumnName("ywjl")
.HasComment("涓氬姟缁忕悊");
+
+ entity.Property(e => e.Zuijinzhuizongtime)
+ .HasColumnType("datetime")
+ .HasColumnName("zuijinzhuizongtime");
});
modelBuilder.Entity<IntentionOrder>(entity =>
@@ -3083,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")
@@ -3152,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");
@@ -3168,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)
@@ -3217,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 =>
@@ -3269,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 =>
@@ -3885,6 +4337,7 @@
.HasMaxLength(50)
.HasColumnName("userId");
});
+
modelBuilder.Entity<Project>(entity =>
{
entity.ToTable("Project");
@@ -3954,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");
@@ -3961,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)
@@ -3973,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()
@@ -4101,6 +4564,9 @@
entity.Property(e => e.ProjectId)
.IsRequired()
.HasMaxLength(50);
+
+ entity.Property(e => e.Defen).HasColumnType("money")
+ .HasColumnName("defen"); ;
});
modelBuilder.Entity<SysAttachment>(entity =>
@@ -4743,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