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

/***************************************************************************************************
 * 
 * 作者：王勇
 * 
 * *************************************************************************************************/
namespace Estsh.Core.Services
{
    /// <summary>
    /// 菜单业务处理类
    /// </summary>
    public class YYAdjustOrderService
    {
        private YYAdjustOrderDal dal = new YYAdjustOrderDal(RemotingProxyProvider._remotingProxy);

        /// <summary>
        /// 根据分页条件获取分页菜单数据
        /// </summary>
        /// <param name="YYAdjustOrderName"></param>
        /// <param name="pager"></param>
        /// <param name="direction"></param>
        /// <param name="sort"></param>
        /// <returns></returns>
        public Hashtable getYYAdjustOrderListByPage(RemotingProxy.RecordStatus status, Pager pager, String direction, String sort, string cbCustPDLine)
        {
            Hashtable result = new Hashtable();

            //String strWhere = " p.cust_pdline_name='" + cbCustPDLine.ToString() + "'";
            String strWhere = "";
            if (cbCustPDLine == "SX12")
            {
                strWhere = " o.appoint_pdline=100001 ";
            }
            else
            {
               strWhere = " o.appoint_pdline=100002 ";
            }
            strWhere += " and g.work_flag <0 ";
            strWhere += " and  a.create_ymd>(SELECT CONVERT(VARCHAR(10), GETDATE()- 15, 120))";
            strWhere += " AND a.enabled='Y'";

            String orderBy = " a.seq ";
            result = dal.getListByPage(status, pager.pageSize, pager.pageNo, strWhere, orderBy);
            return result;
        }

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

        /// <summary>
        /// 查看详情
        /// </summary>
        /// <param name="ruid"></param>
        /// <returns></returns>
        public ArrayList getYYAdjustOrder(String part_id)
        {
            part_id = "part_id = " + part_id;
            DataTable dt = dal.getList(part_id, "");
            ArrayList result = DataTypeConvert.NewObject.DataTableToArrayList(dt);
            return result;
        }

        /// <summary>
        /// 删除菜单
        /// </summary>
        /// <param name="ids"></param>
        /// <returns></returns>
        public int deleteYYAdjustOrder(String ids)
        {
            String[] idArray = ids.Split(',');
            int count = 0;
            foreach (String id in idArray)
            {
                if (!"".Equals(id))
                {
                    count += this.dal.deleteYYAdjustOrder(id);
                }
            }
            return count;
        }

        /// <summary>
        /// 上移
        /// </summary>
        /// <param name="ids"></param>
        /// <returns></returns>
        public bool upRow(int seq, int ruid, int up_ruid, int up_seq)
        {
            bool Bool = false;

            Bool = this.dal.upRow(seq, ruid, up_ruid, up_seq);

            return Bool;
        }

        /// <summary>
        /// 上移多行
        /// </summary>
        /// <param name="ids"></param>
        /// <returns></returns>
        public bool upAll(int ruid, int seq, int up_ruid, int up_seq)
        {
            bool Bool = false;

            Bool = this.dal.upAll(ruid, seq, up_ruid, up_seq);

            return Bool;
        }

        /// <summary>
        /// 获取上一条数据
        /// </summary>
        /// <param name="ids"></param>
        /// <returns></returns>
        public DataTable selectAll(string CustPDLine)
        {
            DataTable dt = new DataTable();

            dt = this.dal.selectAll(CustPDLine);

            return dt;
        }

        /// <summary>
        /// 获取下拉框中的菜单数据
        /// </summary>
        /// <returns></returns>
        public ArrayList getSelectYYAdjustOrder()
        {
            Hashtable result = new Hashtable();

            DataTable dt = dal.getSelectYYAdjustOrder();

            return DataTypeConvert.NewObject.DataTableToArrayList(dt);
        }

        public int deleteOrder(String ruid)
        {
            return dal.deleteOrder(ruid);
        }

        public int deleteOrderInfo(String ruid, string custPdlineDesc)
        {
            string partLocation = dal.getPartLocation(ruid);
            return dal.deleteOrderInfo(ruid, custPdlineDesc, partLocation);
        }
    }
}