//
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("20211115011112_addCaseCeoffcient")]
partial class addCaseCeoffcient
{
protected override void BuildTargetModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("Relational:MaxIdentifierLength", 128)
.HasAnnotation("ProductVersion", "5.0.9")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("wispro.sp.entity.AppealRecord", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("CreateTime")
.HasColumnType("datetime2");
b.Property("CreaterId")
.HasColumnType("int");
b.Property("ItemId")
.HasColumnType("int");
b.Property("Reason")
.HasMaxLength(500)
.HasColumnType("nvarchar(500)");
b.Property("ReviewTime")
.HasColumnType("datetime2");
b.Property("ReviewerId")
.HasColumnType("int");
b.Property("ReviewerMemo")
.HasColumnType("nvarchar(max)");
b.Property("State")
.HasColumnType("int");
b.Property("TypeId")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("CreaterId");
b.HasIndex("ItemId");
b.HasIndex("ReviewerId");
b.HasIndex("TypeId");
b.ToTable("AppealRecord");
});
modelBuilder.Entity("wispro.sp.entity.AppealType", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("CanDoExpress")
.HasMaxLength(500)
.HasColumnType("nvarchar(500)");
b.Property("Name")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("ReviewerExpress")
.HasMaxLength(500)
.HasColumnType("nvarchar(500)");
b.Property("Type")
.HasColumnType("int");
b.HasKey("Id");
b.ToTable("AppealType");
b.HasData(
new
{
Id = 1,
CanDoExpress = "p.ItemStaffs.Count()>1",
Name = "绩效点数分配比率",
Type = 0
},
new
{
Id = 2,
CanDoExpress = "p.DoItem==\"新申请\"",
Name = "案件系数复核",
ReviewerExpress = "p.Reviewer",
Type = 0
},
new
{
Id = 3,
CanDoExpress = "p.DoItem==\"新申请\"",
Name = "处理事项系数复核",
ReviewerExpress = "p.Reviewer",
Type = 0
},
new
{
Id = 4,
CanDoExpress = "",
Name = "案件缺漏申诉",
ReviewerExpress = "p.Reviewer",
Type = 1
},
new
{
Id = 5,
CanDoExpress = "p.isDanger()",
Name = "案件严重超期说明",
Type = 0
},
new
{
Id = 6,
CanDoExpress = "p.DoItem==\"新申请\" || p.DoItem==\"翻译\"",
Name = "按照翻译字数算绩效备注",
Type = 0
});
});
modelBuilder.Entity("wispro.sp.entity.AttachFile", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("uniqueidentifier");
b.Property("AppealRecordId")
.HasColumnType("int");
b.Property("Name")
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property("SavePath")
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property("UploadUserId")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("AppealRecordId");
b.HasIndex("UploadUserId");
b.ToTable("AttachFile");
});
modelBuilder.Entity("wispro.sp.entity.BasePointRule", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("PointExpress")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property("Priority")
.HasColumnType("int");
b.Property("Rule")
.HasMaxLength(1000)
.HasColumnType("nvarchar(1000)");
b.Property("Type")
.HasMaxLength(20)
.HasColumnType("nvarchar(20)");
b.HasKey("Id");
b.ToTable("BasePointRule");
});
modelBuilder.Entity("wispro.sp.entity.CalMonth", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("Month")
.HasColumnType("int")
.HasColumnName("month");
b.Property("Status")
.HasColumnType("int")
.HasColumnName("status");
b.Property("Year")
.HasColumnType("int")
.HasColumnName("year");
b.HasKey("Id");
b.ToTable("CalMonth");
});
modelBuilder.Entity("wispro.sp.entity.CaseCeoffcient", b =>
{
b.Property("Ceoffcient")
.HasColumnType("nvarchar(450)");
b.Property("Value")
.HasColumnType("float");
b.HasKey("Ceoffcient");
b.ToTable("CaseCeofficient");
b.HasData(
new
{
Ceoffcient = "S",
Value = 2.5
},
new
{
Ceoffcient = "A",
Value = 1.5
},
new
{
Ceoffcient = "B",
Value = 1.0
},
new
{
Ceoffcient = "C",
Value = 0.69999999999999996
},
new
{
Ceoffcient = "D",
Value = 0.40000000000000002
});
});
modelBuilder.Entity("wispro.sp.entity.Customer", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("Address")
.HasMaxLength(500)
.HasColumnType("nvarchar(500)");
b.Property("ContactMan")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("Name")
.IsRequired()
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property("Phone")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("ResponseManId")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("ResponseManId");
b.ToTable("Customer");
});
modelBuilder.Entity("wispro.sp.entity.InputField", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("AppealState")
.HasColumnType("int");
b.Property("AppealTypeId")
.HasColumnType("int");
b.Property("CanMuliSelect")
.HasColumnType("bit");
b.Property("FieldName")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("FieldType")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("MapObjectField")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("MapObjectFieldLabel")
.HasColumnType("nvarchar(max)");
b.Property("MaxSize")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("AppealTypeId");
b.ToTable("InputField");
b.HasData(
new
{
Id = 1,
AppealState = 0,
AppealTypeId = 1,
CanMuliSelect = false,
FieldName = "分配比率",
FieldType = "System.Double",
MapObjectField = "ItemStaffs.PerformancePoint",
MapObjectFieldLabel = "ItemStaffs.DoPerson.Name"
},
new
{
Id = 3,
AppealState = 0,
AppealTypeId = 1,
CanMuliSelect = false,
FieldName = "原因",
FieldType = "System.String"
},
new
{
Id = 4,
AppealState = 1,
AppealTypeId = 1,
CanMuliSelect = false,
FieldName = "备注",
FieldType = "System.String"
},
new
{
Id = 5,
AppealState = 1,
AppealTypeId = 1,
CanMuliSelect = false,
FieldName = "审核意见",
FieldType = "System.String"
},
new
{
Id = 6,
AppealState = 0,
AppealTypeId = 2,
CanMuliSelect = false,
FieldName = "案件系数",
FieldType = "System.String",
MapObjectField = "CaseCoefficient"
},
new
{
Id = 9,
AppealState = 1,
AppealTypeId = 2,
CanMuliSelect = false,
FieldName = "备注",
FieldType = "System.String"
},
new
{
Id = 10,
AppealState = 1,
AppealTypeId = 2,
CanMuliSelect = false,
FieldName = "审核意见",
FieldType = "System.String"
},
new
{
Id = 11,
AppealState = 0,
AppealTypeId = 3,
CanMuliSelect = false,
FieldName = "处理事项系数",
FieldType = "System.String",
MapObjectField = "DoItemCoefficient"
},
new
{
Id = 12,
AppealState = 1,
AppealTypeId = 3,
CanMuliSelect = false,
FieldName = "备注",
FieldType = "System.String"
},
new
{
Id = 13,
AppealState = 1,
AppealTypeId = 3,
CanMuliSelect = false,
FieldName = "审核意见",
FieldType = "System.String"
},
new
{
Id = 14,
AppealState = 0,
AppealTypeId = 4,
CanMuliSelect = false,
FieldName = "我方文号",
FieldType = "System.String"
},
new
{
Id = 15,
AppealState = 0,
AppealTypeId = 4,
CanMuliSelect = false,
FieldName = "处理事项",
FieldType = "System.String"
},
new
{
Id = 16,
AppealState = 1,
AppealTypeId = 4,
CanMuliSelect = false,
FieldName = "备注",
FieldType = "System.String"
},
new
{
Id = 17,
AppealState = 1,
AppealTypeId = 4,
CanMuliSelect = false,
FieldName = "审核意见",
FieldType = "System.String"
},
new
{
Id = 18,
AppealState = 0,
AppealTypeId = 5,
CanMuliSelect = false,
FieldName = "超期说明",
FieldType = "System.String",
MapObjectField = "OverDueMemo"
},
new
{
Id = 21,
AppealState = 1,
AppealTypeId = 5,
CanMuliSelect = false,
FieldName = "审核意见",
FieldType = "System.String"
},
new
{
Id = 22,
AppealState = 1,
AppealTypeId = 5,
CanMuliSelect = false,
FieldName = "备注",
FieldType = "System.String"
},
new
{
Id = 19,
AppealState = 0,
AppealTypeId = 6,
CanMuliSelect = false,
FieldName = "翻译类型",
FieldType = "System.String",
MapObjectField = "AgentFeedbackMemo"
},
new
{
Id = 20,
AppealState = 0,
AppealTypeId = 6,
CanMuliSelect = false,
FieldName = "翻译字数",
FieldType = "System.Int32",
MapObjectField = "WordCount"
},
new
{
Id = 23,
AppealState = 1,
AppealTypeId = 6,
CanMuliSelect = false,
FieldName = "审核意见",
FieldType = "System.Int32"
},
new
{
Id = 24,
AppealState = 1,
AppealTypeId = 6,
CanMuliSelect = false,
FieldName = "翻译字数",
FieldType = "System.Int32",
MapObjectField = "WordCount"
});
});
modelBuilder.Entity("wispro.sp.entity.InputFieldValue", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("AppealRecordId")
.HasColumnType("int");
b.Property("InputFieldId")
.HasColumnType("int");
b.Property("Label")
.HasColumnType("nvarchar(max)");
b.Property("Value")
.HasMaxLength(500)
.HasColumnType("nvarchar(500)");
b.Property("mapExpress")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.HasIndex("AppealRecordId");
b.HasIndex("InputFieldId");
b.ToTable("InputFieldValue");
});
modelBuilder.Entity("wispro.sp.entity.ItemStaff", b =>
{
b.Property("ItemId")
.HasColumnType("int");
b.Property("DoPersonId")
.HasColumnType("int");
b.Property("PerformancePoint")
.HasColumnType("float");
b.HasKey("ItemId", "DoPersonId");
b.HasIndex("DoPersonId");
b.ToTable("ItemStaff");
});
modelBuilder.Entity("wispro.sp.entity.Message", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("uniqueidentifier");
b.Property("FromId")
.HasColumnType("int");
b.Property("MessageInfo")
.HasMaxLength(500)
.HasColumnType("nvarchar(500)");
b.Property("Type")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("FromId");
b.ToTable("Message");
});
modelBuilder.Entity("wispro.sp.entity.MessagePerformanceItem", b =>
{
b.Property("ItemId")
.HasColumnType("int");
b.Property("MessageId")
.HasColumnType("uniqueidentifier");
b.HasKey("ItemId", "MessageId");
b.HasIndex("MessageId");
b.ToTable("MessagePerformanceItems");
});
modelBuilder.Entity("wispro.sp.entity.MessageReadRecord", b =>
{
b.Property("MessageId")
.HasColumnType("uniqueidentifier");
b.Property("StaffId")
.HasColumnType("int");
b.Property("MessageId1")
.HasColumnType("uniqueidentifier");
b.Property("isReaded")
.HasColumnType("bit");
b.HasKey("MessageId", "StaffId");
b.HasIndex("MessageId1");
b.HasIndex("StaffId");
b.ToTable("MessageReadRecord");
});
modelBuilder.Entity("wispro.sp.entity.PerformanceItem", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("AgentFeedbackMemo")
.HasColumnType("nvarchar(max)");
b.Property("ApplicationName")
.HasMaxLength(200)
.HasColumnType("nvarchar(200)");
b.Property("ApplicationType")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("BasePoint")
.HasColumnType("numeric(18,2)");
b.Property("BusinessType")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("CalMonthId")
.HasColumnType("int");
b.Property("CaseCoefficient")
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
b.Property("CaseMemo")
.HasColumnType("nvarchar(max)");
b.Property("CaseName")
.HasMaxLength(500)
.HasColumnType("nvarchar(500)");
b.Property("CaseNo")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("CaseStage")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("CaseState")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("CaseType")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("CustomerId")
.HasColumnType("int");
b.Property("CustomerLimitDate")
.HasColumnType("date");
b.Property("DoItem")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("DoItemCoefficient")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("DoItemMemo")
.HasMaxLength(500)
.HasColumnType("nvarchar(500)");
b.Property("DoItemState")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("EntrustingDate")
.HasColumnType("date");
b.Property("FinalizationDate")
.HasColumnType("date");
b.Property("FinishedDate")
.HasColumnType("date");
b.Property("FirstDraftDate")
.HasColumnType("date");
b.Property("InternalDate")
.HasColumnType("date");
b.Property("OverDueMemo")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property("PreOastaffId")
.HasColumnType("int")
.HasColumnName("PreOAStaffId");
b.Property("ReturnCasseNo")
.HasColumnType("nvarchar(max)");
b.Property("ReturnDate")
.HasColumnType("date");
b.Property("ReviewerId")
.HasColumnType("int");
b.Property("Status")
.HasColumnType("int");
b.Property("Type")
.HasColumnType("nvarchar(max)");
b.Property("WordCount")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("CalMonthId");
b.HasIndex("CustomerId");
b.HasIndex("PreOastaffId");
b.HasIndex("ReviewerId");
b.ToTable("PerformanceItem");
});
modelBuilder.Entity("wispro.sp.entity.SelectValue", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("InputFieldId")
.HasColumnType("int");
b.Property("Value")
.HasColumnType("nvarchar(max)");
b.HasKey("Id");
b.HasIndex("InputFieldId");
b.ToTable("SelectValue");
b.HasData(
new
{
Id = 1,
InputFieldId = 5,
Value = "同意"
},
new
{
Id = 2,
InputFieldId = 5,
Value = "拒绝"
},
new
{
Id = 3,
InputFieldId = 10,
Value = "同意"
},
new
{
Id = 4,
InputFieldId = 10,
Value = "拒绝"
},
new
{
Id = 5,
InputFieldId = 13,
Value = "同意"
},
new
{
Id = 6,
InputFieldId = 13,
Value = "拒绝"
},
new
{
Id = 7,
InputFieldId = 17,
Value = "同意"
},
new
{
Id = 8,
InputFieldId = 17,
Value = "拒绝"
},
new
{
Id = 9,
InputFieldId = 6,
Value = "S"
},
new
{
Id = 10,
InputFieldId = 6,
Value = "A"
},
new
{
Id = 11,
InputFieldId = 6,
Value = "B"
},
new
{
Id = 12,
InputFieldId = 6,
Value = "C"
},
new
{
Id = 13,
InputFieldId = 6,
Value = "D"
},
new
{
Id = 14,
InputFieldId = 11,
Value = "实质"
},
new
{
Id = 15,
InputFieldId = 11,
Value = "形式"
},
new
{
Id = 16,
InputFieldId = 19,
Value = "中-德"
},
new
{
Id = 17,
InputFieldId = 19,
Value = "中-英"
},
new
{
Id = 18,
InputFieldId = 19,
Value = "英-中"
},
new
{
Id = 19,
InputFieldId = 22,
Value = "同意"
},
new
{
Id = 20,
InputFieldId = 22,
Value = "拒绝"
});
});
modelBuilder.Entity("wispro.sp.entity.Staff", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("Account")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("Department")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("EntyDate")
.HasColumnType("date");
b.Property("IsCalPerformsnce")
.HasColumnType("bit")
.HasColumnName("isCalPerformsnce");
b.Property("IsOnJob")
.HasColumnType("bit");
b.Property("Mail")
.HasColumnType("nvarchar(max)");
b.Property("Memo")
.HasColumnType("nvarchar(max)");
b.Property("Mobile")
.HasColumnType("nvarchar(max)");
b.Property("Name")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("Password")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("Sex")
.HasColumnType("nvarchar(max)");
b.Property("StaffGradeId")
.HasColumnType("int");
b.Property("Status")
.IsRequired()
.HasMaxLength(25)
.HasColumnType("nvarchar(25)");
b.Property("Tel")
.HasColumnType("nvarchar(max)");
b.Property("WorkPlace")
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.HasKey("Id");
b.HasIndex("StaffGradeId");
b.ToTable("Staff");
});
modelBuilder.Entity("wispro.sp.entity.StaffGrade", b =>
{
b.Property("Id")
.ValueGeneratedOnAdd()
.HasColumnType("int")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
b.Property("Coefficient")
.HasColumnType("float");
b.Property("Grade")
.IsRequired()
.HasMaxLength(5)
.HasColumnType("nchar(5)")
.IsFixedLength(true);
b.HasKey("Id");
b.ToTable("StaffGrade");
b.HasData(
new
{
Id = 1,
Coefficient = 1.2,
Grade = "S级"
},
new
{
Id = 2,
Coefficient = 1.1000000000000001,
Grade = "A3级"
},
new
{
Id = 3,
Coefficient = 1.1000000000000001,
Grade = "A2级"
},
new
{
Id = 4,
Coefficient = 1.1000000000000001,
Grade = "A1级"
},
new
{
Id = 5,
Coefficient = 1.0,
Grade = "B3级"
},
new
{
Id = 6,
Coefficient = 1.0,
Grade = "B2级"
},
new
{
Id = 7,
Coefficient = 0.90000000000000002,
Grade = "B1级"
},
new
{
Id = 8,
Coefficient = 0.90000000000000002,
Grade = "C3级"
},
new
{
Id = 9,
Coefficient = 0.69999999999999996,
Grade = "C2级"
},
new
{
Id = 10,
Coefficient = 0.69999999999999996,
Grade = "C1级"
},
new
{
Id = 11,
Coefficient = 0.59999999999999998,
Grade = "D3级"
},
new
{
Id = 12,
Coefficient = 0.59999999999999998,
Grade = "D2级"
},
new
{
Id = 13,
Coefficient = 0.5,
Grade = "D1级"
},
new
{
Id = 14,
Coefficient = 1.1000000000000001,
Grade = "A级"
},
new
{
Id = 15,
Coefficient = 1.0,
Grade = "C级"
},
new
{
Id = 16,
Coefficient = 0.90000000000000002,
Grade = "D级"
});
});
modelBuilder.Entity("wispro.sp.entity.VerifyCoefficient", b =>
{
b.Property("CheckerId")
.HasColumnType("int");
b.Property("DoPersonId")
.HasColumnType("int");
b.Property("Coefficient")
.HasColumnType("float");
b.HasKey("CheckerId", "DoPersonId");
b.HasIndex("DoPersonId");
b.ToTable("VerifyCoefficient");
b.HasData(
new
{
CheckerId = 1,
DoPersonId = 5,
Coefficient = 0.29999999999999999
},
new
{
CheckerId = 1,
DoPersonId = 6,
Coefficient = 0.29999999999999999
},
new
{
CheckerId = 1,
DoPersonId = 7,
Coefficient = 0.29999999999999999
},
new
{
CheckerId = 1,
DoPersonId = 8,
Coefficient = 0.29999999999999999
},
new
{
CheckerId = 1,
DoPersonId = 9,
Coefficient = 0.40000000000000002
},
new
{
CheckerId = 1,
DoPersonId = 10,
Coefficient = 0.40000000000000002
},
new
{
CheckerId = 1,
DoPersonId = 11,
Coefficient = 0.5
},
new
{
CheckerId = 1,
DoPersonId = 12,
Coefficient = 0.5
},
new
{
CheckerId = 1,
DoPersonId = 13,
Coefficient = 0.59999999999999998
},
new
{
CheckerId = 2,
DoPersonId = 5,
Coefficient = 0.20000000000000001
},
new
{
CheckerId = 2,
DoPersonId = 6,
Coefficient = 0.20000000000000001
},
new
{
CheckerId = 2,
DoPersonId = 7,
Coefficient = 0.20000000000000001
},
new
{
CheckerId = 2,
DoPersonId = 8,
Coefficient = 0.20000000000000001
},
new
{
CheckerId = 2,
DoPersonId = 9,
Coefficient = 0.29999999999999999
},
new
{
CheckerId = 2,
DoPersonId = 10,
Coefficient = 0.29999999999999999
},
new
{
CheckerId = 2,
DoPersonId = 11,
Coefficient = 0.40000000000000002
},
new
{
CheckerId = 2,
DoPersonId = 12,
Coefficient = 0.40000000000000002
},
new
{
CheckerId = 2,
DoPersonId = 13,
Coefficient = 0.5
},
new
{
CheckerId = 3,
DoPersonId = 5,
Coefficient = 0.20000000000000001
},
new
{
CheckerId = 3,
DoPersonId = 6,
Coefficient = 0.20000000000000001
},
new
{
CheckerId = 3,
DoPersonId = 7,
Coefficient = 0.20000000000000001
},
new
{
CheckerId = 3,
DoPersonId = 8,
Coefficient = 0.20000000000000001
},
new
{
CheckerId = 3,
DoPersonId = 9,
Coefficient = 0.29999999999999999
},
new
{
CheckerId = 3,
DoPersonId = 10,
Coefficient = 0.29999999999999999
},
new
{
CheckerId = 3,
DoPersonId = 11,
Coefficient = 0.40000000000000002
},
new
{
CheckerId = 3,
DoPersonId = 12,
Coefficient = 0.40000000000000002
},
new
{
CheckerId = 3,
DoPersonId = 13,
Coefficient = 0.5
},
new
{
CheckerId = 4,
DoPersonId = 5,
Coefficient = 0.20000000000000001
},
new
{
CheckerId = 4,
DoPersonId = 6,
Coefficient = 0.20000000000000001
},
new
{
CheckerId = 4,
DoPersonId = 7,
Coefficient = 0.20000000000000001
},
new
{
CheckerId = 4,
DoPersonId = 8,
Coefficient = 0.20000000000000001
},
new
{
CheckerId = 4,
DoPersonId = 9,
Coefficient = 0.29999999999999999
},
new
{
CheckerId = 4,
DoPersonId = 10,
Coefficient = 0.29999999999999999
},
new
{
CheckerId = 4,
DoPersonId = 11,
Coefficient = 0.40000000000000002
},
new
{
CheckerId = 4,
DoPersonId = 12,
Coefficient = 0.40000000000000002
},
new
{
CheckerId = 4,
DoPersonId = 13,
Coefficient = 0.5
},
new
{
CheckerId = 5,
DoPersonId = 5,
Coefficient = 0.20000000000000001
},
new
{
CheckerId = 5,
DoPersonId = 6,
Coefficient = 0.20000000000000001
},
new
{
CheckerId = 5,
DoPersonId = 7,
Coefficient = 0.20000000000000001
},
new
{
CheckerId = 5,
DoPersonId = 8,
Coefficient = 0.20000000000000001
},
new
{
CheckerId = 5,
DoPersonId = 9,
Coefficient = 0.29999999999999999
},
new
{
CheckerId = 5,
DoPersonId = 10,
Coefficient = 0.29999999999999999
},
new
{
CheckerId = 5,
DoPersonId = 11,
Coefficient = 0.40000000000000002
},
new
{
CheckerId = 5,
DoPersonId = 12,
Coefficient = 0.40000000000000002
},
new
{
CheckerId = 5,
DoPersonId = 13,
Coefficient = 0.5
},
new
{
CheckerId = 6,
DoPersonId = 5,
Coefficient = 0.20000000000000001
},
new
{
CheckerId = 6,
DoPersonId = 6,
Coefficient = 0.20000000000000001
},
new
{
CheckerId = 6,
DoPersonId = 7,
Coefficient = 0.20000000000000001
},
new
{
CheckerId = 6,
DoPersonId = 8,
Coefficient = 0.20000000000000001
},
new
{
CheckerId = 6,
DoPersonId = 9,
Coefficient = 0.29999999999999999
},
new
{
CheckerId = 6,
DoPersonId = 10,
Coefficient = 0.29999999999999999
},
new
{
CheckerId = 6,
DoPersonId = 11,
Coefficient = 0.40000000000000002
},
new
{
CheckerId = 6,
DoPersonId = 12,
Coefficient = 0.40000000000000002
},
new
{
CheckerId = 6,
DoPersonId = 13,
Coefficient = 0.5
});
});
modelBuilder.Entity("wispro.sp.entity.AppealRecord", b =>
{
b.HasOne("wispro.sp.entity.Staff", "Creater")
.WithMany()
.HasForeignKey("CreaterId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("wispro.sp.entity.PerformanceItem", "Item")
.WithMany()
.HasForeignKey("ItemId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.HasOne("wispro.sp.entity.Staff", "Reviewer")
.WithMany()
.HasForeignKey("ReviewerId")
.OnDelete(DeleteBehavior.NoAction);
b.HasOne("wispro.sp.entity.AppealType", "Type")
.WithMany()
.HasForeignKey("TypeId")
.OnDelete(DeleteBehavior.NoAction)
.IsRequired();
b.Navigation("Creater");
b.Navigation("Item");
b.Navigation("Reviewer");
b.Navigation("Type");
});
modelBuilder.Entity("wispro.sp.entity.AttachFile", b =>
{
b.HasOne("wispro.sp.entity.AppealRecord", "AppealRecord")
.WithMany("AttachFiles")
.HasForeignKey("AppealRecordId")
.HasConstraintName("FK_AttachFile_AppealRecord");
b.HasOne("wispro.sp.entity.Staff", "UploadUser")
.WithMany()
.HasForeignKey("UploadUserId")
.HasConstraintName("FK_AttachFile_UpdateUser")
.OnDelete(DeleteBehavior.NoAction)
.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.SelectValue", b =>
{
b.HasOne("wispro.sp.entity.InputField", "InputField")
.WithMany("SelectValues")
.HasForeignKey("InputFieldId")
.OnDelete(DeleteBehavior.Cascade)
.IsRequired();
b.Navigation("InputField");
});
modelBuilder.Entity("wispro.sp.entity.Staff", b =>
{
b.HasOne("wispro.sp.entity.StaffGrade", "StaffGrade")
.WithMany("Staff")
.HasForeignKey("StaffGradeId")
.HasConstraintName("FK_Staff_StaffGrade");
b.Navigation("StaffGrade");
});
modelBuilder.Entity("wispro.sp.entity.VerifyCoefficient", b =>
{
b.HasOne("wispro.sp.entity.StaffGrade", "Checker")
.WithMany("VerifyCoefficientCheckers")
.HasForeignKey("CheckerId")
.HasConstraintName("FK_VerifyCoefficient_StaffGrade")
.IsRequired();
b.HasOne("wispro.sp.entity.StaffGrade", "DoPerson")
.WithMany("VerifyCoefficientDoPeople")
.HasForeignKey("DoPersonId")
.HasConstraintName("FK_VerifyCoefficient_StaffGrade1")
.IsRequired();
b.Navigation("Checker");
b.Navigation("DoPerson");
});
modelBuilder.Entity("wispro.sp.entity.AppealRecord", b =>
{
b.Navigation("AttachFiles");
});
modelBuilder.Entity("wispro.sp.entity.CalMonth", b =>
{
b.Navigation("PerformanceItems");
});
modelBuilder.Entity("wispro.sp.entity.Customer", b =>
{
b.Navigation("PerformanceItems");
});
modelBuilder.Entity("wispro.sp.entity.InputField", b =>
{
b.Navigation("SelectValues");
});
modelBuilder.Entity("wispro.sp.entity.Message", b =>
{
b.Navigation("RelatedItem");
b.Navigation("To");
});
modelBuilder.Entity("wispro.sp.entity.PerformanceItem", b =>
{
b.Navigation("ItemStaffs");
});
modelBuilder.Entity("wispro.sp.entity.Staff", b =>
{
b.Navigation("Customers");
b.Navigation("ItemStaffs");
b.Navigation("ReviewerItems");
});
modelBuilder.Entity("wispro.sp.entity.StaffGrade", b =>
{
b.Navigation("Staff");
b.Navigation("VerifyCoefficientCheckers");
b.Navigation("VerifyCoefficientDoPeople");
});
#pragma warning restore 612, 618
}
}
}