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