sqe_oqc_statistics.cs 3.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Text;
  4. using Business.Core.Attributes;
  5. using System.IO;
  6. namespace Business.StructuredDB.Sqe
  7. {
  8. /// <summary>
  9. /// OQC统计
  10. /// </summary>
  11. public class sqe_oqc_statistics
  12. {
  13. /// <summary>
  14. /// 流水号主键
  15. /// </summary>
  16. public Int64 id { get; set; }
  17. /// <summary>
  18. /// Data主键
  19. /// </summary>
  20. public Int64 data_id { get; set; }
  21. /// <summary>
  22. /// OQC标识
  23. /// </summary>
  24. public Int64 oqc_id { get; set; }
  25. /// <summary>
  26. /// 统计起始日期
  27. /// </summary>
  28. public DateTime ? start_date { get; set; }
  29. /// <summary>
  30. /// 统计结束日期
  31. /// </summary>
  32. public DateTime ? end_date { get; set; }
  33. /// <summary>
  34. /// 供应商编码
  35. /// </summary>
  36. public string supp_no { get; set; }
  37. /// <summary>
  38. /// 物料名称
  39. /// </summary>
  40. public string item_name { get; set; }
  41. /// <summary>
  42. /// 物料号
  43. /// </summary>
  44. public string item_no { get; set; }
  45. /// <summary>
  46. /// 物料版本号
  47. /// </summary>
  48. public string item_version { get; set; }
  49. /// <summary>
  50. /// 日期
  51. /// </summary>
  52. public DateTime ? product_time { get; set; }
  53. /// <summary>
  54. /// 批次号
  55. /// </summary>
  56. public string batch_no { get; set; }
  57. /// <summary>
  58. /// 批次数量
  59. /// </summary>
  60. [DecimalPrecision(18, 5)]
  61. public decimal batch_qty { get; set; }
  62. /// <summary>
  63. /// 检验人员
  64. /// </summary>
  65. public string test_person { get; set; }
  66. /// <summary>
  67. /// 抽样标准
  68. /// </summary>
  69. public string sampling_standard { get; set; }
  70. /// <summary>
  71. /// 抽样数量
  72. /// </summary>
  73. [DecimalPrecision(18, 5)]
  74. public decimal sampling_number { get; set; }
  75. /// <summary>
  76. /// 检验项目
  77. /// </summary>
  78. public string standard_no { get; set; }
  79. /// <summary>
  80. /// 均值
  81. /// </summary>
  82. [DecimalPrecision(18, 5)]
  83. public decimal value_avg { get; set; }
  84. /// <summary>
  85. /// 标准差
  86. /// </summary>
  87. [DecimalPrecision(18, 5)]
  88. public decimal value_std_range { get; set; }
  89. /// <summary>
  90. /// PP
  91. /// </summary>
  92. [DecimalPrecision(18, 5)]
  93. public decimal value_pp { get; set; }
  94. /// <summary>
  95. /// PPK
  96. /// </summary>
  97. [DecimalPrecision(18, 5)]
  98. public decimal value_ppk { get; set; }
  99. /// <summary>
  100. /// Max
  101. /// </summary>
  102. [DecimalPrecision(18, 5)]
  103. public decimal value_max { get; set; }
  104. /// <summary>
  105. /// Min
  106. /// </summary>
  107. [DecimalPrecision(18, 5)]
  108. public decimal value_min { get; set; }
  109. /// <summary>
  110. /// 极差
  111. /// </summary>
  112. [DecimalPrecision(18, 5)]
  113. public decimal value_range { get; set; }
  114. }
  115. }