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