public PageResult SelectGoods(string barcodes, GoodsListParam goodsListParam) { PageResult pageResult = new PageResult(); pageResult.list = new List <object>(); pageResult.pagination = new Page(goodsListParam.current, goodsListParam.pageSize); StringBuilder selectBuilder = new StringBuilder(); selectBuilder.AppendFormat(ActiceSqls.SELECT_T_BUSS_GOODS_BY_BARCODE, barcodes); string select = selectBuilder.ToString(); DataTable dtGoods = DatabaseOperationWeb.ExecuteSelectDS(select, "T").Tables[0]; if (dtGoods.Rows.Count > 0) { for (int j = (goodsListParam.current - 1) * goodsListParam.pageSize; j < dtGoods.Rows.Count && j < goodsListParam.current * goodsListParam.pageSize; j++) { GoodsListItem goodsListItem = new GoodsListItem(); goodsListItem.key = j + 1; goodsListItem.goodsName = dtGoods.Rows[j]["goods_name"].ToString(); goodsListItem.goodsId = dtGoods.Rows[j]["goods_id"].ToString(); goodsListItem.goodsCost = dtGoods.Rows[j]["goods_cost"].ToString(); goodsListItem.goodsPrice = dtGoods.Rows[j]["goods_price"].ToString(); goodsListItem.goodsNum = dtGoods.Rows[j]["goods_stock"].ToString(); goodsListItem.img = dtGoods.Rows[j]["goods_img"].ToString(); goodsListItem.goodsNums = "1"; pageResult.list.Add(goodsListItem); } } pageResult.pagination.total = dtGoods.Rows.Count; return(pageResult); }
public PageResult SelectGoods(GoodsListParam goodsListParam, string shopId) { PageResult page = new PageResult(); page.list = new List <object>(); page.pagination = new Page(goodsListParam.current, goodsListParam.pageSize); StringBuilder selectBuilder = new StringBuilder(); selectBuilder.AppendFormat(ActiceSqls.SELECT_T_BUSS_GOODS_BY_BARCODE, goodsListParam.goodsName); string select = selectBuilder.ToString(); DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(select, "T").Tables[0]; if (dt.Rows.Count > 0) { StringBuilder selectBuilder1 = new StringBuilder(); selectBuilder1.AppendFormat(ActiceSqls.SELECT_T_BUSS_ACTIVE_GOODS_BY_SHOPID, shopId); string select1 = selectBuilder1.ToString(); DataTable dtchose = DatabaseOperationWeb.ExecuteSelectDS(select1, "T").Tables[0]; for (int i = (goodsListParam.current - 1) * goodsListParam.pageSize; i < dt.Rows.Count && i < goodsListParam.current * goodsListParam.pageSize; i++) { int count = dtchose.Rows.Count; GoodsListItem goodsListItem = new GoodsListItem(); goodsListItem.key = i + 1; goodsListItem.goodsName = dt.Rows[i]["goods_name"].ToString(); goodsListItem.goodsId = dt.Rows[i]["goods_id"].ToString(); goodsListItem.goodsCost = dt.Rows[i]["goods_cost"].ToString(); goodsListItem.goodsPrice = dt.Rows[i]["goods_price"].ToString(); goodsListItem.goodsNum = dt.Rows[i]["goods_stock"].ToString(); goodsListItem.img = dt.Rows[i]["goods_img"].ToString(); goodsListItem.goodsNums = "1"; if (count > 0) { goodsListItem.ifchose = dtchose.Select("goodsId='" + goodsListItem.goodsId + "'").Length == 1 ? 1 : 0; } page.list.Add(goodsListItem); } } page.pagination.total = dt.Rows.Count; return(page); }
public async Task <GoodsListWithKindResponseForA> GetGoodsByKind(string kind) { GoodsListWithKindResponseForA response = new GoodsListWithKindResponseForA(); List <Goods> listgoods = await gr.GetAllGoodsWithKind(kind); response.TotalCount = gr.GetAllGoodsWithKind(kind).Result.Count; response.GoodsKind = kind; List <GoodsListItem> goodslistitem = new List <GoodsListItem>(); for (int i = 0; i < listgoods.Count; i++) { GoodsListItem gli = new GoodsListItem(); gli.GoodsId = listgoods[i].GoodsId; gli.GoodsName = listgoods[i].GoodsName; gli.GoodsPrice = listgoods[i].GoodsPrice; gli.GoodsNum = listgoods[i].GoodsNum; gli.CreateDateTime = listgoods[i].CreateDateTime; goodslistitem.Add(gli); } response.GoodsList = goodslistitem; return(response); }