using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CoreFS.CA06;
using System.Data;
using System.Collections;

using Core.Mes.Client.Common;

namespace Core.LgMes.Client.lgBll.lgPlanMgt
{
    public class CommonLgPlanMgt
    {
        private static Core.LgMes.Client.lgServiceMgt.SqMesService.Tbg02ChargeCommService tbg02ChargeCommService = new Core.LgMes.Client.lgServiceMgt.SqMesService.Tbg02ChargeCommService();
        public CommonLgPlanMgt()
        { 
        }

        /// <summary>
        /// 获取作业计划表数据
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public static DataSet returnDsOfPpc_Steel_Heat(ClientParam param)
        {
            DataSet ds = new DataSet();            
            try
            {
                ds = DbCommon.returnDataSet(param.sqlStr,param.ob);
            }
            catch
            { 
            }
            return ds;
        }


        /// <summary>
        /// 从某一ds中获取某字段值
        /// </summary>
        /// <param name="dsPpc"></param>
        /// <param name="columnName"></param>
        /// <returns></returns>
        public static string returnPpc_SteelColumnValueByColumnName(DataSet dsPpc,string columnName)
        {
            try
            {
                if(lgCommon.isDataSetDataFoundCheck(dsPpc))
                    return lgCommon.returnColumnValueFromDsByColumnName(dsPpc, columnName.ToUpper()).ToString();                  
            }
            catch
            { 
            }

            return "";
        }

        /// <summary>
        /// 获取Tbg02_Charge_Comm计划信息，从三期系统
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public static DataSet returnDsOfTbg02_Charge_Comm(ClientParam param)
        {
            ClientParamWithSqlConditionAndOpenBase paramClient = new ClientParamWithSqlConditionAndOpenBase();
            paramClient.sqlCondition = param.sqlCondition;
            paramClient.ob = param.ob;
            return tbg02ChargeCommService.ReturnDsTbg02ChargeComm(paramClient);
        }


        /// <summary>
        /// 获取计划信息，从三期系统
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public static DataSet returnDsOfTbg02_Charge_Comm(ClientParamWithSqlConditionAndOpenBase param)
        {
            return tbg02ChargeCommService.ReturnDsTbg02ChargeComm(param);
        }


        /// <summary>
        /// 获取浇次管理号，从热轧系统获取
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public static string return3qCastNoByHeatNo(ClientParam param)
        {
            string returnStr = "";
            try
            {
                DataSet ds = returnDsOfTbg02_Charge_Comm(param);
                returnStr = lgCommon.returnColumnValueFromDsByColumnName(ds, "CAST_NO").ToString();
            }
            catch
            { 
            }
           
            return returnStr;
        }


        /// <summary>
        /// 返回炉号列表，并存入list，
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public static ArrayList returnHeatNoListByCastNo(ClientParam param)
        {
            ArrayList list = new ArrayList();
            try
            {
                DataSet ds = returnDsOfTbg02_Charge_Comm(param);
                if (ds != null & ds.Tables.Count > 0)
                {
                    foreach (DataRow dr in ds.Tables[0].Rows)
                    {
                        list.Add(dr["CHARGE_NO"].ToString());
                    }
                }
               
            }
            catch
            {
            }
            return list;
        }
    }
}