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