XinYu_LG2MES/ClientSolution/Core.LgMes.Client.lgServiceMgt/LgSqlCollection/LgRes/LgHmpSql/LgHmpSql001.cs

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

namespace Core.LgMes.Client.lgServiceMgt.LgSqlCollection.LgRes.LgHmpSql
{
   public class LgHmpSql001
    {
        /// <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;
        }



       

     


    }
}