求: 请有心人帮我将以下2条SQL语句转成HQL.. 感谢了!!!

Question

1.select sum(case when goodsid=777 and ioless=0 then price end)-sum(case when goodsid=777 and ioless=1 then price end) from io_goods

2.update goods set price = (select sum(price) from io_goods where io_goods.goodsid=777) where goods.goods_id=777;

[size=xx-large]谢谢了!![/size]
[b]问题补充：[/b]
IoGoods.java

public class IoGoods implements java.io.Serializable {

// Fields

private int id;
private Employee employee;
private int goodsid;
private int ionumber;
private String goodsname;
private int price;
private int quantity;
private String gstype;
private Date iotime;
private int ioless;
private String company;

Goods.java

public class Goods implements java.io.Serializable {

// Fields

private int goodsId;
private String goodsName;
private int gid;
private Employee employee;
private int price;
private int quantity;
private int gnumber;

抱歉..是我的失误!!!

Answer 1

1.select sum(case when goodsid=777 and ioless=0 then price end)-sum(case when goodsid=777 and ioless=1 then price end) from IoGoods

2.update Goods g set g.price = (select sum(g.price) from IoGoods io where io.goodsid=777) where g.goodsid=777;