mo_mes_morder.cs 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327
  1. using Business.Core.Attributes;
  2. using Bussiness.MongoModel;
  3. using Microsoft.EntityFrameworkCore;
  4. using System;
  5. using System.Collections.Generic;
  6. using System.ComponentModel;
  7. using System.ComponentModel.DataAnnotations;
  8. using System.ComponentModel.DataAnnotations.Schema;
  9. using System.Linq;
  10. using System.Text;
  11. using System.Threading.Tasks;
  12. using Volo.Abp;
  13. namespace Bussiness.MongoModel.Production
  14. {
  15. /// <summary>
  16. /// 工单主表
  17. /// </summary>
  18. [CollectionName("dopbang", "mo_mes_morder")]
  19. [Comment("工单主表")]
  20. public class mo_mes_morder : MoBaseEntity
  21. {
  22. ///// <summary>
  23. ///// 生产工单id
  24. ///// </summary>
  25. //[Key]
  26. //[Comment("生产工单id")]
  27. //public long morder_id { get; set; }
  28. /// <summary>
  29. /// 上级工单id
  30. /// </summary>
  31. [Comment("上级工单id")]
  32. public long? parent_id { get; set; }
  33. /// <summary>
  34. /// 关联工单id
  35. /// </summary>
  36. [Comment("关联工单id")]
  37. public long? relation_moid { get; set; }
  38. /// <summary>
  39. /// 关联编号
  40. /// </summary>
  41. [StringLength(50)]
  42. [Comment("关联编号")]
  43. public string? relation_mono { get; set; }
  44. /// <summary>
  45. /// 生产工单编号
  46. /// </summary>
  47. [Required]
  48. [StringLength(50)]
  49. [Comment("生产工单编号")]
  50. public string? morder_no { get; set; }
  51. /// <summary>
  52. /// 生产工单类型(类型:计划工单、销售工单、委外工单、预测工单)
  53. /// </summary>
  54. [StringLength(50)]
  55. [Comment("生产工单类型(类型:计划工单、销售工单、委外工单、预测工单)")]
  56. public string? morder_type { get; set; }
  57. /// <summary>
  58. /// 工单所属物料类型
  59. /// </summary>
  60. [StringLength(255)]
  61. [Comment("工单所属物料类型")]
  62. public string? morder_icitem_type { get; set; }
  63. /// <summary>
  64. /// 工单类型(类型:发货工单、试产工单、备库工单、常规工单、返工工单)
  65. /// </summary>
  66. [StringLength(255)]
  67. [Comment("工单类型(类型:发货工单、试产工单、备库工单、常规工单、返工工单)")]
  68. public string? work_order_type { get; set; }
  69. /// <summary>
  70. /// 生产工单日期
  71. /// </summary>
  72. [Comment("生产工单日期")]
  73. public DateTime? morder_date { get; set; }
  74. /// <summary>
  75. /// 生产工单状态(订单状态:初始,下达,暂停、完成)
  76. /// </summary>
  77. [StringLength(50)]
  78. [Comment("生产工单状态(订单状态:初始,下达,暂停、完成)")]
  79. public string? morder_state { get; set; }
  80. /// <summary>
  81. /// 生产组织id
  82. /// </summary>
  83. [Comment("生产组织id")]
  84. public long? moentry_prd { get; set; }
  85. /// <summary>
  86. /// 生产组织名称
  87. /// </summary>
  88. [StringLength(50)]
  89. [Comment("生产组织名称")]
  90. public string? moentry_prdname { get; set; }
  91. /// <summary>
  92. /// 工作中心id
  93. /// </summary>
  94. [Comment("工作中心id")]
  95. public long? moentry_wrkc { get; set; }
  96. /// <summary>
  97. /// 工作中心名称
  98. /// </summary>
  99. [StringLength(50)]
  100. [Comment("工作中心名称")]
  101. public string? moentry_wrkcname { get; set; }
  102. /// <summary>
  103. /// 计划员工号
  104. /// </summary>
  105. [StringLength(80)]
  106. [Comment("计划员工号")]
  107. public string? planner_num { get; set; }
  108. /// <summary>
  109. /// 计划员名称
  110. /// </summary>
  111. [StringLength(80)]
  112. [Comment("计划员名称")]
  113. public string? planner_name { get; set; }
  114. /// <summary>
  115. /// 生产工单开始日期
  116. /// </summary>
  117. [Comment("生产工单开始日期")]
  118. public DateTime? moentry_stime { get; set; }
  119. /// <summary>
  120. /// 生产工单结束日期
  121. /// </summary>
  122. [Comment("生产工单结束日期")]
  123. public DateTime? moentry_etime { get; set; }
  124. /// <summary>
  125. /// 系统建议开工时间
  126. /// </summary>
  127. [Comment("系统建议开工时间")]
  128. public DateTime? moentry_sys_stime { get; set; }
  129. /// <summary>
  130. /// 系统建议完工时间
  131. /// </summary>
  132. [Comment("系统建议完工时间")]
  133. public DateTime? moentry_sys_etime { get; set; }
  134. /// <summary>
  135. /// 实际开始时间
  136. /// </summary>
  137. [Comment("实际开始时间")]
  138. public DateTime? reality_start_time { get; set; }
  139. /// <summary>
  140. /// 实际结束时间
  141. /// </summary>
  142. [Comment("实际结束时间")]
  143. public DateTime? reality_end_time { get; set; }
  144. /// <summary>
  145. /// 计划员设定开始时间
  146. /// </summary>
  147. [Comment("计划员设定开始时间")]
  148. public DateTime? planner_start_date { get; set; }
  149. /// <summary>
  150. /// 计划员设定结束时间
  151. /// </summary>
  152. [Comment("计划员设定结束时间")]
  153. public DateTime? planner_end_date { get; set; }
  154. /// <summary>
  155. /// 基于物料开始时间
  156. /// </summary>
  157. [Comment("基于物料开始时间")]
  158. public DateTime? mat_start_date { get; set; }
  159. /// <summary>
  160. /// 基于物料结束时间
  161. /// </summary>
  162. [Comment("基于物料结束时间")]
  163. public DateTime? mat_end_date { get; set; }
  164. /// <summary>
  165. /// 产品代码
  166. /// </summary>
  167. [StringLength(80)]
  168. [Comment("产品代码")]
  169. public string? product_code { get; set; }
  170. /// <summary>
  171. /// 产品名称
  172. /// </summary>
  173. [StringLength(500)]
  174. [Comment("产品名称")]
  175. public string? product_name { get; set; }
  176. /// <summary>
  177. /// fms旧料号
  178. /// </summary>
  179. [StringLength(80)]
  180. [Comment("fms旧料号")]
  181. public string? fms_number { get; set; }
  182. /// <summary>
  183. /// 规格型号
  184. /// </summary>
  185. [StringLength(500)]
  186. [Comment("规格型号")]
  187. public string? fmodel { get; set; }
  188. /// <summary>
  189. /// bom编码
  190. /// </summary>
  191. [StringLength(80)]
  192. [Comment("bom编码")]
  193. public string? bom_number { get; set; }
  194. /// <summary>
  195. /// 单位
  196. /// </summary>
  197. [StringLength(80)]
  198. [Comment("单位")]
  199. public string? unit { get; set; }
  200. /// <summary>
  201. /// 工单进度
  202. /// </summary>
  203. [StringLength(1000)]
  204. [Comment("工单进度")]
  205. public string? morder_progress { get; set; }
  206. /// <summary>
  207. /// 工单所需工时
  208. /// </summary>
  209. [Precision(20, 8)]
  210. [Comment("工单所需工时")]
  211. public decimal? morder_need_time { get; set; }
  212. /// <summary>
  213. /// 工单生产数量(计划数量)
  214. /// </summary>
  215. [Precision(20, 8)]
  216. [Comment("工单生产数量(计划数量)")]
  217. public decimal? morder_production_number { get; set; }
  218. /// <summary>
  219. /// 需求数量
  220. /// </summary>
  221. [Precision(20, 8)]
  222. [Comment("需求数量")]
  223. public decimal? need_number { get; set; }
  224. /// <summary>
  225. /// 剩余可用数量
  226. /// </summary>
  227. [Precision(20, 8)]
  228. [Comment("剩余可用数量")]
  229. public decimal? remaining_number { get; set; }
  230. /// <summary>
  231. /// 报工数量
  232. /// </summary>
  233. [Precision(20, 8)]
  234. [Comment("报工数量")]
  235. public decimal? work_number { get; set; }
  236. /// <summary>
  237. /// 报检数量
  238. /// </summary>
  239. [Precision(20, 8)]
  240. [Comment("报检数量")]
  241. public decimal? inspection_number { get; set; }
  242. /// <summary>
  243. /// 合格数量
  244. /// </summary>
  245. [Precision(20, 8)]
  246. [Comment("合格数量")]
  247. public decimal? qualified_number { get; set; }
  248. /// <summary>
  249. /// 入库数量
  250. /// </summary>
  251. [Precision(20, 8)]
  252. [Comment("入库数量")]
  253. public decimal? inventory_number { get; set; }
  254. ///// <summary>
  255. ///// 扩展
  256. ///// </summary>
  257. //public string ext { get; set; }
  258. /// <summary>
  259. /// 已开入库通知单数量
  260. /// </summary>
  261. [Precision(20, 8)]
  262. [Comment("已开入库通知单数量")]
  263. public decimal? notice_qty { get; set; }
  264. /// <summary>
  265. /// 启动状态
  266. /// </summary>
  267. [Comment("启动状态")]
  268. public int? moentry_startup_status { get; set; }
  269. /// <summary>
  270. /// 开始时间
  271. /// </summary>
  272. [Comment("开始时间")]
  273. public DateTime? start_time { get; set; }
  274. /// <summary>
  275. /// 最近暂停时间
  276. /// </summary>
  277. [Comment("最近暂停时间")]
  278. public DateTime? pause_time { get; set; }
  279. /// <summary>
  280. /// 最近重启时间
  281. /// </summary>
  282. [Comment("最近重启时间")]
  283. public DateTime? restart_time { get; set; }
  284. /// <summary>
  285. /// 项目名称
  286. /// </summary>
  287. [StringLength(255)]
  288. [Comment("项目名称")]
  289. public string? project_name { get; set; }
  290. /// <summary>
  291. /// 逾期原因备注
  292. /// </summary>
  293. [StringLength(255)]
  294. [Comment("逾期原因备注")]
  295. public string? overdue_Remark { get; set; }
  296. /// <summary>
  297. /// 已领料数量
  298. /// </summary>
  299. [Precision(20, 8)]
  300. [Comment("已领料数量")]
  301. public decimal? picking_qty { get; set; }
  302. /// <summary>
  303. /// 前状态--计划、下达、完成、关闭
  304. /// </summary>
  305. [StringLength(50)]
  306. [Comment("前状态--计划、下达、完成、关闭")]
  307. public string? morder_fstate { get; set; }
  308. /// <summary>
  309. /// 工单批号--(批号管理的物料出入库要使用)
  310. /// </summary>
  311. [StringLength(100)]
  312. [Comment("工单批号--(批号管理的物料出入库要使用)")]
  313. public string? morder_batchno { get; set; }
  314. /// <summary>
  315. /// 下达日期
  316. /// </summary>
  317. [Comment("下达日期")]
  318. public DateTime? convey_date { get; set; }
  319. /// <summary>
  320. /// 计算ID
  321. /// </summary>
  322. [Comment("计算id")]
  323. [NotMapped]
  324. public long? bang_id { get; set; }
  325. }
  326. }