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
{
    /// <summary>
    /// 连铸采样表类
    /// </summary>
    public class LgStlCcmF1samplingService : Core.LgMes.Client.lgServiceMgt.BaseService.LgBaseService
    {
       static string sqlStr = "select * from stl_ccm_f1sampling where 1 = 1 {0}";
       static  string sqlStrHis = "select * from j#stl_ccm_f1sampling where 1 = 1 {0}";
       static string sqlStrAll =  sqlStr + " union all " + sqlStrHis;

       static string sqlStr2 = "select * from stl_ccm_f2sampling where 1 = 1 {0}";
       static string sqlStrHis2 = "select * from j#stl_ccm_f2sampling where 1 = 1 {0}";
       static string sqlStrAll2 = sqlStr2 + " union all " + sqlStrHis2;

       static string sqlStr3 = "select * from stl_ccm_f3sampling where 1 = 1 {0}";
       static string sqlStrHis3 = "select * from j#stl_ccm_f3sampling where 1 = 1 {0}";
       static string sqlStrAll3 = sqlStr3 + " union all " + sqlStrHis3;

       static string sqlStr4 = "select * from stl_ccm_f4sampling where 1 = 1 {0}";
       static string sqlStrHis4 = "select * from j#stl_ccm_f4sampling where 1 = 1 {0}";
       static string sqlStrAll4 = sqlStr4 + " union all " + sqlStrHis4;
        /// <summary>
        /// 获取1采样数据
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public DataSet GetDataSetForStlCcmF1samplingAll(ClientParamWithSqlConditionAndOpenBase param)
        {
            DataSet ds = new DataSet();
            string sqlStr = "";
            try
            {
                sqlStr = string.Format(sqlStrAll,param.sqlCondition); 
                ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr, param.ob));
            }
            catch
            {
            }
            return ds;
        }

        /// <summary>
        /// 获取2#采样数据
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public DataSet GetDataSetForStlCcmF2samplingAll(ClientParamWithSqlConditionAndOpenBase param)
        {
            DataSet ds = new DataSet();
            string sqlStr = "";
            try
            {
                sqlStr = string.Format(sqlStrAll2, param.sqlCondition);
                ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr, param.ob));
            }
            catch
            {
            }
            return ds;
        }

        /// <summary>
        ///  获取3#采样数据
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public DataSet GetDataSetForStlCcmF3samplingAll(ClientParamWithSqlConditionAndOpenBase param)
        {
            DataSet ds = new DataSet();
            string sqlStr = "";
            try
            {
                sqlStr = string.Format(sqlStrAll3, param.sqlCondition);
                ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr, param.ob));
            }
            catch
            {
            }
            return ds;
        }

        public DataSet GetDataSetForStlCcmF1samplingWorking(ClientParamWithSqlConditionAndOpenBase param)
        {
            DataSet ds = new DataSet();
            string sqlStr = "";
            try
            {
                sqlStr = string.Format(sqlStr, param.sqlCondition);
                ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr, param.ob));
            }
            catch
            {
            }
            return ds;
        }
    }
}