public IBillsTypeDAO CreateBillsTypeDAO()
{
IBillsTypeDAO dao = null;
if (_DbType == DatabaseType.SqlServer)
{
dao = new SqlServer.BillsTypeDAO();
}
else if (_DbType == DatabaseType.MySql)
{
dao = new SqlServer.BillsTypeDAO();
}
else if (_DbType == DatabaseType.Oracole)
{
dao = new SqlServer.BillsTypeDAO();
}
else if (_DbType == DatabaseType.DB2)
{
dao = new SqlServer.BillsTypeDAO();
}
else if (_DbType == DatabaseType.Postgre)
{
dao = new SqlServer.BillsTypeDAO();
}
return(dao);
}
/// <summary>
/// 根据条件进行模糊搜索
/// </summary>
/// <param name="searchCond">搜索条件</param>
/// <returns></returns>
public List <BillsType> SearchBillsType(string searchCond)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IBillsTypeDAO dao = DAOFactory.Instance.CreateBillsTypeDAO();
return(dao.SearchBillsType(searchCond, conn));
}
}
/// <summary>
/// 根据ID查找一个票据类型信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public BillsType GetBillsType(int id)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IBillsTypeDAO dao = DAOFactory.Instance.CreateBillsTypeDAO();
return(dao.SelectBillsType(id, conn));
}
}
/// <summary>
/// 获取所有票据类型信息
/// </summary>
/// <returns></returns>
public List <BillsType> GetAllBillsTypes()
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IBillsTypeDAO dao = DAOFactory.Instance.CreateBillsTypeDAO();
return(dao.SelectAllBillsType(conn));
}
}
/// <summary>
/// 删除一条票据类型信息
/// </summary>
/// <param name="id"></param>
/// <param name="deleter"></param>
public void DeleteBillsType(BillsType billsType, string deleter)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IBillsTypeDAO dao = DAOFactory.Instance.CreateBillsTypeDAO();
dao.DeleteBillsType(billsType.ID, conn);
}
}
/// <summary>
/// 保存修改过的票据类型信息
/// </summary>
/// <param name="type"></param>
/// <param name="Modifier"></param>
public void SaveBillsType(BillsType type, string Modifier)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IBillsTypeDAO dao = DAOFactory.Instance.CreateBillsTypeDAO();
dao.UpdateBillsType(type, conn);
}
}
/// <summary>
/// 新增一条票据类别
/// </summary>
/// <param name="type"></param>
/// <param name="creator"></param>
public void CreateBillsType(BillsType type, string creator)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IBillsTypeDAO dao = DAOFactory.Instance.CreateBillsTypeDAO();
dao.InsertBillsType(type, conn);
}
}
