202405260241009_init.cs 130 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167
  1. namespace ShwasherSys.Migrations
  2. {
  3. using System;
  4. using System.Collections.Generic;
  5. using System.Data.Entity.Infrastructure.Annotations;
  6. using System.Data.Entity.Migrations;
  7. public partial class init : DbMigration
  8. {
  9. public override void Up()
  10. {
  11. //RenameTable(name: "dbo.ProductInspectReports", newName: "ProductInspectReportContents");
  12. //RenameColumn(table: "dbo.PackageApply", name: "CurrentSemiStoreHouseNo", newName: "CurrentStoreHouseNo");
  13. //CreateTable(
  14. // "dbo.Currency",
  15. // c => new
  16. // {
  17. // Id = c.String(nullable: false, maxLength: 128),
  18. // CurrencyName = c.String(maxLength: 20),
  19. // TimeCreated = c.DateTime(),
  20. // TimeLastMod = c.DateTime(),
  21. // UserIDLastMod = c.String(maxLength: 20),
  22. // })
  23. // .PrimaryKey(t => t.Id);
  24. //CreateTable(
  25. // "dbo.CurrencyExchangeRate",
  26. // c => new
  27. // {
  28. // Id = c.Int(nullable: false, identity: true),
  29. // FromCurrencyId = c.String(maxLength: 20),
  30. // ToCurrencyId = c.String(maxLength: 20),
  31. // ExchangeRate = c.Decimal(precision: 18, scale: 4),
  32. // TimeCreated = c.DateTime(),
  33. // TimeLastMod = c.DateTime(),
  34. // UserIDLastMod = c.String(maxLength: 20),
  35. // })
  36. // .PrimaryKey(t => t.Id);
  37. //CreateTable(
  38. // "dbo.CurrentRmStoreHouse",
  39. // c => new
  40. // {
  41. // Id = c.String(nullable: false, maxLength: 128),
  42. // ProductionOrderNo = c.String(maxLength: 11),
  43. // StoreHouseId = c.Int(nullable: false),
  44. // StoreLocationNo = c.String(maxLength: 32),
  45. // RmProductNo = c.String(maxLength: 32),
  46. // FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
  47. // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
  48. // Remark = c.String(maxLength: 150),
  49. // ProductBatchNum = c.String(maxLength: 32),
  50. // PreMonthQuantity = c.Decimal(precision: 18, scale: 3),
  51. // IsDeleted = c.Boolean(nullable: false),
  52. // DeleterUserId = c.Long(),
  53. // DeletionTime = c.DateTime(),
  54. // LastModificationTime = c.DateTime(),
  55. // LastModifierUserId = c.Long(),
  56. // CreationTime = c.DateTime(nullable: false),
  57. // CreatorUserId = c.Long(),
  58. // },
  59. // annotations: new Dictionary<string, object>
  60. // {
  61. // { "DynamicFilter_CurrentRmStoreHouse_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  62. // })
  63. // .PrimaryKey(t => t.Id);
  64. //CreateTable(
  65. // "dbo.CustomerDisProductInfo",
  66. // c => new
  67. // {
  68. // Id = c.Int(nullable: false, identity: true),
  69. // ProductOrderNo = c.String(),
  70. // CustomerNo = c.String(),
  71. // CreationTime = c.DateTime(nullable: false),
  72. // CreatorUserId = c.Long(),
  73. // })
  74. // .PrimaryKey(t => t.Id)
  75. // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  76. // .Index(t => t.CreatorUserId);
  77. //CreateTable(
  78. // "dbo.CustomerInvoiceAddress",
  79. // c => new
  80. // {
  81. // Id = c.Int(nullable: false, identity: true),
  82. // CustomerId = c.String(nullable: false, maxLength: 30),
  83. // InvoiceAddressName = c.String(nullable: false, maxLength: 150),
  84. // InvoiceAddress = c.String(nullable: false, maxLength: 250),
  85. // LinkMan = c.String(maxLength: 30),
  86. // Telephone = c.String(maxLength: 50),
  87. // Zip = c.String(maxLength: 8),
  88. // Email = c.String(maxLength: 50),
  89. // Mobile = c.String(maxLength: 50),
  90. // Fax = c.String(maxLength: 50),
  91. // IsDeleted = c.Boolean(nullable: false),
  92. // DeleterUserId = c.Long(),
  93. // DeletionTime = c.DateTime(),
  94. // LastModificationTime = c.DateTime(),
  95. // LastModifierUserId = c.Long(),
  96. // CreationTime = c.DateTime(nullable: false),
  97. // CreatorUserId = c.Long(),
  98. // },
  99. // annotations: new Dictionary<string, object>
  100. // {
  101. // { "DynamicFilter_CustomerInvoiceAddress_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  102. // })
  103. // .PrimaryKey(t => t.Id);
  104. //CreateTable(
  105. // "dbo.DeviceMgPlanInfo",
  106. // c => new
  107. // {
  108. // Id = c.Int(nullable: false, identity: true),
  109. // No = c.String(maxLength: 50),
  110. // PlanType = c.Int(nullable: false),
  111. // DeviceNo = c.String(maxLength: 50),
  112. // Name = c.String(maxLength: 50),
  113. // Description = c.String(),
  114. // ExpireDate = c.DateTime(nullable: false),
  115. // MaintenanceCycle = c.Int(nullable: false),
  116. // MaintenanceDate = c.DateTime(nullable: false),
  117. // NextMaintenanceDate = c.DateTime(),
  118. // Remark = c.String(maxLength: 500),
  119. // NumberOfUsers = c.Int(nullable: false),
  120. // IsDeleted = c.Boolean(nullable: false),
  121. // DeleterUserId = c.Long(),
  122. // DeletionTime = c.DateTime(),
  123. // LastModificationTime = c.DateTime(),
  124. // LastModifierUserId = c.Long(),
  125. // CreationTime = c.DateTime(nullable: false),
  126. // CreatorUserId = c.Long(),
  127. // },
  128. // annotations: new Dictionary<string, object>
  129. // {
  130. // { "DynamicFilter_DeviceMgPlan_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  131. // })
  132. // .PrimaryKey(t => t.Id)
  133. // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  134. // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
  135. // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
  136. // .Index(t => t.DeleterUserId)
  137. // .Index(t => t.LastModifierUserId)
  138. // .Index(t => t.CreatorUserId);
  139. //CreateTable(
  140. // "dbo.DisqualifiedProductInfo",
  141. // c => new
  142. // {
  143. // Id = c.Int(nullable: false, identity: true),
  144. // DisqualifiedNo = c.String(maxLength: 20),
  145. // ProductOrderNo = c.String(maxLength: 11),
  146. // ReturnOrderNo = c.String(maxLength: 32),
  147. // ProductNo = c.String(maxLength: 50),
  148. // ProductName = c.String(maxLength: 100),
  149. // ProductType = c.Int(nullable: false),
  150. // QuantityWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
  151. // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
  152. // QuantityPcs = c.Decimal(nullable: false, precision: 18, scale: 3),
  153. // HandleType = c.Int(nullable: false),
  154. // CheckUser = c.String(maxLength: 20),
  155. // CheckDate = c.DateTime(),
  156. // HandleUser = c.String(maxLength: 20),
  157. // HandleDate = c.DateTime(),
  158. // DisqualifiedType = c.Int(),
  159. // CreationTime = c.DateTime(nullable: false),
  160. // CreatorUserId = c.Long(),
  161. // })
  162. // .PrimaryKey(t => t.Id)
  163. // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  164. // .Index(t => t.CreatorUserId);
  165. //CreateTable(
  166. // "dbo.EmployeeInfo",
  167. // c => new
  168. // {
  169. // Id = c.Int(nullable: false, identity: true),
  170. // No = c.String(maxLength: 20),
  171. // Name = c.String(maxLength: 50),
  172. // CardId = c.String(maxLength: 18),
  173. // Gender = c.Int(nullable: false),
  174. // PhoneNumber = c.String(maxLength: 18),
  175. // DepartmentNo = c.String(maxLength: 20),
  176. // DutyNo = c.String(maxLength: 20),
  177. // Description = c.String(maxLength: 500),
  178. // UserName = c.String(maxLength: 32),
  179. // Remark = c.String(maxLength: 500),
  180. // IsDeleted = c.Boolean(nullable: false),
  181. // DeleterUserId = c.Long(),
  182. // DeletionTime = c.DateTime(),
  183. // LastModificationTime = c.DateTime(),
  184. // LastModifierUserId = c.Long(),
  185. // CreationTime = c.DateTime(nullable: false),
  186. // CreatorUserId = c.Long(),
  187. // },
  188. // annotations: new Dictionary<string, object>
  189. // {
  190. // { "DynamicFilter_Employee_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  191. // })
  192. // .PrimaryKey(t => t.Id)
  193. // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  194. // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
  195. // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
  196. // .Index(t => t.DeleterUserId)
  197. // .Index(t => t.LastModifierUserId)
  198. // .Index(t => t.CreatorUserId);
  199. //CreateTable(
  200. // "dbo.EmployeeWorkPerformanceInfo",
  201. // c => new
  202. // {
  203. // Id = c.Int(nullable: false, identity: true),
  204. // PerformanceNo = c.String(maxLength: 20),
  205. // EmployeeId = c.Int(nullable: false),
  206. // RelatedNo = c.String(maxLength: 20),
  207. // ProductOrderNo = c.String(maxLength: 11),
  208. // WorkType = c.Int(nullable: false),
  209. // Performance = c.Decimal(precision: 18, scale: 3),
  210. // PerformanceUnit = c.String(maxLength: 10),
  211. // PerformanceDesc = c.String(maxLength: 500),
  212. // Remark = c.String(maxLength: 500),
  213. // CreationTime = c.DateTime(nullable: false),
  214. // CreatorUserId = c.Long(),
  215. // })
  216. // .PrimaryKey(t => t.Id)
  217. // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  218. // .ForeignKey("dbo.EmployeeInfo", t => t.EmployeeId, cascadeDelete: true)
  219. // .Index(t => t.EmployeeId)
  220. // .Index(t => t.CreatorUserId);
  221. //CreateTable(
  222. // "dbo.ExpressLogistics",
  223. // c => new
  224. // {
  225. // Id = c.Int(nullable: false, identity: true),
  226. // ExpressName = c.String(maxLength: 50),
  227. // Code = c.String(maxLength: 50),
  228. // Sort = c.Int(nullable: false),
  229. // TimeCreated = c.DateTime(storeType: "smalldatetime"),
  230. // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
  231. // UserIDLastMod = c.String(maxLength: 50),
  232. // IsLock = c.String(nullable: false, maxLength: 1),
  233. // })
  234. // .PrimaryKey(t => t.Id);
  235. //CreateTable(
  236. // "dbo.ExpressProviderMappers",
  237. // c => new
  238. // {
  239. // Id = c.Int(nullable: false, identity: true),
  240. // ExpressId = c.Int(nullable: false),
  241. // ProviderId = c.Int(nullable: false),
  242. // MapperCode = c.String(maxLength: 50),
  243. // QueryUrl = c.String(maxLength: 500),
  244. // ExtendInfo = c.String(maxLength: 500),
  245. // ActiveStatus = c.Int(),
  246. // })
  247. // .PrimaryKey(t => t.Id)
  248. // .ForeignKey("dbo.ExpressLogistics", t => t.ExpressId, cascadeDelete: true)
  249. // .ForeignKey("dbo.ExpressServiceProviders", t => t.ProviderId, cascadeDelete: true)
  250. // .Index(t => t.ExpressId)
  251. // .Index(t => t.ProviderId);
  252. //CreateTable(
  253. // "dbo.ExpressServiceProviders",
  254. // c => new
  255. // {
  256. // Id = c.Int(nullable: false, identity: true),
  257. // ProviderName = c.String(maxLength: 50),
  258. // QueryApiUrl = c.String(maxLength: 150),
  259. // CallBackUrl = c.String(maxLength: 150),
  260. // ExcuteNamespaceAndMethod = c.String(maxLength: 150),
  261. // TimeCreated = c.DateTime(storeType: "smalldatetime"),
  262. // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
  263. // UserIDLastMod = c.String(maxLength: 50),
  264. // IsLock = c.String(nullable: false, maxLength: 1),
  265. // })
  266. // .PrimaryKey(t => t.Id);
  267. //CreateTable(
  268. // "dbo.FixedAssetInfo",
  269. // c => new
  270. // {
  271. // Id = c.Int(nullable: false, identity: true),
  272. // No = c.String(maxLength: 50),
  273. // Name = c.String(maxLength: 50),
  274. // Model = c.String(maxLength: 50),
  275. // Description = c.String(maxLength: 500),
  276. // Remark = c.String(maxLength: 500),
  277. // IsDeleted = c.Boolean(nullable: false),
  278. // DeleterUserId = c.Long(),
  279. // DeletionTime = c.DateTime(),
  280. // LastModificationTime = c.DateTime(),
  281. // LastModifierUserId = c.Long(),
  282. // CreationTime = c.DateTime(nullable: false),
  283. // CreatorUserId = c.Long(),
  284. // },
  285. // annotations: new Dictionary<string, object>
  286. // {
  287. // { "DynamicFilter_FixedAsset_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  288. // })
  289. // .PrimaryKey(t => t.Id)
  290. // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  291. // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
  292. // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
  293. // .Index(t => t.DeleterUserId)
  294. // .Index(t => t.LastModifierUserId)
  295. // .Index(t => t.CreatorUserId);
  296. //CreateTable(
  297. // "dbo.FixedAssetTypeInfo",
  298. // c => new
  299. // {
  300. // Id = c.String(nullable: false, maxLength: 128),
  301. // Name = c.String(nullable: false, maxLength: 50),
  302. // Description = c.String(maxLength: 500),
  303. // Remark = c.String(maxLength: 500),
  304. // IsDeleted = c.Boolean(nullable: false),
  305. // DeleterUserId = c.Long(),
  306. // DeletionTime = c.DateTime(),
  307. // LastModificationTime = c.DateTime(),
  308. // LastModifierUserId = c.Long(),
  309. // CreationTime = c.DateTime(nullable: false),
  310. // CreatorUserId = c.Long(),
  311. // },
  312. // annotations: new Dictionary<string, object>
  313. // {
  314. // { "DynamicFilter_FixedAssetType_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  315. // })
  316. // .PrimaryKey(t => t.Id)
  317. // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  318. // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
  319. // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
  320. // .Index(t => t.DeleterUserId)
  321. // .Index(t => t.LastModifierUserId)
  322. // .Index(t => t.CreatorUserId);
  323. //CreateTable(
  324. // "dbo.InventoryCheck",
  325. // c => new
  326. // {
  327. // Id = c.String(nullable: false, maxLength: 128),
  328. // CheckNo = c.String(maxLength: 32),
  329. // StoreHouseId = c.Int(nullable: false),
  330. // StoreAreaCode = c.String(maxLength: 32),
  331. // ShelfNumber = c.String(maxLength: 32),
  332. // ShelfLevel = c.String(maxLength: 32),
  333. // SequenceNo = c.String(maxLength: 32),
  334. // CheckType = c.String(maxLength: 10),
  335. // PlanStartDate = c.DateTime(),
  336. // PlanEndDate = c.DateTime(),
  337. // Remark = c.String(maxLength: 200),
  338. // CheckUser = c.String(maxLength: 32),
  339. // PublishUser = c.String(maxLength: 32),
  340. // FinishDate = c.DateTime(),
  341. // CheckState = c.Int(nullable: false),
  342. // ProductNo = c.String(maxLength: 32),
  343. // IsDeleted = c.Boolean(nullable: false),
  344. // DeleterUserId = c.Long(),
  345. // DeletionTime = c.DateTime(),
  346. // LastModificationTime = c.DateTime(),
  347. // LastModifierUserId = c.Long(),
  348. // CreationTime = c.DateTime(nullable: false),
  349. // CreatorUserId = c.Long(),
  350. // },
  351. // annotations: new Dictionary<string, object>
  352. // {
  353. // { "DynamicFilter_InventoryCheckInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  354. // })
  355. // .PrimaryKey(t => t.Id);
  356. //CreateTable(
  357. // "dbo.InventoryCheckRecord",
  358. // c => new
  359. // {
  360. // Id = c.String(nullable: false, maxLength: 128),
  361. // CheckNo = c.String(maxLength: 32),
  362. // CurrentStoreHouseNo = c.String(maxLength: 32),
  363. // CheckQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
  364. // StoreQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
  365. // LastModificationTime = c.DateTime(),
  366. // LastModifierUserId = c.Long(),
  367. // CreationTime = c.DateTime(nullable: false),
  368. // CreatorUserId = c.Long(),
  369. // })
  370. // .PrimaryKey(t => t.Id);
  371. //CreateTable(
  372. // "dbo.LicenseDocumentInfo",
  373. // c => new
  374. // {
  375. // Id = c.Int(nullable: false, identity: true),
  376. // No = c.String(maxLength: 50),
  377. // Name = c.String(maxLength: 50),
  378. // Description = c.String(maxLength: 500),
  379. // LicenseGroup = c.String(maxLength: 50),
  380. // LicenseType = c.String(maxLength: 50),
  381. // FilePath = c.String(maxLength: 300),
  382. // ExpireDate = c.DateTime(nullable: false),
  383. // Remark = c.String(maxLength: 500),
  384. // IsDeleted = c.Boolean(nullable: false),
  385. // DeleterUserId = c.Long(),
  386. // DeletionTime = c.DateTime(),
  387. // LastModificationTime = c.DateTime(),
  388. // LastModifierUserId = c.Long(),
  389. // CreationTime = c.DateTime(nullable: false),
  390. // CreatorUserId = c.Long(),
  391. // },
  392. // annotations: new Dictionary<string, object>
  393. // {
  394. // { "DynamicFilter_LicenseDocument_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  395. // })
  396. // .PrimaryKey(t => t.Id)
  397. // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  398. // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
  399. // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
  400. // .Index(t => t.DeleterUserId)
  401. // .Index(t => t.LastModifierUserId)
  402. // .Index(t => t.CreatorUserId);
  403. //CreateTable(
  404. // "dbo.LicenseTypeInfo",
  405. // c => new
  406. // {
  407. // Id = c.Int(nullable: false, identity: true),
  408. // Name = c.String(maxLength: 50),
  409. // GroupName = c.String(maxLength: 50),
  410. // LastModificationTime = c.DateTime(),
  411. // LastModifierUserId = c.Long(),
  412. // CreationTime = c.DateTime(nullable: false),
  413. // CreatorUserId = c.Long(),
  414. // })
  415. // .PrimaryKey(t => t.Id)
  416. // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  417. // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
  418. // .Index(t => t.LastModifierUserId)
  419. // .Index(t => t.CreatorUserId);
  420. //CreateTable(
  421. // "dbo.MaintenanceMemberInfo",
  422. // c => new
  423. // {
  424. // Id = c.String(nullable: false, maxLength: 128),
  425. // MaintenanceNo = c.String(),
  426. // EmployeeId = c.Int(nullable: false),
  427. // Name = c.String(),
  428. // StartDateTime = c.DateTime(),
  429. // EndDateTime = c.DateTime(),
  430. // WorkHour = c.Decimal(nullable: false, precision: 18, scale: 2),
  431. // IsConfirm = c.Boolean(nullable: false),
  432. // WorkDesc = c.String(),
  433. // Remark = c.String(maxLength: 500),
  434. // CreationTime = c.DateTime(nullable: false),
  435. // CreatorUserId = c.Long(),
  436. // })
  437. // .PrimaryKey(t => t.Id)
  438. // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  439. // .ForeignKey("dbo.EmployeeInfo", t => t.EmployeeId, cascadeDelete: true)
  440. // .Index(t => t.EmployeeId)
  441. // .Index(t => t.CreatorUserId);
  442. //CreateTable(
  443. // "dbo.MaintenanceRecordInfo",
  444. // c => new
  445. // {
  446. // Id = c.String(nullable: false, maxLength: 128),
  447. // DeviceMgPlanNo = c.String(maxLength: 50),
  448. // DeviceNo = c.String(maxLength: 50),
  449. // DeviceName = c.String(maxLength: 50),
  450. // MgType = c.Int(nullable: false),
  451. // Description = c.String(maxLength: 500),
  452. // Address = c.String(maxLength: 200),
  453. // PlanDate = c.DateTime(nullable: false),
  454. // CompleteState = c.Int(nullable: false),
  455. // CompleteDate = c.DateTime(),
  456. // Remark = c.String(maxLength: 500),
  457. // CreationTime = c.DateTime(nullable: false),
  458. // CreatorUserId = c.Long(),
  459. // })
  460. // .PrimaryKey(t => t.Id)
  461. // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  462. // .Index(t => t.CreatorUserId);
  463. //CreateTable(
  464. // "dbo.MoldInfo",
  465. // c => new
  466. // {
  467. // Id = c.Int(nullable: false, identity: true),
  468. // No = c.String(maxLength: 50),
  469. // Name = c.String(maxLength: 50),
  470. // Model = c.String(maxLength: 50),
  471. // Material = c.String(maxLength: 50),
  472. // Description = c.String(maxLength: 500),
  473. // Remark = c.String(maxLength: 500),
  474. // CustomerName = c.String(maxLength: 50),
  475. // ShelfNum = c.String(maxLength: 50),
  476. // OuterDiameter = c.String(maxLength: 50),
  477. // InsideDiameter = c.String(maxLength: 50),
  478. // Thickness = c.String(maxLength: 50),
  479. // Height = c.String(maxLength: 50),
  480. // Rigidity = c.String(maxLength: 50),
  481. // MaintenanceCycle = c.Int(nullable: false),
  482. // IsDeleted = c.Boolean(nullable: false),
  483. // DeleterUserId = c.Long(),
  484. // DeletionTime = c.DateTime(),
  485. // LastModificationTime = c.DateTime(),
  486. // LastModifierUserId = c.Long(),
  487. // CreationTime = c.DateTime(nullable: false),
  488. // CreatorUserId = c.Long(),
  489. // },
  490. // annotations: new Dictionary<string, object>
  491. // {
  492. // { "DynamicFilter_Mold_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  493. // })
  494. // .PrimaryKey(t => t.Id)
  495. // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  496. // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
  497. // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
  498. // .Index(t => t.DeleterUserId)
  499. // .Index(t => t.LastModifierUserId)
  500. // .Index(t => t.CreatorUserId);
  501. //CreateTable(
  502. // "dbo.OrderProduction",
  503. // c => new
  504. // {
  505. // Id = c.Int(nullable: false, identity: true),
  506. // OrderItemId = c.Int(nullable: false),
  507. // ProductionOrderNo = c.String(maxLength: 11),
  508. // Remark = c.String(maxLength: 150),
  509. // TimeCreated = c.DateTime(),
  510. // CreatorUserId = c.String(maxLength: 20),
  511. // })
  512. // .PrimaryKey(t => t.Id);
  513. //CreateTable(
  514. // "dbo.OrderSendExceed",
  515. // c => new
  516. // {
  517. // Id = c.Int(nullable: false, identity: true),
  518. // OrderItemId = c.Int(nullable: false),
  519. // ExceedQuantity = c.Decimal(nullable: false, precision: 18, scale: 3, storeType: "numeric"),
  520. // OperatorMan = c.String(maxLength: 30),
  521. // OrderNo = c.String(),
  522. // ProductNo = c.String(),
  523. // LastModificationTime = c.DateTime(),
  524. // LastModifierUserId = c.Long(),
  525. // CreationTime = c.DateTime(nullable: false),
  526. // CreatorUserId = c.Long(),
  527. // })
  528. // .PrimaryKey(t => t.Id);
  529. //CreateTable(
  530. // "dbo.OutFactory",
  531. // c => new
  532. // {
  533. // OutFactoryId = c.String(nullable: false, maxLength: 128),
  534. // OutFactoryName = c.String(nullable: false, maxLength: 50),
  535. // LinkMan = c.String(maxLength: 20),
  536. // Address = c.String(maxLength: 150),
  537. // WebSite = c.String(maxLength: 50),
  538. // TimeCreated = c.DateTime(storeType: "smalldatetime"),
  539. // TimeLastMod = c.DateTime(storeType: "smalldatetime"),
  540. // UserIDLastMod = c.String(maxLength: 20),
  541. // IsLock = c.String(nullable: false, maxLength: 1),
  542. // Telephone = c.String(maxLength: 50),
  543. // Fax = c.String(maxLength: 50),
  544. // zip = c.String(maxLength: 6),
  545. // Email = c.String(maxLength: 200),
  546. // })
  547. // .PrimaryKey(t => t.OutFactoryId);
  548. //CreateTable(
  549. // "dbo.ProductInspectReportInfos",
  550. // c => new
  551. // {
  552. // Id = c.Int(nullable: false, identity: true),
  553. // ProductInspectReportNo = c.String(nullable: false, maxLength: 32),
  554. // ProductionOrderNo = c.String(nullable: false, maxLength: 11),
  555. // SemiProductNo = c.String(maxLength: 32),
  556. // ConfirmStatus = c.Int(nullable: false),
  557. // InspectCount = c.Int(nullable: false),
  558. // ConfirmDate = c.DateTime(),
  559. // ConfirmUser = c.String(maxLength: 100),
  560. // InspectContent = c.String(maxLength: 1000),
  561. // CreationTime = c.DateTime(nullable: false),
  562. // CreatorUserId = c.Long(),
  563. // })
  564. // .PrimaryKey(t => t.Id);
  565. //CreateTable(
  566. // "dbo.ProductionOrderLogInfo",
  567. // c => new
  568. // {
  569. // Id = c.Int(nullable: false, identity: true),
  570. // ProductionNo = c.String(maxLength: 20),
  571. // ProductOrderNo = c.String(maxLength: 11),
  572. // EmployeeId = c.Int(nullable: false),
  573. // CarNo = c.String(maxLength: 20),
  574. // QuantityWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
  575. // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
  576. // QuantityPcs = c.Decimal(nullable: false, precision: 18, scale: 3),
  577. // CreationTime = c.DateTime(nullable: false),
  578. // CreatorUserId = c.Long(),
  579. // })
  580. // .PrimaryKey(t => t.Id)
  581. // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  582. // .ForeignKey("dbo.EmployeeInfo", t => t.EmployeeId, cascadeDelete: true)
  583. // .Index(t => t.EmployeeId)
  584. // .Index(t => t.CreatorUserId);
  585. //CreateTable(
  586. // "dbo.ProductMapper",
  587. // c => new
  588. // {
  589. // Id = c.Int(nullable: false, identity: true),
  590. // ProductNo = c.String(maxLength: 50),
  591. // PreProductNo = c.String(maxLength: 50),
  592. // PreProductType = c.Int(nullable: false),
  593. // NewProductType = c.Int(nullable: false),
  594. // IsDeleted = c.Boolean(nullable: false),
  595. // DeleterUserId = c.Long(),
  596. // DeletionTime = c.DateTime(),
  597. // LastModificationTime = c.DateTime(),
  598. // LastModifierUserId = c.Long(),
  599. // CreationTime = c.DateTime(nullable: false),
  600. // CreatorUserId = c.Long(),
  601. // },
  602. // annotations: new Dictionary<string, object>
  603. // {
  604. // { "DynamicFilter_ProductMapper_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  605. // })
  606. // .PrimaryKey(t => t.Id);
  607. //CreateTable(
  608. // "dbo.ProductProperties",
  609. // c => new
  610. // {
  611. // Id = c.Int(nullable: false, identity: true),
  612. // PropertyType = c.String(maxLength: 50),
  613. // PropertyNo = c.String(maxLength: 50),
  614. // PropertyValue = c.String(maxLength: 50),
  615. // DisplayValue = c.String(maxLength: 150),
  616. // ContentInfo = c.String(maxLength: 250),
  617. // IsDeleted = c.Boolean(nullable: false),
  618. // DeleterUserId = c.Long(),
  619. // DeletionTime = c.DateTime(),
  620. // LastModificationTime = c.DateTime(),
  621. // LastModifierUserId = c.Long(),
  622. // CreationTime = c.DateTime(nullable: false),
  623. // CreatorUserId = c.Long(),
  624. // },
  625. // annotations: new Dictionary<string, object>
  626. // {
  627. // { "DynamicFilter_ProductProperty_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  628. // })
  629. // .PrimaryKey(t => t.Id);
  630. //CreateTable(
  631. // "dbo.QualityIssueLabelInfo",
  632. // c => new
  633. // {
  634. // Id = c.String(nullable: false, maxLength: 128),
  635. // Name = c.String(nullable: false, maxLength: 50),
  636. // Description = c.String(maxLength: 500),
  637. // Remark = c.String(maxLength: 500),
  638. // IsDeleted = c.Boolean(nullable: false),
  639. // DeleterUserId = c.Long(),
  640. // DeletionTime = c.DateTime(),
  641. // LastModificationTime = c.DateTime(),
  642. // LastModifierUserId = c.Long(),
  643. // CreationTime = c.DateTime(nullable: false),
  644. // CreatorUserId = c.Long(),
  645. // },
  646. // annotations: new Dictionary<string, object>
  647. // {
  648. // { "DynamicFilter_QualityIssueLabel_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  649. // })
  650. // .PrimaryKey(t => t.Id)
  651. // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  652. // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
  653. // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
  654. // .Index(t => t.DeleterUserId)
  655. // .Index(t => t.LastModifierUserId)
  656. // .Index(t => t.CreatorUserId);
  657. //CreateTable(
  658. // "dbo.ReturnGoodOrder",
  659. // c => new
  660. // {
  661. // Id = c.Int(nullable: false, identity: true),
  662. // ReturnOrderNo = c.String(maxLength: 32),
  663. // SendOrderNo = c.String(maxLength: 32),
  664. // OrderNo = c.String(maxLength: 32),
  665. // OrderItemNo = c.String(maxLength: 32),
  666. // ProductNo = c.String(maxLength: 32),
  667. // ProductionOrderNo = c.String(maxLength: 32),
  668. // CustomerId = c.String(maxLength: 32),
  669. // Reason = c.String(maxLength: 500),
  670. // Amount = c.Decimal(precision: 18, scale: 2),
  671. // AuditAmount = c.Decimal(precision: 18, scale: 2),
  672. // Quantity = c.Decimal(precision: 18, scale: 3),
  673. // HandleUser = c.String(maxLength: 32),
  674. // ApplyUser = c.String(maxLength: 32),
  675. // ConfirmUser = c.String(maxLength: 32),
  676. // ReturnDate = c.DateTime(),
  677. // ApplyDate = c.DateTime(),
  678. // ConfirmDate = c.DateTime(),
  679. // ReturnState = c.Int(nullable: false),
  680. // ReturnType = c.Int(nullable: false),
  681. // LinkName = c.String(maxLength: 50),
  682. // SurveyReason = c.String(maxLength: 500),
  683. // SurveyDetail = c.String(maxLength: 500),
  684. // Solution = c.String(maxLength: 500),
  685. // IsDeleted = c.Boolean(nullable: false),
  686. // DeleterUserId = c.Long(),
  687. // DeletionTime = c.DateTime(),
  688. // LastModificationTime = c.DateTime(),
  689. // LastModifierUserId = c.Long(),
  690. // CreationTime = c.DateTime(nullable: false),
  691. // CreatorUserId = c.Long(),
  692. // },
  693. // annotations: new Dictionary<string, object>
  694. // {
  695. // { "DynamicFilter_ReturnGoodOrder_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  696. // })
  697. // .PrimaryKey(t => t.Id)
  698. // .Index(t => t.ReturnOrderNo, unique: true);
  699. //CreateTable(
  700. // "dbo.RmEnterStore",
  701. // c => new
  702. // {
  703. // Id = c.String(nullable: false, maxLength: 128),
  704. // ProductionOrderNo = c.String(maxLength: 11),
  705. // RmProductNo = c.String(maxLength: 50),
  706. // StoreHouseId = c.Int(nullable: false),
  707. // StoreLocationNo = c.String(maxLength: 32),
  708. // ApplyStatus = c.Int(nullable: false),
  709. // IsClose = c.Boolean(nullable: false),
  710. // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
  711. // ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
  712. // AuditUser = c.String(maxLength: 32),
  713. // AuditDate = c.DateTime(),
  714. // ApplyEnterDate = c.DateTime(),
  715. // EnterStoreUser = c.String(maxLength: 32),
  716. // EnterStoreDate = c.DateTime(),
  717. // Remark = c.String(maxLength: 150),
  718. // ProductBatchNum = c.String(maxLength: 32),
  719. // CreateSourceType = c.Int(nullable: false),
  720. // IsDeleted = c.Boolean(nullable: false),
  721. // DeleterUserId = c.Long(),
  722. // DeletionTime = c.DateTime(),
  723. // LastModificationTime = c.DateTime(),
  724. // LastModifierUserId = c.Long(),
  725. // CreationTime = c.DateTime(nullable: false),
  726. // CreatorUserId = c.Long(),
  727. // },
  728. // annotations: new Dictionary<string, object>
  729. // {
  730. // { "DynamicFilter_RmEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  731. // })
  732. // .PrimaryKey(t => t.Id);
  733. //CreateTable(
  734. // "dbo.RmOutStore",
  735. // c => new
  736. // {
  737. // Id = c.String(nullable: false, maxLength: 128),
  738. // ProductionOrderNo = c.String(maxLength: 11),
  739. // CurrentRmStoreHouseNo = c.String(maxLength: 32),
  740. // RmProductNo = c.String(maxLength: 50),
  741. // StoreHouseId = c.Int(nullable: false),
  742. // ApplyStatus = c.Int(nullable: false),
  743. // IsClose = c.Boolean(nullable: false),
  744. // IsConfirm = c.Boolean(),
  745. // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
  746. // ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
  747. // AuditUser = c.String(maxLength: 150),
  748. // AuditDate = c.DateTime(),
  749. // OutStoreUser = c.String(maxLength: 150),
  750. // OutStoreDate = c.DateTime(),
  751. // ApplyOutDate = c.DateTime(),
  752. // Remark = c.String(maxLength: 150),
  753. // ProductBatchNum = c.String(maxLength: 32),
  754. // CreateSourceType = c.Int(nullable: false),
  755. // IsDeleted = c.Boolean(nullable: false),
  756. // DeleterUserId = c.Long(),
  757. // DeletionTime = c.DateTime(),
  758. // LastModificationTime = c.DateTime(),
  759. // LastModifierUserId = c.Long(),
  760. // CreationTime = c.DateTime(nullable: false),
  761. // CreatorUserId = c.Long(),
  762. // },
  763. // annotations: new Dictionary<string, object>
  764. // {
  765. // { "DynamicFilter_RmOutStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  766. // })
  767. // .PrimaryKey(t => t.Id);
  768. //CreateTable(
  769. // "dbo.RmProduct",
  770. // c => new
  771. // {
  772. // Id = c.String(nullable: false, maxLength: 128),
  773. // ProductName = c.String(maxLength: 50),
  774. // Material = c.String(maxLength: 50),
  775. // Model = c.String(maxLength: 50),
  776. // ProductDesc = c.String(maxLength: 200),
  777. // ModelNo = c.String(maxLength: 20),
  778. // MaterialNo = c.String(maxLength: 20),
  779. // IsDeleted = c.Boolean(nullable: false),
  780. // DeleterUserId = c.Long(),
  781. // DeletionTime = c.DateTime(),
  782. // LastModificationTime = c.DateTime(),
  783. // LastModifierUserId = c.Long(),
  784. // CreationTime = c.DateTime(nullable: false),
  785. // CreatorUserId = c.Long(),
  786. // },
  787. // annotations: new Dictionary<string, object>
  788. // {
  789. // { "DynamicFilter_RmProduct_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  790. // })
  791. // .PrimaryKey(t => t.Id);
  792. //CreateTable(
  793. // "dbo.ScheduleOrderSend",
  794. // c => new
  795. // {
  796. // Id = c.Int(nullable: false, identity: true),
  797. // OrderItemId = c.Int(nullable: false),
  798. // Remark = c.String(maxLength: 500),
  799. // PlanQuantity = c.Decimal(precision: 18, scale: 2),
  800. // SendUser = c.String(maxLength: 32),
  801. // PlanDate = c.DateTime(),
  802. // SendState = c.Int(nullable: false),
  803. // LastModificationTime = c.DateTime(),
  804. // LastModifierUserId = c.Long(),
  805. // CreationTime = c.DateTime(nullable: false),
  806. // CreatorUserId = c.Long(),
  807. // })
  808. // .PrimaryKey(t => t.Id);
  809. //CreateTable(
  810. // "dbo.N_ViewScheduleOrderSend",
  811. // c => new
  812. // {
  813. // Id = c.Int(nullable: false, identity: true),
  814. // OrderItemId = c.Int(nullable: false),
  815. // PlanQuantity = c.Decimal(precision: 18, scale: 2),
  816. // SendUser = c.String(),
  817. // Remark = c.String(),
  818. // PlanDate = c.DateTime(),
  819. // SendState = c.Int(nullable: false),
  820. // OrderNo = c.String(),
  821. // ProductNo = c.String(),
  822. // ProductName = c.String(),
  823. // Model = c.String(),
  824. // Material = c.String(),
  825. // SurfaceColor = c.String(),
  826. // Rigidity = c.String(),
  827. // CustomerName = c.String(),
  828. // CustomerId = c.String(),
  829. // })
  830. // .PrimaryKey(t => t.Id);
  831. //CreateTable(
  832. // "dbo.ScrapEnterStore",
  833. // c => new
  834. // {
  835. // Id = c.String(nullable: false, maxLength: 128),
  836. // ProductionOrderNo = c.String(maxLength: 11),
  837. // ProductNo = c.String(maxLength: 50),
  838. // StoreHouseId = c.Int(nullable: false),
  839. // StoreLocationNo = c.String(maxLength: 32),
  840. // ApplyStatus = c.Int(nullable: false),
  841. // IsClose = c.Boolean(nullable: false),
  842. // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
  843. // ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
  844. // AuditUser = c.String(maxLength: 32),
  845. // AuditDate = c.DateTime(),
  846. // ApplyEnterDate = c.DateTime(),
  847. // EnterStoreUser = c.String(maxLength: 32),
  848. // EnterStoreDate = c.DateTime(),
  849. // Remark = c.String(maxLength: 150),
  850. // ProductType = c.Int(nullable: false),
  851. // ScrapSource = c.Int(nullable: false),
  852. // ScrapSourceNo = c.String(maxLength: 50),
  853. // IsDeleted = c.Boolean(nullable: false),
  854. // DeleterUserId = c.Long(),
  855. // DeletionTime = c.DateTime(),
  856. // LastModificationTime = c.DateTime(),
  857. // LastModifierUserId = c.Long(),
  858. // CreationTime = c.DateTime(nullable: false),
  859. // CreatorUserId = c.Long(),
  860. // },
  861. // annotations: new Dictionary<string, object>
  862. // {
  863. // { "DynamicFilter_ScrapEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  864. // })
  865. // .PrimaryKey(t => t.Id);
  866. //CreateTable(
  867. // "dbo.ScrapTypeInfo",
  868. // c => new
  869. // {
  870. // Id = c.String(nullable: false, maxLength: 128),
  871. // Name = c.String(nullable: false, maxLength: 50),
  872. // Description = c.String(maxLength: 500),
  873. // Remark = c.String(maxLength: 500),
  874. // IsDeleted = c.Boolean(nullable: false),
  875. // DeleterUserId = c.Long(),
  876. // DeletionTime = c.DateTime(),
  877. // LastModificationTime = c.DateTime(),
  878. // LastModifierUserId = c.Long(),
  879. // CreationTime = c.DateTime(nullable: false),
  880. // CreatorUserId = c.Long(),
  881. // },
  882. // annotations: new Dictionary<string, object>
  883. // {
  884. // { "DynamicFilter_ScrapType_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  885. // })
  886. // .PrimaryKey(t => t.Id)
  887. // .ForeignKey("dbo.Sys_Users", t => t.CreatorUserId)
  888. // .ForeignKey("dbo.Sys_Users", t => t.DeleterUserId)
  889. // .ForeignKey("dbo.Sys_Users", t => t.LastModifierUserId)
  890. // .Index(t => t.DeleterUserId)
  891. // .Index(t => t.LastModifierUserId)
  892. // .Index(t => t.CreatorUserId);
  893. //CreateTable(
  894. // "dbo.StandardCatalog",
  895. // c => new
  896. // {
  897. // Id = c.Int(nullable: false, identity: true),
  898. // StandardNo = c.String(maxLength: 50),
  899. // StandardAbbr = c.String(nullable: false, maxLength: 50),
  900. // StandardAbbrName = c.String(nullable: false, maxLength: 50),
  901. // StandardName = c.String(nullable: false, maxLength: 150),
  902. // Rigidity = c.String(maxLength: 250),
  903. // Param = c.String(maxLength: 250),
  904. // Drawing = c.String(),
  905. // Remark = c.String(maxLength: 250),
  906. // IsDeleted = c.Boolean(nullable: false),
  907. // DeleterUserId = c.Long(),
  908. // DeletionTime = c.DateTime(),
  909. // LastModificationTime = c.DateTime(),
  910. // LastModifierUserId = c.Long(),
  911. // CreationTime = c.DateTime(nullable: false),
  912. // CreatorUserId = c.Long(),
  913. // },
  914. // annotations: new Dictionary<string, object>
  915. // {
  916. // { "DynamicFilter_StandardCatalog_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  917. // })
  918. // .PrimaryKey(t => t.Id);
  919. //CreateTable(
  920. // "dbo.StandardDetail",
  921. // c => new
  922. // {
  923. // Id = c.Int(nullable: false, identity: true),
  924. // StandardId = c.Int(nullable: false),
  925. // Specs = c.String(nullable: false, maxLength: 50),
  926. // StandardName = c.String(nullable: false, maxLength: 150),
  927. // InnerDiameter1 = c.Decimal(precision: 18, scale: 2),
  928. // InnerDiameter2 = c.Decimal(precision: 18, scale: 2),
  929. // OutDiameter1 = c.Decimal(precision: 18, scale: 2),
  930. // OutDiameter2 = c.Decimal(precision: 18, scale: 2),
  931. // Thickness1 = c.Decimal(precision: 18, scale: 2),
  932. // Thickness2 = c.Decimal(precision: 18, scale: 2),
  933. // Height1 = c.Decimal(precision: 18, scale: 2),
  934. // Height2 = c.Decimal(precision: 18, scale: 2),
  935. // InnerChamfer1 = c.Decimal(precision: 18, scale: 2),
  936. // InnerChamfer2 = c.Decimal(precision: 18, scale: 2),
  937. // OutChamfer1 = c.Decimal(precision: 18, scale: 2),
  938. // OutChamfer2 = c.Decimal(precision: 18, scale: 2),
  939. // ThousandWeigh = c.Decimal(precision: 18, scale: 2),
  940. // IsDeleted = c.Boolean(nullable: false),
  941. // DeleterUserId = c.Long(),
  942. // DeletionTime = c.DateTime(),
  943. // LastModificationTime = c.DateTime(),
  944. // LastModifierUserId = c.Long(),
  945. // CreationTime = c.DateTime(nullable: false),
  946. // CreatorUserId = c.Long(),
  947. // },
  948. // annotations: new Dictionary<string, object>
  949. // {
  950. // { "DynamicFilter_StandardDetail_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  951. // })
  952. // .PrimaryKey(t => t.Id);
  953. //CreateTable(
  954. // "dbo.StatementBill",
  955. // c => new
  956. // {
  957. // Id = c.Int(nullable: false, identity: true),
  958. // StatementBillNo = c.String(nullable: false, maxLength: 30),
  959. // CustomerId = c.String(nullable: false, maxLength: 30),
  960. // BillMan = c.String(maxLength: 20),
  961. // Description = c.String(maxLength: 4000),
  962. // StatementState = c.Int(),
  963. // OrderStickBillNo = c.String(maxLength: 30),
  964. // LastModificationTime = c.DateTime(),
  965. // LastModifierUserId = c.Long(),
  966. // CreationTime = c.DateTime(nullable: false),
  967. // CreatorUserId = c.Long(),
  968. // })
  969. // .PrimaryKey(t => t.Id)
  970. // .Index(t => t.StatementBillNo, unique: true);
  971. //CreateTable(
  972. // "dbo.N_ViewCurrentRmStoreHouse",
  973. // c => new
  974. // {
  975. // Id = c.String(nullable: false, maxLength: 128),
  976. // ProductionOrderNo = c.String(maxLength: 11),
  977. // StoreHouseId = c.Int(nullable: false),
  978. // StoreLocationNo = c.String(maxLength: 32),
  979. // RmProductNo = c.String(maxLength: 32),
  980. // FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
  981. // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
  982. // Remark = c.String(maxLength: 150),
  983. // PreMonthQuantity = c.Decimal(precision: 18, scale: 3),
  984. // ProductName = c.String(),
  985. // Material = c.String(),
  986. // Model = c.String(),
  987. // ProductDesc = c.String(),
  988. // StoreHouseName = c.String(),
  989. // ProductBatchNum = c.String(),
  990. // IsDeleted = c.Boolean(nullable: false),
  991. // DeleterUserId = c.Long(),
  992. // DeletionTime = c.DateTime(),
  993. // LastModificationTime = c.DateTime(),
  994. // LastModifierUserId = c.Long(),
  995. // CreationTime = c.DateTime(nullable: false),
  996. // CreatorUserId = c.Long(),
  997. // },
  998. // annotations: new Dictionary<string, object>
  999. // {
  1000. // { "DynamicFilter_ViewCurrentRmStoreHouse_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  1001. // })
  1002. // .PrimaryKey(t => t.Id);
  1003. //CreateTable(
  1004. // "dbo.v_SemiProductStoreInfo",
  1005. // c => new
  1006. // {
  1007. // Id = c.String(nullable: false, maxLength: 128),
  1008. // AllQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
  1009. // AllFreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
  1010. // AllPreMonthQuantity = c.Decimal(precision: 18, scale: 2),
  1011. // SemiProductName = c.String(),
  1012. // Model = c.String(),
  1013. // Material = c.String(),
  1014. // SurfaceColor = c.String(),
  1015. // Rigidity = c.String(),
  1016. // PartNo = c.String(),
  1017. // ProductDesc = c.String(),
  1018. // })
  1019. // .PrimaryKey(t => t.Id);
  1020. //CreateTable(
  1021. // "dbo.v_ProductStoreInfo",
  1022. // c => new
  1023. // {
  1024. // ProductNo = c.String(nullable: false, maxLength: 128),
  1025. // AllQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
  1026. // AllFreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
  1027. // AllPreMonthQuantity = c.Decimal(precision: 18, scale: 2),
  1028. // ProductName = c.String(),
  1029. // Model = c.String(),
  1030. // Material = c.String(),
  1031. // SurfaceColor = c.String(),
  1032. // Rigidity = c.String(),
  1033. // PartNo = c.String(),
  1034. // Defprice = c.Decimal(precision: 18, scale: 3),
  1035. // })
  1036. // .PrimaryKey(t => t.ProductNo);
  1037. //CreateTable(
  1038. // "dbo.N_ViewDisqualifiedProduction",
  1039. // c => new
  1040. // {
  1041. // Id = c.Int(nullable: false, identity: true),
  1042. // DisqualifiedNo = c.String(maxLength: 20),
  1043. // ProductOrderNo = c.String(maxLength: 11),
  1044. // ReturnOrderNo = c.String(maxLength: 32),
  1045. // ProductNo = c.String(maxLength: 50),
  1046. // ProductName = c.String(maxLength: 100),
  1047. // ProductType = c.Int(nullable: false),
  1048. // QuantityWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
  1049. // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
  1050. // QuantityPcs = c.Decimal(nullable: false, precision: 18, scale: 3),
  1051. // HandleType = c.Int(nullable: false),
  1052. // CheckUser = c.String(maxLength: 20),
  1053. // CheckDate = c.DateTime(),
  1054. // HandleUser = c.String(maxLength: 20),
  1055. // HandleDate = c.DateTime(),
  1056. // DisqualifiedType = c.Int(),
  1057. // CreationTime = c.DateTime(nullable: false),
  1058. // Model = c.String(),
  1059. // Material = c.String(),
  1060. // SurfaceColor = c.String(),
  1061. // Rigidity = c.String(),
  1062. // })
  1063. // .PrimaryKey(t => t.Id);
  1064. //CreateTable(
  1065. // "dbo.N_ViewDisqualifiedReturn",
  1066. // c => new
  1067. // {
  1068. // Id = c.Int(nullable: false, identity: true),
  1069. // DisqualifiedNo = c.String(maxLength: 20),
  1070. // ProductOrderNo = c.String(maxLength: 11),
  1071. // ReturnOrderNo = c.String(maxLength: 32),
  1072. // ProductNo = c.String(maxLength: 50),
  1073. // ProductName = c.String(maxLength: 100),
  1074. // ProductType = c.Int(nullable: false),
  1075. // QuantityWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
  1076. // KgWeight = c.Decimal(nullable: false, precision: 18, scale: 3),
  1077. // QuantityPcs = c.Decimal(nullable: false, precision: 18, scale: 3),
  1078. // HandleType = c.Int(nullable: false),
  1079. // CheckUser = c.String(maxLength: 20),
  1080. // CheckDate = c.DateTime(),
  1081. // HandleUser = c.String(maxLength: 20),
  1082. // HandleDate = c.DateTime(),
  1083. // DisqualifiedType = c.Int(),
  1084. // CreationTime = c.DateTime(nullable: false),
  1085. // Model = c.String(),
  1086. // Material = c.String(),
  1087. // SurfaceColor = c.String(),
  1088. // Rigidity = c.String(),
  1089. // CustomerId = c.String(),
  1090. // CustomerName = c.String(),
  1091. // })
  1092. // .PrimaryKey(t => t.Id);
  1093. //CreateTable(
  1094. // "dbo.NV_ViewEmployeeInfo",
  1095. // c => new
  1096. // {
  1097. // Id = c.Int(nullable: false, identity: true),
  1098. // No = c.String(),
  1099. // Name = c.String(),
  1100. // CardId = c.String(),
  1101. // Gender = c.Int(nullable: false),
  1102. // PhoneNumber = c.String(),
  1103. // DepartmentNo = c.String(),
  1104. // DepartmentName = c.String(),
  1105. // DutyNo = c.String(),
  1106. // DutyName = c.String(),
  1107. // Description = c.String(),
  1108. // UserName = c.String(),
  1109. // Remark = c.String(),
  1110. // })
  1111. // .PrimaryKey(t => t.Id);
  1112. //CreateTable(
  1113. // "dbo.vEnterOutLogDetail_c",
  1114. // c => new
  1115. // {
  1116. // Id = c.String(nullable: false, maxLength: 128),
  1117. // ActualId = c.Int(nullable: false),
  1118. // EnterOutFlag = c.Int(nullable: false),
  1119. // ProductNo = c.String(),
  1120. // StoreHouseId = c.Int(nullable: false),
  1121. // Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
  1122. // DateTiem = c.DateTime(),
  1123. // UserIDLastMod = c.String(),
  1124. // Remark = c.String(),
  1125. // ProductName = c.String(),
  1126. // Model = c.String(),
  1127. // Material = c.String(),
  1128. // SurfaceColor = c.String(),
  1129. // Rigidity = c.String(),
  1130. // PartNo = c.String(),
  1131. // CustomerId = c.String(),
  1132. // CustomerName = c.String(),
  1133. // ProductionOrderNo = c.String(),
  1134. // })
  1135. // .PrimaryKey(t => t.Id);
  1136. //CreateTable(
  1137. // "dbo.v_Store_Query",
  1138. // c => new
  1139. // {
  1140. // Id = c.String(nullable: false, maxLength: 128),
  1141. // ActualId = c.Int(nullable: false),
  1142. // EnterOutFlag = c.Int(nullable: false),
  1143. // ProductNo = c.String(),
  1144. // StoreHouseId = c.Int(nullable: false),
  1145. // Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
  1146. // DateTiem = c.DateTime(),
  1147. // UserIDLastMod = c.String(),
  1148. // Remark = c.String(),
  1149. // ProductName = c.String(),
  1150. // Model = c.String(),
  1151. // Material = c.String(),
  1152. // SurfaceColor = c.String(),
  1153. // Rigidity = c.String(),
  1154. // PartNo = c.String(),
  1155. // AllQuantity = c.Decimal(precision: 18, scale: 2),
  1156. // AllFreezeQuantity = c.Decimal(precision: 18, scale: 2),
  1157. // AllPreMonthQuantity = c.Decimal(precision: 18, scale: 2),
  1158. // })
  1159. // .PrimaryKey(t => t.Id);
  1160. //CreateTable(
  1161. // "dbo.v_EnterOutSemiProductStore",
  1162. // c => new
  1163. // {
  1164. // Id = c.String(nullable: false, maxLength: 128),
  1165. // ActualId = c.Int(nullable: false),
  1166. // EnterOutFlag = c.Int(nullable: false),
  1167. // SemiProductNo = c.String(),
  1168. // StoreHouseId = c.Int(nullable: false),
  1169. // Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
  1170. // DateTiem = c.DateTime(),
  1171. // UserIDLastMod = c.String(),
  1172. // Remark = c.String(),
  1173. // SemiProductName = c.String(),
  1174. // Model = c.String(),
  1175. // Material = c.String(),
  1176. // SurfaceColor = c.String(),
  1177. // Rigidity = c.String(),
  1178. // PartNo = c.String(),
  1179. // ProductDesc = c.String(),
  1180. // })
  1181. // .PrimaryKey(t => t.Id);
  1182. //CreateTable(
  1183. // "dbo.N_ViewInventoryCheckRecord_Product",
  1184. // c => new
  1185. // {
  1186. // Id = c.String(nullable: false, maxLength: 128),
  1187. // ProductNo = c.String(),
  1188. // ProductName = c.String(),
  1189. // Model = c.String(),
  1190. // Material = c.String(),
  1191. // SurfaceColor = c.String(),
  1192. // Rigidity = c.String(),
  1193. // ProductDesc = c.String(),
  1194. // CheckNo = c.String(),
  1195. // CurrentStoreHouseNo = c.String(),
  1196. // CheckQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
  1197. // StoreQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
  1198. // FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
  1199. // Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
  1200. // StoreLocationNo = c.String(),
  1201. // StoreHouseId = c.Int(nullable: false),
  1202. // ProductionOrderNo = c.String(),
  1203. // LastModificationTime = c.DateTime(),
  1204. // LastModifierUserId = c.Long(),
  1205. // CreationTime = c.DateTime(nullable: false),
  1206. // CreatorUserId = c.Long(),
  1207. // })
  1208. // .PrimaryKey(t => t.Id);
  1209. //CreateTable(
  1210. // "dbo.N_ViewInventoryCheckRecord_Semi",
  1211. // c => new
  1212. // {
  1213. // Id = c.String(nullable: false, maxLength: 128),
  1214. // ProductNo = c.String(),
  1215. // ProductName = c.String(),
  1216. // Model = c.String(),
  1217. // Material = c.String(),
  1218. // SurfaceColor = c.String(),
  1219. // Rigidity = c.String(),
  1220. // ProductDesc = c.String(),
  1221. // CheckNo = c.String(),
  1222. // CurrentStoreHouseNo = c.String(),
  1223. // CheckQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
  1224. // StoreQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
  1225. // FreezeQuantity = c.Decimal(nullable: false, precision: 18, scale: 2),
  1226. // Quantity = c.Decimal(nullable: false, precision: 18, scale: 2),
  1227. // StoreLocationNo = c.String(),
  1228. // StoreHouseId = c.Int(nullable: false),
  1229. // ProductionOrderNo = c.String(),
  1230. // LastModificationTime = c.DateTime(),
  1231. // LastModifierUserId = c.Long(),
  1232. // CreationTime = c.DateTime(nullable: false),
  1233. // CreatorUserId = c.Long(),
  1234. // })
  1235. // .PrimaryKey(t => t.Id);
  1236. //CreateTable(
  1237. // "dbo.N_ViewPackageApply",
  1238. // c => new
  1239. // {
  1240. // Id = c.Int(nullable: false, identity: true),
  1241. // PackageApplyNo = c.String(),
  1242. // CurrentStoreHouseNo = c.String(),
  1243. // ProductionOrderNo = c.String(),
  1244. // SemiProductNo = c.String(),
  1245. // ProductNo = c.String(),
  1246. // ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
  1247. // ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
  1248. // SourceStore = c.Int(nullable: false),
  1249. // ApplyStatus = c.String(),
  1250. // IsClose = c.Boolean(nullable: false),
  1251. // ApplyDate = c.DateTime(),
  1252. // Remark = c.String(),
  1253. // TimeCreated = c.DateTime(),
  1254. // TimeLastMod = c.DateTime(),
  1255. // CreatorUserId = c.String(),
  1256. // UserIDLastMod = c.String(),
  1257. // ProcessingNum = c.Int(nullable: false),
  1258. // IsApplyEnterQuantity = c.Decimal(precision: 18, scale: 2),
  1259. // IsApplyEnterQuantity2 = c.Decimal(precision: 18, scale: 2),
  1260. // KgWeight = c.Decimal(precision: 18, scale: 2),
  1261. // })
  1262. // .PrimaryKey(t => t.Id);
  1263. //CreateTable(
  1264. // "dbo.N_ViewRmEnterStore",
  1265. // c => new
  1266. // {
  1267. // Id = c.String(nullable: false, maxLength: 128),
  1268. // ProductionOrderNo = c.String(nullable: false, maxLength: 11),
  1269. // RmProductNo = c.String(maxLength: 50),
  1270. // StoreHouseId = c.Int(nullable: false),
  1271. // StoreLocationNo = c.String(maxLength: 32),
  1272. // ApplyStatus = c.Int(nullable: false),
  1273. // IsClose = c.Boolean(nullable: false),
  1274. // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
  1275. // ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
  1276. // AuditUser = c.String(maxLength: 32),
  1277. // AuditDate = c.DateTime(),
  1278. // ApplyEnterDate = c.DateTime(),
  1279. // EnterStoreUser = c.String(maxLength: 32),
  1280. // EnterStoreDate = c.DateTime(),
  1281. // Remark = c.String(maxLength: 150),
  1282. // ProductName = c.String(),
  1283. // Material = c.String(),
  1284. // Model = c.String(),
  1285. // ProductDesc = c.String(),
  1286. // StoreHouseName = c.String(),
  1287. // ProductBatchNum = c.String(),
  1288. // CreateSourceType = c.Int(),
  1289. // IsDeleted = c.Boolean(nullable: false),
  1290. // DeleterUserId = c.Long(),
  1291. // DeletionTime = c.DateTime(),
  1292. // LastModificationTime = c.DateTime(),
  1293. // LastModifierUserId = c.Long(),
  1294. // CreationTime = c.DateTime(nullable: false),
  1295. // CreatorUserId = c.Long(),
  1296. // },
  1297. // annotations: new Dictionary<string, object>
  1298. // {
  1299. // { "DynamicFilter_ViewRmEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  1300. // })
  1301. // .PrimaryKey(t => t.Id);
  1302. //CreateTable(
  1303. // "dbo.N_ViewRmOutStore",
  1304. // c => new
  1305. // {
  1306. // Id = c.String(nullable: false, maxLength: 128),
  1307. // ProductionOrderNo = c.String(maxLength: 11),
  1308. // CurrentRmStoreHouseNo = c.String(maxLength: 32),
  1309. // RmProductNo = c.String(maxLength: 50),
  1310. // StoreHouseId = c.Int(nullable: false),
  1311. // ApplyStatus = c.Int(nullable: false),
  1312. // IsClose = c.Boolean(nullable: false),
  1313. // IsConfirm = c.Boolean(),
  1314. // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
  1315. // ActualQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
  1316. // AuditUser = c.String(maxLength: 150),
  1317. // AuditDate = c.DateTime(),
  1318. // OutStoreUser = c.String(maxLength: 150),
  1319. // OutStoreDate = c.DateTime(),
  1320. // ApplyOutDate = c.DateTime(),
  1321. // Remark = c.String(maxLength: 150),
  1322. // ProductName = c.String(),
  1323. // Material = c.String(),
  1324. // Model = c.String(),
  1325. // ProductDesc = c.String(),
  1326. // StoreHouseName = c.String(),
  1327. // ProductBatchNum = c.String(),
  1328. // CreateSourceType = c.Int(),
  1329. // IsDeleted = c.Boolean(nullable: false),
  1330. // DeleterUserId = c.Long(),
  1331. // DeletionTime = c.DateTime(),
  1332. // LastModificationTime = c.DateTime(),
  1333. // LastModifierUserId = c.Long(),
  1334. // CreationTime = c.DateTime(nullable: false),
  1335. // CreatorUserId = c.Long(),
  1336. // },
  1337. // annotations: new Dictionary<string, object>
  1338. // {
  1339. // { "DynamicFilter_ViewRmOutStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  1340. // })
  1341. // .PrimaryKey(t => t.Id);
  1342. //CreateTable(
  1343. // "dbo.N_ViewScrapEnterStore",
  1344. // c => new
  1345. // {
  1346. // Id = c.String(nullable: false, maxLength: 128),
  1347. // ProductionOrderNo = c.String(nullable: false, maxLength: 11),
  1348. // ProductNo = c.String(maxLength: 50),
  1349. // StoreHouseId = c.Int(nullable: false),
  1350. // StoreLocationNo = c.String(maxLength: 32),
  1351. // ApplyStatus = c.Int(nullable: false),
  1352. // IsClose = c.Boolean(nullable: false),
  1353. // Quantity = c.Decimal(nullable: false, precision: 18, scale: 3),
  1354. // ApplyQuantity = c.Decimal(nullable: false, precision: 18, scale: 3),
  1355. // AuditUser = c.String(maxLength: 32),
  1356. // AuditDate = c.DateTime(),
  1357. // ApplyEnterDate = c.DateTime(),
  1358. // EnterStoreUser = c.String(maxLength: 32),
  1359. // EnterStoreDate = c.DateTime(),
  1360. // Remark = c.String(maxLength: 150),
  1361. // ProductName = c.String(),
  1362. // Material = c.String(),
  1363. // Model = c.String(),
  1364. // ProductDesc = c.String(),
  1365. // StoreHouseName = c.String(),
  1366. // SurfaceColor = c.String(),
  1367. // Rigidity = c.String(),
  1368. // ProductType = c.Int(),
  1369. // ScrapSource = c.Int(nullable: false),
  1370. // ScrapSourceNo = c.String(),
  1371. // IsDeleted = c.Boolean(nullable: false),
  1372. // DeleterUserId = c.Long(),
  1373. // DeletionTime = c.DateTime(),
  1374. // LastModificationTime = c.DateTime(),
  1375. // LastModifierUserId = c.Long(),
  1376. // CreationTime = c.DateTime(nullable: false),
  1377. // CreatorUserId = c.Long(),
  1378. // },
  1379. // annotations: new Dictionary<string, object>
  1380. // {
  1381. // { "DynamicFilter_ViewScrapEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  1382. // })
  1383. // .PrimaryKey(t => t.Id);
  1384. //CreateTable(
  1385. // "dbo.N_ViewStatementBill",
  1386. // c => new
  1387. // {
  1388. // Id = c.Int(nullable: false, identity: true),
  1389. // StatementBillNo = c.String(nullable: false, maxLength: 30),
  1390. // CustomerId = c.String(nullable: false, maxLength: 30),
  1391. // BillMan = c.String(maxLength: 20),
  1392. // Description = c.String(maxLength: 4000),
  1393. // StatementState = c.Int(),
  1394. // CustomerName = c.String(),
  1395. // OrderStickBillNo = c.String(),
  1396. // TotalPrice = c.Decimal(precision: 18, scale: 3),
  1397. // AfterTaxTotalPrice = c.Decimal(precision: 18, scale: 3),
  1398. // CurrencyId = c.String(),
  1399. // LastModificationTime = c.DateTime(),
  1400. // LastModifierUserId = c.Long(),
  1401. // CreationTime = c.DateTime(nullable: false),
  1402. // CreatorUserId = c.Long(),
  1403. // })
  1404. // .PrimaryKey(t => t.Id)
  1405. // .Index(t => t.StatementBillNo, unique: true);
  1406. //CreateTable(
  1407. // "dbo.v_OrderStickBill",
  1408. // c => new
  1409. // {
  1410. // OrderStickBillNo = c.String(nullable: false, maxLength: 128),
  1411. // CustomerId = c.String(),
  1412. // CreatDate = c.DateTime(),
  1413. // StickNum = c.String(),
  1414. // StickMan = c.String(),
  1415. // Description = c.String(),
  1416. // TimeCreated = c.DateTime(),
  1417. // CustomerName = c.String(),
  1418. // Address = c.String(),
  1419. // LinkMan = c.String(),
  1420. // TotalPrice = c.Decimal(precision: 18, scale: 3),
  1421. // AfterTaxTotalPrice = c.Decimal(precision: 18, scale: 3),
  1422. // CurrencyId = c.String(),
  1423. // InvoiceState = c.Int(),
  1424. // Amount = c.Decimal(precision: 18, scale: 2),
  1425. // OriginalStickNum = c.String(),
  1426. // ReturnOrderNo = c.String(),
  1427. // OrderNo = c.String(),
  1428. // InvoiceType = c.Int(nullable: false),
  1429. // })
  1430. // .PrimaryKey(t => t.OrderStickBillNo);
  1431. //AddColumn("dbo.BackUpCurrentSemiStoreHouse", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1432. //AddColumn("dbo.CurrentProductStoreHouse", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1433. //AddColumn("dbo.CurrentProductStoreHouse", "PreMonthQuantity", c => c.Decimal(precision: 18, scale: 3));
  1434. //AddColumn("dbo.CurrentProductStoreHouse", "InventoryCheckState", c => c.Int());
  1435. //AddColumn("dbo.CurrentProductStoreHouse", "ReturnState", c => c.Int());
  1436. //AddColumn("dbo.CurrentSemiStoreHouse", "StoreLocationNo", c => c.String(maxLength: 32));
  1437. //AddColumn("dbo.CurrentSemiStoreHouse", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1438. //AddColumn("dbo.CurrentSemiStoreHouse", "PreMonthQuantity", c => c.Decimal(precision: 18, scale: 3));
  1439. //AddColumn("dbo.CurrentSemiStoreHouse", "InventoryCheckState", c => c.Int());
  1440. //AddColumn("dbo.CurrentSemiStoreHouse", "ReturnState", c => c.Int());
  1441. //AddColumn("dbo.CustomerDefaultProduct", "PartNo", c => c.String(maxLength: 30));
  1442. //AddColumn("dbo.Customers", "SaleType", c => c.Int());
  1443. //AddColumn("dbo.FinshedEnterStore", "PackageProductNo", c => c.String(maxLength: 50));
  1444. //AddColumn("dbo.FinshedEnterStore", "SourceStoreHouseId", c => c.Int(nullable: false));
  1445. //AddColumn("dbo.FinshedEnterStore", "ApplySourceType", c => c.Int(nullable: false));
  1446. //AddColumn("dbo.FinshedEnterStore", "ApplyQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1447. //AddColumn("dbo.FinshedEnterStore", "EnterStoreUser", c => c.String(maxLength: 20));
  1448. //AddColumn("dbo.FinshedEnterStore", "EnterStoreDate", c => c.DateTime());
  1449. //AddColumn("dbo.FinshedEnterStore", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1450. //AddColumn("dbo.FinshedEnterStore", "CreateSourceType", c => c.Int());
  1451. //AddColumn("dbo.FinshedEnterStore", "PackageEnterNum", c => c.String());
  1452. //AddColumn("dbo.FinshedEnterStore", "PackageUser", c => c.String(maxLength: 20));
  1453. //AddColumn("dbo.FinshedEnterStore", "VerifyUser", c => c.String(maxLength: 20));
  1454. //AddColumn("dbo.FinshedEnterStore", "ApplyQuantity2", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1455. //AddColumn("dbo.Sys_Users", "AccountNo", c => c.String(maxLength: 20));
  1456. //AddColumn("dbo.OrderHeader", "SaleType", c => c.Int());
  1457. //AddColumn("dbo.OrderHeader", "SaleMan", c => c.String(maxLength: 50));
  1458. //AddColumn("dbo.OrderHeader", "IsLock", c => c.String(maxLength: 1));
  1459. //AddColumn("dbo.OrderItems", "ToCnyRate", c => c.Decimal(precision: 18, scale: 3));
  1460. //AddColumn("dbo.OrderItems", "EmergencyLevel", c => c.Int(nullable: false));
  1461. //AddColumn("dbo.OrderItems", "IsLock", c => c.String(maxLength: 1));
  1462. //AddColumn("dbo.OrderItems", "StandardName", c => c.String(maxLength: 50));
  1463. //AddColumn("dbo.OrderItems", "StoreCompleteState", c => c.Int(nullable: false));
  1464. //AddColumn("dbo.OrderItems", "LogisticsFee", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1465. //AddColumn("dbo.OrderItems", "MoldFee", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1466. //AddColumn("dbo.OrderItems", "LogisticsFeeAfterTax", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1467. //AddColumn("dbo.OrderItems", "MoldFeeAfterTax", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1468. //AddColumn("dbo.OrderSendBills", "ExpressId", c => c.Int());
  1469. //AddColumn("dbo.OrderSendBills", "ExpressBillNo", c => c.String(maxLength: 50));
  1470. //AddColumn("dbo.OrderSend", "CreatorUserId", c => c.String(maxLength: 20));
  1471. //AddColumn("dbo.OrderSend", "StatementBillNo", c => c.String(maxLength: 32));
  1472. //AddColumn("dbo.OrderSend", "LogisticsFee", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1473. //AddColumn("dbo.OrderSend", "MoldFee", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1474. //AddColumn("dbo.OrderSend", "LogisticsFeeAfterTax", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1475. //AddColumn("dbo.OrderSend", "MoldFeeAfterTax", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1476. //AddColumn("dbo.OrderSend", "SendBillSort", c => c.Int(nullable: false));
  1477. //AddColumn("dbo.OrderSend", "StatementBillSort", c => c.Int(nullable: false));
  1478. //AddColumn("dbo.OrderStickBills", "InvoiceState", c => c.Int());
  1479. //AddColumn("dbo.OrderStickBills", "Amount", c => c.Decimal(precision: 18, scale: 2));
  1480. //AddColumn("dbo.OrderStickBills", "OriginalStickNum", c => c.String(maxLength: 30));
  1481. //AddColumn("dbo.OrderStickBills", "ReturnOrderNo", c => c.String(maxLength: 30));
  1482. //AddColumn("dbo.OrderStickBills", "OrderNo", c => c.String(maxLength: 500));
  1483. //AddColumn("dbo.OrderStickBills", "InvoiceType", c => c.Int(nullable: false));
  1484. //AddColumn("dbo.PackageApply", "ProductNo", c => c.String(maxLength: 32));
  1485. //AddColumn("dbo.PackageApply", "SourceStore", c => c.Int(nullable: false));
  1486. //AddColumn("dbo.PackageApply", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1487. //AddColumn("dbo.ProductInspectInfos", "ProductInspectReportNo", c => c.String(nullable: false, maxLength: 32));
  1488. //AddColumn("dbo.ProductInspectInfos", "InspectSubject", c => c.String(maxLength: 50));
  1489. //AddColumn("dbo.ProductionOrders", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1490. //AddColumn("dbo.ProductionOrders", "OutsourcingFactory", c => c.String());
  1491. //AddColumn("dbo.ProductionOrders", "EnterDate", c => c.DateTime());
  1492. //AddColumn("dbo.ProductionOrders", "InspectDate", c => c.DateTime());
  1493. //AddColumn("dbo.ProductionOrders", "HasExported", c => c.Boolean(nullable: false));
  1494. //AddColumn("dbo.ProductionOrders", "MaxQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1495. //AddColumn("dbo.ProductOutStore", "OutStoreUser", c => c.String(maxLength: 20));
  1496. //AddColumn("dbo.ProductOutStore", "OutStoreDate", c => c.DateTime());
  1497. //AddColumn("dbo.ProductOutStore", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1498. //AddColumn("dbo.ProductOutStore", "ApplyOutStoreSourceType", c => c.Int(nullable: false));
  1499. //AddColumn("dbo.ProductOutStore", "CreateSourceType", c => c.Int());
  1500. //AddColumn("dbo.Products", "SpecialDesc", c => c.String(maxLength: 50));
  1501. //AddColumn("dbo.Products", "ModelNo", c => c.String(maxLength: 20));
  1502. //AddColumn("dbo.Products", "MaterialNo", c => c.String(maxLength: 20));
  1503. //AddColumn("dbo.Products", "SurfaceColorNo", c => c.String(maxLength: 20));
  1504. //AddColumn("dbo.Products", "RigidityNo", c => c.String(maxLength: 20));
  1505. //AddColumn("dbo.Products", "SpecialNo", c => c.String(maxLength: 20));
  1506. //AddColumn("dbo.Products", "PrevProductNo", c => c.String(maxLength: 50));
  1507. //AddColumn("dbo.ProductInspectReportContents", "ProductionOrderNo", c => c.String(maxLength: 32));
  1508. //AddColumn("dbo.SemiEnterStore", "EnterStoreUser", c => c.String(maxLength: 20));
  1509. //AddColumn("dbo.SemiEnterStore", "EnterStoreDate", c => c.DateTime());
  1510. //AddColumn("dbo.SemiEnterStore", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1511. //AddColumn("dbo.SemiEnterStore", "CreateSourceType", c => c.Int());
  1512. //AddColumn("dbo.SemiEnterStore", "StoreLocationNo", c => c.String(maxLength: 32));
  1513. //AddColumn("dbo.SemiOutStores", "OutStoreUser", c => c.String(maxLength: 20));
  1514. //AddColumn("dbo.SemiOutStores", "OutStoreDate", c => c.DateTime());
  1515. //AddColumn("dbo.SemiOutStores", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1516. //AddColumn("dbo.SemiOutStores", "CreateSourceType", c => c.Int());
  1517. //AddColumn("dbo.SemiProducts", "SpecialDesc", c => c.String(maxLength: 50));
  1518. //AddColumn("dbo.SemiProducts", "ModelNo", c => c.String(maxLength: 20));
  1519. //AddColumn("dbo.SemiProducts", "MaterialNo", c => c.String(maxLength: 20));
  1520. //AddColumn("dbo.SemiProducts", "SurfaceColorNo", c => c.String(maxLength: 20));
  1521. //AddColumn("dbo.SemiProducts", "RigidityNo", c => c.String(maxLength: 20));
  1522. //AddColumn("dbo.SemiProducts", "SpecialNo", c => c.String(maxLength: 20));
  1523. //AddColumn("dbo.SemiProducts", "PrevProductNo", c => c.String(maxLength: 50));
  1524. //AddColumn("dbo.TemplateInfos", "TempKey", c => c.String(maxLength: 50));
  1525. //AddColumn("dbo.TemplateInfos", "FilePath", c => c.String(maxLength: 300));
  1526. //AddColumn("dbo.TemplateInfos", "FileExt", c => c.String(maxLength: 50));
  1527. //AddColumn("dbo.TemplateInfos", "ClassPath", c => c.String(maxLength: 100));
  1528. //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "ProductDesc", c => c.String());
  1529. //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "PartNo", c => c.String());
  1530. //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1531. //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "PreMonthQuantity", c => c.Decimal(precision: 18, scale: 3));
  1532. //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "InventoryCheckState", c => c.Int());
  1533. //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "ReturnState", c => c.Int());
  1534. //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "StoreAreaCode", c => c.String());
  1535. //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "ShelfNumber", c => c.String());
  1536. //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "ShelfLevel", c => c.String());
  1537. //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "SequenceNo", c => c.String());
  1538. //AddColumn("dbo.N_ViewCurrentProductStoreHouse", "LocationRemark", c => c.String());
  1539. //AddColumn("dbo.N_ViewCurrentSemiStoreHouse", "PartNo", c => c.String());
  1540. //AddColumn("dbo.N_ViewCurrentSemiStoreHouse", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1541. //AddColumn("dbo.N_ViewCurrentSemiStoreHouse", "StoreLocationNo", c => c.String());
  1542. //AddColumn("dbo.N_ViewCurrentSemiStoreHouse", "PreMonthQuantity", c => c.Decimal(precision: 18, scale: 3));
  1543. //AddColumn("dbo.N_ViewCurrentSemiStoreHouse", "InventoryCheckState", c => c.Int());
  1544. //AddColumn("dbo.N_ViewCurrentSemiStoreHouse", "ReturnState", c => c.Int());
  1545. //AddColumn("dbo.N_ViewCurrentSemiStoreHouse", "StoreAreaCode", c => c.String());
  1546. //AddColumn("dbo.N_ViewCurrentSemiStoreHouse", "ShelfNumber", c => c.String());
  1547. //AddColumn("dbo.N_ViewCurrentSemiStoreHouse", "ShelfLevel", c => c.String());
  1548. //AddColumn("dbo.N_ViewCurrentSemiStoreHouse", "SequenceNo", c => c.String());
  1549. //AddColumn("dbo.v_customerstick", "StatementBillNo", c => c.String());
  1550. //AddColumn("dbo.N_ViewOrderItems", "AfterTaxTotalPrice", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1551. //AddColumn("dbo.N_ViewOrderItems", "SaleType", c => c.Int());
  1552. //AddColumn("dbo.N_ViewOrderItems", "SaleMan", c => c.String());
  1553. //AddColumn("dbo.N_ViewOrderItems", "EmergencyLevel", c => c.Int(nullable: false));
  1554. //AddColumn("dbo.N_ViewOrderItems", "IsLock", c => c.String());
  1555. //AddColumn("dbo.N_ViewOrderItems", "StandardName", c => c.String());
  1556. //AddColumn("dbo.N_ViewOrderItems", "StoreCompleteState", c => c.Int(nullable: false));
  1557. //AddColumn("dbo.N_ViewOrderItems", "LogisticsFee", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1558. //AddColumn("dbo.N_ViewOrderItems", "MoldFee", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1559. //AddColumn("dbo.N_ViewOrderItems", "LogisticsFeeAfterTax", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1560. //AddColumn("dbo.N_ViewOrderItems", "MoldFeeAfterTax", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1561. //AddColumn("dbo.v_OrderSendBill", "OrderSendCount", c => c.Int(nullable: false));
  1562. //AddColumn("dbo.v_OrderSendBill", "StatementCount", c => c.Int(nullable: false));
  1563. //AddColumn("dbo.v_OrderSendBill", "ExpressId", c => c.Int());
  1564. //AddColumn("dbo.v_OrderSendBill", "ExpressBillNo", c => c.String());
  1565. //AddColumn("dbo.v_OrderSendBill", "ExpressName", c => c.String());
  1566. //AddColumn("dbo.v_OrderSendBill", "CreatorUserId", c => c.String());
  1567. //AddColumn("dbo.v_OrderSendBill", "TotalPrice", c => c.Decimal(precision: 18, scale: 3));
  1568. //AddColumn("dbo.v_OrderSendBill", "AfterTaxTotalPrice", c => c.Decimal(precision: 18, scale: 3));
  1569. //AddColumn("dbo.v_OrderSendBill", "CurrencyId", c => c.String());
  1570. //AddColumn("dbo.N_ViewOrderSends", "CustomerName", c => c.String());
  1571. //AddColumn("dbo.N_ViewOrderSends", "SaleType", c => c.Int());
  1572. //AddColumn("dbo.N_ViewOrderSends", "AfterTaxPrice", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1573. //AddColumn("dbo.N_ViewOrderSends", "StatementBillNo", c => c.String());
  1574. //AddColumn("dbo.N_ViewOrderSends", "SendActionDate", c => c.DateTime());
  1575. //AddColumn("dbo.N_ViewOrderSends", "StandardName", c => c.String());
  1576. //AddColumn("dbo.N_ViewOrderSends", "LogisticsFee", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1577. //AddColumn("dbo.N_ViewOrderSends", "MoldFee", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1578. //AddColumn("dbo.N_ViewOrderSends", "LogisticsFeeAfterTax", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1579. //AddColumn("dbo.N_ViewOrderSends", "MoldFeeAfterTax", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1580. //AddColumn("dbo.N_ViewOrderSends", "SendBillSort", c => c.Int(nullable: false));
  1581. //AddColumn("dbo.N_ViewOrderSends", "StatementBillSort", c => c.Int(nullable: false));
  1582. //AddColumn("dbo.vwOrderSendBill", "StatementBillNo", c => c.String());
  1583. //AddColumn("dbo.vwOrderSendBill", "CurrencyId", c => c.String());
  1584. //AddColumn("dbo.vwOrderSendBill", "AfterTaxPrice", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1585. //AddColumn("dbo.vwOrderSendBill", "LogisticsFee", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1586. //AddColumn("dbo.vwOrderSendBill", "MoldFee", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1587. //AddColumn("dbo.vwOrderSendBill", "LogisticsFeeAfterTax", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1588. //AddColumn("dbo.vwOrderSendBill", "MoldFeeAfterTax", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1589. //AddColumn("dbo.vwOrderSendBill", "AfterTaxTotalprice", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1590. //AddColumn("dbo.vwOrderSendBill", "SendBillSort", c => c.Int(nullable: false));
  1591. //AddColumn("dbo.vwOrderSendBill", "StatementBillSort", c => c.Int(nullable: false));
  1592. //AddColumn("dbo.N_ViewProductEnterStore", "PackageProductNo", c => c.String(maxLength: 32));
  1593. //AddColumn("dbo.N_ViewProductEnterStore", "ApplySourceType", c => c.Int(nullable: false));
  1594. //AddColumn("dbo.N_ViewProductEnterStore", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1595. //AddColumn("dbo.N_ViewProductEnterStore", "SourceStoreHouseId", c => c.Int(nullable: false));
  1596. //AddColumn("dbo.N_ViewProductEnterStore", "CreateSourceType", c => c.Int());
  1597. //AddColumn("dbo.N_ViewProductEnterStore", "PackageEnterNum", c => c.String());
  1598. //AddColumn("dbo.N_ViewProductOutStore", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1599. //AddColumn("dbo.N_ViewProductOutStore", "ApplyOutStoreSourceType", c => c.Int(nullable: false));
  1600. //AddColumn("dbo.N_ViewProductOutStore", "CreateSourceType", c => c.Int());
  1601. //AddColumn("dbo.N_ViewProductOutStore", "OrderDate", c => c.DateTime());
  1602. //AddColumn("dbo.N_ViewSemiEnterStore", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1603. //AddColumn("dbo.N_ViewSemiEnterStore", "CreateSourceType", c => c.Int());
  1604. //AddColumn("dbo.N_ViewSemiEnterStore", "StoreLocationNo", c => c.String());
  1605. //AddColumn("dbo.N_ViewSemiOutStore", "KgWeight", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1606. //AddColumn("dbo.N_ViewSemiOutStore", "CreateSourceType", c => c.Int());
  1607. //AlterColumn("dbo.BackUpCurrentSemiStoreHouse", "FreezeQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1608. //AlterColumn("dbo.BackUpCurrentSemiStoreHouse", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1609. //AlterColumn("dbo.CurrentProductStoreHouse", "FreezeQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1610. //AlterColumn("dbo.CurrentProductStoreHouse", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1611. //AlterColumn("dbo.CurrentSemiStoreHouse", "FreezeQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1612. //AlterColumn("dbo.CurrentSemiStoreHouse", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1613. //AlterColumn("dbo.FinshedEnterStore", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1614. //AlterColumn("dbo.FinshedEnterStore", "PackageSpecification", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1615. //AlterColumn("dbo.FinshedEnterStore", "PackageCount", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1616. //AlterColumn("dbo.FinshedEnterStore", "ActualPackageCount", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1617. //AlterColumn("dbo.OrderItems", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 3, storeType: "numeric"));
  1618. //AlterColumn("dbo.OrderSend", "SendQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1619. //AlterColumn("dbo.OrderSend", "QuantityPerPack", c => c.Decimal(precision: 18, scale: 3));
  1620. //AlterColumn("dbo.OrderSend", "PackageCount", c => c.Decimal(precision: 18, scale: 3));
  1621. //AlterColumn("dbo.PackageApply", "ApplyQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1622. //AlterColumn("dbo.PackageApply", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1623. //AlterColumn("dbo.ProductionOrders", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1624. //AlterColumn("dbo.ProductionOrders", "EnterQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1625. //AlterColumn("dbo.ProductOutStore", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1626. //AlterColumn("dbo.ProductOutStore", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1627. //AlterColumn("dbo.Products", "TranUnitValue", c => c.Decimal(precision: 18, scale: 3));
  1628. //AlterColumn("dbo.SemiEnterStore", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1629. //AlterColumn("dbo.SemiEnterStore", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1630. //AlterColumn("dbo.SemiOutStores", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1631. //AlterColumn("dbo.SemiOutStores", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1632. //AlterColumn("dbo.SemiProducts", "TranUnitValue", c => c.Decimal(precision: 18, scale: 3));
  1633. //AlterColumn("dbo.SemiProductStore", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 3));
  1634. //AlterColumn("dbo.N_ViewOrderSends", "OrderDate", c => c.DateTime());
  1635. //AlterColumn("dbo.N_ViewOrderSends", "CustomerSendId", c => c.Int());
  1636. //DropColumn("dbo.FinshedEnterStore", "SemiProductNo");
  1637. //DropColumn("dbo.FinshedEnterStore", "ApplySource");
  1638. //DropColumn("dbo.v_OrderSendBill", "StickNum");
  1639. //DropColumn("dbo.v_OrderSendBill", "StickMan");
  1640. //DropColumn("dbo.v_OrderSendBill", "CreatDate");
  1641. //DropColumn("dbo.v_OrderSendBill", "isbill");
  1642. //DropColumn("dbo.N_ViewProductEnterStore", "SemiProductNo");
  1643. //DropColumn("dbo.N_ViewProductEnterStore", "ApplySource");
  1644. //DropTable("dbo.ProductionOrderLogs");
  1645. }
  1646. public override void Down()
  1647. {
  1648. //CreateTable(
  1649. // "dbo.ProductionOrderLogs",
  1650. // c => new
  1651. // {
  1652. // Id = c.Int(nullable: false, identity: true),
  1653. // ProductionOrderNo = c.String(nullable: false, maxLength: 11),
  1654. // OperatorTitle = c.String(maxLength: 150),
  1655. // OperatorConent = c.String(),
  1656. // TimeCreated = c.DateTime(),
  1657. // CreatorUserId = c.String(maxLength: 20),
  1658. // })
  1659. // .PrimaryKey(t => t.Id);
  1660. //AddColumn("dbo.N_ViewProductEnterStore", "ApplySource", c => c.Int(nullable: false));
  1661. //AddColumn("dbo.N_ViewProductEnterStore", "SemiProductNo", c => c.String(maxLength: 32));
  1662. //AddColumn("dbo.v_OrderSendBill", "isbill", c => c.String());
  1663. //AddColumn("dbo.v_OrderSendBill", "CreatDate", c => c.DateTime());
  1664. //AddColumn("dbo.v_OrderSendBill", "StickMan", c => c.String());
  1665. //AddColumn("dbo.v_OrderSendBill", "StickNum", c => c.String());
  1666. //AddColumn("dbo.FinshedEnterStore", "ApplySource", c => c.Int(nullable: false));
  1667. //AddColumn("dbo.FinshedEnterStore", "SemiProductNo", c => c.String(maxLength: 50));
  1668. //DropForeignKey("dbo.ScrapTypeInfo", "LastModifierUserId", "dbo.Sys_Users");
  1669. //DropForeignKey("dbo.ScrapTypeInfo", "DeleterUserId", "dbo.Sys_Users");
  1670. //DropForeignKey("dbo.ScrapTypeInfo", "CreatorUserId", "dbo.Sys_Users");
  1671. //DropForeignKey("dbo.QualityIssueLabelInfo", "LastModifierUserId", "dbo.Sys_Users");
  1672. //DropForeignKey("dbo.QualityIssueLabelInfo", "DeleterUserId", "dbo.Sys_Users");
  1673. //DropForeignKey("dbo.QualityIssueLabelInfo", "CreatorUserId", "dbo.Sys_Users");
  1674. //DropForeignKey("dbo.ProductionOrderLogInfo", "EmployeeId", "dbo.EmployeeInfo");
  1675. //DropForeignKey("dbo.ProductionOrderLogInfo", "CreatorUserId", "dbo.Sys_Users");
  1676. //DropForeignKey("dbo.MoldInfo", "LastModifierUserId", "dbo.Sys_Users");
  1677. //DropForeignKey("dbo.MoldInfo", "DeleterUserId", "dbo.Sys_Users");
  1678. //DropForeignKey("dbo.MoldInfo", "CreatorUserId", "dbo.Sys_Users");
  1679. //DropForeignKey("dbo.MaintenanceRecordInfo", "CreatorUserId", "dbo.Sys_Users");
  1680. //DropForeignKey("dbo.MaintenanceMemberInfo", "EmployeeId", "dbo.EmployeeInfo");
  1681. //DropForeignKey("dbo.MaintenanceMemberInfo", "CreatorUserId", "dbo.Sys_Users");
  1682. //DropForeignKey("dbo.LicenseTypeInfo", "LastModifierUserId", "dbo.Sys_Users");
  1683. //DropForeignKey("dbo.LicenseTypeInfo", "CreatorUserId", "dbo.Sys_Users");
  1684. //DropForeignKey("dbo.LicenseDocumentInfo", "LastModifierUserId", "dbo.Sys_Users");
  1685. //DropForeignKey("dbo.LicenseDocumentInfo", "DeleterUserId", "dbo.Sys_Users");
  1686. //DropForeignKey("dbo.LicenseDocumentInfo", "CreatorUserId", "dbo.Sys_Users");
  1687. //DropForeignKey("dbo.FixedAssetTypeInfo", "LastModifierUserId", "dbo.Sys_Users");
  1688. //DropForeignKey("dbo.FixedAssetTypeInfo", "DeleterUserId", "dbo.Sys_Users");
  1689. //DropForeignKey("dbo.FixedAssetTypeInfo", "CreatorUserId", "dbo.Sys_Users");
  1690. //DropForeignKey("dbo.FixedAssetInfo", "LastModifierUserId", "dbo.Sys_Users");
  1691. //DropForeignKey("dbo.FixedAssetInfo", "DeleterUserId", "dbo.Sys_Users");
  1692. //DropForeignKey("dbo.FixedAssetInfo", "CreatorUserId", "dbo.Sys_Users");
  1693. //DropForeignKey("dbo.ExpressProviderMappers", "ProviderId", "dbo.ExpressServiceProviders");
  1694. //DropForeignKey("dbo.ExpressProviderMappers", "ExpressId", "dbo.ExpressLogistics");
  1695. //DropForeignKey("dbo.EmployeeWorkPerformanceInfo", "EmployeeId", "dbo.EmployeeInfo");
  1696. //DropForeignKey("dbo.EmployeeWorkPerformanceInfo", "CreatorUserId", "dbo.Sys_Users");
  1697. //DropForeignKey("dbo.EmployeeInfo", "LastModifierUserId", "dbo.Sys_Users");
  1698. //DropForeignKey("dbo.EmployeeInfo", "DeleterUserId", "dbo.Sys_Users");
  1699. //DropForeignKey("dbo.EmployeeInfo", "CreatorUserId", "dbo.Sys_Users");
  1700. //DropForeignKey("dbo.DisqualifiedProductInfo", "CreatorUserId", "dbo.Sys_Users");
  1701. //DropForeignKey("dbo.DeviceMgPlanInfo", "LastModifierUserId", "dbo.Sys_Users");
  1702. //DropForeignKey("dbo.DeviceMgPlanInfo", "DeleterUserId", "dbo.Sys_Users");
  1703. //DropForeignKey("dbo.DeviceMgPlanInfo", "CreatorUserId", "dbo.Sys_Users");
  1704. //DropForeignKey("dbo.CustomerDisProductInfo", "CreatorUserId", "dbo.Sys_Users");
  1705. //DropIndex("dbo.N_ViewStatementBill", new[] { "StatementBillNo" });
  1706. //DropIndex("dbo.StatementBill", new[] { "StatementBillNo" });
  1707. //DropIndex("dbo.ScrapTypeInfo", new[] { "CreatorUserId" });
  1708. //DropIndex("dbo.ScrapTypeInfo", new[] { "LastModifierUserId" });
  1709. //DropIndex("dbo.ScrapTypeInfo", new[] { "DeleterUserId" });
  1710. //DropIndex("dbo.ReturnGoodOrder", new[] { "ReturnOrderNo" });
  1711. //DropIndex("dbo.QualityIssueLabelInfo", new[] { "CreatorUserId" });
  1712. //DropIndex("dbo.QualityIssueLabelInfo", new[] { "LastModifierUserId" });
  1713. //DropIndex("dbo.QualityIssueLabelInfo", new[] { "DeleterUserId" });
  1714. //DropIndex("dbo.ProductionOrderLogInfo", new[] { "CreatorUserId" });
  1715. //DropIndex("dbo.ProductionOrderLogInfo", new[] { "EmployeeId" });
  1716. //DropIndex("dbo.MoldInfo", new[] { "CreatorUserId" });
  1717. //DropIndex("dbo.MoldInfo", new[] { "LastModifierUserId" });
  1718. //DropIndex("dbo.MoldInfo", new[] { "DeleterUserId" });
  1719. //DropIndex("dbo.MaintenanceRecordInfo", new[] { "CreatorUserId" });
  1720. //DropIndex("dbo.MaintenanceMemberInfo", new[] { "CreatorUserId" });
  1721. //DropIndex("dbo.MaintenanceMemberInfo", new[] { "EmployeeId" });
  1722. //DropIndex("dbo.LicenseTypeInfo", new[] { "CreatorUserId" });
  1723. //DropIndex("dbo.LicenseTypeInfo", new[] { "LastModifierUserId" });
  1724. //DropIndex("dbo.LicenseDocumentInfo", new[] { "CreatorUserId" });
  1725. //DropIndex("dbo.LicenseDocumentInfo", new[] { "LastModifierUserId" });
  1726. //DropIndex("dbo.LicenseDocumentInfo", new[] { "DeleterUserId" });
  1727. //DropIndex("dbo.FixedAssetTypeInfo", new[] { "CreatorUserId" });
  1728. //DropIndex("dbo.FixedAssetTypeInfo", new[] { "LastModifierUserId" });
  1729. //DropIndex("dbo.FixedAssetTypeInfo", new[] { "DeleterUserId" });
  1730. //DropIndex("dbo.FixedAssetInfo", new[] { "CreatorUserId" });
  1731. //DropIndex("dbo.FixedAssetInfo", new[] { "LastModifierUserId" });
  1732. //DropIndex("dbo.FixedAssetInfo", new[] { "DeleterUserId" });
  1733. //DropIndex("dbo.ExpressProviderMappers", new[] { "ProviderId" });
  1734. //DropIndex("dbo.ExpressProviderMappers", new[] { "ExpressId" });
  1735. //DropIndex("dbo.EmployeeWorkPerformanceInfo", new[] { "CreatorUserId" });
  1736. //DropIndex("dbo.EmployeeWorkPerformanceInfo", new[] { "EmployeeId" });
  1737. //DropIndex("dbo.EmployeeInfo", new[] { "CreatorUserId" });
  1738. //DropIndex("dbo.EmployeeInfo", new[] { "LastModifierUserId" });
  1739. //DropIndex("dbo.EmployeeInfo", new[] { "DeleterUserId" });
  1740. //DropIndex("dbo.DisqualifiedProductInfo", new[] { "CreatorUserId" });
  1741. //DropIndex("dbo.DeviceMgPlanInfo", new[] { "CreatorUserId" });
  1742. //DropIndex("dbo.DeviceMgPlanInfo", new[] { "LastModifierUserId" });
  1743. //DropIndex("dbo.DeviceMgPlanInfo", new[] { "DeleterUserId" });
  1744. //DropIndex("dbo.CustomerDisProductInfo", new[] { "CreatorUserId" });
  1745. //AlterColumn("dbo.N_ViewOrderSends", "CustomerSendId", c => c.Int(nullable: false));
  1746. //AlterColumn("dbo.N_ViewOrderSends", "OrderDate", c => c.DateTime(nullable: false));
  1747. //AlterColumn("dbo.SemiProductStore", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1748. //AlterColumn("dbo.SemiProducts", "TranUnitValue", c => c.Decimal(precision: 18, scale: 2));
  1749. //AlterColumn("dbo.SemiOutStores", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1750. //AlterColumn("dbo.SemiOutStores", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1751. //AlterColumn("dbo.SemiEnterStore", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1752. //AlterColumn("dbo.SemiEnterStore", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1753. //AlterColumn("dbo.Products", "TranUnitValue", c => c.Decimal(precision: 18, scale: 2));
  1754. //AlterColumn("dbo.ProductOutStore", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1755. //AlterColumn("dbo.ProductOutStore", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1756. //AlterColumn("dbo.ProductionOrders", "EnterQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1757. //AlterColumn("dbo.ProductionOrders", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1758. //AlterColumn("dbo.PackageApply", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1759. //AlterColumn("dbo.PackageApply", "ApplyQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1760. //AlterColumn("dbo.OrderSend", "PackageCount", c => c.Decimal(precision: 18, scale: 2));
  1761. //AlterColumn("dbo.OrderSend", "QuantityPerPack", c => c.Decimal(precision: 18, scale: 2));
  1762. //AlterColumn("dbo.OrderSend", "SendQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1763. //AlterColumn("dbo.OrderItems", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 2, storeType: "numeric"));
  1764. //AlterColumn("dbo.FinshedEnterStore", "ActualPackageCount", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1765. //AlterColumn("dbo.FinshedEnterStore", "PackageCount", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1766. //AlterColumn("dbo.FinshedEnterStore", "PackageSpecification", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1767. //AlterColumn("dbo.FinshedEnterStore", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1768. //AlterColumn("dbo.CurrentSemiStoreHouse", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1769. //AlterColumn("dbo.CurrentSemiStoreHouse", "FreezeQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1770. //AlterColumn("dbo.CurrentProductStoreHouse", "Quantity", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1771. //AlterColumn("dbo.CurrentProductStoreHouse", "FreezeQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1772. //AlterColumn("dbo.BackUpCurrentSemiStoreHouse", "ActualQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1773. //AlterColumn("dbo.BackUpCurrentSemiStoreHouse", "FreezeQuantity", c => c.Decimal(nullable: false, precision: 18, scale: 2));
  1774. //DropColumn("dbo.N_ViewSemiOutStore", "CreateSourceType");
  1775. //DropColumn("dbo.N_ViewSemiOutStore", "KgWeight");
  1776. //DropColumn("dbo.N_ViewSemiEnterStore", "StoreLocationNo");
  1777. //DropColumn("dbo.N_ViewSemiEnterStore", "CreateSourceType");
  1778. //DropColumn("dbo.N_ViewSemiEnterStore", "KgWeight");
  1779. //DropColumn("dbo.N_ViewProductOutStore", "OrderDate");
  1780. //DropColumn("dbo.N_ViewProductOutStore", "CreateSourceType");
  1781. //DropColumn("dbo.N_ViewProductOutStore", "ApplyOutStoreSourceType");
  1782. //DropColumn("dbo.N_ViewProductOutStore", "KgWeight");
  1783. //DropColumn("dbo.N_ViewProductEnterStore", "PackageEnterNum");
  1784. //DropColumn("dbo.N_ViewProductEnterStore", "CreateSourceType");
  1785. //DropColumn("dbo.N_ViewProductEnterStore", "SourceStoreHouseId");
  1786. //DropColumn("dbo.N_ViewProductEnterStore", "KgWeight");
  1787. //DropColumn("dbo.N_ViewProductEnterStore", "ApplySourceType");
  1788. //DropColumn("dbo.N_ViewProductEnterStore", "PackageProductNo");
  1789. //DropColumn("dbo.vwOrderSendBill", "StatementBillSort");
  1790. //DropColumn("dbo.vwOrderSendBill", "SendBillSort");
  1791. //DropColumn("dbo.vwOrderSendBill", "AfterTaxTotalprice");
  1792. //DropColumn("dbo.vwOrderSendBill", "MoldFeeAfterTax");
  1793. //DropColumn("dbo.vwOrderSendBill", "LogisticsFeeAfterTax");
  1794. //DropColumn("dbo.vwOrderSendBill", "MoldFee");
  1795. //DropColumn("dbo.vwOrderSendBill", "LogisticsFee");
  1796. //DropColumn("dbo.vwOrderSendBill", "AfterTaxPrice");
  1797. //DropColumn("dbo.vwOrderSendBill", "CurrencyId");
  1798. //DropColumn("dbo.vwOrderSendBill", "StatementBillNo");
  1799. //DropColumn("dbo.N_ViewOrderSends", "StatementBillSort");
  1800. //DropColumn("dbo.N_ViewOrderSends", "SendBillSort");
  1801. //DropColumn("dbo.N_ViewOrderSends", "MoldFeeAfterTax");
  1802. //DropColumn("dbo.N_ViewOrderSends", "LogisticsFeeAfterTax");
  1803. //DropColumn("dbo.N_ViewOrderSends", "MoldFee");
  1804. //DropColumn("dbo.N_ViewOrderSends", "LogisticsFee");
  1805. //DropColumn("dbo.N_ViewOrderSends", "StandardName");
  1806. //DropColumn("dbo.N_ViewOrderSends", "SendActionDate");
  1807. //DropColumn("dbo.N_ViewOrderSends", "StatementBillNo");
  1808. //DropColumn("dbo.N_ViewOrderSends", "AfterTaxPrice");
  1809. //DropColumn("dbo.N_ViewOrderSends", "SaleType");
  1810. //DropColumn("dbo.N_ViewOrderSends", "CustomerName");
  1811. //DropColumn("dbo.v_OrderSendBill", "CurrencyId");
  1812. //DropColumn("dbo.v_OrderSendBill", "AfterTaxTotalPrice");
  1813. //DropColumn("dbo.v_OrderSendBill", "TotalPrice");
  1814. //DropColumn("dbo.v_OrderSendBill", "CreatorUserId");
  1815. //DropColumn("dbo.v_OrderSendBill", "ExpressName");
  1816. //DropColumn("dbo.v_OrderSendBill", "ExpressBillNo");
  1817. //DropColumn("dbo.v_OrderSendBill", "ExpressId");
  1818. //DropColumn("dbo.v_OrderSendBill", "StatementCount");
  1819. //DropColumn("dbo.v_OrderSendBill", "OrderSendCount");
  1820. //DropColumn("dbo.N_ViewOrderItems", "MoldFeeAfterTax");
  1821. //DropColumn("dbo.N_ViewOrderItems", "LogisticsFeeAfterTax");
  1822. //DropColumn("dbo.N_ViewOrderItems", "MoldFee");
  1823. //DropColumn("dbo.N_ViewOrderItems", "LogisticsFee");
  1824. //DropColumn("dbo.N_ViewOrderItems", "StoreCompleteState");
  1825. //DropColumn("dbo.N_ViewOrderItems", "StandardName");
  1826. //DropColumn("dbo.N_ViewOrderItems", "IsLock");
  1827. //DropColumn("dbo.N_ViewOrderItems", "EmergencyLevel");
  1828. //DropColumn("dbo.N_ViewOrderItems", "SaleMan");
  1829. //DropColumn("dbo.N_ViewOrderItems", "SaleType");
  1830. //DropColumn("dbo.N_ViewOrderItems", "AfterTaxTotalPrice");
  1831. //DropColumn("dbo.v_customerstick", "StatementBillNo");
  1832. //DropColumn("dbo.N_ViewCurrentSemiStoreHouse", "SequenceNo");
  1833. //DropColumn("dbo.N_ViewCurrentSemiStoreHouse", "ShelfLevel");
  1834. //DropColumn("dbo.N_ViewCurrentSemiStoreHouse", "ShelfNumber");
  1835. //DropColumn("dbo.N_ViewCurrentSemiStoreHouse", "StoreAreaCode");
  1836. //DropColumn("dbo.N_ViewCurrentSemiStoreHouse", "ReturnState");
  1837. //DropColumn("dbo.N_ViewCurrentSemiStoreHouse", "InventoryCheckState");
  1838. //DropColumn("dbo.N_ViewCurrentSemiStoreHouse", "PreMonthQuantity");
  1839. //DropColumn("dbo.N_ViewCurrentSemiStoreHouse", "StoreLocationNo");
  1840. //DropColumn("dbo.N_ViewCurrentSemiStoreHouse", "KgWeight");
  1841. //DropColumn("dbo.N_ViewCurrentSemiStoreHouse", "PartNo");
  1842. //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "LocationRemark");
  1843. //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "SequenceNo");
  1844. //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "ShelfLevel");
  1845. //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "ShelfNumber");
  1846. //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "StoreAreaCode");
  1847. //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "ReturnState");
  1848. //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "InventoryCheckState");
  1849. //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "PreMonthQuantity");
  1850. //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "KgWeight");
  1851. //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "PartNo");
  1852. //DropColumn("dbo.N_ViewCurrentProductStoreHouse", "ProductDesc");
  1853. //DropColumn("dbo.TemplateInfos", "ClassPath");
  1854. //DropColumn("dbo.TemplateInfos", "FileExt");
  1855. //DropColumn("dbo.TemplateInfos", "FilePath");
  1856. //DropColumn("dbo.TemplateInfos", "TempKey");
  1857. //DropColumn("dbo.SemiProducts", "PrevProductNo");
  1858. //DropColumn("dbo.SemiProducts", "SpecialNo");
  1859. //DropColumn("dbo.SemiProducts", "RigidityNo");
  1860. //DropColumn("dbo.SemiProducts", "SurfaceColorNo");
  1861. //DropColumn("dbo.SemiProducts", "MaterialNo");
  1862. //DropColumn("dbo.SemiProducts", "ModelNo");
  1863. //DropColumn("dbo.SemiProducts", "SpecialDesc");
  1864. //DropColumn("dbo.SemiOutStores", "CreateSourceType");
  1865. //DropColumn("dbo.SemiOutStores", "KgWeight");
  1866. //DropColumn("dbo.SemiOutStores", "OutStoreDate");
  1867. //DropColumn("dbo.SemiOutStores", "OutStoreUser");
  1868. //DropColumn("dbo.SemiEnterStore", "StoreLocationNo");
  1869. //DropColumn("dbo.SemiEnterStore", "CreateSourceType");
  1870. //DropColumn("dbo.SemiEnterStore", "KgWeight");
  1871. //DropColumn("dbo.SemiEnterStore", "EnterStoreDate");
  1872. //DropColumn("dbo.SemiEnterStore", "EnterStoreUser");
  1873. //DropColumn("dbo.ProductInspectReportContents", "ProductionOrderNo");
  1874. //DropColumn("dbo.Products", "PrevProductNo");
  1875. //DropColumn("dbo.Products", "SpecialNo");
  1876. //DropColumn("dbo.Products", "RigidityNo");
  1877. //DropColumn("dbo.Products", "SurfaceColorNo");
  1878. //DropColumn("dbo.Products", "MaterialNo");
  1879. //DropColumn("dbo.Products", "ModelNo");
  1880. //DropColumn("dbo.Products", "SpecialDesc");
  1881. //DropColumn("dbo.ProductOutStore", "CreateSourceType");
  1882. //DropColumn("dbo.ProductOutStore", "ApplyOutStoreSourceType");
  1883. //DropColumn("dbo.ProductOutStore", "KgWeight");
  1884. //DropColumn("dbo.ProductOutStore", "OutStoreDate");
  1885. //DropColumn("dbo.ProductOutStore", "OutStoreUser");
  1886. //DropColumn("dbo.ProductionOrders", "MaxQuantity");
  1887. //DropColumn("dbo.ProductionOrders", "HasExported");
  1888. //DropColumn("dbo.ProductionOrders", "InspectDate");
  1889. //DropColumn("dbo.ProductionOrders", "EnterDate");
  1890. //DropColumn("dbo.ProductionOrders", "OutsourcingFactory");
  1891. //DropColumn("dbo.ProductionOrders", "KgWeight");
  1892. //DropColumn("dbo.ProductInspectInfos", "InspectSubject");
  1893. //DropColumn("dbo.ProductInspectInfos", "ProductInspectReportNo");
  1894. //DropColumn("dbo.PackageApply", "KgWeight");
  1895. //DropColumn("dbo.PackageApply", "SourceStore");
  1896. //DropColumn("dbo.PackageApply", "ProductNo");
  1897. //DropColumn("dbo.OrderStickBills", "InvoiceType");
  1898. //DropColumn("dbo.OrderStickBills", "OrderNo");
  1899. //DropColumn("dbo.OrderStickBills", "ReturnOrderNo");
  1900. //DropColumn("dbo.OrderStickBills", "OriginalStickNum");
  1901. //DropColumn("dbo.OrderStickBills", "Amount");
  1902. //DropColumn("dbo.OrderStickBills", "InvoiceState");
  1903. //DropColumn("dbo.OrderSend", "StatementBillSort");
  1904. //DropColumn("dbo.OrderSend", "SendBillSort");
  1905. //DropColumn("dbo.OrderSend", "MoldFeeAfterTax");
  1906. //DropColumn("dbo.OrderSend", "LogisticsFeeAfterTax");
  1907. //DropColumn("dbo.OrderSend", "MoldFee");
  1908. //DropColumn("dbo.OrderSend", "LogisticsFee");
  1909. //DropColumn("dbo.OrderSend", "StatementBillNo");
  1910. //DropColumn("dbo.OrderSend", "CreatorUserId");
  1911. //DropColumn("dbo.OrderSendBills", "ExpressBillNo");
  1912. //DropColumn("dbo.OrderSendBills", "ExpressId");
  1913. //DropColumn("dbo.OrderItems", "MoldFeeAfterTax");
  1914. //DropColumn("dbo.OrderItems", "LogisticsFeeAfterTax");
  1915. //DropColumn("dbo.OrderItems", "MoldFee");
  1916. //DropColumn("dbo.OrderItems", "LogisticsFee");
  1917. //DropColumn("dbo.OrderItems", "StoreCompleteState");
  1918. //DropColumn("dbo.OrderItems", "StandardName");
  1919. //DropColumn("dbo.OrderItems", "IsLock");
  1920. //DropColumn("dbo.OrderItems", "EmergencyLevel");
  1921. //DropColumn("dbo.OrderItems", "ToCnyRate");
  1922. //DropColumn("dbo.OrderHeader", "IsLock");
  1923. //DropColumn("dbo.OrderHeader", "SaleMan");
  1924. //DropColumn("dbo.OrderHeader", "SaleType");
  1925. //DropColumn("dbo.Sys_Users", "AccountNo");
  1926. //DropColumn("dbo.FinshedEnterStore", "ApplyQuantity2");
  1927. //DropColumn("dbo.FinshedEnterStore", "VerifyUser");
  1928. //DropColumn("dbo.FinshedEnterStore", "PackageUser");
  1929. //DropColumn("dbo.FinshedEnterStore", "PackageEnterNum");
  1930. //DropColumn("dbo.FinshedEnterStore", "CreateSourceType");
  1931. //DropColumn("dbo.FinshedEnterStore", "KgWeight");
  1932. //DropColumn("dbo.FinshedEnterStore", "EnterStoreDate");
  1933. //DropColumn("dbo.FinshedEnterStore", "EnterStoreUser");
  1934. //DropColumn("dbo.FinshedEnterStore", "ApplyQuantity");
  1935. //DropColumn("dbo.FinshedEnterStore", "ApplySourceType");
  1936. //DropColumn("dbo.FinshedEnterStore", "SourceStoreHouseId");
  1937. //DropColumn("dbo.FinshedEnterStore", "PackageProductNo");
  1938. //DropColumn("dbo.Customers", "SaleType");
  1939. //DropColumn("dbo.CustomerDefaultProduct", "PartNo");
  1940. //DropColumn("dbo.CurrentSemiStoreHouse", "ReturnState");
  1941. //DropColumn("dbo.CurrentSemiStoreHouse", "InventoryCheckState");
  1942. //DropColumn("dbo.CurrentSemiStoreHouse", "PreMonthQuantity");
  1943. //DropColumn("dbo.CurrentSemiStoreHouse", "KgWeight");
  1944. //DropColumn("dbo.CurrentSemiStoreHouse", "StoreLocationNo");
  1945. //DropColumn("dbo.CurrentProductStoreHouse", "ReturnState");
  1946. //DropColumn("dbo.CurrentProductStoreHouse", "InventoryCheckState");
  1947. //DropColumn("dbo.CurrentProductStoreHouse", "PreMonthQuantity");
  1948. //DropColumn("dbo.CurrentProductStoreHouse", "KgWeight");
  1949. //DropColumn("dbo.BackUpCurrentSemiStoreHouse", "KgWeight");
  1950. //DropTable("dbo.v_OrderStickBill");
  1951. //DropTable("dbo.N_ViewStatementBill");
  1952. //DropTable("dbo.N_ViewScrapEnterStore",
  1953. // removedAnnotations: new Dictionary<string, object>
  1954. // {
  1955. // { "DynamicFilter_ViewScrapEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  1956. // });
  1957. //DropTable("dbo.N_ViewRmOutStore",
  1958. // removedAnnotations: new Dictionary<string, object>
  1959. // {
  1960. // { "DynamicFilter_ViewRmOutStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  1961. // });
  1962. //DropTable("dbo.N_ViewRmEnterStore",
  1963. // removedAnnotations: new Dictionary<string, object>
  1964. // {
  1965. // { "DynamicFilter_ViewRmEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  1966. // });
  1967. //DropTable("dbo.N_ViewPackageApply");
  1968. //DropTable("dbo.N_ViewInventoryCheckRecord_Semi");
  1969. //DropTable("dbo.N_ViewInventoryCheckRecord_Product");
  1970. //DropTable("dbo.v_EnterOutSemiProductStore");
  1971. //DropTable("dbo.v_Store_Query");
  1972. //DropTable("dbo.vEnterOutLogDetail_c");
  1973. //DropTable("dbo.NV_ViewEmployeeInfo");
  1974. //DropTable("dbo.N_ViewDisqualifiedReturn");
  1975. //DropTable("dbo.N_ViewDisqualifiedProduction");
  1976. //DropTable("dbo.v_ProductStoreInfo");
  1977. //DropTable("dbo.v_SemiProductStoreInfo");
  1978. //DropTable("dbo.N_ViewCurrentRmStoreHouse",
  1979. // removedAnnotations: new Dictionary<string, object>
  1980. // {
  1981. // { "DynamicFilter_ViewCurrentRmStoreHouse_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  1982. // });
  1983. //DropTable("dbo.StatementBill");
  1984. //DropTable("dbo.StandardDetail",
  1985. // removedAnnotations: new Dictionary<string, object>
  1986. // {
  1987. // { "DynamicFilter_StandardDetail_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  1988. // });
  1989. //DropTable("dbo.StandardCatalog",
  1990. // removedAnnotations: new Dictionary<string, object>
  1991. // {
  1992. // { "DynamicFilter_StandardCatalog_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  1993. // });
  1994. //DropTable("dbo.ScrapTypeInfo",
  1995. // removedAnnotations: new Dictionary<string, object>
  1996. // {
  1997. // { "DynamicFilter_ScrapType_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  1998. // });
  1999. //DropTable("dbo.ScrapEnterStore",
  2000. // removedAnnotations: new Dictionary<string, object>
  2001. // {
  2002. // { "DynamicFilter_ScrapEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  2003. // });
  2004. //DropTable("dbo.N_ViewScheduleOrderSend");
  2005. //DropTable("dbo.ScheduleOrderSend");
  2006. //DropTable("dbo.RmProduct",
  2007. // removedAnnotations: new Dictionary<string, object>
  2008. // {
  2009. // { "DynamicFilter_RmProduct_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  2010. // });
  2011. //DropTable("dbo.RmOutStore",
  2012. // removedAnnotations: new Dictionary<string, object>
  2013. // {
  2014. // { "DynamicFilter_RmOutStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  2015. // });
  2016. //DropTable("dbo.RmEnterStore",
  2017. // removedAnnotations: new Dictionary<string, object>
  2018. // {
  2019. // { "DynamicFilter_RmEnterStore_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  2020. // });
  2021. //DropTable("dbo.ReturnGoodOrder",
  2022. // removedAnnotations: new Dictionary<string, object>
  2023. // {
  2024. // { "DynamicFilter_ReturnGoodOrder_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  2025. // });
  2026. //DropTable("dbo.QualityIssueLabelInfo",
  2027. // removedAnnotations: new Dictionary<string, object>
  2028. // {
  2029. // { "DynamicFilter_QualityIssueLabel_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  2030. // });
  2031. //DropTable("dbo.ProductProperties",
  2032. // removedAnnotations: new Dictionary<string, object>
  2033. // {
  2034. // { "DynamicFilter_ProductProperty_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  2035. // });
  2036. //DropTable("dbo.ProductMapper",
  2037. // removedAnnotations: new Dictionary<string, object>
  2038. // {
  2039. // { "DynamicFilter_ProductMapper_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  2040. // });
  2041. //DropTable("dbo.ProductionOrderLogInfo");
  2042. //DropTable("dbo.ProductInspectReportInfos");
  2043. //DropTable("dbo.OutFactory");
  2044. //DropTable("dbo.OrderSendExceed");
  2045. //DropTable("dbo.OrderProduction");
  2046. //DropTable("dbo.MoldInfo",
  2047. // removedAnnotations: new Dictionary<string, object>
  2048. // {
  2049. // { "DynamicFilter_Mold_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  2050. // });
  2051. //DropTable("dbo.MaintenanceRecordInfo");
  2052. //DropTable("dbo.MaintenanceMemberInfo");
  2053. //DropTable("dbo.LicenseTypeInfo");
  2054. //DropTable("dbo.LicenseDocumentInfo",
  2055. // removedAnnotations: new Dictionary<string, object>
  2056. // {
  2057. // { "DynamicFilter_LicenseDocument_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  2058. // });
  2059. //DropTable("dbo.InventoryCheckRecord");
  2060. //DropTable("dbo.InventoryCheck",
  2061. // removedAnnotations: new Dictionary<string, object>
  2062. // {
  2063. // { "DynamicFilter_InventoryCheckInfo_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  2064. // });
  2065. //DropTable("dbo.FixedAssetTypeInfo",
  2066. // removedAnnotations: new Dictionary<string, object>
  2067. // {
  2068. // { "DynamicFilter_FixedAssetType_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  2069. // });
  2070. //DropTable("dbo.FixedAssetInfo",
  2071. // removedAnnotations: new Dictionary<string, object>
  2072. // {
  2073. // { "DynamicFilter_FixedAsset_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  2074. // });
  2075. //DropTable("dbo.ExpressServiceProviders");
  2076. //DropTable("dbo.ExpressProviderMappers");
  2077. //DropTable("dbo.ExpressLogistics");
  2078. //DropTable("dbo.EmployeeWorkPerformanceInfo");
  2079. //DropTable("dbo.EmployeeInfo",
  2080. // removedAnnotations: new Dictionary<string, object>
  2081. // {
  2082. // { "DynamicFilter_Employee_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  2083. // });
  2084. //DropTable("dbo.DisqualifiedProductInfo");
  2085. //DropTable("dbo.DeviceMgPlanInfo",
  2086. // removedAnnotations: new Dictionary<string, object>
  2087. // {
  2088. // { "DynamicFilter_DeviceMgPlan_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  2089. // });
  2090. //DropTable("dbo.CustomerInvoiceAddress",
  2091. // removedAnnotations: new Dictionary<string, object>
  2092. // {
  2093. // { "DynamicFilter_CustomerInvoiceAddress_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  2094. // });
  2095. //DropTable("dbo.CustomerDisProductInfo");
  2096. //DropTable("dbo.CurrentRmStoreHouse",
  2097. // removedAnnotations: new Dictionary<string, object>
  2098. // {
  2099. // { "DynamicFilter_CurrentRmStoreHouse_SoftDelete", "EntityFramework.DynamicFilters.DynamicFilterDefinition" },
  2100. // });
  2101. //DropTable("dbo.CurrencyExchangeRate");
  2102. //DropTable("dbo.Currency");
  2103. //RenameColumn(table: "dbo.PackageApply", name: "CurrentStoreHouseNo", newName: "CurrentSemiStoreHouseNo");
  2104. //RenameTable(name: "dbo.ProductInspectReportContents", newName: "ProductInspectReports");
  2105. }
  2106. }
  2107. }