From 00446e5e764fd57ea0f28b30921f4a5daa60c890 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期五, 23 七月 2021 14:10:31 +0800
Subject: [PATCH] 流程 费用申请，物品申领
---
zhengcaioa/Model/zhengcaioaContext.cs | 488 +++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 485 insertions(+), 3 deletions(-)
diff --git a/zhengcaioa/Model/zhengcaioaContext.cs b/zhengcaioa/Model/zhengcaioaContext.cs
index 4905e17..7414199 100644
--- a/zhengcaioa/Model/zhengcaioaContext.cs
+++ b/zhengcaioa/Model/zhengcaioaContext.cs
@@ -24,7 +24,8 @@
public virtual DbSet<HrSalaryAppeal> HrSalaryAppeal { get; set; }
public virtual DbSet<SimCostYearView> SimCostYearView { get; set; }
-
+ public virtual DbSet<AdmAskcost> AdmAskcosts { get; set; }
+ public virtual DbSet<AdmAskGood> AdmAskGoods { get; set; }
public virtual DbSet<AdmAskLeave> AdmAskLeaves { get; set; }
public virtual DbSet<AdmAskLeaveOff> AdmAskLeaveOffs { get; set; }
public virtual DbSet<AdmAttendance> AdmAttendances { get; set; }
@@ -67,9 +68,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; }
@@ -85,6 +91,7 @@
public virtual DbSet<SysCode> SysCodes { get; set; }
public virtual DbSet<SysCodeDtl> SysCodeDtls { get; set; }
public virtual DbSet<Systemsetting> Systemsettings { get; set; }
+ public virtual DbSet<SysUpdatetime> SysUpdatetimes { get; set; }
public virtual DbSet<WfApplytype> WfApplytypes { get; set; }
public virtual DbSet<WfHistory> WfHistories { get; set; }
public virtual DbSet<WfLog> WfLogs { get; set; }
@@ -112,6 +119,117 @@
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.HasAnnotation("Relational:Collation", "Chinese_PRC_CI_AS");
+
+ modelBuilder.Entity<AdmAskcost>(entity =>
+ {
+ entity.ToTable("ADM_Askcost");
+
+ entity.Property(e => e.Id).HasMaxLength(50);
+
+ entity.Property(e => e.Cost)
+ .HasColumnType("money")
+ .HasDefaultValueSql("((0))");
+
+ 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.Tittle)
+ .HasMaxLength(50)
+ .HasColumnName("tittle");
+ });
+
+ modelBuilder.Entity<AdmAskGood>(entity =>
+ {
+ entity.ToTable("ADM_AskGoods");
+
+ 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.GoodsId).HasMaxLength(50);
+
+ 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.Shuliang)
+ .HasColumnType("money")
+ .HasDefaultValueSql("((0))");
+
+ entity.Property(e => e.Tittle)
+ .HasMaxLength(50)
+ .HasColumnName("tittle");
+ });
+
modelBuilder.Entity<AdmAskLeave>(entity =>
{
entity.ToTable("ADM_AskLeave");
@@ -1203,6 +1321,10 @@
.HasColumnName("remark")
.HasComment("宸ヤ綔鍐呭");
+ entity.Property(e => e.Shuliang)
+ .HasColumnType("money")
+ .HasColumnName("shuliang");
+
entity.Property(e => e.UserId)
.HasMaxLength(50)
.HasColumnName("userId")
@@ -1291,6 +1413,14 @@
.HasColumnType("datetime")
.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)
@@ -1418,11 +1548,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)
@@ -1612,6 +1754,11 @@
.HasColumnName("f_tel")
.HasComment("鑱旂郴鐢佃瘽");
+ entity.Property(e => e.HuiyuanId)
+ .HasMaxLength(50)
+ .HasColumnName("huiyuanId")
+ .HasComment("浼氬憳Id");
+
entity.Property(e => e.Hyfl)
.HasMaxLength(50)
.HasColumnName("hyfl")
@@ -1716,6 +1863,14 @@
entity.Property(e => e.Weixin)
.HasMaxLength(50)
.HasColumnName("weixin");
+
+ entity.Property(e => e.Weixiner)
+ .HasMaxLength(50)
+ .HasColumnName("weixiner");
+
+ entity.Property(e => e.Weixintime)
+ .HasColumnType("datetime")
+ .HasColumnName("weixintime");
entity.Property(e => e.YwName)
.HasMaxLength(500)
@@ -2180,7 +2335,7 @@
.HasComment("浼氳垂");
entity.Property(e => e.MemberAuthority)
- .HasMaxLength(100)
+ .HasMaxLength(500)
.HasColumnName("member_authority")
.HasComment("浼氬憳鏉冮檺");
@@ -3041,6 +3196,14 @@
.HasMaxLength(50)
.HasColumnName("weixin");
+ entity.Property(e => e.Weixiner)
+ .HasMaxLength(50)
+ .HasColumnName("weixiner");
+
+ entity.Property(e => e.Weixintime)
+ .HasColumnType("datetime")
+ .HasColumnName("weixintime");
+
entity.Property(e => e.Yixiang).HasMaxLength(50);
entity.Property(e => e.Yixiangtime).HasColumnType("datetime");
@@ -3163,6 +3326,10 @@
.HasColumnName("createtime")
.HasDefaultValueSql("(getdate())");
+ entity.Property(e => e.DuanxinNeirong)
+ .HasMaxLength(500)
+ .HasColumnName("duanxin_neirong");
+
entity.Property(e => e.Jdr)
.HasMaxLength(500)
.HasColumnName("jdr")
@@ -3232,6 +3399,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");
@@ -3249,9 +3459,15 @@
.HasMaxLength(4000)
.HasColumnName("anwser");
+ entity.Property(e => e.ChushuStatus)
+ .HasMaxLength(1)
+ .HasColumnName("chushu_status")
+ .HasDefaultValueSql("('D')");
+
entity.Property(e => e.Clientid)
.HasMaxLength(50)
- .HasColumnName("clientid");
+ .HasColumnName("clientid")
+ .HasDefaultValueSql("('a')");
entity.Property(e => e.Creater)
.IsRequired()
@@ -3294,9 +3510,55 @@
.HasColumnName("rec_status")
.HasDefaultValueSql("('a')");
+ entity.Property(e => e.Shenheer)
+ .HasMaxLength(50)
+ .HasColumnName("shenheer");
+
+ entity.Property(e => e.Shenhetime)
+ .HasColumnType("datetime")
+ .HasColumnName("shenhetime");
+
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 =>
@@ -3406,6 +3668,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 =>
@@ -3912,6 +4373,10 @@
.HasColumnName("usernumber");
entity.Property(e => e.Weixin).HasMaxLength(50);
+
+ entity.Property(e => e.Yaoqingma)
+ .HasMaxLength(50)
+ .HasColumnName("yaoqingma");
entity.Property(e => e.Zhengzhi).HasMaxLength(50);
@@ -4547,6 +5012,23 @@
.HasColumnName("wedding_leave")
.HasComment("濠氬亣澶╂暟");
});
+
+ modelBuilder.Entity<SysUpdatetime>(entity =>
+ {
+ entity.ToTable("sys_updatetime");
+
+ entity.Property(e => e.Id).HasMaxLength(50);
+
+ entity.Property(e => e.Updatename)
+ .IsRequired()
+ .HasMaxLength(100)
+ .HasColumnName("updatename");
+
+ entity.Property(e => e.Updatetime)
+ .HasColumnType("datetime")
+ .HasColumnName("updatetime");
+ });
+
modelBuilder.Entity<WfApplytype>(entity =>
{
entity.ToTable("wf_applytype");
--
Gitblit v1.9.1