private PrizeGoodsItem buildPrizeGoodsItem(DataRow dr)
{
PrizeGoodsItem item = new PrizeGoodsItem();
item.GoodsID = (string)dr["goods_id"];
item.Code = (string)dr["code"];
item.Name = (string)dr["name"];
item.Units = (string)dr["units"];
item.Num = (float)dr["num"];
return(item);
}
public List <PrizeGoodsItem> QueryPrizeGoods()
{
List <PrizeGoodsItem> items = new List <PrizeGoodsItem>();
DataSet ds = ExecuteDataSet("select goods.goods_id, goods.`code`, goods.`name`, goods.units, goods.num from goods where goods.product_type = 2 and goods.num > 0");
if (null != ds && ds.Tables.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
PrizeGoodsItem data = buildPrizeGoodsItem(dr);
items.Add(data);
}
}
return(items);
}