mo_mes_oorder.cs 7.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245
  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. namespace Bussiness.MongoModel.Production
  13. {
  14. /// <summary>
  15. /// 委外订单表
  16. /// </summary>
  17. [CollectionName("dopbang", "mo_mes_oorder")]
  18. [Comment("委外订单表")]
  19. public class mo_mes_oorder : MoBaseEntity
  20. {
  21. ///// <summary>
  22. ///// 委外订单id
  23. ///// </summary>
  24. //[Key]
  25. //[Comment("委外订单id")]
  26. //public long oorder_id { get; set; }
  27. /// <summary>
  28. /// 生产工单编号
  29. /// </summary>
  30. [StringLength(50)]
  31. [Comment("生产工单编号")]
  32. public string? oorder_no { get; set; }
  33. /// <summary>
  34. /// 生产工单类型
  35. /// </summary>
  36. [StringLength(80)]
  37. [Comment("生产工单类型")]
  38. public string? oorder_type { get; set; }
  39. /// <summary>
  40. /// 委外订单日期
  41. /// </summary>
  42. [Comment("委外订单日期")]
  43. public DateTime? oorder_date { get; set; }
  44. /// <summary>
  45. /// 订单状态
  46. /// </summary>
  47. [StringLength(50)]
  48. [Comment("订单状态")]
  49. public string? oorder_state { get; set; }
  50. /// <summary>
  51. /// 生产组织
  52. /// </summary>
  53. [Comment("生产组织")]
  54. public long? ooentry_prd { get; set; }
  55. /// <summary>
  56. /// 生产组织名称
  57. /// </summary>
  58. [StringLength(50)]
  59. [Comment("生产组织名称")]
  60. public string? ooentry_prdname { get; set; }
  61. /// <summary>
  62. /// 工作中心id
  63. /// </summary>
  64. [Comment("工作中心id")]
  65. public long? ooentry_wrkc { get; set; }
  66. /// <summary>
  67. /// 工作中心名称
  68. /// </summary>
  69. [StringLength(50)]
  70. [Comment("工作中心名称")]
  71. public string? ooentry_wrkcname { get; set; }
  72. /// <summary>
  73. /// 计划员工号
  74. /// </summary>
  75. [StringLength(80)]
  76. [Comment("计划员工号")]
  77. public string? planner_num { get; set; }
  78. /// <summary>
  79. /// 计划员名称
  80. /// </summary>
  81. [StringLength(80)]
  82. [Comment("计划员名称")]
  83. public string? planner_name { get; set; }
  84. /// <summary>
  85. /// 计划开工日期
  86. /// </summary>
  87. [Comment("计划开工日期")]
  88. public DateTime? ooentry_stime { get; set; }
  89. /// <summary>
  90. /// 计划完工日期
  91. /// </summary>
  92. [Comment("计划完工日期")]
  93. public DateTime? ooentry_etime { get; set; }
  94. /// <summary>
  95. /// 产品代码
  96. /// </summary>
  97. [StringLength(80)]
  98. [Comment("产品代码")]
  99. public string? product_code { get; set; }
  100. /// <summary>
  101. /// fms旧料号
  102. /// </summary>
  103. [StringLength(80)]
  104. [Comment("fms旧料号")]
  105. public string? ffms_number { get; set; }
  106. /// <summary>
  107. /// 产品名称
  108. /// </summary>
  109. [StringLength(500)]
  110. [Comment("产品名称")]
  111. public string? product_name { get; set; }
  112. /// <summary>
  113. /// 规格型号
  114. /// </summary>
  115. [StringLength(500)]
  116. [Comment("规格型号")]
  117. public string? specification_model { get; set; }
  118. /// <summary>
  119. /// bom编码
  120. /// </summary>
  121. [StringLength(80)]
  122. [Comment("bom编码")]
  123. public string? bom_number { get; set; }
  124. /// <summary>
  125. /// 单位
  126. /// </summary>
  127. [StringLength(80)]
  128. [Comment("单位")]
  129. public string? unit { get; set; }
  130. /// <summary>
  131. /// 工单进度
  132. /// </summary>
  133. [StringLength(500)]
  134. [Comment("工单进度")]
  135. public string? morder_progress { get; set; }
  136. /// <summary>
  137. /// 工单生产数量(计划数量)
  138. /// </summary>
  139. [Precision(20, 10)]
  140. [Comment("工单生产数量(计划数量)")]
  141. public decimal? morder_production_number { get; set; }
  142. /// <summary>
  143. /// 需求数量
  144. /// </summary>
  145. [Precision(20, 10)]
  146. [Comment("需求数量")]
  147. public decimal? need_number { get; set; }
  148. /// <summary>
  149. /// 剩余可用数量
  150. /// </summary>
  151. [Precision(20, 10)]
  152. [Comment("剩余可用数量")]
  153. public decimal? remaining_number { get; set; }
  154. /// <summary>
  155. /// 报工数量
  156. /// </summary>
  157. [Precision(20, 8)]
  158. [Comment("报工数量")]
  159. public decimal? work_number { get; set; }
  160. /// <summary>
  161. /// 报检数量
  162. /// </summary>
  163. [Precision(20, 8)]
  164. [Comment("报检数量")]
  165. public decimal? inspection_number { get; set; }
  166. /// <summary>
  167. /// 合格数量
  168. /// </summary>
  169. [Precision(20, 8)]
  170. [Comment("合格数量")]
  171. public decimal? qualified_number { get; set; }
  172. /// <summary>
  173. /// 入库数量
  174. /// </summary>
  175. [Precision(20, 8)]
  176. [Comment("入库数量")]
  177. public decimal? inventory_number { get; set; }
  178. /// <summary>
  179. /// 已开通知单数量
  180. /// </summary>
  181. [Precision(20, 8)]
  182. [Comment("已开通知单数量")]
  183. public decimal? notice_qty { get; set; }
  184. /// <summary>
  185. /// 启动状态
  186. /// </summary>
  187. [Comment("启动状态")]
  188. public int? moentry_on { get; set; }
  189. /// <summary>
  190. /// 开始时间
  191. /// </summary>
  192. [Comment("开始时间")]
  193. public DateTime? start_time { get; set; }
  194. /// <summary>
  195. /// 最近暂停时间
  196. /// </summary>
  197. [Comment("最近暂停时间")]
  198. public DateTime? pause_time { get; set; }
  199. /// <summary>
  200. /// 最近重启时间
  201. /// </summary>
  202. [Comment("最近重启时间")]
  203. public DateTime? restart_time { get; set; }
  204. ///// <summary>
  205. ///// 扩展
  206. ///// </summary>
  207. //public string ext { get; set; }
  208. /// <summary>
  209. /// 项目名称
  210. /// </summary>
  211. [StringLength(255)]
  212. [Comment("项目名称")]
  213. public string? project_name { get; set; }
  214. /// <summary>
  215. /// 发料状态 1-待发料 2-已发料
  216. /// </summary>
  217. [Comment("发料状态 1-待发料 2-已发料")]
  218. public int? sent_status { get; set; }
  219. /// <summary>
  220. /// 加工单位
  221. /// </summary>
  222. [StringLength(100)]
  223. [Comment("加工单位")]
  224. public string? production_unit { get; set; }
  225. /// <summary>
  226. /// 加工单位编码
  227. /// </summary>
  228. [StringLength(20)]
  229. [Comment("加工单位编码")]
  230. public string? production_unit_code { get; set; }
  231. /// <summary>
  232. /// 所需物料是否充足 1-充足 0-缺料
  233. /// </summary>
  234. [Comment("所需物料是否充足 1-充足 0-缺料")]
  235. public int? need_icitem_status { get; set; }
  236. /// <summary>
  237. /// 计算ID
  238. /// </summary>
  239. [Comment("计算id")]
  240. [NotMapped]
  241. public long? bang_id { get; set; }
  242. }
  243. }