public ICompanyTypeDAO CreateCompanyTypeDAO()
{
ICompanyTypeDAO dao = null;
if (_DbType == DatabaseType.SqlServer)
{
dao = new SqlServer.CompanyTypeDAO();
}
else if (_DbType == DatabaseType.MySql)
{
dao = new SqlServer.CompanyTypeDAO();
}
else if (_DbType == DatabaseType.Oracole)
{
dao = new SqlServer.CompanyTypeDAO();
}
else if (_DbType == DatabaseType.DB2)
{
dao = new SqlServer.CompanyTypeDAO();
}
else if (_DbType == DatabaseType.Postgre)
{
dao = new SqlServer.CompanyTypeDAO();
}
return(dao);
}
/// <summary>
/// 根据条件进行模糊搜索
/// </summary>
/// <param name="searchCond">搜索条件</param>
/// <returns></returns>
public List <CompanyType> SearchCompanyType(string searchCond)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
ICompanyTypeDAO dao = DAOFactory.Instance.CreateCompanyTypeDAO();
return(dao.SearchCompanyType(searchCond, searchCond, conn));
}
}
/// <summary>
/// 根据ID查找一个关联单位类别信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public CompanyType GetCompanyType(int id)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
ICompanyTypeDAO dao = DAOFactory.Instance.CreateCompanyTypeDAO();
return(dao.SelectCompanyType(id, conn));
}
}
/// <summary>
/// 获取所有关联单位类型信息
/// </summary>
/// <returns></returns>
public List <CompanyType> GetAllCompanyTypes()
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
ICompanyTypeDAO dao = DAOFactory.Instance.CreateCompanyTypeDAO();
return(dao.SelectAllCompanyType(conn));
}
}
/// <summary>
/// 删除一条关联单位类型信息
/// </summary>
/// <param name="id"></param>
/// <param name="deleter"></param>
public void DeleteCompanyType(int id, string deleter)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
ICompanyTypeDAO dao = DAOFactory.Instance.CreateCompanyTypeDAO();
dao.DeleteCompanyType(id, conn);
}
}
/// <summary>
/// 保存修改过的关联单位类型信息
/// </summary>
/// <param name="type"></param>
/// <param name="Modifier"></param>
public void SaveCompanyType(CompanyType type, string Modifier)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
ICompanyTypeDAO dao = DAOFactory.Instance.CreateCompanyTypeDAO();
dao.UpdateCompanyType(type, conn);
}
}
/// <summary>
/// 新增一条关联单位类型
/// </summary>
/// <param name="type"></param>
/// <param name="creator"></param>
public void CreateCompanyType(CompanyType type, string creator)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
ICompanyTypeDAO dao = DAOFactory.Instance.CreateCompanyTypeDAO();
dao.InsertCompanyType(type, conn);
}
}
