XinYu_LG2MES/ClientSolution/Core.LgMes.Client.lgBll/lgResMgt/LgstlCcmMgt.cs

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;
using Core.LgMes.Client.lgServiceMgt;

namespace Core.LgMes.Client.lgBll.lgResMgt
{
    public class LgstlCcmMgt
    {
        private static lgServiceMgt.LgResService.LgStlCcmF1samplingService stlcmf1sampling = new Core.LgMes.Client.lgServiceMgt.LgResService.LgStlCcmF1samplingService();

        /// <summary>
        /// 1#连铸采样数据
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public static DataSet GetStlCcmF1Sampling(ClientParamWithSqlConditionAndOpenBase param)
        {
            return stlcmf1sampling.GetDataSetForStlCcmF1samplingAll(param);
        }

        /// <summary>
        /// 2#连铸采样数据
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public static DataSet GetStlCcmF2Sampling(ClientParamWithSqlConditionAndOpenBase param)
        {
            return stlcmf1sampling.GetDataSetForStlCcmF2samplingAll(param);
        }

        /// <summary>
        /// 3#连铸采样数据
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public static DataSet GetStlCcmF3Sampling(ClientParamWithSqlConditionAndOpenBase param)
        {
            return stlcmf1sampling.GetDataSetForStlCcmF3samplingAll(param);
        }


        /// <summary>
        /// 通过炉号获取采样数据
        /// </summary>
        /// <param name="param">炉号</param>
        /// <returns></returns>
        public static DataSet GetStlCcmSamplingByHeatNo(ClientParamWithSqlConditionAndOpenBase param)
        {
            DataSet ds = null;
            ds = GetStlCcmF1Sampling(param);

            if (lgCommon.isDataSetDataFoundCheck(ds))
                return ds;
            ds = GetStlCcmF2Sampling(param);
            if (lgCommon.isDataSetDataFoundCheck(ds))
                return ds;
            ds = GetStlCcmF3Sampling(param);
            if (lgCommon.isDataSetDataFoundCheck(ds))
                return ds;

            return ds;
 
        }


        /// <summary>
        /// 根据炉号获取中包最低温度，最高温度，以及温差,index 0 最低，1 最高，2 温差
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public static double[] GetCalMidladletempByHeatNo(ClientParamWithSqlConditionAndOpenBase param)
        {
            double minTemp = 0;
            double maxTemp = 0;
            double[] returnData = new double[] { 0, 0, 0 };
            DataSet dsOrderMidladletemp2 = null;
            DataView dv1 = null;
            DataSet dsOrderMidladletemp1 = null;
            string heatNo = param.param[0].ToString();
            Core.Mes.Client.Common.ClientParamWithSqlConditionAndOpenBase param1 = new ClientParamWithSqlConditionAndOpenBase(string.Format(" and heatno = '{0}'", heatNo), param.ob);
            DataSet ds = Core.LgMes.Client.lgBll.lgResMgt.LgstlCcmMgt.GetStlCcmSamplingByHeatNo(param1);
            if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
                return returnData;

            DataView dv2 = ds.Tables[0].DefaultView;
            dv2.RowFilter = "MIDLADLETEMP2  >= '1500'";

            if (dv2.Count > 0)
            {
                DataSet ds2 = new DataSet();
                ds2.Tables.Add(dv2.ToTable());
                dsOrderMidladletemp2 = lgCommon.returnDsByAscOrderFromSourceDataSet(ds2, "MIDLADLETEMP2");
                minTemp = Convert.ToDouble((dsOrderMidladletemp2.Tables[0].Rows[0]["MIDLADLETEMP2"].ToString()));
                maxTemp = Convert.ToDouble((dsOrderMidladletemp2.Tables[0].Rows[dsOrderMidladletemp2.Tables[0].Rows.Count - 1]["MIDLADLETEMP2"].ToString()));
            }

            else
            {
                dv1 = ds.Tables[0].DefaultView;
                dv1.RowFilter = "MIDLADLETEMP1 >= '1500'";
                if (dv1.Count > 0)
                {
                    DataSet ds1 = new DataSet();
                    ds1.Tables.Add(dv1.ToTable());
                    dsOrderMidladletemp1 = lgCommon.returnDsByAscOrderFromSourceDataSet(ds1, "MIDLADLETEMP1");
                    minTemp = Convert.ToDouble((dsOrderMidladletemp1.Tables[0].Rows[0]["MIDLADLETEMP1"].ToString()));
                    maxTemp = Convert.ToDouble((dsOrderMidladletemp1.Tables[0].Rows[dsOrderMidladletemp1.Tables[0].Rows.Count - 1]["MIDLADLETEMP1"].ToString()));
                }

            }

            returnData[0] = minTemp;
            returnData[1] = maxTemp;
            returnData[2] = maxTemp - minTemp;

            return returnData;
        }
    }
}