/// <summary>
/// 查询药品库存-每组均要查询一次
/// </summary>
/// <returns>药品库存</returns>
public List <IP_DrugStore> GetDrugStore()
{
List <IP_DrugStore> drugStoreList = new List <IP_DrugStore>();
string sql = @" SELECT a.DrugID ,
d.ValidAmount StoreAmount , --有效库存
a.DeptID ExecDeptId
FROM DS_Storage a
INNER JOIN DS_ValidStorage d ON a.StorageID = d.StorageID
INNER JOIN DG_HospMakerDic b ON a.DrugID = b.DrugID AND b.WorkID = a.WorkID AND b.IsStop = 0
INNER JOIN DG_CenterSpecDic c ON c.CenteDrugID=b.CenteDrugID AND c.IsStop = 0
WHERE d.WorkID={0}";
sql = string.Format(sql, WorkId);
DataTable dt = oleDb.GetDataTable(sql);
foreach (DataRow dr in dt.Rows)
{
IP_DrugStore drugStore = new IP_DrugStore();
drugStore.DrugID = Convert.ToInt32(dr["DrugID"]);
drugStore.ExecDeptId = Convert.ToInt32(dr["ExecDeptId"]);
drugStore.ExecDeptName = string.Empty;
drugStore.StoreAmount = Convert.ToDecimal(dr["StoreAmount"]);
drugStoreList.Add(drugStore);
}
return(drugStoreList);
}
/// <summary>
/// 判断项目是否停用 仅仅在算法开头查询一次
/// </summary>
/// <returns>项目信息</returns>
public List <IP_DrugStore> GetItemInfo()
{
List <IP_DrugStore> itemStoreList = new List <IP_DrugStore>();
string sql = @"--收费项目 3
SELECT a.ItemID ,
9999 StoreAmount ,
0 ExecDeptId ,
'' ExecDeptName
FROM Basic_HospFeeItem a
INNER JOIN Basic_CenterFeeItem b ON a.CenterItemID = b.FeeID AND b.IsStop = 0
WHERE a.IsStop = 0
AND a.IsBle=1
AND a.WorkID={0}
--组合项目 4
UNION ALL
SELECT a.ExamItemID ItemID ,
9999 StoreAmount ,
ISNULL(b.ExecDeptID,0) ExecDeptId ,
dbo.fnGetDeptName(b.ExecDeptID) ExecDeptName
FROM Basic_ExamItem a
INNER JOIN Basic_ExamType b ON a.ExamTypeID = b.ExamTypeID AND b.DelFlag=0
WHERE a.DelFlag = 0 AND a.WorkID={0}
UNION ALL
SELECT a.MaterialID ItemID ,
9999 StoreAmount , --有效库存
0 ExecDeptId ,
'' ExecDeptName
FROM MW_HospMakerDic a
INNER JOIN MW_CenterSpecDic b ON a.CenterMatID=b.CenterMatID
WHERE a.IsStop = 0 AND b.IsStop = 0 AND a.IsBle=1 AND a.WorkID={0} ";
sql = string.Format(sql, WorkId);
DataTable dt = oleDb.GetDataTable(sql);
foreach (DataRow dr in dt.Rows)
{
IP_DrugStore drugStore = new IP_DrugStore();
drugStore.DrugID = Convert.ToInt32(dr["ItemID"]);
drugStore.ExecDeptId = Convert.ToInt32(dr["ExecDeptId"]);
drugStore.ExecDeptName = dr["ExecDeptName"].ToString();
drugStore.StoreAmount = Convert.ToDecimal(dr["StoreAmount"]);
itemStoreList.Add(drugStore);
}
return(itemStoreList);
}
