StaffPerformance/wispro.sp.api/Migrations/20211104013549_add-appealDB.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("20211104013549_add-appealDB")]
    partial class addappealDB
    {
        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<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("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.HasKey("Id");

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

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

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

                    b.Property<int?>("AppealRecordId1")
                        .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("AppealRecordId1");

                    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.2",
                            Priority = 1,
                            Rule = "p.ApplicationType==\"外观设计\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 2,
                            PointExpress = "0.2",
                            Priority = 2,
                            Rule = "p.AgentFeedbackMemo==\"检索结案\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 3,
                            PointExpress = "0.0",
                            Priority = 3,
                            Rule = "p.AgentFeedbackMemo==\"撰写中客户取消申请\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 4,
                            PointExpress = "0.49",
                            Priority = 4,
                            Rule = "p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"发文后客户取消申请\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 5,
                            PointExpress = "0.7",
                            Priority = 5,
                            Rule = "p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"发文后客户取消申请\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 6,
                            PointExpress = "1.33",
                            Priority = 6,
                            Rule = "p.CaseNo.StartsWith(\"PADE\")  && p.AgentFeedbackMemo==\"发文后客户原因取消申请，系统结案\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 7,
                            PointExpress = "1.26",
                            Priority = 7,
                            Rule = "p.CaseNo.StartsWith(\"PAUS\")  && p.AgentFeedbackMemo==\"发文后客户原因取消申请，系统结案\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 8,
                            PointExpress = "0.0",
                            Priority = 8,
                            Rule = "p.AgentFeedbackMemo==\"我方代交\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 9,
                            PointExpress = "0.2",
                            Priority = 9,
                            Rule = "p.AgentFeedbackMemo==\"我方转格式、复核\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 10,
                            PointExpress = "1.8",
                            Priority = 10,
                            Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"PCT首次英文案\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 11,
                            PointExpress = "0.3",
                            Priority = 11,
                            Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"改权\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 12,
                            PointExpress = "0.5",
                            Priority = 12,
                            Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"改权+改说明书\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 13,
                            PointExpress = "0.7",
                            Priority = 13,
                            Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"涉外实质改权\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 14,
                            PointExpress = "1.0",
                            Priority = 14,
                            Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"首次中文案\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 15,
                            PointExpress = "1.5",
                            Priority = 15,
                            Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"外-内首次申请\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 16,
                            PointExpress = "0.1",
                            Priority = 16,
                            Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"转格式\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 17,
                            PointExpress = "0.1",
                            Priority = 17,
                            Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\"  && p.CaseNo.StartsWith(\"PATW\") && p.AgentFeedbackMemo==\"同套大陆+台湾\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 18,
                            PointExpress = "0.7",
                            Priority = 18,
                            Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"同套大陆+台湾\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 19,
                            PointExpress = "0.1",
                            Priority = 19,
                            Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PATW\") && p.AgentFeedbackMemo==\"同套大陆+台湾\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 20,
                            PointExpress = "0.2",
                            Priority = 20,
                            Rule = "p.DoItem==\"新申请\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"台湾案转大陆案\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 21,
                            PointExpress = "1.0",
                            Priority = 21,
                            Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\"  && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"同套大陆+台湾\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 22,
                            PointExpress = "0.2",
                            Priority = 22,
                            Rule = "p.DoItem==\"新申请\" && p.CaseNo.StartsWith(\"PATW\") && p.AgentFeedbackMemo==\"大陆案转台湾案\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 23,
                            PointExpress = "1.8",
                            Priority = 23,
                            Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PAEPO\")",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 24,
                            PointExpress = "0.3",
                            Priority = 24,
                            Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PACN\") && p.CaseNo.EndsWith(\"-分案\")",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 25,
                            PointExpress = "0.5",
                            Priority = 25,
                            Rule = "p.CaseNo.StartsWith(\"PAUS\") && (p.CaseNo.EndsWith(\"-同套\") || p.CaseNo.EndsWith(\"CA\") || p.CaseNo.EndsWith(\"CIP\") || p.CaseNo.EndsWith(\"分案\")) ",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 26,
                            PointExpress = "1.0",
                            Priority = 26,
                            Rule = "p.DoItem==\"新申请\"  && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PACN\") && p.CaseNo.EndsWith(\"-TS\")",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 27,
                            PointExpress = "0.1",
                            Priority = 27,
                            Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" &&  p.CaseNo.StartsWith(\"PACN\") && p.CaseNo.EndsWith(\"-TS\")",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 28,
                            PointExpress = "1.0",
                            Priority = 28,
                            Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\")",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 29,
                            PointExpress = "1.0",
                            Priority = 30,
                            Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" &&  p.CaseNo.StartsWith(\"PACN\") && p.Customer.Name.Contains(\"OPPO\")",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 30,
                            PointExpress = "0.7",
                            Priority = 29,
                            Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" &&  p.CaseNo.StartsWith(\"PACN\")",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 31,
                            PointExpress = "1.9",
                            Priority = 31,
                            Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PADE\")",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 32,
                            PointExpress = "1.9",
                            Priority = 32,
                            Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" &&  p.CaseNo.StartsWith(\"PADE\")",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 33,
                            PointExpress = "0.2",
                            Priority = 33,
                            Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PAEPO\")",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 34,
                            PointExpress = "1.8",
                            Priority = 34,
                            Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PAGB\")",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 35,
                            PointExpress = "1.7",
                            Priority = 36,
                            Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PAUS\") && p.Customer.Name.Contains(\"OPPO\")",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 36,
                            PointExpress = "1.8",
                            Priority = 35,
                            Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PAUS\")",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 37,
                            PointExpress = "1.5",
                            Priority = 37,
                            Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PCTCN\")",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 38,
                            PointExpress = "0.0",
                            Priority = 38,
                            Rule = "(p.ApplicationType==\"实用新型\" || p.ApplicationType==\"发明\") && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"客户不进行答辩\"",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 39,
                            PointExpress = "p.WordCount/1000*0.1",
                            Priority = 39,
                            Rule = "p.DoItem==\"新申请\") && p.AgentFeedbackMemo==\"英-中\" && p.WordCount !=null",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 40,
                            PointExpress = "p.WordCount/1000*0.16",
                            Priority = 40,
                            Rule = "p.DoItem==\"新申请\") && p.AgentFeedbackMemo==\"中-英\" && p.WordCount !=null",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 41,
                            PointExpress = "p.WordCount/1000*0.18",
                            Priority = 41,
                            Rule = "p.DoItem==\"新申请\") && p.AgentFeedbackMemo==\"中-德\" && p.WordCount !=null",
                            Type = "新申请"
                        },
                        new
                        {
                            Id = 42,
                            PointExpress = "0.1",
                            Priority = 42,
                            Rule = "p.AgentFeedbackMemo==\"涉外OA不答辩，发报导函结案\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 43,
                            PointExpress = "0.2",
                            Priority = 43,
                            Rule = "p.ApplicationType==\"外观设计\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 44,
                            PointExpress = "0.0",
                            Priority = 44,
                            Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"实用新型\"  && p.AgentFeedbackMemo==\"不请款\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 45,
                            PointExpress = "0.0",
                            Priority = 45,
                            Rule = "p.ApplicationType==\"实用新型\"  && p.DoItemCoefficient==\"实质\" && (p.CaseStage==\"三通\" || p.CaseStage==\"四通\" || p.CaseStage==\"五通\" || p.CaseStage==\"六通\" || p.CaseStage==\"七通\" || p.CaseStage==\"八通\") ",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 46,
                            PointExpress = "0.14",
                            Priority = 46,
                            Rule = "p.ApplicationType==\"实用新型\"  && p.DoItemCoefficient==\"实质\" && p.CaseStage==\"二通\" && p.AgentFeedbackMemo==\"请款\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 47,
                            PointExpress = "0.35",
                            Priority = 47,
                            Rule = "p.ApplicationType==\"实用新型\"  && p.DoItemCoefficient==\"实质\" && p.CaseStage==\"一通\" && p.AgentFeedbackMemo==\"请款\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 48,
                            PointExpress = "0.35",
                            Priority = 48,
                            Rule = "p.DoItem==\"请求复审\" && p.ApplicationType==\"实用新型\"  && p.AgentFeedbackMemo==\"请款\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 49,
                            PointExpress = "0.3",
                            Priority = 49,
                            Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"非实质\"  && p.AgentFeedbackMemo==\"外所/他人首次转入OA\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 50,
                            PointExpress = "0.5",
                            Priority = 50,
                            Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"外所/他人首次转入OA\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 51,
                            PointExpress = "0.2",
                            Priority = 51,
                            Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"形式\" && p.AgentFeedbackMemo==\"外所/他人首次转入OA\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 52,
                            PointExpress = "0.5",
                            Priority = 52,
                            Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"客户提供答辩点，撰写英文报导函\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 53,
                            PointExpress = "0.8",
                            Priority = 53,
                            Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"客户未提供答辩点，撰写英文报导函\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 54,
                            PointExpress = "1.5",
                            Priority = 54,
                            Rule = "p.DoItem==\"Advisory Action\" && p.DoItemCoefficient==\"实质\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 55,
                            PointExpress = "0.2",
                            Priority = 55,
                            Rule = "p.DoItem==\"Advisory Action\" && p.DoItemCoefficient==\"形式\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 56,
                            PointExpress = "1.5",
                            Priority = 56,
                            Rule = "p.DoItem==\"Final Action\" && p.DoItemCoefficient==\"实质\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 57,
                            PointExpress = "0.2",
                            Priority = 57,
                            Rule = "p.DoItem==\"Final Action\" && p.DoItemCoefficient==\"形式\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 58,
                            PointExpress = "0.1",
                            Priority = 58,
                            Rule = "p.DoItem==\"form 3\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 59,
                            PointExpress = "0.1",
                            Priority = 59,
                            Rule = "p.DoItem==\"form 3-8（2）\" ||  p.DoItem==\"Form 3-8(2)\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 60,
                            PointExpress = "1.5",
                            Priority = 60,
                            Rule = "p.DoItem==\"Non Final Action\" && p.DoItemCoefficient==\"实质\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 61,
                            PointExpress = "0.2",
                            Priority = 61,
                            Rule = "p.DoItem==\"Non Final Action\" && p.DoItemCoefficient==\"形式\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 62,
                            PointExpress = "1.5",
                            Priority = 62,
                            Rule = "p.DoItem==\"RCE\" && p.DoItemCoefficient==\"实质\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 63,
                            PointExpress = "0.2",
                            Priority = 63,
                            Rule = "p.DoItem==\"RCE\" && p.DoItemCoefficient==\"形式\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 64,
                            PointExpress = "1.5",
                            Priority = 64,
                            Rule = "p.DoItem==\"欧洲案答辩\" && p.DoItemCoefficient==\"实质\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 65,
                            PointExpress = "0.2",
                            Priority = 65,
                            Rule = "p.DoItem==\"欧洲案答辩\" && p.DoItemCoefficient==\"形式\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 66,
                            PointExpress = "0.2",
                            Priority = 66,
                            Rule = "p.DoItem==\"口审评估\" && p.DoItemCoefficient==\"非实质\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 67,
                            PointExpress = "1.5",
                            Priority = 67,
                            Rule = "p.DoItem==\"口审评估\" && p.DoItemCoefficient==\"实质\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 68,
                            PointExpress = "1.5",
                            Priority = 68,
                            Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAUS\")",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 69,
                            PointExpress = "0.2",
                            Priority = 69,
                            Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAUS\")",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 70,
                            PointExpress = "1.5",
                            Priority = 70,
                            Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAAU\")",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 71,
                            PointExpress = "1.6",
                            Priority = 71,
                            Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PADE\")",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 72,
                            PointExpress = "1.5",
                            Priority = 72,
                            Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAEPO\")",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 73,
                            PointExpress = "1.5",
                            Priority = 73,
                            Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAGB\")",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 74,
                            PointExpress = "1.5",
                            Priority = 74,
                            Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAIN\")",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 75,
                            PointExpress = "0.2",
                            Priority = 75,
                            Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAAU\")",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 76,
                            PointExpress = "0.3",
                            Priority = 76,
                            Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PADE\")",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 77,
                            PointExpress = "0.2",
                            Priority = 77,
                            Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAEPO\")",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 78,
                            PointExpress = "0.2",
                            Priority = 78,
                            Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAGB\")",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 79,
                            PointExpress = "0.2",
                            Priority = 79,
                            Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAIN\")",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 80,
                            PointExpress = "0.5",
                            Priority = 80,
                            Rule = "p.DoItem==\"申復\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PATW\")",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 81,
                            PointExpress = "0.2",
                            Priority = 81,
                            Rule = "p.DoItem==\"申復\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PATW\")",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 82,
                            PointExpress = "0.5",
                            Priority = 82,
                            Rule = "p.DoItem==\"请求复审\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\")",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 83,
                            PointExpress = "0.2",
                            Priority = 83,
                            Rule = "p.DoItem==\"意见陈述\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"复审\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 84,
                            PointExpress = "0.3",
                            Priority = 84,
                            Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.DoItemCoefficient==\"非实质\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"一通\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 85,
                            PointExpress = "0.5",
                            Priority = 85,
                            Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PACN\")  && p.CaseStage==\"一通\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 86,
                            PointExpress = "0.2",
                            Priority = 86,
                            Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"一通\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 87,
                            PointExpress = "0.3",
                            Priority = 87,
                            Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.DoItemCoefficient==\"非实质\" && p.CaseNo.StartsWith(\"PCTCN\") && p.CaseStage==\"一通\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 88,
                            PointExpress = "0.5",
                            Priority = 88,
                            Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PCTCN\")  && p.CaseStage==\"一通\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 89,
                            PointExpress = "0.2",
                            Priority = 89,
                            Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PCTCN\") && p.CaseStage==\"一通\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 90,
                            PointExpress = "0.2",
                            Priority = 90,
                            Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"二通\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 91,
                            PointExpress = "0.2",
                            Priority = 91,
                            Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" &&  p.CaseNo.StartsWith(\"PCTCN\") && p.CaseStage==\"二通\"",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 92,
                            PointExpress = "0.0",
                            Priority = 92,
                            Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") &&  (p.CaseStage==\"三通\" || p.CaseStage==\"四通\" || p.CaseStage==\"五通\")",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 93,
                            PointExpress = "0.0",
                            Priority = 93,
                            Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PCTCN\") &&  (p.CaseStage==\"三通\" || p.CaseStage==\"四通\" || p.CaseStage==\"五通\")",
                            Type = "OA"
                        },
                        new
                        {
                            Id = 94,
                            PointExpress = "0.2",
                            Priority = 94,
                            Rule = "p.DoItem==\"发明一次OA授权\" && p.ApplicationType==\"发明\"",
                            Type = "一次OA授权"
                        },
                        new
                        {
                            Id = 95,
                            PointExpress = "0.7",
                            Priority = 95,
                            Rule = "p.DoItem==\"翻译校核\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"内-外\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 96,
                            PointExpress = "0.5",
                            Priority = 96,
                            Rule = "p.DoItem==\"翻译校核\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"外-内\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 97,
                            PointExpress = "0.3",
                            Priority = 97,
                            Rule = "p.DoItem==\"翻译校核\" && p.DoItemCoefficient==\"形式\" && p.AgentFeedbackMemo==\"内-外\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 98,
                            PointExpress = "0.2",
                            Priority = 98,
                            Rule = "p.DoItem==\"翻译校核\" && p.DoItemCoefficient==\"形式\" && p.AgentFeedbackMemo==\"外-内\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 99,
                            PointExpress = "0.1",
                            Priority = 99,
                            Rule = "p.AgentFeedbackMemo==\"检索结案\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 100,
                            PointExpress = "0.0",
                            Priority = 100,
                            Rule = "p.DoItem==\"内部检索\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 101,
                            PointExpress = "0.2",
                            Priority = 101,
                            Rule = "p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PAAU\")",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 102,
                            PointExpress = "0.0",
                            Priority = 102,
                            Rule = "p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PACN\")",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 103,
                            PointExpress = "0.0",
                            Priority = 103,
                            Rule = "p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PCTCN\")",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 104,
                            PointExpress = "0.0",
                            Priority = 104,
                            Rule = "p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"WOCN\")",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 105,
                            PointExpress = "0.2",
                            Priority = 105,
                            Rule = "p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PADE\")",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 106,
                            PointExpress = "0.2",
                            Priority = 106,
                            Rule = "p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PAEPO\")",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 107,
                            PointExpress = "0.2",
                            Priority = 107,
                            Rule = "p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PAGB\")",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 108,
                            PointExpress = "0.2",
                            Priority = 108,
                            Rule = "p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PAIN\")",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 109,
                            PointExpress = "0.2",
                            Priority = 109,
                            Rule = "p.DoItem.Contains(\"补正\")  && p.CaseNo.StartsWith(\"PAUS\")",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 110,
                            PointExpress = "0.2",
                            Priority = 110,
                            Rule = "p.DoItem==\"Election Action\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 111,
                            PointExpress = "0.2",
                            Priority = 111,
                            Rule = "p.DoItem==\"OA答辩校核\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 112,
                            PointExpress = "0.1",
                            Priority = 112,
                            Rule = "p.DoItem==\"PPH\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 113,
                            PointExpress = "0.0",
                            Priority = 113,
                            Rule = "p.DoItem==\"电询\"  && p.CaseNo.StartsWith(\"PACN\")",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 114,
                            PointExpress = "0.2",
                            Priority = 114,
                            Rule = "p.DoItem==\"电询\"  && p.CaseNo.StartsWith(\"PAEPO\") ",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 115,
                            PointExpress = "0.2",
                            Priority = 115,
                            Rule = "p.DoItem==\"电询\"  && p.CaseNo.StartsWith(\"PAUS\")",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 116,
                            PointExpress = "0.1",
                            Priority = 116,
                            Rule = "p.DoItem==\"分案评估\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 117,
                            PointExpress = "0.2",
                            Priority = 117,
                            Rule = "p.DoItem==\"分案评估+分案\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 118,
                            PointExpress = "0.0",
                            Priority = 118,
                            Rule = "p.DoItem==\"绘图\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 119,
                            PointExpress = "0.0",
                            Priority = 119,
                            Rule = "p.DoItem==\"技术确认\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 120,
                            PointExpress = "0.1",
                            Priority = 120,
                            Rule = "p.DoItem==\"提交ids\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 121,
                            PointExpress = "0.0",
                            Priority = 121,
                            Rule = "p.DoItem==\"询问放弃或复审\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 122,
                            PointExpress = "0.0",
                            Priority = 122,
                            Rule = "p.DoItem==\"知识点总结\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 123,
                            PointExpress = "0.0",
                            Priority = 123,
                            Rule = "p.DoItem==\"专利挖掘与布局\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 124,
                            PointExpress = "0.2",
                            Priority = 124,
                            Rule = "p.ApplicationType==\"外观设计\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 125,
                            PointExpress = "0.0",
                            Priority = 125,
                            Rule = "p.DoItem==\"提交ids\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 126,
                            PointExpress = "0.0",
                            Priority = 126,
                            Rule = "p.DoItem==\"请求优先审查\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 127,
                            PointExpress = "p.WordCount/1000*0.1",
                            Priority = 127,
                            Rule = "p.DoItem==\"翻译\") && p.AgentFeedbackMemo==\"英-中\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 128,
                            PointExpress = "p.WordCount/1000*0.16",
                            Priority = 128,
                            Rule = "p.DoItem==\"翻译\") && p.AgentFeedbackMemo==\"中-英\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 129,
                            PointExpress = "p.WordCount/1000*0.18",
                            Priority = 129,
                            Rule = "p.DoItem==\"翻译\") && p.AgentFeedbackMemo==\"中-德\"",
                            Type = "其它"
                        },
                        new
                        {
                            Id = 130,
                            PointExpress = "0.0",
                            Priority = 130,
                            Rule = "p.AgentFeedbackMemo==\"已核算绩效\"",
                            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.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.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<string>("FieldName")
                        .HasMaxLength(50)
                        .HasColumnType("nvarchar(50)");

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

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

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

                    b.HasKey("Id");

                    b.HasIndex("AppealTypeId");

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

            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>("Value")
                        .HasMaxLength(500)
                        .HasColumnType("nvarchar(500)");

                    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.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.AppealRecord", b =>
                {
                    b.HasOne("wispro.sp.entity.Staff", "Creater")
                        .WithMany()
                        .HasForeignKey("CreaterId")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.HasOne("wispro.sp.entity.Staff", "Reviewer")
                        .WithMany()
                        .HasForeignKey("ReviewerId")
                        .OnDelete(DeleteBehavior.NoAction)
                        .IsRequired();

                    b.HasOne("wispro.sp.entity.AppealType", "Type")
                        .WithMany()
                        .HasForeignKey("TypeId")
                        .OnDelete(DeleteBehavior.NoAction)
                        .IsRequired();

                    b.Navigation("Creater");

                    b.Navigation("Reviewer");

                    b.Navigation("Type");
                });

            modelBuilder.Entity("wispro.sp.entity.AttachFile", b =>
                {
                    b.HasOne("wispro.sp.entity.AppealRecord", "AppealRecord")
                        .WithMany()
                        .HasForeignKey("AppealRecordId")
                        .HasConstraintName("FK_AttachFile_AppealRecord")
                        .OnDelete(DeleteBehavior.Cascade)
                        .IsRequired();

                    b.HasOne("wispro.sp.entity.AppealRecord", null)
                        .WithMany("AttachFiles")
                        .HasForeignKey("AppealRecordId1");

                    b.HasOne("wispro.sp.entity.Staff", "UploadUser")
                        .WithMany()
                        .HasForeignKey("UploadUserId")
                        .HasConstraintName("FK_AttachFile_UpdateUser")
                        .OnDelete(DeleteBehavior.NoAction)
                        .IsRequired();

                    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.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.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.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.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("ReviewerItems");
                });

            modelBuilder.Entity("wispro.sp.entity.StaffGrade", b =>
                {
                    b.Navigation("Staff");

                    b.Navigation("VerifyCoefficientCheckers");

                    b.Navigation("VerifyCoefficientDoPeople");
                });
#pragma warning restore 612, 618
        }
    }
}