spDbContextModelSnapshot.cs 132 KB

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