using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
//using WMS.Model.Dictionary;
//using WMS.Model.Order;
namespace WMS.IData.ICommon
{
    public interface ICommon
    {
        DataTable GetTable(string sql);
        /// <summary>
        /// 通过指定的字段属性查询数据
        /// </summary>
        /// <returns></returns>
        DataTable GetCustomCtrlData(string tableName, string clmValue, string clmName, string whereSelect, string clmClassName);

        /// <summary>
        /// 返回通用查询的数据
        /// </summary>
        /// <typeparam name="T">表名</typeparam>
        /// <param name="column">查询的列</param>
        /// <param name="clmValue">查询条件</param>
        /// <param name="tableName">表名</param>
        /// <returns></returns>
        DataTable GetListData(List<string> column, Dictionary<string, string> clmValue, string tableName);
     
        /// <summary>
        /// 获取商品分类
        /// </summary>
        /// <param name="status">1使用 0停用</param>
        /// <param name="user_id">用户编号</param>
        /// <returns></returns>
        DataSet GetGoods_Category(string status, string user_id);

        /// <summary>
        /// 获取商品信息
        /// </summary>
        /// <param name="strGooID">商品分类编号</param>
        /// <param name="user_id">用户编号</param>
        /// <returns></returns>
        DataSet Get_GoodsInfo(string strGooID, string user_id);

        /// <summary>
        /// 获取采购类型
        /// </summary>
        /// <returns></returns>
        DataSet GetPurchaseType();

        /// <summary>
        /// 获取来源类型
        /// </summary>
        /// <returns></returns>
        DataSet GetSourceType();
        /// <summary>
        /// 获取活动类型
        /// </summary>
        /// <returns></returns>
        DataSet GetActTypte();

        /// <summary>
        /// 获取仓库信息
        /// </summary>
        /// <param name="user_id">用户编号</param>
        /// <returns></returns>
        DataSet GetStorage(string user_id);
        /// <summary>
        /// 库区信息
        /// </summary>
        /// <param name="user_id">用户编号</param>
        /// <returns></returns>
        DataSet GetArea(string id, string user_id);
        /// <summary>
        /// 根据仓库信息获取仓库的库位信息
        /// </summary>
        /// <param name="StorageID">仓库编号</param>
        /// <returns></returns>
        DataSet GetLocation(string StorageID);
        /// <summary>
        /// 供应商信息
        /// </summary
        /// <param name="user_id">用户编号</param>
        /// <returns></returns>
        DataSet GetProviderType(string user_id);

        /// <summary>
        /// 付款方式类型
        /// </summary>
        /// <returns></returns>
        DataSet GetPayType();
        ///// <summary>
        ///// 获取库存管理类型
        ///// </summary>
        ///// <param name="type"></param>
        ///// <returns></returns>
        //DataSet GetWMSType(WMS.Model.TypeModel.WMSType type);
        /// <summary>
        /// 获取卸车人信息
        /// </summary>
        /// <returns></returns>
        DataSet GetUnloadMan();

        /// <summary>
        /// 物流公司信息
        /// </summary>
        /// <returns></returns>
        DataSet GetLogisticsComInfo();

        /// <summary>
        /// 获取结果集
        /// </summary>
        /// <param name="col">列名</param>
        /// <param name="table">表名</param>
        /// <param name="where">查询条件</param>
        /// <returns></returns>
        DataSet GetDataSet(string col, string table, string where);

        /// <summary>
        /// 获取公司类型
        /// </summary>
        /// <returns></returns>
        DataSet GetCompanyType();

        /// <summary>
        /// 获取公司分类
        /// </summary>
        /// <returns></returns>
        DataSet GetCompanyCategory();

        /// <summary>
        /// 获取公司编号和公司名称
        /// </summary>
        /// <returns></returns>
        DataSet GetCompanyIDName();

        /// <summary>
        /// 获取部门编号和部门名称
        /// </summary>
        /// <returns></returns>
        DataSet GetDepartmentIDName();

        /// <summary>
        /// 获取公司部门
        /// </summary>
        /// <returns></returns>
        DataTable GetComDetDataTable();

        /// <summary>
        /// 获取员工信息
        /// </summary>
        /// <param name="ComId">公司编号</param>
        /// <param name="DetId">部门编号</param>
        /// <param name="UserName">员工名称</param>
        /// <returns></returns>
        DataTable GetUserDataTable(string ComId, string DetId, string UserName);

        /// <summary>
        /// 获取集团编号和集团名称
        /// </summary>
        /// <returns></returns>
        DataSet GetGroupIDName();

        /// <summary>
        /// 获取供应商类型
        /// </summary>
        /// <returns></returns>
        DataSet GetProviderType();

        /// <summary>
        /// 获取省份
        /// </summary>
        /// <returns></returns>
        DataSet GetProvince();

        /// <summary>
        /// 根据省份编号获取城市
        /// </summary>
        /// <param name="strProId">省份编号</param>
        /// <returns></returns>
        DataSet GetCityByPRO_ID(string strProId);

        /// <summary>
        /// 根据城市编号获取区
        /// </summary>
        /// <param name="CityId">城市编号</param>
        /// <returns></returns>
        DataSet GetTownByCityId(string strCityId);

        /// <summary>
        /// 获取字典类型对照信息
        /// </summary>
        /// <returns></returns>
        DataSet GetDictionaryType();

        /// <summary>
        /// 根据类型代码查询出类型字典信息
        /// </summary>
        /// <param name="strTypeId">类型代码</param>
        /// <returns></returns>
        DataSet GetTypeInfo(int strTypeId);

        ///// <summary>
        ///// 单据打印记录
        ///// </summary>
        ///// <param name="orderPrintModel"></param>
        ///// <returns></returns>
        //int PrintRecord(OrderPrintModel orderPrintModel);


        ///// <summary>
        ///// 获取托盘下拉列表
        ///// </summary>
        ///// <returns></returns>
        //DataSet GetPalletType();
      
    }
}