프로젝트

일반

사용자정보

개정판 e890d999

IDe890d9994694a862c8b1c928d24b5bf835c6dedc
상위 a55ba94c
하위 0f7919b5

김태성이(가) 일년 이상 전에 추가함

issue #00000 markup data 표시 수정

Change-Id: I7bdaba5d93347f80e2369a905658f99428323aff

차이점 보기:

ID2.Manager/DataBaseCreate/App.config
1 
<?xml version="1.0" encoding="utf-8" ?>
2 
<configuration>
3 
    <configSections>
4 
    </configSections>
5 
    <startup>
6 
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6" />
7 
    </startup>
8 
	<connectionStrings>
9 
  <add name="DataBaseCreate.Properties.Settings.ID2Manager" connectionString="data source=12.127.163.230,10102;initial catalog=ID2Manager;persist security info=True;user id=sa;password=P@sswd12;multipleactiveresultsets=True" />
10 
 </connectionStrings>
11 
</configuration>
ID2.Manager/DataBaseCreate/DataBaseCreate.csproj
1 
<?xml version="1.0" encoding="utf-8"?>
2 
<Project ToolsVersion="15.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
3 
  <Import Project="$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" />
4 
  <PropertyGroup>
5 
    <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
6 
    <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
7 
    <ProjectGuid>{1DAC9B4B-5AAE-463C-8A93-9EFE112821EB}</ProjectGuid>
8 
    <OutputType>Exe</OutputType>
9 
    <RootNamespace>DataBaseCreate</RootNamespace>
10 
    <AssemblyName>DataBaseCreate</AssemblyName>
11 
    <TargetFrameworkVersion>v4.6</TargetFrameworkVersion>
12 
    <FileAlignment>512</FileAlignment>
13 
    <AutoGenerateBindingRedirects>true</AutoGenerateBindingRedirects>
14 
    <Deterministic>true</Deterministic>
15 
  </PropertyGroup>
16 
  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
17 
    <PlatformTarget>AnyCPU</PlatformTarget>
18 
    <DebugSymbols>true</DebugSymbols>
19 
    <DebugType>full</DebugType>
20 
    <Optimize>false</Optimize>
21 
    <OutputPath>bin\Debug\</OutputPath>
22 
    <DefineConstants>DEBUG;TRACE</DefineConstants>
23 
    <ErrorReport>prompt</ErrorReport>
24 
    <WarningLevel>4</WarningLevel>
25 
  </PropertyGroup>
26 
  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
27 
    <PlatformTarget>AnyCPU</PlatformTarget>
28 
    <DebugType>pdbonly</DebugType>
29 
    <Optimize>true</Optimize>
30 
    <OutputPath>bin\Release\</OutputPath>
31 
    <DefineConstants>TRACE</DefineConstants>
32 
    <ErrorReport>prompt</ErrorReport>
33 
    <WarningLevel>4</WarningLevel>
34 
  </PropertyGroup>
35 
  <ItemGroup>
36 
    <Reference Include="System" />
37 
    <Reference Include="System.Core" />
38 
    <Reference Include="System.Xml.Linq" />
39 
    <Reference Include="System.Data.DataSetExtensions" />
40 
    <Reference Include="Microsoft.CSharp" />
41 
    <Reference Include="System.Data" />
42 
    <Reference Include="System.Net.Http" />
43 
    <Reference Include="System.Xml" />
44 
  </ItemGroup>
45 
  <ItemGroup>
46 
    <Compile Include="Program.cs" />
47 
    <Compile Include="Properties\AssemblyInfo.cs" />
48 
    <Compile Include="Properties\Settings.Designer.cs">
49 
      <AutoGen>True</AutoGen>
50 
      <DesignTimeSharedInput>True</DesignTimeSharedInput>
51 
      <DependentUpon>Settings.settings</DependentUpon>
52 
    </Compile>
53 
  </ItemGroup>
54 
  <ItemGroup>
55 
    <None Include="App.config" />
56 
    <None Include="Properties\Settings.settings">
57 
      <Generator>SettingsSingleFileGenerator</Generator>
58 
      <LastGenOutput>Settings.Designer.cs</LastGenOutput>
59 
    </None>
60 
  </ItemGroup>
61 
  <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
62 
</Project>
ID2.Manager/DataBaseCreate/MarkupDataParse.sln
1 

2 
Microsoft Visual Studio Solution File, Format Version 12.00
3 
# Visual Studio Version 16
4 
VisualStudioVersion = 16.0.33920.266
5 
MinimumVisualStudioVersion = 10.0.40219.1
6 
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "MarkupDataParse", "..\..\..\MARKUS\MarkupDataParse\MarkupDataParse.csproj", "{C8BB3E31-C512-4B87-B78F-6042A02594B0}"
7 
EndProject
8 
Project("{9A19103F-16F7-4668-BE54-9A1E7A4F7556}") = "MarkupDataParseTest", "..\..\..\MARKUS\MarkupDataParseTest\MarkupDataParseTest.csproj", "{727C273D-6D2F-483E-990E-6AF0BC00CA50}"
9 
EndProject
10 
Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "DataBaseCreate", "DataBaseCreate.csproj", "{1DAC9B4B-5AAE-463C-8A93-9EFE112821EB}"
11 
EndProject
12 
Global
13 
	GlobalSection(SolutionConfigurationPlatforms) = preSolution
14 
		Debug|Any CPU = Debug|Any CPU
15 
		Release|Any CPU = Release|Any CPU
16 
	EndGlobalSection
17 
	GlobalSection(ProjectConfigurationPlatforms) = postSolution
18 
		{C8BB3E31-C512-4B87-B78F-6042A02594B0}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
19 
		{C8BB3E31-C512-4B87-B78F-6042A02594B0}.Debug|Any CPU.Build.0 = Debug|Any CPU
20 
		{C8BB3E31-C512-4B87-B78F-6042A02594B0}.Release|Any CPU.ActiveCfg = Release|Any CPU
21 
		{C8BB3E31-C512-4B87-B78F-6042A02594B0}.Release|Any CPU.Build.0 = Release|Any CPU
22 
		{727C273D-6D2F-483E-990E-6AF0BC00CA50}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
23 
		{727C273D-6D2F-483E-990E-6AF0BC00CA50}.Debug|Any CPU.Build.0 = Debug|Any CPU
24 
		{727C273D-6D2F-483E-990E-6AF0BC00CA50}.Release|Any CPU.ActiveCfg = Release|Any CPU
25 
		{727C273D-6D2F-483E-990E-6AF0BC00CA50}.Release|Any CPU.Build.0 = Release|Any CPU
26 
		{1DAC9B4B-5AAE-463C-8A93-9EFE112821EB}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
27 
		{1DAC9B4B-5AAE-463C-8A93-9EFE112821EB}.Debug|Any CPU.Build.0 = Debug|Any CPU
28 
		{1DAC9B4B-5AAE-463C-8A93-9EFE112821EB}.Release|Any CPU.ActiveCfg = Release|Any CPU
29 
		{1DAC9B4B-5AAE-463C-8A93-9EFE112821EB}.Release|Any CPU.Build.0 = Release|Any CPU
30 
	EndGlobalSection
31 
	GlobalSection(SolutionProperties) = preSolution
32 
		HideSolutionNode = FALSE
33 
	EndGlobalSection
34 
	GlobalSection(ExtensibilityGlobals) = postSolution
35 
		SolutionGuid = {EFD9B659-8118-437F-9193-72BECAA61546}
36 
	EndGlobalSection
37 
EndGlobal
ID2.Manager/DataBaseCreate/MarkupDataParse.sql
1 
USE [ID2Manager]
2 
GO
3 

  		




  
  4
  
    
/****** Object:  UserDefinedFunction [dbo].[MarkupDataParse]    Script Date: 2023-08-16 ���� 1:20:32 ******/


  		




  
  5
  
    
DROP FUNCTION [dbo].[MarkupDataParse]


  		




  
  6
  
    
GO


  		




  
  7
  
    

  		




  
  8
  
    
/****** Object:  UserDefinedFunction [dbo].[MarkupDataParse]    Script Date: 2023-08-16 ���� 1:20:32 ******/


  		




  
  9
  
    
SET ANSI_NULLS ON


  		




  
  10
  
    
GO


  		




  
  11
  
    

  		




  
  12
  
    
SET QUOTED_IDENTIFIER ON


  		




  
  13
  
    
GO


  		




  
  14
  
    

  		




  
  15
  
    
-- =============================================


  		




  
  16
  
    
-- Author:		<Author,,Name>


  		




  
  17
  
    
-- Create date: <Create Date, ,>


  		




  
  18
  
    
-- Description:	<Description, ,>


  		




  
  19
  
    
-- =============================================


  		




  
  20
  
    
CREATE FUNCTION [dbo].[MarkupDataParse]


  		




  
  21
  
    
(


  		




  
  22
  
    
	-- Add the parameters for the function here


  		




  
  23
  
    
	@MARKUP_DATA VARCHAR(MAX)


  		




  
  24
  
    
)


  		




  
  25
  
    
RETURNS VARCHAR(MAX)


  		




  
  26
  
    
AS


  		




  
  27
  
    
BEGIN


  		




  
  28
  
    
	-- Declare the return variable here


  		




  
  29
  
    
	DECLARE @RESULT_VALUE VARCHAR(MAX)


  		




  
  30
  
    
	DECLARE @DECOMPRESS_DATA VARCHAR(MAX)


  		




  
  31
  
    

  		




  
  32
  
    
	SET @DECOMPRESS_DATA = CONVERT(varchar(max), CONVERT(xml, decompress(CAST(REPLACE(@MARKUP_DATA,'|DZ|','') as xml).value('xs:base64Binary(.)', 'varbinary(max)'))))


  		




  
  33
  
    

  		




  
  34
  
    
	IF JSON_VALUE(@DECOMPRESS_DATA, '$.Text') IS NOT NULL


  		




  
  35
  
    
		SET @RESULT_VALUE = JSON_VALUE(@DECOMPRESS_DATA, '$.Text')


  		




  
  36
  
    
	ELSE IF  JSON_VALUE(@DECOMPRESS_DATA, '$.ArrowText') IS NOT NULL 


  		




  
  37
  
    
		SET @RESULT_VALUE = JSON_VALUE(@DECOMPRESS_DATA, '$.ArrowText')


  		




  
  38
  
    
	ELSE


  		




  
  39
  
    
		SET @RESULT_VALUE = NULL


  		




  
  40
  
    

  		




  
  41
  
    
	-- Return the result of the function


  		




  
  42
  
    
	RETURN @RESULT_VALUE


  		




  
  43
  
    

  		




  
  44
  
    
END


  		




  
  45
  
    
GO


  		




  
  46
  
    

  		




  
  47
  
    

  		












  

    
      ID2.Manager/DataBaseCreate/Program.cs
    
  





  
  1
  
    
using System;


  		




  
  2
  
    
using System.Collections.Generic;


  		




  
  3
  
    
using System.Data.SqlClient;


  		




  
  4
  
    
using System.IO;


  		




  
  5
  
    
using System.Linq;


  		




  
  6
  
    
using System.Text;


  		




  
  7
  
    
using System.Threading.Tasks;


  		




  
  8
  
    

  		




  
  9
  
    
namespace DataBaseCreate


  		




  
  10
  
    
{


  		




  
  11
  
    
    class Program


  		




  
  12
  
    
    {


  		




  
  13
  
    
        static void Main(string[] args)


  		




  
  14
  
    
        {


  		




  
  15
  
    
            foreach (var item in args)


  		




  
  16
  
    
            {


  		




  
  17
  
    
                RunSql(item);


  		




  
  18
  
    
            }


  		




  
  19
  
    

  		




  
  20
  
    
            Console.ReadKey();


  		




  
  21
  
    
        }


  		




  
  22
  
    

  		




  
  23
  
    
        static void RunSql(string filePath)


  		




  
  24
  
    
        {


  		




  
  25
  
    
            string connectionString = Properties.Settings.Default.ID2Manager; // 데이터베이스 연결 문자열 입력


  		




  
  26
  
    

  		




  
  27
  
    
            string sqlContent = File.ReadAllText(filePath);


  		




  
  28
  
    

  		




  
  29
  
    
            using (SqlConnection connection = new SqlConnection(connectionString))


  		




  
  30
  
    
            {


  		




  
  31
  
    
                connection.Open();


  		




  
  32
  
    
                string[] sqlCommands = sqlContent.Split(new[] { "GO" }, StringSplitOptions.RemoveEmptyEntries);


  		




  
  33
  
    

  		




  
  34
  
    
                foreach (string sqlCommand in sqlCommands)


  		




  
  35
  
    
                {


  		




  
  36
  
    
                    using (SqlCommand command = new SqlCommand(sqlCommand, connection))


  		




  
  37
  
    
                    {


  		




  
  38
  
    
                        try


  		




  
  39
  
    
                        {


  		




  
  40
  
    
                            command.ExecuteNonQuery();


  		




  
  41
  
    
                            Console.WriteLine("SQL command executed successfully.");


  		




  
  42
  
    
                        }


  		




  
  43
  
    
                        catch (Exception ex)


  		




  
  44
  
    
                        {


  		




  
  45
  
    
                            Console.WriteLine("Error executing SQL command: " + ex.Message);


  		




  
  46
  
    
                        }


  		




  
  47
  
    
                    }


  		




  
  48
  
    
                }


  		




  
  49
  
    

  		




  
  50
  
    

  		




  
  51
  
    
                Console.WriteLine($"{filePath} file executed successfully.");


  		




  
  52
  
    
            }


  		




  
  53
  
    
        }


  		




  
  54
  
    

  		




  
  55
  
    
    }


  		




  
  56
  
    
}


  		












  

    
      ID2.Manager/DataBaseCreate/Properties/AssemblyInfo.cs
    
  





  
  1
  
    
using System.Reflection;


  		




  
  2
  
    
using System.Runtime.CompilerServices;


  		




  
  3
  
    
using System.Runtime.InteropServices;


  		




  
  4
  
    

  		




  
  5
  
    
// 어셈블리에 대한 일반 정보는 다음 특성 집합을 통해 


  		




  
  6
  
    
// 제어됩니다. 어셈블리와 관련된 정보를 수정하려면


  		




  
  7
  
    
// 이러한 특성 값을 변경하세요.


  		




  
  8
  
    
[assembly: AssemblyTitle("DataBaseCreate")]


  		




  
  9
  
    
[assembly: AssemblyDescription("")]


  		




  
  10
  
    
[assembly: AssemblyConfiguration("")]


  		




  
  11
  
    
[assembly: AssemblyCompany("")]


  		




  
  12
  
    
[assembly: AssemblyProduct("DataBaseCreate")]


  		




  
  13
  
    
[assembly: AssemblyCopyright("Copyright ©  2023")]


  		




  
  14
  
    
[assembly: AssemblyTrademark("")]


  		




  
  15
  
    
[assembly: AssemblyCulture("")]


  		




  
  16
  
    

  		




  
  17
  
    
// ComVisible을 false로 설정하면 이 어셈블리의 형식이 COM 구성 요소에 


  		




  
  18
  
    
// 표시되지 않습니다. COM에서 이 어셈블리의 형식에 액세스하려면


  		




  
  19
  
    
// 해당 형식에 대해 ComVisible 특성을 true로 설정하세요.


  		




  
  20
  
    
[assembly: ComVisible(false)]


  		




  
  21
  
    

  		




  
  22
  
    
// 이 프로젝트가 COM에 노출되는 경우 다음 GUID는 typelib의 ID를 나타냅니다.


  		




  
  23
  
    
[assembly: Guid("1dac9b4b-5aae-463c-8a93-9efe112821eb")]


  		




  
  24
  
    

  		




  
  25
  
    
// 어셈블리의 버전 정보는 다음 네 가지 값으로 구성됩니다.


  		




  
  26
  
    
//


  		




  
  27
  
    
//      주 버전


  		




  
  28
  
    
//      부 버전 


  		




  
  29
  
    
//      빌드 번호


  		




  
  30
  
    
//      수정 버전


  		




  
  31
  
    
//


  		




  
  32
  
    
// 모든 값을 지정하거나 아래와 같이 '*'를 사용하여 빌드 번호 및 수정 번호를


  		




  
  33
  
    
// 기본값으로 할 수 있습니다.


  		




  
  34
  
    
// [assembly: AssemblyVersion("1.0.*")]


  		




  
  35
  
    
[assembly: AssemblyVersion("1.0.0.0")]


  		




  
  36
  
    
[assembly: AssemblyFileVersion("1.0.0.0")]


  		












  

    
      ID2.Manager/DataBaseCreate/Properties/Settings.Designer.cs
    
  





  
  1
  
    
//------------------------------------------------------------------------------


  		




  
  2
  
    
// <auto-generated>


  		




  
  3
  
    
//     이 코드는 도구를 사용하여 생성되었습니다.


  		




  
  4
  
    
//     런타임 버전:4.0.30319.42000


  		




  
  5
  
    
//


  		




  
  6
  
    
//     파일 내용을 변경하면 잘못된 동작이 발생할 수 있으며, 코드를 다시 생성하면


  		




  
  7
  
    
//     이러한 변경 내용이 손실됩니다.


  		




  
  8
  
    
// </auto-generated>


  		




  
  9
  
    
//------------------------------------------------------------------------------


  		




  
  10
  
    

  		




  
  11
  
    
namespace DataBaseCreate.Properties {


  		




  
  12
  
    
    


  		




  
  13
  
    
    


  		




  
  14
  
    
    [global::System.Runtime.CompilerServices.CompilerGeneratedAttribute()]


  		




  
  15
  
    
    [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Editors.SettingsDesigner.SettingsSingleFileGenerator", "16.10.0.0")]


  		




  
  16
  
    
    internal sealed partial class Settings : global::System.Configuration.ApplicationSettingsBase {


  		




  
  17
  
    
        


  		




  
  18
  
    
        private static Settings defaultInstance = ((Settings)(global::System.Configuration.ApplicationSettingsBase.Synchronized(new Settings())));


  		




  
  19
  
    
        


  		




  
  20
  
    
        public static Settings Default {


  		




  
  21
  
    
            get {


  		




  
  22
  
    
                return defaultInstance;


  		




  
  23
  
    
            }


  		




  
  24
  
    
        }


  		




  
  25
  
    
        


  		




  
  26
  
    
        [global::System.Configuration.ApplicationScopedSettingAttribute()]


  		




  
  27
  
    
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]


  		




  
  28
  
    
        [global::System.Configuration.SpecialSettingAttribute(global::System.Configuration.SpecialSetting.ConnectionString)]


  		




  
  29
  
    
        [global::System.Configuration.DefaultSettingValueAttribute("data source=12.127.163.230,10102;initial catalog=ID2Manager;persist security info" +


  		




  
  30
  
    
            "=True;user id=sa;password=P@sswd12;multipleactiveresultsets=True")]


  		




  
  31
  
    
        public string ID2Manager {


  		




  
  32
  
    
            get {


  		




  
  33
  
    
                return ((string)(this["ID2Manager"]));


  		




  
  34
  
    
            }


  		




  
  35
  
    
        }


  		




  
  36
  
    
    }


  		




  
  37
  
    
}


  		












  

    
      ID2.Manager/DataBaseCreate/Properties/Settings.settings
    
  





  
  1
  
    
<?xml version='1.0' encoding='utf-8'?>


  		




  
  2
  
    
<SettingsFile xmlns="http://schemas.microsoft.com/VisualStudio/2004/01/settings" CurrentProfile="(Default)" GeneratedClassNamespace="DataBaseCreate.Properties" GeneratedClassName="Settings">


  		




  
  3
  
    
  <Profiles />


  		




  
  4
  
    
  <Settings>


  		




  
  5
  
    
    <Setting Name="ID2Manager" Type="(Connection string)" Scope="Application">


  		




  
  6
  
    
      <DesignTimeValue Profile="(Default)">&lt;?xml version="1.0" encoding="utf-16"?&gt;


  		




  
  7
  
    
&lt;SerializableConnectionString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;


  		




  
  8
  
    
  &lt;ConnectionString&gt;data source=12.127.163.230,10102;initial catalog=ID2Manager;persist security info=True;user id=sa;password=P@sswd12;multipleactiveresultsets=True&lt;/ConnectionString&gt;


  		




  
  9
  
    
&lt;/SerializableConnectionString&gt;</DesignTimeValue>


  		




  
  10
  
    
      <Value Profile="(Default)">data source=12.127.163.230,10102;initial catalog=ID2Manager;persist security info=True;user id=sa;password=P@sswd12;multipleactiveresultsets=True</Value>


  		




  
  11
  
    
    </Setting>


  		




  
  12
  
    
  </Settings>


  		




  
  13
  
    
</SettingsFile>


  		












  

    
      ID2.Manager/DataBaseCreate/ViewMarkupData.sql
    
  





  
  1
  
    
USE [ID2Manager]


  		




  
  2
  
    
GO


  		




  
  3
  
    

  		




  
  4
  
    
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPaneCount' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'ViewMarkupData'


  		




  
  5
  
    
GO


  		




  
  6
  
    

  		




  
  7
  
    
EXEC sys.sp_dropextendedproperty @name=N'MS_DiagramPane1' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'ViewMarkupData'


  		




  
  8
  
    
GO


  		




  
  9
  
    

  		




  
  10
  
    
/****** Object:  View [dbo].[ViewMarkupData]    Script Date: 2023-08-16 ???? 1:11:44 ******/


  		




  
  11
  
    
DROP VIEW [dbo].[ViewMarkupData]


  		




  
  12
  
    
GO


  		




  
  13
  
    

  		




  
  14
  
    
/****** Object:  View [dbo].[ViewMarkupData]    Script Date: 2023-08-16 ???? 1:11:44 ******/


  		




  
  15
  
    
SET ANSI_NULLS ON


  		




  
  16
  
    
GO


  		




  
  17
  
    

  		




  
  18
  
    
SET QUOTED_IDENTIFIER ON


  		




  
  19
  
    
GO


  		




  
  20
  
    

  		




  
  21
  
    
CREATE VIEW [dbo].[ViewMarkupData]


  		




  
  22
  
    
AS


  		




  
  23
  
    
SELECT  CONVERTER.PROJECT_NO, CONVERTER.DOCUMENT_ID, CONVERTER.STATUS, MarkupData.PAGENUMBER, MarkupData.Text, MarkupData.CREATE_DATE, MarkupData.NAME


  		




  
  24
  
    
FROM     (SELECT  PROJECT_NO, DOCUMENT_ID, MAX(STATUS) AS STATUS


  		




  
  25
  
    
                FROM     markus_SEC.dbo.CONVERTER_DOC


  		




  
  26
  
    
                WHERE  (STATUS >= 0) AND (STATUS <= 4)


  		




  
  27
  
    
                GROUP BY PROJECT_NO, DOCUMENT_ID


  		




  
  28
  
    
                HAVING  (COUNT(*) > 1)) AS CONVERTER LEFT OUTER JOIN


  		




  
  29
  
    
                   (SELECT  markus_SEC.dbo.DOCINFO.PROJECT_NO, markus_SEC.dbo.DOCINFO.DOCUMENT_ID, markus_SEC.dbo.MARKUP_DATA.PAGENUMBER, 


  		




  
  30
  
    
                                   CASE WHEN MAX(dbo.MarkupDataParse(markus_SEC.dbo.MARKUP_DATA.DATA)) IS NOT NULL THEN MAX(dbo.MarkupDataParse(markus_SEC.dbo.MARKUP_DATA.DATA)) 


  		




  
  31
  
    
                                   ELSE MAX('Markup') END AS Text, MAX(markus_SEC.dbo.MARKUP_INFO_VERSION.CREATE_DATE) AS CREATE_DATE, MAX(markus_SEC.dbo.MEMBER.NAME) AS NAME


  		




  
  32
  
    
                    FROM     markus_SEC.dbo.MARKUP_DATA INNER JOIN


  		




  
  33
  
    
                                   markus_SEC.dbo.ControlType ON markus_SEC.dbo.MARKUP_DATA.DATA_TYPE = markus_SEC.dbo.ControlType.TypeValue INNER JOIN


  		




  
  34
  
    
                                   markus_SEC.dbo.DOCINFO INNER JOIN


  		




  
  35
  
    
                                   markus_SEC.dbo.MARKUP_INFO ON markus_SEC.dbo.DOCINFO.ID = markus_SEC.dbo.MARKUP_INFO.DOCINFO_ID INNER JOIN


  		




  
  36
  
    
                                   markus_SEC.dbo.MARKUP_INFO_VERSION ON markus_SEC.dbo.MARKUP_INFO.ID = markus_SEC.dbo.MARKUP_INFO_VERSION.MARKUPINFO_ID ON 


  		




  
  37
  
    
                                   markus_SEC.dbo.MARKUP_DATA.MARKUPINFO_VERSION_ID = markus_SEC.dbo.MARKUP_INFO_VERSION.ID INNER JOIN


  		




  
  38
  
    
                                   markus_SEC.dbo.MEMBER ON markus_SEC.dbo.MARKUP_INFO.USER_ID = markus_SEC.dbo.MEMBER.ID


  		




  
  39
  
    
                    GROUP BY markus_SEC.dbo.DOCINFO.PROJECT_NO, markus_SEC.dbo.DOCINFO.DOCUMENT_ID, markus_SEC.dbo.MARKUP_DATA.PAGENUMBER, 


  		




  
  40
  
    
                                   dbo.MarkupDataParse(markus_SEC.dbo.MARKUP_DATA.DATA), markus_SEC.dbo.MEMBER.NAME) AS MarkupData ON 


  		




  
  41
  
    
               CONVERTER.PROJECT_NO = MarkupData.PROJECT_NO AND CONVERTER.DOCUMENT_ID = MarkupData.DOCUMENT_ID


  		




  
  42
  
    
GO


  		




  
  43
  
    

  		




  
  44
  
    
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]


  		




  
  45
  
    
Begin DesignProperties = 


  		




  
  46
  
    
   Begin PaneConfigurations = 


  		




  
  47
  
    
      Begin PaneConfiguration = 0


  		




  
  48
  
    
         NumPanes = 4


  		




  
  49
  
    
         Configuration = "(H (1[21] 4[16] 2[31] 3) )"


  		




  
  50
  
    
      End


  		




  
  51
  
    
      Begin PaneConfiguration = 1


  		




  
  52
  
    
         NumPanes = 3


  		




  
  53
  
    
         Configuration = "(H (1 [50] 4 [25] 3))"


  		




  
  54
  
    
      End


  		




  
  55
  
    
      Begin PaneConfiguration = 2


  		




  
  56
  
    
         NumPanes = 3


  		




  
  57
  
    
         Configuration = "(H (1 [50] 2 [25] 3))"


  		




  
  58
  
    
      End


  		




  
  59
  
    
      Begin PaneConfiguration = 3


  		




  
  60
  
    
         NumPanes = 3


  		




  
  61
  
    
         Configuration = "(H (4 [30] 2 [40] 3))"


  		




  
  62
  
    
      End


  		




  
  63
  
    
      Begin PaneConfiguration = 4


  		




  
  64
  
    
         NumPanes = 2


  		




  
  65
  
    
         Configuration = "(H (1 [56] 3))"


  		




  
  66
  
    
      End


  		




  
  67
  
    
      Begin PaneConfiguration = 5


  		




  
  68
  
    
         NumPanes = 2


  		




  
  69
  
    
         Configuration = "(H (2 [66] 3))"


  		




  
  70
  
    
      End


  		




  
  71
  
    
      Begin PaneConfiguration = 6


  		




  
  72
  
    
         NumPanes = 2


  		




  
  73
  
    
         Configuration = "(H (4 [50] 3))"


  		




  
  74
  
    
      End


  		




  
  75
  
    
      Begin PaneConfiguration = 7


  		




  
  76
  
    
         NumPanes = 1


  		




  
  77
  
    
         Configuration = "(V (3))"


  		




  
  78
  
    
      End


  		




  
  79
  
    
      Begin PaneConfiguration = 8


  		




  
  80
  
    
         NumPanes = 3


  		




  
  81
  
    
         Configuration = "(H (1[56] 4[18] 2) )"


  		




  
  82
  
    
      End


  		




  
  83
  
    
      Begin PaneConfiguration = 9


  		




  
  84
  
    
         NumPanes = 2


  		




  
  85
  
    
         Configuration = "(H (1 [75] 4))"


  		




  
  86
  
    
      End


  		




  
  87
  
    
      Begin PaneConfiguration = 10


  		




  
  88
  
    
         NumPanes = 2


  		




  
  89
  
    
         Configuration = "(H (1[66] 2) )"


  		




  
  90
  
    
      End


  		




  
  91
  
    
      Begin PaneConfiguration = 11


  		




  
  92
  
    
         NumPanes = 2


  		




  
  93
  
    
         Configuration = "(H (4 [60] 2))"


  		




  
  94
  
    
      End


  		




  
  95
  
    
      Begin PaneConfiguration = 12


  		




  
  96
  
    
         NumPanes = 1


  		




  
  97
  
    
         Configuration = "(H (1) )"


  		




  
  98
  
    
      End


  		




  
  99
  
    
      Begin PaneConfiguration = 13


  		




  
  100
  
    
         NumPanes = 1


  		




  
  101
  
    
         Configuration = "(V (4))"


  		




  
  102
  
    
      End


  		




  
  103
  
    
      Begin PaneConfiguration = 14


  		




  
  104
  
    
         NumPanes = 1


  		




  
  105
  
    
         Configuration = "(V (2))"


  		




  
  106
  
    
      End


  		




  
  107
  
    
      ActivePaneConfig = 0


  		




  
  108
  
    
   End


  		




  
  109
  
    
   Begin DiagramPane = 


  		




  
  110
  
    
      Begin Origin = 


  		




  
  111
  
    
         Top = 0


  		




  
  112
  
    
         Left = 0


  		




  
  113
  
    
      End


  		




  
  114
  
    
      Begin Tables = 


  		




  
  115
  
    
         Begin Table = "CONVERTER"


  		




  
  116
  
    
            Begin Extent = 


  		




  
  117
  
    
               Top = 6


  		




  
  118
  
    
               Left = 311


  		




  
  119
  
    
               Bottom = 119


  		




  
  120
  
    
               Right = 483


  		




  
  121
  
    
            End


  		




  
  122
  
    
            DisplayFlags = 280


  		




  
  123
  
    
            TopColumn = 0


  		




  
  124
  
    
         End


  		




  
  125
  
    
         Begin Table = "MarkupData"


  		




  
  126
  
    
            Begin Extent = 


  		




  
  127
  
    
               Top = 6


  		




  
  128
  
    
               Left = 38


  		




  
  129
  
    
               Bottom = 136


  		




  
  130
  
    
               Right = 210


  		




  
  131
  
    
            End


  		




  
  132
  
    
            DisplayFlags = 280


  		




  
  133
  
    
            TopColumn = 0


  		




  
  134
  
    
         End


  		




  
  135
  
    
      End


  		




  
  136
  
    
   End


  		




  
  137
  
    
   Begin SQLPane = 


  		




  
  138
  
    
   End


  		




  
  139
  
    
   Begin DataPane = 


  		




  
  140
  
    
      Begin ParameterDefaults = ""


  		




  
  141
  
    
      End


  		




  
  142
  
    
      Begin ColumnWidths = 10


  		




  
  143
  
    
         Width = 284


  		




  
  144
  
    
         Width = 1500


  		




  
  145
  
    
         Width = 1500


  		




  
  146
  
    
         Width = 3690


  		




  
  147
  
    
         Width = 1500


  		




  
  148
  
    
         Width = 2490


  		




  
  149
  
    
         Width = 2250


  		




  
  150
  
    
         Width = 1500


  		




  
  151
  
    
         Width = 1500


  		




  
  152
  
    
         Width = 1500


  		




  
  153
  
    
      End


  		




  
  154
  
    
   End


  		




  
  155
  
    
   Begin CriteriaPane = 


  		




  
  156
  
    
      Begin ColumnWidths = 11


  		




  
  157
  
    
         Column = 18090


  		




  
  158
  
    
         Alias = 900


  		




  
  159
  
    
         Table = 1170


  		




  
  160
  
    
         Output = 720


  		




  
  161
  
    
         Append = 1400


  		




  
  162
  
    
         NewValue = 1170


  		




  
  163
  
    
         SortType = 1350


  		




  
  164
  
    
         SortOrder = 1410


  		




  
  165
  
    
         GroupBy = 1350


  		




  
  166
  
    
         Filter = 1350


  		




  
  167
  
    
         Or = 1350


  		




  
  168
  
    
         Or = 1350


  		




  
  169
  
    
         Or = 1350


  		




  
  170
  
    
      End


  		




  
  171
  
    
   End


  		




  
  172
  
    
End


  		




  
  173
  
    
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'ViewMarkupData'


  		




  
  174
  
    
GO


  		




  
  175
  
    

  		




  
  176
  
    
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'ViewMarkupData'


  		




  
  177
  
    
GO


  		




  
  178
  
    

  		




  
  179
  
    

  		












  

    
      ID2.Manager/ID2.Manager/Main.cs
    
  





  1653
  1653
  
    
                    {


  		




  1654
  1654
  
    
                        expanderCellElement.Enabled = false;


  		




  1655
  1655
  
    
                    }


  		




  
  1656
  
    
                    else


  		




  
  1657
  
    
                    {


  		




  
  1658
  
    
                        expanderCellElement.Enabled = true;


  		




  
  1659
  
    
                    }


  		




  1656
  1660
  
    
                }


  		




  1657
  1661
  
    
                else


  		




  1658
  1662
  
    
                {


  		












내보내기  Unified diff