XinYu_LG2MES/ClientSolution/Core.LgMes.Client.lgServiceMgt/SqMesService/Tbg02ChargeCommService.cs

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 Tbg02ChargeCommService : Core.LgMes.Client.lgServiceMgt.BaseService.LgBaseService
    {
       private  string SQL_STR_CHARGE_COMMON = @"select CHARGE_NO,
                                                                                PLAN_CHARGE_NO,
                                                                                PLANT_CLF,
                                                                                CHARGE_STAT,
                                                                                MATRL_END_CD,
                                                                                MATRL_END_DTIME,
                                                                                INSTR_RT,
                                                                                ACT_BOF_RT,
                                                                                ACT_CAS_RT,
                                                                                ACT_RH_RT,
                                                                                ACT_LF_RT,
                                                                                ACT_CCM_RT,
                                                                                PRODNM_CD,
                                                                                ORD_NO,
                                                                                SPEC_ABBSYM,
                                                                                CUR_PROG_CD,
                                                                                CUR_PROG_CD_REG_PGM,
                                                                                CUR_PROG_CD_REG_DTIME,
                                                                                BEF_PROG_CD,
                                                                                BEF_PROG_CD_REG_PGM,
                                                                                BEF_PROG_CD_REG_DTIME,
                                                                                STL_GRD,
                                                                                BEF_STL_GRD,
                                                                                ORD_FL,
                                                                                BEF_ORD_FL,
                                                                                HCR_CLF,
                                                                                LD_NO,
                                                                                LD_IN_DTIME,
                                                                                BOF_NO,
                                                                                BOF_WKDATE,
                                                                                CAST_NO,
                                                                                CAST_EDT_CHARGE_CNT,
                                                                                CAST_CHARGE_SEQ,
                                                                                CHARGE_WGT,
                                                                                BOF_TAPPING_WGT,
                                                                                SLAB_PRODQNTY,
                                                                                RTN_CHARGE_CLF,
                                                                                RTN_CHARGE_OCR_DTIME,
                                                                                RTN_CHARGE_CAUSE_CD,
                                                                                RTN_CHARGE_WGT,
                                                                                RTN_CHARGE_OCR_PROC,
                                                                                NEW_PLAN_CHARGE_NO,
                                                                                RTN_CHARGE_TREAT_DTIME,
                                                                                RTN_CHARGE_TREAT_PROC,
                                                                                RTN_CHARGE_EMP_ID,
                                                                                SCRAP_TREAT_STA_DTIME,
                                                                                SCRAP_TREAT_END_DTIME,
                                                                                SCRAP_TREAT_WGT,
                                                                                RCPT_TAP_QTY,
                                                                                INGR_DEC_GRD,
                                                                                INGR_DEC_DTIME,
                                                                                LST_INGR_CD,
                                                                                LST_INGR_REG_DTIME,
                                                                                BOF_STA_DTIME,
                                                                                BOF_END_DTIME,
                                                                                RH_STA_DTIME,
                                                                                RH_END_DTIME,
                                                                                LF_STA_DTIME,
                                                                                LF_END_DTIME,
                                                                                CAS_STA_DTIME,
                                                                                CAS_END_DTIME,
                                                                                LT_ARRV_DTIME,
                                                                                CASTING_STA_DTIME,
                                                                                CASTING_END_DTIME,
                                                                                SLAB_CNT,
                                                                                SLAB_WGT,
                                                                                CAS_ARRV_WGT,
                                                                                CAS_DEP_WGT,
                                                                                RH_ARRV_WGT,
                                                                                RH_DEP_WGT,
                                                                                LF_ARRV_WGT,
                                                                                LF_DEP_WGT,
                                                                                CCM_ARRV_WGT,
                                                                                KR_SER_NO,
                                                                                KR_LD_NO,
                                                                                RE_CHARGE_NO,
                                                                                RTN_CHARGE_NO,
                                                                                RTN_IN_BOF_WGT,
                                                                                TD_NO,
                                                                                MD_NO1,
                                                                                MD_NO2,
                                                                                CCM_PRC_LINE,
                                                                                PATH_PROC_CD,
                                                                                CC_DEVNO,
                                                                                ORD_SEQ,
                                                                                REG_ID,
                                                                                REG_PGM_ID,
                                                                                REG_DTIME,
                                                                                SLAB_RT,
                                                                                CHARGE_INGR_DEC_EMP_ID,
                                                                                CHARGE_DCS_DETAIL,
                                                                                INGR_SHIFT,
                                                                                INGR_GROUP,
                                                                                INGR_FAC_DEC_GRD,
                                                                                INGR_XIUYUE,
                                                                                DIVIDE_CHARGE_YN,
                                                                                CHARGE_INIT_DTIME  from tbg02_charge_comm@XG3Q a where 1 = 1 {0}";


        /// <summary>
       /// 获取三期表Tbg02ChargeComm 数据集
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
       public DataSet ReturnDsTbg02ChargeComm(ClientParamWithSqlConditionAndOpenBase param)
       {
           string sqlStr = string.Format(SQL_STR_CHARGE_COMMON,param.sqlCondition);
           DataSet ds = new DataSet();
           try
           {
              ds = base.ReturnDbCommondByCommondType(DbCommandType.TqMes).ExecuteReader(new DbClientParam(sqlStr, param.ob));
               
           }
           catch
           {
           }
           return ds;
       }

    }
}