/// <summary> /// 获取购物车列表 /// </summary> public static List<ProductDetail> GetShoppingCart(EnumDocType ordertype, string guid, string userid) { DataTable dt = ShoppingCartDAL.GetShoppingCart((int)ordertype, guid, userid); List<ProductDetail> list = new List<ProductDetail>(); foreach (DataRow dr in dt.Rows) { ProductDetail model = new ProductDetail(); model.FillData(dr); if (!string.IsNullOrEmpty(model.UnitID)) { model.UnitName = new ProductsBusiness().GetUnitByID(model.UnitID).UnitName; } list.Add(model); } return list; }
public Products GetProductByIDForDetails(string productid, string clientid) { var dal = new ProductsDAL(); DataSet ds = dal.GetProductByIDForDetails(productid, clientid); Products model = new Products(); if (ds.Tables.Contains("Product") && ds.Tables["Product"].Rows.Count > 0) { model.FillData(ds.Tables["Product"].Rows[0]); model.SmallUnit = GetUnitByID(model.SmallUnitID); model.AttrLists = new List<ProductAttr>(); model.SaleAttrs = new List<ProductAttr>(); model.Providers = new ProvidersEntity(); if (!string.IsNullOrEmpty(model.ProdiverID)) { model.Providers.FillData(ds.Tables["Providers"].Rows[0]); if (!string.IsNullOrEmpty(model.Providers.CityCode)) { var city = CommonBusiness.GetCityByCode(model.Providers.CityCode); model.Providers.Address = city.Description + model.Providers.Address; } } foreach (DataRow attrtr in ds.Tables["Attrs"].Rows) { ProductAttr attrModel = new ProductAttr(); attrModel.FillData(attrtr); attrModel.AttrValues = new List<AttrValue>(); //参数 if (attrModel.Type == (int)EnumAttrType.Parameter) { foreach (DataRow valuetr in ds.Tables["Values"].Select("AttrID='" + attrModel.AttrID + "'")) { AttrValue valueModel = new AttrValue(); valueModel.FillData(valuetr); if (model.AttrValueList.IndexOf(valueModel.ValueID) >= 0) { attrModel.AttrValues.Add(valueModel); model.AttrLists.Add(attrModel); break; } } } else { model.SaleAttrs.Add(attrModel); } } model.ProductDetails = new List<ProductDetail>(); foreach (DataRow item in ds.Tables["Details"].Rows) { ProductDetail detail = new ProductDetail(); detail.FillData(item); model.ProductDetails.Add(detail); } } return model; }
public List<ProductDetail> GetProductDetails(string wareid, string keywords, string agentid, string clientid) { DataSet ds = ProductsDAL.BaseProvider.GetProductDetails(wareid, keywords, clientid); List<ProductDetail> list = new List<ProductDetail>(); foreach (DataRow dr in ds.Tables[0].Rows) { ProductDetail model = new ProductDetail(); model.FillData(dr); list.Add(model); } return list; }
public List<ProductDetail> GetFilterProducts(string categoryid, List<FilterAttr> Attrs, int doctype, string beginprice, string endprice, int ispublic, string keyWords, string orderby, bool isasc, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string clientID) { var dal = new ProductsDAL(); StringBuilder attrbuild = new StringBuilder(); StringBuilder salebuild = new StringBuilder(); foreach (var attr in Attrs) { if (attr.Type == EnumAttrType.Parameter) { attrbuild.Append(" and p.ValueList like '%" + attr.ValueID + "%'"); } else if (attr.Type == EnumAttrType.Specification) { salebuild.Append(" and AttrValue like '%" + attr.ValueID + "%'"); } } DataSet ds = dal.GetFilterProducts(categoryid, attrbuild.ToString(), salebuild.ToString(), doctype, beginprice, endprice, ispublic, keyWords, orderby, isasc ? 1 : 0, pageSize, pageIndex, ref totalCount, ref pageCount, clientID); List<ProductDetail> list = new List<ProductDetail>(); foreach (DataRow dr in ds.Tables[0].Rows) { ProductDetail model = new ProductDetail(); model.FillData(dr); list.Add(model); } return list; }
public Products GetProductByID(string productid, string clientid) { var dal = new ProductsDAL(); DataSet ds = dal.GetProductByID(productid); Products model = new Products(); if (ds.Tables.Contains("Product") && ds.Tables["Product"].Rows.Count > 0) { model.FillData(ds.Tables["Product"].Rows[0]); model.Category = GetCategoryDetailByID(model.CategoryID); model.SmallUnit = GetUnitByID(model.SmallUnitID); if (!string.IsNullOrEmpty(model.ProdiverID)) { model.Providers = ProvidersBusiness.BaseBusiness.GetProviderByID(model.ProdiverID); } model.ProductDetails = new List<ProductDetail>(); foreach (DataRow item in ds.Tables["Details"].Rows) { //子产品 ProductDetail detail = new ProductDetail(); detail.FillData(item); model.ProductDetails.Add(detail); } } return model; }
public List<ProductDetail> GetProductDetailStocks(string productid, string agentid, string clientid) { DataTable dt = StockDAL.BaseProvider.GetProductDetailStocks(productid, clientid); List<ProductDetail> list = new List<ProductDetail>(); foreach (DataRow dr in dt.Rows) { ProductDetail model = new ProductDetail(); model.FillData(dr); list.Add(model); } return list; }