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 LgBofReportService : Core.LgMes.Client.lgServiceMgt.BaseService.LgBaseService
    {
       
        public LgBofReportService()
        {
              
        }

        /// <summary>
        /// 炉前报表
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public DataSet returnDsOfBofForwardReport(ClientParamWithSqlConditionAndOpenBase param)
        {
            DataSet ds = new DataSet();
            try
            {
                string sqlStr =  LgSqlCollection.LgReportSql.SqlCollectionBof.returnSqlOfBofForwardReport(param.sqlConditionList);
                ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr, param.ob));
               
            }
            catch
            {
            }
            return ds;
        }

        /// <summary>
        /// 转炉操作记录报表数据
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public  DataSet returnDsOfBofOperationReport(ClientParamWithSqlConditionAndOpenBase param)
        {
            DataSet ds = new DataSet();
            try
            {
                ds = base.dbCommond.ExecuteReader(new DbClientParam(LgSqlCollection.LgReportSql.SqlCollectionBof.returnSqlOfBofOperatioReport(param.sqlConditionList), param.ob));
            }
            catch
            {
            }
            return ds;
        }


        /// <summary>
        /// 返回炼钢生产报表ds
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public  DataSet ReturnDsOfLgProdueceReport(ClientParamWithSqlConditionAndOpenBase param)
        {
            DataSet ds = new DataSet();
            try
            {
                string sqlStr = SqlCollection.CcmSqlCollection.ReturnSqlOfLgProdueceReport(param.sqlConditionList);
                ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr, param.ob));
            }
            catch
            {
            }
            return ds;
        }



        /// <summary>
        /// 返回转炉出钢C报表ds
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public DataSet ReturnDsOfBofTapping(ClientParamWithSqlConditionAndOpenBase param)
        {
            DataSet ds = new DataSet();
            try
            {
                string sqlStr = LgSqlCollection.LgReportSql.SqlCollectionBof.returnSqlOfBofTapping(param.sqlConditionList);
                ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr,param.ob));
            }
            catch
            { 
            }
            return ds;
        }

        /// <summary>
        /// 终终点MN考核报表
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public DataSet ReturnDsOfBofChecnNmReport(ClientParamWithSqlConditionAndOpenBase param)
        {

            DataSet ds = new DataSet();
            try
            {
                string sqlStr = LgSqlCollection.LgReportSql.SqlCollectionBof.ReturnSqlOfBofChecnNmReport(param.sqlConditionList);
                ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr, param.ob));
            }
            catch
            {
            }
            return ds;
 
        }

        /// <summary>
        /// 钢铁料消耗报表
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public DataSet ReturnDsOfSteelAddiStaticsReport(ClientParamWithSqlConditionAndOpenBase param)
        {
            DataSet ds = new DataSet();
            try
            {
                string sqlStr = LgSqlCollection.LgReportSql.SqlCollectionBof.ReturnSqlOfSteelAdditStats(param.sqlConditionList);
                ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr, param.ob));
            }
            catch
            {
            }
            return ds;
        }

        /// <summary>
        /// 转炉生产日报统计表--转炉信息查询
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public DataSet ReturnDsOfBofQueryInfo(ClientParamWithSqlConditionAndOpenBase param)
        {
            DataSet ds = new DataSet();
            try
            {
                string sqlStr = LgSqlCollection.LgReportSql.SqlCollectionBof.ReturnSqlOfBofQueryInfo(param.sqlConditionList);
                ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr, param.ob));
            }
            catch
            {
            }
            return ds;
        }
    

        
    }
}