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


namespace Estsh.Core.Services
{
    public class ViewpdlineService
    {
        private ViewpdlineDal dal = new ViewpdlineDal(RemotingProxyProvider._remotingProxy);


        /// <summary>
        /// 获取产线编号
        /// </summary>
        /// <returns></returns>
        public ArrayList GetViewPdlineID()
        {
            return dal.GetViewPdlineID();
        }

        /// <summary>
        /// 获取产线名称
        /// </summary>
        /// <returns></returns>
        public ArrayList GetViewPdlineName()
        {
            return dal.GetViewPdlineName();
        }

        /// <summary>
        /// 修改数据
        /// </summary>
        /// <param name="htParams"></param>
        /// <returns></returns>
        public int updateView(Hashtable htParams)
        {
            return dal.updateView(htParams);
        }

        /// <summary>
        /// 获取数据列表
        /// </summary>
        /// <param name="pdline_name"></param>
        /// <param name="jph_f"></param>
        /// <param name="jph_r"></param>
        /// <param name="kanban_ordering"></param>
        /// <param name="pager"></param>
        /// <param name="direction"></param>
        /// <param name="sort"></param>
        /// <returns></returns>
        public Hashtable getPdlineListByPage(String cbViewPDLine, String jph_f, String jph_r, String kanban_ordering, Pager pager, String direction, String sort)
        {
            Hashtable result = new Hashtable();
            String strWhere = " 1=1 ";
            if (cbViewPDLine != null && !cbViewPDLine.Trim().Equals(""))
            {
                strWhere = "  cbViewPDLine like '%" + cbViewPDLine.Trim() + "%'  ";
            }
            if (jph_f != null && !jph_f.Trim().Equals(""))
            {
                strWhere += " AND jph_f like '%" + jph_f.Trim() + "%'";
            }
            if (jph_r != null && !jph_r.Trim().Equals(""))
            {
                strWhere += " AND jph_r like '%" + jph_r.Trim() + "%'";
            }

            if (kanban_ordering != null && !kanban_ordering.Trim().Equals(""))
            {
                strWhere += " AND kanban_ordering like '%" + kanban_ordering.Trim() + "%'";
            }


            String orderBy = "";
            if (sort != null && !"".Equals(sort.Trim()))
            {
                orderBy += sort + " " + direction;
            }
            else
            {
                orderBy += " pdline_id " + direction;
            }
            result = dal.getListByPage(pager.pageSize, pager.pageNo, strWhere, orderBy);
            return result;
        }

        /// <summary>
        /// 查看菜单详情
        /// </summary>
        /// <param name="type_id"></param>
        /// <returns></returns>
        public Hashtable getViewDetail(String pdline_id)
        {
            pdline_id = " pdline_id = " + pdline_id;
            DataTable dt = dal.getViewDetail(pdline_id, "");
            Hashtable result = new Hashtable();

            result.Add("pdline_id", dt.Rows[0]["pdline_id"]);
            result.Add("pdline_name", dt.Rows[0]["pdline_name"]);
            result.Add("jph_f", dt.Rows[0]["jph_f"]);
            result.Add("jph_r", dt.Rows[0]["jph_r"]);
            result.Add("kanban_ordering", dt.Rows[0]["kanban_ordering"]);
            result.Add("create_ymd", dt.Rows[0]["create_ymd"].ToString());
            result.Add("create_hms", dt.Rows[0]["create_hms"].ToString());
            result.Add("create_userid", dt.Rows[0]["create_userid"].ToString());
            return result;
        }

        /// <summary>
        /// 判断厂区代码是否已存在
        /// </summary>
        /// <param name="facCode">厂区代码</param>
        /// <returns>false：不存在  true :已存在</returns>
        //public bool IsExistOrd(string kanbanord)
        //{
        //    Hashtable hsTalbe = new Hashtable();
        //    string strWhere = " and kanban_ordering ='" + kanbanord + "'";
        //    DataTable dt = dal.getKanbanList(strWhere);

        //    if (dt == null || dt.Rows.Count < 1)
        //    {
        //        return false;
        //    }

        //    return true;
        //}

    }
}