public ShowDayGoodsList GetShowDayGoodsList(string showId)
{
ShowDayGoodsList showDayGoodsList = new ShowDayGoodsList();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(MallSqls.SELECT_SHOW_DAY_GOODS_BY_SHOW_ID, showId);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt != null)
{
showDayGoodsList.list = new List <ShowDayGoods>();
foreach (DataRow dr in dt.Rows)
{
ShowDayGoods showDayGoods = new ShowDayGoods
{
goodsId = dr["GOODS_ID"].ToString(),
goodsImg = dr["GOODS_IMG"].ToString(),
goodsTitle = dr["GOODS_TITLE"].ToString(),
};
showDayGoodsList.list.Add(showDayGoods);
}
}
return(showDayGoodsList);
}
public ShowDayGoodsList GetShowDayGoodsList(string showId)
{
ShowDayGoodsList showDayGoodsList = new ShowDayGoodsList();
StringBuilder builder = new StringBuilder();
builder.AppendFormat(OrderSqls.SELECT_CATEGORY_GOODS_BY_SHOW_ID, showId);
string sql = builder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(sql, "T").Tables[0];
if (dt != null)
{
showDayGoodsList.list = new List <ShowDayGoods>();
foreach (DataRow dr in dt.Rows)
{
string goodsTitle = dr["GOODS_NAME"].ToString();
if (goodsTitle.Length > 22)
{
goodsTitle = dr["GOODS_NAME"].ToString().Substring(0, 20) + "...";
}
ShowDayGoods showDayGoods = new ShowDayGoods
{
goodsId = dr["GOODS_ID"].ToString(),
goodsImg = dr["GOODS_IMG"].ToString(),
goodsTitle = goodsTitle,
goodsPrice = dr["GOODS_PRICE"].ToString(),
};
showDayGoodsList.list.Add(showDayGoods);
}
}
return(showDayGoodsList);
}
