//
using System;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Infrastructure;
using Microsoft.EntityFrameworkCore.Metadata;
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
using wispro.sp.api;
namespace wispro.sp.api.Migrations
{
[DbContext(typeof(spDbContext))]
partial class spDbContextModelSnapshot : ModelSnapshot
{
protected override void BuildModel(ModelBuilder modelBuilder)
{
#pragma warning disable 612, 618
modelBuilder
.HasAnnotation("Relational:Collation", "Chinese_PRC_CI_AS")
.HasAnnotation("Relational:MaxIdentifierLength", 128)
.HasAnnotation("ProductVersion", "5.0.9")
.HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
modelBuilder.Entity("wispro.sp.entity.Customer", b =>
{
b.Property("Id")
.HasColumnType("int");
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.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.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("CaseCoefficient")
.HasMaxLength(10)
.HasColumnType("nvarchar(10)");
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("Month")
.HasColumnType("int");
b.Property("OverDueMemo")
.HasMaxLength(100)
.HasColumnType("nvarchar(100)");
b.Property("PreOastaffId")
.HasColumnType("int")
.HasColumnName("PreOAStaffId");
b.Property("ReturnDate")
.HasColumnType("date");
b.Property("ReviewerId")
.HasColumnType("int");
b.Property("StaffId")
.HasColumnType("int");
b.Property("Status")
.HasColumnType("int")
.HasColumnName("status");
b.Property("Year")
.HasColumnType("int");
b.HasKey("Id");
b.HasIndex("CustomerId");
b.HasIndex("PreOastaffId");
b.HasIndex("ReviewerId");
b.HasIndex("StaffId");
b.ToTable("PerformanceItem");
});
modelBuilder.Entity("wispro.sp.entity.Staff", b =>
{
b.Property("Id")
.HasColumnType("int");
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("Memo")
.HasColumnType("nvarchar(max)");
b.Property("Name")
.IsRequired()
.HasMaxLength(50)
.HasColumnType("nvarchar(50)");
b.Property("Password")
.IsRequired()
.HasColumnType("nvarchar(max)");
b.Property("StaffGradeId")
.HasColumnType("int");
b.Property("Status")
.IsRequired()
.HasMaxLength(25)
.HasColumnType("nvarchar(25)");
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级"
});
});
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 = 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
});
});
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.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.PerformanceItem", b =>
{
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.HasOne("wispro.sp.entity.Staff", null)
.WithMany("PerformanceItems")
.HasForeignKey("StaffId");
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")
.IsRequired();
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.Customer", b =>
{
b.Navigation("PerformanceItems");
});
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("PerformanceItems");
b.Navigation("ReviewerItems");
});
modelBuilder.Entity("wispro.sp.entity.StaffGrade", b =>
{
b.Navigation("Staff");
b.Navigation("VerifyCoefficientCheckers");
b.Navigation("VerifyCoefficientDoPeople");
});
#pragma warning restore 612, 618
}
}
}