using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Estsh.Web.Dal;
using Estsh.Web.Util;
using System.Collections;
using System.Data;


namespace Estsh.Core.Services
{
    public class NewShippingInformationDefineService
    {
        NewShippingInformationDefineDal dal = new NewShippingInformationDefineDal(RemotingProxyProvider._remotingProxy);


        /// <summary>
        /// 客户产线集合
        /// </summary>
        /// <returns>数据集</returns>
        public ArrayList GetCustPDLineName()
        {
            return dal.GetCustPDLineName();
        }


        /// <summary>
        /// 根据分页条件获取分页菜单数据
        /// </summary>
        /// <param name="PartMasterName"></param>
        /// <param name="pager"></param>
        /// <param name="direction"></param>
        /// <param name="sort"></param>
        /// <returns></returns>
        public Hashtable getShippingListByPage(String where, Pager pager)
        {
            Hashtable result = new Hashtable();


            result = dal.getShippingListByPage(pager.pageSize, pager.pageNo, where);
            return result;
        }

        public Hashtable getShippingListDetail(String ruid)
        {
            ruid = " ruid = " + ruid;
            DataTable dt = dal.getList(ruid, "");
            Hashtable result = new Hashtable();

            result.Add("ruid", dt.Rows[0]["ruid"]);
            result.Add("order_no", dt.Rows[0]["order_no"]);
            result.Add("part_no", dt.Rows[0]["part_no"]);
            result.Add("part_spec", dt.Rows[0]["part_spec"]);
            result.Add("qty", dt.Rows[0]["qty"]);
            result.Add("piqty", dt.Rows[0]["piqty"]);
            return result;
        }

        //public int saveShippingList(Hashtable htParams)
        //{
        //    return dal.saveShippingList(htParams);
        //}
        ///// <summary>
        /// 更新菜单数据
        /// </summary>
        /// <param name="htParams"></param>
        /// <returns></returns>
        public int updateShippingList(Hashtable htParams)
        {
            return dal.updateShippingList(htParams);
        }

        public Hashtable getShippingListDetailByPage(String where, Pager pager)
        {
            Hashtable result = new Hashtable();


            result = dal.getShippingListDetailByPage(pager.pageSize, pager.pageNo, where);
            return result;
        }


        /// <summary>
        /// 
        /// </summary>
        /// <param name="aWhere"></param>
        /// <returns></returns>
        public DataTable GetCountShipping(string aWhere)
        {
            return dal.GetCountShipping(aWhere);
        }

        public DataTable GetCountShippingDetail(string aWhere)
        {
            return dal.GetCountShippingDetail(aWhere);
        }



    }


}