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.lgDbMgt;

namespace Core.LgMes.Client.lgServiceMgt.LgResService
{
   public class LgStlHmpOptinfoService : Core.LgMes.Client.lgServiceMgt.BaseService.LgBaseService
    {
        /// <summary>
        /// 获取脱硫站记录集合
        /// </summary>
        /// <param name="param">ClientParamWithSqlConditionAndOpenBase</param>
        /// <returns></returns>
        public  DataSet returnDsOfHmpInfo(ClientParamWithSqlConditionAndOpenBase param)
        {
            DataSet ds = new DataSet();
            string sqlStr = "";

            try
            {
                sqlStr = LgSqlCollection.LgRes.LgHmpSql.LgHmpSql001.returnSqlOfStl_Hmp_Optinfo(param.sqlCondition);
                ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr,param.ob));
            }
            catch
            {
            }

            return ds;
        }


        /// <summary>
        /// 返回当前工作表中的脱硫数据，即从stl_hmp_optinfo 获取数据
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public  DataSet returnDsOfHmpWorkingInfo(ClientParamWithSqlConditionAndOpenBase param)
        {
            DataSet ds = new DataSet();
            string sqlStr = "";
            try
            {
                sqlStr = LgSqlCollection.LgRes.LgHmpSql.LgHmpSql001.returnSqlOfStl_Hmp_Optinfo_Working(param.sqlCondition);
                ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr, param.ob));
            }
            catch
            {
            }

            return ds;
        }
    }
}