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