// using System; using Microsoft.EntityFrameworkCore; using Microsoft.EntityFrameworkCore.Infrastructure; using Microsoft.EntityFrameworkCore.Metadata; using Microsoft.EntityFrameworkCore.Migrations; using Microsoft.EntityFrameworkCore.Storage.ValueConversion; using wispro.sp.api; namespace wispro.sp.api.Migrations { [DbContext(typeof(spDbContext))] [Migration("20211130020237_sp-database")] partial class spdatabase { protected override void BuildTargetModel(ModelBuilder modelBuilder) { #pragma warning disable 612, 618 modelBuilder .HasAnnotation("Relational:MaxIdentifierLength", 128) .HasAnnotation("ProductVersion", "5.0.9") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); modelBuilder.Entity("wispro.sp.entity.AppealRecord", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("CreateTime") .HasColumnType("datetime2"); b.Property("CreaterId") .HasColumnType("int"); b.Property("ItemId") .HasColumnType("int"); b.Property("Reason") .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property("ReviewTime") .HasColumnType("datetime2"); b.Property("ReviewerId") .HasColumnType("int"); b.Property("ReviewerMemo") .HasColumnType("nvarchar(max)"); b.Property("State") .HasColumnType("int"); b.Property("TypeId") .HasColumnType("int"); b.HasKey("Id"); b.HasIndex("CreaterId"); b.HasIndex("ItemId"); b.HasIndex("ReviewerId"); b.HasIndex("TypeId"); b.ToTable("AppealRecord"); }); modelBuilder.Entity("wispro.sp.entity.AppealType", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("CanDoExpress") .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property("Name") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("ReviewerExpress") .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property("Type") .HasColumnType("int"); b.HasKey("Id"); b.ToTable("AppealType"); b.HasData( new { Id = 1, CanDoExpress = "p.ItemStaffs.Count()>1", Name = "绩效点数分配比率", Type = 0 }, new { Id = 2, CanDoExpress = "p.DoItem==\"新申请\"", Name = "案件系数复核", ReviewerExpress = "p.Reviewer", Type = 0 }, new { Id = 3, CanDoExpress = "p.DoItem==\"新申请\"", Name = "处理事项系数复核", ReviewerExpress = "p.Reviewer", Type = 0 }, new { Id = 4, CanDoExpress = "", Name = "案件缺漏申诉", ReviewerExpress = "p.Reviewer", Type = 1 }, new { Id = 5, CanDoExpress = "p.isDanger()", Name = "案件严重超期说明", Type = 0 }, new { Id = 6, CanDoExpress = "p.DoItem==\"新申请\" || p.DoItem==\"翻译\"", Name = "按照翻译字数算绩效备注", Type = 0 }); }); modelBuilder.Entity("wispro.sp.entity.AttachFile", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); b.Property("AppealRecordId") .HasColumnType("int"); b.Property("Name") .HasMaxLength(200) .HasColumnType("nvarchar(200)"); b.Property("SavePath") .HasMaxLength(200) .HasColumnType("nvarchar(200)"); b.Property("UploadUserId") .HasColumnType("int"); b.HasKey("Id"); b.HasIndex("AppealRecordId"); b.HasIndex("UploadUserId"); b.ToTable("AttachFile"); }); modelBuilder.Entity("wispro.sp.entity.BasePointRule", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("PointExpress") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property("Priority") .HasColumnType("int"); b.Property("Rule") .HasMaxLength(1000) .HasColumnType("nvarchar(1000)"); b.Property("Type") .HasMaxLength(20) .HasColumnType("nvarchar(20)"); b.HasKey("Id"); b.ToTable("BasePointRule"); b.HasData( new { Id = 1, PointExpress = "0", Priority = 136, Rule = "p.CaseNo.StartsWith(\"J\")", Type = "其它" }, new { Id = 2, PointExpress = "0", Priority = 135, Rule = "p.AgentFeedbackMemo==\"已算绩效\"", Type = "其它" }, new { Id = 3, PointExpress = "p.WordCount/1000*0.18", Priority = 134, Rule = "p.DoItem==\"翻译\" && p.AgentFeedbackMemo==\"中-德\"", Type = "其它" }, new { Id = 4, PointExpress = "p.WordCount/1000*0.16", Priority = 133, Rule = "p.DoItem==\"翻译\" && p.AgentFeedbackMemo==\"中-英\"", Type = "其它" }, new { Id = 5, PointExpress = "p.WordCount/1000*0.1", Priority = 132, Rule = "p.DoItem==\"翻译\" && p.AgentFeedbackMemo==\"英-中\"", Type = "其它" }, new { Id = 6, PointExpress = "0.2", Priority = 131, Rule = "(p.DoItem==\"提交检索主题申明\" || p.DoItem==\"提交检索主题声明\") && p.CaseNo.StartsWith(\"PAEPO\")", Type = "其它" }, new { Id = 7, PointExpress = "0", Priority = 130, Rule = "p.DoItem==\"请求优先审查\"", Type = "其它" }, new { Id = 8, PointExpress = "0.2", Priority = 129, Rule = "p.ApplicationType==\"外观设计\" && p.DoItem==\"新申请\"", Type = "其它" }, new { Id = 9, PointExpress = "0", Priority = 128, Rule = "p.DoItem==\"专利挖掘与布局\"", Type = "其它" }, new { Id = 10, PointExpress = "0", Priority = 127, Rule = "p.DoItem==\"知识点总结\"", Type = "其它" }, new { Id = 11, PointExpress = "0", Priority = 126, Rule = "p.DoItem==\"询问放弃或复审\"", Type = "其它" }, new { Id = 12, PointExpress = "0", Priority = 125, Rule = "p.DoItem==\"申请时提交IDS\"", Type = "其它" }, new { Id = 13, PointExpress = "0.1", Priority = 124, Rule = "p.DoItem==\"提交ids\" || p.DoItem==\"提交IDS\" ", Type = "其它" }, new { Id = 14, PointExpress = "0", Priority = 123, Rule = "p.DoItem==\"技术确认\"", Type = "其它" }, new { Id = 15, PointExpress = "0", Priority = 122, Rule = "p.DoItem==\"绘图\"", Type = "其它" }, new { Id = 16, PointExpress = "0.2", Priority = 121, Rule = "p.DoItem==\"分案评估+分案\"", Type = "其它" }, new { Id = 17, PointExpress = "0.1", Priority = 120, Rule = "p.DoItem==\"分案评估\"", Type = "其它" }, new { Id = 18, PointExpress = "0.2", Priority = 119, Rule = "p.DoItem==\"电询\" && p.CaseNo.StartsWith(\"PAUS\")", Type = "其它" }, new { Id = 19, PointExpress = "0.2", Priority = 118, Rule = "p.DoItem==\"电询\" && p.CaseNo.StartsWith(\"PAEPO\") ", Type = "其它" }, new { Id = 20, PointExpress = "0", Priority = 117, Rule = "p.DoItem==\"电询\" && p.CaseNo.StartsWith(\"PACN\")", Type = "其它" }, new { Id = 21, PointExpress = "0.1", Priority = 116, Rule = "p.DoItem==\"PPH\"", Type = "其它" }, new { Id = 22, PointExpress = "0.2", Priority = 115, Rule = "p.DoItem==\"OA答辩校核\"", Type = "其它" }, new { Id = 23, PointExpress = "0.2", Priority = 114, Rule = "p.DoItem==\"Election Action\"", Type = "其它" }, new { Id = 24, PointExpress = "0.2", Priority = 113, Rule = "p.DoItem.Contains(\"补正\") && p.CaseNo.StartsWith(\"PAUS\")", Type = "其它" }, new { Id = 25, PointExpress = "0.2", Priority = 112, Rule = "p.DoItem.Contains(\"补正\") && p.CaseNo.StartsWith(\"PAIN\")", Type = "其它" }, new { Id = 26, PointExpress = "0.2", Priority = 111, Rule = "p.DoItem.Contains(\"补正\") && p.CaseNo.StartsWith(\"PAGB\")", Type = "其它" }, new { Id = 27, PointExpress = "0.2", Priority = 110, Rule = "p.DoItem.Contains(\"补正\") && p.CaseNo.StartsWith(\"PAEPO\")", Type = "其它" }, new { Id = 28, PointExpress = "0.2", Priority = 109, Rule = "p.DoItem.Contains(\"补正\") && p.CaseNo.StartsWith(\"PADE\")", Type = "其它" }, new { Id = 29, PointExpress = "0", Priority = 108, Rule = "p.DoItem.Contains(\"补正\") && p.CaseNo.StartsWith(\"WOCN\")", Type = "其它" }, new { Id = 30, PointExpress = "0", Priority = 107, Rule = "p.DoItem.Contains(\"补正\") && p.CaseNo.StartsWith(\"PCTCN\")", Type = "其它" }, new { Id = 31, PointExpress = "0", Priority = 106, Rule = "p.DoItem.Contains(\"补正\") && p.CaseNo.StartsWith(\"PACN\")", Type = "其它" }, new { Id = 32, PointExpress = "0.2", Priority = 105, Rule = "p.DoItem.Contains(\"补正\") && p.CaseNo.StartsWith(\"PAAU\")", Type = "其它" }, new { Id = 33, PointExpress = "0.2", Priority = 104, Rule = "p.AgentFeedbackMemo==\"检索结案\"", Type = "其它" }, new { Id = 34, PointExpress = "0", Priority = 103, Rule = "p.DoItem==\"内部检索\"", Type = "其它" }, new { Id = 35, PointExpress = "0.2", Priority = 102, Rule = "p.DoItem==\"翻译校核\" && p.DoItemCoefficient==\"形式\" && p.AgentFeedbackMemo==\"外-内\"", Type = "其它" }, new { Id = 36, PointExpress = "0.3", Priority = 101, Rule = "p.DoItem==\"翻译校核\" && p.DoItemCoefficient==\"形式\" && p.AgentFeedbackMemo==\"内-外\"", Type = "其它" }, new { Id = 37, PointExpress = "0.5", Priority = 100, Rule = "p.DoItem==\"翻译校核\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"外-内\"", Type = "其它" }, new { Id = 38, PointExpress = "0.7", Priority = 99, Rule = "p.DoItem==\"翻译校核\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"内-外\"", Type = "其它" }, new { Id = 39, PointExpress = "0.2", Priority = 98, Rule = "p.DoItem==\"发明一次OA授权\" && p.ApplicationType==\"发明\"", Type = "其它" }, new { Id = 40, PointExpress = "0", Priority = 97, Rule = "p.DoItem==\"处理审查意见\" && p.AgentFeedbackMemo==\"客户不进行答辩\"", Type = "OA" }, new { Id = 41, PointExpress = "0", Priority = 96, Rule = "p.DoItem==\"处理审查意见\" && p.AgentFeedbackMemo==\"电询/补正\"", Type = "OA" }, new { Id = 42, PointExpress = "0", Priority = 95, Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"实用新型\" && p.AgentFeedbackMemo==\"不请款\"", Type = "OA" }, new { Id = 43, PointExpress = "0", Priority = 94, Rule = "p.DoItem==\"意见陈述\" && p.ApplicationType==\"实用新型\" && p.AgentFeedbackMemo==\"不请款\"", Type = "OA" }, new { Id = 44, PointExpress = "0", Priority = 93, Rule = "p.DoItem==\"请求复审\" && p.ApplicationType==\"实用新型\" && p.AgentFeedbackMemo==\"不请款\"", Type = "OA" }, new { Id = 45, PointExpress = "0.14", Priority = 92, Rule = "p.DoItem==\"意见陈述\" && p.ApplicationType==\"实用新型\" && p.AgentFeedbackMemo==\"请款\"", Type = "OA" }, new { Id = 46, PointExpress = "0.35", Priority = 91, Rule = "p.DoItem==\"请求复审\" && p.ApplicationType==\"实用新型\" && p.AgentFeedbackMemo==\"请款\"", Type = "OA" }, new { Id = 47, PointExpress = "0.21", Priority = 90, Rule = "p.ApplicationType==\"实用新型\" && p.DoItemCoefficient==\"非实质\" && p.CaseStage==\"一通\" && p.AgentFeedbackMemo==\"请款\"", Type = "OA" }, new { Id = 48, PointExpress = "0.35", Priority = 89, Rule = "p.ApplicationType==\"实用新型\" && p.DoItemCoefficient==\"实质\" && p.CaseStage==\"一通\" && p.AgentFeedbackMemo==\"请款\"", Type = "OA" }, new { Id = 49, PointExpress = "0.14", Priority = 88, Rule = "p.ApplicationType==\"实用新型\" && p.DoItemCoefficient==\"形式\" && p.CaseStage==\"一通\" && p.AgentFeedbackMemo==\"请款\"", Type = "OA" }, new { Id = 50, PointExpress = "0.14", Priority = 87, Rule = "p.ApplicationType==\"实用新型\" && p.DoItemCoefficient==\"实质\" && p.CaseStage==\"二通\" && p.AgentFeedbackMemo==\"请款\"", Type = "OA" }, new { Id = 51, PointExpress = "0", Priority = 86, Rule = "p.ApplicationType==\"实用新型\" && p.DoItemCoefficient==\"实质\" && (p.CaseStage==\"三通\" || p.CaseStage==\"四通\" || p.CaseStage==\"五通\" || p.CaseStage==\"六通\" || p.CaseStage==\"七通\" || p.CaseStage==\"八通\") ", Type = "OA" }, new { Id = 52, PointExpress = "0.2", Priority = 85, Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"形式\" && p.AgentFeedbackMemo==\"外所/他人首次转入OA\"", Type = "OA" }, new { Id = 53, PointExpress = "0.5", Priority = 84, Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"外所/他人首次转入OA\"", Type = "OA" }, new { Id = 54, PointExpress = "0.3", Priority = 83, Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"非实质\" && p.AgentFeedbackMemo==\"外所/他人首次转入OA\"", Type = "OA" }, new { Id = 55, PointExpress = "0", Priority = 82, Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PCTCN\") && (p.CaseStage==\"三通\" || p.CaseStage==\"四通\" || p.CaseStage==\"五通\")", Type = "OA" }, new { Id = 56, PointExpress = "0", Priority = 81, Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && (p.CaseStage==\"三通\" || p.CaseStage==\"四通\" || p.CaseStage==\"五通\")", Type = "OA" }, new { Id = 57, PointExpress = "0.2", Priority = 80, Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PCTCN\") && p.CaseStage==\"二通\"", Type = "OA" }, new { Id = 58, PointExpress = "0.2", Priority = 79, Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"二通\"", Type = "OA" }, new { Id = 59, PointExpress = "0.2", Priority = 78, Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PCTCN\") && p.CaseStage==\"一通\"", Type = "OA" }, new { Id = 60, PointExpress = "0.5", Priority = 77, Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PCTCN\") && p.CaseStage==\"一通\"", Type = "OA" }, new { Id = 61, PointExpress = "0.3", Priority = 76, Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"非实质\" && p.CaseNo.StartsWith(\"PCTCN\") && p.CaseStage==\"一通\"", Type = "OA" }, new { Id = 62, PointExpress = "0.2", Priority = 75, Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"一通\"", Type = "OA" }, new { Id = 63, PointExpress = "0.5", Priority = 74, Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"一通\"", Type = "OA" }, new { Id = 64, PointExpress = "0.3", Priority = 73, Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"非实质\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"一通\"", Type = "OA" }, new { Id = 65, PointExpress = "0.2", Priority = 72, Rule = "p.DoItem==\"意见陈述\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"复审\"", Type = "OA" }, new { Id = 66, PointExpress = "0.5", Priority = 71, Rule = "p.DoItem==\"请求复审\" && p.ApplicationType==\"发明\"", Type = "OA" }, new { Id = 67, PointExpress = "0.1", Priority = 70, Rule = "p.AgentFeedbackMemo==\"涉外OA不答辩，发报导函结案\"", Type = "其它" }, new { Id = 68, PointExpress = "0.8", Priority = 69, Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"客户未提供答辩点，撰写英文报导函\"", Type = "OA" }, new { Id = 69, PointExpress = "0.5", Priority = 68, Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"客户提供答辩点，撰写英文报导函\"", Type = "OA" }, new { Id = 70, PointExpress = "0.2", Priority = 67, Rule = "p.DoItem==\"申復\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PATW\")", Type = "OA" }, new { Id = 71, PointExpress = "0.5", Priority = 66, Rule = "p.DoItem==\"申復\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PATW\")", Type = "OA" }, new { Id = 72, PointExpress = "0.2", Priority = 65, Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAIN\")", Type = "OA" }, new { Id = 73, PointExpress = "0.2", Priority = 64, Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAGB\")", Type = "OA" }, new { Id = 74, PointExpress = "0.2", Priority = 63, Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAEPO\")", Type = "OA" }, new { Id = 75, PointExpress = "0.3", Priority = 62, Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PADE\")", Type = "OA" }, new { Id = 76, PointExpress = "0.2", Priority = 61, Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAAU\")", Type = "OA" }, new { Id = 77, PointExpress = "1.5", Priority = 60, Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAIN\")", Type = "OA" }, new { Id = 78, PointExpress = "1.5", Priority = 59, Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAGB\")", Type = "OA" }, new { Id = 79, PointExpress = "1.5", Priority = 58, Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAEPO\")", Type = "OA" }, new { Id = 80, PointExpress = "1.6", Priority = 57, Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PADE\")", Type = "OA" }, new { Id = 81, PointExpress = "1.5", Priority = 56, Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAAU\")", Type = "OA" }, new { Id = 82, PointExpress = "0.2", Priority = 55, Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAUS\")", Type = "OA" }, new { Id = 83, PointExpress = "1.5", Priority = 54, Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAUS\")", Type = "OA" }, new { Id = 84, PointExpress = "1.5", Priority = 53, Rule = "p.DoItem==\"口审评估\" && p.DoItemCoefficient==\"实质\"", Type = "OA" }, new { Id = 85, PointExpress = "0.2", Priority = 52, Rule = "p.DoItem==\"口审评估\" && p.DoItemCoefficient==\"形式\"", Type = "OA" }, new { Id = 86, PointExpress = "0.2", Priority = 51, Rule = "p.DoItem==\"欧洲案答辩\" && p.DoItemCoefficient==\"形式\"", Type = "OA" }, new { Id = 87, PointExpress = "1.5", Priority = 50, Rule = "p.DoItem==\"欧洲案答辩\" && p.DoItemCoefficient==\"实质\"", Type = "OA" }, new { Id = 88, PointExpress = "0.2", Priority = 49, Rule = "p.DoItem==\"RCE\" && p.DoItemCoefficient==\"形式\"", Type = "OA" }, new { Id = 89, PointExpress = "1.5", Priority = 48, Rule = "p.DoItem==\"RCE\" && p.DoItemCoefficient==\"实质\"", Type = "OA" }, new { Id = 90, PointExpress = "0.2", Priority = 47, Rule = "p.DoItem==\"Non Final Action\" && p.DoItemCoefficient==\"形式\"", Type = "OA" }, new { Id = 91, PointExpress = "1.5", Priority = 46, Rule = "p.DoItem==\"Non Final Action\" && p.DoItemCoefficient==\"实质\"", Type = "OA" }, new { Id = 92, PointExpress = "0.1", Priority = 45, Rule = "p.DoItem==\"form 3-8（2）\" || p.DoItem==\"Form 3-8(2)\" || p.DoItem==\"Form 3-8(2)\"", Type = "OA" }, new { Id = 93, PointExpress = "0.1", Priority = 44, Rule = "p.DoItem==\"form 3\"", Type = "OA" }, new { Id = 94, PointExpress = "0.2", Priority = 43, Rule = "p.DoItem==\"Final Action\" && p.DoItemCoefficient==\"形式\"", Type = "OA" }, new { Id = 95, PointExpress = "1.5", Priority = 42, Rule = "p.DoItem==\"Final Action\" && p.DoItemCoefficient==\"实质\"", Type = "OA" }, new { Id = 96, PointExpress = "0.2", Priority = 41, Rule = "p.DoItem==\"Advisory Action\" && p.DoItemCoefficient==\"形式\"", Type = "OA" }, new { Id = 97, PointExpress = "1.5", Priority = 40, Rule = "p.DoItem==\"Advisory Action\" && p.DoItemCoefficient==\"实质\"", Type = "OA" }, new { Id = 98, PointExpress = "p.WordCount/1000*0.18", Priority = 39, Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"中-德\" && p.WordCount !=null", Type = "其它" }, new { Id = 99, PointExpress = "p.WordCount/1000*0.16", Priority = 38, Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"中-英\" && p.WordCount !=null", Type = "其它" }, new { Id = 100, PointExpress = "p.WordCount/1000*0.1", Priority = 37, Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"英-中\" && p.WordCount !=null", Type = "其它" }, new { Id = 101, PointExpress = "0", Priority = 36, Rule = "(p.ApplicationType==\"实用新型\" || p.ApplicationType==\"发明\") && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"客户不进行答辩\"", Type = "其它" }, new { Id = 102, PointExpress = "1.26", Priority = 35, Rule = "p.CaseNo.StartsWith(\"PAUS\") && p.AgentFeedbackMemo==\"发文后客户原因取消申请，系统结案\"", Type = "新申请" }, new { Id = 103, PointExpress = "1.33", Priority = 34, Rule = "p.CaseNo.StartsWith(\"PADE\") && p.AgentFeedbackMemo==\"发文后客户原因取消申请，系统结案\"", Type = "新申请" }, new { Id = 104, PointExpress = "0.7", Priority = 33, Rule = "p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"发文后客户取消申请\"", Type = "新申请" }, new { Id = 105, PointExpress = "0.49", Priority = 32, Rule = "p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"发文后客户取消申请\"", Type = "新申请" }, new { Id = 106, PointExpress = "0", Priority = 31, Rule = "p.AgentFeedbackMemo==\"撰写中客户取消申请\"", Type = "其它" }, new { Id = 107, PointExpress = "1.5", Priority = 30, Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PCTCN\") && p.AgentFeedbackMemo==\"外到内首次申请\"", Type = "新申请" }, new { Id = 108, PointExpress = "0.1", Priority = 29, Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"转格式\"", Type = "其它" }, new { Id = 109, PointExpress = "1.5", Priority = 28, Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"外-内首次申请\"", Type = "新申请" }, new { Id = 110, PointExpress = "1", Priority = 27, Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"首次中文案\"", Type = "新申请" }, new { Id = 111, PointExpress = "0.7", Priority = 26, Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"涉外实质改权\"", Type = "新申请" }, new { Id = 112, PointExpress = "0.5", Priority = 25, Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"改权+改说明书\"", Type = "其它" }, new { Id = 113, PointExpress = "0.3", Priority = 24, Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"改权\"", Type = "其它" }, new { Id = 114, PointExpress = "1.8", Priority = 23, Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"PCT首次英文案\"", Type = "新申请" }, new { Id = 115, PointExpress = "0.2", Priority = 22, Rule = "p.AgentFeedbackMemo==\"我方转格式、复核\"", Type = "其它" }, new { Id = 116, PointExpress = "0", Priority = 21, Rule = "p.AgentFeedbackMemo==\"我方代交\"", Type = "其它" }, new { Id = 117, PointExpress = "0.5", Priority = 20, Rule = "p.CaseNo.StartsWith(\"PAUS\") && (p.CaseNo.EndsWith(\"-同套\") || p.CaseNo.EndsWith(\"CA\") || p.CaseNo.EndsWith(\"CIP\") || p.CaseNo.EndsWith(\"分案\")) ", Type = "其它" }, new { Id = 118, PointExpress = "0.2", Priority = 19, Rule = "(p.CaseNo.StartsWith(\"PAMY \") || p.CaseNo.StartsWith(\"PADE\") || p.CaseNo.StartsWith(\"PAGB\") || p.CaseNo.StartsWith(\"PAIN\") || p.CaseNo.StartsWith(\"PAUS\") || p.CaseNo.StartsWith(\"PAEPO\") ) && p.AgentFeedbackMemo==\"同套\"", Type = "其它" }, new { Id = 119, PointExpress = "0.3", Priority = 18, Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseNo.EndsWith(\"-分案\")", Type = "其它" }, new { Id = 120, PointExpress = "1.8", Priority = 17, Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"欧洲案首次\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PAEPO\")", Type = "新申请" }, new { Id = 121, PointExpress = "0.2", Priority = 16, Rule = "p.DoItem==\"新申请\" && p.CaseNo.StartsWith(\"PATW\") && p.AgentFeedbackMemo==\"大陆案转台湾案\"", Type = "其它" }, new { Id = 122, PointExpress = "1", Priority = 15, Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"同套大陆+台湾\"", Type = "新申请" }, new { Id = 123, PointExpress = "0.2", Priority = 14, Rule = "p.DoItem==\"新申请\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"台湾案转大陆案\"", Type = "其它" }, new { Id = 124, PointExpress = "0.1", Priority = 13, Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PATW\") && p.AgentFeedbackMemo==\"同套大陆+台湾\"", Type = "其它" }, new { Id = 125, PointExpress = "0.7", Priority = 12, Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"同套大陆+台湾\"", Type = "新申请" }, new { Id = 126, PointExpress = "0.1", Priority = 11, Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PATW\") && p.AgentFeedbackMemo==\"同套大陆+台湾\"", Type = "其它" }, new { Id = 127, PointExpress = "1.7", Priority = 10, Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PAUS\") && (p.Customer!=null && p.Customer.Name.Contains(\"OPPO\"))", Type = "新申请" }, new { Id = 128, PointExpress = "1.8", Priority = 9, Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PAUS\")", Type = "新申请" }, new { Id = 129, PointExpress = "1.8", Priority = 8, Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PAGB\")", Type = "新申请" }, new { Id = 130, PointExpress = "0.2", Priority = 7, Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PAEPO\")", Type = "其它" }, new { Id = 131, PointExpress = "1.9", Priority = 6, Rule = "p.DoItem==\"新申请\" && p.CaseNo.StartsWith(\"PADE\")", Type = "新申请" }, new { Id = 132, PointExpress = "0.1", Priority = 5, Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseNo.EndsWith(\"-TS\")", Type = "其它" }, new { Id = 133, PointExpress = "1", Priority = 4, Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PACN\") && (p.Customer!=null && p.Customer.Name.Contains(\"OPPO\"))", Type = "新申请" }, new { Id = 134, PointExpress = "0.7", Priority = 3, Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PACN\")", Type = "新申请" }, new { Id = 135, PointExpress = "1", Priority = 2, Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseNo.EndsWith(\"-TS\")", Type = "新申请" }, new { Id = 136, PointExpress = "1", Priority = 1, Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\")", Type = "新申请" }, new { Id = 137, PointExpress = "0", Priority = 250, Rule = "p.CaseNo.StartsWith(\"S\")", Type = "专案" }); }); modelBuilder.Entity("wispro.sp.entity.CalMonth", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("Month") .HasColumnType("int") .HasColumnName("month"); b.Property("Status") .HasColumnType("int") .HasColumnName("status"); b.Property("Year") .HasColumnType("int") .HasColumnName("year"); b.HasKey("Id"); b.ToTable("CalMonth"); }); modelBuilder.Entity("wispro.sp.entity.CaseCeoffcient", b => { b.Property("Ceoffcient") .HasColumnType("nvarchar(450)"); b.Property("Value") .HasColumnType("float"); b.HasKey("Ceoffcient"); b.ToTable("CaseCeofficient"); b.HasData( new { Ceoffcient = "S", Value = 2.5 }, new { Ceoffcient = "A", Value = 1.5 }, new { Ceoffcient = "B", Value = 1.0 }, new { Ceoffcient = "C", Value = 0.69999999999999996 }, new { Ceoffcient = "D", Value = 0.40000000000000002 }); }); modelBuilder.Entity("wispro.sp.entity.Customer", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("Address") .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property("ContactMan") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("Name") .IsRequired() .HasMaxLength(200) .HasColumnType("nvarchar(200)"); b.Property("Phone") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("ResponseManId") .HasColumnType("int"); b.HasKey("Id"); b.HasIndex("ResponseManId"); b.ToTable("Customer"); }); modelBuilder.Entity("wispro.sp.entity.Department", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("Memo") .HasColumnType("nvarchar(max)"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.Property("ancestors") .HasColumnType("nvarchar(max)"); b.Property("order_num") .HasColumnType("int"); b.Property("parentId") .HasColumnType("int"); b.HasKey("Id"); b.ToTable("Department"); }); modelBuilder.Entity("wispro.sp.entity.DepartmentPosition", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("PositionId") .HasColumnType("int"); b.Property("StaffId") .HasColumnType("int"); b.Property("departmentId") .HasColumnType("int"); b.HasKey("Id"); b.HasIndex("PositionId"); b.HasIndex("StaffId"); b.HasIndex("departmentId"); b.ToTable("DepartmentPosition"); }); modelBuilder.Entity("wispro.sp.entity.InputField", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("AppealState") .HasColumnType("int"); b.Property("AppealTypeId") .HasColumnType("int"); b.Property("CanMuliSelect") .HasColumnType("bit"); b.Property("FieldName") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("FieldType") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("MapObjectField") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("MapObjectFieldLabel") .HasColumnType("nvarchar(max)"); b.Property("MapSaveCondition") .HasColumnType("nvarchar(max)"); b.Property("MaxSize") .HasColumnType("int"); b.HasKey("Id"); b.HasIndex("AppealTypeId"); b.ToTable("InputField"); b.HasData( new { Id = 1, AppealState = 0, AppealTypeId = 1, CanMuliSelect = false, FieldName = "分配比率", FieldType = "System.Double", MapObjectField = "ItemStaffs.PerformancePoint", MapObjectFieldLabel = "ItemStaffs.DoPerson.Name" }, new { Id = 3, AppealState = 0, AppealTypeId = 1, CanMuliSelect = false, FieldName = "原因", FieldType = "System.String" }, new { Id = 4, AppealState = 1, AppealTypeId = 1, CanMuliSelect = false, FieldName = "备注", FieldType = "System.String" }, new { Id = 5, AppealState = 1, AppealTypeId = 1, CanMuliSelect = false, FieldName = "审核意见", FieldType = "System.String" }, new { Id = 6, AppealState = 0, AppealTypeId = 2, CanMuliSelect = false, FieldName = "案件系数", FieldType = "System.String", MapObjectField = "CaseCoefficient" }, new { Id = 9, AppealState = 1, AppealTypeId = 2, CanMuliSelect = false, FieldName = "备注", FieldType = "System.String" }, new { Id = 10, AppealState = 1, AppealTypeId = 2, CanMuliSelect = false, FieldName = "审核意见", FieldType = "System.String" }, new { Id = 11, AppealState = 0, AppealTypeId = 3, CanMuliSelect = false, FieldName = "处理事项系数", FieldType = "System.String", MapObjectField = "DoItemCoefficient" }, new { Id = 12, AppealState = 1, AppealTypeId = 3, CanMuliSelect = false, FieldName = "备注", FieldType = "System.String" }, new { Id = 13, AppealState = 1, AppealTypeId = 3, CanMuliSelect = false, FieldName = "审核意见", FieldType = "System.String" }, new { Id = 14, AppealState = 0, AppealTypeId = 4, CanMuliSelect = false, FieldName = "我方文号", FieldType = "System.String" }, new { Id = 15, AppealState = 0, AppealTypeId = 4, CanMuliSelect = false, FieldName = "处理事项", FieldType = "System.String" }, new { Id = 16, AppealState = 1, AppealTypeId = 4, CanMuliSelect = false, FieldName = "备注", FieldType = "System.String" }, new { Id = 17, AppealState = 1, AppealTypeId = 4, CanMuliSelect = false, FieldName = "审核意见", FieldType = "System.String" }, new { Id = 18, AppealState = 0, AppealTypeId = 5, CanMuliSelect = false, FieldName = "超期说明", FieldType = "System.String", MapObjectField = "OverDueMemo" }, new { Id = 21, AppealState = 1, AppealTypeId = 5, CanMuliSelect = false, FieldName = "审核意见", FieldType = "System.String" }, new { Id = 22, AppealState = 1, AppealTypeId = 5, CanMuliSelect = false, FieldName = "备注", FieldType = "System.String" }, new { Id = 19, AppealState = 0, AppealTypeId = 6, CanMuliSelect = false, FieldName = "翻译类型", FieldType = "System.String", MapObjectField = "AgentFeedbackMemo" }, new { Id = 20, AppealState = 0, AppealTypeId = 6, CanMuliSelect = false, FieldName = "翻译字数", FieldType = "System.Int32", MapObjectField = "WordCount" }, new { Id = 23, AppealState = 1, AppealTypeId = 6, CanMuliSelect = false, FieldName = "审核意见", FieldType = "System.Int32" }, new { Id = 24, AppealState = 1, AppealTypeId = 6, CanMuliSelect = false, FieldName = "翻译字数", FieldType = "System.Int32", MapObjectField = "WordCount" }); }); modelBuilder.Entity("wispro.sp.entity.InputFieldValue", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("AppealRecordId") .HasColumnType("int"); b.Property("InputFieldId") .HasColumnType("int"); b.Property("Label") .HasColumnType("nvarchar(max)"); b.Property("Value") .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property("mapExpress") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.HasIndex("AppealRecordId"); b.HasIndex("InputFieldId"); b.ToTable("InputFieldValue"); }); modelBuilder.Entity("wispro.sp.entity.ItemStaff", b => { b.Property("ItemId") .HasColumnType("int"); b.Property("DoPersonId") .HasColumnType("int"); b.Property("PerformancePoint") .HasColumnType("float"); b.HasKey("ItemId", "DoPersonId"); b.HasIndex("DoPersonId"); b.ToTable("ItemStaff"); }); modelBuilder.Entity("wispro.sp.entity.Message", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("uniqueidentifier"); b.Property("FromId") .HasColumnType("int"); b.Property("MessageInfo") .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property("Type") .HasColumnType("int"); b.HasKey("Id"); b.HasIndex("FromId"); b.ToTable("Message"); }); modelBuilder.Entity("wispro.sp.entity.MessagePerformanceItem", b => { b.Property("ItemId") .HasColumnType("int"); b.Property("MessageId") .HasColumnType("uniqueidentifier"); b.HasKey("ItemId", "MessageId"); b.HasIndex("MessageId"); b.ToTable("MessagePerformanceItems"); }); modelBuilder.Entity("wispro.sp.entity.MessageReadRecord", b => { b.Property("MessageId") .HasColumnType("uniqueidentifier"); b.Property("StaffId") .HasColumnType("int"); b.Property("MessageId1") .HasColumnType("uniqueidentifier"); b.Property("isReaded") .HasColumnType("bit"); b.HasKey("MessageId", "StaffId"); b.HasIndex("MessageId1"); b.HasIndex("StaffId"); b.ToTable("MessageReadRecord"); }); modelBuilder.Entity("wispro.sp.entity.PerformanceItem", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("AgentFeedbackMemo") .HasColumnType("nvarchar(max)"); b.Property("ApplicationName") .HasMaxLength(200) .HasColumnType("nvarchar(200)"); b.Property("ApplicationType") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("BasePoint") .HasColumnType("numeric(18,2)"); b.Property("BusinessType") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("CalMonthId") .HasColumnType("int"); b.Property("CaseCoefficient") .HasMaxLength(10) .HasColumnType("nvarchar(10)"); b.Property("CaseMemo") .HasColumnType("nvarchar(max)"); b.Property("CaseName") .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property("CaseNo") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("CaseStage") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("CaseState") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("CaseType") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("CustomerId") .HasColumnType("int"); b.Property("CustomerLimitDate") .HasColumnType("date"); b.Property("DoItem") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("DoItemCoefficient") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("DoItemMemo") .HasMaxLength(500) .HasColumnType("nvarchar(500)"); b.Property("DoItemState") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("EntrustingDate") .HasColumnType("date"); b.Property("FinalizationDate") .HasColumnType("date"); b.Property("FinishedDate") .HasColumnType("date"); b.Property("FirstDraftDate") .HasColumnType("date"); b.Property("InternalDate") .HasColumnType("date"); b.Property("OverDueMemo") .HasMaxLength(100) .HasColumnType("nvarchar(100)"); b.Property("PreOastaffId") .HasColumnType("int") .HasColumnName("PreOAStaffId"); b.Property("ReturnCasseNo") .HasColumnType("nvarchar(max)"); b.Property("ReturnDate") .HasColumnType("date"); b.Property("ReviewerId") .HasColumnType("int"); b.Property("Status") .HasColumnType("int"); b.Property("Type") .HasColumnType("nvarchar(max)"); b.Property("WordCount") .HasColumnType("int"); b.HasKey("Id"); b.HasIndex("CalMonthId"); b.HasIndex("CustomerId"); b.HasIndex("PreOastaffId"); b.HasIndex("ReviewerId"); b.ToTable("PerformanceItem"); }); modelBuilder.Entity("wispro.sp.entity.Position", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("Memo") .HasColumnType("nvarchar(max)"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.ToTable("Position"); }); modelBuilder.Entity("wispro.sp.entity.SelectValue", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("InputFieldId") .HasColumnType("int"); b.Property("Value") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.HasIndex("InputFieldId"); b.ToTable("SelectValue"); b.HasData( new { Id = 1, InputFieldId = 5, Value = "同意" }, new { Id = 2, InputFieldId = 5, Value = "拒绝" }, new { Id = 3, InputFieldId = 10, Value = "同意" }, new { Id = 4, InputFieldId = 10, Value = "拒绝" }, new { Id = 5, InputFieldId = 13, Value = "同意" }, new { Id = 6, InputFieldId = 13, Value = "拒绝" }, new { Id = 7, InputFieldId = 17, Value = "同意" }, new { Id = 8, InputFieldId = 17, Value = "拒绝" }, new { Id = 9, InputFieldId = 6, Value = "S" }, new { Id = 10, InputFieldId = 6, Value = "A" }, new { Id = 11, InputFieldId = 6, Value = "B" }, new { Id = 12, InputFieldId = 6, Value = "C" }, new { Id = 13, InputFieldId = 6, Value = "D" }, new { Id = 14, InputFieldId = 11, Value = "实质" }, new { Id = 15, InputFieldId = 11, Value = "形式" }, new { Id = 16, InputFieldId = 19, Value = "中-德" }, new { Id = 17, InputFieldId = 19, Value = "中-英" }, new { Id = 18, InputFieldId = 19, Value = "英-中" }, new { Id = 19, InputFieldId = 22, Value = "同意" }, new { Id = 20, InputFieldId = 22, Value = "拒绝" }); }); modelBuilder.Entity("wispro.sp.entity.Staff", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("Account") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("Department") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("EntyDate") .HasColumnType("date"); b.Property("IsCalPerformsnce") .HasColumnType("bit") .HasColumnName("isCalPerformsnce"); b.Property("IsOnJob") .HasColumnType("bit"); b.Property("Mail") .HasColumnType("nvarchar(max)"); b.Property("Memo") .HasColumnType("nvarchar(max)"); b.Property("Mobile") .HasColumnType("nvarchar(max)"); b.Property("Name") .IsRequired() .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.Property("Password") .IsRequired() .HasColumnType("nvarchar(max)"); b.Property("Sex") .HasColumnType("nvarchar(max)"); b.Property("StaffGradeId") .HasColumnType("int"); b.Property("Status") .IsRequired() .HasMaxLength(25) .HasColumnType("nvarchar(25)"); b.Property("Tel") .HasColumnType("nvarchar(max)"); b.Property("WorkPlace") .HasMaxLength(50) .HasColumnType("nvarchar(50)"); b.HasKey("Id"); b.HasIndex("StaffGradeId"); b.ToTable("Staff"); }); modelBuilder.Entity("wispro.sp.entity.StaffGrade", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("Coefficient") .HasColumnType("float"); b.Property("Grade") .IsRequired() .HasMaxLength(5) .HasColumnType("nchar(5)") .IsFixedLength(true); b.HasKey("Id"); b.ToTable("StaffGrade"); b.HasData( new { Id = 1, Coefficient = 1.2, Grade = "S级" }, new { Id = 2, Coefficient = 1.1000000000000001, Grade = "A3级" }, new { Id = 3, Coefficient = 1.1000000000000001, Grade = "A2级" }, new { Id = 4, Coefficient = 1.1000000000000001, Grade = "A1级" }, new { Id = 5, Coefficient = 1.0, Grade = "B3级" }, new { Id = 6, Coefficient = 1.0, Grade = "B2级" }, new { Id = 7, Coefficient = 0.90000000000000002, Grade = "B1级" }, new { Id = 8, Coefficient = 0.90000000000000002, Grade = "C3级" }, new { Id = 9, Coefficient = 0.69999999999999996, Grade = "C2级" }, new { Id = 10, Coefficient = 0.69999999999999996, Grade = "C1级" }, new { Id = 11, Coefficient = 0.59999999999999998, Grade = "D3级" }, new { Id = 12, Coefficient = 0.59999999999999998, Grade = "D2级" }, new { Id = 13, Coefficient = 0.5, Grade = "D1级" }, new { Id = 14, Coefficient = 1.1000000000000001, Grade = "A级" }, new { Id = 15, Coefficient = 1.0, Grade = "C级" }, new { Id = 16, Coefficient = 0.90000000000000002, Grade = "D级" }); }); modelBuilder.Entity("wispro.sp.entity.VerifyCoefficient", b => { b.Property("CheckerId") .HasColumnType("int"); b.Property("DoPersonId") .HasColumnType("int"); b.Property("Coefficient") .HasColumnType("float"); b.HasKey("CheckerId", "DoPersonId"); b.HasIndex("DoPersonId"); b.ToTable("VerifyCoefficient"); b.HasData( new { CheckerId = 1, DoPersonId = 5, Coefficient = 0.29999999999999999 }, new { CheckerId = 1, DoPersonId = 6, Coefficient = 0.29999999999999999 }, new { CheckerId = 1, DoPersonId = 7, Coefficient = 0.29999999999999999 }, new { CheckerId = 1, DoPersonId = 8, Coefficient = 0.29999999999999999 }, new { CheckerId = 1, DoPersonId = 9, Coefficient = 0.40000000000000002 }, new { CheckerId = 1, DoPersonId = 10, Coefficient = 0.40000000000000002 }, new { CheckerId = 1, DoPersonId = 11, Coefficient = 0.5 }, new { CheckerId = 1, DoPersonId = 12, Coefficient = 0.5 }, new { CheckerId = 1, DoPersonId = 13, Coefficient = 0.59999999999999998 }, new { CheckerId = 2, DoPersonId = 5, Coefficient = 0.20000000000000001 }, new { CheckerId = 2, DoPersonId = 6, Coefficient = 0.20000000000000001 }, new { CheckerId = 2, DoPersonId = 7, Coefficient = 0.20000000000000001 }, new { CheckerId = 2, DoPersonId = 8, Coefficient = 0.20000000000000001 }, new { CheckerId = 2, DoPersonId = 9, Coefficient = 0.29999999999999999 }, new { CheckerId = 2, DoPersonId = 10, Coefficient = 0.29999999999999999 }, new { CheckerId = 2, DoPersonId = 11, Coefficient = 0.40000000000000002 }, new { CheckerId = 2, DoPersonId = 12, Coefficient = 0.40000000000000002 }, new { CheckerId = 2, DoPersonId = 13, Coefficient = 0.5 }, new { CheckerId = 3, DoPersonId = 5, Coefficient = 0.20000000000000001 }, new { CheckerId = 3, DoPersonId = 6, Coefficient = 0.20000000000000001 }, new { CheckerId = 3, DoPersonId = 7, Coefficient = 0.20000000000000001 }, new { CheckerId = 3, DoPersonId = 8, Coefficient = 0.20000000000000001 }, new { CheckerId = 3, DoPersonId = 9, Coefficient = 0.29999999999999999 }, new { CheckerId = 3, DoPersonId = 10, Coefficient = 0.29999999999999999 }, new { CheckerId = 3, DoPersonId = 11, Coefficient = 0.40000000000000002 }, new { CheckerId = 3, DoPersonId = 12, Coefficient = 0.40000000000000002 }, new { CheckerId = 3, DoPersonId = 13, Coefficient = 0.5 }, new { CheckerId = 4, DoPersonId = 5, Coefficient = 0.20000000000000001 }, new { CheckerId = 4, DoPersonId = 6, Coefficient = 0.20000000000000001 }, new { CheckerId = 4, DoPersonId = 7, Coefficient = 0.20000000000000001 }, new { CheckerId = 4, DoPersonId = 8, Coefficient = 0.20000000000000001 }, new { CheckerId = 4, DoPersonId = 9, Coefficient = 0.29999999999999999 }, new { CheckerId = 4, DoPersonId = 10, Coefficient = 0.29999999999999999 }, new { CheckerId = 4, DoPersonId = 11, Coefficient = 0.40000000000000002 }, new { CheckerId = 4, DoPersonId = 12, Coefficient = 0.40000000000000002 }, new { CheckerId = 4, DoPersonId = 13, Coefficient = 0.5 }, new { CheckerId = 5, DoPersonId = 5, Coefficient = 0.20000000000000001 }, new { CheckerId = 5, DoPersonId = 6, Coefficient = 0.20000000000000001 }, new { CheckerId = 5, DoPersonId = 7, Coefficient = 0.20000000000000001 }, new { CheckerId = 5, DoPersonId = 8, Coefficient = 0.20000000000000001 }, new { CheckerId = 5, DoPersonId = 9, Coefficient = 0.29999999999999999 }, new { CheckerId = 5, DoPersonId = 10, Coefficient = 0.29999999999999999 }, new { CheckerId = 5, DoPersonId = 11, Coefficient = 0.40000000000000002 }, new { CheckerId = 5, DoPersonId = 12, Coefficient = 0.40000000000000002 }, new { CheckerId = 5, DoPersonId = 13, Coefficient = 0.5 }, new { CheckerId = 6, DoPersonId = 5, Coefficient = 0.20000000000000001 }, new { CheckerId = 6, DoPersonId = 6, Coefficient = 0.20000000000000001 }, new { CheckerId = 6, DoPersonId = 7, Coefficient = 0.20000000000000001 }, new { CheckerId = 6, DoPersonId = 8, Coefficient = 0.20000000000000001 }, new { CheckerId = 6, DoPersonId = 9, Coefficient = 0.29999999999999999 }, new { CheckerId = 6, DoPersonId = 10, Coefficient = 0.29999999999999999 }, new { CheckerId = 6, DoPersonId = 11, Coefficient = 0.40000000000000002 }, new { CheckerId = 6, DoPersonId = 12, Coefficient = 0.40000000000000002 }, new { CheckerId = 6, DoPersonId = 13, Coefficient = 0.5 }); }); modelBuilder.Entity("wispro.sp.entity.workflowDefine.Action", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("InputForm") .HasColumnType("nvarchar(max)"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.Property("OnActionObjectType") .HasColumnType("nvarchar(max)"); b.Property("StepId") .HasColumnType("int"); b.HasKey("Id"); b.HasIndex("StepId"); b.ToTable("Action"); }); modelBuilder.Entity("wispro.sp.entity.workflowDefine.InputValueSetting", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("DisplayName") .HasColumnType("nvarchar(max)"); b.Property("Options") .HasColumnType("nvarchar(max)"); b.Property("ParentSettingId") .HasColumnType("int"); b.Property("actionId") .HasColumnType("int"); b.Property("bindField") .HasColumnType("nvarchar(max)"); b.Property("bindFieldSavetoObjectCondition") .HasColumnType("nvarchar(max)"); b.Property("valueType") .HasColumnType("int"); b.HasKey("Id"); b.HasIndex("ParentSettingId"); b.HasIndex("actionId"); b.ToTable("InputValueSetting"); }); modelBuilder.Entity("wispro.sp.entity.workflowDefine.Step", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("Name") .HasColumnType("nvarchar(max)"); b.Property("defaultResponseSetting") .HasColumnType("nvarchar(max)"); b.Property("stepType") .HasColumnType("int"); b.Property("workflowId") .HasColumnType("int"); b.HasKey("Id"); b.HasIndex("workflowId"); b.ToTable("Step"); }); modelBuilder.Entity("wispro.sp.entity.workflowDefine.TrasferCondition", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("Condition") .HasColumnType("nvarchar(max)"); b.Property("StepId") .HasColumnType("int"); b.Property("nextStepId") .HasColumnType("int"); b.HasKey("Id"); b.HasIndex("StepId"); b.HasIndex("nextStepId"); b.ToTable("TrasferCondition"); }); modelBuilder.Entity("wispro.sp.entity.workflowDefine.Workflow", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("ContentObjectType") .HasColumnType("nvarchar(max)"); b.Property("EndStepId") .HasColumnType("int"); b.Property("InitActionId") .HasColumnType("int"); b.Property("Name") .HasColumnType("nvarchar(max)"); b.HasKey("Id"); b.HasIndex("InitActionId"); b.ToTable("Workflow"); }); modelBuilder.Entity("wispro.sp.entity.workflowInstance.InputValue", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("value") .HasColumnType("nvarchar(max)"); b.Property("valueSettingId") .HasColumnType("int"); b.Property("workflowInstanceId") .HasColumnType("int"); b.HasKey("Id"); b.HasIndex("valueSettingId"); b.HasIndex("workflowInstanceId"); b.ToTable("InputValue"); }); modelBuilder.Entity("wispro.sp.entity.workflowInstance.StepInstance", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("PreviousStepId") .HasColumnType("int"); b.Property("stepId") .HasColumnType("int"); b.Property("workflowInstanceId") .HasColumnType("int"); b.HasKey("Id"); b.HasIndex("stepId"); b.HasIndex("workflowInstanceId"); b.ToTable("StepInstance"); }); modelBuilder.Entity("wispro.sp.entity.workflowInstance.WorkflowInstance", b => { b.Property("Id") .ValueGeneratedOnAdd() .HasColumnType("int") .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn); b.Property("ObjectId") .HasColumnType("int"); b.Property("workflowId") .HasColumnType("int"); b.HasKey("Id"); b.HasIndex("workflowId"); b.ToTable("WorkflowInstance"); }); modelBuilder.Entity("wispro.sp.entity.AppealRecord", b => { b.HasOne("wispro.sp.entity.Staff", "Creater") .WithMany() .HasForeignKey("CreaterId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("wispro.sp.entity.PerformanceItem", "Item") .WithMany() .HasForeignKey("ItemId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("wispro.sp.entity.Staff", "Reviewer") .WithMany() .HasForeignKey("ReviewerId") .OnDelete(DeleteBehavior.NoAction); b.HasOne("wispro.sp.entity.AppealType", "Type") .WithMany() .HasForeignKey("TypeId") .OnDelete(DeleteBehavior.NoAction) .IsRequired(); b.Navigation("Creater"); b.Navigation("Item"); b.Navigation("Reviewer"); b.Navigation("Type"); }); modelBuilder.Entity("wispro.sp.entity.AttachFile", b => { b.HasOne("wispro.sp.entity.AppealRecord", "AppealRecord") .WithMany("AttachFiles") .HasForeignKey("AppealRecordId") .HasConstraintName("FK_AttachFile_AppealRecord"); b.HasOne("wispro.sp.entity.Staff", "UploadUser") .WithMany() .HasForeignKey("UploadUserId") .HasConstraintName("FK_AttachFile_UpdateUser") .OnDelete(DeleteBehavior.NoAction); b.Navigation("AppealRecord"); b.Navigation("UploadUser"); }); modelBuilder.Entity("wispro.sp.entity.Customer", b => { b.HasOne("wispro.sp.entity.Staff", "ResponseMan") .WithMany("Customers") .HasForeignKey("ResponseManId") .HasConstraintName("FK_Customer_Staff"); b.Navigation("ResponseMan"); }); modelBuilder.Entity("wispro.sp.entity.DepartmentPosition", b => { b.HasOne("wispro.sp.entity.Position", "Position") .WithMany() .HasForeignKey("PositionId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("wispro.sp.entity.Staff", "Staff") .WithMany("Positions") .HasForeignKey("StaffId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("wispro.sp.entity.Department", "department") .WithMany() .HasForeignKey("departmentId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("department"); b.Navigation("Position"); b.Navigation("Staff"); }); modelBuilder.Entity("wispro.sp.entity.InputField", b => { b.HasOne("wispro.sp.entity.AppealType", "AppealType") .WithMany() .HasForeignKey("AppealTypeId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("AppealType"); }); modelBuilder.Entity("wispro.sp.entity.InputFieldValue", b => { b.HasOne("wispro.sp.entity.AppealRecord", "AppealRecord") .WithMany() .HasForeignKey("AppealRecordId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("wispro.sp.entity.InputField", "InputField") .WithMany() .HasForeignKey("InputFieldId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("AppealRecord"); b.Navigation("InputField"); }); modelBuilder.Entity("wispro.sp.entity.ItemStaff", b => { b.HasOne("wispro.sp.entity.Staff", "DoPerson") .WithMany("ItemStaffs") .HasForeignKey("DoPersonId") .HasConstraintName("FK_ItemStaff_Staff") .IsRequired(); b.HasOne("wispro.sp.entity.PerformanceItem", "Item") .WithMany("ItemStaffs") .HasForeignKey("ItemId") .HasConstraintName("FK_ItemStaff_PerformanceItem") .IsRequired(); b.Navigation("DoPerson"); b.Navigation("Item"); }); modelBuilder.Entity("wispro.sp.entity.Message", b => { b.HasOne("wispro.sp.entity.Staff", "From") .WithMany() .HasForeignKey("FromId") .HasConstraintName("FK_From_Staff") .IsRequired(); b.Navigation("From"); }); modelBuilder.Entity("wispro.sp.entity.MessagePerformanceItem", b => { b.HasOne("wispro.sp.entity.PerformanceItem", "Item") .WithMany() .HasForeignKey("ItemId") .HasConstraintName("FK_MessagePerformanceItem_Item") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("wispro.sp.entity.Message", "Message") .WithMany("RelatedItem") .HasForeignKey("MessageId") .HasConstraintName("FK_MessagePerformanceItem_Message") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("Item"); b.Navigation("Message"); }); modelBuilder.Entity("wispro.sp.entity.MessageReadRecord", b => { b.HasOne("wispro.sp.entity.Message", "Message") .WithMany() .HasForeignKey("MessageId") .HasConstraintName("FK_MessageReadRecord_Message") .IsRequired(); b.HasOne("wispro.sp.entity.Message", null) .WithMany("To") .HasForeignKey("MessageId1"); b.HasOne("wispro.sp.entity.Staff", "Staff") .WithMany() .HasForeignKey("StaffId") .HasConstraintName("FK_MessageReadRecord_Staff") .IsRequired(); b.Navigation("Message"); b.Navigation("Staff"); }); modelBuilder.Entity("wispro.sp.entity.PerformanceItem", b => { b.HasOne("wispro.sp.entity.CalMonth", "CalMonth") .WithMany("PerformanceItems") .HasForeignKey("CalMonthId") .HasConstraintName("FK_PerformanceItem_CalMonth") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("wispro.sp.entity.Customer", "Customer") .WithMany("PerformanceItems") .HasForeignKey("CustomerId") .HasConstraintName("FK_PerformanceItem_Customer"); b.HasOne("wispro.sp.entity.Staff", "PreOastaff") .WithMany() .HasForeignKey("PreOastaffId") .HasConstraintName("FK_PerformanceItem_Staff"); b.HasOne("wispro.sp.entity.Staff", "Reviewer") .WithMany("ReviewerItems") .HasForeignKey("ReviewerId") .HasConstraintName("FK_PerformanceItem_Reviewer"); b.Navigation("CalMonth"); b.Navigation("Customer"); b.Navigation("PreOastaff"); b.Navigation("Reviewer"); }); modelBuilder.Entity("wispro.sp.entity.SelectValue", b => { b.HasOne("wispro.sp.entity.InputField", "InputField") .WithMany("SelectValues") .HasForeignKey("InputFieldId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("InputField"); }); modelBuilder.Entity("wispro.sp.entity.Staff", b => { b.HasOne("wispro.sp.entity.StaffGrade", "StaffGrade") .WithMany("Staff") .HasForeignKey("StaffGradeId") .HasConstraintName("FK_Staff_StaffGrade"); b.Navigation("StaffGrade"); }); modelBuilder.Entity("wispro.sp.entity.VerifyCoefficient", b => { b.HasOne("wispro.sp.entity.StaffGrade", "Checker") .WithMany("VerifyCoefficientCheckers") .HasForeignKey("CheckerId") .HasConstraintName("FK_VerifyCoefficient_StaffGrade") .IsRequired(); b.HasOne("wispro.sp.entity.StaffGrade", "DoPerson") .WithMany("VerifyCoefficientDoPeople") .HasForeignKey("DoPersonId") .HasConstraintName("FK_VerifyCoefficient_StaffGrade1") .IsRequired(); b.Navigation("Checker"); b.Navigation("DoPerson"); }); modelBuilder.Entity("wispro.sp.entity.workflowDefine.Action", b => { b.HasOne("wispro.sp.entity.workflowDefine.Step", "step") .WithMany() .HasForeignKey("StepId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("step"); }); modelBuilder.Entity("wispro.sp.entity.workflowDefine.InputValueSetting", b => { b.HasOne("wispro.sp.entity.workflowDefine.InputValueSetting", "ParentSetting") .WithMany() .HasForeignKey("ParentSettingId"); b.HasOne("wispro.sp.entity.workflowDefine.Action", "action") .WithMany("inputValuesSettings") .HasForeignKey("actionId") .OnDelete(DeleteBehavior.NoAction) .IsRequired(); b.Navigation("action"); b.Navigation("ParentSetting"); }); modelBuilder.Entity("wispro.sp.entity.workflowDefine.Step", b => { b.HasOne("wispro.sp.entity.workflowDefine.Workflow", "workflow") .WithMany() .HasForeignKey("workflowId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("workflow"); }); modelBuilder.Entity("wispro.sp.entity.workflowDefine.TrasferCondition", b => { b.HasOne("wispro.sp.entity.workflowDefine.Step", "Step") .WithMany() .HasForeignKey("StepId") .OnDelete(DeleteBehavior.NoAction) .IsRequired(); b.HasOne("wispro.sp.entity.workflowDefine.Step", "nextStep") .WithMany() .HasForeignKey("nextStepId") .OnDelete(DeleteBehavior.NoAction) .IsRequired(); b.Navigation("nextStep"); b.Navigation("Step"); }); modelBuilder.Entity("wispro.sp.entity.workflowDefine.Workflow", b => { b.HasOne("wispro.sp.entity.workflowDefine.Action", "InitAction") .WithMany() .HasForeignKey("InitActionId") .OnDelete(DeleteBehavior.NoAction) .IsRequired(); b.Navigation("InitAction"); }); modelBuilder.Entity("wispro.sp.entity.workflowInstance.InputValue", b => { b.HasOne("wispro.sp.entity.workflowDefine.InputValueSetting", "valueSetting") .WithMany() .HasForeignKey("valueSettingId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("wispro.sp.entity.workflowInstance.WorkflowInstance", "workflowInstance") .WithMany() .HasForeignKey("workflowInstanceId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("valueSetting"); b.Navigation("workflowInstance"); }); modelBuilder.Entity("wispro.sp.entity.workflowInstance.StepInstance", b => { b.HasOne("wispro.sp.entity.workflowDefine.Step", "Step") .WithMany() .HasForeignKey("stepId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.HasOne("wispro.sp.entity.workflowInstance.WorkflowInstance", "workflowInstance") .WithMany() .HasForeignKey("workflowInstanceId") .OnDelete(DeleteBehavior.NoAction) .IsRequired(); b.Navigation("Step"); b.Navigation("workflowInstance"); }); modelBuilder.Entity("wispro.sp.entity.workflowInstance.WorkflowInstance", b => { b.HasOne("wispro.sp.entity.workflowDefine.Workflow", "workflow") .WithMany() .HasForeignKey("workflowId") .OnDelete(DeleteBehavior.Cascade) .IsRequired(); b.Navigation("workflow"); }); modelBuilder.Entity("wispro.sp.entity.AppealRecord", b => { b.Navigation("AttachFiles"); }); modelBuilder.Entity("wispro.sp.entity.CalMonth", b => { b.Navigation("PerformanceItems"); }); modelBuilder.Entity("wispro.sp.entity.Customer", b => { b.Navigation("PerformanceItems"); }); modelBuilder.Entity("wispro.sp.entity.InputField", b => { b.Navigation("SelectValues"); }); modelBuilder.Entity("wispro.sp.entity.Message", b => { b.Navigation("RelatedItem"); b.Navigation("To"); }); modelBuilder.Entity("wispro.sp.entity.PerformanceItem", b => { b.Navigation("ItemStaffs"); }); modelBuilder.Entity("wispro.sp.entity.Staff", b => { b.Navigation("Customers"); b.Navigation("ItemStaffs"); b.Navigation("Positions"); b.Navigation("ReviewerItems"); }); modelBuilder.Entity("wispro.sp.entity.StaffGrade", b => { b.Navigation("Staff"); b.Navigation("VerifyCoefficientCheckers"); b.Navigation("VerifyCoefficientDoPeople"); }); modelBuilder.Entity("wispro.sp.entity.workflowDefine.Action", b => { b.Navigation("inputValuesSettings"); }); #pragma warning restore 612, 618 } } }