/ID2.Manager/ID2.Manager.Dapper/Repository/DocumentRepository.cs - 이력해설 - HYTOS - 일정관리

hytos / ID2.Manager / ID2.Manager.Dapper / Repository / DocumentRepository.cs @ 0d323d8f

-            5898479a
+using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Text;
 using System.Threading.Tasks;
 using ID2.Manager.Data.Models;
 namespace ID2.Manager.Dapper.Repository
+{
     public class DocumentRepository : BaseRepository
+    {
         public DocumentRepository(string connectionStr) : base(connectionStr) { }
         public IEnumerable<Documents> GetAllDocuments()
+        {
             string query = $@"
-ae20f6
+select   doc.*
-            5898479a
+from     dbo.Documents doc
-ae20f6
+order by doc.Seq";
-            5898479a
+            yoush97
             return Query<Documents>(query);
+        }
-f6326
+            yoush97
-c1971
+        public bool SetDocumentData(List<Documents> docList, List<Documents> delDocList)
-f6326
+            yoush97
             bool isSuccess = false;
             try
+            {
                 using (var transaction = base._DbConnection.BeginTransaction())
+                {
-c1971
+                    string query = string.Empty;
                     if (delDocList.Count > 0)
-f6326
+            yoush97
-c1971
+                        string docIDList = string.Join("','", delDocList.Where(x => !string.IsNullOrEmpty(x.DocID)).Select(x => x.DocID).ToList());
                         if (docIDList.Length > 0)
+                        {
                             query = $@"delete from dbo.Documents where Cases_UID=@Cases_UID and [DocID] in ('{docIDList}');";
                             base.Execute(query, transaction);
+                        }
+                    }
-f6326
+            yoush97
                     foreach (Documents doc in docList)
+                    {
                         if (string.IsNullOrEmpty(doc.DocID))
+                        {
                             query = $@"
 insert into dbo.Documents
+(
      [DocID]
     ,[DocumentNo]
     ,[RevisonNo]
     ,[RefProjectID]
     ,[IsLatest]
     ,[DocFilePath]
     ,[DocFileName]
     ,[Place]
     ,[JobLevel]
     ,[IsTypical]
     ,[PersonInCharge]
     ,[IsDeleted]
     ,[RegisteredDate]
     ,[ModifiedDate]
     ,[DeletedDate]
     ,[ToIsDiscussion]
     ,[ToRemarks]
     ,[ToCreator]
     ,[ToModifier]
     ,[ToCapturePath]
     ,[ToIsMarkup]
     ,[FrReviewStatus]
     ,[FrRemarks]
     ,[FrCreator]
     ,[FrModifier]
     ,[FrCapturePath]
     ,[FrIsMarkup]
     ,[IsID2Work]
     ,[ID2Connection]
     ,[ID2StartDate]
     ,[ID2EndDate]
     ,[ID2JobTime]
     ,[ID2Status]
     ,[ID2Issues]
     ,[AVEVAConnection]
     ,[AVEVAConvertDate]
     ,[AVEVAReviewDate]
     ,[AVEVAStatus]
     ,[AVEVAIssues]
     ,[ReviewFilePath]
     ,[ReviewFileName]
     ,[ProdReviewer]
     ,[ProdIsResult]
     ,[ProdRemarks]
     ,[ClientReviewer]
     ,[ClientIsResult]
     ,[ClientRemarks]
     ,[DTIsGateWay]
     ,[DTIsImport]
     ,[DTIsRegSystem]
     ,[DTRemarks]
+)
 values
+(
      lower(newid())
     ,@DocumentNo
     ,@RevisonNo
     ,@RefProjectID
     ,@IsLatest
     ,@DocFilePath
     ,@DocFileName
     ,@Place
     ,@JobLevel
     ,@IsTypical
     ,@PersonInCharge
     ,@IsDeleted
-c1971
+    ,getdate()
-f6326
+    ,@ModifiedDate
     ,@DeletedDate
     ,@ToIsDiscussion
     ,@ToRemarks
     ,@ToCreator
     ,@ToModifier
     ,@ToCapturePath
     ,@ToIsMarkup
     ,@FrReviewStatus
     ,@FrRemarks
     ,@FrCreator
     ,@FrModifier
     ,@FrCapturePath
     ,@FrIsMarkup
     ,@IsID2Work
     ,@ID2Connection
     ,@ID2StartDate
     ,@ID2EndDate
     ,@ID2JobTime
     ,@ID2Status
     ,@ID2Issues
     ,@AVEVAConnection
     ,@AVEVAConvertDate
     ,@AVEVAReviewDate
     ,@AVEVAStatus
     ,@AVEVAIssues
     ,@ReviewFilePath
     ,@ReviewFileName
     ,@ProdReviewer
     ,@ProdIsResult
     ,@ProdRemarks
     ,@ClientReviewer
     ,@ClientIsResult
     ,@ClientRemarks
     ,@DTIsGateWay
     ,@DTIsImport
     ,@DTIsRegSystem
     ,@DTRemarks
-c1971
+);";
-f6326
+            yoush97
                         else
+                        {
                             query = $@"
 update dbo.Documents
 set    [DocumentNo]
       ,[RevisonNo]
       ,[RefProjectID]
       ,[IsLatest]
       ,[DocFilePath]
       ,[DocFileName]
       ,[Place]
       ,[JobLevel]
       ,[IsTypical]
       ,[PersonInCharge]
       ,[IsDeleted]
       ,[RegisteredDate]
       ,[ModifiedDate]
       ,[DeletedDate]
       ,[ToIsDiscussion]
       ,[ToRemarks]
       ,[ToCreator]
       ,[ToModifier]
       ,[ToCapturePath]
       ,[ToIsMarkup]
       ,[FrReviewStatus]
       ,[FrRemarks]
       ,[FrCreator]
       ,[FrModifier]
       ,[FrCapturePath]
       ,[FrIsMarkup]
       ,[IsID2Work]
       ,[ID2Connection]
       ,[ID2StartDate]
       ,[ID2EndDate]
       ,[ID2JobTime]
       ,[ID2Status]
       ,[ID2Issues]
       ,[AVEVAConnection]
       ,[AVEVAConvertDate]
       ,[AVEVAReviewDate]
       ,[AVEVAStatus]
       ,[AVEVAIssues]
       ,[ReviewFilePath]
       ,[ReviewFileName]
       ,[ProdReviewer]
       ,[ProdIsResult]
       ,[ProdRemarks]
       ,[ClientReviewer]
       ,[ClientIsResult]
       ,[ClientRemarks]
       ,[DTIsGateWay]
       ,[DTIsImport]
       ,[DTIsRegSystem]
       ,[DTRemarks]
-c1971
+where  [DocID]=@DocID;";
-f6326
+            yoush97
                         base.Execute(query, doc, transaction);
+                    }
                     transaction.Commit();
                     isSuccess = true;
+                }
+            }
             catch (Exception ex)
+            {
                 throw ex;
+            }
             return isSuccess;
+        }
-            5898479a
+            yoush97
+}

프로젝트

일반

사용자정보

HYTOS

hytos / ID2.Manager / ID2.Manager.Dapper / Repository / DocumentRepository.cs @ 0d323d8f