프로젝트

일반

사용자정보

개정판 10f17080

ID10f17080d530d84cf0c0e5a5ded2e4ab32ce4a56
상위 9a1bb06b
하위 ac93ec02

유성호이(가) 약 2년 전에 추가함

issue #0000
update 문 수정

Change-Id: I4d86c38ba178978f8b9bd60b7bb81e2ea0ba61d3

차이점 보기:

ID2.Manager/ID2.Manager.Dapper/Repository/DocumentRepository.cs
156 156
                        {
157 157
                            query = $@"
158 158
update dbo.Documents
159
set    [DocumentNo]=@DocumentNo,
160
      ,[RevisonNo]=@RevisonNo,
161
      ,[RefProjectID]=@RefProjectID,
162
      ,[DocFilePath]=@DocFilePath,
163
      ,[DocFileName]=@DocFileName,
164
      ,[Place]=@Place,
165
      ,[JobLevel]=@JobLevel,
166
      ,[IsTypical]=@IsTypical,
167
      ,[PersonInCharge]=@PersonInCharge,
168
      ,[ModifiedDate]=getdate(),
169
      ,[ToIsDiscussion]=@ToIsDiscussion,
170
      ,[ToRemarks]=@ToRemarks,
171
      ,[ToCreator]=@ToCreator,
172
      ,[ToModifier]=@ToModifier,
173
      ,[ToCapturePath]=@ToCapturePath,
174
      ,[ToIsMarkup]=@ToIsMarkup,
175
      ,[FrReviewStatus]=@FrReviewStatus,
176
      ,[FrRemarks]=@FrRemarks,
177
      ,[FrCreator]=@FrCreator,
178
      ,[FrModifier]=@FrModifier,
179
      ,[FrCapturePath]=@FrCapturePath,
180
      ,[FrIsMarkup]=@FrIsMarkup,
181
      ,[IsID2Work]=@IsID2Work,
182
      ,[ID2Connection]=@ID2Connection,
183
      ,[ID2StartDate]=@ID2StartDate,
184
      ,[ID2EndDate]=@ID2EndDate,
185
      ,[ID2JobTime]=@ID2JobTime,
186
      ,[ID2Status]=@ID2Status,
187
      ,[ID2Issues]=@ID2Issues,
188
      ,[AVEVAConnection]=@AVEVAConnection,
189
      ,[AVEVAConvertDate]=@AVEVAConvertDate,
190
      ,[AVEVAReviewDate]=@AVEVAReviewDate,
191
      ,[AVEVAStatus]=@AVEVAStatus,
192
      ,[AVEVAIssues]=@AVEVAIssues,
193
      ,[ReviewFilePath]=@ReviewFilePath,
194
      ,[ReviewFileName]=@ReviewFileName,
195
      ,[ProdReviewer]=@ProdReviewer,
196
      ,[ProdIsResult]=@ProdIsResult,
197
      ,[ProdRemarks]=@ProdRemarks,
198
      ,[ClientReviewer]=@ClientReviewer,
199
      ,[ClientIsResult]=@ClientIsResult,
200
      ,[ClientRemarks]=@ClientRemarks,
201
      ,[DTIsGateWay]=@DTIsGateWay,
202
      ,[DTIsImport]=@DTIsImport,
203
      ,[DTIsRegSystem]=@DTIsRegSystem,
159
set    [DocumentNo]=@DocumentNo
160
      ,[RevisonNo]=@RevisonNo
161
      ,[RefProjectID]=@RefProjectID
162
      ,[DocFilePath]=@DocFilePath
163
      ,[DocFileName]=@DocFileName
164
      ,[Place]=@Place
165
      ,[JobLevel]=@JobLevel
166
      ,[IsTypical]=@IsTypical
167
      ,[PersonInCharge]=@PersonInCharge
168
      ,[ModifiedDate]=getdate()
169
      ,[ToIsDiscussion]=@ToIsDiscussion
170
      ,[ToRemarks]=@ToRemarks
171
      ,[ToCreator]=@ToCreator
172
      ,[ToModifier]=@ToModifier
173
      ,[ToCapturePath]=@ToCapturePath
174
      ,[ToIsMarkup]=@ToIsMarkup
175
      ,[FrReviewStatus]=@FrReviewStatus
176
      ,[FrRemarks]=@FrRemarks
177
      ,[FrCreator]=@FrCreator
178
      ,[FrModifier]=@FrModifier
179
      ,[FrCapturePath]=@FrCapturePath
180
      ,[FrIsMarkup]=@FrIsMarkup
181
      ,[IsID2Work]=@IsID2Work
182
      ,[ID2Connection]=@ID2Connection
183
      ,[ID2StartDate]=@ID2StartDate
184
      ,[ID2EndDate]=@ID2EndDate
185
      ,[ID2JobTime]=@ID2JobTime
186
      ,[ID2Status]=@ID2Status
187
      ,[ID2Issues]=@ID2Issues
188
      ,[AVEVAConnection]=@AVEVAConnection
189
      ,[AVEVAConvertDate]=@AVEVAConvertDate
190
      ,[AVEVAReviewDate]=@AVEVAReviewDate
191
      ,[AVEVAStatus]=@AVEVAStatus
192
      ,[AVEVAIssues]=@AVEVAIssues
193
      ,[ReviewFilePath]=@ReviewFilePath
194
      ,[ReviewFileName]=@ReviewFileName
195
      ,[ProdReviewer]=@ProdReviewer
196
      ,[ProdIsResult]=@ProdIsResult
197
      ,[ProdRemarks]=@ProdRemarks
198
      ,[ClientReviewer]=@ClientReviewer
199
      ,[ClientIsResult]=@ClientIsResult
200
      ,[ClientRemarks]=@ClientRemarks
201
      ,[DTIsGateWay]=@DTIsGateWay
202
      ,[DTIsImport]=@DTIsImport
203
      ,[DTIsRegSystem]=@DTIsRegSystem
204 204
      ,[DTRemarks]=@DTRemarks
205 205
where  [DocID]=@DocID;";
206 206
                        }

내보내기 Unified diff

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