20211130023258_addObjectStaffStatistics.Designer.cs 132 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885288628872888288928902891289228932894289528962897289828992900290129022903290429052906290729082909291029112912291329142915291629172918291929202921292229232924292529262927292829292930293129322933293429352936293729382939294029412942294329442945294629472948294929502951295229532954295529562957295829592960296129622963296429652966296729682969297029712972297329742975297629772978297929802981298229832984298529862987298829892990299129922993299429952996299729982999300030013002300330043005300630073008300930103011301230133014301530163017301830193020302130223023302430253026302730283029303030313032303330343035303630373038303930403041304230433044304530463047304830493050305130523053305430553056305730583059306030613062306330643065306630673068306930703071307230733074307530763077307830793080308130823083308430853086308730883089309030913092309330943095309630973098309931003101310231033104310531063107310831093110311131123113311431153116311731183119312031213122312331243125312631273128312931303131313231333134313531363137313831393140314131423143314431453146314731483149315031513152315331543155315631573158315931603161316231633164316531663167316831693170317131723173317431753176317731783179318031813182318331843185318631873188318931903191319231933194319531963197319831993200320132023203320432053206320732083209321032113212321332143215321632173218321932203221322232233224322532263227322832293230323132323233323432353236323732383239324032413242324332443245324632473248324932503251325232533254325532563257325832593260326132623263326432653266326732683269327032713272327332743275327632773278327932803281328232833284328532863287328832893290329132923293329432953296329732983299330033013302330333043305330633073308330933103311331233133314331533163317331833193320332133223323332433253326332733283329333033313332
  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("20211130023258_addObjectStaffStatistics")]
  13. partial class addObjectStaffStatistics
  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. b.HasData(
  160. new
  161. {
  162. Id = 1,
  163. PointExpress = "0",
  164. Priority = 136,
  165. Rule = "p.CaseNo.StartsWith(\"J\")",
  166. Type = "其它"
  167. },
  168. new
  169. {
  170. Id = 2,
  171. PointExpress = "0",
  172. Priority = 135,
  173. Rule = "p.AgentFeedbackMemo==\"已算绩效\"",
  174. Type = "其它"
  175. },
  176. new
  177. {
  178. Id = 3,
  179. PointExpress = "p.WordCount/1000*0.18",
  180. Priority = 134,
  181. Rule = "p.DoItem==\"翻译\" && p.AgentFeedbackMemo==\"中-德\"",
  182. Type = "其它"
  183. },
  184. new
  185. {
  186. Id = 4,
  187. PointExpress = "p.WordCount/1000*0.16",
  188. Priority = 133,
  189. Rule = "p.DoItem==\"翻译\" && p.AgentFeedbackMemo==\"中-英\"",
  190. Type = "其它"
  191. },
  192. new
  193. {
  194. Id = 5,
  195. PointExpress = "p.WordCount/1000*0.1",
  196. Priority = 132,
  197. Rule = "p.DoItem==\"翻译\" && p.AgentFeedbackMemo==\"英-中\"",
  198. Type = "其它"
  199. },
  200. new
  201. {
  202. Id = 6,
  203. PointExpress = "0.2",
  204. Priority = 131,
  205. Rule = "(p.DoItem==\"提交检索主题申明\" || p.DoItem==\"提交检索主题声明\") && p.CaseNo.StartsWith(\"PAEPO\")",
  206. Type = "其它"
  207. },
  208. new
  209. {
  210. Id = 7,
  211. PointExpress = "0",
  212. Priority = 130,
  213. Rule = "p.DoItem==\"请求优先审查\"",
  214. Type = "其它"
  215. },
  216. new
  217. {
  218. Id = 8,
  219. PointExpress = "0.2",
  220. Priority = 129,
  221. Rule = "p.ApplicationType==\"外观设计\" && p.DoItem==\"新申请\"",
  222. Type = "其它"
  223. },
  224. new
  225. {
  226. Id = 9,
  227. PointExpress = "0",
  228. Priority = 128,
  229. Rule = "p.DoItem==\"专利挖掘与布局\"",
  230. Type = "其它"
  231. },
  232. new
  233. {
  234. Id = 10,
  235. PointExpress = "0",
  236. Priority = 127,
  237. Rule = "p.DoItem==\"知识点总结\"",
  238. Type = "其它"
  239. },
  240. new
  241. {
  242. Id = 11,
  243. PointExpress = "0",
  244. Priority = 126,
  245. Rule = "p.DoItem==\"询问放弃或复审\"",
  246. Type = "其它"
  247. },
  248. new
  249. {
  250. Id = 12,
  251. PointExpress = "0",
  252. Priority = 125,
  253. Rule = "p.DoItem==\"申请时提交IDS\"",
  254. Type = "其它"
  255. },
  256. new
  257. {
  258. Id = 13,
  259. PointExpress = "0.1",
  260. Priority = 124,
  261. Rule = "p.DoItem==\"提交ids\" || p.DoItem==\"提交IDS\" ",
  262. Type = "其它"
  263. },
  264. new
  265. {
  266. Id = 14,
  267. PointExpress = "0",
  268. Priority = 123,
  269. Rule = "p.DoItem==\"技术确认\"",
  270. Type = "其它"
  271. },
  272. new
  273. {
  274. Id = 15,
  275. PointExpress = "0",
  276. Priority = 122,
  277. Rule = "p.DoItem==\"绘图\"",
  278. Type = "其它"
  279. },
  280. new
  281. {
  282. Id = 16,
  283. PointExpress = "0.2",
  284. Priority = 121,
  285. Rule = "p.DoItem==\"分案评估+分案\"",
  286. Type = "其它"
  287. },
  288. new
  289. {
  290. Id = 17,
  291. PointExpress = "0.1",
  292. Priority = 120,
  293. Rule = "p.DoItem==\"分案评估\"",
  294. Type = "其它"
  295. },
  296. new
  297. {
  298. Id = 18,
  299. PointExpress = "0.2",
  300. Priority = 119,
  301. Rule = "p.DoItem==\"电询\" && p.CaseNo.StartsWith(\"PAUS\")",
  302. Type = "其它"
  303. },
  304. new
  305. {
  306. Id = 19,
  307. PointExpress = "0.2",
  308. Priority = 118,
  309. Rule = "p.DoItem==\"电询\" && p.CaseNo.StartsWith(\"PAEPO\") ",
  310. Type = "其它"
  311. },
  312. new
  313. {
  314. Id = 20,
  315. PointExpress = "0",
  316. Priority = 117,
  317. Rule = "p.DoItem==\"电询\" && p.CaseNo.StartsWith(\"PACN\")",
  318. Type = "其它"
  319. },
  320. new
  321. {
  322. Id = 21,
  323. PointExpress = "0.1",
  324. Priority = 116,
  325. Rule = "p.DoItem==\"PPH\"",
  326. Type = "其它"
  327. },
  328. new
  329. {
  330. Id = 22,
  331. PointExpress = "0.2",
  332. Priority = 115,
  333. Rule = "p.DoItem==\"OA答辩校核\"",
  334. Type = "其它"
  335. },
  336. new
  337. {
  338. Id = 23,
  339. PointExpress = "0.2",
  340. Priority = 114,
  341. Rule = "p.DoItem==\"Election Action\"",
  342. Type = "其它"
  343. },
  344. new
  345. {
  346. Id = 24,
  347. PointExpress = "0.2",
  348. Priority = 113,
  349. Rule = "p.DoItem.Contains(\"补正\") && p.CaseNo.StartsWith(\"PAUS\")",
  350. Type = "其它"
  351. },
  352. new
  353. {
  354. Id = 25,
  355. PointExpress = "0.2",
  356. Priority = 112,
  357. Rule = "p.DoItem.Contains(\"补正\") && p.CaseNo.StartsWith(\"PAIN\")",
  358. Type = "其它"
  359. },
  360. new
  361. {
  362. Id = 26,
  363. PointExpress = "0.2",
  364. Priority = 111,
  365. Rule = "p.DoItem.Contains(\"补正\") && p.CaseNo.StartsWith(\"PAGB\")",
  366. Type = "其它"
  367. },
  368. new
  369. {
  370. Id = 27,
  371. PointExpress = "0.2",
  372. Priority = 110,
  373. Rule = "p.DoItem.Contains(\"补正\") && p.CaseNo.StartsWith(\"PAEPO\")",
  374. Type = "其它"
  375. },
  376. new
  377. {
  378. Id = 28,
  379. PointExpress = "0.2",
  380. Priority = 109,
  381. Rule = "p.DoItem.Contains(\"补正\") && p.CaseNo.StartsWith(\"PADE\")",
  382. Type = "其它"
  383. },
  384. new
  385. {
  386. Id = 29,
  387. PointExpress = "0",
  388. Priority = 108,
  389. Rule = "p.DoItem.Contains(\"补正\") && p.CaseNo.StartsWith(\"WOCN\")",
  390. Type = "其它"
  391. },
  392. new
  393. {
  394. Id = 30,
  395. PointExpress = "0",
  396. Priority = 107,
  397. Rule = "p.DoItem.Contains(\"补正\") && p.CaseNo.StartsWith(\"PCTCN\")",
  398. Type = "其它"
  399. },
  400. new
  401. {
  402. Id = 31,
  403. PointExpress = "0",
  404. Priority = 106,
  405. Rule = "p.DoItem.Contains(\"补正\") && p.CaseNo.StartsWith(\"PACN\")",
  406. Type = "其它"
  407. },
  408. new
  409. {
  410. Id = 32,
  411. PointExpress = "0.2",
  412. Priority = 105,
  413. Rule = "p.DoItem.Contains(\"补正\") && p.CaseNo.StartsWith(\"PAAU\")",
  414. Type = "其它"
  415. },
  416. new
  417. {
  418. Id = 33,
  419. PointExpress = "0.2",
  420. Priority = 104,
  421. Rule = "p.AgentFeedbackMemo==\"检索结案\"",
  422. Type = "其它"
  423. },
  424. new
  425. {
  426. Id = 34,
  427. PointExpress = "0",
  428. Priority = 103,
  429. Rule = "p.DoItem==\"内部检索\"",
  430. Type = "其它"
  431. },
  432. new
  433. {
  434. Id = 35,
  435. PointExpress = "0.2",
  436. Priority = 102,
  437. Rule = "p.DoItem==\"翻译校核\" && p.DoItemCoefficient==\"形式\" && p.AgentFeedbackMemo==\"外-内\"",
  438. Type = "其它"
  439. },
  440. new
  441. {
  442. Id = 36,
  443. PointExpress = "0.3",
  444. Priority = 101,
  445. Rule = "p.DoItem==\"翻译校核\" && p.DoItemCoefficient==\"形式\" && p.AgentFeedbackMemo==\"内-外\"",
  446. Type = "其它"
  447. },
  448. new
  449. {
  450. Id = 37,
  451. PointExpress = "0.5",
  452. Priority = 100,
  453. Rule = "p.DoItem==\"翻译校核\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"外-内\"",
  454. Type = "其它"
  455. },
  456. new
  457. {
  458. Id = 38,
  459. PointExpress = "0.7",
  460. Priority = 99,
  461. Rule = "p.DoItem==\"翻译校核\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"内-外\"",
  462. Type = "其它"
  463. },
  464. new
  465. {
  466. Id = 39,
  467. PointExpress = "0.2",
  468. Priority = 98,
  469. Rule = "p.DoItem==\"发明一次OA授权\" && p.ApplicationType==\"发明\"",
  470. Type = "其它"
  471. },
  472. new
  473. {
  474. Id = 40,
  475. PointExpress = "0",
  476. Priority = 97,
  477. Rule = "p.DoItem==\"处理审查意见\" && p.AgentFeedbackMemo==\"客户不进行答辩\"",
  478. Type = "OA"
  479. },
  480. new
  481. {
  482. Id = 41,
  483. PointExpress = "0",
  484. Priority = 96,
  485. Rule = "p.DoItem==\"处理审查意见\" && p.AgentFeedbackMemo==\"电询/补正\"",
  486. Type = "OA"
  487. },
  488. new
  489. {
  490. Id = 42,
  491. PointExpress = "0",
  492. Priority = 95,
  493. Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"实用新型\" && p.AgentFeedbackMemo==\"不请款\"",
  494. Type = "OA"
  495. },
  496. new
  497. {
  498. Id = 43,
  499. PointExpress = "0",
  500. Priority = 94,
  501. Rule = "p.DoItem==\"意见陈述\" && p.ApplicationType==\"实用新型\" && p.AgentFeedbackMemo==\"不请款\"",
  502. Type = "OA"
  503. },
  504. new
  505. {
  506. Id = 44,
  507. PointExpress = "0",
  508. Priority = 93,
  509. Rule = "p.DoItem==\"请求复审\" && p.ApplicationType==\"实用新型\" && p.AgentFeedbackMemo==\"不请款\"",
  510. Type = "OA"
  511. },
  512. new
  513. {
  514. Id = 45,
  515. PointExpress = "0.14",
  516. Priority = 92,
  517. Rule = "p.DoItem==\"意见陈述\" && p.ApplicationType==\"实用新型\" && p.AgentFeedbackMemo==\"请款\"",
  518. Type = "OA"
  519. },
  520. new
  521. {
  522. Id = 46,
  523. PointExpress = "0.35",
  524. Priority = 91,
  525. Rule = "p.DoItem==\"请求复审\" && p.ApplicationType==\"实用新型\" && p.AgentFeedbackMemo==\"请款\"",
  526. Type = "OA"
  527. },
  528. new
  529. {
  530. Id = 47,
  531. PointExpress = "0.21",
  532. Priority = 90,
  533. Rule = "p.ApplicationType==\"实用新型\" && p.DoItemCoefficient==\"非实质\" && p.CaseStage==\"一通\" && p.AgentFeedbackMemo==\"请款\"",
  534. Type = "OA"
  535. },
  536. new
  537. {
  538. Id = 48,
  539. PointExpress = "0.35",
  540. Priority = 89,
  541. Rule = "p.ApplicationType==\"实用新型\" && p.DoItemCoefficient==\"实质\" && p.CaseStage==\"一通\" && p.AgentFeedbackMemo==\"请款\"",
  542. Type = "OA"
  543. },
  544. new
  545. {
  546. Id = 49,
  547. PointExpress = "0.14",
  548. Priority = 88,
  549. Rule = "p.ApplicationType==\"实用新型\" && p.DoItemCoefficient==\"形式\" && p.CaseStage==\"一通\" && p.AgentFeedbackMemo==\"请款\"",
  550. Type = "OA"
  551. },
  552. new
  553. {
  554. Id = 50,
  555. PointExpress = "0.14",
  556. Priority = 87,
  557. Rule = "p.ApplicationType==\"实用新型\" && p.DoItemCoefficient==\"实质\" && p.CaseStage==\"二通\" && p.AgentFeedbackMemo==\"请款\"",
  558. Type = "OA"
  559. },
  560. new
  561. {
  562. Id = 51,
  563. PointExpress = "0",
  564. Priority = 86,
  565. Rule = "p.ApplicationType==\"实用新型\" && p.DoItemCoefficient==\"实质\" && (p.CaseStage==\"三通\" || p.CaseStage==\"四通\" || p.CaseStage==\"五通\" || p.CaseStage==\"六通\" || p.CaseStage==\"七通\" || p.CaseStage==\"八通\") ",
  566. Type = "OA"
  567. },
  568. new
  569. {
  570. Id = 52,
  571. PointExpress = "0.2",
  572. Priority = 85,
  573. Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"形式\" && p.AgentFeedbackMemo==\"外所/他人首次转入OA\"",
  574. Type = "OA"
  575. },
  576. new
  577. {
  578. Id = 53,
  579. PointExpress = "0.5",
  580. Priority = 84,
  581. Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"外所/他人首次转入OA\"",
  582. Type = "OA"
  583. },
  584. new
  585. {
  586. Id = 54,
  587. PointExpress = "0.3",
  588. Priority = 83,
  589. Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"非实质\" && p.AgentFeedbackMemo==\"外所/他人首次转入OA\"",
  590. Type = "OA"
  591. },
  592. new
  593. {
  594. Id = 55,
  595. PointExpress = "0",
  596. Priority = 82,
  597. Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PCTCN\") && (p.CaseStage==\"三通\" || p.CaseStage==\"四通\" || p.CaseStage==\"五通\")",
  598. Type = "OA"
  599. },
  600. new
  601. {
  602. Id = 56,
  603. PointExpress = "0",
  604. Priority = 81,
  605. Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && (p.CaseStage==\"三通\" || p.CaseStage==\"四通\" || p.CaseStage==\"五通\")",
  606. Type = "OA"
  607. },
  608. new
  609. {
  610. Id = 57,
  611. PointExpress = "0.2",
  612. Priority = 80,
  613. Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PCTCN\") && p.CaseStage==\"二通\"",
  614. Type = "OA"
  615. },
  616. new
  617. {
  618. Id = 58,
  619. PointExpress = "0.2",
  620. Priority = 79,
  621. Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"二通\"",
  622. Type = "OA"
  623. },
  624. new
  625. {
  626. Id = 59,
  627. PointExpress = "0.2",
  628. Priority = 78,
  629. Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PCTCN\") && p.CaseStage==\"一通\"",
  630. Type = "OA"
  631. },
  632. new
  633. {
  634. Id = 60,
  635. PointExpress = "0.5",
  636. Priority = 77,
  637. Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PCTCN\") && p.CaseStage==\"一通\"",
  638. Type = "OA"
  639. },
  640. new
  641. {
  642. Id = 61,
  643. PointExpress = "0.3",
  644. Priority = 76,
  645. Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"非实质\" && p.CaseNo.StartsWith(\"PCTCN\") && p.CaseStage==\"一通\"",
  646. Type = "OA"
  647. },
  648. new
  649. {
  650. Id = 62,
  651. PointExpress = "0.2",
  652. Priority = 75,
  653. Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"一通\"",
  654. Type = "OA"
  655. },
  656. new
  657. {
  658. Id = 63,
  659. PointExpress = "0.5",
  660. Priority = 74,
  661. Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"一通\"",
  662. Type = "OA"
  663. },
  664. new
  665. {
  666. Id = 64,
  667. PointExpress = "0.3",
  668. Priority = 73,
  669. Rule = "p.DoItem==\"处理审查意见\" && p.ApplicationType==\"发明\" && p.DoItemCoefficient==\"非实质\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"一通\"",
  670. Type = "OA"
  671. },
  672. new
  673. {
  674. Id = 65,
  675. PointExpress = "0.2",
  676. Priority = 72,
  677. Rule = "p.DoItem==\"意见陈述\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseStage==\"复审\"",
  678. Type = "OA"
  679. },
  680. new
  681. {
  682. Id = 66,
  683. PointExpress = "0.5",
  684. Priority = 71,
  685. Rule = "p.DoItem==\"请求复审\" && p.ApplicationType==\"发明\"",
  686. Type = "OA"
  687. },
  688. new
  689. {
  690. Id = 67,
  691. PointExpress = "0.1",
  692. Priority = 70,
  693. Rule = "p.AgentFeedbackMemo==\"涉外OA不答辩,发报导函结案\"",
  694. Type = "其它"
  695. },
  696. new
  697. {
  698. Id = 68,
  699. PointExpress = "0.8",
  700. Priority = 69,
  701. Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"客户未提供答辩点,撰写英文报导函\"",
  702. Type = "OA"
  703. },
  704. new
  705. {
  706. Id = 69,
  707. PointExpress = "0.5",
  708. Priority = 68,
  709. Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.AgentFeedbackMemo==\"客户提供答辩点,撰写英文报导函\"",
  710. Type = "OA"
  711. },
  712. new
  713. {
  714. Id = 70,
  715. PointExpress = "0.2",
  716. Priority = 67,
  717. Rule = "p.DoItem==\"申復\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PATW\")",
  718. Type = "OA"
  719. },
  720. new
  721. {
  722. Id = 71,
  723. PointExpress = "0.5",
  724. Priority = 66,
  725. Rule = "p.DoItem==\"申復\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PATW\")",
  726. Type = "OA"
  727. },
  728. new
  729. {
  730. Id = 72,
  731. PointExpress = "0.2",
  732. Priority = 65,
  733. Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAIN\")",
  734. Type = "OA"
  735. },
  736. new
  737. {
  738. Id = 73,
  739. PointExpress = "0.2",
  740. Priority = 64,
  741. Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAGB\")",
  742. Type = "OA"
  743. },
  744. new
  745. {
  746. Id = 74,
  747. PointExpress = "0.2",
  748. Priority = 63,
  749. Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAEPO\")",
  750. Type = "OA"
  751. },
  752. new
  753. {
  754. Id = 75,
  755. PointExpress = "0.3",
  756. Priority = 62,
  757. Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PADE\")",
  758. Type = "OA"
  759. },
  760. new
  761. {
  762. Id = 76,
  763. PointExpress = "0.2",
  764. Priority = 61,
  765. Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAAU\")",
  766. Type = "OA"
  767. },
  768. new
  769. {
  770. Id = 77,
  771. PointExpress = "1.5",
  772. Priority = 60,
  773. Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAIN\")",
  774. Type = "OA"
  775. },
  776. new
  777. {
  778. Id = 78,
  779. PointExpress = "1.5",
  780. Priority = 59,
  781. Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAGB\")",
  782. Type = "OA"
  783. },
  784. new
  785. {
  786. Id = 79,
  787. PointExpress = "1.5",
  788. Priority = 58,
  789. Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAEPO\")",
  790. Type = "OA"
  791. },
  792. new
  793. {
  794. Id = 80,
  795. PointExpress = "1.6",
  796. Priority = 57,
  797. Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PADE\")",
  798. Type = "OA"
  799. },
  800. new
  801. {
  802. Id = 81,
  803. PointExpress = "1.5",
  804. Priority = 56,
  805. Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAAU\")",
  806. Type = "OA"
  807. },
  808. new
  809. {
  810. Id = 82,
  811. PointExpress = "0.2",
  812. Priority = 55,
  813. Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"形式\" && p.CaseNo.StartsWith(\"PAUS\")",
  814. Type = "OA"
  815. },
  816. new
  817. {
  818. Id = 83,
  819. PointExpress = "1.5",
  820. Priority = 54,
  821. Rule = "p.DoItem==\"处理审查意见\" && p.DoItemCoefficient==\"实质\" && p.CaseNo.StartsWith(\"PAUS\")",
  822. Type = "OA"
  823. },
  824. new
  825. {
  826. Id = 84,
  827. PointExpress = "1.5",
  828. Priority = 53,
  829. Rule = "p.DoItem==\"口审评估\" && p.DoItemCoefficient==\"实质\"",
  830. Type = "OA"
  831. },
  832. new
  833. {
  834. Id = 85,
  835. PointExpress = "0.2",
  836. Priority = 52,
  837. Rule = "p.DoItem==\"口审评估\" && p.DoItemCoefficient==\"形式\"",
  838. Type = "OA"
  839. },
  840. new
  841. {
  842. Id = 86,
  843. PointExpress = "0.2",
  844. Priority = 51,
  845. Rule = "p.DoItem==\"欧洲案答辩\" && p.DoItemCoefficient==\"形式\"",
  846. Type = "OA"
  847. },
  848. new
  849. {
  850. Id = 87,
  851. PointExpress = "1.5",
  852. Priority = 50,
  853. Rule = "p.DoItem==\"欧洲案答辩\" && p.DoItemCoefficient==\"实质\"",
  854. Type = "OA"
  855. },
  856. new
  857. {
  858. Id = 88,
  859. PointExpress = "0.2",
  860. Priority = 49,
  861. Rule = "p.DoItem==\"RCE\" && p.DoItemCoefficient==\"形式\"",
  862. Type = "OA"
  863. },
  864. new
  865. {
  866. Id = 89,
  867. PointExpress = "1.5",
  868. Priority = 48,
  869. Rule = "p.DoItem==\"RCE\" && p.DoItemCoefficient==\"实质\"",
  870. Type = "OA"
  871. },
  872. new
  873. {
  874. Id = 90,
  875. PointExpress = "0.2",
  876. Priority = 47,
  877. Rule = "p.DoItem==\"Non Final Action\" && p.DoItemCoefficient==\"形式\"",
  878. Type = "OA"
  879. },
  880. new
  881. {
  882. Id = 91,
  883. PointExpress = "1.5",
  884. Priority = 46,
  885. Rule = "p.DoItem==\"Non Final Action\" && p.DoItemCoefficient==\"实质\"",
  886. Type = "OA"
  887. },
  888. new
  889. {
  890. Id = 92,
  891. PointExpress = "0.1",
  892. Priority = 45,
  893. Rule = "p.DoItem==\"form 3-8(2)\" || p.DoItem==\"Form 3-8(2)\" || p.DoItem==\"Form 3-8(2)\"",
  894. Type = "OA"
  895. },
  896. new
  897. {
  898. Id = 93,
  899. PointExpress = "0.1",
  900. Priority = 44,
  901. Rule = "p.DoItem==\"form 3\"",
  902. Type = "OA"
  903. },
  904. new
  905. {
  906. Id = 94,
  907. PointExpress = "0.2",
  908. Priority = 43,
  909. Rule = "p.DoItem==\"Final Action\" && p.DoItemCoefficient==\"形式\"",
  910. Type = "OA"
  911. },
  912. new
  913. {
  914. Id = 95,
  915. PointExpress = "1.5",
  916. Priority = 42,
  917. Rule = "p.DoItem==\"Final Action\" && p.DoItemCoefficient==\"实质\"",
  918. Type = "OA"
  919. },
  920. new
  921. {
  922. Id = 96,
  923. PointExpress = "0.2",
  924. Priority = 41,
  925. Rule = "p.DoItem==\"Advisory Action\" && p.DoItemCoefficient==\"形式\"",
  926. Type = "OA"
  927. },
  928. new
  929. {
  930. Id = 97,
  931. PointExpress = "1.5",
  932. Priority = 40,
  933. Rule = "p.DoItem==\"Advisory Action\" && p.DoItemCoefficient==\"实质\"",
  934. Type = "OA"
  935. },
  936. new
  937. {
  938. Id = 98,
  939. PointExpress = "p.WordCount/1000*0.18",
  940. Priority = 39,
  941. Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"中-德\" && p.WordCount !=null",
  942. Type = "其它"
  943. },
  944. new
  945. {
  946. Id = 99,
  947. PointExpress = "p.WordCount/1000*0.16",
  948. Priority = 38,
  949. Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"中-英\" && p.WordCount !=null",
  950. Type = "其它"
  951. },
  952. new
  953. {
  954. Id = 100,
  955. PointExpress = "p.WordCount/1000*0.1",
  956. Priority = 37,
  957. Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"英-中\" && p.WordCount !=null",
  958. Type = "其它"
  959. },
  960. new
  961. {
  962. Id = 101,
  963. PointExpress = "0",
  964. Priority = 36,
  965. Rule = "(p.ApplicationType==\"实用新型\" || p.ApplicationType==\"发明\") && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"客户不进行答辩\"",
  966. Type = "其它"
  967. },
  968. new
  969. {
  970. Id = 102,
  971. PointExpress = "1.26",
  972. Priority = 35,
  973. Rule = "p.CaseNo.StartsWith(\"PAUS\") && p.AgentFeedbackMemo==\"发文后客户原因取消申请,系统结案\"",
  974. Type = "新申请"
  975. },
  976. new
  977. {
  978. Id = 103,
  979. PointExpress = "1.33",
  980. Priority = 34,
  981. Rule = "p.CaseNo.StartsWith(\"PADE\") && p.AgentFeedbackMemo==\"发文后客户原因取消申请,系统结案\"",
  982. Type = "新申请"
  983. },
  984. new
  985. {
  986. Id = 104,
  987. PointExpress = "0.7",
  988. Priority = 33,
  989. Rule = "p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"发文后客户取消申请\"",
  990. Type = "新申请"
  991. },
  992. new
  993. {
  994. Id = 105,
  995. PointExpress = "0.49",
  996. Priority = 32,
  997. Rule = "p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"发文后客户取消申请\"",
  998. Type = "新申请"
  999. },
  1000. new
  1001. {
  1002. Id = 106,
  1003. PointExpress = "0",
  1004. Priority = 31,
  1005. Rule = "p.AgentFeedbackMemo==\"撰写中客户取消申请\"",
  1006. Type = "其它"
  1007. },
  1008. new
  1009. {
  1010. Id = 107,
  1011. PointExpress = "1.5",
  1012. Priority = 30,
  1013. Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PCTCN\") && p.AgentFeedbackMemo==\"外到内首次申请\"",
  1014. Type = "新申请"
  1015. },
  1016. new
  1017. {
  1018. Id = 108,
  1019. PointExpress = "0.1",
  1020. Priority = 29,
  1021. Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"转格式\"",
  1022. Type = "其它"
  1023. },
  1024. new
  1025. {
  1026. Id = 109,
  1027. PointExpress = "1.5",
  1028. Priority = 28,
  1029. Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"外-内首次申请\"",
  1030. Type = "新申请"
  1031. },
  1032. new
  1033. {
  1034. Id = 110,
  1035. PointExpress = "1",
  1036. Priority = 27,
  1037. Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"首次中文案\"",
  1038. Type = "新申请"
  1039. },
  1040. new
  1041. {
  1042. Id = 111,
  1043. PointExpress = "0.7",
  1044. Priority = 26,
  1045. Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"涉外实质改权\"",
  1046. Type = "新申请"
  1047. },
  1048. new
  1049. {
  1050. Id = 112,
  1051. PointExpress = "0.5",
  1052. Priority = 25,
  1053. Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"改权+改说明书\"",
  1054. Type = "其它"
  1055. },
  1056. new
  1057. {
  1058. Id = 113,
  1059. PointExpress = "0.3",
  1060. Priority = 24,
  1061. Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"改权\"",
  1062. Type = "其它"
  1063. },
  1064. new
  1065. {
  1066. Id = 114,
  1067. PointExpress = "1.8",
  1068. Priority = 23,
  1069. Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"PCT首次英文案\"",
  1070. Type = "新申请"
  1071. },
  1072. new
  1073. {
  1074. Id = 115,
  1075. PointExpress = "0.2",
  1076. Priority = 22,
  1077. Rule = "p.AgentFeedbackMemo==\"我方转格式、复核\"",
  1078. Type = "其它"
  1079. },
  1080. new
  1081. {
  1082. Id = 116,
  1083. PointExpress = "0",
  1084. Priority = 21,
  1085. Rule = "p.AgentFeedbackMemo==\"我方代交\"",
  1086. Type = "其它"
  1087. },
  1088. new
  1089. {
  1090. Id = 117,
  1091. PointExpress = "0.5",
  1092. Priority = 20,
  1093. Rule = "p.CaseNo.StartsWith(\"PAUS\") && (p.CaseNo.EndsWith(\"-同套\") || p.CaseNo.EndsWith(\"CA\") || p.CaseNo.EndsWith(\"CIP\") || p.CaseNo.EndsWith(\"分案\")) ",
  1094. Type = "其它"
  1095. },
  1096. new
  1097. {
  1098. Id = 118,
  1099. PointExpress = "0.2",
  1100. Priority = 19,
  1101. Rule = "(p.CaseNo.StartsWith(\"PAMY \") || p.CaseNo.StartsWith(\"PADE\") || p.CaseNo.StartsWith(\"PAGB\") || p.CaseNo.StartsWith(\"PAIN\") || p.CaseNo.StartsWith(\"PAUS\") || p.CaseNo.StartsWith(\"PAEPO\") ) && p.AgentFeedbackMemo==\"同套\"",
  1102. Type = "其它"
  1103. },
  1104. new
  1105. {
  1106. Id = 119,
  1107. PointExpress = "0.3",
  1108. Priority = 18,
  1109. Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseNo.EndsWith(\"-分案\")",
  1110. Type = "其它"
  1111. },
  1112. new
  1113. {
  1114. Id = 120,
  1115. PointExpress = "1.8",
  1116. Priority = 17,
  1117. Rule = "p.DoItem==\"新申请\" && p.AgentFeedbackMemo==\"欧洲案首次\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PAEPO\")",
  1118. Type = "新申请"
  1119. },
  1120. new
  1121. {
  1122. Id = 121,
  1123. PointExpress = "0.2",
  1124. Priority = 16,
  1125. Rule = "p.DoItem==\"新申请\" && p.CaseNo.StartsWith(\"PATW\") && p.AgentFeedbackMemo==\"大陆案转台湾案\"",
  1126. Type = "其它"
  1127. },
  1128. new
  1129. {
  1130. Id = 122,
  1131. PointExpress = "1",
  1132. Priority = 15,
  1133. Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"同套大陆+台湾\"",
  1134. Type = "新申请"
  1135. },
  1136. new
  1137. {
  1138. Id = 123,
  1139. PointExpress = "0.2",
  1140. Priority = 14,
  1141. Rule = "p.DoItem==\"新申请\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"台湾案转大陆案\"",
  1142. Type = "其它"
  1143. },
  1144. new
  1145. {
  1146. Id = 124,
  1147. PointExpress = "0.1",
  1148. Priority = 13,
  1149. Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PATW\") && p.AgentFeedbackMemo==\"同套大陆+台湾\"",
  1150. Type = "其它"
  1151. },
  1152. new
  1153. {
  1154. Id = 125,
  1155. PointExpress = "0.7",
  1156. Priority = 12,
  1157. Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PACN\") && p.AgentFeedbackMemo==\"同套大陆+台湾\"",
  1158. Type = "新申请"
  1159. },
  1160. new
  1161. {
  1162. Id = 126,
  1163. PointExpress = "0.1",
  1164. Priority = 11,
  1165. Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PATW\") && p.AgentFeedbackMemo==\"同套大陆+台湾\"",
  1166. Type = "其它"
  1167. },
  1168. new
  1169. {
  1170. Id = 127,
  1171. PointExpress = "1.7",
  1172. Priority = 10,
  1173. Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PAUS\") && (p.Customer!=null && p.Customer.Name.Contains(\"OPPO\"))",
  1174. Type = "新申请"
  1175. },
  1176. new
  1177. {
  1178. Id = 128,
  1179. PointExpress = "1.8",
  1180. Priority = 9,
  1181. Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PAUS\")",
  1182. Type = "新申请"
  1183. },
  1184. new
  1185. {
  1186. Id = 129,
  1187. PointExpress = "1.8",
  1188. Priority = 8,
  1189. Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PAGB\")",
  1190. Type = "新申请"
  1191. },
  1192. new
  1193. {
  1194. Id = 130,
  1195. PointExpress = "0.2",
  1196. Priority = 7,
  1197. Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PAEPO\")",
  1198. Type = "其它"
  1199. },
  1200. new
  1201. {
  1202. Id = 131,
  1203. PointExpress = "1.9",
  1204. Priority = 6,
  1205. Rule = "p.DoItem==\"新申请\" && p.CaseNo.StartsWith(\"PADE\")",
  1206. Type = "新申请"
  1207. },
  1208. new
  1209. {
  1210. Id = 132,
  1211. PointExpress = "0.1",
  1212. Priority = 5,
  1213. Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseNo.EndsWith(\"-TS\")",
  1214. Type = "其它"
  1215. },
  1216. new
  1217. {
  1218. Id = 133,
  1219. PointExpress = "1",
  1220. Priority = 4,
  1221. Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PACN\") && (p.Customer!=null && p.Customer.Name.Contains(\"OPPO\"))",
  1222. Type = "新申请"
  1223. },
  1224. new
  1225. {
  1226. Id = 134,
  1227. PointExpress = "0.7",
  1228. Priority = 3,
  1229. Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"实用新型\" && p.CaseNo.StartsWith(\"PACN\")",
  1230. Type = "新申请"
  1231. },
  1232. new
  1233. {
  1234. Id = 135,
  1235. PointExpress = "1",
  1236. Priority = 2,
  1237. Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\") && p.CaseNo.EndsWith(\"-TS\")",
  1238. Type = "新申请"
  1239. },
  1240. new
  1241. {
  1242. Id = 136,
  1243. PointExpress = "1",
  1244. Priority = 1,
  1245. Rule = "p.DoItem==\"新申请\" && p.ApplicationType==\"发明\" && p.CaseNo.StartsWith(\"PACN\")",
  1246. Type = "新申请"
  1247. },
  1248. new
  1249. {
  1250. Id = 137,
  1251. PointExpress = "0",
  1252. Priority = 250,
  1253. Rule = "p.CaseNo.StartsWith(\"S\")",
  1254. Type = "专案"
  1255. });
  1256. });
  1257. modelBuilder.Entity("wispro.sp.entity.CalMonth", b =>
  1258. {
  1259. b.Property<int>("Id")
  1260. .ValueGeneratedOnAdd()
  1261. .HasColumnType("int")
  1262. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  1263. b.Property<int>("Month")
  1264. .HasColumnType("int")
  1265. .HasColumnName("month");
  1266. b.Property<int>("Status")
  1267. .HasColumnType("int")
  1268. .HasColumnName("status");
  1269. b.Property<int>("Year")
  1270. .HasColumnType("int")
  1271. .HasColumnName("year");
  1272. b.HasKey("Id");
  1273. b.ToTable("CalMonth");
  1274. });
  1275. modelBuilder.Entity("wispro.sp.entity.CaseCeoffcient", b =>
  1276. {
  1277. b.Property<string>("Ceoffcient")
  1278. .HasColumnType("nvarchar(450)");
  1279. b.Property<double>("Value")
  1280. .HasColumnType("float");
  1281. b.HasKey("Ceoffcient");
  1282. b.ToTable("CaseCeofficient");
  1283. b.HasData(
  1284. new
  1285. {
  1286. Ceoffcient = "S",
  1287. Value = 2.5
  1288. },
  1289. new
  1290. {
  1291. Ceoffcient = "A",
  1292. Value = 1.5
  1293. },
  1294. new
  1295. {
  1296. Ceoffcient = "B",
  1297. Value = 1.0
  1298. },
  1299. new
  1300. {
  1301. Ceoffcient = "C",
  1302. Value = 0.69999999999999996
  1303. },
  1304. new
  1305. {
  1306. Ceoffcient = "D",
  1307. Value = 0.40000000000000002
  1308. });
  1309. });
  1310. modelBuilder.Entity("wispro.sp.entity.Customer", b =>
  1311. {
  1312. b.Property<int>("Id")
  1313. .ValueGeneratedOnAdd()
  1314. .HasColumnType("int")
  1315. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  1316. b.Property<string>("Address")
  1317. .HasMaxLength(500)
  1318. .HasColumnType("nvarchar(500)");
  1319. b.Property<string>("ContactMan")
  1320. .HasMaxLength(50)
  1321. .HasColumnType("nvarchar(50)");
  1322. b.Property<string>("Name")
  1323. .IsRequired()
  1324. .HasMaxLength(200)
  1325. .HasColumnType("nvarchar(200)");
  1326. b.Property<string>("Phone")
  1327. .HasMaxLength(50)
  1328. .HasColumnType("nvarchar(50)");
  1329. b.Property<int?>("ResponseManId")
  1330. .HasColumnType("int");
  1331. b.HasKey("Id");
  1332. b.HasIndex("ResponseManId");
  1333. b.ToTable("Customer");
  1334. });
  1335. modelBuilder.Entity("wispro.sp.entity.Department", b =>
  1336. {
  1337. b.Property<int>("Id")
  1338. .ValueGeneratedOnAdd()
  1339. .HasColumnType("int")
  1340. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  1341. b.Property<string>("Memo")
  1342. .HasColumnType("nvarchar(max)");
  1343. b.Property<string>("Name")
  1344. .HasColumnType("nvarchar(max)");
  1345. b.Property<string>("ancestors")
  1346. .HasColumnType("nvarchar(max)");
  1347. b.Property<int?>("order_num")
  1348. .HasColumnType("int");
  1349. b.Property<int?>("parentId")
  1350. .HasColumnType("int");
  1351. b.HasKey("Id");
  1352. b.ToTable("Department");
  1353. });
  1354. modelBuilder.Entity("wispro.sp.entity.DepartmentPosition", b =>
  1355. {
  1356. b.Property<int>("Id")
  1357. .ValueGeneratedOnAdd()
  1358. .HasColumnType("int")
  1359. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  1360. b.Property<int>("PositionId")
  1361. .HasColumnType("int");
  1362. b.Property<int>("StaffId")
  1363. .HasColumnType("int");
  1364. b.Property<int>("departmentId")
  1365. .HasColumnType("int");
  1366. b.HasKey("Id");
  1367. b.HasIndex("PositionId");
  1368. b.HasIndex("StaffId");
  1369. b.HasIndex("departmentId");
  1370. b.ToTable("DepartmentPosition");
  1371. });
  1372. modelBuilder.Entity("wispro.sp.entity.InputField", b =>
  1373. {
  1374. b.Property<int>("Id")
  1375. .ValueGeneratedOnAdd()
  1376. .HasColumnType("int")
  1377. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  1378. b.Property<int>("AppealState")
  1379. .HasColumnType("int");
  1380. b.Property<int>("AppealTypeId")
  1381. .HasColumnType("int");
  1382. b.Property<bool>("CanMuliSelect")
  1383. .HasColumnType("bit");
  1384. b.Property<string>("FieldName")
  1385. .HasMaxLength(50)
  1386. .HasColumnType("nvarchar(50)");
  1387. b.Property<string>("FieldType")
  1388. .HasMaxLength(50)
  1389. .HasColumnType("nvarchar(50)");
  1390. b.Property<string>("MapObjectField")
  1391. .HasMaxLength(50)
  1392. .HasColumnType("nvarchar(50)");
  1393. b.Property<string>("MapObjectFieldLabel")
  1394. .HasColumnType("nvarchar(max)");
  1395. b.Property<string>("MapSaveCondition")
  1396. .HasColumnType("nvarchar(max)");
  1397. b.Property<int?>("MaxSize")
  1398. .HasColumnType("int");
  1399. b.HasKey("Id");
  1400. b.HasIndex("AppealTypeId");
  1401. b.ToTable("InputField");
  1402. b.HasData(
  1403. new
  1404. {
  1405. Id = 1,
  1406. AppealState = 0,
  1407. AppealTypeId = 1,
  1408. CanMuliSelect = false,
  1409. FieldName = "分配比率",
  1410. FieldType = "System.Double",
  1411. MapObjectField = "ItemStaffs.PerformancePoint",
  1412. MapObjectFieldLabel = "ItemStaffs.DoPerson.Name"
  1413. },
  1414. new
  1415. {
  1416. Id = 3,
  1417. AppealState = 0,
  1418. AppealTypeId = 1,
  1419. CanMuliSelect = false,
  1420. FieldName = "原因",
  1421. FieldType = "System.String"
  1422. },
  1423. new
  1424. {
  1425. Id = 4,
  1426. AppealState = 1,
  1427. AppealTypeId = 1,
  1428. CanMuliSelect = false,
  1429. FieldName = "备注",
  1430. FieldType = "System.String"
  1431. },
  1432. new
  1433. {
  1434. Id = 5,
  1435. AppealState = 1,
  1436. AppealTypeId = 1,
  1437. CanMuliSelect = false,
  1438. FieldName = "审核意见",
  1439. FieldType = "System.String"
  1440. },
  1441. new
  1442. {
  1443. Id = 6,
  1444. AppealState = 0,
  1445. AppealTypeId = 2,
  1446. CanMuliSelect = false,
  1447. FieldName = "案件系数",
  1448. FieldType = "System.String",
  1449. MapObjectField = "CaseCoefficient"
  1450. },
  1451. new
  1452. {
  1453. Id = 9,
  1454. AppealState = 1,
  1455. AppealTypeId = 2,
  1456. CanMuliSelect = false,
  1457. FieldName = "备注",
  1458. FieldType = "System.String"
  1459. },
  1460. new
  1461. {
  1462. Id = 10,
  1463. AppealState = 1,
  1464. AppealTypeId = 2,
  1465. CanMuliSelect = false,
  1466. FieldName = "审核意见",
  1467. FieldType = "System.String"
  1468. },
  1469. new
  1470. {
  1471. Id = 11,
  1472. AppealState = 0,
  1473. AppealTypeId = 3,
  1474. CanMuliSelect = false,
  1475. FieldName = "处理事项系数",
  1476. FieldType = "System.String",
  1477. MapObjectField = "DoItemCoefficient"
  1478. },
  1479. new
  1480. {
  1481. Id = 12,
  1482. AppealState = 1,
  1483. AppealTypeId = 3,
  1484. CanMuliSelect = false,
  1485. FieldName = "备注",
  1486. FieldType = "System.String"
  1487. },
  1488. new
  1489. {
  1490. Id = 13,
  1491. AppealState = 1,
  1492. AppealTypeId = 3,
  1493. CanMuliSelect = false,
  1494. FieldName = "审核意见",
  1495. FieldType = "System.String"
  1496. },
  1497. new
  1498. {
  1499. Id = 14,
  1500. AppealState = 0,
  1501. AppealTypeId = 4,
  1502. CanMuliSelect = false,
  1503. FieldName = "我方文号",
  1504. FieldType = "System.String"
  1505. },
  1506. new
  1507. {
  1508. Id = 15,
  1509. AppealState = 0,
  1510. AppealTypeId = 4,
  1511. CanMuliSelect = false,
  1512. FieldName = "处理事项",
  1513. FieldType = "System.String"
  1514. },
  1515. new
  1516. {
  1517. Id = 16,
  1518. AppealState = 1,
  1519. AppealTypeId = 4,
  1520. CanMuliSelect = false,
  1521. FieldName = "备注",
  1522. FieldType = "System.String"
  1523. },
  1524. new
  1525. {
  1526. Id = 17,
  1527. AppealState = 1,
  1528. AppealTypeId = 4,
  1529. CanMuliSelect = false,
  1530. FieldName = "审核意见",
  1531. FieldType = "System.String"
  1532. },
  1533. new
  1534. {
  1535. Id = 18,
  1536. AppealState = 0,
  1537. AppealTypeId = 5,
  1538. CanMuliSelect = false,
  1539. FieldName = "超期说明",
  1540. FieldType = "System.String",
  1541. MapObjectField = "OverDueMemo"
  1542. },
  1543. new
  1544. {
  1545. Id = 21,
  1546. AppealState = 1,
  1547. AppealTypeId = 5,
  1548. CanMuliSelect = false,
  1549. FieldName = "审核意见",
  1550. FieldType = "System.String"
  1551. },
  1552. new
  1553. {
  1554. Id = 22,
  1555. AppealState = 1,
  1556. AppealTypeId = 5,
  1557. CanMuliSelect = false,
  1558. FieldName = "备注",
  1559. FieldType = "System.String"
  1560. },
  1561. new
  1562. {
  1563. Id = 19,
  1564. AppealState = 0,
  1565. AppealTypeId = 6,
  1566. CanMuliSelect = false,
  1567. FieldName = "翻译类型",
  1568. FieldType = "System.String",
  1569. MapObjectField = "AgentFeedbackMemo"
  1570. },
  1571. new
  1572. {
  1573. Id = 20,
  1574. AppealState = 0,
  1575. AppealTypeId = 6,
  1576. CanMuliSelect = false,
  1577. FieldName = "翻译字数",
  1578. FieldType = "System.Int32",
  1579. MapObjectField = "WordCount"
  1580. },
  1581. new
  1582. {
  1583. Id = 23,
  1584. AppealState = 1,
  1585. AppealTypeId = 6,
  1586. CanMuliSelect = false,
  1587. FieldName = "审核意见",
  1588. FieldType = "System.Int32"
  1589. },
  1590. new
  1591. {
  1592. Id = 24,
  1593. AppealState = 1,
  1594. AppealTypeId = 6,
  1595. CanMuliSelect = false,
  1596. FieldName = "翻译字数",
  1597. FieldType = "System.Int32",
  1598. MapObjectField = "WordCount"
  1599. });
  1600. });
  1601. modelBuilder.Entity("wispro.sp.entity.InputFieldValue", b =>
  1602. {
  1603. b.Property<int>("Id")
  1604. .ValueGeneratedOnAdd()
  1605. .HasColumnType("int")
  1606. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  1607. b.Property<int>("AppealRecordId")
  1608. .HasColumnType("int");
  1609. b.Property<int>("InputFieldId")
  1610. .HasColumnType("int");
  1611. b.Property<string>("Label")
  1612. .HasColumnType("nvarchar(max)");
  1613. b.Property<string>("Value")
  1614. .HasMaxLength(500)
  1615. .HasColumnType("nvarchar(500)");
  1616. b.Property<string>("mapExpress")
  1617. .HasColumnType("nvarchar(max)");
  1618. b.HasKey("Id");
  1619. b.HasIndex("AppealRecordId");
  1620. b.HasIndex("InputFieldId");
  1621. b.ToTable("InputFieldValue");
  1622. });
  1623. modelBuilder.Entity("wispro.sp.entity.ItemStaff", b =>
  1624. {
  1625. b.Property<int>("ItemId")
  1626. .HasColumnType("int");
  1627. b.Property<int>("DoPersonId")
  1628. .HasColumnType("int");
  1629. b.Property<double?>("PerformancePoint")
  1630. .HasColumnType("float");
  1631. b.HasKey("ItemId", "DoPersonId");
  1632. b.HasIndex("DoPersonId");
  1633. b.ToTable("ItemStaff");
  1634. });
  1635. modelBuilder.Entity("wispro.sp.entity.Message", b =>
  1636. {
  1637. b.Property<Guid>("Id")
  1638. .ValueGeneratedOnAdd()
  1639. .HasColumnType("uniqueidentifier");
  1640. b.Property<int>("FromId")
  1641. .HasColumnType("int");
  1642. b.Property<string>("MessageInfo")
  1643. .HasMaxLength(500)
  1644. .HasColumnType("nvarchar(500)");
  1645. b.Property<int>("Type")
  1646. .HasColumnType("int");
  1647. b.HasKey("Id");
  1648. b.HasIndex("FromId");
  1649. b.ToTable("Message");
  1650. });
  1651. modelBuilder.Entity("wispro.sp.entity.MessagePerformanceItem", b =>
  1652. {
  1653. b.Property<int>("ItemId")
  1654. .HasColumnType("int");
  1655. b.Property<Guid>("MessageId")
  1656. .HasColumnType("uniqueidentifier");
  1657. b.HasKey("ItemId", "MessageId");
  1658. b.HasIndex("MessageId");
  1659. b.ToTable("MessagePerformanceItems");
  1660. });
  1661. modelBuilder.Entity("wispro.sp.entity.MessageReadRecord", b =>
  1662. {
  1663. b.Property<Guid>("MessageId")
  1664. .HasColumnType("uniqueidentifier");
  1665. b.Property<int>("StaffId")
  1666. .HasColumnType("int");
  1667. b.Property<Guid?>("MessageId1")
  1668. .HasColumnType("uniqueidentifier");
  1669. b.Property<bool>("isReaded")
  1670. .HasColumnType("bit");
  1671. b.HasKey("MessageId", "StaffId");
  1672. b.HasIndex("MessageId1");
  1673. b.HasIndex("StaffId");
  1674. b.ToTable("MessageReadRecord");
  1675. });
  1676. modelBuilder.Entity("wispro.sp.entity.PerformanceItem", b =>
  1677. {
  1678. b.Property<int>("Id")
  1679. .ValueGeneratedOnAdd()
  1680. .HasColumnType("int")
  1681. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  1682. b.Property<string>("AgentFeedbackMemo")
  1683. .HasColumnType("nvarchar(max)");
  1684. b.Property<string>("ApplicationName")
  1685. .HasMaxLength(200)
  1686. .HasColumnType("nvarchar(200)");
  1687. b.Property<string>("ApplicationType")
  1688. .HasMaxLength(50)
  1689. .HasColumnType("nvarchar(50)");
  1690. b.Property<decimal?>("BasePoint")
  1691. .HasColumnType("numeric(18,2)");
  1692. b.Property<string>("BusinessType")
  1693. .HasMaxLength(50)
  1694. .HasColumnType("nvarchar(50)");
  1695. b.Property<int>("CalMonthId")
  1696. .HasColumnType("int");
  1697. b.Property<string>("CaseCoefficient")
  1698. .HasMaxLength(10)
  1699. .HasColumnType("nvarchar(10)");
  1700. b.Property<string>("CaseMemo")
  1701. .HasColumnType("nvarchar(max)");
  1702. b.Property<string>("CaseName")
  1703. .HasMaxLength(500)
  1704. .HasColumnType("nvarchar(500)");
  1705. b.Property<string>("CaseNo")
  1706. .HasMaxLength(50)
  1707. .HasColumnType("nvarchar(50)");
  1708. b.Property<string>("CaseStage")
  1709. .HasMaxLength(50)
  1710. .HasColumnType("nvarchar(50)");
  1711. b.Property<string>("CaseState")
  1712. .HasMaxLength(50)
  1713. .HasColumnType("nvarchar(50)");
  1714. b.Property<string>("CaseType")
  1715. .HasMaxLength(50)
  1716. .HasColumnType("nvarchar(50)");
  1717. b.Property<int?>("CustomerId")
  1718. .HasColumnType("int");
  1719. b.Property<DateTime?>("CustomerLimitDate")
  1720. .HasColumnType("date");
  1721. b.Property<string>("DoItem")
  1722. .HasMaxLength(50)
  1723. .HasColumnType("nvarchar(50)");
  1724. b.Property<string>("DoItemCoefficient")
  1725. .HasMaxLength(50)
  1726. .HasColumnType("nvarchar(50)");
  1727. b.Property<string>("DoItemMemo")
  1728. .HasMaxLength(500)
  1729. .HasColumnType("nvarchar(500)");
  1730. b.Property<string>("DoItemState")
  1731. .HasMaxLength(50)
  1732. .HasColumnType("nvarchar(50)");
  1733. b.Property<DateTime?>("EntrustingDate")
  1734. .HasColumnType("date");
  1735. b.Property<DateTime?>("FinalizationDate")
  1736. .HasColumnType("date");
  1737. b.Property<DateTime?>("FinishedDate")
  1738. .HasColumnType("date");
  1739. b.Property<DateTime?>("FirstDraftDate")
  1740. .HasColumnType("date");
  1741. b.Property<DateTime?>("InternalDate")
  1742. .HasColumnType("date");
  1743. b.Property<string>("OverDueMemo")
  1744. .HasMaxLength(100)
  1745. .HasColumnType("nvarchar(100)");
  1746. b.Property<int?>("PreOastaffId")
  1747. .HasColumnType("int")
  1748. .HasColumnName("PreOAStaffId");
  1749. b.Property<string>("ReturnCasseNo")
  1750. .HasColumnType("nvarchar(max)");
  1751. b.Property<DateTime?>("ReturnDate")
  1752. .HasColumnType("date");
  1753. b.Property<int?>("ReviewerId")
  1754. .HasColumnType("int");
  1755. b.Property<int?>("Status")
  1756. .HasColumnType("int");
  1757. b.Property<string>("Type")
  1758. .HasColumnType("nvarchar(max)");
  1759. b.Property<int?>("WordCount")
  1760. .HasColumnType("int");
  1761. b.HasKey("Id");
  1762. b.HasIndex("CalMonthId");
  1763. b.HasIndex("CustomerId");
  1764. b.HasIndex("PreOastaffId");
  1765. b.HasIndex("ReviewerId");
  1766. b.ToTable("PerformanceItem");
  1767. });
  1768. modelBuilder.Entity("wispro.sp.entity.Position", b =>
  1769. {
  1770. b.Property<int>("Id")
  1771. .ValueGeneratedOnAdd()
  1772. .HasColumnType("int")
  1773. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  1774. b.Property<string>("Memo")
  1775. .HasColumnType("nvarchar(max)");
  1776. b.Property<string>("Name")
  1777. .HasColumnType("nvarchar(max)");
  1778. b.HasKey("Id");
  1779. b.ToTable("Position");
  1780. });
  1781. modelBuilder.Entity("wispro.sp.entity.SelectValue", b =>
  1782. {
  1783. b.Property<int>("Id")
  1784. .ValueGeneratedOnAdd()
  1785. .HasColumnType("int")
  1786. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  1787. b.Property<int>("InputFieldId")
  1788. .HasColumnType("int");
  1789. b.Property<string>("Value")
  1790. .HasColumnType("nvarchar(max)");
  1791. b.HasKey("Id");
  1792. b.HasIndex("InputFieldId");
  1793. b.ToTable("SelectValue");
  1794. b.HasData(
  1795. new
  1796. {
  1797. Id = 1,
  1798. InputFieldId = 5,
  1799. Value = "同意"
  1800. },
  1801. new
  1802. {
  1803. Id = 2,
  1804. InputFieldId = 5,
  1805. Value = "拒绝"
  1806. },
  1807. new
  1808. {
  1809. Id = 3,
  1810. InputFieldId = 10,
  1811. Value = "同意"
  1812. },
  1813. new
  1814. {
  1815. Id = 4,
  1816. InputFieldId = 10,
  1817. Value = "拒绝"
  1818. },
  1819. new
  1820. {
  1821. Id = 5,
  1822. InputFieldId = 13,
  1823. Value = "同意"
  1824. },
  1825. new
  1826. {
  1827. Id = 6,
  1828. InputFieldId = 13,
  1829. Value = "拒绝"
  1830. },
  1831. new
  1832. {
  1833. Id = 7,
  1834. InputFieldId = 17,
  1835. Value = "同意"
  1836. },
  1837. new
  1838. {
  1839. Id = 8,
  1840. InputFieldId = 17,
  1841. Value = "拒绝"
  1842. },
  1843. new
  1844. {
  1845. Id = 9,
  1846. InputFieldId = 6,
  1847. Value = "S"
  1848. },
  1849. new
  1850. {
  1851. Id = 10,
  1852. InputFieldId = 6,
  1853. Value = "A"
  1854. },
  1855. new
  1856. {
  1857. Id = 11,
  1858. InputFieldId = 6,
  1859. Value = "B"
  1860. },
  1861. new
  1862. {
  1863. Id = 12,
  1864. InputFieldId = 6,
  1865. Value = "C"
  1866. },
  1867. new
  1868. {
  1869. Id = 13,
  1870. InputFieldId = 6,
  1871. Value = "D"
  1872. },
  1873. new
  1874. {
  1875. Id = 14,
  1876. InputFieldId = 11,
  1877. Value = "实质"
  1878. },
  1879. new
  1880. {
  1881. Id = 15,
  1882. InputFieldId = 11,
  1883. Value = "形式"
  1884. },
  1885. new
  1886. {
  1887. Id = 16,
  1888. InputFieldId = 19,
  1889. Value = "中-德"
  1890. },
  1891. new
  1892. {
  1893. Id = 17,
  1894. InputFieldId = 19,
  1895. Value = "中-英"
  1896. },
  1897. new
  1898. {
  1899. Id = 18,
  1900. InputFieldId = 19,
  1901. Value = "英-中"
  1902. },
  1903. new
  1904. {
  1905. Id = 19,
  1906. InputFieldId = 22,
  1907. Value = "同意"
  1908. },
  1909. new
  1910. {
  1911. Id = 20,
  1912. InputFieldId = 22,
  1913. Value = "拒绝"
  1914. });
  1915. });
  1916. modelBuilder.Entity("wispro.sp.entity.Staff", b =>
  1917. {
  1918. b.Property<int>("Id")
  1919. .ValueGeneratedOnAdd()
  1920. .HasColumnType("int")
  1921. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  1922. b.Property<string>("Account")
  1923. .IsRequired()
  1924. .HasMaxLength(50)
  1925. .HasColumnType("nvarchar(50)");
  1926. b.Property<string>("Department")
  1927. .HasMaxLength(50)
  1928. .HasColumnType("nvarchar(50)");
  1929. b.Property<DateTime?>("EntyDate")
  1930. .HasColumnType("date");
  1931. b.Property<bool>("IsCalPerformsnce")
  1932. .HasColumnType("bit")
  1933. .HasColumnName("isCalPerformsnce");
  1934. b.Property<bool>("IsOnJob")
  1935. .HasColumnType("bit");
  1936. b.Property<string>("Mail")
  1937. .HasColumnType("nvarchar(max)");
  1938. b.Property<string>("Memo")
  1939. .HasColumnType("nvarchar(max)");
  1940. b.Property<string>("Mobile")
  1941. .HasColumnType("nvarchar(max)");
  1942. b.Property<string>("Name")
  1943. .IsRequired()
  1944. .HasMaxLength(50)
  1945. .HasColumnType("nvarchar(50)");
  1946. b.Property<string>("Password")
  1947. .IsRequired()
  1948. .HasColumnType("nvarchar(max)");
  1949. b.Property<string>("Sex")
  1950. .HasColumnType("nvarchar(max)");
  1951. b.Property<int?>("StaffGradeId")
  1952. .HasColumnType("int");
  1953. b.Property<string>("Status")
  1954. .IsRequired()
  1955. .HasMaxLength(25)
  1956. .HasColumnType("nvarchar(25)");
  1957. b.Property<string>("Tel")
  1958. .HasColumnType("nvarchar(max)");
  1959. b.Property<string>("WorkPlace")
  1960. .HasMaxLength(50)
  1961. .HasColumnType("nvarchar(50)");
  1962. b.HasKey("Id");
  1963. b.HasIndex("StaffGradeId");
  1964. b.ToTable("Staff");
  1965. });
  1966. modelBuilder.Entity("wispro.sp.entity.StaffGrade", b =>
  1967. {
  1968. b.Property<int>("Id")
  1969. .ValueGeneratedOnAdd()
  1970. .HasColumnType("int")
  1971. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  1972. b.Property<double>("Coefficient")
  1973. .HasColumnType("float");
  1974. b.Property<string>("Grade")
  1975. .IsRequired()
  1976. .HasMaxLength(5)
  1977. .HasColumnType("nchar(5)")
  1978. .IsFixedLength(true);
  1979. b.HasKey("Id");
  1980. b.ToTable("StaffGrade");
  1981. b.HasData(
  1982. new
  1983. {
  1984. Id = 1,
  1985. Coefficient = 1.2,
  1986. Grade = "S级"
  1987. },
  1988. new
  1989. {
  1990. Id = 2,
  1991. Coefficient = 1.1000000000000001,
  1992. Grade = "A3级"
  1993. },
  1994. new
  1995. {
  1996. Id = 3,
  1997. Coefficient = 1.1000000000000001,
  1998. Grade = "A2级"
  1999. },
  2000. new
  2001. {
  2002. Id = 4,
  2003. Coefficient = 1.1000000000000001,
  2004. Grade = "A1级"
  2005. },
  2006. new
  2007. {
  2008. Id = 5,
  2009. Coefficient = 1.0,
  2010. Grade = "B3级"
  2011. },
  2012. new
  2013. {
  2014. Id = 6,
  2015. Coefficient = 1.0,
  2016. Grade = "B2级"
  2017. },
  2018. new
  2019. {
  2020. Id = 7,
  2021. Coefficient = 0.90000000000000002,
  2022. Grade = "B1级"
  2023. },
  2024. new
  2025. {
  2026. Id = 8,
  2027. Coefficient = 0.90000000000000002,
  2028. Grade = "C3级"
  2029. },
  2030. new
  2031. {
  2032. Id = 9,
  2033. Coefficient = 0.69999999999999996,
  2034. Grade = "C2级"
  2035. },
  2036. new
  2037. {
  2038. Id = 10,
  2039. Coefficient = 0.69999999999999996,
  2040. Grade = "C1级"
  2041. },
  2042. new
  2043. {
  2044. Id = 11,
  2045. Coefficient = 0.59999999999999998,
  2046. Grade = "D3级"
  2047. },
  2048. new
  2049. {
  2050. Id = 12,
  2051. Coefficient = 0.59999999999999998,
  2052. Grade = "D2级"
  2053. },
  2054. new
  2055. {
  2056. Id = 13,
  2057. Coefficient = 0.5,
  2058. Grade = "D1级"
  2059. },
  2060. new
  2061. {
  2062. Id = 14,
  2063. Coefficient = 1.1000000000000001,
  2064. Grade = "A级"
  2065. },
  2066. new
  2067. {
  2068. Id = 15,
  2069. Coefficient = 1.0,
  2070. Grade = "C级"
  2071. },
  2072. new
  2073. {
  2074. Id = 16,
  2075. Coefficient = 0.90000000000000002,
  2076. Grade = "D级"
  2077. });
  2078. });
  2079. modelBuilder.Entity("wispro.sp.entity.StaffStatistics", b =>
  2080. {
  2081. b.Property<int>("Id")
  2082. .ValueGeneratedOnAdd()
  2083. .HasColumnType("int")
  2084. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  2085. b.Property<int>("CalMonthId")
  2086. .HasColumnType("int");
  2087. b.Property<int>("StaffId")
  2088. .HasColumnType("int");
  2089. b.Property<string>("jxType")
  2090. .HasColumnType("nvarchar(max)");
  2091. b.Property<double?>("totalActuallyPoint")
  2092. .HasColumnType("float");
  2093. b.Property<double?>("totalBasePoint")
  2094. .HasColumnType("float");
  2095. b.HasKey("Id");
  2096. b.HasIndex("CalMonthId");
  2097. b.HasIndex("StaffId");
  2098. b.ToTable("StaffStatistics");
  2099. });
  2100. modelBuilder.Entity("wispro.sp.entity.VerifyCoefficient", b =>
  2101. {
  2102. b.Property<int>("CheckerId")
  2103. .HasColumnType("int");
  2104. b.Property<int>("DoPersonId")
  2105. .HasColumnType("int");
  2106. b.Property<double>("Coefficient")
  2107. .HasColumnType("float");
  2108. b.HasKey("CheckerId", "DoPersonId");
  2109. b.HasIndex("DoPersonId");
  2110. b.ToTable("VerifyCoefficient");
  2111. b.HasData(
  2112. new
  2113. {
  2114. CheckerId = 1,
  2115. DoPersonId = 5,
  2116. Coefficient = 0.29999999999999999
  2117. },
  2118. new
  2119. {
  2120. CheckerId = 1,
  2121. DoPersonId = 6,
  2122. Coefficient = 0.29999999999999999
  2123. },
  2124. new
  2125. {
  2126. CheckerId = 1,
  2127. DoPersonId = 7,
  2128. Coefficient = 0.29999999999999999
  2129. },
  2130. new
  2131. {
  2132. CheckerId = 1,
  2133. DoPersonId = 8,
  2134. Coefficient = 0.29999999999999999
  2135. },
  2136. new
  2137. {
  2138. CheckerId = 1,
  2139. DoPersonId = 9,
  2140. Coefficient = 0.40000000000000002
  2141. },
  2142. new
  2143. {
  2144. CheckerId = 1,
  2145. DoPersonId = 10,
  2146. Coefficient = 0.40000000000000002
  2147. },
  2148. new
  2149. {
  2150. CheckerId = 1,
  2151. DoPersonId = 11,
  2152. Coefficient = 0.5
  2153. },
  2154. new
  2155. {
  2156. CheckerId = 1,
  2157. DoPersonId = 12,
  2158. Coefficient = 0.5
  2159. },
  2160. new
  2161. {
  2162. CheckerId = 1,
  2163. DoPersonId = 13,
  2164. Coefficient = 0.59999999999999998
  2165. },
  2166. new
  2167. {
  2168. CheckerId = 2,
  2169. DoPersonId = 5,
  2170. Coefficient = 0.20000000000000001
  2171. },
  2172. new
  2173. {
  2174. CheckerId = 2,
  2175. DoPersonId = 6,
  2176. Coefficient = 0.20000000000000001
  2177. },
  2178. new
  2179. {
  2180. CheckerId = 2,
  2181. DoPersonId = 7,
  2182. Coefficient = 0.20000000000000001
  2183. },
  2184. new
  2185. {
  2186. CheckerId = 2,
  2187. DoPersonId = 8,
  2188. Coefficient = 0.20000000000000001
  2189. },
  2190. new
  2191. {
  2192. CheckerId = 2,
  2193. DoPersonId = 9,
  2194. Coefficient = 0.29999999999999999
  2195. },
  2196. new
  2197. {
  2198. CheckerId = 2,
  2199. DoPersonId = 10,
  2200. Coefficient = 0.29999999999999999
  2201. },
  2202. new
  2203. {
  2204. CheckerId = 2,
  2205. DoPersonId = 11,
  2206. Coefficient = 0.40000000000000002
  2207. },
  2208. new
  2209. {
  2210. CheckerId = 2,
  2211. DoPersonId = 12,
  2212. Coefficient = 0.40000000000000002
  2213. },
  2214. new
  2215. {
  2216. CheckerId = 2,
  2217. DoPersonId = 13,
  2218. Coefficient = 0.5
  2219. },
  2220. new
  2221. {
  2222. CheckerId = 3,
  2223. DoPersonId = 5,
  2224. Coefficient = 0.20000000000000001
  2225. },
  2226. new
  2227. {
  2228. CheckerId = 3,
  2229. DoPersonId = 6,
  2230. Coefficient = 0.20000000000000001
  2231. },
  2232. new
  2233. {
  2234. CheckerId = 3,
  2235. DoPersonId = 7,
  2236. Coefficient = 0.20000000000000001
  2237. },
  2238. new
  2239. {
  2240. CheckerId = 3,
  2241. DoPersonId = 8,
  2242. Coefficient = 0.20000000000000001
  2243. },
  2244. new
  2245. {
  2246. CheckerId = 3,
  2247. DoPersonId = 9,
  2248. Coefficient = 0.29999999999999999
  2249. },
  2250. new
  2251. {
  2252. CheckerId = 3,
  2253. DoPersonId = 10,
  2254. Coefficient = 0.29999999999999999
  2255. },
  2256. new
  2257. {
  2258. CheckerId = 3,
  2259. DoPersonId = 11,
  2260. Coefficient = 0.40000000000000002
  2261. },
  2262. new
  2263. {
  2264. CheckerId = 3,
  2265. DoPersonId = 12,
  2266. Coefficient = 0.40000000000000002
  2267. },
  2268. new
  2269. {
  2270. CheckerId = 3,
  2271. DoPersonId = 13,
  2272. Coefficient = 0.5
  2273. },
  2274. new
  2275. {
  2276. CheckerId = 4,
  2277. DoPersonId = 5,
  2278. Coefficient = 0.20000000000000001
  2279. },
  2280. new
  2281. {
  2282. CheckerId = 4,
  2283. DoPersonId = 6,
  2284. Coefficient = 0.20000000000000001
  2285. },
  2286. new
  2287. {
  2288. CheckerId = 4,
  2289. DoPersonId = 7,
  2290. Coefficient = 0.20000000000000001
  2291. },
  2292. new
  2293. {
  2294. CheckerId = 4,
  2295. DoPersonId = 8,
  2296. Coefficient = 0.20000000000000001
  2297. },
  2298. new
  2299. {
  2300. CheckerId = 4,
  2301. DoPersonId = 9,
  2302. Coefficient = 0.29999999999999999
  2303. },
  2304. new
  2305. {
  2306. CheckerId = 4,
  2307. DoPersonId = 10,
  2308. Coefficient = 0.29999999999999999
  2309. },
  2310. new
  2311. {
  2312. CheckerId = 4,
  2313. DoPersonId = 11,
  2314. Coefficient = 0.40000000000000002
  2315. },
  2316. new
  2317. {
  2318. CheckerId = 4,
  2319. DoPersonId = 12,
  2320. Coefficient = 0.40000000000000002
  2321. },
  2322. new
  2323. {
  2324. CheckerId = 4,
  2325. DoPersonId = 13,
  2326. Coefficient = 0.5
  2327. },
  2328. new
  2329. {
  2330. CheckerId = 5,
  2331. DoPersonId = 5,
  2332. Coefficient = 0.20000000000000001
  2333. },
  2334. new
  2335. {
  2336. CheckerId = 5,
  2337. DoPersonId = 6,
  2338. Coefficient = 0.20000000000000001
  2339. },
  2340. new
  2341. {
  2342. CheckerId = 5,
  2343. DoPersonId = 7,
  2344. Coefficient = 0.20000000000000001
  2345. },
  2346. new
  2347. {
  2348. CheckerId = 5,
  2349. DoPersonId = 8,
  2350. Coefficient = 0.20000000000000001
  2351. },
  2352. new
  2353. {
  2354. CheckerId = 5,
  2355. DoPersonId = 9,
  2356. Coefficient = 0.29999999999999999
  2357. },
  2358. new
  2359. {
  2360. CheckerId = 5,
  2361. DoPersonId = 10,
  2362. Coefficient = 0.29999999999999999
  2363. },
  2364. new
  2365. {
  2366. CheckerId = 5,
  2367. DoPersonId = 11,
  2368. Coefficient = 0.40000000000000002
  2369. },
  2370. new
  2371. {
  2372. CheckerId = 5,
  2373. DoPersonId = 12,
  2374. Coefficient = 0.40000000000000002
  2375. },
  2376. new
  2377. {
  2378. CheckerId = 5,
  2379. DoPersonId = 13,
  2380. Coefficient = 0.5
  2381. },
  2382. new
  2383. {
  2384. CheckerId = 6,
  2385. DoPersonId = 5,
  2386. Coefficient = 0.20000000000000001
  2387. },
  2388. new
  2389. {
  2390. CheckerId = 6,
  2391. DoPersonId = 6,
  2392. Coefficient = 0.20000000000000001
  2393. },
  2394. new
  2395. {
  2396. CheckerId = 6,
  2397. DoPersonId = 7,
  2398. Coefficient = 0.20000000000000001
  2399. },
  2400. new
  2401. {
  2402. CheckerId = 6,
  2403. DoPersonId = 8,
  2404. Coefficient = 0.20000000000000001
  2405. },
  2406. new
  2407. {
  2408. CheckerId = 6,
  2409. DoPersonId = 9,
  2410. Coefficient = 0.29999999999999999
  2411. },
  2412. new
  2413. {
  2414. CheckerId = 6,
  2415. DoPersonId = 10,
  2416. Coefficient = 0.29999999999999999
  2417. },
  2418. new
  2419. {
  2420. CheckerId = 6,
  2421. DoPersonId = 11,
  2422. Coefficient = 0.40000000000000002
  2423. },
  2424. new
  2425. {
  2426. CheckerId = 6,
  2427. DoPersonId = 12,
  2428. Coefficient = 0.40000000000000002
  2429. },
  2430. new
  2431. {
  2432. CheckerId = 6,
  2433. DoPersonId = 13,
  2434. Coefficient = 0.5
  2435. });
  2436. });
  2437. modelBuilder.Entity("wispro.sp.entity.workflowDefine.Action", b =>
  2438. {
  2439. b.Property<int>("Id")
  2440. .ValueGeneratedOnAdd()
  2441. .HasColumnType("int")
  2442. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  2443. b.Property<string>("InputForm")
  2444. .HasColumnType("nvarchar(max)");
  2445. b.Property<string>("Name")
  2446. .HasColumnType("nvarchar(max)");
  2447. b.Property<string>("OnActionObjectType")
  2448. .HasColumnType("nvarchar(max)");
  2449. b.Property<int>("StepId")
  2450. .HasColumnType("int");
  2451. b.HasKey("Id");
  2452. b.HasIndex("StepId");
  2453. b.ToTable("Action");
  2454. });
  2455. modelBuilder.Entity("wispro.sp.entity.workflowDefine.InputValueSetting", b =>
  2456. {
  2457. b.Property<int>("Id")
  2458. .ValueGeneratedOnAdd()
  2459. .HasColumnType("int")
  2460. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  2461. b.Property<string>("DisplayName")
  2462. .HasColumnType("nvarchar(max)");
  2463. b.Property<string>("Options")
  2464. .HasColumnType("nvarchar(max)");
  2465. b.Property<int?>("ParentSettingId")
  2466. .HasColumnType("int");
  2467. b.Property<int>("actionId")
  2468. .HasColumnType("int");
  2469. b.Property<string>("bindField")
  2470. .HasColumnType("nvarchar(max)");
  2471. b.Property<string>("bindFieldSavetoObjectCondition")
  2472. .HasColumnType("nvarchar(max)");
  2473. b.Property<int>("valueType")
  2474. .HasColumnType("int");
  2475. b.HasKey("Id");
  2476. b.HasIndex("ParentSettingId");
  2477. b.HasIndex("actionId");
  2478. b.ToTable("InputValueSetting");
  2479. });
  2480. modelBuilder.Entity("wispro.sp.entity.workflowDefine.Step", b =>
  2481. {
  2482. b.Property<int>("Id")
  2483. .ValueGeneratedOnAdd()
  2484. .HasColumnType("int")
  2485. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  2486. b.Property<string>("Name")
  2487. .HasColumnType("nvarchar(max)");
  2488. b.Property<string>("defaultResponseSetting")
  2489. .HasColumnType("nvarchar(max)");
  2490. b.Property<int>("stepType")
  2491. .HasColumnType("int");
  2492. b.Property<int>("workflowId")
  2493. .HasColumnType("int");
  2494. b.HasKey("Id");
  2495. b.HasIndex("workflowId");
  2496. b.ToTable("Step");
  2497. });
  2498. modelBuilder.Entity("wispro.sp.entity.workflowDefine.TrasferCondition", b =>
  2499. {
  2500. b.Property<int>("Id")
  2501. .ValueGeneratedOnAdd()
  2502. .HasColumnType("int")
  2503. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  2504. b.Property<string>("Condition")
  2505. .HasColumnType("nvarchar(max)");
  2506. b.Property<int>("StepId")
  2507. .HasColumnType("int");
  2508. b.Property<int>("nextStepId")
  2509. .HasColumnType("int");
  2510. b.HasKey("Id");
  2511. b.HasIndex("StepId");
  2512. b.HasIndex("nextStepId");
  2513. b.ToTable("TrasferCondition");
  2514. });
  2515. modelBuilder.Entity("wispro.sp.entity.workflowDefine.Workflow", b =>
  2516. {
  2517. b.Property<int>("Id")
  2518. .ValueGeneratedOnAdd()
  2519. .HasColumnType("int")
  2520. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  2521. b.Property<string>("ContentObjectType")
  2522. .HasColumnType("nvarchar(max)");
  2523. b.Property<int>("EndStepId")
  2524. .HasColumnType("int");
  2525. b.Property<int>("InitActionId")
  2526. .HasColumnType("int");
  2527. b.Property<string>("Name")
  2528. .HasColumnType("nvarchar(max)");
  2529. b.HasKey("Id");
  2530. b.HasIndex("InitActionId");
  2531. b.ToTable("Workflow");
  2532. });
  2533. modelBuilder.Entity("wispro.sp.entity.workflowInstance.InputValue", b =>
  2534. {
  2535. b.Property<int>("Id")
  2536. .ValueGeneratedOnAdd()
  2537. .HasColumnType("int")
  2538. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  2539. b.Property<string>("value")
  2540. .HasColumnType("nvarchar(max)");
  2541. b.Property<int>("valueSettingId")
  2542. .HasColumnType("int");
  2543. b.Property<int>("workflowInstanceId")
  2544. .HasColumnType("int");
  2545. b.HasKey("Id");
  2546. b.HasIndex("valueSettingId");
  2547. b.HasIndex("workflowInstanceId");
  2548. b.ToTable("InputValue");
  2549. });
  2550. modelBuilder.Entity("wispro.sp.entity.workflowInstance.StepInstance", b =>
  2551. {
  2552. b.Property<int>("Id")
  2553. .ValueGeneratedOnAdd()
  2554. .HasColumnType("int")
  2555. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  2556. b.Property<int?>("PreviousStepId")
  2557. .HasColumnType("int");
  2558. b.Property<int>("stepId")
  2559. .HasColumnType("int");
  2560. b.Property<int>("workflowInstanceId")
  2561. .HasColumnType("int");
  2562. b.HasKey("Id");
  2563. b.HasIndex("stepId");
  2564. b.HasIndex("workflowInstanceId");
  2565. b.ToTable("StepInstance");
  2566. });
  2567. modelBuilder.Entity("wispro.sp.entity.workflowInstance.WorkflowInstance", b =>
  2568. {
  2569. b.Property<int>("Id")
  2570. .ValueGeneratedOnAdd()
  2571. .HasColumnType("int")
  2572. .HasAnnotation("SqlServer:ValueGenerationStrategy", SqlServerValueGenerationStrategy.IdentityColumn);
  2573. b.Property<int>("ObjectId")
  2574. .HasColumnType("int");
  2575. b.Property<int>("workflowId")
  2576. .HasColumnType("int");
  2577. b.HasKey("Id");
  2578. b.HasIndex("workflowId");
  2579. b.ToTable("WorkflowInstance");
  2580. });
  2581. modelBuilder.Entity("wispro.sp.entity.AppealRecord", b =>
  2582. {
  2583. b.HasOne("wispro.sp.entity.Staff", "Creater")
  2584. .WithMany()
  2585. .HasForeignKey("CreaterId")
  2586. .OnDelete(DeleteBehavior.Cascade)
  2587. .IsRequired();
  2588. b.HasOne("wispro.sp.entity.PerformanceItem", "Item")
  2589. .WithMany()
  2590. .HasForeignKey("ItemId")
  2591. .OnDelete(DeleteBehavior.Cascade)
  2592. .IsRequired();
  2593. b.HasOne("wispro.sp.entity.Staff", "Reviewer")
  2594. .WithMany()
  2595. .HasForeignKey("ReviewerId")
  2596. .OnDelete(DeleteBehavior.NoAction);
  2597. b.HasOne("wispro.sp.entity.AppealType", "Type")
  2598. .WithMany()
  2599. .HasForeignKey("TypeId")
  2600. .OnDelete(DeleteBehavior.NoAction)
  2601. .IsRequired();
  2602. b.Navigation("Creater");
  2603. b.Navigation("Item");
  2604. b.Navigation("Reviewer");
  2605. b.Navigation("Type");
  2606. });
  2607. modelBuilder.Entity("wispro.sp.entity.AttachFile", b =>
  2608. {
  2609. b.HasOne("wispro.sp.entity.AppealRecord", "AppealRecord")
  2610. .WithMany("AttachFiles")
  2611. .HasForeignKey("AppealRecordId")
  2612. .HasConstraintName("FK_AttachFile_AppealRecord");
  2613. b.HasOne("wispro.sp.entity.Staff", "UploadUser")
  2614. .WithMany()
  2615. .HasForeignKey("UploadUserId")
  2616. .HasConstraintName("FK_AttachFile_UpdateUser")
  2617. .OnDelete(DeleteBehavior.NoAction);
  2618. b.Navigation("AppealRecord");
  2619. b.Navigation("UploadUser");
  2620. });
  2621. modelBuilder.Entity("wispro.sp.entity.Customer", b =>
  2622. {
  2623. b.HasOne("wispro.sp.entity.Staff", "ResponseMan")
  2624. .WithMany("Customers")
  2625. .HasForeignKey("ResponseManId")
  2626. .HasConstraintName("FK_Customer_Staff");
  2627. b.Navigation("ResponseMan");
  2628. });
  2629. modelBuilder.Entity("wispro.sp.entity.DepartmentPosition", b =>
  2630. {
  2631. b.HasOne("wispro.sp.entity.Position", "Position")
  2632. .WithMany()
  2633. .HasForeignKey("PositionId")
  2634. .OnDelete(DeleteBehavior.Cascade)
  2635. .IsRequired();
  2636. b.HasOne("wispro.sp.entity.Staff", "Staff")
  2637. .WithMany("Positions")
  2638. .HasForeignKey("StaffId")
  2639. .OnDelete(DeleteBehavior.Cascade)
  2640. .IsRequired();
  2641. b.HasOne("wispro.sp.entity.Department", "department")
  2642. .WithMany()
  2643. .HasForeignKey("departmentId")
  2644. .OnDelete(DeleteBehavior.Cascade)
  2645. .IsRequired();
  2646. b.Navigation("department");
  2647. b.Navigation("Position");
  2648. b.Navigation("Staff");
  2649. });
  2650. modelBuilder.Entity("wispro.sp.entity.InputField", b =>
  2651. {
  2652. b.HasOne("wispro.sp.entity.AppealType", "AppealType")
  2653. .WithMany()
  2654. .HasForeignKey("AppealTypeId")
  2655. .OnDelete(DeleteBehavior.Cascade)
  2656. .IsRequired();
  2657. b.Navigation("AppealType");
  2658. });
  2659. modelBuilder.Entity("wispro.sp.entity.InputFieldValue", b =>
  2660. {
  2661. b.HasOne("wispro.sp.entity.AppealRecord", "AppealRecord")
  2662. .WithMany()
  2663. .HasForeignKey("AppealRecordId")
  2664. .OnDelete(DeleteBehavior.Cascade)
  2665. .IsRequired();
  2666. b.HasOne("wispro.sp.entity.InputField", "InputField")
  2667. .WithMany()
  2668. .HasForeignKey("InputFieldId")
  2669. .OnDelete(DeleteBehavior.Cascade)
  2670. .IsRequired();
  2671. b.Navigation("AppealRecord");
  2672. b.Navigation("InputField");
  2673. });
  2674. modelBuilder.Entity("wispro.sp.entity.ItemStaff", b =>
  2675. {
  2676. b.HasOne("wispro.sp.entity.Staff", "DoPerson")
  2677. .WithMany("ItemStaffs")
  2678. .HasForeignKey("DoPersonId")
  2679. .HasConstraintName("FK_ItemStaff_Staff")
  2680. .IsRequired();
  2681. b.HasOne("wispro.sp.entity.PerformanceItem", "Item")
  2682. .WithMany("ItemStaffs")
  2683. .HasForeignKey("ItemId")
  2684. .HasConstraintName("FK_ItemStaff_PerformanceItem")
  2685. .IsRequired();
  2686. b.Navigation("DoPerson");
  2687. b.Navigation("Item");
  2688. });
  2689. modelBuilder.Entity("wispro.sp.entity.Message", b =>
  2690. {
  2691. b.HasOne("wispro.sp.entity.Staff", "From")
  2692. .WithMany()
  2693. .HasForeignKey("FromId")
  2694. .HasConstraintName("FK_From_Staff")
  2695. .IsRequired();
  2696. b.Navigation("From");
  2697. });
  2698. modelBuilder.Entity("wispro.sp.entity.MessagePerformanceItem", b =>
  2699. {
  2700. b.HasOne("wispro.sp.entity.PerformanceItem", "Item")
  2701. .WithMany()
  2702. .HasForeignKey("ItemId")
  2703. .HasConstraintName("FK_MessagePerformanceItem_Item")
  2704. .OnDelete(DeleteBehavior.Cascade)
  2705. .IsRequired();
  2706. b.HasOne("wispro.sp.entity.Message", "Message")
  2707. .WithMany("RelatedItem")
  2708. .HasForeignKey("MessageId")
  2709. .HasConstraintName("FK_MessagePerformanceItem_Message")
  2710. .OnDelete(DeleteBehavior.Cascade)
  2711. .IsRequired();
  2712. b.Navigation("Item");
  2713. b.Navigation("Message");
  2714. });
  2715. modelBuilder.Entity("wispro.sp.entity.MessageReadRecord", b =>
  2716. {
  2717. b.HasOne("wispro.sp.entity.Message", "Message")
  2718. .WithMany()
  2719. .HasForeignKey("MessageId")
  2720. .HasConstraintName("FK_MessageReadRecord_Message")
  2721. .IsRequired();
  2722. b.HasOne("wispro.sp.entity.Message", null)
  2723. .WithMany("To")
  2724. .HasForeignKey("MessageId1");
  2725. b.HasOne("wispro.sp.entity.Staff", "Staff")
  2726. .WithMany()
  2727. .HasForeignKey("StaffId")
  2728. .HasConstraintName("FK_MessageReadRecord_Staff")
  2729. .IsRequired();
  2730. b.Navigation("Message");
  2731. b.Navigation("Staff");
  2732. });
  2733. modelBuilder.Entity("wispro.sp.entity.PerformanceItem", b =>
  2734. {
  2735. b.HasOne("wispro.sp.entity.CalMonth", "CalMonth")
  2736. .WithMany("PerformanceItems")
  2737. .HasForeignKey("CalMonthId")
  2738. .HasConstraintName("FK_PerformanceItem_CalMonth")
  2739. .OnDelete(DeleteBehavior.Cascade)
  2740. .IsRequired();
  2741. b.HasOne("wispro.sp.entity.Customer", "Customer")
  2742. .WithMany("PerformanceItems")
  2743. .HasForeignKey("CustomerId")
  2744. .HasConstraintName("FK_PerformanceItem_Customer");
  2745. b.HasOne("wispro.sp.entity.Staff", "PreOastaff")
  2746. .WithMany()
  2747. .HasForeignKey("PreOastaffId")
  2748. .HasConstraintName("FK_PerformanceItem_Staff");
  2749. b.HasOne("wispro.sp.entity.Staff", "Reviewer")
  2750. .WithMany("ReviewerItems")
  2751. .HasForeignKey("ReviewerId")
  2752. .HasConstraintName("FK_PerformanceItem_Reviewer");
  2753. b.Navigation("CalMonth");
  2754. b.Navigation("Customer");
  2755. b.Navigation("PreOastaff");
  2756. b.Navigation("Reviewer");
  2757. });
  2758. modelBuilder.Entity("wispro.sp.entity.SelectValue", b =>
  2759. {
  2760. b.HasOne("wispro.sp.entity.InputField", "InputField")
  2761. .WithMany("SelectValues")
  2762. .HasForeignKey("InputFieldId")
  2763. .OnDelete(DeleteBehavior.Cascade)
  2764. .IsRequired();
  2765. b.Navigation("InputField");
  2766. });
  2767. modelBuilder.Entity("wispro.sp.entity.Staff", b =>
  2768. {
  2769. b.HasOne("wispro.sp.entity.StaffGrade", "StaffGrade")
  2770. .WithMany("Staff")
  2771. .HasForeignKey("StaffGradeId")
  2772. .HasConstraintName("FK_Staff_StaffGrade");
  2773. b.Navigation("StaffGrade");
  2774. });
  2775. modelBuilder.Entity("wispro.sp.entity.StaffStatistics", b =>
  2776. {
  2777. b.HasOne("wispro.sp.entity.CalMonth", "CalMonth")
  2778. .WithMany()
  2779. .HasForeignKey("CalMonthId")
  2780. .OnDelete(DeleteBehavior.Cascade)
  2781. .IsRequired();
  2782. b.HasOne("wispro.sp.entity.Staff", "Staff")
  2783. .WithMany()
  2784. .HasForeignKey("StaffId")
  2785. .OnDelete(DeleteBehavior.Cascade)
  2786. .IsRequired();
  2787. b.Navigation("CalMonth");
  2788. b.Navigation("Staff");
  2789. });
  2790. modelBuilder.Entity("wispro.sp.entity.VerifyCoefficient", b =>
  2791. {
  2792. b.HasOne("wispro.sp.entity.StaffGrade", "Checker")
  2793. .WithMany("VerifyCoefficientCheckers")
  2794. .HasForeignKey("CheckerId")
  2795. .HasConstraintName("FK_VerifyCoefficient_StaffGrade")
  2796. .IsRequired();
  2797. b.HasOne("wispro.sp.entity.StaffGrade", "DoPerson")
  2798. .WithMany("VerifyCoefficientDoPeople")
  2799. .HasForeignKey("DoPersonId")
  2800. .HasConstraintName("FK_VerifyCoefficient_StaffGrade1")
  2801. .IsRequired();
  2802. b.Navigation("Checker");
  2803. b.Navigation("DoPerson");
  2804. });
  2805. modelBuilder.Entity("wispro.sp.entity.workflowDefine.Action", b =>
  2806. {
  2807. b.HasOne("wispro.sp.entity.workflowDefine.Step", "step")
  2808. .WithMany()
  2809. .HasForeignKey("StepId")
  2810. .OnDelete(DeleteBehavior.Cascade)
  2811. .IsRequired();
  2812. b.Navigation("step");
  2813. });
  2814. modelBuilder.Entity("wispro.sp.entity.workflowDefine.InputValueSetting", b =>
  2815. {
  2816. b.HasOne("wispro.sp.entity.workflowDefine.InputValueSetting", "ParentSetting")
  2817. .WithMany()
  2818. .HasForeignKey("ParentSettingId");
  2819. b.HasOne("wispro.sp.entity.workflowDefine.Action", "action")
  2820. .WithMany("inputValuesSettings")
  2821. .HasForeignKey("actionId")
  2822. .OnDelete(DeleteBehavior.NoAction)
  2823. .IsRequired();
  2824. b.Navigation("action");
  2825. b.Navigation("ParentSetting");
  2826. });
  2827. modelBuilder.Entity("wispro.sp.entity.workflowDefine.Step", b =>
  2828. {
  2829. b.HasOne("wispro.sp.entity.workflowDefine.Workflow", "workflow")
  2830. .WithMany()
  2831. .HasForeignKey("workflowId")
  2832. .OnDelete(DeleteBehavior.Cascade)
  2833. .IsRequired();
  2834. b.Navigation("workflow");
  2835. });
  2836. modelBuilder.Entity("wispro.sp.entity.workflowDefine.TrasferCondition", b =>
  2837. {
  2838. b.HasOne("wispro.sp.entity.workflowDefine.Step", "Step")
  2839. .WithMany()
  2840. .HasForeignKey("StepId")
  2841. .OnDelete(DeleteBehavior.NoAction)
  2842. .IsRequired();
  2843. b.HasOne("wispro.sp.entity.workflowDefine.Step", "nextStep")
  2844. .WithMany()
  2845. .HasForeignKey("nextStepId")
  2846. .OnDelete(DeleteBehavior.NoAction)
  2847. .IsRequired();
  2848. b.Navigation("nextStep");
  2849. b.Navigation("Step");
  2850. });
  2851. modelBuilder.Entity("wispro.sp.entity.workflowDefine.Workflow", b =>
  2852. {
  2853. b.HasOne("wispro.sp.entity.workflowDefine.Action", "InitAction")
  2854. .WithMany()
  2855. .HasForeignKey("InitActionId")
  2856. .OnDelete(DeleteBehavior.NoAction)
  2857. .IsRequired();
  2858. b.Navigation("InitAction");
  2859. });
  2860. modelBuilder.Entity("wispro.sp.entity.workflowInstance.InputValue", b =>
  2861. {
  2862. b.HasOne("wispro.sp.entity.workflowDefine.InputValueSetting", "valueSetting")
  2863. .WithMany()
  2864. .HasForeignKey("valueSettingId")
  2865. .OnDelete(DeleteBehavior.Cascade)
  2866. .IsRequired();
  2867. b.HasOne("wispro.sp.entity.workflowInstance.WorkflowInstance", "workflowInstance")
  2868. .WithMany()
  2869. .HasForeignKey("workflowInstanceId")
  2870. .OnDelete(DeleteBehavior.Cascade)
  2871. .IsRequired();
  2872. b.Navigation("valueSetting");
  2873. b.Navigation("workflowInstance");
  2874. });
  2875. modelBuilder.Entity("wispro.sp.entity.workflowInstance.StepInstance", b =>
  2876. {
  2877. b.HasOne("wispro.sp.entity.workflowDefine.Step", "Step")
  2878. .WithMany()
  2879. .HasForeignKey("stepId")
  2880. .OnDelete(DeleteBehavior.Cascade)
  2881. .IsRequired();
  2882. b.HasOne("wispro.sp.entity.workflowInstance.WorkflowInstance", "workflowInstance")
  2883. .WithMany()
  2884. .HasForeignKey("workflowInstanceId")
  2885. .OnDelete(DeleteBehavior.NoAction)
  2886. .IsRequired();
  2887. b.Navigation("Step");
  2888. b.Navigation("workflowInstance");
  2889. });
  2890. modelBuilder.Entity("wispro.sp.entity.workflowInstance.WorkflowInstance", b =>
  2891. {
  2892. b.HasOne("wispro.sp.entity.workflowDefine.Workflow", "workflow")
  2893. .WithMany()
  2894. .HasForeignKey("workflowId")
  2895. .OnDelete(DeleteBehavior.Cascade)
  2896. .IsRequired();
  2897. b.Navigation("workflow");
  2898. });
  2899. modelBuilder.Entity("wispro.sp.entity.AppealRecord", b =>
  2900. {
  2901. b.Navigation("AttachFiles");
  2902. });
  2903. modelBuilder.Entity("wispro.sp.entity.CalMonth", b =>
  2904. {
  2905. b.Navigation("PerformanceItems");
  2906. });
  2907. modelBuilder.Entity("wispro.sp.entity.Customer", b =>
  2908. {
  2909. b.Navigation("PerformanceItems");
  2910. });
  2911. modelBuilder.Entity("wispro.sp.entity.InputField", b =>
  2912. {
  2913. b.Navigation("SelectValues");
  2914. });
  2915. modelBuilder.Entity("wispro.sp.entity.Message", b =>
  2916. {
  2917. b.Navigation("RelatedItem");
  2918. b.Navigation("To");
  2919. });
  2920. modelBuilder.Entity("wispro.sp.entity.PerformanceItem", b =>
  2921. {
  2922. b.Navigation("ItemStaffs");
  2923. });
  2924. modelBuilder.Entity("wispro.sp.entity.Staff", b =>
  2925. {
  2926. b.Navigation("Customers");
  2927. b.Navigation("ItemStaffs");
  2928. b.Navigation("Positions");
  2929. b.Navigation("ReviewerItems");
  2930. });
  2931. modelBuilder.Entity("wispro.sp.entity.StaffGrade", b =>
  2932. {
  2933. b.Navigation("Staff");
  2934. b.Navigation("VerifyCoefficientCheckers");
  2935. b.Navigation("VerifyCoefficientDoPeople");
  2936. });
  2937. modelBuilder.Entity("wispro.sp.entity.workflowDefine.Action", b =>
  2938. {
  2939. b.Navigation("inputValuesSettings");
  2940. });
  2941. #pragma warning restore 612, 618
  2942. }
  2943. }
  2944. }