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.lgGlobalMap
{
   public class ScmLiquidusTemp
    {
        /// <summary>
        /// 查询液相线温度
        /// </summary>
        /// <param name="Lmltempt"></param>
        /// <returns></returns>
       public static DataTable LiquidusTemp(string Lmltempt, OpeBase ob)
        {
            try
            {
                DataSet ds = new DataSet();
                string strErr = "";
                string strSql = "select a.liquidustemp from  SCM_LIQUIDUS_TEMP a where a.steelname='" + Lmltempt + "'";

                //CoreFS.CA06.FrmBase cctos = new FrmBase();
                CommonClientToServer cctos = new CommonClientToServer();
                cctos.ob = ob;
                ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBExecute",
                                                           "doSimpleQuery", strSql, out strErr);
                return ds.Tables[0];
            }
            catch { }
            return null;
        }

       public static DataTable BofOptinfo(string Heatno, OpeBase ob)
       {
           try
           {
               DataSet ds = new DataSet();

               string strSql = "select  a.TERMINUSTEPT ARBTEMPT from stl_bof_optinfo a where a.heatno='" + Heatno + "' union all select  t.TERMINUSTEPT ARBTEMPT from j#stl_bof_optinfo t where t.heatno='" + Heatno + "'";
               return ExectuteQuery(strSql, ob);
           }
           catch { }
           return null;
       }
       
       public static DataTable CasOptinfo(string Heatno,OpeBase ob)
       {
           try
           {
               DataSet ds = new DataSet();

               string strSql = "select  a.ARFTEMPT,a.ARBTEMPT from stl_cas_optinfo a where a.heatno='" + Heatno + "' union all select  t.ARFTEMPT,t.ARBTEMPT from j#stl_cas_optinfo t where t.heatno='" + Heatno + "'";
               return ExectuteQuery(strSql, ob);
           }
           catch { }
           return null;
       }
       public static DataTable LfsOptinfo(string Heatno, OpeBase ob)
       {
           try
           {
               DataSet ds = new DataSet();

               string strSql = "select  a.ARRIVETEMPT,a.LEAVETEMPT from stl_lfs_optinfo a where a.heatno='" + Heatno + "' union all select  t.ARRIVETEMPT,t.LEAVETEMPT from j#stl_lfs_optinfo t where t.heatno='" + Heatno + "'";
               return ExectuteQuery(strSql, ob);
           }
           catch { }
           return null;
       }
       public static DataTable VdsOptinfo(string Heatno, OpeBase ob)
       {
           try
           {
               DataSet ds = new DataSet();

               string strSql = "select  a.ARFTEMPT,a.ARBTEMPT from stl_vds_optinfo a where a.heatno='" + Heatno + "' union all select  t.ARFTEMPT,t.ARBTEMPT from j#stl_vds_optinfo t where t.heatno='" + Heatno + "'";
               return ExectuteQuery(strSql, ob);
           }
           catch { }
           return null;
       }
       public static DataTable RhsOptinfo(string Heatno, OpeBase ob)
       {
           try
           {
               DataSet ds = new DataSet();

               string strSql = "select  a.ARFTEMPT,a.ARBTEMPT from stl_rhs_optinfo a where a.heatno='" + Heatno + "' union all select  t.ARFTEMPT,t.ARBTEMPT from j#stl_rhs_optinfo t where t.heatno='" + Heatno + "'";
               return ExectuteQuery(strSql, ob);
           }
           catch { }
           return null;
       }
       public static DataTable CcmOptinfo(string Heatno, OpeBase ob)
       {
           try
           {
               DataSet ds = new DataSet();

               string strSql = "select  a.PFBALETEMPT ARFTEMPT from stl_ccm_optinfo a where a.heatno='" + Heatno + "' union all select  t.PFBALETEMPT ARFTEMPT from j#stl_ccm_optinfo t where t.heatno='" + Heatno + "'";
               return ExectuteQuery(strSql, ob);
           }
           catch { }
           return null;
       }

       public static DataTable USE_DETAIL(string Heatno, OpeBase ob)// string v_Ladleid,
       {
           try
           {
               DataSet ds = new DataSet();

               string strSql = " select *　from DEV_GB_USE_DETAIL a1 where a1.heatno='" + Heatno + "'";//and a1.ladleid ='" + v_Ladleid + "' 
               return ExectuteQuery(strSql, ob);
           }
           catch { }
           return null;
       }


       //调用公用查询方法
       public static DataTable ExectuteQuery(string strSql, OpeBase ob) 
       {
           try
           {
               CommonClientToServer cctos = new CommonClientToServer();
               DataSet ds = new DataSet();
               string strErr = "";
               cctos.ob = ob;
               ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBExecute",
                                                          "doSimpleQuery", strSql, out strErr);
               return ds.Tables[0];
           }
           catch { }
           return null;
       }

       
    }
}