/// <summary>
/// 获取药厂的基础数据
/// </summary>
/// <returns></returns>
public List <DrugsBase_Manufacturer_Model> GetManufactInitData()
{
try
{
List <DrugsBase_Manufacturer_Model> objs = new List <DrugsBase_Manufacturer_Model>();
string sql = @"SELECT t1.*, t2.DrugNumber AS DrugNumber
FROM
(SELECT DrugsBase_Manufacturer_ID, DrugsBase_Manufacturer
FROM DrugsBase_Manufacturer
WHERE DrugsBase_Manufacturer IN (SELECT DrugsBase_Manufacturer FROM product_online_v)) AS t1,
(SELECT
a.DrugsBase_Manufacturer AS DrugsBase_Manufacturer,
count(a.DrugsBase_Manufacturer) AS DrugNumber
FROM
dbo.product_online_v a
GROUP BY a.DrugsBase_Manufacturer) AS t2
WHERE t1.DrugsBase_Manufacturer=t2.DrugsBase_Manufacturer
ORDER BY t2.DrugNumber DESC";
DataTable dt = base.ExecuteTableForCache(sql, DateTime.Now.AddDays(5));
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
foreach (DataRow rowObj in dt.Rows)
{
DrugsBase_Manufacturer_Model obj = new DrugsBase_Manufacturer_Model();
int id;
if (int.TryParse(rowObj["DrugsBase_Manufacturer_ID"].ToString(), out id))
{
obj.DrugsBase_Manufacturer_ID = id;
}
obj.DrugsBase_Manufacturer1 = rowObj["DrugsBase_Manufacturer"].ToString().Trim();
obj.DrugNumber = (int)rowObj["DrugNumber"];
objs.Add(obj);
}
}
return(objs);
}
catch
{
return(null);
}
}
/// <summary>
/// 获取进口药生产企业及进口药数量
/// </summary>
/// <returns></returns>
public List <DrugsBase_Manufacturer_Model> GetImpDrugsManufacts()
{
List <DrugsBase_Manufacturer_Model> objs = new List <DrugsBase_Manufacturer_Model>();
string sql = @"SELECT DISTINCT tt1.drugsBase_Manufacturer_Id,
tt1.drugsBase_Manufacturer,
tt2.drugNum
FROM View_ImportedPharm_Manufacturer_Pharm tt1
INNER JOIN
( SELECT
drugsBase_Manufacturer, count(drugsBase_Manufacturer) AS drugNum
FROM (SELECT DISTINCT drugsBase_Manufacturer, drugsBase_Id FROM View_ImportedPharm_Manufacturer_Pharm) t1
GROUP BY drugsBase_Manufacturer
) tt2
ON tt1.drugsBase_Manufacturer=tt2.drugsBase_Manufacturer";
DataTable dt = base.ExecuteTableForCache(sql, DateTime.Now.AddHours(1));
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
foreach (DataRow rowObj in dt.Rows)
{
DrugsBase_Manufacturer_Model obj = new DrugsBase_Manufacturer_Model();
obj.DrugsBase_Manufacturer_ID = (int)rowObj["DrugsBase_Manufacturer_Id"];; //生产企业Id
obj.DrugsBase_Manufacturer1 = rowObj["DrugsBase_Manufacturer"].ToString().Trim(); //生产企业名称
obj.DrugNumber = (int)rowObj["drugNum"]; //统计数量
obj.PYJM = GetChineseSpell(obj.DrugsBase_Manufacturer1);
objs.Add(obj);
}
}
List <DrugsBase_Manufacturer_Model> rtnObj = objs.OrderByDescending(b => b.DrugNumber).OrderBy(a => a.PYJM_FirstChar_).ToList <DrugsBase_Manufacturer_Model>();
return(rtnObj);
}
