source/HF.Core/HF.Sale.Data/SaleGoodsData.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using HF.Framework;
using HF.DataAccess.SqlDataContract;
using HF.DataAccess.DBAgent;
namespace HF.Sale.Data
{
    public class SaleGoodsData
    {
        /// <summary>
        /// 获取商品信息
        /// </summary>
        /// <param name="goodsId"></param>
        /// <param name="organizeId"></param>
        /// <returns></returns>
        public DataRow GetGoodsRow(string goodsId, string organizeId)
        {
            string tmpStr = @"select * from Goods_BaseInfo where   id=@goodsId and OrganizeId=@OrganizeId  ";
            SqlDataItem sqlItem = new SqlDataItem();
            sqlItem.CommandText = tmpStr;
            sqlItem.DatabaseName = SaleModuleHelper.CfgDataBaseName;
            sqlItem.AppendParameter("@goodsId", goodsId);
            sqlItem.AppendParameter("@OrganizeId", organizeId);
            ClientDBAgent agent = new ClientDBAgent();
            DataTable dt= agent.ExecuteDataTable(sqlItem);
            if (dt.IsEmpty() == false)
                return dt.Rows[0];
            else return null;
        }
        /// <summary>
        /// 获取商品分类信息
        /// </summary>
        /// <param name="goodsCateId"></param>
        /// <param name="organizeId"></param>
        /// <returns></returns>
        public DataRow GetGoodsCateRow(string goodsCateId, string organizeId)
        {
            string tmpStr = @"select * from Goods_Cate where   CateId=@goodsCateId and OrganizeId=@OrganizeId  ";
            SqlDataItem sqlItem = new SqlDataItem();
            sqlItem.CommandText = tmpStr;
            sqlItem.DatabaseName = SaleModuleHelper.CfgDataBaseName;
            sqlItem.AppendParameter("@goodsCateId", goodsCateId);
            sqlItem.AppendParameter("@OrganizeId", organizeId);
            ClientDBAgent agent = new ClientDBAgent();
            DataTable dt = agent.ExecuteDataTable(sqlItem);
            if (dt.IsEmpty() == false)
                return dt.Rows[0];
            else return null;
        }
        /// <summary>
        /// 获得商品下级分类
        /// </summary>
        /// <param name="cateId">父部门Id</param>
        /// <param name="organizeId">所属组织Id</param>
        /// <returns>子部门table</returns>
        public DataTable GetChildCates(string cateId, string organizeId, string sort)
        {