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); }