查询产品状态正在抢购中的资产信息
/**
*用户资产管理表
*
*/
@Entity
@Table(name = "zxb_user_money_mg", schema = "")
@DynamicUpdate(true)
@DynamicInsert(true)
@SuppressWarnings("serial")
public class ZxbUserMoneyMgEntity implements java.io.Serializable {
/** 资产ID */
private java.lang.String assetid;
/** 用户id */
private java.lang.String userid;
/** 金额 */
private BigDecimal money;
/** 产品分类 */
private java.lang.String producttype;
// 标的管理实体
private ZxbProductMgEntity zxbProductiMgEntity;
@OneToOne(fetch = FetchType.EAGER, targetEntity = ZxbProductMgEntity.class)
@JoinColumn(name = "producttype", referencedColumnName = "producttype", nullable = false, updatable = false, insertable = false)
public ZxbProductMgEntity getZxbProductiMgEntity() {
return zxbProductiMgEntity;
}
public void setZxbProductiMgEntity(ZxbProductMgEntity zxbProductiMgEntity) {
this.zxbProductiMgEntity = zxbProductiMgEntity;
}
// 其他字段的set,get方法省略
}
/**
*标的管理表
*/
@Entity
@Table(name = "zxb_product_mg", schema = "")
@DynamicUpdate(true)
@DynamicInsert(true)
@SuppressWarnings("serial")
public class ZxbProductMgEntity implements java.io.Serializable {
/** id */
private java.lang.String id;
/** 标的名称 */
private java.lang.String name;
/** 标的总额 */
private BigDecimal totalmoney;
/** 标的期限 */
private BigDecimal term;
/** 最低起投 */
private BigDecimal mininvest;
/** 标准利率 */
private BigDecimal normalrate;
/** 产品详情 */
private java.lang.String productinfo;
/** 剩余额度 */
private BigDecimal remainmoney;
/** 尾巴 */
private BigDecimal tailmoney;
/** 类型 */
private java.lang.String producttype;
/** 产品状态(0抢购中1已抢完2下架) */
private java.lang.String productstatus;
// set,get方法省略
}
/**
* 根据用户id查询资产列表
*/
@SuppressWarnings("unchecked")
@Override
public List<ZxbUserMoneyMgEntity> findUserMoneyMgByUid(String uid) throws Exception {
Criteria c = getCurrentSession().createCriteria(ZxbUserMoneyMgEntity.class);
c.add(Restrictions.eq("userid", new String(uid)));
c.add(Restrictions.eq("deleteflag", new String("0")));
// 关联关系查询
c.createCriteria("zxbProductiMgEntity").add(Restrictions.eq("productstatus", new String("0")));
c.addOrder(Order.desc("inserttime"));
if (c.list() != null && c.list().size() > 0) {
return c.list();
}
return null;
}