/// <summary>
/// 获取指定生产厂家的销量最多或点击量最大的药品
/// </summary>
/// <param name="drugsBase_Manufacturer">药厂名称</param>
/// <param name="orderFieldName">排序字段</param>
/// <returns></returns>
public List <product_online_v_Model> GetHotAndClickDrugs(string drugsBase_Manufacturer, string orderFieldName)
{
try
{
List <product_online_v_Model> objs = new List <product_online_v_Model>();
string sql = string.Format(@"SELECT TOP 6 a.Product_ID,
a.Goods_ID,
a.DrugsBase_ID,
a.Goods_Package_ID,
a.DrugsBase_DrugName,
a.DrugsBase_Manufacturer,
a.DrugsBase_Specification,
a.DrugsBase_Formulation,
a.Image,
a.created,
a.Product_SaleNum,
a.Product_ClickNum,
a.Goods_ConveRatio_Unit_Name,
a.Goods_ConveRatio_Unit,
a.Goods_ConveRatio,
a.Goods_Unit
FROM dbo.product_online_v a
WHERE a.DrugsBase_Manufacturer = '{0}'
ORDER BY {1} DESC ",
drugsBase_Manufacturer, orderFieldName);
DataTable dt = base.ExecuteTableForCache(sql, DateTime.Now.AddDays(1));
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
foreach (DataRow rowObj in dt.Rows)
{
product_online_v_Model obj = new product_online_v_Model();
obj.Product_ID = (int)rowObj["Product_ID"];
obj.Goods_ID = (int)rowObj["Goods_ID"];
obj.DrugsBase_ID = (int)rowObj["DrugsBase_ID"]; //药品Id
obj.Goods_Package_ID = (int)rowObj["Goods_Package_ID"];
obj.DrugsBase_DrugName = rowObj["DrugsBase_DrugName"].ToString().Trim(); //药品名称
obj.DrugsBase_Manufacturer = drugsBase_Manufacturer; //生产企业名称
obj.DrugsBase_Specification = GetSpecificationAndS(rowObj); //规格
obj.DrugsBase_Formulation = rowObj["DrugsBase_Formulation"].ToString().Trim();
obj.Image = GetImagePath(rowObj["Image"].ToString()); //图片地址
obj.created = (DateTime)rowObj["created"]; //上架时间
obj.Product_SaleNum = (int)rowObj["Product_SaleNum"]; //销量
obj.Product_ClickNum = (int)rowObj["Product_ClickNum"]; //浏览量
objs.Add(obj);
}
}
return(objs);
}
catch
{
return(null);
}
}
/// <summary>
/// 获取指定生产厂家的中药饮片信息
/// </summary>
/// <param name="drugsBase_Manufacturer">药厂名称</param>
/// <returns></returns>
private List <product_online_v_Model> GetZYCListInfo(string drugsBase_Manufacturer)
{
try
{
List <product_online_v_Model> objs = new List <product_online_v_Model>();
string sql = string.Format(@"SELECT a.Product_ID,
a.Goods_ID,
a.DrugsBase_ID,
a.Goods_Package_ID,
a.DrugsBase_DrugName,
a.DrugsBase_Manufacturer,
a.DrugsBase_Specification,
a.DrugsBase_Formulation,
a.Image,
b.ProductionClassId AS Pharm_Id,
c.ProductionClassName AS Pharm_Name,
a.Goods_ConveRatio_Unit_Name,
a.Goods_ConveRatio_Unit,
a.Goods_ConveRatio,
a.Goods_Unit
FROM dbo.product_online_v a, dbo.DrugsBase_ZYC b, dbo.DrugsBase_ZYC_ProductionClass c
WHERE a.DrugsBase_Manufacturer = '{0}'
AND b.DrugsBase_ID = a.DrugsBase_ID
AND b.ProductionClassId = c.ProductionClassId",
drugsBase_Manufacturer);
DataTable dt = base.ExecuteTableForCache(sql, DateTime.Now.AddDays(1));
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
foreach (DataRow rowObj in dt.Rows)
{
product_online_v_Model obj = new product_online_v_Model();
obj.Product_ID = (int)rowObj["Product_ID"];
obj.Goods_ID = (int)rowObj["Goods_ID"];
obj.DrugsBase_ID = (int)rowObj["DrugsBase_ID"]; //药品Id
obj.Goods_Package_ID = (int)rowObj["Goods_Package_ID"];
obj.DrugsBase_DrugName = rowObj["DrugsBase_DrugName"].ToString().Trim(); //药品名称
obj.DrugsBase_Manufacturer = drugsBase_Manufacturer; //生产企业名称
obj.DrugsBase_Specification = GetSpecificationAndS(rowObj); //规格
obj.DrugsBase_Formulation = rowObj["DrugsBase_Formulation"].ToString().Trim();
obj.Image = GetImagePath(rowObj["Image"].ToString()); //图片地址
obj.Pharm_ID = (int)rowObj["Pharm_ID"]; //分类Id
obj.Pharm_ID_Path = Enum_中药饮片.中药饮片.ToString();
objs.Add(obj);
}
}
return(objs);
}
catch
{
return(null);
}
}
