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 LgStlVdsOptinfoDAL : Core.LgMes.Client.lgServiceMgt.BaseService.LgBaseService
    {
        private const string SQL_STL_VDS_OPTION = "select * from stl_vds_optinfo where  1 = 1 {0}";
        private const string HIS_SQL_STL_VDS_OPTION = "select * from j#stl_vds_optinfo where  1 = 1 {0}";
        private const string SQL_STL_LFS_OPTION_All = "select * from stl_vds_optinfo where  1 = 1 {0}  union all select * from  j#stl_vds_optinfo where  1 = 1 {0}";

       /// <summary>
        /// stl_vds_optinfo
       /// </summary>
       /// <param name="param"></param>
       /// <returns></returns>
       public DataSet GetStlVdsOption(ClientParamWithSqlConditionAndOpenBase param)
       {
           DataSet ds = new DataSet();
           string sqlStr = "";
           try
           {
               sqlStr = string.Format(SQL_STL_VDS_OPTION, param.sqlCondition);
               ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr, param.ob));
           }
           catch
           {
           }
           return ds;
       }

       /// <summary>
       /// j#stl_rhs_optinfo
       /// </summary>
       /// <param name="param"></param>
       /// <returns></returns>
       public DataSet GetStlVdsOptionHis(ClientParamWithSqlConditionAndOpenBase param)
       {
           DataSet ds = new DataSet();
           string sqlStr = "";
           try
           {
               sqlStr = string.Format(HIS_SQL_STL_VDS_OPTION, param.sqlCondition);
               ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr, param.ob));
           }
           catch
           {
           }
           return ds;
       }

       /// <summary>
       /// stl_rhs_optinfo  j#stl_rhs_optinfo
       /// </summary>
       /// <param name="param"></param>
       /// <returns></returns>
       public DataSet GetStlVdsOptionAll(ClientParamWithSqlConditionAndOpenBase param)
       {
           DataSet ds = new DataSet();
           string sqlStr = "";
           try
           {
               sqlStr = string.Format(SQL_STL_LFS_OPTION_All, param.sqlCondition);
               ds = base.dbCommond.ExecuteReader(new DbClientParam(sqlStr, param.ob));
           }
           catch
           {
           }
           return ds;
       }

       /// <summary>
       /// 通过一炉号获取实绩信息
       /// </summary>
       /// <param name="param"></param>
       /// <returns></returns>
       public DataSet GetStlVhsOptionByHeatNo(ClientParamWithSqlConditionAndOpenBase param)
       {
           ClientParamWithSqlConditionAndOpenBase pa = new ClientParamWithSqlConditionAndOpenBase();
           pa.sqlCondition = string.Format(" and heatno = '{0}' ",param.sqlCondition);
           pa.ob = param.ob;
           return GetStlVdsOptionAll(pa);
       }

    }
}