public GoodsFrom GetGoodsFromByCode(string code) { using (IDbConnection conn = DAOFactory.Instance.OpenConnection()) { IGoodsFromDAO dao = DAOFactory.Instance.CreateGoodsFromDAO(); return(dao.SelectGoodsFrom(code, conn)); } }
/// <summary> /// /// </summary> /// <param name="id"></param> /// <returns></returns> public GoodsFrom RetrieveGoodsFrom(int id) { using (IDbConnection conn = DAOFactory.Instance.OpenConnection()) { IGoodsFromDAO dao = DAOFactory.Instance.CreateGoodsFromDAO(); return(dao.SelectGoodsFrom(id, conn)); } }
/// <summary> /// /// </summary> /// <returns></returns> public List <GoodsFrom> GetAllGoodsFroms() { using (IDbConnection conn = DAOFactory.Instance.OpenConnection()) { IGoodsFromDAO dao = DAOFactory.Instance.CreateGoodsFromDAO(); return(dao.SelectAllGoodsFroms(conn)); } }
/// <summary> /// /// </summary> /// <param name="from"></param> /// <param name="deleter"></param> public void DeleteGoodsFrom(GoodsFrom from, string deleter) { using (IDbConnection conn = DAOFactory.Instance.OpenConnection()) { IGoodsFromDAO dao = DAOFactory.Instance.CreateGoodsFromDAO(); dao.DeleteGoodsFrom(from.ID, conn); } }
/// <summary> /// /// </summary> /// <param name="from"></param> /// <param name="modifier"></param> public void SaveGoodsFrom(GoodsFrom from, string modifier) { using (IDbConnection conn = DAOFactory.Instance.OpenConnection()) { IGoodsFromDAO dao = DAOFactory.Instance.CreateGoodsFromDAO(); dao.UpdateGoodsFrom(from, conn); } }
/// <summary> /// /// </summary> /// <param name="from"></param> /// <param name="creator"></param> public void CreateGoodsFrom(GoodsFrom from, string creator) { using (IDbConnection conn = DAOFactory.Instance.OpenConnection()) { IGoodsFromDAO dao = DAOFactory.Instance.CreateGoodsFromDAO(); dao.InsertGoodsFrom(from, conn); } }
public IGoodsFromDAO CreateGoodsFromDAO() { IGoodsFromDAO dao = null; if (_DbType == DatabaseType.SqlServer) { dao = new SqlServer.GoodsFromDAO(); } else if (_DbType == DatabaseType.MySQL) { //dao = new MySQL.EventLogDAO(); } return(dao); }