using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using WMS.IData.IBase;
using System.Data;
using WMS.IData;using Oracle.ManagedDataAccess.Client;

namespace WMS.SqlServerData.BaseData
{
   public class PalletStatusData:IPalletStatus
    {
       public DataTable GetPalletStatusData()
       {
           string str =@"select t.pallet_status_id,
                           t.pallet_id,
                           t.vc_dictionary_id,
                           t.storage_id,
                           t.storage_area_id,
                           a.storage_area_name,
                           s.storage_name,
                           d.vc_dictionary_name,
                           t.version
                           from T_BASE_PALLET_STATUS t
                           left outer join t_Base_Storage_Area a
                           on t.storage_area_id = a.storage_area_id
                           left outer join t_Base_Storageinfo s
                           on t.storage_id = s.storage_id
                           left outer Join T_SYS_DICTIONARY_TAB d
                           on t.vc_dictionary_id = d.vc_dictionary_id
                           where 1=1";

           DataTable dt = SystemDataObject.Instance.GetDataTable(str) ;
           return dt;
       }
    }
}