XinYu_LG2MES/ClientSolution/Core.LgMes.Client.lgServiceMgt/SqMesService/.svn/text-base/Tbb01SeqIngrService.cs.svn-base

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.SqMesService
{
    /// <summary>
    /// 成分修约类
    /// </summary>
   
    public class Tbb01SeqIngrService : Core.LgMes.Client.lgServiceMgt.BaseService.LgBaseService
    {
        private const string SQL_STR_CHEME = @"select CHEM_CD,
                                                                        DISPLAY_SEQ,
                                                                        DISPLAY_LEN,
                                                                        COMP_YN,
                                                                        COMP_CAL,
                                                                        COMP_DETAIL,
                                                                        REG_PGM_ID,
                                                                        REG_ID,
                                                                        REG_DTIME,
                                                                        MOD_PGM_ID,
                                                                        MOD_ID,
                                                                        MOD_DTIME  from tbb01_seq_ingr@xg3q  where 1 = 1 {0}";
        /// <summary>
        /// 获取成分修约数据
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public DataSet ReturnDsTbb01SeqIngr(ClientParamWithSqlConditionAndOpenBase param)
        {
            string sqlStr = string.Format(SQL_STR_CHEME, "");
            DataSet ds = new DataSet();
            try
            {
               ds = base.ReturnDbCommondByCommondType(DbCommandType.TqMes).ExecuteReader(new DbClientParam(sqlStr, param.ob));
              
            }
            catch
            {
            }
            return ds;
        }

        

    }
}