WarehouseRecieptModel.cs 6.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269
  1. using GalaSoft.MvvmLight;
  2. using Muchinfo.MTPClient.Data.Enums;
  3. using Muchinfo.MTPClient.Data.Helper;
  4. using Muchinfo.MTPClient.Resources;
  5. using System;
  6. using System.Collections.Generic;
  7. using System.Linq;
  8. using System.Text;
  9. namespace Muchinfo.MTPClient.Data.Model.Delivery
  10. {
  11. /// <summary>
  12. /// 仓单表实体
  13. /// </summary>
  14. public class WarehouseRecieptModel : ViewModelBase
  15. {
  16. #region SQL字段
  17. // <select id="QueryTakeGoodsMoreDetail" parameterType="java.util.Map"
  18. // resultType="HashMap">
  19. // SELECT wr.WRCode,
  20. // wr.WRType,
  21. // wr.WRAccountId,
  22. // wr.DeliveryGoodsId,
  23. // wr.Brand,
  24. // wr.Rank,
  25. // wr.WareHouseId,
  26. // wr.Qty,
  27. // wr.FreezeQty,
  28. // wr.PayQty,
  29. // wr.StoreCharge,
  30. // wr.StorePlace,
  31. // wr.Spec,
  32. // wr.StoreAmount,
  33. // wr.Status,
  34. // dg.DeliveryGoodsName,
  35. // dg.GoodsUnitId,
  36. // dg.AgreeUnit,
  37. // sd.storeoutqty,
  38. // os.AuditTime,
  39. // (select d.parametervalue from DeliveryRule d where d.deliverygoodsid=wr.deliverygoodsid and d.ruleid=2021) TakeGoodsDate
  40. //from StoreOutRequestDetial sd
  41. //left join OutStoreRequest os on os.storeoutid =sd.storeoutid
  42. //left join WarehouseReciept wr
  43. // on sd.WRId = wr.wrid
  44. //left join DeliveryGoods dg
  45. // on dg.DeliveryGoodsId = wr.DeliveryGoodsId
  46. // <where>
  47. // sd.STOREOUTID =#{STOREOUTID}
  48. // </where>
  49. // </select>
  50. #endregion
  51. /// <summary>
  52. /// 仓单号
  53. /// </summary>
  54. [PropertyDisc("WRCode")]
  55. public string WRCode { get; set; }
  56. /// <summary>
  57. /// 仓单类型
  58. /// </summary>
  59. [PropertyDisc("WRType")]
  60. public int WRType { get; set; }
  61. /// <summary>
  62. /// 存货人Id
  63. /// </summary>
  64. [PropertyDisc("WRAccountId")]
  65. public long WRAccountId { get; set; }
  66. /// <summary>
  67. /// 交割商品ID
  68. /// </summary>
  69. [PropertyDisc("DeliveryGoodsId")]
  70. public long DeliveryGoodsId { get; set; }
  71. ///// <summary>
  72. ///// 品牌
  73. ///// </summary>
  74. //[PropertyDisc("Brand")]
  75. //public string Brand { get; set; }
  76. ///// <summary>
  77. ///// 等级
  78. ///// </summary>
  79. //[PropertyDisc("Rank")]
  80. //public string Rank { get; set; }
  81. private string _Brand = "-";
  82. /// <summary>
  83. /// 品牌
  84. /// </summary>
  85. [PropertyDisc("Brand")]
  86. public string Brand
  87. {
  88. get { return _Brand; }
  89. set { _Brand = value; }
  90. }
  91. private string _Rank = "-";
  92. /// <summary>
  93. /// 等级
  94. /// </summary>
  95. [PropertyDisc("Rank")]
  96. public string Rank
  97. {
  98. get { return _Rank; }
  99. set { _Rank = value; }
  100. }
  101. /// <summary>
  102. /// 存储仓库ID
  103. /// </summary>
  104. [PropertyDisc("WareHouseId")]
  105. public long WareHouseId { get; set; }
  106. /// <summary>
  107. /// 注册数量
  108. /// </summary>
  109. [PropertyDisc("Qty")]
  110. public decimal Qty { get; set; }
  111. /// <summary>
  112. /// 冻结数量
  113. /// </summary>
  114. [PropertyDisc("FreezeQty")]
  115. public decimal FreezeQty { get; set; }
  116. /// <summary>
  117. /// 兑付数量
  118. /// </summary>
  119. [PropertyDisc("PayQty")]
  120. public decimal PayQty { get; set; }
  121. /// <summary>
  122. /// 仓储费
  123. /// </summary>
  124. [PropertyDisc("StoreCharge")]
  125. public decimal StoreCharge { get; set; }
  126. //public string StorePlace { get; set; }
  127. private string _StorePlace = "-";
  128. /// <summary>
  129. /// 库位
  130. /// </summary>
  131. [PropertyDisc("StorePlace")]
  132. public string StorePlace
  133. {
  134. get { return _StorePlace; }
  135. set { _StorePlace = value; }
  136. }
  137. ///// <summary>
  138. ///// 规格
  139. ///// </summary>
  140. //[PropertyDisc("Spec")]
  141. //public string Spec { get; set; }
  142. private string _Spec = "-";
  143. /// <summary>
  144. /// 规格
  145. /// </summary>
  146. [PropertyDisc("Spec")]
  147. public string Spec
  148. {
  149. get { return _Spec; }
  150. set { _Spec = value; }
  151. }
  152. /// <summary>
  153. /// 货值金额
  154. /// </summary>
  155. [PropertyDisc("StoreAmount")]
  156. public decimal StoreAmount { get; set; }
  157. /// <summary>
  158. /// 状态
  159. /// </summary>
  160. [PropertyDisc("Status")]
  161. public int Status { get; set; }
  162. /// <summary>
  163. /// 交割商品名称
  164. /// </summary>
  165. [PropertyDisc("DeliveryGoodsName")]
  166. public string DeliveryGoodsName { get; set; }
  167. /// <summary>
  168. /// 交割商品代码
  169. /// </summary>
  170. [PropertyDisc("deliverygoodscode")]
  171. public string DeliveryGoodsCode { get; set; }
  172. public string DisplayGoodsCodeName
  173. {
  174. get
  175. {
  176. return string.Format("{0}/{1}", DeliveryGoodsCode, DeliveryGoodsName);
  177. }
  178. }
  179. /// <summary>
  180. /// 商品单位
  181. /// </summary>
  182. [PropertyDisc("GoodsUnitId")]
  183. public long GoodsUnitId { get; set; }
  184. /// <summary>
  185. /// 合约单位
  186. /// </summary>
  187. //[PropertyDisc("AgreeUnit")]
  188. //public decimal AgreeUnit { get; set; }
  189. /// <summary>
  190. /// 提货数量
  191. /// </summary>
  192. [PropertyDisc("storeoutqty")]
  193. public decimal StoreoutQty { get; set; }
  194. // /// <summary>
  195. // /// 审核时间
  196. // /// </summary>
  197. // [PropertyDisc("AuditTime")]
  198. // public DateTime AuditTime { get; set; }
  199. // private int _takeGoodsDate=-1;
  200. // /// <summary>
  201. // /// 提货有效日期
  202. // /// </summary>
  203. //[PropertyDisc("TakeGoodsDate")]
  204. // public int TakeGoodsDate
  205. // {
  206. // get { return _takeGoodsDate; }
  207. // set { _takeGoodsDate = value; }
  208. // }
  209. private DateTime _storeOutValidDate=DateTime.MinValue;
  210. /// <summary>
  211. /// 提货截止日期时间
  212. /// </summary>
  213. [PropertyDisc("storeOutValidDate")]
  214. public DateTime storeOutValidDate
  215. {
  216. get { return _storeOutValidDate; }
  217. set { _storeOutValidDate = value; }
  218. }
  219. /// <summary>
  220. /// 出库状态
  221. /// </summary>
  222. [PropertyDisc("AuditStatus")]
  223. public eAuditStatus AuditStatus { get; set; }
  224. /// <summary>
  225. /// 合约单位-自定义字段
  226. /// </summary>
  227. public string GoodsUnitIdDisplay { get; set; }
  228. }
  229. }