/// <summary>
/// 根据ID获取一个商品
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Goods RetrieveGoods(int id)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IGoodsDAO dao = DAOFactory.Instance.CreateGoodsDAO();
return(dao.SelectGoods(id, conn));
}
}
/// <summary>
/// 获取指定编码的商品
/// </summary>
/// <param name="code"></param>
/// <returns></returns>
public Goods GetGoodsByCode(string code)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IGoodsDAO dao = DAOFactory.Instance.CreateGoodsDAO();
return(dao.SelectGoods(code, conn));
}
}
/// <summary>
/// 获取所有的商品列表
/// </summary>
/// <returns></returns>
public List <Goods> GetAllGoods()
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IGoodsDAO dao = DAOFactory.Instance.CreateGoodsDAO();
return(dao.SelectAllGoods(conn));
}
}
/// <summary>
/// 删除一个商品
/// </summary>
/// <param name="goods"></param>
/// <param name="deleter"></param>
public void DeleteGoods(Goods goods, string deleter)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IGoodsDAO dao = DAOFactory.Instance.CreateGoodsDAO();
dao.DeleteGoods(goods.ID, conn);
}
}
/// <summary>
/// 保存修改过的商品信息
/// </summary>
/// <param name="goods"></param>
/// <param name="modifier"></param>
public void SaveGoods(Goods goods, string modifier)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IGoodsDAO dao = DAOFactory.Instance.CreateGoodsDAO();
dao.UpdateGoods(goods, conn);
}
}
/// <summary>
/// 创建一个新商品
/// </summary>
/// <param name="goods"></param>
/// <param name="creator"></param>
public void CreateGoods(Goods goods, string creator)
{
using (IDbConnection conn = DAOFactory.Instance.OpenConnection())
{
IGoodsDAO dao = DAOFactory.Instance.CreateGoodsDAO();
dao.InsertGoods(goods, conn);
}
}
public IGoodsDAO CreateGoodsDAO()
{
IGoodsDAO dao = null;
if (_DbType == DatabaseType.SqlServer)
{
dao = new SqlServer.GoodsDAO();
}
else if (_DbType == DatabaseType.MySQL)
{
//dao = new MySQL.EventLogDAO();
}
return(dao);
}
