sujinlee

setting language
 
TO_CHAR(A.WK_DT, 'DAY', 'NLS_DATE_LANGUAGE=ENGLISH')

sujinlee

select 0.533 value 
  from dual ; 
  
  --result => .533



--전체 자리수 7에 소수점 이하 3자리를 기준으로 
select rtrim(to_char(0.533, 'FM99990D999'), '.') value
  from dual ; 

sujinlee

  <HTabControl Grid.Row="1" ItemsSource="{Binding Path=OutNursingPartStatementFolderList}" SelectedItem="{Binding Path=SelectedNursingPartFolder}"
               SelectedValuePath="NRST_FLDR_CTG_CD" DisplayMemberPath="FLDR_NM" ItemContainerStyle="{StaticResource treeItemStyle}">
      <i:Interaction.Triggers>
          <i:EventTrigger EventName="SelectionChanged">
              <i:InvokeCommandAction Command="{Binding Path=SelectionFolderChangedCommand}" />
          </i:EventTrigger>
      </i:Interaction.Triggers>
  </HTabControl>

sujinlee

exec :pt_no := '88888888'; 
   select *
     from ACPPRICD
    where PT_NO = :pt_no ; 

 
 define in_pt_no = '88888888'
   select *
     from ACPPRICD

sujinlee

        public bool ValidateData(object data)
        {
            foreach (PropertyInfo propertyInfo in data.GetType().GetProperties())
            {
                if (propertyInfo.PropertyType == typeof(DateTime) )
                {
                    if (Convert.ToDateTime(propertyInfo.GetValue(data))  == DateTime.MinValue)
                    {
                        propertyInfo.SetValue(data, DateTime.Now);
                    }

sujinlee

 ----------------------------------------------------------------------------------------
      -- 입원인 경우 고지서 출력여부를 Check하여 'N'인 경우에만 입원접수내역에 퇴원관련컬럼을 Update
      ---------------------------------------------------------------------------------------- 
      if (IN_MED_PACT_TP_CD = 'I') then
            -------------------------------------------------------------------------------------
         -- 퇴원지시나 퇴원취소가 가능한지 심사완료여부 및 고지서출력여부를 조회한다.
         -------------------------------------------------------------------------------------     
      	begin
            begin
				SELECT A.BSCR_TP_CD         --사전심사구분코드