MES_Client/TGMES/Core.StlMes.Client.YdmStuffManage/公共类/ClsLoad.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CoreFS.CA06;
using System.Data;
using Infragistics.Win;
using System.Collections;
using Core.Mes.Client.Comm.Server;

namespace Core.StlMes.Client.YdmStuffManage
{
    class ClsLoad
    {
        /// <summary>
        ///基础信息
        /// </summary>
        /// <param name="df"></param>
        /// <param name="ob"></param>
        public static DataTable GetValueListDataTable(string pCode, OpeBase ob)
        {
            DataTable dt = new DataTable();
            ArrayList queryList = new ArrayList();
            queryList.Add(pCode);

            dt = ServerHelper.GetData("Core.LgMes.Server.Stuffmanage.BaseOperations.queryBaseConfion", new object[] { queryList }, ob);
            return dt;
        }

        public static DataTable GetValueListDataTable(string [] pCode, OpeBase ob)
        {
            DataTable dt = new DataTable();
            ArrayList queryList = new ArrayList();
            for (int i = 0; i < pCode.Length; i++)
            {
                queryList.Add(pCode[i].ToString());
            }


            dt = ServerHelper.GetData("Core.LgMes.Server.Stuffmanage.BaseOperations.queryBaseConfion", new object[] { queryList }, ob);
            return dt;
        }


        /// <summary>
        /// 根据指定DataTable生成ValueList
        /// </summary>
        /// <param name="table"></param>
        /// <param name="strKey">value</param>
        /// <param name="strText">Text</param>
        /// <returns></returns>
        public static ValueList GeneralValuelist(ref DataTable table, string strKey, string strText)
        {
            if (table == null || !table.Columns.Contains(strKey) || !table.Columns.Contains(strText))
            {
                return null;
            }

            ArrayList alist = new ArrayList();
            ValueList vlist = new ValueList();

            for (int i = 0; i < table.Rows.Count; i++)
            {
                try
                {
                    if (!alist.Contains(table.Rows[i][strKey]))
                    {
                        alist.Add(table.Rows[i][strKey]);
                        vlist.ValueListItems.Add(table.Rows[i][strKey], Convert.ToString(table.Rows[i][strText]));
                    }
                }
                catch { }
            }

            return vlist;
        }
        /// <summary>
        /// 获取作业类型信息
        /// </summary>
        /// <param name="sortCode">快速索引码,参数数组</param>
        /// <param name="ob">界面OB对象</param>
        /// <returns></returns>
        public static DataTable getComTypeInfo(string sortCode, OpeBase ob)
        {
            return ServerHelper.GetData("com.steering.pss.ydm.pipemanage.PipeManageClassInfo.queryType", new object[] { sortCode }, ob);
        }

        /// <summary>
        /// 根据登陆部门获取产线
        /// </summary>
        /// <param name="Department">user_depatment</param>
        /// <returns></returns>
        public static string GetPCode(string Department,OpeBase ob)
        {
            string Pcode = "";
            DataTable dt = ServerHelper.GetData("Core.LgMes.Server.Common.ComLgValidDataPurviewIds.getPCode", new Object[] { Department }, ob);
            if (dt.Rows.Count > 0)
            {
                Pcode = dt.Rows[0]["pline_code"].ToString();
            }
            return Pcode;
        }
        /// <summary>
        /// 通过科室查找对应的部门
        /// </summary>
        /// <param name="sectionName">科室ID</param>
        /// <param name="ob"></param>
        /// <returns>部门名称</returns>
        public static string GetDepartBySectionId(string sectionId, OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData("Core.LgMes.Server.Common.ComLgValidDataPurviewIds.getDeptBySection", new object[] { sectionId }, ob);
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0]["DEPARTNAME"].ToString();
            }
            else
            {
                return "";
            }
        }

        /// <summary>
        /// 通过科室查找对应的部门
        /// </summary>
        /// <param name="sectionName">科室ID</param>
        /// <param name="ob"></param>
        /// <returns>部门ID</returns>
        public static string GetDepartIdBySectionId(string sectionId, OpeBase ob)
        {
            DataTable dt = ServerHelper.GetData("Core.LgMes.Server.Common.ComLgValidDataPurviewIds.getDeptBySection", new object[] { sectionId }, ob);
            if (dt.Rows.Count > 0)
            {
                return dt.Rows[0]["DEPARTID"].ToString();
            }
            else
            {
                return "";
            }
        }

    }
    
}