/ - Diff - MARKUS - 일정관리

개정판 2ab012e8

ID	2ab012e8c38d0b8980678a02ba95f6e020e4dce9
상위	2aac9b2b
하위	6c781c0c

김동진이(가) 6년 이상 전에 추가함

issue #573 : Direct DB Connection Modify
KCOM API Method add

KCOM_API/KCOM_API.csproj.user
9	9	<IISExpressUseClassicPipelineMode />
10	10	<UseGlobalApplicationHostFile />
11	11	<NameOfLastUsedPublishProfile>FolderProfile</NameOfLastUsedPublishProfile>
	12	<LastActiveSolutionConfig>Debug\|Any CPU</LastActiveSolutionConfig>
12	13	</PropertyGroup>
13	14	<ProjectExtensions>
14	15	<VisualStudio>

     using MARKUS;
     using System;
     using System.Collections.Generic;
     using System.Collections.ObjectModel;
     using System.Linq;
     using System.Runtime.Remoting.Channels.Tcp;
     using System.Runtime.Serialization;
-...
+            }
             [OperationContract]
             public VPRevision GetVPRevisionFirstOrDefault(string ProjectNo, string DocumentId)
+            {
                 VPRevision _result = null;
                 try
+                {
                     using (CIEntities entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(ProjectNo).ToString()))
+                    {
                         _result = (from docitem in entity.DOCUMENT_ITEM
                          where docitem.DOCUMENT_ID == DocumentId
                          select new VPRevision
+                         {
                              RevNo = docitem.REVISION,
                              GroupNo = docitem.GROUP_NO,
                              FROM_VENDOR = docitem.ORIGINAL_FILE,
                              DOCUMENT_ID = docitem.DOCUMENT_ID,
                              TO_VENDOR = docitem.RESULT_FILE,
                              RESULT = docitem.RESULT
                          }).FirstOrDefault();
+                    }
+                }
                 catch (Exception)
+                {
                     throw;
+                }
                 finally
+                {
                     GC.Collect(2);
+                }
                 return _result;
+            }
             [OperationContract]
             public DOCINFO GetDocInfo(KCOM_BasicParam param)
+            {
                 DOCINFO _result = null;
-...
             //    return _result;
             //}
             //[OperationContract]
             //[ServiceKnownType(typeof(MEMBER))]
             //public List<MEMBER> GetUserData(string ProjectNo, string UserID)
             //{
             //    List<MEMBER> _result = new List<MEMBER>();
             [OperationContract]
             [ServiceKnownType(typeof(MEMBER))]
             public List<MEMBER> GetUserData(string ProjectNo, string UserID)
+            {
                 List<MEMBER> _result = new List<MEMBER>();
             //    using (CIEntities entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(ProjectNo).ToString()))
             //    {
             //        var _UserList = from member in entity.MEMBER
             //                        where member.ID == UserID
             //                        select member;
             //        _result = _UserList.ToList();
             //    }
             //    //GC.Collect(2);
             //    return _result;
             //}
                 using (CIEntities entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(ProjectNo).ToString()))
+                {
                     var _UserList = from member in entity.MEMBER
                                     where member.ID == UserID
                                     select member;
                     _result = _UserList.ToList();
+                }
                 //GC.Collect(2);
                 return _result;
+            }
             [OperationContract]
-...
             //    }
             //}
             #endregion
             [OperationContract]
             public bool SaveMarkupData(MarkupInfoItem UserState,string project_no,string doc_id, string user_id, List<MARKUP_DATA> mlmarkup_data)
+            {
                 using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                {
                     #region Docinfo 정보 가져오기
                     string docinfoid_ = (from info in Entity.DOCINFO
                                          where info.DOCUMENT_ID == doc_id
                                          && info.PROJECT_NO == project_no
                                          select info.ID
                                          ).First().ToString();
                     #endregion
                     #region Markup_Info 저장
                     MARKUP_INFO markup_info = new MARKUP_INFO();
                     try
+                    {
                         markup_info = (from info in Entity.MARKUP_INFO
                                        where info.ID == UserState.MarkupInfoID && info.USER_ID == user_id
                                        select info).FirstOrDefault();
+                    }
                     catch (Exception)
+                    {
                         markup_info = null;
+                    }
                     //markup_info가 없을 경우 생성
                     if (markup_info == null)
+                    {
                         //MarkupInfo 저장
                         markup_info = new MARKUP_INFO
+                        {
                             ID = UserState.MarkupInfoID,
                             DOCINFO_ID = docinfoid_,
                             USER_ID = user_id,
                             CREATE_TIME = DateTime.Now,
                             CONSOLIDATE = UserState.Consolidate,
                             AVOID_CONSOLIDATE = UserState.AvoidConsolidate,
                             PART_CONSOLIDATE = UserState.PartConsolidate,
                             DESCRIPTION = UserState.Description,
                             UPDATE_TIME = DateTime.Now
                         };
                         Entity.MARKUP_INFO.AddObject(markup_info);
+                    }
                     //markup_info가 있을 경우 업데이트
                     else
+                    {
                         markup_info.UPDATE_TIME = DateTime.Now;
+                    }
                     Entity.SaveChanges();
                     #endregion
                     #region Markup_Info_Version 저장
                     MARKUP_INFO_VERSION markup_info_version = new MARKUP_INFO_VERSION();
                     try
+                    {
                         markup_info_version = (from info in Entity.MARKUP_INFO_VERSION
                                                where info.MARKUPINFO_ID == markup_info.ID
                                                select info).FirstOrDefault();
+                    }
                     catch (Exception)
+                    {
                         markup_info_version = null;
+                    }
                     //markup_info_version 없을 경우 생성
                     if (markup_info_version == null)
+                    {
                         //MarkupInfo_version 저장
                         markup_info_version = new MARKUP_INFO_VERSION()
+                        {
                             ID = UserState.MarkupVersionID,
                             MARKUPINFO_ID = markup_info.ID,
                             CREATE_DATE = DateTime.Now
                         };
                         Entity.MARKUP_INFO_VERSION.AddObject(markup_info_version);
                         Entity.SaveChanges();
+                    }
                     #endregion
                     Entity.MARKUP_DATA.Where(data => data.MARKUPINFO_VERSION_ID == markup_info_version.ID).ToList().ForEach(item =>
+                    {
                         Entity.MARKUP_DATA.DeleteObject(item);
                     });
                     Entity.SaveChanges();
                     try
+                    {
                         mlmarkup_data.ForEach(value =>
+                        {
                             Entity.MARKUP_DATA.AddObject(new MARKUP_DATA
+                            {
                                 ID = value.ID,
                                 DATA = value.DATA,
                                 DATA_TYPE = value.DATA_TYPE,
                                 PAGENUMBER = value.PAGENUMBER,
                                 MARKUPINFO_VERSION_ID = markup_info_version.ID
                             });
                         });
                         Entity.SaveChanges();
+                    }
                     catch (Exception)
+                    {
                         return false;
+                    }
+                }
                 return true;
+            }
             [OperationContract]
             public bool SaveSymbol(SYMBOL_PRIVATE symbol_private)
+            {
                 try
+                {
                     using (KCOMDataModel.DataModel.KCOMEntities uc = new KCOMDataModel.DataModel.KCOMEntities(KCOMDataModel.Common.ConnectStringBuilder.KCOMConnectionString().ToString()))
+                    {
                         uc.AddToSYMBOL_PRIVATE(symbol_private);
                         uc.SaveChanges();
+                    }
+                }
                 catch(Exception)
+                {
                     return false;
+                }
                 return true;
+            }
             [OperationContract]
             public bool DeleteSymbol(string symbol_id)
+            {
                 try
+                {
                     using (KCOMEntities Entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
+                    {
                         string delItem_ID = symbol_id;
                         var delitem = Entity.SYMBOL_PRIVATE.Where(data => data.ID == delItem_ID).FirstOrDefault();
                         Entity.SYMBOL_PRIVATE.DeleteObject(delitem);
                         Entity.SaveChanges();
+                    }
+                }
                 catch(Exception)
+                {
                     return false;
+                }
                 return true;
+            }
             [OperationContract]
             public bool RenameSymbol(string symbol_id, string name)
+            {
                 try
+                {
                     using (KCOMEntities Entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
+                    {
                         var UpdateItem = Entity.SYMBOL_PRIVATE.Where(info => info.ID == symbol_id).FirstOrDefault();
                         UpdateItem.NAME = name;
                         Entity.SaveChanges();
+                    }
+                }
                 catch (Exception)
+                {
                     return false;
+                }
                 return true;
+            }
             [OperationContract]
             public bool AddCheckListHistory(string project_no, CHECK_LIST_HISTORY Check_History)
+            {
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         Entity.CHECK_LIST_HISTORY.AddObject(Check_History);
                         Entity.SaveChanges();
+                    }
+                }
                 catch (Exception)
+                {
                     return false;
+                }
                 return true;
+            }
             [OperationContract]
             public bool SaveCheckListHistory(string project_no, string rev, CHECK_LIST_HISTORY Check_History)
+            {
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         var item = Entity.CHECK_LIST_HISTORY.Where(info => info.REVISION == rev).FirstOrDefault();
                         item = Check_History;
                         Entity.SaveChanges();
+                    }
+                }
                 catch (Exception)
+                {
                     return false;
+                }
                 return true;
+            }
             [OperationContract]
             public bool SaveCheckList(string project_no, string _id, CHECK_LIST Check_value)
+            {
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         var item = Entity.CHECK_LIST.Where(info => info.ID == _id).FirstOrDefault();
                         item.TODOLIST = Check_value.TODOLIST;
                         item.REMARK = Check_value.REMARK;
                         item.STATUS = Check_value.STATUS;
                         item.VENDOR = Check_value.VENDOR;
                         item.REPLY = Check_value.REPLY;
                         item.IMAGE_URL = Check_value.IMAGE_URL;
                         item.IMAGE_ANCHOR = Check_value.IMAGE_ANCHOR;
                         item.UPDATE_TIME = Check_value.UPDATE_TIME;
                         Entity.SaveChanges();
+                    }
+                }
                 catch (Exception)
+                {
                     return false;
+                }
                 return true;
+            }
             [OperationContract]
             public bool AddCheckList(string project_no, CHECK_LIST Check_value)
+            {
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         Entity.CHECK_LIST.AddObject(Check_value);
                         Entity.SaveChanges();
+                    }
+                }
                 catch (Exception)
+                {
                     return false;
+                }
                 return true;
+            }
             [OperationContract]
             public CHECK_LIST GetCheckList(string project_no, string _id)
+            {
                 CHECK_LIST Check_value = new CHECK_LIST();
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         Check_value = Entity.CHECK_LIST.Where(info => info.ID == _id).FirstOrDefault();
+                    }
+                }
                 catch (Exception)
+                {
                     return null;
+                }
                 return Check_value;
+            }
             [OperationContract]
             public List<CHECK_LIST> GetUserCheckList(string project_no, string user_id, string doc_no)
+            {
                 List<CHECK_LIST> list = new List<CHECK_LIST>();
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         list = Entity.CHECK_LIST.Where(i => i.PROJECT_NO == project_no && i.DOCUMENT_NO == doc_no && i.USER_ID == user_id).OrderBy(p => p.CREATE_TIME).ToList();
+                    }
+                }
                 catch (Exception)
+                {
                     return null;
+                }
                 return list;
+            }
             [OperationContract]
             public List<CHECK_LIST_HISTORY> GetCheckListHistory(string project_no, string _id)
+            {
                 List<CHECK_LIST_HISTORY> history = new List<CHECK_LIST_HISTORY>();
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         history = Entity.CHECK_LIST_HISTORY.Where(data => data.CHECKLIST_ID == _id).ToList();
+                    }
+                }
                 catch (Exception)
+                {
                     return null;
+                }
                 return history;
+            }
             [OperationContract]
             public CHECK_LIST_HISTORY GetCheckListHistoryFirstOrDefault(string project_no, string checklist_id, string rev)
+            {
                 CHECK_LIST_HISTORY Check_Item = new CHECK_LIST_HISTORY();
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         Check_Item = Entity.CHECK_LIST_HISTORY.Where(info => info.CHECKLIST_ID == checklist_id && info.REVISION == rev).FirstOrDefault();
+                    }
+                }
                 catch (Exception)
+                {
                     return null;
+                }
                 return Check_Item;
+            }
             [OperationContract]
             public bool SavePageAngle(string project_no, List<DOCPAGE> _mldocpage)
+            {
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         KCOMDataModel.DataModel.DOCPAGE _docpage = new KCOMDataModel.DataModel.DOCPAGE();
                         _mldocpage.ForEach(data =>
+                        {
                             _docpage = (from info in Entity.DOCPAGE
                                         where info.ID == data.ID
                                         select info).FirstOrDefault();
                             if (_docpage.PAGE_ANGLE != data.PAGE_ANGLE)
+                            {
                                 _docpage.PAGE_ANGLE = data.PAGE_ANGLE;
+                            }
                         });
                         Entity.SaveChanges();
+                    }
+                }
                 catch (Exception)
+                {
                     return false;
+                }
                 return true;
+            }
             [OperationContract]
             public MARKUP_INFO GetMarkupInfo(string project_no, string _id)
+            {
                 MARKUP_INFO markupInfo = new MARKUP_INFO();
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         markupInfo = Entity.MARKUP_INFO.Where(entity => entity.DOCINFO_ID == _id).OrderByDescending(i => i.CONSOLIDATE).OrderByDescending(j => j.CREATE_TIME).FirstOrDefault();
+                    }
+                }
                 catch (Exception)
+                {
                     return null;
+                }
                 return markupInfo;
+            }
             [OperationContract]
             public List<string> GetMarkupDataListperPage(string project_no, string _markupinfoid, int _pageNo)
+            {
                 List<string> markupdata = new List<string>();
                 MARKUP_INFO_VERSION markup_info_version = new MARKUP_INFO_VERSION();
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         markup_info_version = (from version in Entity.MARKUP_INFO_VERSION
                                                where version.MARKUPINFO_ID == _markupinfoid
                                                orderby version.CREATE_DATE descending
                                                select version).First();
                         markupdata = (from data in Entity.MARKUP_DATA
                                       where data.MARKUPINFO_VERSION_ID == markup_info_version.ID && data.PAGENUMBER == _pageNo
                                       select data.DATA).ToList();
+                    }
+                }
                 catch (Exception)
+                {
                     return null;
+                }
                 return markupdata;
+            }
             [OperationContract]
             public bool AddMarkupInfo(string project_no, MARKUP_INFO value)
+            {
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         Entity.MARKUP_INFO.AddObject(value);
                         Entity.SaveChanges();
+                    }
+                }
                 catch (Exception)
+                {
                     return false;
+                }
                 return true;
+            }
             [OperationContract]
             public bool AddMarkupInfoVersion(string project_no, MARKUP_INFO_VERSION value)
+            {
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         Entity.MARKUP_INFO_VERSION.AddObject(value);
                         Entity.SaveChanges();
+                    }
+                }
                 catch (Exception)
+                {
                     return false;
+                }
                 return true;
+            }
             [OperationContract]
             public bool AddMarkupData(string project_no, MARKUP_DATA value)
+            {
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         Entity.MARKUP_DATA.AddObject(value);
                         Entity.SaveChanges();
+                    }
+                }
                 catch (Exception)
+                {
                     return false;
+                }
                 return true;
+            }
             [OperationContract]
             public bool AvoidMarkupInfo(string project_no, string _doc_id)
+            {
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         var item = Entity.MARKUP_INFO.Where(entity => entity.DOCINFO_ID == _doc_id).OrderByDescending(i => i.CONSOLIDATE).OrderByDescending(j => j.CREATE_TIME).FirstOrDefault();
                         item.AVOID_CONSOLIDATE = 1;
                         Entity.SaveChanges();
+                    }
+                }
                 catch (Exception)
+                {
                     return false;
+                }
                 return true;
+            }
             [OperationContract]
             public bool SaveMarkupInfo(string project_no, string _id, MARKUP_INFO value)
+            {
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         var item = Entity.MARKUP_INFO.Where(info => info.ID == _id).FirstOrDefault();
                         item = value;
                         Entity.SaveChanges();
+                    }
+                }
                 catch (Exception)
+                {
                     return false;
+                }
                 return true;
+            }
             [OperationContract]
             public List<MARKUP_DATA> GetMarkupDataList(string project_no, string _versionid)
+            {
                 List<MARKUP_DATA> mlresult = new List<MARKUP_DATA>();
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         mlresult = Entity.MARKUP_DATA.Where(data => data.MARKUPINFO_VERSION_ID == _versionid).ToList();
+                    }
+                }
                 catch (Exception)
+                {
                     return null;
+                }
                 return mlresult;
+            }
             [OperationContract]
             public bool Consolidate(string project_no, string _user_id, string _doc_id, List<MarkupInfoItem> markupInfoItems)
+            {
                 try
+                {
                     List<KCOMDataModel.DataModel.MARKUP_DATA> instanceDataSet = new List<KCOMDataModel.DataModel.MARKUP_DATA>();
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         var markupInfo = Entity.MARKUP_INFO.Where(entity => entity.DOCINFO_ID == _doc_id).OrderByDescending(i => i.CONSOLIDATE).OrderByDescending(j => j.CREATE_TIME).FirstOrDefault();
                         if (markupInfo.CONSOLIDATE == 1)
+                        {
                             markupInfo.AVOID_CONSOLIDATE = 1;
+                        }
                         foreach (MarkupInfoItem item in markupInfoItems)
+                        {
                             Entity.MARKUP_DATA.Where(data => data.MARKUPINFO_VERSION_ID == item.MarkupVersionID).ToList().ForEach(d =>
+                            {
                                 instanceDataSet.Add(d);
                             });
+                        }
                         KCOMDataModel.DataModel.MARKUP_INFO info = new KCOMDataModel.DataModel.MARKUP_INFO();
                         info.ID = shortGuid();
                         info.CONSOLIDATE = 1;
                         info.CREATE_TIME = DateTime.Now;
                         info.DOCINFO_ID = _doc_id;
                         info.UPDATE_TIME = DateTime.Now;
                         info.USER_ID = _user_id;
                         info.AVOID_CONSOLIDATE = 0;
                         Entity.MARKUP_INFO.AddObject(info);
                         Entity.SaveChanges();
                         KCOMDataModel.DataModel.MARKUP_INFO_VERSION info2 = new KCOMDataModel.DataModel.MARKUP_INFO_VERSION
+                        {
                             ID = shortGuid(),
                             CREATE_DATE = DateTime.Now,
                             MARKUP_INFO = info,
                         };
                         Entity.SaveChanges();
                         foreach (var item in instanceDataSet)
+                        {
                             Entity.MARKUP_DATA.AddObject(new KCOMDataModel.DataModel.MARKUP_DATA
+                            {
                                 ID = shortGuid(),
                                 DATA = item.DATA,
                                 DATA_TYPE = item.DATA_TYPE,
                                 PAGENUMBER = item.PAGENUMBER,
                                 MARKUP_INFO_VERSION = info2
                             });
+                        }
                         Entity.SaveChanges();
+                    }
+                }
                 catch (Exception)
+                {
                     return false;
+                }
                 return true;
+            }
             [OperationContract]
             [ServiceKnownType(typeof(MEMBER))]
             public MEMBER GetMember(string project_no, string user_id)
+            {
                 MEMBER rstmember = new MEMBER();
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         var tmp = (from member in Entity.MEMBER
                                         where member.ID == user_id
                                         select member).FirstOrDefault();
                         rstmember.DEPARTMENT = tmp.DEPARTMENT;
                         rstmember.ID = tmp.ID;
                         rstmember.NAME = tmp.NAME;
+                    }
+                }
                 catch (Exception)
+                {
                     return null;
+                }
                 return rstmember;
+            }
             [OperationContract]
             public List<SYMBOL_PRIVATE> GetSymbolList(string user_id)
+            {
                 List<SYMBOL_PRIVATE> Custom_List = new List<SYMBOL_PRIVATE>();
                 try
+                {
                     using (KCOMEntities Entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
+                    {
                         Custom_List = Entity.SYMBOL_PRIVATE.Where(data => data.MEMBER_USER_ID == user_id).ToList();
+                    }
+                }
                 catch (Exception)
+                {
                     return null;
+                }
                 return Custom_List;
+            }
             [OperationContract]
             public List<string> GetPublicSymbolDeptList()
+            {
                 List<string> Custom_List = new List<string>();
                 try
+                {
                     using (KCOMEntities Entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
+                    {
                         Custom_List = Entity.SYMBOL_PUBLIC.Select(data => data.DEPARTMENT).ToList();
+                    }
+                }
                 catch (Exception)
+                {
                     return null;
+                }
                 return Custom_List;
+            }
             [OperationContract]
             public List<SYMBOL_PUBLIC> GetPublicSymbolList(string dept)
+            {
                 List<SYMBOL_PUBLIC> Custom_List = new List<SYMBOL_PUBLIC>();
                 try
+                {
                     using (KCOMEntities Entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
+                    {
                         if(!string.IsNullOrEmpty(dept))
+                        {
                             Custom_List = Entity.SYMBOL_PUBLIC.Where(data => data.DEPARTMENT == dept).ToList();
+                        }
                         else
+                        {
                             Custom_List = Entity.SYMBOL_PUBLIC.ToList();
+                        }
+                    }
+                }
                 catch (Exception)
+                {
                     return null;
+                }
                 return Custom_List;
+            }
             /// <summary>
             ///
             /// </summary>
             /// <param name="id">symbol id</param>
             /// <param name="type"> 0 : PRIVATE, 1 : PUBLIC</param>
             /// <returns></returns>
             [OperationContract]
             public string GetSymbolData(string id, int type)
+            {
                 string result;
                 try
+                {
                     using (KCOMEntities Entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
+                    {
                         if(type == 0)
+                        {
                             result = Entity.SYMBOL_PRIVATE.Where(data => data.ID == id).FirstOrDefault().DATA;
+                        }
                         else
+                        {
                             result = Entity.SYMBOL_PUBLIC.Where(data => data.ID == id).FirstOrDefault().DATA;
+                        }
+                    }
+                }
                 catch (Exception)
+                {
                     return null;
+                }
                 return result;
+            }
             [OperationContract]
             public string GetSignData(string project_no, string user_id)
+            {
                 string result = null;
                 try
+                {
                     var ModelWFConnectionString = ConnectStringBuilder.ProjectCIConnectString(project_no).ToString();
                     if (null != ModelWFConnectionString)
+                    {
                         using (CIEntities entity = new CIEntities(ModelWFConnectionString))
+                        {
                             var _sign = entity.SIGN_INFO.Where(sin => sin.MEMBER_USER_ID == user_id);
                             if (_sign.Count() > 0)
+                            {
                                 result = _sign.First().SIGN_STR;
+                            }
                             else
+                            {
                                 return null;
+                            }
+                        }
+                    }
+                }
                 catch (Exception)
+                {
                     return null;
+                }
                 return result;
+            }
             [OperationContract]
             public string GetProjectName(string project_no)
+            {
                 string result = null;
                 try
+                {
                     using (KCOMDataModel.DataModel.KCOMEntities Entity = new KCOMDataModel.DataModel.KCOMEntities(KCOMDataModel.Common.ConnectStringBuilder.KCOMConnectionString().ToString()))
+                    {
                         result = Entity.RUN_PROJECTS.Where(i => i.PROJECT_NO == project_no).FirstOrDefault().PROJECT_NAME.ToString();
+                    }
+                }
                 catch (Exception)
+                {
                     return null;
+                }
                 return result;
+            }
             [OperationContract]
             public List<DOCUMENT_ITEM> GetPreRevSelect(string project_no, string doc_no, string current_rev)
+            {
                 List<DOCUMENT_ITEM> result = new List<DOCUMENT_ITEM>();
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         result = Entity.DOCUMENT_ITEM.Where(i => i.PROJECT_NO == project_no
                         && i.DOCUMENT_NO == doc_no
                         && i.REVISION != current_rev).OrderByDescending(i => i.GROUP_NO).ToList();
+                    }
+                }
                 catch (Exception)
+                {
                     return null;
+                }
                 return result;
+            }
             [OperationContract]
             public DOCINFO GetDocInfoOneSelect(string project_no, string doc_id)
+            {
                 DOCINFO docinfo = null;
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         docinfo = (from info in Entity.DOCINFO
                                   where info.DOCUMENT_ID == doc_id
                                   && info.PROJECT_NO == project_no
                                   select info).First();
+                    }
+                }
                 catch (Exception)
+                {
                     return null;
+                }
                 return docinfo;
+            }
             [OperationContract]
             public List<MarkupInfoItem> GetPrintDocItemList(string project_no, string doc_id, List<MarkupInfoItem> _markupInfoList)
+            {
                 MarkupInfoItem _result = null;
                 List<MarkupInfoItem> markupinfo = new List<MarkupInfoItem>();
                 try
+                {
                     using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
+                    {
                         var docitem = (from info in Entity.DOCINFO
                                    where info.DOCUMENT_ID == doc_id
                                    && info.PROJECT_NO == project_no
                                    select info).First();
                         foreach (MARKUP_INFO markinfo in docitem.MARKUP_INFO)
+                        {
                             var member = (from mem in Entity.MEMBER
                                          where mem.ID == markinfo.USER_ID
                                          select mem).First();
                             string displaycolor = null;
                             try
+                            {
                                 displaycolor = _markupInfoList.Where(info => info.MarkupInfoID == markinfo.ID).First().DisplayColor;
+                            }
                             catch(Exception)
+                            {
                                 displaycolor = "#FFFFFF";
+                            }
                             _result = new MarkupInfoItem
+                            {
                                 MarkupInfoID = markinfo.ID,
                                 Consolidate = markinfo.CONSOLIDATE,
                                 CreateTime = markinfo.UPDATE_TIME.HasValue ? markinfo.UPDATE_TIME.Value : markinfo.CREATE_TIME,
                                 DisplayColor = displaycolor,
                                 UserID = markinfo.USER_ID,
                                 UserName = member.NAME,
                                 Depatment = member.DEPARTMENT,
                             };
                             _result.MarkupList = new List<IKCOM.MarkupItem>();
                             var markup_Version = markinfo.MARKUP_INFO_VERSION.OrderByDescending(p => p.CREATE_DATE).First();
                             foreach (MARKUP_DATA markdata in markup_Version.MARKUP_DATA)
+                            {
                                 MarkupItem markitem = new MarkupItem()
+                                {
                                     ID = markdata.ID,
                                     PageNumber = markdata.PAGENUMBER,
                                 };
                                 _result.MarkupList.Add(markitem);
+                            }
                             _result.PageCount = _result.MarkupList.GroupBy(i => i.PageNumber).Count();
                             markupinfo.Add(_result);
+                        }
+                    }
+                }
                 catch (Exception)
+                {
                     return null;
+                }
                 return markupinfo;
+            }
+        }
+    }

         <compilation debug="true" targetFramework="4.0"/>
         <pages controlRenderingCompatibilityVersion="4.0"/>
       </system.web>
       <system.serviceModel>
         <!--<behaviors>
           <serviceBehaviors>
             <behavior name="">
               <serviceMetadata httpGetEnabled="true"/>
               <serviceDebug includeExceptionDetailInFaults="false"/>
             </behavior>
           </serviceBehaviors>
         </behaviors>-->
       <system.serviceModel>
         <behaviors>
           <serviceBehaviors>
             <behavior name="KCOM_API.SilverlightServiceBehavior">
               <serviceMetadata httpGetEnabled="true" />
               <serviceDebug includeExceptionDetailInFaults="false" />
               <!--Jaedoo 최소용량때문에 추가한거임-->
               <dataContractSerializer maxItemsInObjectGraph="6553600"/>
               <dataContractSerializer maxItemsInObjectGraph="2147483647"/>
             </behavior>
           </serviceBehaviors>
         </behaviors>
         <serviceHostingEnvironment multipleSiteBindingsEnabled="true"/>
         <bindings>
           <basicHttpBinding>
             <binding name="LargeBuffer" receiveTimeout="00:30:00" openTimeout="00:30:00" sendTimeout="00:30:00"
             <binding name="LargeBuffer" receiveTimeout="04:30:00" openTimeout="00:30:00" sendTimeout="04:30:00"
                            closeTimeout="00:30:00"
                           maxBufferSize="2147483647" maxReceivedMessageSize="2147483647">
               <readerQuotas maxDepth="2147483647" maxStringContentLength="2147483647" maxArrayLength="2147483647"

내보내기 Unified diff

프로젝트

일반

사용자정보

MARKUS

개정판 2ab012e8

프로젝트

일반

사용자정보

MARKUS

개정판 2ab012e8

연결된 일감