| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163 |
- using Muchinfo.MTPClient.Data.Helper;
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- namespace Muchinfo.MTPClient.Data.Model.Delivery
- {
- /// <summary>
- /// 交割单仓单表
- /// </summary>
- public class DeliveryDetailWR
- {
- #region SQL字段
- //<select id="QueryDeliveryHolderDeatil" parameterType="java.util.Map"
- // resultType="java.util.Map">
- // select d.deliveryid,
- // d.wrid,
- // d.sellaccountid,
- // d.price,
- // d.deliveryqty,
- // d.deliveryamount,
- // d.wrpricemore,
- // d.deliverytotalamount,
- // d.buyfee,
- // d.sellfee,
- // d.tax,
- // w.wrcode,
- // w.wrregistercode,
- // w.deliverygoodsid,
- // w.goodsbrandid,
- // w.goodslevelid,
- // w.regqty,
- // w.freezeqty,
- // w.deliverqty,
- // l.brand goodlevel,
- // b.brand
- // from DeliveryDetailWR d, WarehouseReciept w, GoodsLevel l, GoodsBrand b
- // where d.wrid = w.wrid
- // and l.goodslevelid = w.goodslevelid
- // and b.goodsbrandid = w.goodsbrandid
- // <if test="deliveryid != null">
- // and d.deliveryid = #{deliveryid}
- // </if>
- // </select>
- #endregion
- /// <summary>
- /// 仓单号
- /// </summary>
- [PropertyDisc("wrcode")]
- public string WRCode { get; set; }
- /// <summary>
- /// AUTOID
- /// </summary>
- [PropertyDisc("AUTOID")]
- public long AUTOID { get; set; }
- /// <summary>
- /// 交割单
- /// </summary>
- [PropertyDisc("DELIVERYID")]
- public long DELIVERYID { get; set; }
- /// <summary>
- /// 仓单Id
- /// </summary>
- [PropertyDisc("wrid")]
- public long WRID { get; set; }
- /// <summary>
- /// 数量
- /// </summary>
- [PropertyDisc("deliveryqty")]
- public decimal DELIVERYQTY { get; set; }
- /// <summary>
- /// 仓单升贴水总额
- /// </summary>
- [PropertyDisc("wrpricemore")]
- public decimal WRPRICEMOVE { get; set; }
- /// <summary>
- /// 单价仓单升贴水
- /// </summary>
- [PropertyDisc("price")]
- public decimal PriceMove { get; set; }
- /// <summary>
- /// 关联仓单Id
- /// </summary>
- [PropertyDisc("RELATIONWRID")]
- public long RELATIONWRID { get; set; }
- /// <summary>
- /// 品牌
- /// </summary>
- [PropertyDisc("brand")]
- public string Brand { get; set; }
- /// <summary>
- /// 等级
- /// </summary>
- [PropertyDisc("goodlevel")]
- public string Rank { get; set; }
- /// <summary>
- /// 注册数量
- /// </summary>
- [PropertyDisc("regqty")]
- public decimal Qty { get; set; }
- public string QtyDisplay
- {
- get
- {
- return Qty.ToString()+ GoodsunitName;
- }
- }
- /// <summary>
- /// 冻结数量
- /// </summary>
- [PropertyDisc("freezeqty")]
- public decimal FreezeQty { get; set; }
- /// <summary>
- /// 兑付数量
- /// </summary>
- [PropertyDisc("PayQty")]
- public decimal PayQty { get; set; }
- /// <summary>
- /// 单位
- /// </summary>
- [PropertyDisc("GoodsUnitId")]
- public long GoodsUnitId { get; set; }
- /// <summary>
- /// 单位名称
- /// </summary>
- [PropertyDisc("GoodsunitName")]
- public string GoodsunitName { get; set; }
- /// <summary>
- /// 存储仓库名称
- /// </summary>
- [PropertyDisc("warehousename")]
- public string WareHouseName { get; set; }
- /// <summary>
- /// 货款
- /// </summary>
- [PropertyDisc("deliveryamount")]
- public decimal deliveryamount { get; set; }
- /// <summary>
- /// 价格
- /// </summary>
- [PropertyDisc("deliveryprice")]
- public decimal deliveryprice { get; set; }
- }
- }
|