BomChildExamineDto.cs 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499
  1. using Business.MongoModel.Production;
  2. using Business.MongoModel.SRM;
  3. using Microsoft.EntityFrameworkCore;
  4. using System;
  5. using System.Collections.Generic;
  6. using System.ComponentModel;
  7. using System.ComponentModel.DataAnnotations;
  8. using System.Linq;
  9. using System.Text;
  10. using System.Threading.Tasks;
  11. namespace Business.ResourceExamineManagement.Dto
  12. {
  13. public class BomChildExamineDto
  14. {
  15. /// <summary>
  16. /// 数据库主键
  17. /// </summary>
  18. public long id { get; set; }
  19. /// <summary>
  20. /// 本级id
  21. /// </summary>
  22. public long fid { get; set; }
  23. /// <summary>
  24. /// 父级
  25. /// </summary>
  26. public long? parent_id { get; set; }
  27. /// <summary>
  28. /// bom明细主键
  29. /// </summary>
  30. public long? bom_child_id { get; set; }
  31. /// <summary>
  32. /// 版本
  33. /// </summary>
  34. public string version { get; set; }
  35. /// <summary>
  36. /// bom编号
  37. /// </summary>
  38. public string bom_number { get; set; }
  39. /// <summary>
  40. /// 物料编号
  41. /// </summary>
  42. public string item_number { get; set; }
  43. /// <summary>
  44. /// level
  45. /// </summary>
  46. public int level { get; set; }
  47. /// <summary>
  48. /// 订单行ID
  49. /// </summary>
  50. public long sentry_id { get; set; }
  51. /// <summary>
  52. /// BOMid
  53. /// </summary>
  54. public long? bom_id { get; set; }
  55. /// <summary>
  56. /// 项次号
  57. /// </summary>
  58. public string num { get; set; }
  59. /// <summary>
  60. /// 供排序使用
  61. /// </summary>
  62. public long num_order { get; set; }
  63. /// <summary>
  64. /// 类型 0标准件,1替代件
  65. /// </summary>
  66. public int type { get; set; }
  67. /// <summary>
  68. /// 物料id
  69. /// </summary>
  70. public long item_id { get; set; }
  71. /// <summary>
  72. /// 物料名称
  73. /// </summary>
  74. public string item_name { get; set; }
  75. /// <summary>
  76. /// 规格型号
  77. /// </summary>
  78. public string model { get; set; }
  79. /// <summary>
  80. /// 单位
  81. /// </summary>
  82. public string unit { get; set; }
  83. /// <summary>
  84. /// 物料属性 0.配置类 1.自制 2.委外加工 3.外购 4.虚拟件
  85. /// </summary>
  86. public int erp_cls { get; set; }
  87. /// <summary>
  88. /// 物料属性名称
  89. /// </summary>
  90. public string erp_cls_name { get; set; }
  91. /// <summary>
  92. /// 是否倒冲
  93. /// </summary>
  94. public int backflush { get; set; }
  95. /// <summary>
  96. /// 单位用量
  97. /// </summary>
  98. public decimal qty { get; set; }
  99. /// <summary>
  100. /// 库存数量
  101. /// </summary>
  102. public decimal sqty { get; set; }
  103. /// <summary>
  104. /// 库存占用数量
  105. /// </summary>
  106. public decimal use_qty { get; set; }
  107. /// <summary>
  108. /// 本级缺料数量
  109. /// </summary>
  110. public decimal self_lack_qty { get; set; }
  111. /// <summary>
  112. /// 缺料数量
  113. /// </summary>
  114. public decimal lack_qty { get; set; }
  115. /// <summary>
  116. /// 在制占用数量
  117. /// </summary>
  118. public decimal mo_qty { get; set; }
  119. /// <summary>
  120. /// 在制工单占用明细
  121. /// </summary>
  122. public List<mo_occupy> mo_occupy_list { get; set; }
  123. /// <summary>
  124. /// 自制数量
  125. /// </summary>
  126. public decimal make_qty { get; set; }
  127. /// <summary>
  128. /// 自制工单明细
  129. /// </summary>
  130. public List<moorder> make_list { get; set; }
  131. /// <summary>
  132. /// 采购数量
  133. /// </summary>
  134. public decimal purchase_qty { get; set; }
  135. /// <summary>
  136. /// 采购明细
  137. /// </summary>
  138. public List<purchase> purchase_list { get; set; }
  139. /// <summary>
  140. /// 采购明细占用数量
  141. /// </summary>
  142. public decimal purchase_occupy_qty { get; set; }
  143. /// <summary>
  144. /// 采购占用明细
  145. /// </summary>
  146. public List<purchase_occupy> purchase_occupy_list { get; set; }
  147. /// <summary>
  148. /// 委外数量
  149. /// </summary>
  150. public decimal subcontracting_qty { get; set; }
  151. /// <summary>
  152. /// 委外工单明细
  153. /// </summary>
  154. public List<ooder> subcontracting_list { get; set; }
  155. /// <summary>
  156. /// 齐套时间
  157. /// </summary>
  158. public DateTime? kitting_time { get; set; }
  159. /// <summary>
  160. /// 满足时间
  161. /// </summary>
  162. public DateTime? satisfy_time { get; set; }
  163. /// <summary>
  164. /// 自制时长(天)
  165. /// </summary>
  166. public int? make_time { get; set; }
  167. /// <summary>
  168. /// 采购前置(需加上自制)
  169. /// </summary>
  170. public int? pre_time { get; set; }
  171. /// <summary>
  172. /// 是否BOM
  173. /// </summary>
  174. public int isbom { get; set; }
  175. /// <summary>
  176. /// 存在替代关系
  177. /// </summary>
  178. public int haveicsubs { get; set; }
  179. /// <summary>
  180. /// 群组代码
  181. /// </summary>
  182. public string substitute_code { get; set; }
  183. /// <summary>
  184. /// 是否群组替代
  185. /// </summary>
  186. public int is_replace { get; set; }
  187. /// <summary>
  188. /// 群组ids
  189. /// </summary>
  190. public string icitem_ids { get; set; }
  191. /// <summary>
  192. /// 群组优先级
  193. /// </summary>
  194. public int? substitute_all_num { get; set; }
  195. /// <summary>
  196. /// 替代策略
  197. /// </summary>
  198. public int substitute_strategy { get; set; }
  199. /// <summary>
  200. /// 替代方式
  201. /// </summary>
  202. public int substitute_mode { get; set; }
  203. /// <summary>
  204. /// 物料状态-- -1.无需求 0.缺料 1.充足 2.可制,时间满足 3.可制,时间不满足 4.采购 5.委外
  205. /// </summary>
  206. public int stock_state { get; set; }
  207. /// <summary>
  208. /// 单个产品总需要用量
  209. /// </summary>
  210. public decimal needCount { get; set; }
  211. /// <summary>
  212. /// 是否使用此物料
  213. /// </summary>
  214. public bool is_use { get; set; }
  215. }
  216. /// <summary>
  217. /// 生产工单信息
  218. /// </summary>
  219. public class moorder
  220. {
  221. /// <summary>
  222. /// 主键
  223. /// </summary>
  224. public long? Id { get; set; }
  225. /// <summary>
  226. /// 生产工单编号
  227. /// </summary>
  228. public string? morder_no { get; set; }
  229. /// <summary>
  230. /// 生产组织名称
  231. /// </summary>
  232. public string? moentry_prdname { get; set; }
  233. /// <summary>
  234. /// 工作中心名称
  235. /// </summary>
  236. public string? moentry_wrkcname { get; set; }
  237. /// <summary>
  238. /// 生产工单开始日期
  239. /// </summary>
  240. public DateTime? moentry_stime { get; set; }
  241. /// <summary>
  242. /// 生产工单结束日期
  243. /// </summary>
  244. public DateTime? moentry_etime { get; set; }
  245. /// <summary>
  246. /// 系统建议开工时间
  247. /// </summary>
  248. public DateTime? moentry_sys_stime { get; set; }
  249. /// <summary>
  250. /// 系统建议完工时间
  251. /// </summary>
  252. public DateTime? moentry_sys_etime { get; set; }
  253. /// <summary>
  254. /// 实际开始时间
  255. /// </summary>
  256. public DateTime? reality_start_time { get; set; }
  257. /// <summary>
  258. /// 实际结束时间
  259. /// </summary>
  260. public DateTime? reality_end_time { get; set; }
  261. /// <summary>
  262. /// 工单所需工时
  263. /// </summary>
  264. public decimal? morder_need_time { get; set; }
  265. /// <summary>
  266. /// 工单生产数量(计划数量)
  267. /// </summary>
  268. public decimal? morder_production_number { get; set; }
  269. /// <summary>
  270. /// 需求数量
  271. /// </summary>
  272. public decimal? need_number { get; set; }
  273. }
  274. /// <summary>
  275. /// 在制占用明细
  276. /// </summary>
  277. public class mo_occupy
  278. {
  279. /// <summary>
  280. /// 主键
  281. /// </summary>
  282. public long? id { get; set; }
  283. /// <summary>
  284. /// 工单号
  285. /// </summary>
  286. public string? moo_mo { get; set; }
  287. /// <summary>
  288. /// 占用量
  289. /// </summary>
  290. public decimal? moo_qty { get; set; }
  291. /// <summary>
  292. /// 开始时间
  293. /// </summary>
  294. public DateTime? moo_stime { get; set; }
  295. /// <summary>
  296. /// 结束时间
  297. /// </summary>
  298. public DateTime? moo_etime { get; set; }
  299. }
  300. /// <summary>
  301. /// 采购明细信息
  302. /// </summary>
  303. public class purchase
  304. {
  305. /// <summary>
  306. /// 主键
  307. /// </summary>
  308. public long? Id { get; set; }
  309. /// <summary>
  310. /// pr单号
  311. /// </summary>
  312. public string? pr_billno { get; set; }
  313. /// <summary>
  314. /// 供应商编码
  315. /// </summary>
  316. public string? pr_purchasenumber { get; set; }
  317. /// <summary>
  318. /// 供应商名称
  319. /// </summary>
  320. public string? pr_purchasename { get; set; }
  321. /// <summary>
  322. /// 需求数量
  323. /// </summary>
  324. public decimal? pr_rqty { get; set; }
  325. /// <summary>
  326. /// 申请数量
  327. /// </summary>
  328. public decimal? pr_aqty { get; set; }
  329. /// <summary>
  330. /// 建议数量
  331. /// </summary>
  332. public decimal? pr_sqty { get; set; }
  333. /// <summary>
  334. /// 计划到达日期
  335. /// </summary>
  336. public DateTime? pr_parrive_date { get; set; }
  337. /// <summary>
  338. /// 需求到货日期
  339. /// </summary>
  340. public DateTime? pr_rarrive_date { get; set; }
  341. /// <summary>
  342. /// 采购确认到货日期
  343. /// </summary>
  344. public DateTime? pr_pur_affirm_date { get; set; }
  345. /// <summary>
  346. /// 系统价格(含税)
  347. /// </summary>
  348. public decimal? pr_sysprice { get; set; }
  349. /// <summary>
  350. /// 订单价格(含税)
  351. /// </summary>
  352. public decimal? pr_orderprice { get; set; }
  353. /// <summary>
  354. /// 采购净价(不含税)
  355. /// </summary>
  356. public decimal? pr_price { get; set; }
  357. /// <summary>
  358. /// 税率
  359. /// </summary>
  360. public decimal? pr_rate { get; set; }
  361. public bool isbestoptions { get; set; }
  362. }
  363. /// <summary>
  364. /// 采购占用明细
  365. /// </summary>
  366. public class purchase_occupy
  367. {
  368. /// <summary>
  369. /// 主键
  370. /// </summary>
  371. public long? id { get; set; }
  372. /// <summary>
  373. /// 采购订单单号
  374. /// </summary>
  375. public string? po_billno { get; set; }
  376. /// <summary>
  377. /// 类型
  378. /// </summary>
  379. public string? type { get; set; }
  380. /// <summary>
  381. /// 占用量
  382. /// </summary>
  383. public decimal? qty { get; set; }
  384. /// <summary>
  385. /// 开始时间
  386. /// </summary>
  387. public DateTime? stime { get; set; }
  388. /// <summary>
  389. /// 结束时间
  390. /// </summary>
  391. public DateTime? etime { get; set; }
  392. }
  393. /// <summary>
  394. /// 委外工单信息
  395. /// </summary>
  396. public class ooder {
  397. /// <summary>
  398. /// 主键
  399. /// </summary>
  400. public long? Id { get; set; }
  401. /// <summary>
  402. /// 工单编号
  403. /// </summary>
  404. public string? oorder_no { get; set; }
  405. /// <summary>
  406. /// 委外订单日期
  407. /// </summary>
  408. public DateTime? oorder_date { get; set; }
  409. /// <summary>
  410. /// 生产组织名称
  411. /// </summary>
  412. public string? ooentry_prdname { get; set; }
  413. /// <summary>
  414. /// 计划开工日期
  415. /// </summary>
  416. public DateTime? ooentry_stime { get; set; }
  417. /// <summary>
  418. /// 计划完工日期
  419. /// </summary>
  420. public DateTime? ooentry_etime { get; set; }
  421. /// <summary>
  422. /// 工单生产数量(计划数量)
  423. /// </summary>
  424. public decimal? morder_production_number { get; set; }
  425. /// <summary>
  426. /// 加工单位
  427. /// </summary>
  428. public string? production_unit { get; set; }
  429. /// <summary>
  430. /// 加工单位编码
  431. /// </summary>
  432. public string? production_unit_code { get; set; }
  433. }
  434. }