using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CY.IBaseDAL;
using CY.Model;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data;
using CY.Infrastructure.Query;
namespace CY.IDAL
{
    /// <summary>
    /// 办公系统货品类别-数据库操作接口
    /// </summary>
    public interface IOA_CommodityDAL : ICommonDAL, IPaging<OA_Commodity>, IGetAllModel<OA_Commodity>
    {
        DataTable SelectModelPage(Guid FirmId, string IsPaper, string IsUsed);
        IEnumerable<Model.OA_Commodity> SelectModelPage(Pagination pa, Guid FirmId, string CommodityName);
        Model.OA_Commodity SelectSingleModel(string Keyid);
        
        /// <summary>
        /// 得到厂商对应的纸张类别ID
        /// </summary>
        /// <param name="FirmId"></param>
        /// <returns></returns>
        Model.OA_Commodity getCommodityId(Guid FirmId);
          /// <summary>
        /// 得到厂商对应的版材Id
        /// </summary>
        /// <param name="FirmId"></param>
        /// <returns></returns>
        Model.OA_Commodity getBanCaiId(Guid FirmId);
    }
}