506 lines
13 KiB
C#
506 lines
13 KiB
C#
using BaseOUDAL;
|
|
using Newtonsoft.Json;
|
|
using System.ComponentModel;
|
|
using System.ComponentModel.DataAnnotations;
|
|
using System.ComponentModel.DataAnnotations.Schema;
|
|
using YLErp.Helpers;
|
|
|
|
namespace YLErp.DBModels
|
|
{
|
|
[Table("clientcashincashout_product")]
|
|
public class clientcashincashout_product : DBModelWithOperator,IDBModelWithCreator
|
|
{
|
|
/// <summary>
|
|
/// 抵押赎回状态
|
|
/// </summary>
|
|
[DisplayName("抵押赎回状态")]
|
|
public string Status { get; set; }
|
|
|
|
/// <summary>
|
|
/// 出入金单号
|
|
/// </summary>
|
|
[DisplayName("出入金单号")]
|
|
public string Number { get; set; }
|
|
|
|
/// <summary>
|
|
/// 客户名称
|
|
/// </summary>
|
|
[DisplayName("客户名称")]
|
|
public int ClientId { get; set; }
|
|
|
|
/// <summary>
|
|
/// 客户编号
|
|
/// </summary>
|
|
[DisplayName("客户编号")]
|
|
public string ClientNumber { get; set; }
|
|
|
|
/// <summary>
|
|
/// 客户名称
|
|
/// </summary>
|
|
[DisplayName("客户名称")]
|
|
public string ClientName { get; set; }
|
|
|
|
/// <summary>
|
|
/// 数量
|
|
/// </summary>
|
|
[DisplayName("数量")]
|
|
public double? ProductAmount { get; set; }
|
|
|
|
/// <summary>
|
|
/// 质押率
|
|
/// </summary>
|
|
[DisplayName("质押率")]
|
|
public double? Rate { get; set; }
|
|
|
|
[NotMapped]
|
|
public string RateString => Rate == null ? "0.00%" : (Rate.Value * 100).ToString("0.00") + "%";
|
|
|
|
/// <summary>
|
|
/// 抵押品名
|
|
/// 编辑时下拉菜单选择，保存VarietyId
|
|
/// </summary>
|
|
[DisplayName("抵押品名")]
|
|
public int? VarietyId { get; set; }
|
|
|
|
/// <summary>
|
|
/// 抵押品名，在View页面需要显示
|
|
/// </summary>
|
|
[DisplayName("抵押品名")]
|
|
[NotMapped]
|
|
public string VarietyShortName { get; set; }
|
|
|
|
/// <summary>
|
|
/// 标的Id
|
|
/// </summary>
|
|
[DisplayName("标的代码")]
|
|
public int? UnderlyingId { get; set; }
|
|
|
|
[NotMapped]
|
|
public string UnderlyingCode { get; set; }
|
|
|
|
[NotMapped]
|
|
[DisplayName("盯市价格")]
|
|
public double? SpotPrice { get; set; }
|
|
|
|
[NotMapped]
|
|
[DisplayName("质押价值")]
|
|
public double? ProductTotalPrice { get; set; }
|
|
|
|
/// <summary>
|
|
/// 抵押时间
|
|
/// </summary>
|
|
[DisplayName("抵押时间")]
|
|
public DateTime HappenDate { get; set; }
|
|
|
|
[NotMapped]
|
|
public string HappenDateString => HappenDate.ToString("yyyy-MM-dd");
|
|
|
|
/// <summary>
|
|
/// 赎回时间
|
|
/// </summary>
|
|
[DisplayName("赎回时间")]
|
|
public DateTime? BackDate { get; set; }
|
|
|
|
[NotMapped]
|
|
public string BackDateString => BackDate != null ? BackDate.Value.ToString("yyyy-MM-dd") : "";
|
|
|
|
/// <summary>
|
|
/// 仓单号
|
|
/// </summary>
|
|
[DisplayName("仓单号")]
|
|
public string SerialNumber { get; set; }
|
|
|
|
/// <summary>
|
|
/// 备注
|
|
/// </summary>
|
|
[DisplayName("备注")]
|
|
public string Comments { get; set; }
|
|
|
|
/// <summary>
|
|
/// 执行状态
|
|
/// "未确认", "已确认", "拒绝"
|
|
/// </summary>
|
|
[DisplayName("执行状态")]
|
|
public string OptStatus { get; set; }
|
|
|
|
[NotMapped]
|
|
public string OptDateString => OptDate != null ? OptDate.Value.ToString("yyyy-MM-dd HH:mm:ss") : "";
|
|
|
|
/// <summary>
|
|
/// 执行人_optid
|
|
/// </summary>
|
|
[DisplayName("创建人")]
|
|
public int? ExcuteId { get; set; }
|
|
|
|
/// <summary>
|
|
/// 创建人_excutename
|
|
/// </summary>
|
|
[DisplayName("创建人")]
|
|
public string ExcuteName { get; set; }
|
|
|
|
/// <summary>
|
|
/// 操作时间_excutedate
|
|
/// </summary>
|
|
[DisplayName("操作时间")]
|
|
public DateTime? ExcuteDate { get; set; }
|
|
|
|
/// <summary>
|
|
/// 保存抵押品时的错误消息
|
|
/// </summary>
|
|
[NotMapped]
|
|
public string ErrorMsg { get; set; }
|
|
|
|
/// <summary>
|
|
/// 创建人ID
|
|
/// </summary>
|
|
[DisplayName("操作人")]
|
|
public int? CreatorId { set; get; }
|
|
|
|
/// <summary>
|
|
/// 创建人名称
|
|
/// </summary>
|
|
[DisplayName("操作人")]
|
|
public string CreatorName { set; get; }
|
|
|
|
/// <summary>
|
|
/// 创建时间
|
|
/// </summary>
|
|
[DisplayName("操作时间")]
|
|
public DateTime? CreateDate { set; get; }
|
|
}
|
|
|
|
public class clientcashincashout_productGridSum
|
|
{
|
|
/// <summary>
|
|
/// <summary>
|
|
/// 质押率总数
|
|
/// </summary>
|
|
public double? RateSum { get; set; }
|
|
|
|
public double? ProductTotalPriceSum { get; set; }
|
|
}
|
|
|
|
public class clientcashincashout_productReq : BaseSearchReq
|
|
{
|
|
/// <summary>
|
|
/// 抵押赎回状态
|
|
/// </summary>
|
|
public string Status { get; set; }
|
|
|
|
/// <summary>
|
|
/// 抵押品编号
|
|
/// </summary>
|
|
public string Number { get; set; }
|
|
|
|
/// <summary>
|
|
/// 客户信息
|
|
/// </summary>
|
|
public int? ClientId { get; set; }
|
|
|
|
public string ClientIdString { get; set; }
|
|
|
|
public string[] ClientIds => ClientIdString?.Split(',');
|
|
|
|
/// <summary>
|
|
/// 抵押品名
|
|
/// </summary>
|
|
public int? VarietyId { get; set; }
|
|
|
|
public string VarietyIdString { get; set; }
|
|
|
|
public string[] VarietyIds => VarietyIdString?.Split(',');
|
|
|
|
/// <summary>
|
|
/// 客户编号
|
|
/// </summary>
|
|
public string ClientNumber { get; set; }
|
|
|
|
/// <summary>
|
|
/// 客户名称
|
|
/// </summary>
|
|
public string ClientName { get; set; }
|
|
|
|
/// <summary>
|
|
/// 数量
|
|
/// </summary>
|
|
public double? ProductAmount { get; set; }
|
|
|
|
/// <summary>
|
|
/// 质押率
|
|
/// </summary>
|
|
public double? Rate { get; set; }
|
|
|
|
/// <summary>
|
|
/// 标的Id
|
|
/// </summary>
|
|
public int? UnderlyingId { get; set; }
|
|
|
|
/// <summary>
|
|
/// 抵押时间
|
|
/// </summary>
|
|
public DateTime? HappenDate { get; set; }
|
|
[NotMapped]
|
|
[JsonIgnore]
|
|
public DateTime HappenDateStart { get; set; }
|
|
[NotMapped]
|
|
[JsonIgnore]
|
|
public DateTime HappenDateEnd { get; set; }
|
|
|
|
/// <summary>
|
|
/// 抵押时间
|
|
/// </summary>
|
|
public DateTime? BackDate { get; set; }
|
|
[NotMapped]
|
|
[JsonIgnore]
|
|
public DateTime BackDateStart { get; set; }
|
|
[NotMapped]
|
|
[JsonIgnore]
|
|
public DateTime BackDateEnd { get; set; }
|
|
|
|
/// <summary>
|
|
/// 执行状态
|
|
/// </summary>
|
|
public string OptStatus { get; set; }
|
|
|
|
/// <summary>
|
|
/// 创建人_optid
|
|
/// </summary>
|
|
public int? OptId { get; set; }
|
|
|
|
/// <summary>
|
|
/// 创建人_optname
|
|
/// </summary>
|
|
public string OptName { get; set; }
|
|
|
|
/// <summary>
|
|
/// 操作时间_createdate
|
|
/// </summary>
|
|
public DateTime? OptDate { get; set; }
|
|
[NotMapped]
|
|
[JsonIgnore]
|
|
public DateTime OptDateStart { get; set; }
|
|
[NotMapped]
|
|
[JsonIgnore]
|
|
public DateTime OptDateEnd { get; set; }
|
|
|
|
public DateTime? ValueDate { get; set; }
|
|
|
|
/// <summary>
|
|
/// 客户名称列表
|
|
/// </summary>
|
|
public List<string> ClientNameList { get; set; }
|
|
/// <summary>
|
|
/// 客户代码列表
|
|
/// </summary>
|
|
public List<string> ClientNumberList { get; set; }
|
|
/// <summary>
|
|
/// 抵押品赎回状态列表
|
|
/// </summary>
|
|
public List<string> StatusList { get; set; }
|
|
/// <summary>
|
|
/// 抵押品名列表
|
|
/// </summary>
|
|
public List<string> VarietyShortNameList { get; set; }
|
|
/// <summary>
|
|
/// 质押率范围开始
|
|
/// </summary>
|
|
public double? RateStart { get; set; }
|
|
/// <summary>
|
|
/// 质押率范围结束
|
|
/// </summary>
|
|
public double? RateEnd { get; set; }
|
|
/// <summary>
|
|
/// 执行状态列表
|
|
/// </summary>
|
|
public List<string> OptStatusList { get; set; }
|
|
/// <summary>
|
|
/// 是否查询子级标识
|
|
/// </summary>
|
|
public bool ParentFlag { get; set; }
|
|
}
|
|
|
|
public class clientcashincashout_productLinq
|
|
{
|
|
public static string LogClass = "clientcashincashout_product";
|
|
|
|
/// <summary>
|
|
/// 加密主键
|
|
/// </summary>
|
|
[NotMapped]
|
|
public string EncryptId => DataProtectHelper.Encrypt(id);
|
|
|
|
/// <summary>
|
|
///
|
|
/// </summary>
|
|
[Key]
|
|
public int id { get; set; }
|
|
|
|
/// <summary>
|
|
/// 抵押赎回状态
|
|
/// </summary>
|
|
[DisplayName("抵押赎回状态")]
|
|
public string Status { get; set; }
|
|
|
|
/// <summary>
|
|
/// 出入金单号
|
|
/// </summary>
|
|
[DisplayName("出入金单号")]
|
|
public string Number { get; set; }
|
|
|
|
/// <summary>
|
|
/// 客户名称
|
|
/// </summary>
|
|
[DisplayName("客户名称")]
|
|
public int? ClientId { get; set; }
|
|
|
|
/// <summary>
|
|
/// 客户编号
|
|
/// </summary>
|
|
[DisplayName("客户编号")]
|
|
public string ClientNumber { get; set; }
|
|
|
|
/// <summary>
|
|
/// 客户名称
|
|
/// </summary>
|
|
[DisplayName("客户名称")]
|
|
public string ClientName { get; set; }
|
|
|
|
/// <summary>
|
|
/// 数量
|
|
/// </summary>
|
|
[DisplayName("数量")]
|
|
public double? ProductAmount { get; set; }
|
|
|
|
/// <summary>
|
|
/// 质押率
|
|
/// </summary>
|
|
[DisplayName("质押率")]
|
|
public double? Rate { get; set; }
|
|
|
|
[NotMapped]
|
|
public string RateString => Rate == null ? "0.00%" : (Rate.Value * 100).ToString("0.00") + "%";
|
|
|
|
/// <summary>
|
|
/// 抵押品名
|
|
/// 编辑时下拉菜单选择，保存VarietyId
|
|
/// </summary>
|
|
[DisplayName("抵押品名")]
|
|
public int? VarietyId { get; set; }
|
|
|
|
/// <summary>
|
|
/// 抵押品名，在View页面需要显示
|
|
/// </summary>
|
|
[DisplayName("抵押品名")]
|
|
public string VarietyShortName { get; set; }
|
|
|
|
/// <summary>
|
|
/// 标的Id
|
|
/// </summary>
|
|
[DisplayName("标的代码")]
|
|
public int? UnderlyingId { get; set; }
|
|
|
|
public string UnderlyingCode { get; set; }
|
|
|
|
[DisplayName("盯市价格")]
|
|
public double? SpotPrice { get; set; }
|
|
|
|
[DisplayName("质押价值")]
|
|
public double? ProductTotalPrice { get; set; }
|
|
|
|
/// <summary>
|
|
/// 抵押时间
|
|
/// </summary>
|
|
[DisplayName("抵押时间")]
|
|
public DateTime? HappenDate { get; set; }
|
|
|
|
[NotMapped]
|
|
public string HappenDateString => HappenDate != null ? HappenDate.Value.ToString("yyyy-MM-dd HH:mm:ss") : "";
|
|
|
|
/// <summary>
|
|
/// 赎回时间
|
|
/// </summary>
|
|
[DisplayName("赎回时间")]
|
|
public DateTime? BackDate { get; set; }
|
|
|
|
[NotMapped]
|
|
public string BackDateString => BackDate != null ? BackDate.Value.ToString("yyyy-MM-dd HH:mm:ss") : "";
|
|
|
|
/// <summary>
|
|
/// 仓单号
|
|
/// </summary>
|
|
[DisplayName("仓单号")]
|
|
public string SerialNumber { get; set; }
|
|
|
|
/// <summary>
|
|
/// 备注
|
|
/// </summary>
|
|
[DisplayName("备注")]
|
|
public string Comments { get; set; }
|
|
|
|
/// <summary>
|
|
/// 执行状态
|
|
/// "未确认", "已确认", "拒绝"
|
|
/// </summary>
|
|
[DisplayName("执行状态")]
|
|
public string OptStatus { get; set; }
|
|
|
|
/// <summary>
|
|
/// 创建人_optid
|
|
/// </summary>
|
|
[DisplayName("创建人")]
|
|
public int? OptId { get; set; }
|
|
|
|
/// <summary>
|
|
/// 创建人_optname
|
|
/// </summary>
|
|
[DisplayName("创建人")]
|
|
public string OptName { get; set; }
|
|
|
|
/// <summary>
|
|
/// 操作时间_createdate
|
|
/// </summary>
|
|
[DisplayName("操作时间")]
|
|
public DateTime? OptDate { get; set; }
|
|
|
|
[NotMapped]
|
|
public string OptDateString => OptDate != null ? OptDate.Value.ToString("yyyy-MM-dd HH:mm:ss") : "";
|
|
|
|
/// <summary>
|
|
/// 执行人_optid
|
|
/// </summary>
|
|
[DisplayName("确认人")]
|
|
public int? ExcuteId { get; set; }
|
|
|
|
/// <summary>
|
|
/// 创建人_excutename
|
|
/// </summary>
|
|
[DisplayName("确认人")]
|
|
public string ExcuteName { get; set; }
|
|
|
|
/// <summary>
|
|
/// 操作时间_excutedate
|
|
/// </summary>
|
|
[DisplayName("确认时间")]
|
|
public DateTime? ExcuteDate { get; set; }
|
|
|
|
/// <summary>
|
|
/// 创建人ID
|
|
/// </summary>
|
|
[DisplayName("创建人ID")]
|
|
public int? CreatorId { set; get; }
|
|
|
|
/// <summary>
|
|
/// 创建人名称
|
|
/// </summary>
|
|
[DisplayName("创建人名称")]
|
|
public string CreatorName { set; get; }
|
|
|
|
/// <summary>
|
|
/// 创建时间
|
|
/// </summary>
|
|
[DisplayName("创建时间")]
|
|
public DateTime? CreateDate { set; get; }
|
|
|
|
}
|
|
}
|