개정판 10f17080
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