//获得用户发布的商品列表24 OK
public List<Commodity> GetUserPublishCommoditys(String UserName)
{
List<Commodity> commodityList = new List<Commodity>();
//数据访存器
DatabaseAccess.DataClasses1DataContext DBAccessor = new DataClasses1DataContext();
try
{
ISingleResult<getCommodityByUserResult> resultList = DBAccessor.getCommodityByUser(UserName);
foreach (getCommodityByUserResult result in resultList)
{
Commodity commodity = new Commodity();
commodity.ID = result.id;
commodity.Name = result.name;
commodity.UserName = result.userfrom;
commodity.StartTime = (DateTime)result.starttime; //等亮亮的返回参数
commodity.EndTime = (DateTime)result.endtime;
commodity.description = result.discription;
commodity.kind = (CommodityKind)((int)result.kind);
commodity.ImageUrl = result.picturepath;
commodity.Price = (double)result.price;
commodity.popularity = (int)result.popularity;
commodity.tagList = new List<Tag>();
//查找属于商品的Tag列表
ISingleResult<getTagByCommodityResult> TagList = DBAccessor.getTagByCommodity(result.id);
foreach (getTagByCommodityResult atag in TagList)
{
Tag tag = new Tag();
tag.name = atag.id;//id就是tag名数据库中做主码
tag.popularity = (int)atag.popularity;
commodity.tagList.Add(tag); //加入tag列表
}
commodityList.Add(commodity); //加入商品列表
}
}
catch (Exception e)
{
}
return commodityList;
}