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