You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

366 lines
31 KiB

  1. #### 入库备件
  2. #### WM_GoodsReceiptHead
  3. ```go
  4. type GoodsReceiptHead struct {
  5. GoodsReceiptId string `xorm:"pk nvarchar(40) 'GoodsReceiptId'" json:"WM_GoodsReceiptHead-GoodsReceiptId"` //入库流水号
  6. RefOrderId string `xorm:"nvarchar(100) 'RefOrderId' not null" json:"WM_GoodsReceiptHead-RefOrderId"` //入库单号
  7. GRWarehouseId string `xorm:"nvarchar(40) 'GRWarehouseId' not null" json:"WM_GoodsReceiptHead-GRWarehouseId"` //库房id
  8. Remark string `xorm:"nvarchar(255) 'Remark' not null" json:"WM_GoodsReceiptHead-Remark"`//备注
  9. DemandDate grmi.Date `xorm:"date 'DemandDate' not null" json:"WM_GoodsReceiptHead-DemandDate"`// 需求日期
  10. RegisterDate grmi.Date `xorm:"date 'RegisterDate' not null" json:"WM_GoodsReceiptHead-RegisterDate"`// 注册日期
  11. Status string `xorm:"nvarchar(3) 'Status' not null" json:"WM_GoodsReceiptHead-Status"`//状态
  12. SupplierId string `xorm:"nvarchar(40) 'SupplierId' not null" json:"WM_GoodsReceiptHead-SupplierId"`//供应商id
  13. SupplierName string `xorm:"nvarchar(100) 'SupplierName' not null" json:"WM_GoodsReceiptHead-SupplierName"`//供应商名称
  14. GRType string `xorm:"nvarchar(40) 'GRType' not null" json:"WM_GoodsReceiptHead-GRType"`//文本
  15. GRType1 string `xorm:"nvarchar(40) 'GRType1' not null" json:"WM_GoodsReceiptHead-GRType1"`//文本1
  16. GRType2 string `xorm:"nvarchar(40) 'GRType2' not null" json:"WM_GoodsReceiptHead-GRType2"`//文本2
  17. GRReason string `xorm:"nvarchar(255) 'GRReason' not null" json:"WM_GoodsReceiptHead-GRReason"`// 入库描述
  18. OrderedQty float64 `xorm:"float 'OrderedQty' not null" json:"WM_GoodsReceiptHead-OrderedQty"`//订单数量
  19. DeliveredQty float64 `xorm:"float 'DeliveredQty' not null" json:"WM_GoodsReceiptHead-DeliveredQty"`//发运数量
  20. Applicant string `xorm:"nvarchar(40) 'Applicant' not null" json:"WM_GoodsReceiptHead-Applicant"`//申请人
  21. Department string `xorm:"nvarchar(40) 'Department' not null" json:"WM_GoodsReceiptHead-Department"`//部门
  22. ApplyTime grmi.DateTime `xorm:"datetime 'ApplyTime' not null" json:"WM_GoodsReceiptHead-ApplyTime"`//申请时间
  23. GRCtrlPara1 int `xorm:"int 'GRCtrlPara1' not null" json:"WM_GoodsReceiptHead-GRCtrlPara1"`
  24. GRCtrlPara2 int `xorm:"int 'GRCtrlPara2' not null" json:"WM_GoodsReceiptHead-GRCtrlPara2"`
  25. GRCtrlPara3 int `xorm:"int 'GRCtrlPara3' not null" json:"WM_GoodsReceiptHead-GRCtrlPara3"`
  26. GRCtrlPara4 int `xorm:"int 'GRCtrlPara4' not null" json:"WM_GoodsReceiptHead-GRCtrlPara4"`
  27. GRCtrlPara5 string `xorm:"nvarchar(255) 'GRCtrlPara5'" json:"WM_GoodsReceiptHead-GRCtrlPara5"`
  28. GRCtrlPara6 string `xorm:"nvarchar(255) 'GRCtrlPara6'" json:"WM_GoodsReceiptHead-GRCtrlPara6"`
  29. GRCtrlPara7 string `xorm:"nvarchar(255) 'GRCtrlPara7'" json:"WM_GoodsReceiptHead-GRCtrlPara7"`
  30. GRCtrlPara8 string `xorm:"nvarchar(255) 'GRCtrlPara8'" json:"WM_GoodsReceiptHead-GRCtrlPara8"`
  31. GRCtrlPara9 float64 `xorm:"float 'GRCtrlPara9'" json:"WM_GoodsReceiptHead-GRCtrlPara9"`
  32. GRCtrlPara10 float64 `xorm:"float 'GRCtrlPara10'" json:"WM_GoodsReceiptHead-GRCtrlPara10"`
  33. GRCtrlPara11 float64 `xorm:"float 'GRCtrlPara11'" json:"WM_GoodsReceiptHead-GRCtrlPara11"`
  34. GRCtrlPara12 float64 `xorm:"float 'GRCtrlPara12'" json:"WM_GoodsReceiptHead-GRCtrlPara12"`
  35. GRCtrlPara13 grmi.DateTime `xorm:"datetime 'GRCtrlPara13'" json:"WM_GoodsReceiptHead-GRCtrlPara13"`
  36. GRCtrlPara14 grmi.DateTime `xorm:"datetime 'GRCtrlPara14'" json:"WM_GoodsReceiptHead-GRCtrlPara14"`
  37. GRCtrlPara15 grmi.DateTime `xorm:"datetime 'GRCtrlPara15'" json:"WM_GoodsReceiptHead-GRCtrlPara15"`
  38. GRCtrlPara16 grmi.DateTime `xorm:"datetime 'GRCtrlPara16'" json:"WM_GoodsReceiptHead-GRCtrlPara16"`
  39. LastModify grmi.DateTime `xorm:"datetime 'LastModify' not null updated" json:"WM_GoodsReceiptHead-LastModify"`
  40. LastUser string `xorm:"nvarchar(20) 'LastUser' not null" json:"WM_GoodsReceiptHead-LastUser"`
  41. CreateTime grmi.DateTime `xorm:"datetime 'CreateTime' not null created" json:"WM_GoodsReceiptHead-CreateTime"`
  42. GoodsReceiptDetail []GoodsReceiptDetail `json:"goods-receipt-detail" xorm:"-"` //详情列表
  43. }
  44. ```
  45. #### 接口:
  46. 插入 入库: /admin/wm/goodsreceipthead/insertone
  47. 查询一条: /admin/wm/goodsreceipthead/get/{GoodsReceiptId:string}
  48. #### 入库备件详情
  49. #### WM_GoodsReceiptDetail
  50. ```go
  51. type GoodsReceiptDetail struct {
  52. GoodsReceiptId string `xorm:"pk nvarchar(40) 'GoodsReceiptId'" json:"WM_GoodsReceiptDetail-GoodsReceiptId"`//入库流水号
  53. GRPos int `xorm:"pk int 'GRPos'" json:"WM_GoodsReceiptDetail-GRPos"`//入库详情编号 1,2,3。。。
  54. ArtId string `xorm:"nvarchar(40) 'ArtId' not null" json:"WM_GoodsReceiptDetail-ArtId"`//物料id
  55. ArtName string `xorm:"nvarchar(100) 'ArtName' not null" json:"WM_GoodsReceiptDetail-ArtName"`//物料名称
  56. ArtType string `xorm:"nvarchar(40) 'ArtType' not null" json:"WM_GoodsReceiptDetail-ArtType"`//物料类型
  57. Remark string `xorm:"nvarchar(100) 'Remark' not null" json:"WM_GoodsReceiptDetail-Remark"`//备注
  58. Auditor string `xorm:"nvarchar(40) 'Auditor' not null" json:"WM_GoodsReceiptDetail-Auditor"`//审核人
  59. AuditTime grmi.DateTime `xorm:"datetime 'AuditTime' not null" json:"WM_GoodsReceiptDetail-AuditTime"`//审核时间
  60. AuditStatus string `xorm:"nvarchar(3) 'AuditStatus' not null" json:"WM_GoodsReceiptDetail-AuditStatus"`//审核状态
  61. BatchId string `xorm:"nvarchar(255) 'BatchId' not null" json:"WM_GoodsReceiptDetail-BatchId"`// 批次ID
  62. OrderedQty float64 `xorm:"float 'OrderedQty' not null" json:"WM_GoodsReceiptDetail-OrderedQty"`// 订单数量
  63. OrderType string `xorm:"nvarchar(40) 'OrderType' not null" json:"WM_GoodsReceiptDetail-OrderType"`// 订单类型
  64. DeliveredQty float64 `xorm:"float 'DeliveredQty' not null" json:"WM_GoodsReceiptDetail-DeliveredQty"`// 发运数量
  65. QtyUom string `xorm:"nvarchar(40) 'QtyUom' not null" json:"WM_GoodsReceiptDetail-QtyUom"`//计量单位 (个)
  66. UnitPrice float64 `xorm:"float 'UnitPrice'" json:"WM_GoodsReceiptDetail-UnitPrice"`//单价
  67. TotalPrice float64 `xorm:"float 'TotalPrice'" json:"WM_GoodsReceiptDetail-TotalPrice"`//总金额
  68. Currency string `xorm:"nvarchar(40) 'Currency' not null" json:"WM_GoodsReceiptDetail-Currency"`//单价货币类型
  69. InspectToggle bool `xorm:"bit 'InspectToggle' not null" json:"WM_GoodsReceiptDetail-InspectToggle"`// 检查开关
  70. InspectPlanId string `xorm:"nvarchar(40) 'InspectPlanId' not null" json:"WM_GoodsReceiptDetail-InspectPlanId"`// 检查计划ID
  71. InspectStatus string `xorm:"nvarchar(3) 'InspectStatus' not null" json:"WM_GoodsReceiptDetail-InspectStatus"`// 检查状态
  72. GRICtrlPara1 int `xorm:"int 'GRICtrlPara1' not null" json:"WM_GoodsReceiptDetail-GRICtrlPara1"`
  73. GRICtrlPara2 int `xorm:"int 'GRICtrlPara2' not null" json:"WM_GoodsReceiptDetail-GRICtrlPara2"`
  74. GRICtrlPara3 int `xorm:"int 'GRICtrlPara3' not null" json:"WM_GoodsReceiptDetail-GRICtrlPara3"`
  75. GRICtrlPara4 int `xorm:"int 'GRICtrlPara4' not null" json:"WM_GoodsReceiptDetail-GRICtrlPara4"`
  76. GRICtrlPara5 string `xorm:"nvarchar(255) 'GRICtrlPara5'" json:"WM_GoodsReceiptDetail-GRICtrlPara5"`
  77. GRICtrlPara6 string `xorm:"nvarchar(255) 'GRICtrlPara6'" json:"WM_GoodsReceiptDetail-GRICtrlPara6"`
  78. GRICtrlPara7 string `xorm:"nvarchar(255) 'GRICtrlPara7'" json:"WM_GoodsReceiptDetail-GRICtrlPara7"`
  79. GRICtrlPara8 string `xorm:"nvarchar(255) 'GRICtrlPara8'" json:"WM_GoodsReceiptDetail-GRICtrlPara8"`
  80. GRICtrlPara9 float64 `xorm:"float 'GRICtrlPara9'" json:"WM_GoodsReceiptDetail-GRICtrlPara9"`
  81. GRICtrlPara10 float64 `xorm:"float 'GRICtrlPara10'" json:"WM_GoodsReceiptDetail-GRICtrlPara10"`
  82. GRICtrlPara11 float64 `xorm:"float 'GRICtrlPara11'" json:"WM_GoodsReceiptDetail-GRICtrlPara11"`
  83. GRICtrlPara12 float64 `xorm:"float 'GRICtrlPara12'" json:"WM_GoodsReceiptDetail-GRICtrlPara12"`
  84. GRICtrlPara13 grmi.DateTime `xorm:"datetime 'GRICtrlPara13'" json:"WM_GoodsReceiptDetail-GRICtrlPara13"`
  85. GRICtrlPara14 grmi.DateTime `xorm:"datetime 'GRICtrlPara14'" json:"WM_GoodsReceiptDetail-GRICtrlPara14"`
  86. GRICtrlPara15 grmi.DateTime `xorm:"datetime 'GRICtrlPara15'" json:"WM_GoodsReceiptDetail-GRICtrlPara15"`
  87. GRICtrlPara16 grmi.DateTime `xorm:"datetime 'GRICtrlPara16'" json:"WM_GoodsReceiptDetail-GRICtrlPara16"`
  88. LastModify grmi.DateTime `xorm:"datetime 'LastModify' not null updated" json:"WM_GoodsReceiptDetail-LastModify"`
  89. LastUser string `xorm:"nvarchar(20) 'LastUser' not null" json:"WM_GoodsReceiptDetail-LastUser"`
  90. CreateTime grmi.DateTime `xorm:"datetime 'CreateTime' not null created" json:"WM_GoodsReceiptDetail-CreateTime"`
  91. BeforeQty float64 `xorm:"float 'BeforeQty' not null" json:"WM_GoodsReceiptDetail-BeforeQty"`// 之前库存
  92. CurQty float64 `xorm:"float 'CurQty' not null" json:"WM_GoodsReceiptDetail-CurQty"`// 当前库存
  93. GoodsReceiptLst []GoodsReceiptLst `json:"goods-receipt-lst" xorm:"-"` // 库位列表
  94. }
  95. ```
  96. #### 接口:
  97. 列表 入库流水查询: /admin/wm/goodsreceiptdetail/query/{ArtId:string}
  98. 查询一条: /admin/wm/goodsreceiptdetail/get/{GoodsReceiptId:string,GRPos:int}
  99. #### 入库备件详情列表
  100. #### WM_GoodsReceiptLst
  101. ```go
  102. type GoodsReceiptLst struct {
  103. GoodsReceiptId string `xorm:"pk nvarchar(40) 'GoodsReceiptId'" json:"WM_GoodsReceiptLst-GoodsReceiptId"`//入库流水号
  104. GRPos int `xorm:"pk int 'GRPos'" json:"WM_GoodsReceiptLst-GRPos"`//入库详情编号 1,2,3。。。
  105. GRLPos int `xorm:"pk int 'GRLPos'" json:"WM_GoodsReceiptLst-GRLPos"`//入库详情列表编号 1,2,3。。。
  106. WarehouseId string `xorm:"nvarchar(40) 'WarehouseId' not null" json:"WM_GoodsReceiptLst-WarehouseId"`//库房id
  107. StorageAreaId string `xorm:"nvarchar(40) 'StorageAreaId' not null" json:"WM_GoodsReceiptLst-StorageAreaId"`//库区id
  108. StorageBinId string `xorm:"nvarchar(40) 'StorageBinId' not null" json:"WM_GoodsReceiptLst-StorageBinId"`//库位id
  109. StorageRackId string `xorm:"nvarchar(40) 'StorageRackId' not null" json:"WM_GoodsReceiptLst-StorageRackId"`//库架id
  110. Qty float64 `xorm:"float 'Qty' not null" json:"WM_GoodsReceiptLst-Qty"`//数量
  111. CtrlPara1 string `xorm:"nvarchar(100) 'CtrlPara1' not null" json:"WM_GoodsReceiptLst-CtrlPara1"`
  112. CtrlPara2 string `xorm:"nvarchar(100) 'CtrlPara2' not null" json:"WM_GoodsReceiptLst-CtrlPara2"`
  113. CtrlPara3 int `xorm:"int 'CtrlPara3' not null" json:"WM_GoodsReceiptLst-CtrlPara3"`
  114. CtrlPara4 int `xorm:"int 'CtrlPara4' not null" json:"WM_GoodsReceiptLst-CtrlPara4"`
  115. CtrlPara5 float64 `xorm:"float 'CtrlPara5' not null" json:"WM_GoodsReceiptLst-CtrlPara5"`
  116. CtrlPara6 float64 `xorm:"float 'CtrlPara6' not null" json:"WM_GoodsReceiptLst-CtrlPara6"`
  117. LastModify grmi.DateTime `xorm:"datetime 'LastModify' not null updated" json:"WM_GoodsReceiptLst-LastModify"`
  118. LastUser string `xorm:"nvarchar(20) 'LastUser' not null" json:"WM_GoodsReceiptLst-LastUser"`
  119. CreateTime grmi.DateTime `xorm:"datetime 'CreateTime' not null created" json:"WM_GoodsReceiptLst-CreateTime"`
  120. }
  121. ```
  122. #### 接口:
  123. 列表: /admin/wm/goodsreceiptlst/query
  124. 查询一条: /admin/wm/goodsreceiptlst/get
  125. #### 出库备件
  126. #### WM_GoodsIssueHead
  127. ```go
  128. type GoodsIssueHead struct {
  129. GoodsIssueId string `xorm:"pk nvarchar(40) 'GoodsIssueId'" json:"WM_GoodsIssueHead-GoodsIssueId"`
  130. RefOrderId string `xorm:"nvarchar(100) 'RefOrderId' not null" json:"WM_GoodsIssueHead-RefOrderId"`
  131. CustOrderId string `xorm:"nvarchar(100) 'CustOrderId' not null" json:"WM_GoodsIssueHead-CustOrderId"`
  132. Destination string `xorm:"nvarchar(40) 'Destination' not null" json:"WM_GoodsIssueHead-Destination"`
  133. Remark string `xorm:"nvarchar(255) 'Remark' not null" json:"WM_GoodsIssueHead-Remark"`
  134. DeliveryDate grmi.Date `xorm:"date 'DeliveryDate' not null" json:"WM_GoodsIssueHead-DeliveryDate"`
  135. Status string `xorm:"nvarchar(3) 'Status' not null" json:"WM_GoodsIssueHead-Status"`
  136. GIType string `xorm:"nvarchar(40) 'GIType' not null" json:"WM_GoodsIssueHead-GIType"`
  137. GIType1 string `xorm:"nvarchar(40) 'GIType1' not null" json:"WM_GoodsIssueHead-GIType1"`
  138. GIType2 string `xorm:"nvarchar(40) 'GIType2' not null" json:"WM_GoodsIssueHead-GIType2"`
  139. GIReason string `xorm:"nvarchar(255) 'GIReason' not null" json:"WM_GoodsIssueHead-GIReason"`
  140. Priority int `xorm:"int 'Priority' not null" json:"WM_GoodsIssueHead-Priority"`
  141. CostCenterId string `xorm:"nvarchar(40) 'CostCenterId' not null" json:"WM_GoodsIssueHead-CostCenterId"`
  142. BookingKey string `xorm:"nvarchar(100) 'BookingKey' not null" json:"WM_GoodsIssueHead-BookingKey"`
  143. GICtrlPara1 int `xorm:"int 'GICtrlPara1' not null" json:"WM_GoodsIssueHead-GICtrlPara1"`
  144. GICtrlPara2 int `xorm:"int 'GICtrlPara2' not null" json:"WM_GoodsIssueHead-GICtrlPara2"`
  145. GICtrlPara3 int `xorm:"int 'GICtrlPara3' not null" json:"WM_GoodsIssueHead-GICtrlPara3"`
  146. GICtrlPara4 int `xorm:"int 'GICtrlPara4' not null" json:"WM_GoodsIssueHead-GICtrlPara4"`
  147. GICtrlPara5 string `xorm:"nvarchar(255) 'GICtrlPara5'" json:"WM_GoodsIssueHead-GICtrlPara5"`
  148. GICtrlPara6 string `xorm:"nvarchar(255) 'GICtrlPara6'" json:"WM_GoodsIssueHead-GICtrlPara6"`
  149. GICtrlPara7 string `xorm:"nvarchar(255) 'GICtrlPara7'" json:"WM_GoodsIssueHead-GICtrlPara7"`
  150. GICtrlPara8 string `xorm:"nvarchar(255) 'GICtrlPara8'" json:"WM_GoodsIssueHead-GICtrlPara8"`
  151. GICtrlPara9 float64 `xorm:"float 'GICtrlPara9'" json:"WM_GoodsIssueHead-GICtrlPara9"`
  152. GICtrlPara10 float64 `xorm:"float 'GICtrlPara10'" json:"WM_GoodsIssueHead-GICtrlPara10"`
  153. GICtrlPara11 float64 `xorm:"float 'GICtrlPara11'" json:"WM_GoodsIssueHead-GICtrlPara11"`
  154. GICtrlPara12 float64 `xorm:"float 'GICtrlPara12'" json:"WM_GoodsIssueHead-GICtrlPara12"`
  155. GICtrlPara13 grmi.DateTime `xorm:"datetime 'GICtrlPara13'" json:"WM_GoodsIssueHead-GICtrlPara13"`
  156. GICtrlPara14 grmi.DateTime `xorm:"datetime 'GICtrlPara14'" json:"WM_GoodsIssueHead-GICtrlPara14"`
  157. GICtrlPara15 grmi.DateTime `xorm:"datetime 'GICtrlPara15'" json:"WM_GoodsIssueHead-GICtrlPara15"`
  158. GICtrlPara16 grmi.DateTime `xorm:"datetime 'GICtrlPara16'" json:"WM_GoodsIssueHead-GICtrlPara16"`
  159. LastModify grmi.DateTime `xorm:"datetime 'LastModify' not null updated" json:"WM_GoodsIssueHead-LastModify"`
  160. LastUser string `xorm:"nvarchar(20) 'LastUser' not null" json:"WM_GoodsIssueHead-LastUser"`
  161. CreateTime grmi.DateTime `xorm:"datetime 'CreateTime' not null created" json:"WM_GoodsIssueHead-CreateTime"`
  162. GoodsIssueDetail []GoodsIssueDetail `json:"goods-issue-detail" xorm:"-"` //
  163. }
  164. ```
  165. #### 接口:
  166. 插入 出库: /admin/wm/goodsissuehead/insertone
  167. 查询一条: /admin/wm/goodsissuehead/get/{GoodsReceiptId:string}
  168. #### 出库备件详情
  169. #### WM_GoodsIssueDetail
  170. ```go
  171. type GoodsIssueDetail struct {
  172. GoodsIssueId string `xorm:"pk nvarchar(40) 'GoodsIssueId'" json:"WM_GoodsIssueDetail-GoodsIssueId"`
  173. GIPos int `xorm:"pk int 'GIPos'" json:"WM_GoodsIssueDetail-GIPos"`
  174. Remark string `xorm:"nvarchar(255) 'Remark' not null" json:"WM_GoodsIssueDetail-Remark"`
  175. ArtId string `xorm:"nvarchar(40) 'ArtId' not null" json:"WM_GoodsIssueDetail-ArtId"`
  176. ArtName string `xorm:"nvarchar(100) 'ArtName' not null" json:"WM_GoodsIssueDetail-ArtName"`
  177. ArtType string `xorm:"nvarchar(40) 'ArtType' not null" json:"WM_GoodsIssueDetail-ArtType"`
  178. RequiredQty float64 `xorm:"float 'RequiredQty' not null" json:"WM_GoodsIssueDetail-RequiredQty"`//必须数量
  179. RequestType string `xorm:"nvarchar(40) 'RequestType' not null" json:"WM_GoodsIssueDetail-RequestType"`//请求类型
  180. ReservedQty float64 `xorm:"float 'ReservedQty' not null" json:"WM_GoodsIssueDetail-ReservedQty"`//保留数量
  181. ActualQty float64 `xorm:"float 'ActualQty' not null" json:"WM_GoodsIssueDetail-ActualQty"`//实际数量
  182. OrderQty float64 `xorm:"float 'OrderQty' not null" json:"WM_GoodsIssueDetail-OrderQty"`// 订单数量
  183. DeliveryDate grmi.Date `xorm:"date 'DeliveryDate'" json:"WM_GoodsIssueDetail-DeliveryDate"` // 交付时间
  184. InspectToggle bool `xorm:"bit 'InspectToggle' not null" json:"WM_GoodsIssueDetail-InspectToggle"`
  185. InspectPlanId string `xorm:"nvarchar(40) 'InspectPlanId' not null" json:"WM_GoodsIssueDetail-InspectPlanId"`
  186. InspectStatus string `xorm:"nvarchar(3) 'InspectStatus' not null" json:"WM_GoodsIssueDetail-InspectStatus"`
  187. Auditor string `xorm:"nvarchar(40) 'Auditor' not null" json:"WM_GoodsIssueDetail-Auditor"`
  188. AuditTime grmi.DateTime `xorm:"datetime 'AuditTime' not null" json:"WM_GoodsIssueDetail-AuditTime"`
  189. AuditStatus string `xorm:"nvarchar(3) 'AuditStatus' not null" json:"WM_GoodsIssueDetail-AuditStatus"`
  190. BatchId string `xorm:"nvarchar(255) 'BatchId' not null" json:"WM_GoodsIssueDetail-BatchId"`
  191. GICtrlPara1 int `xorm:"int 'GICtrlPara1' not null" json:"WM_GoodsIssueDetail-GICtrlPara1"`
  192. GIICtrlPara2 int `xorm:"int 'GIICtrlPara2' not null" json:"WM_GoodsIssueDetail-GIICtrlPara2"`
  193. GIICtrlPara3 int `xorm:"int 'GIICtrlPara3' not null" json:"WM_GoodsIssueDetail-GIICtrlPara3"`
  194. GIICtrlPara4 int `xorm:"int 'GIICtrlPara4' not null" json:"WM_GoodsIssueDetail-GIICtrlPara4"`
  195. GIICtrlPara5 string `xorm:"nvarchar(255) 'GIICtrlPara5'" json:"WM_GoodsIssueDetail-GIICtrlPara5"`
  196. GIICtrlPara6 string `xorm:"nvarchar(255) 'GIICtrlPara6'" json:"WM_GoodsIssueDetail-GIICtrlPara6"`
  197. GIICtrlPara7 string `xorm:"nvarchar(255) 'GIICtrlPara7'" json:"WM_GoodsIssueDetail-GIICtrlPara7"`
  198. GIICtrlPara8 string `xorm:"nvarchar(255) 'GIICtrlPara8'" json:"WM_GoodsIssueDetail-GIICtrlPara8"`
  199. GIICtrlPara9 float64 `xorm:"float 'GIICtrlPara9'" json:"WM_GoodsIssueDetail-GIICtrlPara9"`
  200. GIICtrlPara10 float64 `xorm:"float 'GIICtrlPara10'" json:"WM_GoodsIssueDetail-GIICtrlPara10"`
  201. GIICtrlPara11 float64 `xorm:"float 'GIICtrlPara11'" json:"WM_GoodsIssueDetail-GIICtrlPara11"`
  202. GIICtrlPara12 float64 `xorm:"float 'GIICtrlPara12'" json:"WM_GoodsIssueDetail-GIICtrlPara12"`
  203. GIICtrlPara13 grmi.DateTime `xorm:"datetime 'GIICtrlPara13'" json:"WM_GoodsIssueDetail-GIICtrlPara13"`
  204. GIICtrlPara14 grmi.DateTime `xorm:"datetime 'GIICtrlPara14'" json:"WM_GoodsIssueDetail-GIICtrlPara14"`
  205. GIICtrlPara15 grmi.DateTime `xorm:"datetime 'GIICtrlPara15'" json:"WM_GoodsIssueDetail-GIICtrlPara15"`
  206. GIICtrlPara16 grmi.DateTime `xorm:"datetime 'GIICtrlPara16'" json:"WM_GoodsIssueDetail-GIICtrlPara16"`
  207. LastModify grmi.DateTime `xorm:"datetime 'LastModify' not null updated" json:"WM_GoodsIssueDetail-LastModify"`
  208. LastUser string `xorm:"nvarchar(20) 'LastUser' not null" json:"WM_GoodsIssueDetail-LastUser"`
  209. CreateTime grmi.DateTime `xorm:"datetime 'CreateTime' not null created" json:"WM_GoodsIssueDetail-CreateTime"`
  210. BeforeQty float64 `xorm:"float 'BeforeQty' not null" json:"WM_GoodsIssueDetail-BeforeQty"`// 之前库存
  211. CurQty float64 `xorm:"float 'CurQty' not null" json:"WM_GoodsIssueDetail-CurQty"`// 当前库存
  212. GoodsIssueLst []GoodsIssueLst `json:"goods-issue-lst" xorm:"-"` //
  213. }
  214. ```
  215. #### 接口:
  216. 列表 出库流水查询: /admin/wm/goodsissuedetail/query/{ArtId:string}
  217. 查询一条: /admin/wm/goodsissuedetail/get/{GoodsReceiptId:string,GIPos:int}
  218. #### 出库备件详情列表
  219. #### WM_GoodsIssueLst
  220. ```go
  221. type GoodsIssueLst struct {
  222. GoodsIssueId string `xorm:"pk nvarchar(40) 'GoodsIssueId'" json:"WM_GoodsIssueLst-GoodsIssueId"`
  223. GIPos int `xorm:"pk int 'GIPos'" json:"WM_GoodsIssueLst-GIPos"`
  224. GILPos int `xorm:"pk int 'GILPos'" json:"WM_GoodsIssueLst-GILPos"`
  225. WarehouseId string `xorm:"nvarchar(40) 'WarehouseId' not null" json:"WM_GoodsIssueLst-WarehouseId"`
  226. StorageAreaId string `xorm:"nvarchar(40) 'StorageAreaId' not null" json:"WM_GoodsIssueLst-StorageAreaId"`
  227. StorageBinId string `xorm:"nvarchar(40) 'StorageBinId' not null" json:"WM_GoodsIssueLst-StorageBinId"`
  228. StorageRackId string `xorm:"nvarchar(40) 'StorageRackId' not null" json:"WM_GoodsIssueLst-StorageRackId"`
  229. Qty float64 `xorm:"float 'Qty' not null" json:"WM_GoodsIssueLst-Qty"`
  230. CtrlPara1 string `xorm:"nvarchar(100) 'CtrlPara1' not null" json:"WM_GoodsIssueLst-CtrlPara1"`
  231. CtrlPara2 string `xorm:"nvarchar(100) 'CtrlPara2' not null" json:"WM_GoodsIssueLst-CtrlPara2"`
  232. CtrlPara3 int `xorm:"int 'CtrlPara3' not null" json:"WM_GoodsIssueLst-CtrlPara3"`
  233. CtrlPara4 int `xorm:"int 'CtrlPara4' not null" json:"WM_GoodsIssueLst-CtrlPara4"`
  234. CtrlPara5 float64 `xorm:"float 'CtrlPara5' not null" json:"WM_GoodsIssueLst-CtrlPara5"`
  235. CtrlPara6 float64 `xorm:"float 'CtrlPara6' not null" json:"WM_GoodsIssueLst-CtrlPara6"`
  236. LastModify grmi.DateTime `xorm:"datetime 'LastModify' not null updated" json:"WM_GoodsIssueLst-LastModify"`
  237. LastUser string `xorm:"nvarchar(20) 'LastUser' not null" json:"WM_GoodsIssueLst-LastUser"`
  238. CreateTime grmi.DateTime `xorm:"datetime 'CreateTime' not null created" json:"WM_GoodsIssueLst-CreateTime"`
  239. }
  240. ```
  241. #### 接口:
  242. 列表: /admin/wm/goodsissuelst/query
  243. 查询一条: /admin/wm/goodsissuelst/get
  244. #### 移库
  245. #### WM_StockTransferHead
  246. ```go
  247. type StockTransferHead struct {
  248. StockTransferId string `xorm:"pk nvarchar(40) 'StockTransferId'" json:"WM_StockTransferHead-StockTransferId"`//移库id
  249. RefOrderId string `xorm:"nvarchar(100) 'RefOrderId' not null" json:"WM_StockTransferHead-RefOrderId"`//关联订单id
  250. WarehouseId string `xorm:"nvarchar(40) 'WarehouseId' not null" json:"WM_StockTransferHead-WarehouseId"`//库房id
  251. TargetWarehouseId string `xorm:"nvarchar(40) 'TargetWarehouseId' not null" json:"WM_StockTransferHead-TargetWarehouseId"`//目标库房id
  252. Remark string `xorm:"nvarchar(255) 'Remark' not null" json:"WM_StockTransferHead-Remark"`//备注
  253. DemandDate grmi.Date `xorm:"date 'DemandDate' not null" json:"WM_StockTransferHead-DemandDate"`//需求时间
  254. RegisterDate grmi.Date `xorm:"date 'RegisterDate' not null" json:"WM_StockTransferHead-RegisterDate"`//注册时间
  255. Status string `xorm:"nvarchar(3) 'Status' not null" json:"WM_StockTransferHead-Status"`//状态
  256. STType string `xorm:"nvarchar(40) 'STType' not null" json:"WM_StockTransferHead-STType"`//移库类型
  257. STType1 string `xorm:"nvarchar(40) 'STType1' not null" json:"WM_StockTransferHead-STType1"`//移库类型1
  258. STType2 string `xorm:"nvarchar(40) 'STType2' not null" json:"WM_StockTransferHead-STType2"`//移库类型2
  259. STReason string `xorm:"nvarchar(255) 'STReason' not null" json:"WM_StockTransferHead-STReason"`//移库原因
  260. OrderedQty float64 `xorm:"float 'OrderedQty' not null" json:"WM_StockTransferHead-OrderedQty"`//订单数量
  261. DeliveredQty float64 `xorm:"float 'DeliveredQty' not null" json:"WM_StockTransferHead-DeliveredQty"`//发送数量
  262. Applicant string `xorm:"nvarchar(40) 'Applicant' not null" json:"WM_StockTransferHead-Applicant"`//发起者
  263. Department string `xorm:"nvarchar(40) 'Department' not null" json:"WM_StockTransferHead-Department"`//部门
  264. ApplyTime grmi.DateTime `xorm:"datetime 'ApplyTime' not null" json:"WM_StockTransferHead-ApplyTime"`//申请时间
  265. STCtrlPara1 int `xorm:"int 'STCtrlPara1' not null" json:"WM_StockTransferHead-STCtrlPara1"`
  266. STCtrlPara2 int `xorm:"int 'STCtrlPara2' not null" json:"WM_StockTransferHead-STCtrlPara2"`
  267. STCtrlPara3 int `xorm:"int 'STCtrlPara3' not null" json:"WM_StockTransferHead-STCtrlPara3"`
  268. STCtrlPara4 int `xorm:"int 'STCtrlPara4' not null" json:"WM_StockTransferHead-STCtrlPara4"`
  269. STCtrlPara5 string `xorm:"nvarchar(255) 'STCtrlPara5'" json:"WM_StockTransferHead-STCtrlPara5"`
  270. STCtrlPara6 string `xorm:"nvarchar(255) 'STCtrlPara6'" json:"WM_StockTransferHead-STCtrlPara6"`
  271. STCtrlPara7 string `xorm:"nvarchar(255) 'STCtrlPara7'" json:"WM_StockTransferHead-STCtrlPara7"`
  272. STCtrlPara8 string `xorm:"nvarchar(255) 'STCtrlPara8'" json:"WM_StockTransferHead-STCtrlPara8"`
  273. STCtrlPara9 float64 `xorm:"float 'STCtrlPara9'" json:"WM_StockTransferHead-STCtrlPara9"`
  274. STCtrlPara10 float64 `xorm:"float 'STCtrlPara10'" json:"WM_StockTransferHead-STCtrlPara10"`
  275. STCtrlPara11 float64 `xorm:"float 'STCtrlPara11'" json:"WM_StockTransferHead-STCtrlPara11"`
  276. STCtrlPara12 float64 `xorm:"float 'STCtrlPara12'" json:"WM_StockTransferHead-STCtrlPara12"`
  277. STCtrlPara13 grmi.DateTime `xorm:"datetime 'STCtrlPara13'" json:"WM_StockTransferHead-STCtrlPara13"`
  278. STCtrlPara14 grmi.DateTime `xorm:"datetime 'STCtrlPara14'" json:"WM_StockTransferHead-STCtrlPara14"`
  279. STCtrlPara15 grmi.DateTime `xorm:"datetime 'STCtrlPara15'" json:"WM_StockTransferHead-STCtrlPara15"`
  280. STCtrlPara16 grmi.DateTime `xorm:"datetime 'STCtrlPara16'" json:"WM_StockTransferHead-STCtrlPara16"`
  281. LastModify grmi.DateTime `xorm:"datetime 'LastModify' not null updated" json:"WM_StockTransferHead-LastModify"`
  282. LastUser string `xorm:"nvarchar(20) 'LastUser' not null" json:"WM_StockTransferHead-LastUser"`
  283. CreateTime grmi.DateTime `xorm:"datetime 'CreateTime' not null created" json:"WM_StockTransferHead-CreateTime"`
  284. StockTransferDetail []StockTransferDetail `xorm:"-" json:"WM_StockTransferHead-StockTransferDetail"`
  285. }
  286. type StockTransferDetail struct {
  287. StockTransferId string `xorm:"pk nvarchar(40) 'StockTransferId'" json:"WM_StockTransferDetail-StockTransferId"`//移库id
  288. STPos int `xorm:"pk int 'STPos'" json:"WM_StockTransferDetail-STPos"`//移库序号 1,2,3.。。
  289. ArtId string `xorm:"nvarchar(40) 'ArtId' not null" json:"WM_StockTransferDetail-ArtId"`//物料id
  290. ArtName string `xorm:"nvarchar(100) 'ArtName' not null" json:"WM_StockTransferDetail-ArtName"`//物料名称
  291. ArtType string `xorm:"nvarchar(40) 'ArtType' not null" json:"WM_StockTransferDetail-ArtType"`//物料类型
  292. Remark string `xorm:"nvarchar(100) 'Remark' not null" json:"WM_StockTransferDetail-Remark"`//备注
  293. Auditor string `xorm:"nvarchar(40) 'Auditor' not null" json:"WM_StockTransferDetail-Auditor"`//审核人
  294. AuditTime grmi.DateTime `xorm:"datetime 'AuditTime' not null" json:"WM_StockTransferDetail-AuditTime"`//审核时间
  295. AuditStatus string `xorm:"nvarchar(3) 'AuditStatus' not null" json:"WM_StockTransferDetail-AuditStatus"`//审核状态
  296. BatchId string `xorm:"nvarchar(255) 'BatchId' not null" json:"WM_StockTransferDetail-BatchId"`//批次id
  297. OrderedQty float64 `xorm:"float 'OrderedQty' not null" json:"WM_StockTransferDetail-OrderedQty"`//订单数量
  298. OrderType string `xorm:"nvarchar(40) 'OrderType' not null" json:"WM_StockTransferDetail-OrderType"`//订单类型
  299. DeliveredQty float64 `xorm:"float 'DeliveredQty' not null" json:"WM_StockTransferDetail-DeliveredQty"`//发送数量
  300. QtyUom string `xorm:"nvarchar(40) 'QtyUom' not null" json:"WM_StockTransferDetail-QtyUom"`//单位
  301. UnitPrice float64 `xorm:"float 'UnitPrice'" json:"WM_StockTransferDetail-UnitPrice"`//单价
  302. TotalPrice float64 `xorm:"float 'TotalPrice'" json:"WM_StockTransferDetail-TotalPrice"`//总价
  303. Currency string `xorm:"nvarchar(40) 'Currency' not null" json:"WM_StockTransferDetail-Currency"`//货币
  304. InspectToggle bool `xorm:"bit 'InspectToggle' not null" json:"WM_StockTransferDetail-InspectToggle"`
  305. InspectPlanId string `xorm:"nvarchar(40) 'InspectPlanId' not null" json:"WM_StockTransferDetail-InspectPlanId"`
  306. InspectStatus string `xorm:"nvarchar(3) 'InspectStatus' not null" json:"WM_StockTransferDetail-InspectStatus"`
  307. StorageBinId string `xorm:"nvarchar(40) 'StorageBinId' not null" json:"WM_StockTransferDetail-StorageBinId"`//库位
  308. StorageAreaId string `xorm:"nvarchar(40) 'StorageAreaId' not null" json:"WM_StockTransferDetail-StorageAreaId"`//库区
  309. WarehouseId string `xorm:"nvarchar(40) 'WarehouseId' not null" json:"WM_StockTransferDetail-WarehouseId"`//库房
  310. TargetStorageBinId string `xorm:"nvarchar(40) 'TargetStorageBinId' not null" json:"WM_StockTransferDetail-TargetStorageBinId"`//目标库位
  311. TargetStorageAreaId string `xorm:"nvarchar(40) 'TargetStorageAreaId' not null" json:"WM_StockTransferDetail-TargetStorageAreaId"`//目标库区
  312. TargetWarehouseId string `xorm:"nvarchar(40) 'TargetWarehouseId' not null" json:"WM_StockTransferDetail-TargetWarehouseId"`//目标库房
  313. STICtrlPara1 int `xorm:"int 'STICtrlPara1' not null" json:"WM_StockTransferDetail-STICtrlPara1"`
  314. STICtrlPara2 int `xorm:"int 'STICtrlPara2' not null" json:"WM_StockTransferDetail-STICtrlPara2"`
  315. STICtrlPara3 int `xorm:"int 'STICtrlPara3' not null" json:"WM_StockTransferDetail-STICtrlPara3"`
  316. STICtrlPara4 int `xorm:"int 'STICtrlPara4' not null" json:"WM_StockTransferDetail-STICtrlPara4"`
  317. STICtrlPara5 string `xorm:"nvarchar(255) 'STICtrlPara5'" json:"WM_StockTransferDetail-STICtrlPara5"`
  318. STICtrlPara6 string `xorm:"nvarchar(255) 'STICtrlPara6'" json:"WM_StockTransferDetail-STICtrlPara6"`
  319. STICtrlPara7 string `xorm:"nvarchar(255) 'STICtrlPara7'" json:"WM_StockTransferDetail-STICtrlPara7"`
  320. STICtrlPara8 string `xorm:"nvarchar(255) 'STICtrlPara8'" json:"WM_StockTransferDetail-STICtrlPara8"`
  321. STICtrlPara9 float64 `xorm:"float 'STICtrlPara9'" json:"WM_StockTransferDetail-STICtrlPara9"`
  322. STICtrlPara10 float64 `xorm:"float 'STICtrlPara10'" json:"WM_StockTransferDetail-STICtrlPara10"`
  323. STICtrlPara11 float64 `xorm:"float 'STICtrlPara11'" json:"WM_StockTransferDetail-STICtrlPara11"`
  324. STICtrlPara12 float64 `xorm:"float 'STICtrlPara12'" json:"WM_StockTransferDetail-STICtrlPara12"`
  325. STICtrlPara13 grmi.DateTime `xorm:"datetime 'STICtrlPara13'" json:"WM_StockTransferDetail-STICtrlPara13"`
  326. STICtrlPara14 grmi.DateTime `xorm:"datetime 'STICtrlPara14'" json:"WM_StockTransferDetail-STICtrlPara14"`
  327. STICtrlPara15 grmi.DateTime `xorm:"datetime 'STICtrlPara15'" json:"WM_StockTransferDetail-STICtrlPara15"`
  328. STICtrlPara16 grmi.DateTime `xorm:"datetime 'STICtrlPara16'" json:"WM_StockTransferDetail-STICtrlPara16"`
  329. StorageRackId string `xorm:"nvarchar(40) 'StorageRackId' not null" json:"WM_StockTransferDetail-StorageRackId"`
  330. TargetStorageRackId string `xorm:"nvarchar(40) 'TargetStorageRackId' not null" json:"WM_StockTransferDetail-TargetStorageRackId"`//目标库架
  331. LastModify grmi.DateTime `xorm:"datetime 'LastModify' not null updated" json:"WM_StockTransferDetail-LastModify"`
  332. LastUser string `xorm:"nvarchar(20) 'LastUser' not null" json:"WM_StockTransferDetail-LastUser"`
  333. CreateTime grmi.DateTime `xorm:"datetime 'CreateTime' not null created" json:"WM_StockTransferDetail-CreateTime"`
  334. }
  335. ```
  336. #### 接口:
  337. 插入 移库: /admin/wm/stocktransferhead/insertone