public IDrugsDAO CreateDrugsDAO()
{
IDrugsDAO dao = null;
if (_DbType == DatabaseType.SqlServer)
{
dao = new SqlServer.DrugsDAO();
}
else if (_DbType == DatabaseType.MySql)
{
dao = new SqlServer.DrugsDAO();
}
else if (_DbType == DatabaseType.Oracole)
{
dao = new SqlServer.DrugsDAO();
}
else if (_DbType == DatabaseType.DB2)
{
dao = new SqlServer.DrugsDAO();
}
else if (_DbType == DatabaseType.Postgre)
{
dao = new SqlServer.DrugsDAO();
}
return(dao);
}
/// <summary>
/// 获取指定编码的药品
/// </summary>
/// <param name="code"></param>
/// <returns></returns>
public Drugs GetDrugsByCode(string code)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IDrugsDAO dao = DAOFactory.Instance.CreateDrugsDAO();
return(dao.SelectDrug(code, conn));
}
}
/// <summary>
/// 根据ID查找一个药品信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Drugs RetrieveDrug(int id)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IDrugsDAO dao = DAOFactory.Instance.CreateDrugsDAO();
return(dao.SelectDrug(id, conn));
}
}
/// <summary>
/// 获取所有药品信息
/// </summary>
/// <returns></returns>
public List <Drugs> GetAllDrugs()
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IDrugsDAO dao = DAOFactory.Instance.CreateDrugsDAO();
return(dao.SelectAllDrugs(conn));
}
}
/// <summary>
/// 删除一个药品信息
/// </summary>
/// <param name="drug"></param>
/// <param name="Deleter"></param>
public void DeleteDrug(Drugs drug, string Deleter)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IDrugsDAO dao = DAOFactory.Instance.CreateDrugsDAO();
dao.DeleteDrug(drug.ID, conn);
}
}
/// <summary>
/// 保存修改过的药品信息
/// </summary>
/// <param name="drug"></param>
/// <param name="Modifier"></param>
public void SaveDrug(Drugs drug, string Modifier)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IDrugsDAO dao = DAOFactory.Instance.CreateDrugsDAO();
dao.UpdateDrug(drug, conn);
}
}
/// <summary>
/// 增加一个药品信息
/// </summary>
/// <param name="drug"></param>
/// <param name="creator"></param>
public void CreateDrug(Drugs drug, string creator)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IDrugsDAO dao = DAOFactory.Instance.CreateDrugsDAO();
dao.InsertDrug(drug, conn);
}
}
/// <summary>
/// 根据条件进行模糊搜索
/// </summary>
/// <param name="searchCond">搜索条件</param>
/// <returns></returns>
public List <Drugs> SearchDrugs(string searchCond)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IDrugsDAO dao = DAOFactory.Instance.CreateDrugsDAO();
SearchDrugsTemplate template = new SearchDrugsTemplate();
template.Code = searchCond;
template.Name = searchCond;
template.From = searchCond;
template.Category = searchCond;
return(dao.SearchDrugs(template, conn));
}
}
