public IDrugFromDAO CreateDrugFromDAO()
{
IDrugFromDAO dao = null;
if (_DbType == DatabaseType.SqlServer)
{
dao = new SqlServer.DrugFromDAO();
}
else if (_DbType == DatabaseType.MySql)
{
dao = new SqlServer.DrugFromDAO();
}
else if (_DbType == DatabaseType.Oracole)
{
dao = new SqlServer.DrugFromDAO();
}
else if (_DbType == DatabaseType.DB2)
{
dao = new SqlServer.DrugFromDAO();
}
else if (_DbType == DatabaseType.Postgre)
{
dao = new SqlServer.DrugFromDAO();
}
return(dao);
}
/// <summary>
/// 根据条件进行模糊搜索
/// </summary>
/// <param name="searchCond">搜索条件</param>
/// <returns></returns>
public List <DrugFrom> SearchDrugFrom(string searchCond)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IDrugFromDAO dao = DAOFactory.Instance.CreateDrugFromDAO();
return(dao.SearchDrugFrom(searchCond, conn));
}
}
/// <summary>
/// 根据ID查找药品产地
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DrugFrom RetrieveDrugsFrom(int id)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IDrugFromDAO dao = DAOFactory.Instance.CreateDrugFromDAO();
return(dao.SelectDrugFrom(id, conn));
}
}
/// <summary>
/// 查出所有的药品产地
/// </summary>
/// <returns></returns>
public List <DrugFrom> GetAllDrugFrom()
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IDrugFromDAO dao = DAOFactory.Instance.CreateDrugFromDAO();
return(dao.SelectAllDrugFrom(conn));
}
}
/// <summary>
/// 删除一条药品产地
/// </summary>
/// <param name="from"></param>
/// <param name="deleter"></param>
public void DeleteDrugFrom(DrugFrom from, string deleter)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IDrugFromDAO dao = DAOFactory.Instance.CreateDrugFromDAO();
dao.DeleteDrugFrom(from.ID, conn);
}
}
/// <summary>
/// 保存修改的药品产地
/// </summary>
/// <param name="from"></param>
/// <param name="modifier"></param>
public void SaveDrugFrom(DrugFrom from, string modifier)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IDrugFromDAO dao = DAOFactory.Instance.CreateDrugFromDAO();
dao.UpdateDrugFrom(from, conn);
}
}
/// <summary>
/// 增加一个药品产地
/// </summary>
/// <param name="from"></param>
/// <param name="creator"></param>
public void CreateDrugFrom(DrugFrom from, string creator)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IDrugFromDAO dao = DAOFactory.Instance.CreateDrugFromDAO();
dao.InsertDrugFrom(from, conn);
}
}
