using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Core.LgMes.Client.lgBll.lgResMgt
{
    public class CommonAtomForLgResMgt
    {
        /// <summary>
        /// 返回脱硫实绩Sql
        /// </summary>
        /// <param name="sqlWhere"></param>
        /// <returns></returns>
        public static string returnSqlOfStl_Hmp_Optinfo(string sqlWhere)
        {
            string sqlStr = "";
            sqlStr = "select * from stl_hmp_optinfo a where 1 = 1{0}";
            sqlStr += "  union all select * from j#stl_hmp_optinfo a where 1 = 1{0}";
            sqlStr = string.Format(sqlStr, sqlWhere);
            return sqlStr;
        }

        /// <summary>
        /// 返回脱硫操作表中数据
        /// </summary>
        /// <param name="sqlWhere"></param>
        /// <returns></returns>
        public static string returnSqlOfStl_Hmp_Optinfo_Working(string sqlWhere)
        {
            string sqlStr = "";
            sqlStr = "select * from stl_hmp_optinfo a where 1 = 1 {0} ";          
            sqlStr = string.Format(sqlStr, sqlWhere);
            return sqlStr;
        }



        /// <summary>
        /// 返回转炉实绩Sql
        /// </summary>
        /// <param name="sqlWhere"></param>
        /// <returns></returns>
        public static string returnSqlOfStl_Bof_Optinfo(string sqlWhere)
        {
            string sqlStr = "";
            sqlStr = "select * from stl_bof_optinfo a where 1 = 1{0}";
            sqlStr += "  union all select * from j#stl_bof_optinfo a where 1 = 1{0}";
            sqlStr = string.Format(sqlStr, sqlWhere);
            return sqlStr;
        }
        /// <summary>
        /// 返回氩站实绩SQL
        /// </summary>
        /// <param name="sqlWhere"></param>
        /// <returns></returns>
        public static string returnSqlOfStl_Cas_Optinfo(string sqlWhere)
        {
            string sqlStr = "";
            sqlStr = "select * from stl_cas_optinfo a where 1=1 {0}";
            sqlStr += "union all select * from j#stl_cas_optinfo a where 1=1 {0}";
            sqlStr = string.Format(sqlStr,sqlWhere);
            return sqlStr;
        }


        /// <summary>
        /// 返回连铸实绩sql
        /// </summary>
        /// <param name="sqlWhere"></param>
        /// <returns></returns>

        public static string returnSqlOfStl_Ccm_Optinfo(string sqlWhere)
        {
            string sqlStr = "";
            sqlStr = "select * from stl_ccm_optinfo a where 1 = 1 {0}";
            sqlStr += "  union all select * from J#stl_ccm_optinfo A where 1 = 1{0}";
            sqlStr = string.Format(sqlStr, sqlWhere);
            return sqlStr;
        }

        /// <summary>
        /// 返回连铸实绩与包晶数据sql
        /// </summary>
        /// <param name="sqlWhere"></param>
        /// <returns></returns>

        public static string returnSqlOfCcmChemInfo(string sqlWhere)
        {
            string sqlStr = "SELECT * FROM (SELECT T.*,A.BJFYL,A.BJZHL FROM (SELECT * FROM STL_CCM_OPTINFO UNION SELECT * FROM J#STL_CCM_OPTINFO) T "
                                +"LEFT JOIN (SELECT HEATNO, "
                  +"round((0.53-1*C)/(0.53-(0.0885-0.02124*Ni-0.01258*Cu+0.006*Cr+0.00529*Mo+0.01076*V-0.03398*power(Nb,2)-0.00846*Nb-0.00865*power(Ti,3)+0.02595*power(Ti,2)-0.03581*Ti+0.05056*P-0.58528*S-0.443*N-0.0089*Si-0.0145*Mn+0.0144*AlS-0.0115*Si*Mn-0.0031*AlS*Mn+0.0041*power(Si,2)+0.0104*AlS*Si+0.0056*power(AlS,2))),3) BJFYL, "
                  +"round((0.1688-0.0091*Si-0.0218*Mn+0.0435*AlS-0.0261*Si*Mn-0.0143*AlS*Mn+0.0371*AlS*Si+0.0078*power(Si,2)+0.039*power(AlS,2)+0.0022*power(Si,2)*Mn-0.03522*Ni-0.01632*Cu+0.00116*power(Cr,2)+0.0071*Cr+0.02222*Mo+0.04439*V-0.02474*Nb+0.03484*power(Ti,2)-0.02842*Ti+0.27635*P-2.22519*S-0.55592*N-1*C)/(0.1688-0.0091*Si-0.0218*Mn+0.0435*AlS-0.0261*Si*Mn-0.0143*AlS*Mn+0.0371*AlS*Si+0.0078*power(Si,2)+0.039*power(AlS,2)+0.0022*power(Si,2)*Mn-0.03522*Ni-0.01632*Cu+0.00116*power(Cr,2)+0.0071*Cr+0.02222*Mo+0.04439*V-0.02474*Nb+0.03484*power(Ti,2)-0.02842*Ti+0.27635*P-2.22519*S-0.55592*N-(0.0885-0.02124*Ni-0.01258*Cu+0.006*Cr+0.00529*Mo+0.01076*V-0.03398*power(Nb,2)-0.00846*Nb-0.00865*power(Ti,3)+0.02595*power(Ti,2)-0.03581*Ti+0.05056*P-0.58528*S-0.443*N-0.0089*Si-0.0145*Mn+0.0144*AlS-0.0115*Si*Mn-0.0031*AlS*Mn+0.0041*power(Si,2)+0.0104*AlS*Si+0.0056*power(AlS,2))),3) BJZHL "
                  +"FROM (SELECT NVL(C,0) C,NVL(Ni,0) Ni,NVL(Cu,0) Cu,NVL(Cr,0) Cr,NVL(Mo,0) Mo,NVL(V,0) V,NVL(Nb,0) Nb,NVL(Ti,0) Ti,NVL(P,0) P,NVL(S,0) S,NVL(N,0) N,NVL(Si,0) Si,NVL(Mn,0) Mn,NVL(AlS,0) AlS,ASSAYTYPECODE,HEATNO FROM STL_CHEMELEMENT "
                         +"UNION SELECT NVL(C,0) C,NVL(Ni,0) Ni,NVL(Cu,0) Cu,NVL(Cr,0) Cr,NVL(Mo,0) Mo,NVL(V,0) V,NVL(Nb,0) Nb,NVL(Ti,0) Ti,NVL(P,0) P,NVL(S,0) S,NVL(N,0) N,NVL(Si,0) Si,NVL(Mn,0) Mn,NVL(AlS,0) AlS,ASSAYTYPECODE,HEATNO FROM J#STL_CHEMELEMENT) WHERE ASSAYTYPECODE = 'GP001' "
                  + ") A ON T.HEATNO = A.HEATNO) "
                  + "WHERE 1=1 " + sqlWhere + "";
            /*sqlStr = "select * from stl_ccm_optinfo a where 1 = 1 {0}";
            sqlStr += "  union all select * from J#stl_ccm_optinfo A where 1 = 1{0}";
            sqlStr = string.Format(sqlStr, sqlWhere);*/

            return sqlStr;
        }


        /// <summary>
        /// 获取计划信息
        /// </summary>
        /// <param name="sqlCondition"></param>
        /// <returns></returns>
        public static string returnSqlOfPpc_Steel_Heat(string sqlCondition)
        {
            string sqlStr = string.Format("select * from ppc_steel_heat a where  1 = 1 {0}", sqlCondition);
            return sqlStr;
        }


    }

    


}