public IDrugCategoryDAO CreateDrugCategoryDAO()
{
IDrugCategoryDAO dao = null;
if (_DbType == DatabaseType.SqlServer)
{
dao = new SqlServer.DrugCategoryDAO();
}
else if (_DbType == DatabaseType.MySql)
{
dao = new SqlServer.DrugCategoryDAO();
}
else if (_DbType == DatabaseType.Oracole)
{
dao = new SqlServer.DrugCategoryDAO();
}
else if (_DbType == DatabaseType.DB2)
{
dao = new SqlServer.DrugCategoryDAO();
}
else if (_DbType == DatabaseType.Postgre)
{
dao = new SqlServer.DrugCategoryDAO();
}
return(dao);
}
/// <summary>
/// 根据条件进行模糊搜索
/// </summary>
/// <param name="searchCond">搜索条件</param>
/// <returns></returns>
public List <DrugCategory> SearchDrugCategory(string searchCond)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IDrugCategoryDAO dao = DAOFactory.Instance.CreateDrugCategoryDAO();
return(dao.SearchDrugCategory(searchCond, conn));
}
}
/// <summary>
/// 根据ID查找相应的药品种类
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DrugCategory RetrieveDrugCategory(int id)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IDrugCategoryDAO dao = DAOFactory.Instance.CreateDrugCategoryDAO();
return(dao.SelectDrugCategory(id, conn));
}
}
/// <summary>
/// 获取所有药品种类
/// </summary>
/// <returns></returns>
public List <DrugCategory> GetAllDrugCategory()
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IDrugCategoryDAO dao = DAOFactory.Instance.CreateDrugCategoryDAO();
return(dao.SelectAllDrugCategory(conn));
}
}
/// <summary>
/// 删除一条药品种类
/// </summary>
/// <param name="category"></param>
/// <param name="deleter"></param>
public void DeleteDrugCategory(DrugCategory category, string deleter)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IDrugCategoryDAO dao = DAOFactory.Instance.CreateDrugCategoryDAO();
dao.DeleteDrugCategory(category.ID, conn);
}
}
/// <summary>
/// 保存修改的药品种类
/// </summary>
/// <param name="category"></param>
/// <param name="modifier"></param>
public void SaveDrugCategory(DrugCategory category, string modifier)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IDrugCategoryDAO dao = DAOFactory.Instance.CreateDrugCategoryDAO();
dao.UpdateDrugCategory(category, conn);
}
}
/// <summary>
/// 增加一个药品种类
/// </summary>
/// <param name="category"></param>
/// <param name="creator"></param>
public void CreateDrugCategory(DrugCategory category, string creator)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IDrugCategoryDAO dao = DAOFactory.Instance.CreateDrugCategoryDAO();
dao.InsertDrugCategory(category, conn);
}
}
