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 LgStlBofOptionService : Core.LgMes.Client.lgServiceMgt.BaseService.LgBaseService
    {
       /// <summary>
        /// 获取stl_bof_optinfo 数据
       /// </summary>
       /// <param name="param"></param>
       /// <returns></returns>
       public  DataSet GetDataSetForStlBofOption(ClientParamWithSqlConditionAndOpenBase param)
       {
           DataSet ds = new DataSet();
           string sqlStr = "";
           try
           {
               sqlStr = LgSqlCollection.LgRes.LgBofSql.LgBofResSql01.GetSqlForStlBofOptinfo(param.sqlCondition);
               ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr,param.ob));
           }
           catch
           { 
           }
           return ds;
       }

       /// <summary>
       /// 获取转炉实绩数据，包括历史表
       /// </summary>
       /// <param name="param"></param>
       /// <returns></returns>
       public DataSet GetDataSetForAllStl_bof_optinfo(ClientParamWithSqlConditionAndOpenBase param)
       {
           DataSet ds = new DataSet();
           string sqlStr = "";
           try
           {
               sqlStr = LgSqlCollection.LgRes.LgBofSql.LgBofResSql01.GetSqlForHisStlBofOptinfo(param.sqlCondition);
               ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr, param.ob));
               try
               {
                   ds.Merge(GetDataSetForStlBofOption(param));
               }
               catch
               { 
               }
           }
           catch
           {
           }
           return ds;
       }
    }
}