20211115011112_addCaseCeoffcient.Designer.cs 63 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748
  1. // <auto-generated />
  2. using System;
  3. using Microsoft.EntityFrameworkCore;
  4. using Microsoft.EntityFrameworkCore.Infrastructure;
  5. using Microsoft.EntityFrameworkCore.Metadata;
  6. using Microsoft.EntityFrameworkCore.Migrations;
  7. using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
  8. using wispro.sp.api;
  9. namespace wispro.sp.api.Migrations
  10. {
  11. [DbContext(typeof(spDbContext))]
  12. [Migration("20211115011112_addCaseCeoffcient")]
  13. partial class addCaseCeoffcient
  14. {
  15. protected override void BuildTargetModel(ModelBuilder modelBuilder)
  16. {
  17. #pragma warning disable 612, 618
  18. modelBuilder
  19. .HasAnnotation("Relational:MaxIdentifierLength", 128)
  20. .HasAnnotation("ProductVersion", "5.0.9")
  21. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  22. modelBuilder.Entity("wispro.sp.entity.AppealRecord", b =>
  23. {
  24. b.Property<int>("Id")
  25. .ValueGeneratedOnAdd()
  26. .HasColumnType("int")
  27. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  28. b.Property<DateTime>("CreateTime")
  29. .HasColumnType("datetime2");
  30. b.Property<int>("CreaterId")
  31. .HasColumnType("int");
  32. b.Property<int>("ItemId")
  33. .HasColumnType("int");
  34. b.Property<string>("Reason")
  35. .HasMaxLength(500)
  36. .HasColumnType("nvarchar(500)");
  37. b.Property<DateTime?>("ReviewTime")
  38. .HasColumnType("datetime2");
  39. b.Property<int?>("ReviewerId")
  40. .HasColumnType("int");
  41. b.Property<string>("ReviewerMemo")
  42. .HasColumnType("nvarchar(max)");
  43. b.Property<int>("State")
  44. .HasColumnType("int");
  45. b.Property<int>("TypeId")
  46. .HasColumnType("int");
  47. b.HasKey("Id");
  48. b.HasIndex("CreaterId");
  49. b.HasIndex("ItemId");
  50. b.HasIndex("ReviewerId");
  51. b.HasIndex("TypeId");
  52. b.ToTable("AppealRecord");
  53. });
  54. modelBuilder.Entity("wispro.sp.entity.AppealType", b =>
  55. {
  56. b.Property<int>("Id")
  57. .ValueGeneratedOnAdd()
  58. .HasColumnType("int")
  59. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  60. b.Property<string>("CanDoExpress")
  61. .HasMaxLength(500)
  62. .HasColumnType("nvarchar(500)");
  63. b.Property<string>("Name")
  64. .HasMaxLength(50)
  65. .HasColumnType("nvarchar(50)");
  66. b.Property<string>("ReviewerExpress")
  67. .HasMaxLength(500)
  68. .HasColumnType("nvarchar(500)");
  69. b.Property<int>("Type")
  70. .HasColumnType("int");
  71. b.HasKey("Id");
  72. b.ToTable("AppealType");
  73. b.HasData(
  74. new
  75. {
  76. Id = 1,
  77. CanDoExpress = "p.ItemStaffs.Count()>1",
  78. Name = "绩效点数分配比率",
  79. Type = 0
  80. },
  81. new
  82. {
  83. Id = 2,
  84. CanDoExpress = "p.DoItem==\"新申请\"",
  85. Name = "案件系数复核",
  86. ReviewerExpress = "p.Reviewer",
  87. Type = 0
  88. },
  89. new
  90. {
  91. Id = 3,
  92. CanDoExpress = "p.DoItem==\"新申请\"",
  93. Name = "处理事项系数复核",
  94. ReviewerExpress = "p.Reviewer",
  95. Type = 0
  96. },
  97. new
  98. {
  99. Id = 4,
  100. CanDoExpress = "",
  101. Name = "案件缺漏申诉",
  102. ReviewerExpress = "p.Reviewer",
  103. Type = 1
  104. },
  105. new
  106. {
  107. Id = 5,
  108. CanDoExpress = "p.isDanger()",
  109. Name = "案件严重超期说明",
  110. Type = 0
  111. },
  112. new
  113. {
  114. Id = 6,
  115. CanDoExpress = "p.DoItem==\"新申请\" || p.DoItem==\"翻译\"",
  116. Name = "按照翻译字数算绩效备注",
  117. Type = 0
  118. });
  119. });
  120. modelBuilder.Entity("wispro.sp.entity.AttachFile", b =>
  121. {
  122. b.Property<Guid>("Id")
  123. .ValueGeneratedOnAdd()
  124. .HasColumnType("uniqueidentifier");
  125. b.Property<int?>("AppealRecordId")
  126. .HasColumnType("int");
  127. b.Property<string>("Name")
  128. .HasMaxLength(200)
  129. .HasColumnType("nvarchar(200)");
  130. b.Property<string>("SavePath")
  131. .HasMaxLength(200)
  132. .HasColumnType("nvarchar(200)");
  133. b.Property<int>("UploadUserId")
  134. .HasColumnType("int");
  135. b.HasKey("Id");
  136. b.HasIndex("AppealRecordId");
  137. b.HasIndex("UploadUserId");
  138. b.ToTable("AttachFile");
  139. });
  140. modelBuilder.Entity("wispro.sp.entity.BasePointRule", b =>
  141. {
  142. b.Property<int>("Id")
  143. .ValueGeneratedOnAdd()
  144. .HasColumnType("int")
  145. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  146. b.Property<string>("PointExpress")
  147. .HasMaxLength(100)
  148. .HasColumnType("nvarchar(100)");
  149. b.Property<int>("Priority")
  150. .HasColumnType("int");
  151. b.Property<string>("Rule")
  152. .HasMaxLength(1000)
  153. .HasColumnType("nvarchar(1000)");
  154. b.Property<string>("Type")
  155. .HasMaxLength(20)
  156. .HasColumnType("nvarchar(20)");
  157. b.HasKey("Id");
  158. b.ToTable("BasePointRule");
  159. });
  160. modelBuilder.Entity("wispro.sp.entity.CalMonth", b =>
  161. {
  162. b.Property<int>("Id")
  163. .ValueGeneratedOnAdd()
  164. .HasColumnType("int")
  165. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  166. b.Property<int>("Month")
  167. .HasColumnType("int")
  168. .HasColumnName("month");
  169. b.Property<int>("Status")
  170. .HasColumnType("int")
  171. .HasColumnName("status");
  172. b.Property<int>("Year")
  173. .HasColumnType("int")
  174. .HasColumnName("year");
  175. b.HasKey("Id");
  176. b.ToTable("CalMonth");
  177. });
  178. modelBuilder.Entity("wispro.sp.entity.CaseCeoffcient", b =>
  179. {
  180. b.Property<string>("Ceoffcient")
  181. .HasColumnType("nvarchar(450)");
  182. b.Property<double>("Value")
  183. .HasColumnType("float");
  184. b.HasKey("Ceoffcient");
  185. b.ToTable("CaseCeofficient");
  186. b.HasData(
  187. new
  188. {
  189. Ceoffcient = "S",
  190. Value = 2.5
  191. },
  192. new
  193. {
  194. Ceoffcient = "A",
  195. Value = 1.5
  196. },
  197. new
  198. {
  199. Ceoffcient = "B",
  200. Value = 1.0
  201. },
  202. new
  203. {
  204. Ceoffcient = "C",
  205. Value = 0.69999999999999996
  206. },
  207. new
  208. {
  209. Ceoffcient = "D",
  210. Value = 0.40000000000000002
  211. });
  212. });
  213. modelBuilder.Entity("wispro.sp.entity.Customer", b =>
  214. {
  215. b.Property<int>("Id")
  216. .ValueGeneratedOnAdd()
  217. .HasColumnType("int")
  218. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  219. b.Property<string>("Address")
  220. .HasMaxLength(500)
  221. .HasColumnType("nvarchar(500)");
  222. b.Property<string>("ContactMan")
  223. .HasMaxLength(50)
  224. .HasColumnType("nvarchar(50)");
  225. b.Property<string>("Name")
  226. .IsRequired()
  227. .HasMaxLength(200)
  228. .HasColumnType("nvarchar(200)");
  229. b.Property<string>("Phone")
  230. .HasMaxLength(50)
  231. .HasColumnType("nvarchar(50)");
  232. b.Property<int?>("ResponseManId")
  233. .HasColumnType("int");
  234. b.HasKey("Id");
  235. b.HasIndex("ResponseManId");
  236. b.ToTable("Customer");
  237. });
  238. modelBuilder.Entity("wispro.sp.entity.InputField", b =>
  239. {
  240. b.Property<int>("Id")
  241. .ValueGeneratedOnAdd()
  242. .HasColumnType("int")
  243. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  244. b.Property<int>("AppealState")
  245. .HasColumnType("int");
  246. b.Property<int>("AppealTypeId")
  247. .HasColumnType("int");
  248. b.Property<bool>("CanMuliSelect")
  249. .HasColumnType("bit");
  250. b.Property<string>("FieldName")
  251. .HasMaxLength(50)
  252. .HasColumnType("nvarchar(50)");
  253. b.Property<string>("FieldType")
  254. .HasMaxLength(50)
  255. .HasColumnType("nvarchar(50)");
  256. b.Property<string>("MapObjectField")
  257. .HasMaxLength(50)
  258. .HasColumnType("nvarchar(50)");
  259. b.Property<string>("MapObjectFieldLabel")
  260. .HasColumnType("nvarchar(max)");
  261. b.Property<int?>("MaxSize")
  262. .HasColumnType("int");
  263. b.HasKey("Id");
  264. b.HasIndex("AppealTypeId");
  265. b.ToTable("InputField");
  266. b.HasData(
  267. new
  268. {
  269. Id = 1,
  270. AppealState = 0,
  271. AppealTypeId = 1,
  272. CanMuliSelect = false,
  273. FieldName = "分配比率",
  274. FieldType = "System.Double",
  275. MapObjectField = "ItemStaffs.PerformancePoint",
  276. MapObjectFieldLabel = "ItemStaffs.DoPerson.Name"
  277. },
  278. new
  279. {
  280. Id = 3,
  281. AppealState = 0,
  282. AppealTypeId = 1,
  283. CanMuliSelect = false,
  284. FieldName = "原因",
  285. FieldType = "System.String"
  286. },
  287. new
  288. {
  289. Id = 4,
  290. AppealState = 1,
  291. AppealTypeId = 1,
  292. CanMuliSelect = false,
  293. FieldName = "备注",
  294. FieldType = "System.String"
  295. },
  296. new
  297. {
  298. Id = 5,
  299. AppealState = 1,
  300. AppealTypeId = 1,
  301. CanMuliSelect = false,
  302. FieldName = "审核意见",
  303. FieldType = "System.String"
  304. },
  305. new
  306. {
  307. Id = 6,
  308. AppealState = 0,
  309. AppealTypeId = 2,
  310. CanMuliSelect = false,
  311. FieldName = "案件系数",
  312. FieldType = "System.String",
  313. MapObjectField = "CaseCoefficient"
  314. },
  315. new
  316. {
  317. Id = 9,
  318. AppealState = 1,
  319. AppealTypeId = 2,
  320. CanMuliSelect = false,
  321. FieldName = "备注",
  322. FieldType = "System.String"
  323. },
  324. new
  325. {
  326. Id = 10,
  327. AppealState = 1,
  328. AppealTypeId = 2,
  329. CanMuliSelect = false,
  330. FieldName = "审核意见",
  331. FieldType = "System.String"
  332. },
  333. new
  334. {
  335. Id = 11,
  336. AppealState = 0,
  337. AppealTypeId = 3,
  338. CanMuliSelect = false,
  339. FieldName = "处理事项系数",
  340. FieldType = "System.String",
  341. MapObjectField = "DoItemCoefficient"
  342. },
  343. new
  344. {
  345. Id = 12,
  346. AppealState = 1,
  347. AppealTypeId = 3,
  348. CanMuliSelect = false,
  349. FieldName = "备注",
  350. FieldType = "System.String"
  351. },
  352. new
  353. {
  354. Id = 13,
  355. AppealState = 1,
  356. AppealTypeId = 3,
  357. CanMuliSelect = false,
  358. FieldName = "审核意见",
  359. FieldType = "System.String"
  360. },
  361. new
  362. {
  363. Id = 14,
  364. AppealState = 0,
  365. AppealTypeId = 4,
  366. CanMuliSelect = false,
  367. FieldName = "我方文号",
  368. FieldType = "System.String"
  369. },
  370. new
  371. {
  372. Id = 15,
  373. AppealState = 0,
  374. AppealTypeId = 4,
  375. CanMuliSelect = false,
  376. FieldName = "处理事项",
  377. FieldType = "System.String"
  378. },
  379. new
  380. {
  381. Id = 16,
  382. AppealState = 1,
  383. AppealTypeId = 4,
  384. CanMuliSelect = false,
  385. FieldName = "备注",
  386. FieldType = "System.String"
  387. },
  388. new
  389. {
  390. Id = 17,
  391. AppealState = 1,
  392. AppealTypeId = 4,
  393. CanMuliSelect = false,
  394. FieldName = "审核意见",
  395. FieldType = "System.String"
  396. },
  397. new
  398. {
  399. Id = 18,
  400. AppealState = 0,
  401. AppealTypeId = 5,
  402. CanMuliSelect = false,
  403. FieldName = "超期说明",
  404. FieldType = "System.String",
  405. MapObjectField = "OverDueMemo"
  406. },
  407. new
  408. {
  409. Id = 21,
  410. AppealState = 1,
  411. AppealTypeId = 5,
  412. CanMuliSelect = false,
  413. FieldName = "审核意见",
  414. FieldType = "System.String"
  415. },
  416. new
  417. {
  418. Id = 22,
  419. AppealState = 1,
  420. AppealTypeId = 5,
  421. CanMuliSelect = false,
  422. FieldName = "备注",
  423. FieldType = "System.String"
  424. },
  425. new
  426. {
  427. Id = 19,
  428. AppealState = 0,
  429. AppealTypeId = 6,
  430. CanMuliSelect = false,
  431. FieldName = "翻译类型",
  432. FieldType = "System.String",
  433. MapObjectField = "AgentFeedbackMemo"
  434. },
  435. new
  436. {
  437. Id = 20,
  438. AppealState = 0,
  439. AppealTypeId = 6,
  440. CanMuliSelect = false,
  441. FieldName = "翻译字数",
  442. FieldType = "System.Int32",
  443. MapObjectField = "WordCount"
  444. },
  445. new
  446. {
  447. Id = 23,
  448. AppealState = 1,
  449. AppealTypeId = 6,
  450. CanMuliSelect = false,
  451. FieldName = "审核意见",
  452. FieldType = "System.Int32"
  453. },
  454. new
  455. {
  456. Id = 24,
  457. AppealState = 1,
  458. AppealTypeId = 6,
  459. CanMuliSelect = false,
  460. FieldName = "翻译字数",
  461. FieldType = "System.Int32",
  462. MapObjectField = "WordCount"
  463. });
  464. });
  465. modelBuilder.Entity("wispro.sp.entity.InputFieldValue", b =>
  466. {
  467. b.Property<int>("Id")
  468. .ValueGeneratedOnAdd()
  469. .HasColumnType("int")
  470. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  471. b.Property<int>("AppealRecordId")
  472. .HasColumnType("int");
  473. b.Property<int>("InputFieldId")
  474. .HasColumnType("int");
  475. b.Property<string>("Label")
  476. .HasColumnType("nvarchar(max)");
  477. b.Property<string>("Value")
  478. .HasMaxLength(500)
  479. .HasColumnType("nvarchar(500)");
  480. b.Property<string>("mapExpress")
  481. .HasColumnType("nvarchar(max)");
  482. b.HasKey("Id");
  483. b.HasIndex("AppealRecordId");
  484. b.HasIndex("InputFieldId");
  485. b.ToTable("InputFieldValue");
  486. });
  487. modelBuilder.Entity("wispro.sp.entity.ItemStaff", b =>
  488. {
  489. b.Property<int>("ItemId")
  490. .HasColumnType("int");
  491. b.Property<int>("DoPersonId")
  492. .HasColumnType("int");
  493. b.Property<double?>("PerformancePoint")
  494. .HasColumnType("float");
  495. b.HasKey("ItemId", "DoPersonId");
  496. b.HasIndex("DoPersonId");
  497. b.ToTable("ItemStaff");
  498. });
  499. modelBuilder.Entity("wispro.sp.entity.Message", b =>
  500. {
  501. b.Property<Guid>("Id")
  502. .ValueGeneratedOnAdd()
  503. .HasColumnType("uniqueidentifier");
  504. b.Property<int>("FromId")
  505. .HasColumnType("int");
  506. b.Property<string>("MessageInfo")
  507. .HasMaxLength(500)
  508. .HasColumnType("nvarchar(500)");
  509. b.Property<int>("Type")
  510. .HasColumnType("int");
  511. b.HasKey("Id");
  512. b.HasIndex("FromId");
  513. b.ToTable("Message");
  514. });
  515. modelBuilder.Entity("wispro.sp.entity.MessagePerformanceItem", b =>
  516. {
  517. b.Property<int>("ItemId")
  518. .HasColumnType("int");
  519. b.Property<Guid>("MessageId")
  520. .HasColumnType("uniqueidentifier");
  521. b.HasKey("ItemId", "MessageId");
  522. b.HasIndex("MessageId");
  523. b.ToTable("MessagePerformanceItems");
  524. });
  525. modelBuilder.Entity("wispro.sp.entity.MessageReadRecord", b =>
  526. {
  527. b.Property<Guid>("MessageId")
  528. .HasColumnType("uniqueidentifier");
  529. b.Property<int>("StaffId")
  530. .HasColumnType("int");
  531. b.Property<Guid?>("MessageId1")
  532. .HasColumnType("uniqueidentifier");
  533. b.Property<bool>("isReaded")
  534. .HasColumnType("bit");
  535. b.HasKey("MessageId", "StaffId");
  536. b.HasIndex("MessageId1");
  537. b.HasIndex("StaffId");
  538. b.ToTable("MessageReadRecord");
  539. });
  540. modelBuilder.Entity("wispro.sp.entity.PerformanceItem", b =>
  541. {
  542. b.Property<int>("Id")
  543. .ValueGeneratedOnAdd()
  544. .HasColumnType("int")
  545. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  546. b.Property<string>("AgentFeedbackMemo")
  547. .HasColumnType("nvarchar(max)");
  548. b.Property<string>("ApplicationName")
  549. .HasMaxLength(200)
  550. .HasColumnType("nvarchar(200)");
  551. b.Property<string>("ApplicationType")
  552. .HasMaxLength(50)
  553. .HasColumnType("nvarchar(50)");
  554. b.Property<decimal?>("BasePoint")
  555. .HasColumnType("numeric(18,2)");
  556. b.Property<string>("BusinessType")
  557. .HasMaxLength(50)
  558. .HasColumnType("nvarchar(50)");
  559. b.Property<int>("CalMonthId")
  560. .HasColumnType("int");
  561. b.Property<string>("CaseCoefficient")
  562. .HasMaxLength(10)
  563. .HasColumnType("nvarchar(10)");
  564. b.Property<string>("CaseMemo")
  565. .HasColumnType("nvarchar(max)");
  566. b.Property<string>("CaseName")
  567. .HasMaxLength(500)
  568. .HasColumnType("nvarchar(500)");
  569. b.Property<string>("CaseNo")
  570. .HasMaxLength(50)
  571. .HasColumnType("nvarchar(50)");
  572. b.Property<string>("CaseStage")
  573. .HasMaxLength(50)
  574. .HasColumnType("nvarchar(50)");
  575. b.Property<string>("CaseState")
  576. .HasMaxLength(50)
  577. .HasColumnType("nvarchar(50)");
  578. b.Property<string>("CaseType")
  579. .HasMaxLength(50)
  580. .HasColumnType("nvarchar(50)");
  581. b.Property<int?>("CustomerId")
  582. .HasColumnType("int");
  583. b.Property<DateTime?>("CustomerLimitDate")
  584. .HasColumnType("date");
  585. b.Property<string>("DoItem")
  586. .HasMaxLength(50)
  587. .HasColumnType("nvarchar(50)");
  588. b.Property<string>("DoItemCoefficient")
  589. .HasMaxLength(50)
  590. .HasColumnType("nvarchar(50)");
  591. b.Property<string>("DoItemMemo")
  592. .HasMaxLength(500)
  593. .HasColumnType("nvarchar(500)");
  594. b.Property<string>("DoItemState")
  595. .HasMaxLength(50)
  596. .HasColumnType("nvarchar(50)");
  597. b.Property<DateTime?>("EntrustingDate")
  598. .HasColumnType("date");
  599. b.Property<DateTime?>("FinalizationDate")
  600. .HasColumnType("date");
  601. b.Property<DateTime?>("FinishedDate")
  602. .HasColumnType("date");
  603. b.Property<DateTime?>("FirstDraftDate")
  604. .HasColumnType("date");
  605. b.Property<DateTime?>("InternalDate")
  606. .HasColumnType("date");
  607. b.Property<string>("OverDueMemo")
  608. .HasMaxLength(100)
  609. .HasColumnType("nvarchar(100)");
  610. b.Property<int?>("PreOastaffId")
  611. .HasColumnType("int")
  612. .HasColumnName("PreOAStaffId");
  613. b.Property<string>("ReturnCasseNo")
  614. .HasColumnType("nvarchar(max)");
  615. b.Property<DateTime?>("ReturnDate")
  616. .HasColumnType("date");
  617. b.Property<int?>("ReviewerId")
  618. .HasColumnType("int");
  619. b.Property<int?>("Status")
  620. .HasColumnType("int");
  621. b.Property<string>("Type")
  622. .HasColumnType("nvarchar(max)");
  623. b.Property<int?>("WordCount")
  624. .HasColumnType("int");
  625. b.HasKey("Id");
  626. b.HasIndex("CalMonthId");
  627. b.HasIndex("CustomerId");
  628. b.HasIndex("PreOastaffId");
  629. b.HasIndex("ReviewerId");
  630. b.ToTable("PerformanceItem");
  631. });
  632. modelBuilder.Entity("wispro.sp.entity.SelectValue", b =>
  633. {
  634. b.Property<int>("Id")
  635. .ValueGeneratedOnAdd()
  636. .HasColumnType("int")
  637. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  638. b.Property<int>("InputFieldId")
  639. .HasColumnType("int");
  640. b.Property<string>("Value")
  641. .HasColumnType("nvarchar(max)");
  642. b.HasKey("Id");
  643. b.HasIndex("InputFieldId");
  644. b.ToTable("SelectValue");
  645. b.HasData(
  646. new
  647. {
  648. Id = 1,
  649. InputFieldId = 5,
  650. Value = "同意"
  651. },
  652. new
  653. {
  654. Id = 2,
  655. InputFieldId = 5,
  656. Value = "拒绝"
  657. },
  658. new
  659. {
  660. Id = 3,
  661. InputFieldId = 10,
  662. Value = "同意"
  663. },
  664. new
  665. {
  666. Id = 4,
  667. InputFieldId = 10,
  668. Value = "拒绝"
  669. },
  670. new
  671. {
  672. Id = 5,
  673. InputFieldId = 13,
  674. Value = "同意"
  675. },
  676. new
  677. {
  678. Id = 6,
  679. InputFieldId = 13,
  680. Value = "拒绝"
  681. },
  682. new
  683. {
  684. Id = 7,
  685. InputFieldId = 17,
  686. Value = "同意"
  687. },
  688. new
  689. {
  690. Id = 8,
  691. InputFieldId = 17,
  692. Value = "拒绝"
  693. },
  694. new
  695. {
  696. Id = 9,
  697. InputFieldId = 6,
  698. Value = "S"
  699. },
  700. new
  701. {
  702. Id = 10,
  703. InputFieldId = 6,
  704. Value = "A"
  705. },
  706. new
  707. {
  708. Id = 11,
  709. InputFieldId = 6,
  710. Value = "B"
  711. },
  712. new
  713. {
  714. Id = 12,
  715. InputFieldId = 6,
  716. Value = "C"
  717. },
  718. new
  719. {
  720. Id = 13,
  721. InputFieldId = 6,
  722. Value = "D"
  723. },
  724. new
  725. {
  726. Id = 14,
  727. InputFieldId = 11,
  728. Value = "实质"
  729. },
  730. new
  731. {
  732. Id = 15,
  733. InputFieldId = 11,
  734. Value = "形式"
  735. },
  736. new
  737. {
  738. Id = 16,
  739. InputFieldId = 19,
  740. Value = "中-德"
  741. },
  742. new
  743. {
  744. Id = 17,
  745. InputFieldId = 19,
  746. Value = "中-英"
  747. },
  748. new
  749. {
  750. Id = 18,
  751. InputFieldId = 19,
  752. Value = "英-中"
  753. },
  754. new
  755. {
  756. Id = 19,
  757. InputFieldId = 22,
  758. Value = "同意"
  759. },
  760. new
  761. {
  762. Id = 20,
  763. InputFieldId = 22,
  764. Value = "拒绝"
  765. });
  766. });
  767. modelBuilder.Entity("wispro.sp.entity.Staff", b =>
  768. {
  769. b.Property<int>("Id")
  770. .ValueGeneratedOnAdd()
  771. .HasColumnType("int")
  772. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  773. b.Property<string>("Account")
  774. .IsRequired()
  775. .HasMaxLength(50)
  776. .HasColumnType("nvarchar(50)");
  777. b.Property<string>("Department")
  778. .HasMaxLength(50)
  779. .HasColumnType("nvarchar(50)");
  780. b.Property<DateTime?>("EntyDate")
  781. .HasColumnType("date");
  782. b.Property<bool>("IsCalPerformsnce")
  783. .HasColumnType("bit")
  784. .HasColumnName("isCalPerformsnce");
  785. b.Property<bool>("IsOnJob")
  786. .HasColumnType("bit");
  787. b.Property<string>("Mail")
  788. .HasColumnType("nvarchar(max)");
  789. b.Property<string>("Memo")
  790. .HasColumnType("nvarchar(max)");
  791. b.Property<string>("Mobile")
  792. .HasColumnType("nvarchar(max)");
  793. b.Property<string>("Name")
  794. .IsRequired()
  795. .HasMaxLength(50)
  796. .HasColumnType("nvarchar(50)");
  797. b.Property<string>("Password")
  798. .IsRequired()
  799. .HasColumnType("nvarchar(max)");
  800. b.Property<string>("Sex")
  801. .HasColumnType("nvarchar(max)");
  802. b.Property<int?>("StaffGradeId")
  803. .HasColumnType("int");
  804. b.Property<string>("Status")
  805. .IsRequired()
  806. .HasMaxLength(25)
  807. .HasColumnType("nvarchar(25)");
  808. b.Property<string>("Tel")
  809. .HasColumnType("nvarchar(max)");
  810. b.Property<string>("WorkPlace")
  811. .HasMaxLength(50)
  812. .HasColumnType("nvarchar(50)");
  813. b.HasKey("Id");
  814. b.HasIndex("StaffGradeId");
  815. b.ToTable("Staff");
  816. });
  817. modelBuilder.Entity("wispro.sp.entity.StaffGrade", b =>
  818. {
  819. b.Property<int>("Id")
  820. .ValueGeneratedOnAdd()
  821. .HasColumnType("int")
  822. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  823. b.Property<double>("Coefficient")
  824. .HasColumnType("float");
  825. b.Property<string>("Grade")
  826. .IsRequired()
  827. .HasMaxLength(5)
  828. .HasColumnType("nchar(5)")
  829. .IsFixedLength(true);
  830. b.HasKey("Id");
  831. b.ToTable("StaffGrade");
  832. b.HasData(
  833. new
  834. {
  835. Id = 1,
  836. Coefficient = 1.2,
  837. Grade = "S级"
  838. },
  839. new
  840. {
  841. Id = 2,
  842. Coefficient = 1.1000000000000001,
  843. Grade = "A3级"
  844. },
  845. new
  846. {
  847. Id = 3,
  848. Coefficient = 1.1000000000000001,
  849. Grade = "A2级"
  850. },
  851. new
  852. {
  853. Id = 4,
  854. Coefficient = 1.1000000000000001,
  855. Grade = "A1级"
  856. },
  857. new
  858. {
  859. Id = 5,
  860. Coefficient = 1.0,
  861. Grade = "B3级"
  862. },
  863. new
  864. {
  865. Id = 6,
  866. Coefficient = 1.0,
  867. Grade = "B2级"
  868. },
  869. new
  870. {
  871. Id = 7,
  872. Coefficient = 0.90000000000000002,
  873. Grade = "B1级"
  874. },
  875. new
  876. {
  877. Id = 8,
  878. Coefficient = 0.90000000000000002,
  879. Grade = "C3级"
  880. },
  881. new
  882. {
  883. Id = 9,
  884. Coefficient = 0.69999999999999996,
  885. Grade = "C2级"
  886. },
  887. new
  888. {
  889. Id = 10,
  890. Coefficient = 0.69999999999999996,
  891. Grade = "C1级"
  892. },
  893. new
  894. {
  895. Id = 11,
  896. Coefficient = 0.59999999999999998,
  897. Grade = "D3级"
  898. },
  899. new
  900. {
  901. Id = 12,
  902. Coefficient = 0.59999999999999998,
  903. Grade = "D2级"
  904. },
  905. new
  906. {
  907. Id = 13,
  908. Coefficient = 0.5,
  909. Grade = "D1级"
  910. },
  911. new
  912. {
  913. Id = 14,
  914. Coefficient = 1.1000000000000001,
  915. Grade = "A级"
  916. },
  917. new
  918. {
  919. Id = 15,
  920. Coefficient = 1.0,
  921. Grade = "C级"
  922. },
  923. new
  924. {
  925. Id = 16,
  926. Coefficient = 0.90000000000000002,
  927. Grade = "D级"
  928. });
  929. });
  930. modelBuilder.Entity("wispro.sp.entity.VerifyCoefficient", b =>
  931. {
  932. b.Property<int>("CheckerId")
  933. .HasColumnType("int");
  934. b.Property<int>("DoPersonId")
  935. .HasColumnType("int");
  936. b.Property<double>("Coefficient")
  937. .HasColumnType("float");
  938. b.HasKey("CheckerId", "DoPersonId");
  939. b.HasIndex("DoPersonId");
  940. b.ToTable("VerifyCoefficient");
  941. b.HasData(
  942. new
  943. {
  944. CheckerId = 1,
  945. DoPersonId = 5,
  946. Coefficient = 0.29999999999999999
  947. },
  948. new
  949. {
  950. CheckerId = 1,
  951. DoPersonId = 6,
  952. Coefficient = 0.29999999999999999
  953. },
  954. new
  955. {
  956. CheckerId = 1,
  957. DoPersonId = 7,
  958. Coefficient = 0.29999999999999999
  959. },
  960. new
  961. {
  962. CheckerId = 1,
  963. DoPersonId = 8,
  964. Coefficient = 0.29999999999999999
  965. },
  966. new
  967. {
  968. CheckerId = 1,
  969. DoPersonId = 9,
  970. Coefficient = 0.40000000000000002
  971. },
  972. new
  973. {
  974. CheckerId = 1,
  975. DoPersonId = 10,
  976. Coefficient = 0.40000000000000002
  977. },
  978. new
  979. {
  980. CheckerId = 1,
  981. DoPersonId = 11,
  982. Coefficient = 0.5
  983. },
  984. new
  985. {
  986. CheckerId = 1,
  987. DoPersonId = 12,
  988. Coefficient = 0.5
  989. },
  990. new
  991. {
  992. CheckerId = 1,
  993. DoPersonId = 13,
  994. Coefficient = 0.59999999999999998
  995. },
  996. new
  997. {
  998. CheckerId = 2,
  999. DoPersonId = 5,
  1000. Coefficient = 0.20000000000000001
  1001. },
  1002. new
  1003. {
  1004. CheckerId = 2,
  1005. DoPersonId = 6,
  1006. Coefficient = 0.20000000000000001
  1007. },
  1008. new
  1009. {
  1010. CheckerId = 2,
  1011. DoPersonId = 7,
  1012. Coefficient = 0.20000000000000001
  1013. },
  1014. new
  1015. {
  1016. CheckerId = 2,
  1017. DoPersonId = 8,
  1018. Coefficient = 0.20000000000000001
  1019. },
  1020. new
  1021. {
  1022. CheckerId = 2,
  1023. DoPersonId = 9,
  1024. Coefficient = 0.29999999999999999
  1025. },
  1026. new
  1027. {
  1028. CheckerId = 2,
  1029. DoPersonId = 10,
  1030. Coefficient = 0.29999999999999999
  1031. },
  1032. new
  1033. {
  1034. CheckerId = 2,
  1035. DoPersonId = 11,
  1036. Coefficient = 0.40000000000000002
  1037. },
  1038. new
  1039. {
  1040. CheckerId = 2,
  1041. DoPersonId = 12,
  1042. Coefficient = 0.40000000000000002
  1043. },
  1044. new
  1045. {
  1046. CheckerId = 2,
  1047. DoPersonId = 13,
  1048. Coefficient = 0.5
  1049. },
  1050. new
  1051. {
  1052. CheckerId = 3,
  1053. DoPersonId = 5,
  1054. Coefficient = 0.20000000000000001
  1055. },
  1056. new
  1057. {
  1058. CheckerId = 3,
  1059. DoPersonId = 6,
  1060. Coefficient = 0.20000000000000001
  1061. },
  1062. new
  1063. {
  1064. CheckerId = 3,
  1065. DoPersonId = 7,
  1066. Coefficient = 0.20000000000000001
  1067. },
  1068. new
  1069. {
  1070. CheckerId = 3,
  1071. DoPersonId = 8,
  1072. Coefficient = 0.20000000000000001
  1073. },
  1074. new
  1075. {
  1076. CheckerId = 3,
  1077. DoPersonId = 9,
  1078. Coefficient = 0.29999999999999999
  1079. },
  1080. new
  1081. {
  1082. CheckerId = 3,
  1083. DoPersonId = 10,
  1084. Coefficient = 0.29999999999999999
  1085. },
  1086. new
  1087. {
  1088. CheckerId = 3,
  1089. DoPersonId = 11,
  1090. Coefficient = 0.40000000000000002
  1091. },
  1092. new
  1093. {
  1094. CheckerId = 3,
  1095. DoPersonId = 12,
  1096. Coefficient = 0.40000000000000002
  1097. },
  1098. new
  1099. {
  1100. CheckerId = 3,
  1101. DoPersonId = 13,
  1102. Coefficient = 0.5
  1103. },
  1104. new
  1105. {
  1106. CheckerId = 4,
  1107. DoPersonId = 5,
  1108. Coefficient = 0.20000000000000001
  1109. },
  1110. new
  1111. {
  1112. CheckerId = 4,
  1113. DoPersonId = 6,
  1114. Coefficient = 0.20000000000000001
  1115. },
  1116. new
  1117. {
  1118. CheckerId = 4,
  1119. DoPersonId = 7,
  1120. Coefficient = 0.20000000000000001
  1121. },
  1122. new
  1123. {
  1124. CheckerId = 4,
  1125. DoPersonId = 8,
  1126. Coefficient = 0.20000000000000001
  1127. },
  1128. new
  1129. {
  1130. CheckerId = 4,
  1131. DoPersonId = 9,
  1132. Coefficient = 0.29999999999999999
  1133. },
  1134. new
  1135. {
  1136. CheckerId = 4,
  1137. DoPersonId = 10,
  1138. Coefficient = 0.29999999999999999
  1139. },
  1140. new
  1141. {
  1142. CheckerId = 4,
  1143. DoPersonId = 11,
  1144. Coefficient = 0.40000000000000002
  1145. },
  1146. new
  1147. {
  1148. CheckerId = 4,
  1149. DoPersonId = 12,
  1150. Coefficient = 0.40000000000000002
  1151. },
  1152. new
  1153. {
  1154. CheckerId = 4,
  1155. DoPersonId = 13,
  1156. Coefficient = 0.5
  1157. },
  1158. new
  1159. {
  1160. CheckerId = 5,
  1161. DoPersonId = 5,
  1162. Coefficient = 0.20000000000000001
  1163. },
  1164. new
  1165. {
  1166. CheckerId = 5,
  1167. DoPersonId = 6,
  1168. Coefficient = 0.20000000000000001
  1169. },
  1170. new
  1171. {
  1172. CheckerId = 5,
  1173. DoPersonId = 7,
  1174. Coefficient = 0.20000000000000001
  1175. },
  1176. new
  1177. {
  1178. CheckerId = 5,
  1179. DoPersonId = 8,
  1180. Coefficient = 0.20000000000000001
  1181. },
  1182. new
  1183. {
  1184. CheckerId = 5,
  1185. DoPersonId = 9,
  1186. Coefficient = 0.29999999999999999
  1187. },
  1188. new
  1189. {
  1190. CheckerId = 5,
  1191. DoPersonId = 10,
  1192. Coefficient = 0.29999999999999999
  1193. },
  1194. new
  1195. {
  1196. CheckerId = 5,
  1197. DoPersonId = 11,
  1198. Coefficient = 0.40000000000000002
  1199. },
  1200. new
  1201. {
  1202. CheckerId = 5,
  1203. DoPersonId = 12,
  1204. Coefficient = 0.40000000000000002
  1205. },
  1206. new
  1207. {
  1208. CheckerId = 5,
  1209. DoPersonId = 13,
  1210. Coefficient = 0.5
  1211. },
  1212. new
  1213. {
  1214. CheckerId = 6,
  1215. DoPersonId = 5,
  1216. Coefficient = 0.20000000000000001
  1217. },
  1218. new
  1219. {
  1220. CheckerId = 6,
  1221. DoPersonId = 6,
  1222. Coefficient = 0.20000000000000001
  1223. },
  1224. new
  1225. {
  1226. CheckerId = 6,
  1227. DoPersonId = 7,
  1228. Coefficient = 0.20000000000000001
  1229. },
  1230. new
  1231. {
  1232. CheckerId = 6,
  1233. DoPersonId = 8,
  1234. Coefficient = 0.20000000000000001
  1235. },
  1236. new
  1237. {
  1238. CheckerId = 6,
  1239. DoPersonId = 9,
  1240. Coefficient = 0.29999999999999999
  1241. },
  1242. new
  1243. {
  1244. CheckerId = 6,
  1245. DoPersonId = 10,
  1246. Coefficient = 0.29999999999999999
  1247. },
  1248. new
  1249. {
  1250. CheckerId = 6,
  1251. DoPersonId = 11,
  1252. Coefficient = 0.40000000000000002
  1253. },
  1254. new
  1255. {
  1256. CheckerId = 6,
  1257. DoPersonId = 12,
  1258. Coefficient = 0.40000000000000002
  1259. },
  1260. new
  1261. {
  1262. CheckerId = 6,
  1263. DoPersonId = 13,
  1264. Coefficient = 0.5
  1265. });
  1266. });
  1267. modelBuilder.Entity("wispro.sp.entity.AppealRecord", b =>
  1268. {
  1269. b.HasOne("wispro.sp.entity.Staff", "Creater")
  1270. .WithMany()
  1271. .HasForeignKey("CreaterId")
  1272. .OnDelete(DeleteBehavior.Cascade)
  1273. .IsRequired();
  1274. b.HasOne("wispro.sp.entity.PerformanceItem", "Item")
  1275. .WithMany()
  1276. .HasForeignKey("ItemId")
  1277. .OnDelete(DeleteBehavior.Cascade)
  1278. .IsRequired();
  1279. b.HasOne("wispro.sp.entity.Staff", "Reviewer")
  1280. .WithMany()
  1281. .HasForeignKey("ReviewerId")
  1282. .OnDelete(DeleteBehavior.NoAction);
  1283. b.HasOne("wispro.sp.entity.AppealType", "Type")
  1284. .WithMany()
  1285. .HasForeignKey("TypeId")
  1286. .OnDelete(DeleteBehavior.NoAction)
  1287. .IsRequired();
  1288. b.Navigation("Creater");
  1289. b.Navigation("Item");
  1290. b.Navigation("Reviewer");
  1291. b.Navigation("Type");
  1292. });
  1293. modelBuilder.Entity("wispro.sp.entity.AttachFile", b =>
  1294. {
  1295. b.HasOne("wispro.sp.entity.AppealRecord", "AppealRecord")
  1296. .WithMany("AttachFiles")
  1297. .HasForeignKey("AppealRecordId")
  1298. .HasConstraintName("FK_AttachFile_AppealRecord");
  1299. b.HasOne("wispro.sp.entity.Staff", "UploadUser")
  1300. .WithMany()
  1301. .HasForeignKey("UploadUserId")
  1302. .HasConstraintName("FK_AttachFile_UpdateUser")
  1303. .OnDelete(DeleteBehavior.NoAction)
  1304. .IsRequired();
  1305. b.Navigation("AppealRecord");
  1306. b.Navigation("UploadUser");
  1307. });
  1308. modelBuilder.Entity("wispro.sp.entity.Customer", b =>
  1309. {
  1310. b.HasOne("wispro.sp.entity.Staff", "ResponseMan")
  1311. .WithMany("Customers")
  1312. .HasForeignKey("ResponseManId")
  1313. .HasConstraintName("FK_Customer_Staff");
  1314. b.Navigation("ResponseMan");
  1315. });
  1316. modelBuilder.Entity("wispro.sp.entity.InputField", b =>
  1317. {
  1318. b.HasOne("wispro.sp.entity.AppealType", "AppealType")
  1319. .WithMany()
  1320. .HasForeignKey("AppealTypeId")
  1321. .OnDelete(DeleteBehavior.Cascade)
  1322. .IsRequired();
  1323. b.Navigation("AppealType");
  1324. });
  1325. modelBuilder.Entity("wispro.sp.entity.InputFieldValue", b =>
  1326. {
  1327. b.HasOne("wispro.sp.entity.AppealRecord", "AppealRecord")
  1328. .WithMany()
  1329. .HasForeignKey("AppealRecordId")
  1330. .OnDelete(DeleteBehavior.Cascade)
  1331. .IsRequired();
  1332. b.HasOne("wispro.sp.entity.InputField", "InputField")
  1333. .WithMany()
  1334. .HasForeignKey("InputFieldId")
  1335. .OnDelete(DeleteBehavior.Cascade)
  1336. .IsRequired();
  1337. b.Navigation("AppealRecord");
  1338. b.Navigation("InputField");
  1339. });
  1340. modelBuilder.Entity("wispro.sp.entity.ItemStaff", b =>
  1341. {
  1342. b.HasOne("wispro.sp.entity.Staff", "DoPerson")
  1343. .WithMany("ItemStaffs")
  1344. .HasForeignKey("DoPersonId")
  1345. .HasConstraintName("FK_ItemStaff_Staff")
  1346. .IsRequired();
  1347. b.HasOne("wispro.sp.entity.PerformanceItem", "Item")
  1348. .WithMany("ItemStaffs")
  1349. .HasForeignKey("ItemId")
  1350. .HasConstraintName("FK_ItemStaff_PerformanceItem")
  1351. .IsRequired();
  1352. b.Navigation("DoPerson");
  1353. b.Navigation("Item");
  1354. });
  1355. modelBuilder.Entity("wispro.sp.entity.Message", b =>
  1356. {
  1357. b.HasOne("wispro.sp.entity.Staff", "From")
  1358. .WithMany()
  1359. .HasForeignKey("FromId")
  1360. .HasConstraintName("FK_From_Staff")
  1361. .IsRequired();
  1362. b.Navigation("From");
  1363. });
  1364. modelBuilder.Entity("wispro.sp.entity.MessagePerformanceItem", b =>
  1365. {
  1366. b.HasOne("wispro.sp.entity.PerformanceItem", "Item")
  1367. .WithMany()
  1368. .HasForeignKey("ItemId")
  1369. .HasConstraintName("FK_MessagePerformanceItem_Item")
  1370. .OnDelete(DeleteBehavior.Cascade)
  1371. .IsRequired();
  1372. b.HasOne("wispro.sp.entity.Message", "Message")
  1373. .WithMany("RelatedItem")
  1374. .HasForeignKey("MessageId")
  1375. .HasConstraintName("FK_MessagePerformanceItem_Message")
  1376. .OnDelete(DeleteBehavior.Cascade)
  1377. .IsRequired();
  1378. b.Navigation("Item");
  1379. b.Navigation("Message");
  1380. });
  1381. modelBuilder.Entity("wispro.sp.entity.MessageReadRecord", b =>
  1382. {
  1383. b.HasOne("wispro.sp.entity.Message", "Message")
  1384. .WithMany()
  1385. .HasForeignKey("MessageId")
  1386. .HasConstraintName("FK_MessageReadRecord_Message")
  1387. .IsRequired();
  1388. b.HasOne("wispro.sp.entity.Message", null)
  1389. .WithMany("To")
  1390. .HasForeignKey("MessageId1");
  1391. b.HasOne("wispro.sp.entity.Staff", "Staff")
  1392. .WithMany()
  1393. .HasForeignKey("StaffId")
  1394. .HasConstraintName("FK_MessageReadRecord_Staff")
  1395. .IsRequired();
  1396. b.Navigation("Message");
  1397. b.Navigation("Staff");
  1398. });
  1399. modelBuilder.Entity("wispro.sp.entity.PerformanceItem", b =>
  1400. {
  1401. b.HasOne("wispro.sp.entity.CalMonth", "CalMonth")
  1402. .WithMany("PerformanceItems")
  1403. .HasForeignKey("CalMonthId")
  1404. .HasConstraintName("FK_PerformanceItem_CalMonth")
  1405. .OnDelete(DeleteBehavior.Cascade)
  1406. .IsRequired();
  1407. b.HasOne("wispro.sp.entity.Customer", "Customer")
  1408. .WithMany("PerformanceItems")
  1409. .HasForeignKey("CustomerId")
  1410. .HasConstraintName("FK_PerformanceItem_Customer");
  1411. b.HasOne("wispro.sp.entity.Staff", "PreOastaff")
  1412. .WithMany()
  1413. .HasForeignKey("PreOastaffId")
  1414. .HasConstraintName("FK_PerformanceItem_Staff");
  1415. b.HasOne("wispro.sp.entity.Staff", "Reviewer")
  1416. .WithMany("ReviewerItems")
  1417. .HasForeignKey("ReviewerId")
  1418. .HasConstraintName("FK_PerformanceItem_Reviewer");
  1419. b.Navigation("CalMonth");
  1420. b.Navigation("Customer");
  1421. b.Navigation("PreOastaff");
  1422. b.Navigation("Reviewer");
  1423. });
  1424. modelBuilder.Entity("wispro.sp.entity.SelectValue", b =>
  1425. {
  1426. b.HasOne("wispro.sp.entity.InputField", "InputField")
  1427. .WithMany("SelectValues")
  1428. .HasForeignKey("InputFieldId")
  1429. .OnDelete(DeleteBehavior.Cascade)
  1430. .IsRequired();
  1431. b.Navigation("InputField");
  1432. });
  1433. modelBuilder.Entity("wispro.sp.entity.Staff", b =>
  1434. {
  1435. b.HasOne("wispro.sp.entity.StaffGrade", "StaffGrade")
  1436. .WithMany("Staff")
  1437. .HasForeignKey("StaffGradeId")
  1438. .HasConstraintName("FK_Staff_StaffGrade");
  1439. b.Navigation("StaffGrade");
  1440. });
  1441. modelBuilder.Entity("wispro.sp.entity.VerifyCoefficient", b =>
  1442. {
  1443. b.HasOne("wispro.sp.entity.StaffGrade", "Checker")
  1444. .WithMany("VerifyCoefficientCheckers")
  1445. .HasForeignKey("CheckerId")
  1446. .HasConstraintName("FK_VerifyCoefficient_StaffGrade")
  1447. .IsRequired();
  1448. b.HasOne("wispro.sp.entity.StaffGrade", "DoPerson")
  1449. .WithMany("VerifyCoefficientDoPeople")
  1450. .HasForeignKey("DoPersonId")
  1451. .HasConstraintName("FK_VerifyCoefficient_StaffGrade1")
  1452. .IsRequired();
  1453. b.Navigation("Checker");
  1454. b.Navigation("DoPerson");
  1455. });
  1456. modelBuilder.Entity("wispro.sp.entity.AppealRecord", b =>
  1457. {
  1458. b.Navigation("AttachFiles");
  1459. });
  1460. modelBuilder.Entity("wispro.sp.entity.CalMonth", b =>
  1461. {
  1462. b.Navigation("PerformanceItems");
  1463. });
  1464. modelBuilder.Entity("wispro.sp.entity.Customer", b =>
  1465. {
  1466. b.Navigation("PerformanceItems");
  1467. });
  1468. modelBuilder.Entity("wispro.sp.entity.InputField", b =>
  1469. {
  1470. b.Navigation("SelectValues");
  1471. });
  1472. modelBuilder.Entity("wispro.sp.entity.Message", b =>
  1473. {
  1474. b.Navigation("RelatedItem");
  1475. b.Navigation("To");
  1476. });
  1477. modelBuilder.Entity("wispro.sp.entity.PerformanceItem", b =>
  1478. {
  1479. b.Navigation("ItemStaffs");
  1480. });
  1481. modelBuilder.Entity("wispro.sp.entity.Staff", b =>
  1482. {
  1483. b.Navigation("Customers");
  1484. b.Navigation("ItemStaffs");
  1485. b.Navigation("ReviewerItems");
  1486. });
  1487. modelBuilder.Entity("wispro.sp.entity.StaffGrade", b =>
  1488. {
  1489. b.Navigation("Staff");
  1490. b.Navigation("VerifyCoefficientCheckers");
  1491. b.Navigation("VerifyCoefficientDoPeople");
  1492. });
  1493. #pragma warning restore 612, 618
  1494. }
  1495. }
  1496. }