📄 goodsbussiness.cs
字号:
///////////////////////////////////////////////////////////
// GoodsBussiness.cs
// Implementation of the Class GoodsBussiness
// Generated by Enterprise Architect
// Created on: 13-五月-2006 19:53:13
///////////////////////////////////////////////////////////
using BookShop.Entity;
using System.Data;
using BookShop.DataAccess;
using System;
namespace BookShop.Bussiness
{
/// <summary>
/// 货物业务层
/// </summary>
public class GoodsBussiness
{
public GoodsBussiness()
{
}
~GoodsBussiness()
{
}
public virtual void Dispose()
{
}
/// <summary>
/// 添加新货物
/// </summary>
/// <param name="goods"></param>
public bool AddGoods(ref GoodsEntity goods)
{
return new GoodsAccess().AddGoods(ref goods);
}
/// <summary>
/// 修改货物信息
/// </summary>
/// <param name="goods"></param>
public bool ModifyGoods(GoodsEntity goods)
{
return new GoodsAccess().ModifyGoods(goods);
}
/// <summary>
/// 修改货物库存
/// </summary>
/// <param name="goods"></param>
public bool ModifyGoodsCount(GoodsEntity goods)
{
return new GoodsAccess().ModifyGoodsCount(goods);
}
/// <summary>
/// 修改货物储存量,同时将货物入发货表
/// </summary>
/// <param name="goods"></param>
/// <param name="order"></param>
public bool MoveToSent(GoodsEntity goods, OrderEntity order, UserEntity user)
{
return new GoodsAccess().MoveToSent(goods, order, user);
}
public DataTable GetGoodsByCategoryID(int categoryID)
{
return new GoodsAccess().GetGoodsByCategoryID(categoryID);
}
public bool AddGoodsDiscount(DiscountEntity discount)
{
return new GoodsAccess().AddGoodsDiscount(discount);
}
/// <summary>
/// 根据商品ID获取商品信息
/// </summary>
/// <param name="goods"></param>
/// <returns></returns>
public bool GetGoodsByID(ref GoodsEntity goods)
{
DataTable goodsInfo = new GoodsAccess().GetGoodsByID(ref goods);
if (goodsInfo.Rows.Count == 0)
return false;
else
{
goods.Contents = Convert.ToString(goodsInfo.Rows[0]["SContents"]);
if (!Convert.IsDBNull(goodsInfo.Rows[0]["SImage"]))
goods.Image = Convert.ToString(goodsInfo.Rows[0]["SImage"]);
goods.Intro = Convert.ToString(goodsInfo.Rows[0]["SIntro"]);
goods.ISBN = Convert.ToString(goodsInfo.Rows[0]["SISBN"]);
goods.Name = Convert.ToString(goodsInfo.Rows[0]["SName"]);
goods.PageCount = Convert.ToInt32(goodsInfo.Rows[0]["SPageCount"]);
goods.PageSize = Convert.ToInt32(goodsInfo.Rows[0]["SPageSize"]);
goods.Price = Convert.ToSingle(goodsInfo.Rows[0]["SPrice"]);
goods.PublishDate = Convert.ToDateTime(goodsInfo.Rows[0]["SPublishDate"]);
goods.Publisher = Convert.ToString(goodsInfo.Rows[0]["SPublisher"]);
goods.PublishTimes = Convert.ToInt32(goodsInfo.Rows[0]["SPublishTimes"]);
goods.StorageCount = Convert.ToInt32(goodsInfo.Rows[0]["SStorageCount"]);
goods.WordCount = Convert.ToInt32(goodsInfo.Rows[0]["SWordCount"]);
goods.Writer = Convert.ToString(goodsInfo.Rows[0]["SWriter"]);
return true;
}
}
/// <summary>
/// 删除指定ID的货物的折扣信息
/// </summary>
/// <param name="discount"></param>
public void DeleteDiscount(DiscountEntity discount)
{
new GoodsAccess().DeleteDiscount(discount);
}
/// <summary>
/// 设置货物点击率
/// </summary>
/// <param name="goods"></param>
public void SetGoodsClicked(GoodsEntity goods)
{
if (new GoodsAccess().IsGoodsClickedExist(goods))
new GoodsAccess().SetGoodsClicked(goods);
else
new GoodsAccess().AddGoodsClicked(goods);
}
/// <summary>
/// 根据点击率获取前10个商品列表
/// </summary>
/// <returns></returns>
public DataTable GetGoodsByClicked()
{
return new GoodsAccess().GetGoodsByClicked();
}
/// <summary>
/// 根据入库时间获取前10个商品列表
/// </summary>
/// <returns></returns>
public DataTable GetGoodsByInTime()
{
return new GoodsAccess().GetGoodsByInTime();
}
/// <summary>
/// 根据货物ID获取折扣信息
/// </summary>
/// <param name="goods"></param>
/// <returns></returns>
public DiscountEntity[] GetDiscountByGoodsID(GoodsEntity goods)
{
DataTable dtDiscount = new GoodsAccess().GetDiscountByGoodsID(goods);
DiscountEntity[] discount = new DiscountEntity[3];
discount[0] = new DiscountEntity();
discount[0].GoodsID = goods.GoodsID;
discount[0].Price = Convert.ToSingle(dtDiscount.Rows[0]["SDiscount"]);
discount[0].MemberLevel = 1;
discount[1] = new DiscountEntity();
discount[1].GoodsID = goods.GoodsID;
discount[1].Price = Convert.ToSingle(dtDiscount.Rows[1]["SDiscount"]);
discount[1].MemberLevel = 2;
discount[2] = new DiscountEntity();
discount[2].GoodsID = goods.GoodsID;
discount[2].Price = Convert.ToSingle(dtDiscount.Rows[2]["SDiscount"]);
discount[2].MemberLevel = 3;
return discount;
}
}//end GoodsBussiness
}//end namespace Bussiness
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -