/KCOM_API/ServiceDeepView.svc.cs - Diff - MARKUS - 일정관리

개정판 ff01c725

ID	ff01c72555c4ddbb07e4d451cdd16b109d6bb957
상위	4eb4f3f9
하위	36595d5a

백흠경이(가) 5년 이상 전에 추가함

issue #1187: 설치 파일 for SNI

Change-Id: If9472fac917642303f5a53438a6e8d0c19e82db2

KCOM_API/ServiceDeepView.svc.cs
6	6	using System;
7	7	using System.Collections.Generic;
8	8	using System.Collections.ObjectModel;
	9	using System.Configuration;
9	10	using System.Linq;
10	11	using System.Net;
11	12	using System.Runtime.Remoting.Channels.Tcp;
...	...
13	14	using System.ServiceModel;
14	15	using System.ServiceModel.Activation;
15	16	using System.Text;
	17	using System.Web.Services;
16	18	using System.Windows;
17	19	using System.Xml;
18	20
...	...
41	43
42	44	//DB에서 version 정보와 다운로드 url 을 Select
43	45	PROPERTIES dbvalue = null;
44		using (KCOMEntities uc = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	46	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	47	using (KCOMEntities uc = new KCOMEntities(sConnString))
45	48	{
46	49	string wherestr = string.Empty;
47	50	if (is64BitProcess)
...	...
69	72	}
70	73	return url;
71	74	}
72
	75
73	76
74	77	[OperationContract]
75	78	public KCOM_SystemInfo GetSystemData()
76	79	{
77	80	try
78	81	{
79		using (KCOMEntities uc = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	82	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	83	using (KCOMEntities uc = new KCOMEntities(sConnString))
80	84	{
81	85	var SystemInfoSet = uc.PROPERTIES.Where(data => data.TYPE == "SystemInfo").ToList();
82	86
...	...
129	133	[OperationContract]
130	134	public List<FAVORITE_DOC> GetFavoriteVP(string PrjNo, string userID, string sharepointItemID)
131	135	{
132		using (KCOMEntities dc = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	136	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	137	using (KCOMEntities dc = new KCOMEntities(sConnString))
133	138	{
134	139
135	140	int flagString = Convert.ToInt32(FAVORITE_FLAG.Personal);
...	...
149	154	[OperationContract]
150	155	public bool EditFavoriteVP(string prjNo, string userID, string docID, int state, string description)
151	156	{
152		using (KCOMEntities dc = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	157	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	158	using (KCOMEntities dc = new KCOMEntities(sConnString))
153	159	{
154	160	//List<FAVORITE_DOC> favoriteSet = dc.FAVORITE_DOC.Where(data => data.PROJECT_NO == prjNo && data.MEMBER_USER_ID == userID
155	161	// && data.PAGE_NO == SavePageNo && data.CREATE_TIME == createTime).ToList();
...	...
184	190	[OperationContract]
185	191	public bool DelFavoriteVP(string prjNo, string userID, int SavePageNo, string docID)
186	192	{
187
188		using (KCOMEntities dc = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	193	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	194	using (KCOMEntities dc = new KCOMEntities(sConnString))
189	195	{
190	196
191	197	List<FAVORITE_DOC> favoriteSet = dc.FAVORITE_DOC.Where(data => data.PROJECT_NO == prjNo && data.MEMBER_USER_ID == userID
...	...
263	269	int _DocTotalPages = -1;
264	270	string docItemId;
265	271
266
267		using (CIEntities _ci = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(ProjectNo).ToString()))
	272	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	273	using (CIEntities _ci = new CIEntities(sCIConnString))
268	274	{
269	275	var _doc = _ci.DOCINFO.Where(info => info.ID == DocInfoID);
270	276
...	...
294	300	CREATE_DATETIME = DateTime.Now,
295	301	STATUS = (int)IFinalPDF.FinalStatus.Insert
296	302	};
297		using (KCOMEntities _entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	303
	304	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	305	using (KCOMEntities _entity = new KCOMEntities(sConnString))
298	306	{
299	307	_entity.AddToFINAL_PDF(fm);
300	308	_entity.SaveChanges(System.Data.Objects.SaveOptions.AcceptAllChangesAfterSave);
...	...
308	316	System.Runtime.Remoting.Channels.ChannelServices.RegisterChannel(chan, false);
309	317	// Create an instance of the remote object
310	318
311
312		using (KCOMEntities ec = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	319	using (KCOMEntities ec = new KCOMEntities(sConnString))
313	320	{
314	321
315	322	//remObj = (RemFinalPDFObject)Activator.GetObject(typeof(RemFinalPDFObject),
...	...
358	365	[OperationContract]
359	366	public bool GetConversionState(KCOM_BasicParam param)
360	367	{
361		using (CIEntities entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(param.projectNo).ToString()))
	368	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	369	using (CIEntities entity = new CIEntities(sCIConnString))
362	370	{
363	371	var doc = entity.DOCINFO.Where(data => data.DOCUMENT_ID == param.documentID).FirstOrDefault();
364	372	if (doc != null)
...	...
370	378	}
371	379	else //페이지 수가 일치하지 않는 경우
372	380	{
373		KCOMEntities entity_kcom = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString());
	381	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	382	KCOMEntities entity_kcom = new KCOMEntities(sConnString);
374	383	var lst = entity_kcom.CONVERTER_DOC.Where(data => data.PROJECT_NO == param.projectNo && data.DOCUMENT_ID == param.documentID && data.TOTAL_PAGE != doc.PAGE_COUNT).ToList();
375	384
376	385	if (lst != null \|\| lst.Count >= 1)
...	...
396	405	List<VPRevision> _result = new List<VPRevision>();
397	406	try
398	407	{
399		using (CIEntities entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(ProjectNo).ToString()))
	408	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	409	using (CIEntities entity = new CIEntities(sCIConnString))
400	410	{
401	411	var _vpList = (from docitem in entity.DOCUMENT_ITEM
402	412	where docitem.DOCUMENT_NO == vpNo
...	...
420	430	else
421	431	vp.IsSyncPossible = false;
422	432	}
423		_result = _result.OrderByDescending(r => UInt64.Parse(System.Text.RegularExpressions.Regex.Replace(r.GroupNo, @"\D", ""))).ToList();
	433
	434	//_result = _result.OrderByDescending(r => UInt64.Parse(System.Text.RegularExpressions.Regex.Replace(r.GroupNo, @"\D", ""))).ToList();
	435	_result = _result.OrderByDescending(r => r.GroupNo).ToList();
424	436	}
425	437	}
426		catch (Exception)
	438	catch (Exception ex)
427	439	{
428	440
429		throw;
	441	throw ex;
430	442	}
431	443	finally
432	444	{
...	...
441	453	VPRevision _result = null;
442	454	try
443	455	{
444		using (CIEntities entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(ProjectNo).ToString()))
	456	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	457	using (CIEntities entity = new CIEntities(sCIConnString))
445	458	{
446	459	_result = (from docitem in entity.DOCUMENT_ITEM
447	460	where docitem.DOCUMENT_ID == DocumentId
...	...
475	488	{
476	489	// 차후 아래의 코드로 변경
477	490	//using (CI_Entities ModelDeeview = new CI_Entities(DaelimCiConnectionString.ToString()))
478		CIEntities ModelDeeview = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(param.projectNo).ToString());
	491	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	492	CIEntities ModelDeeview = new CIEntities(sCIConnString);
479	493
480	494	var docinfo = ModelDeeview.DOCINFO.Where(doc => doc.DOCUMENT_ID == param.documentID && doc.PROJECT_NO == param.projectNo);
481	495	if (docinfo.Count() > 0)
...	...
501	515	[OperationContract]
502	516	public bool GetCheckSystemAdmin(string UserID)
503	517	{
504		using (KCOMEntities uc = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	518	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	519	using (KCOMEntities uc = new KCOMEntities(sConnString))
505	520	{
506	521	var user = uc.PROPERTIES.Where(data => data.TYPE == "Administrator" && data.PROPERTY.Contains(UserID)).FirstOrDefault();
507	522	if (user != null)
...	...
524	539
525	540	try
526	541	{
527		CIEntities entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(param.projectNo).ToString());
	542	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	543	CIEntities entity = new CIEntities(sCIConnString);
528	544
529	545	var _items = entity.DOCUMENT_ITEM.Where(data => data.DOCUMENT_ID == param.documentID);
530	546
...	...
542	558	catch (Exception ex)
543	559	{
544	560	System.Diagnostics.Trace.WriteLine("GetVendorItemInfo Error : " + ex);
	561	_result = new DOCUMENT_ITEM { RESULT_FILE = ex.ToString() };
	562	//throw new FaultException(ex.ToString());
545	563	//Common.Helper.SystemErrorNotify(SERVICE_NAME.API, LEVEL.MEDIUM, ERROR_TYPE.CONVERT, "GetDocumentItemInfo / " + ex.Message, param.documentID, param.projectNo);
546	564	}
547	565
...	...
560	578
561	579	try
562	580	{
563		CIEntities entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString("markus").ToString());
	581	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	582	CIEntities entity = new CIEntities(sCIConnString);
564	583
565	584	var _items = entity.DOCUMENT_ITEM.Where(data => data.ID == ensemble_id).FirstOrDefault();
566	585	if(_items != null)
...	...
589	608	List<MarkupInfoItem> _result = new List<MarkupInfoItem>();
590	609	try
591	610	{
592		using (CIEntities entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(ProjectNo).ToString()))
	611	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	612	using (CIEntities entity = new CIEntities(sCIConnString))
593	613	{
594	614	var markupListData = entity.MARKUP_INFO.Where(data => data.DOCINFO_ID == DocInfoId).ToList();
595	615
...	...
624	644
625	645	List<PROPERTIES> _ColorsProperties = new List<PROPERTIES>();
626	646	Random random = new Random();
627
628		using (KCOMEntities kcomEntity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	647
	648	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	649	using (KCOMEntities kcomEntity = new KCOMEntities(sConnString))
629	650	{
630	651	_ColorsProperties = (from property in kcomEntity.PROPERTIES
631	652	where property.TYPE == "DisplayColor"
...	...
944	965	List<MarkupInfoItem> _result = new List<MarkupInfoItem>();
945	966	try
946	967	{
947		using (CIEntities entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(ProjectNo).ToString()))
	968	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	969	using (CIEntities entity = new CIEntities(sCIConnString))
948	970	{
949	971	var docItem = entity.DOCINFO.Where(data => data.DOCUMENT_ID == DocInfoId).FirstOrDefault();
950	972	if (docItem == null)
...	...
989	1011	List<PROPERTIES> _ColorsProperties = new List<PROPERTIES>();
990	1012	Random random = new Random();
991	1013
992		using (KCOMEntities kcomEntity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	1014	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	1015	using (KCOMEntities kcomEntity = new KCOMEntities(sConnString))
993	1016	{
994	1017	_ColorsProperties = (from property in kcomEntity.PROPERTIES
995	1018	where property.TYPE == "DisplayColor"
...	...
1061	1084	{
1062	1085	List<MEMBER> _result = new List<MEMBER>();
1063	1086
1064		using (CIEntities entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(ProjectNo).ToString()))
	1087	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1088	using (CIEntities entity = new CIEntities(sCIConnString))
1065	1089	{
1066	1090	var _UserList = from member in entity.MEMBER
1067	1091	where member.ID == UserID
...	...
1080	1104
1081	1105	try
1082	1106	{
1083		KCOMEntities entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString());
	1107	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	1108	KCOMEntities entity = new KCOMEntities(sConnString);
1084	1109	var YourEnginner = (from dept in entity.PROPERTIES
1085	1110	where dept.TYPE == "DeptName" && UserDept.Contains(dept.VALUE)
1086	1111	select dept).FirstOrDefault();
...	...
1114	1139	bool _result = false;
1115	1140	try
1116	1141	{
1117		using (KCOMDataModel.DataModel.CIEntities Entity = new KCOMDataModel.DataModel.CIEntities(KCOMDataModel.Common.ConnectStringBuilder.ProjectCIConnectString(ProjectNo).ToString()))
	1142	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1143	using (KCOMDataModel.DataModel.CIEntities Entity = new KCOMDataModel.DataModel.CIEntities(sCIConnString))
1118	1144	{
1119	1145
1120	1146	MARKUP_INFO instance = Entity.MARKUP_INFO.Where(root => root.ID == MarkupInfoID).FirstOrDefault();
...	...
1156	1182	[OperationContract]
1157	1183	public bool SetFavoriteVP(string prjNo, string userID, string groupNo, string docNo, string rev, int SavePageNo, string documentItemID, string VPDescription, IKCOM.FAVORITE_FLAG flag)
1158	1184	{
1159
1160		using (KCOMEntities entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	1185	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	1186	using (KCOMEntities entity = new KCOMEntities(sConnString))
1161	1187	{
1162	1188	try
1163	1189	{
...	...
1270	1296	[OperationContract]
1271	1297	public bool SaveMarkupData(MarkupInfoItem UserState,string project_no,string doc_id, string user_id, List<MARKUP_DATA> mlmarkup_data)
1272	1298	{
1273		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	1299	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1300	using (CIEntities Entity = new CIEntities(sCIConnString))
1274	1301	{
1275	1302	#region Docinfo 정보 가져오기
1276	1303
...	...
1425	1452	{
1426	1453	try
1427	1454	{
1428		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(ProjectNo).ToString()))
	1455	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1456	using (CIEntities Entity = new CIEntities(sCIConnString))
1429	1457	{
1430	1458	var UpdateItem = Entity.MARKUP_DATA.Where(info => info.ID == CommentID).FirstOrDefault();
1431	1459	//UpdateItem.GROUP_ID = Group_ID;
...	...
1444	1472	{
1445	1473	try
1446	1474	{
1447		using (KCOMDataModel.DataModel.KCOMEntities uc = new KCOMDataModel.DataModel.KCOMEntities(KCOMDataModel.Common.ConnectStringBuilder.KCOMConnectionString().ToString()))
	1475	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	1476	using (KCOMDataModel.DataModel.KCOMEntities uc = new KCOMDataModel.DataModel.KCOMEntities(sConnString))
1448	1477	{
1449	1478	uc.AddToSYMBOL_PRIVATE(symbol_private);
1450	1479	uc.SaveChanges();
...	...
1461	1490	{
1462	1491	try
1463	1492	{
1464		using (KCOMDataModel.DataModel.KCOMEntities uc = new KCOMDataModel.DataModel.KCOMEntities(KCOMDataModel.Common.ConnectStringBuilder.KCOMConnectionString().ToString()))
	1493	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	1494	using (KCOMDataModel.DataModel.KCOMEntities uc = new KCOMDataModel.DataModel.KCOMEntities(sConnString))
1465	1495	{
1466	1496	uc.AddToSYMBOL_PUBLIC(symbol);
1467	1497	uc.SaveChanges();
...	...
1478	1508	{
1479	1509	try
1480	1510	{
1481		using (KCOMEntities Entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	1511	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	1512	using (KCOMEntities Entity = new KCOMEntities(sConnString))
1482	1513	{
1483	1514	if (type == 0)
1484	1515	{
...	...
1508	1539	{
1509	1540	try
1510	1541	{
1511		using (KCOMEntities Entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	1542	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	1543	using (KCOMEntities Entity = new KCOMEntities(sConnString))
1512	1544	{
1513	1545	if (type == 0)
1514	1546	{
...	...
1535	1567	public bool AddCheckListHistory(string project_no, CHECK_LIST_HISTORY Check_History)
1536	1568	{
1537	1569	try
1538		{
1539		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	1570	{
	1571	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1572	using (CIEntities Entity = new CIEntities(sCIConnString))
1540	1573	{
1541	1574	Entity.CHECK_LIST_HISTORY.AddObject(Check_History);
1542	1575	Entity.SaveChanges();
...	...
1553	1586	{
1554	1587	try
1555	1588	{
1556		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	1589	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1590	using (CIEntities Entity = new CIEntities(sCIConnString))
1557	1591	{
1558	1592	var item = Entity.CHECK_LIST_HISTORY.Where(info => info.REVISION == rev).FirstOrDefault();
1559	1593	item = Check_History;
...	...
1571	1605	{
1572	1606	try
1573	1607	{
1574		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	1608	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1609	using (CIEntities Entity = new CIEntities(sCIConnString))
1575	1610	{
1576	1611	var item = Entity.CHECK_LIST.Where(info => info.ID == _id).FirstOrDefault();
1577	1612	item.TODOLIST = Check_value.TODOLIST;
...	...
1604	1639	{
1605	1640	try
1606	1641	{
1607		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	1642	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1643	using (CIEntities Entity = new CIEntities(sCIConnString))
1608	1644	{
1609	1645	Entity.CHECK_LIST.AddObject(Check_value);
1610	1646	Entity.SaveChanges();
...	...
1623	1659	CHECK_LIST Check_value = new CHECK_LIST();
1624	1660	try
1625	1661	{
1626		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	1662	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1663	using (CIEntities Entity = new CIEntities(sCIConnString))
1627	1664	{
1628	1665	Check_value = Entity.CHECK_LIST.Where(info => info.ID == _id).FirstOrDefault();
1629	1666	}
...	...
1640	1677	List<CHECK_LIST> list = new List<CHECK_LIST>();
1641	1678	try
1642	1679	{
1643		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	1680	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1681	using (CIEntities Entity = new CIEntities(sCIConnString))
1644	1682	{
1645	1683	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();
1646	1684	}
...	...
1657	1695	List<CHECK_LIST_HISTORY> history = new List<CHECK_LIST_HISTORY>();
1658	1696	try
1659	1697	{
1660		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	1698	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1699	using (CIEntities Entity = new CIEntities(sCIConnString))
1661	1700	{
1662	1701	history = Entity.CHECK_LIST_HISTORY.Where(data => data.CHECKLIST_ID == _id).ToList();
1663	1702	}
...	...
1674	1713	CHECK_LIST_HISTORY Check_Item = new CHECK_LIST_HISTORY();
1675	1714	try
1676	1715	{
1677		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	1716	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1717	using (CIEntities Entity = new CIEntities(sCIConnString))
1678	1718	{
1679	1719	Check_Item = Entity.CHECK_LIST_HISTORY.Where(info => info.CHECKLIST_ID == checklist_id && info.REVISION == rev).FirstOrDefault();
1680	1720	}
...	...
1690	1730	{
1691	1731	try
1692	1732	{
1693		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	1733	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1734	using (CIEntities Entity = new CIEntities(sCIConnString))
1694	1735	{
1695	1736	KCOMDataModel.DataModel.DOCPAGE _docpage = new KCOMDataModel.DataModel.DOCPAGE();
1696	1737	_mldocpage.ForEach(data =>
...	...
1722	1763
1723	1764	try
1724	1765	{
1725		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	1766	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1767	using (CIEntities Entity = new CIEntities(sCIConnString))
1726	1768	{
1727	1769	markupInfo = Entity.MARKUP_INFO.Where(entity => entity.DOCINFO_ID == _id).OrderByDescending(i => i.CONSOLIDATE).OrderByDescending(j => j.CREATE_TIME).FirstOrDefault();
1728	1770	}
...	...
1741	1783	MARKUP_INFO_VERSION markup_info_version = new MARKUP_INFO_VERSION();
1742	1784	try
1743	1785	{
1744		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	1786	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1787	using (CIEntities Entity = new CIEntities(sCIConnString))
1745	1788	{
1746	1789	markup_info_version = (from version in Entity.MARKUP_INFO_VERSION
1747	1790	where version.MARKUPINFO_ID == _markupinfoid
...	...
1764	1807	{
1765	1808	try
1766	1809	{
1767		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	1810	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1811	using (CIEntities Entity = new CIEntities(sCIConnString))
1768	1812	{
1769	1813	Entity.MARKUP_INFO.AddObject(value);
1770	1814	Entity.SaveChanges();
...	...
1782	1826	{
1783	1827	try
1784	1828	{
1785		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	1829	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1830	using (CIEntities Entity = new CIEntities(sCIConnString))
1786	1831	{
1787	1832	Entity.MARKUP_INFO_VERSION.AddObject(value);
1788	1833	Entity.SaveChanges();
...	...
1800	1845	{
1801	1846	try
1802	1847	{
1803		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	1848	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1849	using (CIEntities Entity = new CIEntities(sCIConnString))
1804	1850	{
1805	1851	Entity.MARKUP_DATA.AddObject(value);
1806	1852	Entity.SaveChanges();
...	...
1818	1864	{
1819	1865	try
1820	1866	{
1821		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	1867	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1868	using (CIEntities Entity = new CIEntities(sCIConnString))
1822	1869	{
1823	1870	var item = Entity.MARKUP_INFO.Where(entity => entity.DOCINFO_ID == _doc_id).OrderByDescending(i => i.CONSOLIDATE).OrderByDescending(j => j.CREATE_TIME).FirstOrDefault();
1824	1871	item.AVOID_CONSOLIDATE = 1;
...	...
1837	1884	{
1838	1885	try
1839	1886	{
1840		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	1887	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1888	using (CIEntities Entity = new CIEntities(sCIConnString))
1841	1889	{
1842	1890	var item = Entity.MARKUP_INFO.Where(info => info.ID == _id).FirstOrDefault();
1843	1891	item = value;
...	...
1857	1905
1858	1906	try
1859	1907	{
1860		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	1908	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1909	using (CIEntities Entity = new CIEntities(sCIConnString))
1861	1910	{
1862	1911	mlresult = Entity.MARKUP_DATA.Where(data => data.MARKUPINFO_VERSION_ID == _versionid).ToList();
1863	1912	}
...	...
1875	1924	try
1876	1925	{
1877	1926	List<KCOMDataModel.DataModel.MARKUP_DATA> instanceDataSet = new List<KCOMDataModel.DataModel.MARKUP_DATA>();
1878		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	1927	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1928	using (CIEntities Entity = new CIEntities(sCIConnString))
1879	1929	{
1880	1930	var markupInfo = Entity.MARKUP_INFO.Where(entity => entity.DOCINFO_ID == _doc_id && entity.CONSOLIDATE == 1).OrderByDescending(j => j.CREATE_TIME).FirstOrDefault();
1881	1931	if (markupInfo != null)
...	...
1945	1995	try
1946	1996	{
1947	1997	List<KCOMDataModel.DataModel.MARKUP_DATA> instanceDataSet = new List<KCOMDataModel.DataModel.MARKUP_DATA>();
1948		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	1998	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	1999	using (CIEntities Entity = new CIEntities(sCIConnString))
1949	2000	{
1950	2001	var markupInfo = Entity.MARKUP_INFO.Where(entity => entity.DOCINFO_ID == _doc_id).OrderByDescending(i => i.CONSOLIDATE).OrderByDescending(j => j.CREATE_TIME).FirstOrDefault();
1951	2002	if (markupInfo.CONSOLIDATE == 1)
...	...
2015	2066	int _DocTotalPages = -1;
2016	2067	string docItemId;
2017	2068
2018
2019		using (CIEntities _ci = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(ProjectNo).ToString()))
	2069	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	2070	using (CIEntities _ci = new CIEntities(sCIConnString))
2020	2071	{
2021	2072	var _doc = _ci.DOCINFO.Where(info => info.ID == DocInfoID);
2022	2073
...	...
2049	2100	CREATE_DATETIME = DateTime.Now,
2050	2101	STATUS = (int)IFinalPDF.FinalStatus.Insert
2051	2102	};
2052		using (KCOMEntities _entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	2103
	2104	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	2105	using (KCOMEntities _entity = new KCOMEntities(sConnString))
2053	2106	{
2054	2107	_entity.AddToFINAL_PDF(fm);
2055	2108	_entity.SaveChanges(System.Data.Objects.SaveOptions.AcceptAllChangesAfterSave);
...	...
2063	2116	System.Runtime.Remoting.Channels.ChannelServices.RegisterChannel(chan, false);
2064	2117	// Create an instance of the remote object
2065	2118
2066
2067		using (KCOMEntities ec = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	2119	using (KCOMEntities ec = new KCOMEntities(sConnString))
2068	2120	{
2069	2121
2070	2122	//remObj = (RemFinalPDFObject)Activator.GetObject(typeof(RemFinalPDFObject),
...	...
2113	2165	try
2114	2166	{
2115	2167	List<KCOMDataModel.DataModel.MARKUP_DATA> instanceDataSet = new List<KCOMDataModel.DataModel.MARKUP_DATA>();
2116		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	2168	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	2169	using (CIEntities Entity = new CIEntities(sCIConnString))
2117	2170	{
2118	2171	string user_dept = Entity.MEMBER.Where(m => m.ID == _user_id).FirstOrDefault().DEPARTMENT;
2119	2172	var markupInfos = Entity.MARKUP_INFO.Where(entity => entity.DOCINFO_ID == _doc_id
...	...
2189	2242	MEMBER rstmember = new MEMBER();
2190	2243	try
2191	2244	{
2192		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	2245	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	2246	using (CIEntities Entity = new CIEntities(sCIConnString))
2193	2247	{
2194	2248	var tmp = (from member in Entity.MEMBER
2195	2249	where member.ID == user_id && member.PROJECT_NO == project_no
...	...
2199	2253	rstmember.NAME = tmp.NAME;
2200	2254	}
2201	2255	}
2202		catch (Exception)
	2256	catch (Exception ex)
2203	2257	{
2204	2258	return null;
2205	2259	}
2206	2260	return rstmember;
2207	2261	}
2208	2262
	2263	[WebMethod]
2209	2264	[OperationContract]
2210	2265	public List<SYMBOL_PRIVATE> GetSymbolList(string user_id)
2211	2266	{
2212	2267	List<SYMBOL_PRIVATE> Custom_List = new List<SYMBOL_PRIVATE>();
2213	2268	try
2214	2269	{
2215		using (KCOMEntities Entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	2270	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	2271	using (KCOMEntities Entity = new KCOMEntities(sConnString))
2216	2272	{
2217	2273	Custom_List = Entity.SYMBOL_PRIVATE.Where(data => data.MEMBER_USER_ID == user_id).ToList();
2218	2274	}
2219	2275	}
2220		catch (Exception)
	2276	catch (Exception ex)
2221	2277	{
2222	2278	return null;
2223	2279	}
...	...
2229	2285	List<string> Custom_List = new List<string>();
2230	2286	try
2231	2287	{
2232		using (KCOMEntities Entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	2288	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	2289	using (KCOMEntities Entity = new KCOMEntities(sConnString))
2233	2290	{
2234	2291	Custom_List = Entity.SYMBOL_PUBLIC.Select(data => data.DEPARTMENT).Distinct().ToList();
2235	2292	}
...	...
2246	2303	List<SYMBOL_PUBLIC> Custom_List = new List<SYMBOL_PUBLIC>();
2247	2304	try
2248	2305	{
2249		using (KCOMEntities Entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	2306	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	2307	using (KCOMEntities Entity = new KCOMEntities(sConnString))
2250	2308	{
2251	2309	if(!string.IsNullOrEmpty(dept))
2252	2310	{
...	...
2278	2336	string result;
2279	2337	try
2280	2338	{
2281		using (KCOMEntities Entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	2339	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	2340	using (KCOMEntities Entity = new KCOMEntities(sConnString))
2282	2341	{
2283	2342	if(type == 0)
2284	2343	{
...	...
2302	2361	string result;
2303	2362	try
2304	2363	{
2305		using (KCOMEntities Entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	2364	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	2365	using (KCOMEntities Entity = new KCOMEntities(sConnString))
2306	2366	{
2307	2367	if (type == 0)
2308	2368	{
...	...
2329	2389	string ifsign = getEnsembleSign(user_id);
2330	2390	if (string.IsNullOrEmpty(ifsign))
2331	2391	{
2332		var ModelWFConnectionString = ConnectStringBuilder.ProjectCIConnectString(project_no).ToString();
	2392	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	2393	var ModelWFConnectionString = sCIConnString;
2333	2394	if (null != ModelWFConnectionString)
2334	2395	{
2335	2396	using (CIEntities entity = new CIEntities(ModelWFConnectionString))
...	...
2366	2427
2367	2428	try
2368	2429	{
2369		using (KCOMDataModel.DataModel.KCOMEntities Entity = new KCOMDataModel.DataModel.KCOMEntities(KCOMDataModel.Common.ConnectStringBuilder.KCOMConnectionString().ToString()))
	2430	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	2431	using (KCOMDataModel.DataModel.KCOMEntities Entity = new KCOMDataModel.DataModel.KCOMEntities(sConnString))
2370	2432	{
2371	2433	result = Entity.RUN_PROJECTS.Where(i => i.PROJECT_NO == project_no).FirstOrDefault().PROJECT_NAME.ToString();
2372	2434	}
...	...
2385	2447
2386	2448	try
2387	2449	{
2388		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	2450	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	2451	using (CIEntities Entity = new CIEntities(sCIConnString))
2389	2452	{
2390	2453	result = Entity.DOCUMENT_ITEM.Where(i => i.PROJECT_NO == project_no
2391	2454	&& i.DOCUMENT_NO == doc_no
...	...
2406	2469
2407	2470	try
2408	2471	{
2409		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	2472	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	2473	using (CIEntities Entity = new CIEntities(sCIConnString))
2410	2474	{
2411	2475	docinfo = (from info in Entity.DOCINFO
2412	2476	where info.DOCUMENT_ID == doc_id
...	...
2428	2492	List<MarkupInfoItem> markupinfo = new List<MarkupInfoItem>();
2429	2493	try
2430	2494	{
2431		using (CIEntities Entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	2495	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	2496	using (CIEntities Entity = new CIEntities(sCIConnString))
2432	2497	{
2433	2498	var docitem = (from info in Entity.DOCINFO
2434	2499	where info.DOCUMENT_ID == doc_id
...	...
2492	2557	{
2493	2558	try
2494	2559	{
2495		using (CIEntities entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	2560	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	2561	using (CIEntities entity = new CIEntities(sCIConnString))
2496	2562	{
2497	2563	entity.TALK.AddObject(value);
2498	2564	entity.SaveChanges();
...	...
2511	2577	List<TALK> result = new List<TALK>();
2512	2578	try
2513	2579	{
2514		using (CIEntities entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	2580	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	2581	using (CIEntities entity = new CIEntities(sCIConnString))
2515	2582	{
2516	2583	result = entity.TALK.Where(data => data.DOCUMENT_ID == doc_id).ToList();
2517	2584	}
2518	2585	}
2519		catch (Exception)
	2586	catch (Exception ex)
2520	2587	{
2521	2588	return result;
2522	2589	}
...	...
2536	2603	string soapurl = string.Empty;
2537	2604	try
2538	2605	{
2539		using (KCOMEntities Entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	2606	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	2607	using (KCOMEntities Entity = new KCOMEntities(sConnString))
2540	2608	{
2541	2609	var item = Entity.PROPERTIES.Where(d => d.TYPE == "UpLoadServiceUrl").FirstOrDefault();
2542	2610	soapurl = item.VALUE;
...	...
2582	2650
2583	2651	try
2584	2652	{
2585		using (CIEntities _entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	2653	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	2654	using (CIEntities _entity = new CIEntities(sCIConnString))
2586	2655	{
2587	2656	var doc = _entity.DOCINFO.Where(x => x.ID == docinfo_id).FirstOrDefault();
2588	2657	if(doc != null)
...	...
2612	2681
2613	2682	try
2614	2683	{
2615		using (CIEntities _entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	2684	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	2685	using (CIEntities _entity = new CIEntities(sCIConnString))
2616	2686	{
2617	2687	var doc = _entity.DOCUMENT_ITEM.Where(x => x.DOCUMENT_ID == document_id).FirstOrDefault();
2618	2688	if(doc != null)
...	...
2650	2720	try
2651	2721	{
2652	2722	//using (CIEntities _entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
2653		using (CIEntities _entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	2723	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	2724	using (CIEntities _entity = new CIEntities(sCIConnString))
2654	2725	{
2655	2726	var datas = _entity.MARKUP_DATA.Where(x => x.MARKUP_INFO_VERSION.MARKUP_INFO.DOCINFO_ID == docinfo_id
2656	2727	&& x.MARKUP_INFO_VERSION.MARKUP_INFO.CONSOLIDATE == 1
...	...
2686	2757
2687	2758	try
2688	2759	{
2689		using (CIEntities _entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	2760	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	2761	using (CIEntities _entity = new CIEntities(sCIConnString))
2690	2762	{
2691	2763	var tmp = _entity.MARKUP_INFO.Where(x => x.DOCINFO_ID == docinfo_id && x.CONSOLIDATE == 1 && x.AVOID_CONSOLIDATE == 0 && x.PART_CONSOLIDATE == 0).FirstOrDefault();
2692	2764	if (tmp != null)
...	...
2714	2786
2715	2787	try
2716	2788	{
2717		using (KCOMEntities _entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	2789	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	2790	using (KCOMEntities _entity = new KCOMEntities(sConnString))
2718	2791	{
2719	2792	var finalList = _entity.FINAL_PDF.Where(final => final.ID == final_id).ToList();
2720	2793	foreach(var final in finalList)
...	...
2753	2826
2754	2827	try
2755	2828	{
2756		using (CIEntities _entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	2829	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	2830	using (CIEntities _entity = new CIEntities(sCIConnString))
2757	2831	{
2758	2832	var pages = _entity.DOCPAGE.Where(x => x.DOCINFO_ID == docinfo_id).OrderBy(x => x.PAGE_NUMBER).ToList();
2759	2833	foreach(var page in pages)
...	...
2783	2857
2784	2858	try
2785	2859	{
2786		using (KCOMEntities _entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	2860	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	2861	using (KCOMEntities _entity = new KCOMEntities(sConnString))
2787	2862	{
2788	2863	var tmp = _entity.FINAL_PDF.Where(x => x.ID == final_id).FirstOrDefault();
2789	2864	if(tmp != null)
...	...
2825	2900
2826	2901	try
2827	2902	{
2828		using (KCOMEntities _entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	2903	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	2904	using (KCOMEntities _entity = new KCOMEntities(sConnString))
2829	2905	{
2830	2906	var finalpdf = _entity.FINAL_PDF.Where(x => x.DOCINFO_ID == DocInfoID && x.MARKUPINFO_ID == MarkupInfoID && x.CREATE_USER_ID == CreateUserID && x.STATUS != (int)FinalStatus.Error).FirstOrDefault();
2831	2907	if (finalpdf != null)
...	...
2853	2929
2854	2930	try
2855	2931	{
2856		using (KCOMEntities _entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	2932	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	2933	using (KCOMEntities _entity = new KCOMEntities(sConnString))
2857	2934	{
2858	2935	var tmp = _entity.FINAL_PDF.Where(x => x.ID == final_id).FirstOrDefault();
2859	2936	if (tmp != null)
...	...
2877	2954
2878	2955	try
2879	2956	{
2880		using (KCOMEntities _entity = new KCOMEntities(ConnectStringBuilder.KCOMConnectionString().ToString()))
	2957	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	2958	using (KCOMEntities _entity = new KCOMEntities(sConnString))
2881	2959	{
2882	2960	var tmp = _entity.FINAL_PDF.Where(x => x.ID == final_id).FirstOrDefault();
2883	2961	if (tmp != null)
...	...
2903	2981
2904	2982	try
2905	2983	{
2906		using (CIEntities _entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	2984	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	2985	using (CIEntities _entity = new CIEntities(sCIConnString))
2907	2986	{
2908	2987	var item = _entity.DOCUMENT_ITEM.Where(d => d.DOCUMENT_ID == document_id).FirstOrDefault();
2909	2988	if (item != null)
...	...
2927	3006	MEMBER member = null;
2928	3007	try
2929	3008	{
2930		using (CIEntities _entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(project_no).ToString()))
	3009	string sCIConnString = ConfigurationManager.ConnectionStrings["CIConnectionString"].ConnectionString;
	3010	using (CIEntities _entity = new CIEntities(sCIConnString))
2931	3011	{
2932	3012	var data = _entity.MARKUP_DATA.Where(x => x.ID == markupdata_id).FirstOrDefault();
2933	3013	string user_id = data.MARKUP_INFO_VERSION.MARKUP_INFO.USER_ID;
...	...
2957	3037	List<PROPERTIES> results = new List<PROPERTIES>();
2958	3038	try
2959	3039	{
2960		using (KCOMEntities _entity = new KCOMEntities(KCOMDataModel.Common.ConnectStringBuilder.KCOMConnectionString().ToString()))
	3040	string sConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
	3041	using (KCOMEntities _entity = new KCOMEntities(sConnString))
2961	3042	{
2962	3043	var _items = _entity.PROPERTIES.Where(x => x.PROPERTY == project_no).ToList();
2963	3044	foreach(var item in _items)

내보내기 Unified diff

프로젝트

일반

사용자정보

MARKUS

개정판 ff01c725

프로젝트

일반

사용자정보

MARKUS

개정판 ff01c725

연결된 일감