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