StaffPerformance/wispro.sp.api/Migrations/20211130020237_sp-database.Designer.cs

// <auto-generated />
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<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<DateTime>("CreateTime")
                        .HasColumnType("datetime2");

                    b.Property<int>("CreaterId")
                        .HasColumnType("int");

                    b.Property<int>("ItemId")
                        .HasColumnType("int");

                    b.Property<string>("Reason")
                        .HasMaxLength(500)
                        .HasColumnType("nvarchar(500)");

                    b.Property<DateTime?>("ReviewTime")
                        .HasColumnType("datetime2");

                    b.Property<int?>("ReviewerId")
                        .HasColumnType("int");

                    b.Property<string>("ReviewerMemo")
                        .HasColumnType("nvarchar(max)");

                    b.Property<int>("State")
                        .HasColumnType("int");

                    b.Property<int>("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<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("CanDoExpress")
                        .HasMaxLength(500)
                        .HasColumnType("nvarchar(500)");

                    b.Property<string>("Name")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("ReviewerExpress")
                        .HasMaxLength(500)
                        .HasColumnType("nvarchar(500)");

                    b.Property<int>("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<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uniqueidentifier");

                    b.Property<int?>("AppealRecordId")
                        .HasColumnType("int");

                    b.Property<string>("Name")
                        .HasMaxLength(200)
                        .HasColumnType("nvarchar(200)");

                    b.Property<string>("SavePath")
                        .HasMaxLength(200)
                        .HasColumnType("nvarchar(200)");

                    b.Property<int?>("UploadUserId")
                        .HasColumnType("int");

                    b.HasKey("Id");

                    b.HasIndex("AppealRecordId");

                    b.HasIndex("UploadUserId");

                    b.ToTable("AttachFile");
                });

            modelBuilder.Entity("wispro.sp.entity.BasePointRule", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("PointExpress")
                        .HasMaxLength(100)
                        .HasColumnType("nvarchar(100)");

                    b.Property<int>("Priority")
                        .HasColumnType("int");

                    b.Property<string>("Rule")
                        .HasMaxLength(1000)
                        .HasColumnType("nvarchar(1000)");

                    b.Property<string>("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<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<int>("Month")
                        .HasColumnType("int")
                        .HasColumnName("month");

                    b.Property<int>("Status")
                        .HasColumnType("int")
                        .HasColumnName("status");

                    b.Property<int>("Year")
                        .HasColumnType("int")
                        .HasColumnName("year");

                    b.HasKey("Id");

                    b.ToTable("CalMonth");
                });

            modelBuilder.Entity("wispro.sp.entity.CaseCeoffcient", b =>
                {
                    b.Property<string>("Ceoffcient")
                        .HasColumnType("nvarchar(450)");

                    b.Property<double>("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<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("Address")
                        .HasMaxLength(500)
                        .HasColumnType("nvarchar(500)");

                    b.Property<string>("ContactMan")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("Name")
                        .IsRequired()
                        .HasMaxLength(200)
                        .HasColumnType("nvarchar(200)");

                    b.Property<string>("Phone")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<int?>("ResponseManId")
                        .HasColumnType("int");

                    b.HasKey("Id");

                    b.HasIndex("ResponseManId");

                    b.ToTable("Customer");
                });

            modelBuilder.Entity("wispro.sp.entity.Department", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("Memo")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("Name")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("ancestors")
                        .HasColumnType("nvarchar(max)");

                    b.Property<int?>("order_num")
                        .HasColumnType("int");

                    b.Property<int?>("parentId")
                        .HasColumnType("int");

                    b.HasKey("Id");

                    b.ToTable("Department");
                });

            modelBuilder.Entity("wispro.sp.entity.DepartmentPosition", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<int>("PositionId")
                        .HasColumnType("int");

                    b.Property<int>("StaffId")
                        .HasColumnType("int");

                    b.Property<int>("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<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<int>("AppealState")
                        .HasColumnType("int");

                    b.Property<int>("AppealTypeId")
                        .HasColumnType("int");

                    b.Property<bool>("CanMuliSelect")
                        .HasColumnType("bit");

                    b.Property<string>("FieldName")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("FieldType")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("MapObjectField")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("MapObjectFieldLabel")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("MapSaveCondition")
                        .HasColumnType("nvarchar(max)");

                    b.Property<int?>("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<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<int>("AppealRecordId")
                        .HasColumnType("int");

                    b.Property<int>("InputFieldId")
                        .HasColumnType("int");

                    b.Property<string>("Label")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("Value")
                        .HasMaxLength(500)
                        .HasColumnType("nvarchar(500)");

                    b.Property<string>("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<int>("ItemId")
                        .HasColumnType("int");

                    b.Property<int>("DoPersonId")
                        .HasColumnType("int");

                    b.Property<double?>("PerformancePoint")
                        .HasColumnType("float");

                    b.HasKey("ItemId", "DoPersonId");

                    b.HasIndex("DoPersonId");

                    b.ToTable("ItemStaff");
                });

            modelBuilder.Entity("wispro.sp.entity.Message", b =>
                {
                    b.Property<Guid>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("uniqueidentifier");

                    b.Property<int>("FromId")
                        .HasColumnType("int");

                    b.Property<string>("MessageInfo")
                        .HasMaxLength(500)
                        .HasColumnType("nvarchar(500)");

                    b.Property<int>("Type")
                        .HasColumnType("int");

                    b.HasKey("Id");

                    b.HasIndex("FromId");

                    b.ToTable("Message");
                });

            modelBuilder.Entity("wispro.sp.entity.MessagePerformanceItem", b =>
                {
                    b.Property<int>("ItemId")
                        .HasColumnType("int");

                    b.Property<Guid>("MessageId")
                        .HasColumnType("uniqueidentifier");

                    b.HasKey("ItemId", "MessageId");

                    b.HasIndex("MessageId");

                    b.ToTable("MessagePerformanceItems");
                });

            modelBuilder.Entity("wispro.sp.entity.MessageReadRecord", b =>
                {
                    b.Property<Guid>("MessageId")
                        .HasColumnType("uniqueidentifier");

                    b.Property<int>("StaffId")
                        .HasColumnType("int");

                    b.Property<Guid?>("MessageId1")
                        .HasColumnType("uniqueidentifier");

                    b.Property<bool>("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<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("AgentFeedbackMemo")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("ApplicationName")
                        .HasMaxLength(200)
                        .HasColumnType("nvarchar(200)");

                    b.Property<string>("ApplicationType")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<decimal?>("BasePoint")
                        .HasColumnType("numeric(18,2)");

                    b.Property<string>("BusinessType")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<int>("CalMonthId")
                        .HasColumnType("int");

                    b.Property<string>("CaseCoefficient")
                        .HasMaxLength(10)
                        .HasColumnType("nvarchar(10)");

                    b.Property<string>("CaseMemo")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("CaseName")
                        .HasMaxLength(500)
                        .HasColumnType("nvarchar(500)");

                    b.Property<string>("CaseNo")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("CaseStage")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("CaseState")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("CaseType")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<int?>("CustomerId")
                        .HasColumnType("int");

                    b.Property<DateTime?>("CustomerLimitDate")
                        .HasColumnType("date");

                    b.Property<string>("DoItem")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("DoItemCoefficient")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("DoItemMemo")
                        .HasMaxLength(500)
                        .HasColumnType("nvarchar(500)");

                    b.Property<string>("DoItemState")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<DateTime?>("EntrustingDate")
                        .HasColumnType("date");

                    b.Property<DateTime?>("FinalizationDate")
                        .HasColumnType("date");

                    b.Property<DateTime?>("FinishedDate")
                        .HasColumnType("date");

                    b.Property<DateTime?>("FirstDraftDate")
                        .HasColumnType("date");

                    b.Property<DateTime?>("InternalDate")
                        .HasColumnType("date");

                    b.Property<string>("OverDueMemo")
                        .HasMaxLength(100)
                        .HasColumnType("nvarchar(100)");

                    b.Property<int?>("PreOastaffId")
                        .HasColumnType("int")
                        .HasColumnName("PreOAStaffId");

                    b.Property<string>("ReturnCasseNo")
                        .HasColumnType("nvarchar(max)");

                    b.Property<DateTime?>("ReturnDate")
                        .HasColumnType("date");

                    b.Property<int?>("ReviewerId")
                        .HasColumnType("int");

                    b.Property<int?>("Status")
                        .HasColumnType("int");

                    b.Property<string>("Type")
                        .HasColumnType("nvarchar(max)");

                    b.Property<int?>("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<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("Memo")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("Name")
                        .HasColumnType("nvarchar(max)");

                    b.HasKey("Id");

                    b.ToTable("Position");
                });

            modelBuilder.Entity("wispro.sp.entity.SelectValue", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<int>("InputFieldId")
                        .HasColumnType("int");

                    b.Property<string>("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<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("Account")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("Department")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<DateTime?>("EntyDate")
                        .HasColumnType("date");

                    b.Property<bool>("IsCalPerformsnce")
                        .HasColumnType("bit")
                        .HasColumnName("isCalPerformsnce");

                    b.Property<bool>("IsOnJob")
                        .HasColumnType("bit");

                    b.Property<string>("Mail")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("Memo")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("Mobile")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("Name")
                        .IsRequired()
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.Property<string>("Password")
                        .IsRequired()
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("Sex")
                        .HasColumnType("nvarchar(max)");

                    b.Property<int?>("StaffGradeId")
                        .HasColumnType("int");

                    b.Property<string>("Status")
                        .IsRequired()
                        .HasMaxLength(25)
                        .HasColumnType("nvarchar(25)");

                    b.Property<string>("Tel")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("WorkPlace")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

                    b.HasKey("Id");

                    b.HasIndex("StaffGradeId");

                    b.ToTable("Staff");
                });

            modelBuilder.Entity("wispro.sp.entity.StaffGrade", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<double>("Coefficient")
                        .HasColumnType("float");

                    b.Property<string>("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<int>("CheckerId")
                        .HasColumnType("int");

                    b.Property<int>("DoPersonId")
                        .HasColumnType("int");

                    b.Property<double>("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<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("InputForm")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("Name")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("OnActionObjectType")
                        .HasColumnType("nvarchar(max)");

                    b.Property<int>("StepId")
                        .HasColumnType("int");

                    b.HasKey("Id");

                    b.HasIndex("StepId");

                    b.ToTable("Action");
                });

            modelBuilder.Entity("wispro.sp.entity.workflowDefine.InputValueSetting", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("DisplayName")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("Options")
                        .HasColumnType("nvarchar(max)");

                    b.Property<int?>("ParentSettingId")
                        .HasColumnType("int");

                    b.Property<int>("actionId")
                        .HasColumnType("int");

                    b.Property<string>("bindField")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("bindFieldSavetoObjectCondition")
                        .HasColumnType("nvarchar(max)");

                    b.Property<int>("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<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("Name")
                        .HasColumnType("nvarchar(max)");

                    b.Property<string>("defaultResponseSetting")
                        .HasColumnType("nvarchar(max)");

                    b.Property<int>("stepType")
                        .HasColumnType("int");

                    b.Property<int>("workflowId")
                        .HasColumnType("int");

                    b.HasKey("Id");

                    b.HasIndex("workflowId");

                    b.ToTable("Step");
                });

            modelBuilder.Entity("wispro.sp.entity.workflowDefine.TrasferCondition", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("Condition")
                        .HasColumnType("nvarchar(max)");

                    b.Property<int>("StepId")
                        .HasColumnType("int");

                    b.Property<int>("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<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("ContentObjectType")
                        .HasColumnType("nvarchar(max)");

                    b.Property<int>("EndStepId")
                        .HasColumnType("int");

                    b.Property<int>("InitActionId")
                        .HasColumnType("int");

                    b.Property<string>("Name")
                        .HasColumnType("nvarchar(max)");

                    b.HasKey("Id");

                    b.HasIndex("InitActionId");

                    b.ToTable("Workflow");
                });

            modelBuilder.Entity("wispro.sp.entity.workflowInstance.InputValue", b =>
                {
                    b.Property<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<string>("value")
                        .HasColumnType("nvarchar(max)");

                    b.Property<int>("valueSettingId")
                        .HasColumnType("int");

                    b.Property<int>("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<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<int?>("PreviousStepId")
                        .HasColumnType("int");

                    b.Property<int>("stepId")
                        .HasColumnType("int");

                    b.Property<int>("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<int>("Id")
                        .ValueGeneratedOnAdd()
                        .HasColumnType("int")
                        .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);

                    b.Property<int>("ObjectId")
                        .HasColumnType("int");

                    b.Property<int>("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
        }
    }
}