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