프로젝트

일반

사용자정보

개정판 3bde451b

ID3bde451b422200cd73fd780e9fdbaa7768afaead
상위 7b095cc3
하위 504c5aa1, 2c634aed

semi 이(가) 약 5년 전에 추가함

FINALPDF와 CONVERT_DOC 저장 프로시저로 변경

Change-Id: I832b4103112d7b9968f573688378b779a9df2db8

차이점 보기:

ConvertService/ServiceBase/Markus.Service.StationController/MarkusModel.edmx
5 5 
    <!-- SSDL content -->
6 6 
    <edmx:StorageModels>
7 7 
    <Schema Namespace="markusModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
8 
        <Function Name="SELECT_CONVERT_DELETE" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
9 
          <Parameter Name="P_ID" Type="nvarchar" Mode="In" />
10 
        </Function>
8 11 
        <Function Name="SELECT_CONVERT_INSERT" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
9 12 
          <Parameter Name="P_ID" Type="nvarchar" Mode="In" />
10 13 
          <Parameter Name="P_PROJECT_NO" Type="nvarchar" Mode="In" />
......
12 15 
          <Parameter Name="P_DOCUMENT_ID" Type="nvarchar" Mode="In" />
13 16 
        </Function>
14 17 
        <Function Name="SELECT_CONVERT_ITEM" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
18 
          <Parameter Name="P_ID" Type="nvarchar" Mode="In" />
15 19 
          <Parameter Name="P_PROJECT_NO" Type="nvarchar" Mode="In" />
16 20 
          <Parameter Name="P_DOCUMENT_ID" Type="nvarchar" Mode="In" />
17 21 
          <Parameter Name="P_STATUS" Type="int" Mode="In" />
......
26 30 
          <Parameter Name="P_DOCUMENT_NAME" Type="nvarchar" Mode="In" />
27 31 
          <Parameter Name="P_DOCUMENT_NO" Type="nvarchar" Mode="In" />
28 32 
          <Parameter Name="P_REVISION" Type="nvarchar" Mode="In" />
33 
          <Parameter Name="P_SERVICE_ID" Type="nvarchar" Mode="In" />
34 
          <Parameter Name="P_RECONVERTER" Type="int" Mode="In" />
35 
        </Function>
36 
        <Function Name="SELECT_FINAL_PDF_DELETE" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
37 
          <Parameter Name="P_ID" Type="nvarchar" Mode="In" />
38 
        </Function>
39 
        <Function Name="SELECT_FINAL_PDF_INSERT" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
40 
          <Parameter Name="P_ID" Type="nvarchar" Mode="In" />
41 
          <Parameter Name="P_PROJECT_NO" Type="nvarchar" Mode="In" />
42 
          <Parameter Name="P_DOCINFO_ID" Type="nvarchar" Mode="In" />
43 
          <Parameter Name="P_DOCUMENT_ID" Type="nvarchar" Mode="In" />
44 
        </Function>
45 
        <Function Name="SELECT_FINAL_PDF_ITEM" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
46 
          <Parameter Name="P_ID" Type="nvarchar" Mode="In" />
47 
          <Parameter Name="P_PROJECT_NO" Type="nvarchar" Mode="In" />
48 
          <Parameter Name="P_DOCUMENT_ID" Type="nvarchar" Mode="In" />
49 
          <Parameter Name="P_MARKUPINFO_ID" Type="nvarchar" Mode="In" />
50 
          <Parameter Name="P_DOCINFO_ID" Type="nvarchar" Mode="In" />
51 
          <Parameter Name="P_DOCUMENT_NAME" Type="nvarchar" Mode="In" />
52 
          <Parameter Name="P_DOCUMENT_NO" Type="nvarchar" Mode="In" />
53 
          <Parameter Name="P_CREATE_USER_ID" Type="nvarchar" Mode="In" />
54 
          <Parameter Name="P_STATUS" Type="int" Mode="In" />
55 
          <Parameter Name="P_TAKE_COUNT" Type="int" Mode="In" />
56 
          <Parameter Name="P_GROUP_NO" Type="nvarchar" Mode="In" />
57 
          <Parameter Name="P_REVISION" Type="nvarchar" Mode="In" />
58 
          <Parameter Name="P_BEGIN_CREATE_DATETIME" Type="datetime" Mode="In" />
59 
          <Parameter Name="P_FINISH_CREATE_DATETIME" Type="datetime" Mode="In" />
60 
          <Parameter Name="P_BEGIN_START_DATETIE" Type="datetime" Mode="In" />
61 
          <Parameter Name="P_FINISH_START_DATETIME" Type="datetime" Mode="In" />
62 
          <Parameter Name="P_BEGIN_END_DATETIME" Type="datetime" Mode="In" />
63 
          <Parameter Name="P_FINISH_END_DATETIME" Type="datetime" Mode="In" />
29 64 
        </Function>
30 65 
        <Function Name="SELECT_RERECONVERT_ITEM" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
31 66 
          <Parameter Name="P_ID" Type="nvarchar" Mode="In" />
32 67 
          <Parameter Name="P_RECONVERTER" Type="int" Mode="In" />
68 
          <Parameter Name="P_CREATE_DATETIME" Type="datetime" Mode="In" />
33 69 
          <Parameter Name="P_STATUS" Type="int" Mode="In" />
70 
          <Parameter Name="P_END_DATETIME" Type="datetime" Mode="In" />
34 71 
        </Function>
35 72 
        <EntityContainer Name="markusModelStoreContainer" />
36 73 
      </Schema></edmx:StorageModels>
......
39 76 
      <Schema Namespace="markusModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
40 77 
        <EntityContainer Name="markusEntities" annotation:LazyLoadingEnabled="true" >
41 78 
          <FunctionImport Name="SELECT_CONVERT_ITEM" ReturnType="Collection(markusModel.SELECT_CONVERT_ITEM_Result)">
79 
            <Parameter Name="P_ID" Mode="In" Type="String" />
42 80 
            <Parameter Name="P_PROJECT_NO" Mode="In" Type="String" />
43 81 
            <Parameter Name="P_DOCUMENT_ID" Mode="In" Type="String" />
44 82 
            <Parameter Name="P_STATUS" Mode="In" Type="Int32" />
......
53 91 
            <Parameter Name="P_DOCUMENT_NAME" Mode="In" Type="String" />
54 92 
            <Parameter Name="P_DOCUMENT_NO" Mode="In" Type="String" />
55 93 
            <Parameter Name="P_REVISION" Mode="In" Type="String" />
94 
            <Parameter Name="P_SERVICE_ID" Mode="In" Type="String" />
95 
            <Parameter Name="P_RECONVERTER" Mode="In" Type="Int32" />
56 96 
          </FunctionImport>
57 
          <FunctionImport Name="SELECT_RERECONVERT_ITEM" ReturnType="Collection(markusModel.SELECT_RERECONVERT_ITEM_Result)">
97 
          <FunctionImport Name="SELECT_RERECONVERT_ITEM">
58 98 
            <Parameter Name="P_ID" Mode="In" Type="String" />
59 99 
            <Parameter Name="P_RECONVERTER" Mode="In" Type="Int32" />
100 
            <Parameter Name="P_CREATE_DATETIME" Mode="In" Type="DateTime" />
60 101 
            <Parameter Name="P_STATUS" Mode="In" Type="Int32" />
102 
            <Parameter Name="P_END_DATETIME" Mode="In" Type="DateTime" />
61 103 
          </FunctionImport>
62 104 
          <FunctionImport Name="SELECT_CONVERT_INSERT">
63 105 
            <Parameter Name="P_ID" Mode="In" Type="String" />
......
65 107 
            <Parameter Name="P_DOCUMENT_URL" Mode="In" Type="String" />
66 108 
            <Parameter Name="P_DOCUMENT_ID" Mode="In" Type="String" />
67 109 
          </FunctionImport>
110 
          <FunctionImport Name="SELECT_CONVERT_DELETE">
111 
          <Parameter Name="P_ID" Mode="In" Type="String" />
112 
          </FunctionImport>
113 
          <FunctionImport Name="SELECT_FINAL_PDF_DELETE">
114 
          <Parameter Name="P_ID" Mode="In" Type="String" />
115 
          </FunctionImport>
116 
          <FunctionImport Name="SELECT_FINAL_PDF_INSERT">
117 
            <Parameter Name="P_ID" Mode="In" Type="String" />
118 
            <Parameter Name="P_PROJECT_NO" Mode="In" Type="String" />
119 
            <Parameter Name="P_DOCINFO_ID" Mode="In" Type="String" />
120 
            <Parameter Name="P_DOCUMENT_ID" Mode="In" Type="String" />
121 
          </FunctionImport>
122 
          <FunctionImport Name="SELECT_FINAL_PDF_ITEM" ReturnType="Collection(markusModel.SELECT_FINAL_PDF_Result)">
123 
            <Parameter Name="P_ID" Mode="In" Type="String" />
124 
            <Parameter Name="P_PROJECT_NO" Mode="In" Type="String" />
125 
            <Parameter Name="P_DOCUMENT_ID" Mode="In" Type="String" />
126 
            <Parameter Name="P_MARKUPINFO_ID" Mode="In" Type="String" />
127 
            <Parameter Name="P_DOCINFO_ID" Mode="In" Type="String" />
128 
            <Parameter Name="P_DOCUMENT_NAME" Mode="In" Type="String" />
129 
            <Parameter Name="P_DOCUMENT_NO" Mode="In" Type="String" />
130 
            <Parameter Name="P_CREATE_USER_ID" Mode="In" Type="String" />
131 
            <Parameter Name="P_STATUS" Mode="In" Type="Int32" />
132 
            <Parameter Name="P_TAKE_COUNT" Mode="In" Type="Int32" />
133 
            <Parameter Name="P_GROUP_NO" Mode="In" Type="String" />
134 
            <Parameter Name="P_REVISION" Mode="In" Type="String" />
135 
            <Parameter Name="P_BEGIN_CREATE_DATETIME" Mode="In" Type="DateTime" />
136 
            <Parameter Name="P_FINISH_CREATE_DATETIME" Mode="In" Type="DateTime" />
137 
            <Parameter Name="P_BEGIN_START_DATETIE" Mode="In" Type="DateTime" />
138 
            <Parameter Name="P_FINISH_START_DATETIME" Mode="In" Type="DateTime" />
139 
            <Parameter Name="P_BEGIN_END_DATETIME" Mode="In" Type="DateTime" />
140 
            <Parameter Name="P_FINISH_END_DATETIME" Mode="In" Type="DateTime" />
141 
          </FunctionImport>
68 142 
        </EntityContainer>
69 143 
        <ComplexType Name="SELECT_CONVERT_ITEM_Result">
70 144 
          <Property Type="String" Name="ID" Nullable="false" MaxLength="50" />
......
86 160 
          <Property Type="String" Name="GROUP_NO" Nullable="true" MaxLength="50" />
87 161 
          <Property Type="String" Name="RESULT_FILE" Nullable="true" MaxLength="500" />
88 162 
          <Property Type="String" Name="RESULT" Nullable="true" MaxLength="50" />
163 
          <Property Type="String" Name="PROPERTIES_VALUE" Nullable="false" />
89 164 
        </ComplexType>
90 
        <ComplexType Name="SELECT_RERECONVERT_ITEM_Result">
91 
          <Property Type="String" Name="EX" Nullable="true" MaxLength="50" />
92 
          <Property Type="Int32" Name="RETURNVALUE" Nullable="true" />
165 
        <ComplexType Name="SELECT_FINAL_PDF_Result" >
166 
          <Property Type="String" Name="ID" Nullable="false" />
167 
          <Property Type="String" Name="PROJECT_NO" Nullable="false" />
168 
          <Property Type="String" Name="DOCUMENT_ID" Nullable="false" />
169 
          <Property Type="String" Name="MARKUPINFO_ID" Nullable="false" />
170 
          <Property Type="String" Name="DOCINFO_ID" Nullable="false" />
171 
          <Property Type="String" Name="DOCUMENT_NAME" Nullable="false" />
172 
          <Property Type="String" Name="DOCUMENT_NO" Nullable="false" />
173 
          <Property Type="String" Name="CREATE_USER_ID" Nullable="false" />
174 
          <Property Type="String" Name="GROUP_NO" Nullable="false" />
175 
          <Property Type="Int32" Name="STATUS" Nullable="false" />
176 
          <Property Type="String" Name="REVISION" Nullable="false" />
177 
          <Property Type="DateTime" Name="CREATE_DATETIME" Nullable="false" />
178 
          <Property Type="DateTime" Name="START_DATETIME" Nullable="true" />
179 
          <Property Type="DateTime" Name="END_DATETIME" Nullable="true" />
180 
          <Property Type="Int32" Name="CURRENT_PAGE" Nullable="false" />
181 
          <Property Type="Int32" Name="TOTAL_PAGE" Nullable="false" />
182 
          <Property Type="String" Name="ORIGINAL_FILE" Nullable="false" />
183 
          <Property Type="String" Name="EXCEPTION" Nullable="false" />
184 
          <Property Type="String" Name="RESULT_FILE" Nullable="false" />
185 
          <Property Type="String" Name="RESULT" Nullable="false" />
186 
          <Property Type="String" Name="LINK" Nullable="false" />
187 
          <Property Type="String" Name="PROPERTIES_TYPE" Nullable="false" />
188 
          <Property Type="String" Name="PROPERTIES_PROPERTY" Nullable="false" />
189 
          <Property Type="String" Name="PROPERTIES_VALUE" Nullable="false" />
93 190 
        </ComplexType>
94 191 
      </Schema>
95 192 
    </edmx:ConceptualModels>
......
123 220 
            </ResultMapping>
124 221 
          </FunctionImportMapping>
125 222 
          <FunctionImportMapping FunctionImportName="SELECT_RERECONVERT_ITEM" FunctionName="markusModel.Store.SELECT_RERECONVERT_ITEM">
223 
          </FunctionImportMapping>
224 
          <FunctionImportMapping FunctionImportName="SELECT_CONVERT_INSERT" FunctionName="markusModel.Store.SELECT_CONVERT_INSERT" />
225 
          <FunctionImportMapping FunctionImportName="SELECT_CONVERT_DELETE" FunctionName="markusModel.Store.SELECT_CONVERT_DELETE" />
226 
          <FunctionImportMapping FunctionImportName="SELECT_FINAL_PDF_DELETE" FunctionName="markusModel.Store.SELECT_FINAL_PDF_DELETE" />
227 
          <FunctionImportMapping FunctionImportName="SELECT_FINAL_PDF_INSERT" FunctionName="markusModel.Store.SELECT_FINAL_PDF_INSERT" />
228 
          <FunctionImportMapping FunctionImportName="SELECT_FINAL_PDF_ITEM" FunctionName="markusModel.Store.SELECT_FINAL_PDF_ITEM" >
126 229 
            <ResultMapping>
127 
              <ComplexTypeMapping TypeName="markusModel.SELECT_RERECONVERT_ITEM_Result">
128 
                <ScalarProperty Name="EX" ColumnName="EX" />
129 
                <ScalarProperty Name="RETURNVALUE" ColumnName="RETURNVALUE" />
130 
              </ComplexTypeMapping>
230 
              <ComplexTypeMapping TypeName="markusModel.SELECT_FINAL_PDF_Result" />
131 231 
            </ResultMapping>
132 232 
          </FunctionImportMapping>
133 
          <FunctionImportMapping FunctionImportName="SELECT_CONVERT_INSERT" FunctionName="markusModel.Store.SELECT_CONVERT_INSERT" />
134 233 
        </EntityContainerMapping>
135 234 
      </Mapping>
136 235 
    </edmx:Mappings>

내보내기 Unified diff

클립보드 이미지 추가 (최대 크기: 500 MB)