MES_Client/TGMES/Core.StlMes.Client.LgCommon/公共自定义控件/实绩管理炉号查询/ClsResBLL.cs

using System;
using System.Data;
using System.Collections;
using CoreFS.CA06;

namespace Core.StlMes.Client.LgCommon
{
    public class ClsResBLL
    {
        public static DataSet GetHudwIdList( string strWhere, OpeBase ob)
        {
            string strSql = "select HEATPROCESSNO, HUDWID,HEATNO,decode(substr(SHIFTCODE,1,1),1,'白班',2,'小夜',3,'大夜', '')||'-'||decode(substr(SHIFTCODE,2,1),1,'甲',2,'乙',3,'丙', 4,'丁','') SHIFTCODE,"
                + "substr(HUDWID, 4, 2) DISPOSALTIME,STATIONCODE  from (select T.HEATPROCESSNO, T.HUDWID, T.HEATNO,T.SHIFTCODE,substr(T.HUDWID, 5, 1) DISPOSALTIME,T.EQUIPMENTNO STATIONCODE,T.OPTDATE from STL_Hmp_OPTINFO T " + strWhere + ""
               + " union select T.HEATPROCESSNO, T.HUDWID, T.HEATNO,T.SHIFTCODE,substr(T.HUDWID, 4, 2) DISPOSALTIME,T.EQUIPMENTNO STATIONCODE,T.OPTDATE  from J#STL_Hmp_OPTINFO  T " + strWhere + ") ORDER BY OPTDATE DESC";

            string strMsg = "";
            bool bSuccess = false;
            DataSet ds = ClsDataAccessPack.GetData(strSql, out bSuccess, out strMsg, ob);

            return ds;
        }

        public static DataSet GetHeatNoList(LG_PROCESS PROCESS, string strTableName, string strWherePlan,string strWhereRes,string strWhereIf, OpeBase ob)
        {
            string Cast = "";
            if (PROCESS == LG_PROCESS.CCM)
                Cast = "T.MOULDNO";
            else
                Cast = "'' MOULDNO";
            string strSql = "( SELECT * FROM PLN_STEELFORFURNACE " + strWherePlan + ") A, " +
                            " (SELECT T.STOVE_NO,T.STATIONCODE,T.DISPOSALTIME,T.HEATPROCESSNO,T.SHIFTCODE," + Cast + ",T.OPTDATE FROM " + strTableName + " T " + strWhereRes +
                            " UNION ALL SELECT T.STOVE_NO,T.STATIONCODE,T.DISPOSALTIME,T.HEATPROCESSNO,T.SHIFTCODE," + Cast + ", T.OPTDATE  FROM J#" + strTableName + " T " + strWhereRes + ") B ";

            strSql = " SELECT A.STOVE_NO HEATNO,DECODE(A.STATUS,'00','编制中','10','下发','20','生产中','30','已生产','40','关闭') STATUS,(SELECT GRADENAME FROM COM_BASE_GRADE WHERE GRADECODE=A.GRADECODE) GRADECODE,CAST_NO,CAST_SEQ,STATIONCODE,DISPOSALTIME,HEATPROCESSNO,SHIFTCODE,MOULDNO FROM " + strSql +
                     " WHERE A.STOVE_NO = B.STOVE_NO(+) " + "AND STATUS>10 " + strWhereIf + "  ORDER BY PLINE_CODE, FURNACENO_SEQ";

            string strMsg = "";
            bool bSuccess = false;
            DataSet ds = ClsDataAccessPack.GetData(strSql, out bSuccess, out strMsg, ob);

            return ds;
        }

        public static DataSet GetAutoTempData(LG_PROCESS PROCESS, string HeatNo, string StationCode, string DisposalTime, OpeBase ob)
        {
            string strMsg = "";
            bool bSuccess = false;


            string strSql = "";
            strSql += Convert.ToString("SELECT HEATPROCESSNO,").Trim() + " ";
            strSql += Convert.ToString("       SAMPLINGID,").Trim() + " ";
            strSql += Convert.ToString("       SAMPLINGNAME,").Trim() + " ";
            strSql += Convert.ToString("       STOVE_NO HEATNO,").Trim() + " ";
            strSql += Convert.ToString("       STATIONCODE,").Trim() + " ";
            strSql += Convert.ToString("       DISPOSALTIME,").Trim() + " ";
            strSql += Convert.ToString("       SAMPLINGDEPICT,").Trim() + " ";
            strSql += Convert.ToString("       SAMPLINGVALUE,").Trim() + " ";
            strSql += Convert.ToString("       TO_CHAR(SAMPLINGDATE, 'HH24:mi:ss') SAMPLINGDATE").Trim() + " ";
            strSql += Convert.ToString("  FROM STL_TEMPSAMPLING").Trim() + " ";
            strSql += Convert.ToString(" WHERE STOVE_NO = '" + HeatNo + "'").Trim() + " ";
      //      strSql += Convert.ToString("   AND STATIONCODE = '" + StationCode + "'").Trim() + " ";
            strSql += Convert.ToString("   AND SUBSTR(STATIONCODE,0,1) <> 'G'").Trim() + " ";
            strSql += Convert.ToString("   AND DISPOSALTIME = '" + DisposalTime + "'").Trim() + " ";
            strSql += Convert.ToString("UNION").Trim() + " ";
            strSql += Convert.ToString("SELECT HEATPROCESSNO,").Trim() + " ";
            strSql += Convert.ToString("       SAMPLINGID,").Trim() + " ";
            strSql += Convert.ToString("       SAMPLINGNAME,").Trim() + " ";
            strSql += Convert.ToString("       STOVE_NO HEATNO,").Trim() + " ";
            strSql += Convert.ToString("       STATIONCODE,").Trim() + " ";
            strSql += Convert.ToString("       DISPOSALTIME,").Trim() + " ";
            strSql += Convert.ToString("       SAMPLINGDEPICT,").Trim() + " ";
            strSql += Convert.ToString("       SAMPLINGVALUE,").Trim() + " ";
            strSql += Convert.ToString("       TO_CHAR(SAMPLINGDATE, 'HH24:mi:ss') SAMPLINGDATE").Trim() + " ";
            strSql += Convert.ToString("  FROM J#STL_TEMPSAMPLING").Trim() + " ";
            strSql += Convert.ToString(" WHERE STOVE_NO = '" + HeatNo + "'").Trim() + " ";
    //        strSql += Convert.ToString("   AND STATIONCODE = '" + StationCode + "'").Trim() + " ";
            strSql += Convert.ToString("   AND SUBSTR(STATIONCODE,0,1) <> 'G'").Trim() + " ";
            strSql += Convert.ToString("   AND DISPOSALTIME = '" + DisposalTime + "'").Trim() + " ";
            strSql += Convert.ToString(" ORDER BY SAMPLINGDATE").Trim();

            DataSet ds = ClsDataAccessPack.GetData(strSql, out bSuccess, out strMsg, ob);
            return ds;
       }
        //连铸查询自动温度
        public static DataSet GetCCMAutoTempData(string HeatNo, OpeBase ob)
        {
            string strMsg = "";
            bool bSuccess = false;

            string strSql = "";
            strSql += Convert.ToString("SELECT T.*").Trim() + " ";
            strSql += Convert.ToString("       FROM (SELECT X.*,").Trim() + " ";
            strSql += Convert.ToString("       ROW_NUMBER() OVER(PARTITION BY X.STOVE_NO, X.STATIONCODE ORDER BY X.SAMPLINGDATE1 DESC) XH").Trim() + " ";
            strSql += Convert.ToString("       FROM (SELECT HEATPROCESSNO,").Trim() + " ";
            strSql += Convert.ToString("       SAMPLINGID,").Trim() + " ";
            strSql += Convert.ToString("       SAMPLINGNAME,").Trim() + " ";
            strSql += Convert.ToString("       STOVE_NO,").Trim() + " ";
            strSql += Convert.ToString("       STATIONCODE,").Trim() + " ";
            strSql += Convert.ToString("       DISPOSALTIME,").Trim() + " ";
            strSql += Convert.ToString("       SAMPLINGDEPICT,").Trim() + " ";
            strSql += Convert.ToString("       SAMPLINGVALUE,").Trim() + " ";
            strSql += Convert.ToString("       SAMPLINGDATE SAMPLINGDATE1,").Trim() + " ";
            strSql += Convert.ToString("       TO_CHAR(SAMPLINGDATE, 'HH24:mi:ss') SAMPLINGDATE").Trim() + " ";
            strSql += Convert.ToString("  FROM STL_TEMPSAMPLING").Trim() + " ";
            strSql += Convert.ToString(" WHERE STOVE_NO = '" + HeatNo + "'").Trim() + " ";
            strSql += Convert.ToString("UNION").Trim() + " ";
            strSql += Convert.ToString("SELECT HEATPROCESSNO,").Trim() + " ";
            strSql += Convert.ToString("       SAMPLINGID,").Trim() + " ";
            strSql += Convert.ToString("       SAMPLINGNAME,").Trim() + " ";
            strSql += Convert.ToString("       STOVE_NO,").Trim() + " ";
            strSql += Convert.ToString("       STATIONCODE,").Trim() + " ";
            strSql += Convert.ToString("       DISPOSALTIME,").Trim() + " ";
            strSql += Convert.ToString("       SAMPLINGDEPICT,").Trim() + " ";
            strSql += Convert.ToString("       SAMPLINGVALUE,").Trim() + " ";
            strSql += Convert.ToString("       SAMPLINGDATE SAMPLINGDATE1,").Trim() + " ";
            strSql += Convert.ToString("       TO_CHAR(SAMPLINGDATE, 'HH24:mi:ss') SAMPLINGDATE").Trim() + " ";
            strSql += Convert.ToString("  FROM J#STL_TEMPSAMPLING").Trim() + " ";
            strSql += Convert.ToString(" WHERE STOVE_NO = '" + HeatNo + "'").Trim() + " ";
            strSql += Convert.ToString("  ORDER BY SAMPLINGDATE) X) T").Trim() + " ";
            strSql += Convert.ToString("  WHERE T.XH < 2").Trim();

            DataSet ds = ClsDataAccessPack.GetData(strSql, out bSuccess, out strMsg, ob);
            return ds;
        }
    }
}