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.LgReportService 
{
    /// <summary>
    /// 转炉报表数据层类
    /// </summary>
    public class LgCcmReportService : Core.LgMes.Client.lgServiceMgt.BaseService.LgBaseService
    {
        public LgCcmReportService()
        {
              
        }

        /// <summary>
        /// 获取3号机操作台记录
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public  DataSet returnDsOfCcmThreeOperationReport(ClientParamWithSqlConditionAndOpenBase param)
        {
            DataSet ds = new DataSet();
            try
            {
                string sqlStr = SqlCollection.CcmSqlCollection.returnSqlOfCcmOption(param.sqlCondition);
                ds =  base.dbCommond.ExecuteReader(new DbClientParam(sqlStr,param.ob));
            
            }
            catch
            {
            }
            return ds;
        }

        /// <summary>
        /// "中包温度与拉速"
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>

        public  DataSet returnDsOfCcmMidPackageAndSpeed(ClientParamWithSqlConditionAndOpenBase param)
        {
            DataSet ds = new DataSet();
            try
            {
                ds = base.dbCommond.ExecuteReader(new DbClientParam(SqlCollection.CcmSqlCollection.returnSqlOfMidPackageAndSpeed(param.sqlConditionList), param.ob));
              
            }
            catch
            {
            }
            return ds;
        }

        /// <summary>
        /// 获取板坯机恒拉表
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public  DataSet returnDsOfCcmCastSpeedReport(ClientParamWithSqlConditionAndOpenBase param)
        {
            DataSet ds = new DataSet();
            try
            {
               ds =  base.dbCommond.ExecuteReader(new DbClientParam(SqlCollection.CcmSqlCollection.returnSqlStrCastCcmSpeed(param.sqlCondition), param.ob));
            }
            catch
            {
            }
            return ds;

        }


        /// <summary>
        /// 板坯铸机典拉表
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public  DataSet returnDsOfCcmDlReport(ClientParamWithSqlConditionAndOpenBase param)
        {
            DataSet ds = new DataSet();
            try
            {
               ds = base.dbCommond.ExecuteReader(new DbClientParam(SqlCollectionCcm.ReturnSqlOfCcmDlReport(param.sqlConditionList), param.ob));
              
            }
            catch
            {
            }
            return ds;
        }

        /// <summary>
        /// 获取某炉号最小和最大拉速
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public  DataSet returnDsOfCcmHlData(ClientParamWithSqlConditionAndOpenBase param)
        {
            DataSet ds = new DataSet();
            try
            {
                ds = base.dbCommond.ExecuteReader(new DbClientParam(SqlCollectionCcm.returnSqlForMinSpeedAndMaxSpeedForHeatNo(param.sqlCondition), param.ob));
            }
            catch
            {
            }
            return ds;
        }


        /// <summary>
        /// 获取配重信息
        /// </summary>
        /// <param name="sqlWhere"></param>
        /// <returns></returns>
        public DataSet returnDsOfWeightMatching(ClientParamWithSqlConditionAndOpenBase param) 
        {
            DataSet ds = new DataSet();
            try
            {
                ds = base.dbCommond.ExecuteReader(new DbClientParam(SqlCollectionCcm.returnSqlWeightMatching(param.sqlCondition), param.ob));
            }
            catch
            {
            }
            return ds;
        }
        
    }
}