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 ProductAttr GetTaskPlateAttrByCategoryID(string categoryid) { var dal = new ProductsDAL(); DataSet ds = dal.GetTaskPlateAttrByCategoryID(categoryid); ProductAttr model = new ProductAttr(); if (ds.Tables.Contains("Attrs") && ds.Tables["Attrs"].Rows.Count > 0) { model.FillData(ds.Tables["Attrs"].Rows[0]); model.AttrValues = new List<AttrValue>(); foreach (DataRow item in ds.Tables["Values"].Rows) { AttrValue attrValue = new AttrValue(); attrValue.FillData(item); model.AttrValues.Add(attrValue); } } return model; }
public Category GetOrderCategoryDetailsByID(string categoryid, string orderid) { var dal = new ProductsDAL(); DataSet ds = dal.GetOrderCategoryDetailsByID(categoryid, orderid); Category model = new Category(); if (ds.Tables.Contains("Category") && ds.Tables["Category"].Rows.Count > 0) { model.FillData(ds.Tables["Category"].Rows[0]); List<ProductAttr> salelist = new List<ProductAttr>(); List<ProductAttr> attrlist = new List<ProductAttr>(); foreach (DataRow attr in ds.Tables["Attrs"].Rows) { ProductAttr modelattr = new ProductAttr(); modelattr.FillData(attr); if (modelattr.Type == 1) { attrlist.Add(modelattr); } else if (modelattr.Type == 2) { salelist.Add(modelattr); } modelattr.AttrValues = new List<AttrValue>(); foreach (DataRow value in ds.Tables["Values"].Select("AttrID='" + modelattr.AttrID + "'")) { AttrValue valuemodel = new AttrValue(); valuemodel.FillData(value); modelattr.AttrValues.Add(valuemodel); } } model.SaleAttrs = salelist; model.AttrLists = attrlist; } return model; }
public ProductAttr GetAttrByID(string attrid) { var list = GetAttrs(); if (list.Where(m => m.AttrID.ToLower() == attrid.ToLower()).Count() > 0) { var cache = list.Where(m => m.AttrID.ToLower() == attrid.ToLower()).FirstOrDefault(); if (cache.AttrValues.Count > 0) { return cache; } else { DataTable dt = new ProductsDAL().GetAttrValuesByAttrID(attrid); foreach (DataRow item in dt.Rows) { AttrValue attrValue = new AttrValue(); attrValue.FillData(item); cache.AttrValues.Add(attrValue); } return cache; } } DataSet ds = new ProductsDAL().GetAttrByID(attrid); ProductAttr model = new ProductAttr(); if (ds.Tables.Contains("Attrs") && ds.Tables["Attrs"].Rows.Count > 0) { model.FillData(ds.Tables["Attrs"].Rows[0]); model.AttrValues = new List<AttrValue>(); foreach (DataRow item in ds.Tables["Values"].Rows) { AttrValue attrValue = new AttrValue(); attrValue.FillData(item); model.AttrValues.Add(attrValue); } CacheAttrs.Add(model); } return model; }