using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using WMS.IData;

namespace WMS.Business.Common
{
    public class BussCommon : IBussFactory
    {
        public DataTable GetTable(string sql)
        {
            DataTable ds = null;
            ds = DataProvider.Instance.Common.GetTable(sql);
            return ds;
        }
        /// <summary>
        /// 通过指定的字段属性查询数据
        /// </summary>
        /// <param name="tableName"></param>
        /// <param name="clmValue"></param>
        /// <param name="clmName"></param>
        /// <returns></returns>
        public DataTable GetCustomCtrlData(string tableName, string clmValue, string clmName, string clmWhere, string clmClassName)
        {
            DataTable ds = null;
            ds = DataProvider.Instance.Common.GetCustomCtrlData(tableName, clmValue, clmName, clmWhere, clmClassName);
            return ds;
        }

        /// <summary>
        /// 返回通用查询的数据
        /// </summary>
        /// <typeparam name="T">表名</typeparam>
        /// <param name="column">查询的列</param>
        /// <param name="clmValue">查询条件</param>
        /// <param name="tableName">表名</param>
        /// <returns></returns>
        public DataTable GetListData(List<string> column, Dictionary<string, string> clmValue, string tableName)
        {
            DataTable listData = DataProvider.Instance.Common.GetListData(column, clmValue, tableName);
            return listData;
        }
        /// <summary>
        /// 获取商品信息
        /// </summary>
        /// <param name="strGooID">商品分类编号</param>
        /// <param name="user_id">用户编号</param>
        /// <returns></returns>
        public DataSet Get_GoodsInfo(string strGooID, string user_id)
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.Get_GoodsInfo(strGooID, user_id);
            return ds;
        }
     
        /// <summary>
        /// 获取商品分类
        /// </summary>
        /// <param name="status">1使用 0停用</param>
        /// <param name="user_id">用户编号</param>
        /// <returns></returns>
        public DataSet GetGoods_Category(string status, string user_id)
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetGoods_Category(status, user_id);

            return ds;
        }
        /// <summary>
        /// 获取采购类型
        /// </summary>
        /// <returns></returns>
        public DataSet GetPurchaseType()
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetPurchaseType();

            return ds;
        }
        /// <summary>
        /// 获取来源类型
        /// </summary>
        /// <returns></returns>
        public DataSet GetSourceType()
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetSourceType();

            return ds;
        }
        /// <summary>
        /// 获取活动类型
        /// </summary>
        /// <returns></returns>
        public DataSet GetActTypte()
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetActTypte();

            return ds;
        }
        /// <summary>
        /// 获取仓库信息
        /// </summary>
        /// <param name="user_id">用户编号</param>
        /// <returns></returns>
        public DataSet GetStorage(string user_id)
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetStorage(user_id);

            return ds;
        }
        /// <summary>
        /// 获取库区信息
        /// </summary>
        /// <param name="user_id">用户编号</param>
        /// <returns></returns>
        public DataSet GetArea(string id, string user_id)
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetArea(id, user_id);
            return ds;
        }
        /// <summary>
        /// 根据仓库编号获取库位信息
        /// </summary>
        /// <param name="StorageID"></param>
        /// <returns></returns>
        public DataSet GetLocation(string StorageID)
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetLocation(StorageID);
            return ds;
        }
        /// <summary>
        /// 获取物流公司信息
        /// </summary>
        /// <returns></returns>
        public DataSet GetLogisticsCom()
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetLogisticsComInfo();
            return ds;
        }
        public DataSet GetUnloadMan()
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetUnloadMan();
            return ds;
        }
        /// <summary>
        /// 供应商信息
        /// </summary>
        /// <param name="user_id">用户编号</param>
        /// <returns></returns>
        public DataSet GetProviderType(string user_id)
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetProviderType(user_id);

            return ds;
        }

        /// <summary>
        /// 付款方式类型
        /// </summary>
        /// <returns></returns>
        public DataSet GetPayType()
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetPayType();

            return ds;
        }

        ///// <summary>
        ///// 获取库存管理类型
        ///// </summary>
        ///// <param name="WMStype"></param>
        ///// <returns></returns>
        //public DataSet GetWMSType(WMSType WMStype)
        //{
        //    DataSet dt = null;
        //    dt = DataProvider.Instance.Common.GetWMSType(WMStype);
        //    return dt;
        //}

        /// <summary>
        /// 物流公司信息
        /// </summary>
        /// <returns></returns>
        public DataSet GetLogisticsComInfo()
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetLogisticsComInfo();

            return ds;
        }

        /// <summary>
        /// 获取结果集
        /// </summary>
        /// <param name="col">列名</param>
        /// <param name="table">表名</param>
        /// <param name="where">查询条件</param>
        /// <returns></returns>
        public DataSet GetDataSet(string col, string table, string where)
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetDataSet(col, table, where);

            return ds;
        }

        /************************************ Start  杨斌 增加 2012-11-20 ********************************/
        /// <summary>
        /// 获取公司类型
        /// </summary>
        /// <returns></returns>
        public DataSet GetCompanyType()
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetCompanyType();
            return ds;
        }
        /************************************ End  杨斌 增加 2012-11-20 **********************************/

        /// <summary>
        /// 获取公司分类
        /// </summary>
        /// <returns></returns>
        public DataSet GetCompanyCategory()
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetCompanyCategory();
            return ds;
        }

        /// <summary>
        /// 获取公司编号和公司名称
        /// </summary>
        /// <returns></returns>
        public DataSet GetCompanyIDName()
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetCompanyIDName();
            return ds;
        }

        #region 获取部门编号和部门名称
        /// <summary>
        /// 获取部门编号和部门名称
        /// </summary>
        /// <returns></returns>
        public DataSet GetDepartmentIDName()
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetDepartmentIDName();
            return ds;
        }
        #endregion

        /// <summary>
        /// 获取公司部门
        /// </summary>
        /// <returns></returns>
        public DataTable GetComDetDataTable()
        {
            return DataProvider.Instance.Common.GetComDetDataTable();
        }

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

        #region 获取集团编号和集团名称
        /// <summary>
        /// 获取集团编号和集团名称
        /// </summary>
        /// <returns></returns>
        public DataSet GetGroupIDName()
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetGroupIDName();
            return ds;
        }
        #endregion

        #region 获取供应商类型
        /// <summary>
        /// 获取供应商类型
        /// </summary>
        /// <returns></returns>
        public DataSet GetProviderType()
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetProviderType();
            return ds;
        }
        #endregion

        #region 获取省份
        /// <summary>
        /// 获取省份
        /// </summary>
        /// <returns></returns>
        public DataSet GetProvince()
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetProvince();
            return ds;
        }
        #endregion

        #region 根据省份编号获取城市
        /// <summary>
        /// 根据省份编号获取城市
        /// </summary>
        /// <param name="strProId">省份编号</param>
        /// <returns></returns>
        public DataSet GetCityByProId(string strProId)
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetCityByPRO_ID(strProId);
            return ds;
        }
        #endregion

        #region 根据城市编号获取区
        /// <summary>
        /// 根据城市编号获取区
        /// </summary>
        /// <param name="CityId">城市编号</param>
        /// <returns></returns>
        public DataSet GetTownByCityId(string strCityId)
        {
            DataSet ds = null;
            ds = DataProvider.Instance.Common.GetTownByCityId(strCityId);
            return ds;
        }
        #endregion

        /// <summary>
        /// 获取字典类型对照信息
        /// </summary>
        /// <returns></returns>
        public DataSet GetDictionaryType()
        {
            DataSet ds = DataProvider.Instance.Common.GetDictionaryType();
            return ds;
        }

        /// <summary>
        /// 根据类型代码查询出类型字典信息
        /// </summary>
        /// <param name="strTypeId">类型代码</param>
        /// <returns></returns>
        public DataSet GetTypeInfo(int strTypeId)
        {
            DataSet ds = DataProvider.Instance.Common.GetTypeInfo(strTypeId);
            if (DataLogErrWrite(ds.Tables[0], ""))
            {
                return null;
            }
            return ds;
        }

        //#region 获取托盘下拉列表
        ///// <summary>
        ///// 获取托盘下拉列表
        ///// </summary>
        ///// <returns></returns>
        //public DataSet GetPalletType()
        //{
        //    DataSet ds = null;
        //    ds = DataProvider.Instance.Common.GetPalletType();
        //    return ds;
        //}
        //#endregion

    }
}