DeliveryDetailWR.cs 4.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163
  1. using Muchinfo.MTPClient.Data.Helper;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Linq;
  5. using System.Text;
  6. namespace Muchinfo.MTPClient.Data.Model.Delivery
  7. {
  8. /// <summary>
  9. /// 交割单仓单表
  10. /// </summary>
  11. public class DeliveryDetailWR
  12. {
  13. #region SQL字段
  14. //<select id="QueryDeliveryHolderDeatil" parameterType="java.util.Map"
  15. // resultType="java.util.Map">
  16. // select d.deliveryid,
  17. // d.wrid,
  18. // d.sellaccountid,
  19. // d.price,
  20. // d.deliveryqty,
  21. // d.deliveryamount,
  22. // d.wrpricemore,
  23. // d.deliverytotalamount,
  24. // d.buyfee,
  25. // d.sellfee,
  26. // d.tax,
  27. // w.wrcode,
  28. // w.wrregistercode,
  29. // w.deliverygoodsid,
  30. // w.goodsbrandid,
  31. // w.goodslevelid,
  32. // w.regqty,
  33. // w.freezeqty,
  34. // w.deliverqty,
  35. // l.brand goodlevel,
  36. // b.brand
  37. // from DeliveryDetailWR d, WarehouseReciept w, GoodsLevel l, GoodsBrand b
  38. // where d.wrid = w.wrid
  39. // and l.goodslevelid = w.goodslevelid
  40. // and b.goodsbrandid = w.goodsbrandid
  41. // <if test="deliveryid != null">
  42. // and d.deliveryid = #{deliveryid}
  43. // </if>
  44. // </select>
  45. #endregion
  46. /// <summary>
  47. /// 仓单号
  48. /// </summary>
  49. [PropertyDisc("wrcode")]
  50. public string WRCode { get; set; }
  51. /// <summary>
  52. /// AUTOID
  53. /// </summary>
  54. [PropertyDisc("AUTOID")]
  55. public long AUTOID { get; set; }
  56. /// <summary>
  57. /// 交割单
  58. /// </summary>
  59. [PropertyDisc("DELIVERYID")]
  60. public long DELIVERYID { get; set; }
  61. /// <summary>
  62. /// 仓单Id
  63. /// </summary>
  64. [PropertyDisc("wrid")]
  65. public long WRID { get; set; }
  66. /// <summary>
  67. /// 数量
  68. /// </summary>
  69. [PropertyDisc("deliveryqty")]
  70. public decimal DELIVERYQTY { get; set; }
  71. /// <summary>
  72. /// 仓单升贴水总额
  73. /// </summary>
  74. [PropertyDisc("wrpricemore")]
  75. public decimal WRPRICEMOVE { get; set; }
  76. /// <summary>
  77. /// 单价仓单升贴水
  78. /// </summary>
  79. [PropertyDisc("price")]
  80. public decimal PriceMove { get; set; }
  81. /// <summary>
  82. /// 关联仓单Id
  83. /// </summary>
  84. [PropertyDisc("RELATIONWRID")]
  85. public long RELATIONWRID { get; set; }
  86. /// <summary>
  87. /// 品牌
  88. /// </summary>
  89. [PropertyDisc("brand")]
  90. public string Brand { get; set; }
  91. /// <summary>
  92. /// 等级
  93. /// </summary>
  94. [PropertyDisc("goodlevel")]
  95. public string Rank { get; set; }
  96. /// <summary>
  97. /// 注册数量
  98. /// </summary>
  99. [PropertyDisc("regqty")]
  100. public decimal Qty { get; set; }
  101. public string QtyDisplay
  102. {
  103. get
  104. {
  105. return Qty.ToString()+ GoodsunitName;
  106. }
  107. }
  108. /// <summary>
  109. /// 冻结数量
  110. /// </summary>
  111. [PropertyDisc("freezeqty")]
  112. public decimal FreezeQty { get; set; }
  113. /// <summary>
  114. /// 兑付数量
  115. /// </summary>
  116. [PropertyDisc("PayQty")]
  117. public decimal PayQty { get; set; }
  118. /// <summary>
  119. /// 单位
  120. /// </summary>
  121. [PropertyDisc("GoodsUnitId")]
  122. public long GoodsUnitId { get; set; }
  123. /// <summary>
  124. /// 单位名称
  125. /// </summary>
  126. [PropertyDisc("GoodsunitName")]
  127. public string GoodsunitName { get; set; }
  128. /// <summary>
  129. /// 存储仓库名称
  130. /// </summary>
  131. [PropertyDisc("warehousename")]
  132. public string WareHouseName { get; set; }
  133. /// <summary>
  134. /// 货款
  135. /// </summary>
  136. [PropertyDisc("deliveryamount")]
  137. public decimal deliveryamount { get; set; }
  138. /// <summary>
  139. /// 价格
  140. /// </summary>
  141. [PropertyDisc("deliveryprice")]
  142. public decimal deliveryprice { get; set; }
  143. }
  144. }