개정판 f9d986d9
issue #885 부서/사용자 색상 설정
IKCOM/Interface.cs | ||
---|---|---|
1 |
using MarkupToPDF.Controls.Common; |
|
1 |
using KCOMDataModel.DataModel; |
|
2 |
using MarkupToPDF.Controls.Common; |
|
2 | 3 |
using System; |
3 | 4 |
using System.Collections.Generic; |
4 | 5 |
using System.Linq; |
... | ... | |
102 | 103 |
public bool IsPreviewUser { get; set; } |
103 | 104 |
} |
104 | 105 |
|
106 |
public class _MemberDeptColors |
|
107 |
{ |
|
108 |
public List<MEMBER_DEPT_COLOR> _memberDeptColors { get; set; } |
|
109 |
} |
|
110 |
|
|
111 |
public class _MemberDeptColorsInfo |
|
112 |
{ |
|
113 |
public List<MEMBER_DEPT_COLORINFO> _memberDeptColorsInfo { get; set; } |
|
114 |
} |
|
115 |
|
|
105 | 116 |
public class MarkupItemEx : MarkupItem |
106 | 117 |
{ |
107 | 118 |
public string MarkupInfoID { get; set; } |
KCOMDataModel/DataModel/CIModel.Designer.cs | ||
---|---|---|
24 | 24 |
[assembly: EdmRelationshipAttribute("CIModel", "FK_MARKUPINFO_VERSIONMARKUPDATA", "MARKUP_INFO_VERSION", System.Data.Metadata.Edm.RelationshipMultiplicity.One, typeof(KCOMDataModel.DataModel.MARKUP_INFO_VERSION), "MARKUP_DATA", System.Data.Metadata.Edm.RelationshipMultiplicity.Many, typeof(KCOMDataModel.DataModel.MARKUP_DATA), true)] |
25 | 25 |
[assembly: EdmRelationshipAttribute("CIModel", "FK_MARKUPINFOMARKUPINFO_VERSION", "MARKUP_INFO", System.Data.Metadata.Edm.RelationshipMultiplicity.One, typeof(KCOMDataModel.DataModel.MARKUP_INFO), "MARKUP_INFO_VERSION", System.Data.Metadata.Edm.RelationshipMultiplicity.Many, typeof(KCOMDataModel.DataModel.MARKUP_INFO_VERSION), true)] |
26 | 26 |
[assembly: EdmRelationshipAttribute("CIModel", "FK_SIGNINFO_MEMBER", "MEMBER", System.Data.Metadata.Edm.RelationshipMultiplicity.One, typeof(KCOMDataModel.DataModel.MEMBER), "SIGN_INFO", System.Data.Metadata.Edm.RelationshipMultiplicity.Many, typeof(KCOMDataModel.DataModel.SIGN_INFO), true)] |
27 |
[assembly: EdmRelationshipAttribute("CIModel", "FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR", "MEMBER_DEPT_COLOR", System.Data.Metadata.Edm.RelationshipMultiplicity.One, typeof(KCOMDataModel.DataModel.MEMBER_DEPT_COLOR), "MEMBER_DEPT_COLORINFO", System.Data.Metadata.Edm.RelationshipMultiplicity.Many, typeof(KCOMDataModel.DataModel.MEMBER_DEPT_COLORINFO), true)] |
|
27 | 28 |
|
28 | 29 |
#endregion |
29 | 30 |
|
... | ... | |
266 | 267 |
} |
267 | 268 |
} |
268 | 269 |
private ObjectSet<CHECK_LIST_HISTORY> _CHECK_LIST_HISTORY; |
270 |
|
|
271 |
/// <summary> |
|
272 |
/// 사용 가능한 메타데이터 설명서가 없습니다. |
|
273 |
/// </summary> |
|
274 |
public ObjectSet<MEMBER_DEPT_COLOR> MEMBER_DEPT_COLOR |
|
275 |
{ |
|
276 |
get |
|
277 |
{ |
|
278 |
if ((_MEMBER_DEPT_COLOR == null)) |
|
279 |
{ |
|
280 |
_MEMBER_DEPT_COLOR = base.CreateObjectSet<MEMBER_DEPT_COLOR>("MEMBER_DEPT_COLOR"); |
|
281 |
} |
|
282 |
return _MEMBER_DEPT_COLOR; |
|
283 |
} |
|
284 |
} |
|
285 |
private ObjectSet<MEMBER_DEPT_COLOR> _MEMBER_DEPT_COLOR; |
|
286 |
|
|
287 |
/// <summary> |
|
288 |
/// 사용 가능한 메타데이터 설명서가 없습니다. |
|
289 |
/// </summary> |
|
290 |
public ObjectSet<MEMBER_DEPT_COLORINFO> MEMBER_DEPT_COLORINFO |
|
291 |
{ |
|
292 |
get |
|
293 |
{ |
|
294 |
if ((_MEMBER_DEPT_COLORINFO == null)) |
|
295 |
{ |
|
296 |
_MEMBER_DEPT_COLORINFO = base.CreateObjectSet<MEMBER_DEPT_COLORINFO>("MEMBER_DEPT_COLORINFO"); |
|
297 |
} |
|
298 |
return _MEMBER_DEPT_COLORINFO; |
|
299 |
} |
|
300 |
} |
|
301 |
private ObjectSet<MEMBER_DEPT_COLORINFO> _MEMBER_DEPT_COLORINFO; |
|
269 | 302 |
|
270 | 303 |
#endregion |
271 | 304 |
|
... | ... | |
366 | 399 |
{ |
367 | 400 |
base.AddObject("CHECK_LIST_HISTORY", cHECK_LIST_HISTORY); |
368 | 401 |
} |
402 |
|
|
403 |
/// <summary> |
|
404 |
/// MEMBER_DEPT_COLOR EntitySet에 새 개체를 추가하는 데 사용되지 않는 메서드입니다. 연결된 ObjectSet<T> 속성의 .Add 메서드를 대신 사용하십시오. |
|
405 |
/// </summary> |
|
406 |
public void AddToMEMBER_DEPT_COLOR(MEMBER_DEPT_COLOR mEMBER_DEPT_COLOR) |
|
407 |
{ |
|
408 |
base.AddObject("MEMBER_DEPT_COLOR", mEMBER_DEPT_COLOR); |
|
409 |
} |
|
410 |
|
|
411 |
/// <summary> |
|
412 |
/// MEMBER_DEPT_COLORINFO EntitySet에 새 개체를 추가하는 데 사용되지 않는 메서드입니다. 연결된 ObjectSet<T> 속성의 .Add 메서드를 대신 사용하십시오. |
|
413 |
/// </summary> |
|
414 |
public void AddToMEMBER_DEPT_COLORINFO(MEMBER_DEPT_COLORINFO mEMBER_DEPT_COLORINFO) |
|
415 |
{ |
|
416 |
base.AddObject("MEMBER_DEPT_COLORINFO", mEMBER_DEPT_COLORINFO); |
|
417 |
} |
|
369 | 418 |
|
370 | 419 |
#endregion |
371 | 420 |
|
... | ... | |
384 | 433 |
public partial class CHECK_LIST : EntityObject |
385 | 434 |
{ |
386 | 435 |
#region 팩터리 메서드 |
387 |
|
|
436 |
|
|
388 | 437 |
/// <summary> |
389 | 438 |
/// 새 CHECK_LIST 개체를 만듭니다. |
390 | 439 |
/// </summary> |
... | ... | |
397 | 446 |
/// <param name="sTATUS">STATUS 속성의 초기 값입니다.</param> |
398 | 447 |
/// <param name="pROJECT_NO">PROJECT_NO 속성의 초기 값입니다.</param> |
399 | 448 |
/// <param name="iMAGE_ANCHOR">IMAGE_ANCHOR 속성의 초기 값입니다.</param> |
400 |
/// <param name="sTATUS_DESC">sTATUS_DESC 속성의 초기 값입니다.</param> |
|
401 |
public static CHECK_LIST CreateCHECK_LIST(global::System.String id, global::System.String dOCUMENT_ID, global::System.String uSER_ID, global::System.String rEVISION, |
|
402 |
global::System.Int32 pAGENUMBER, global::System.String iMAGE_URL, global::System.String sTATUS, global::System.String pROJECT_NO, global::System.String iMAGE_ANCHOR |
|
403 |
, global::System.String sTATUS_DESC) |
|
449 |
public static CHECK_LIST CreateCHECK_LIST(global::System.String id, global::System.String dOCUMENT_ID, global::System.String uSER_ID, global::System.String rEVISION, global::System.Int32 pAGENUMBER, global::System.String iMAGE_URL, global::System.String sTATUS, global::System.String pROJECT_NO, global::System.String iMAGE_ANCHOR) |
|
404 | 450 |
{ |
405 | 451 |
CHECK_LIST cHECK_LIST = new CHECK_LIST(); |
406 | 452 |
cHECK_LIST.ID = id; |
... | ... | |
412 | 458 |
cHECK_LIST.STATUS = sTATUS; |
413 | 459 |
cHECK_LIST.PROJECT_NO = pROJECT_NO; |
414 | 460 |
cHECK_LIST.IMAGE_ANCHOR = iMAGE_ANCHOR; |
415 |
cHECK_LIST.STATUS = sTATUS_DESC; |
|
416 | 461 |
return cHECK_LIST; |
417 | 462 |
} |
418 | 463 |
|
... | ... | |
989 | 1034 |
public partial class CHECK_LIST_HISTORY : EntityObject |
990 | 1035 |
{ |
991 | 1036 |
#region 팩터리 메서드 |
992 |
|
|
1037 |
|
|
993 | 1038 |
/// <summary> |
994 | 1039 |
/// 새 CHECK_LIST_HISTORY 개체를 만듭니다. |
995 | 1040 |
/// </summary> |
... | ... | |
999 | 1044 |
/// <param name="sTATUS">STATUS 속성의 초기 값입니다.</param> |
1000 | 1045 |
/// <param name="cREATE_TIME">CREATE_TIME 속성의 초기 값입니다.</param> |
1001 | 1046 |
/// <param name="uPDATE_TIME">UPDATE_TIME 속성의 초기 값입니다.</param> |
1002 |
/// <param name="sTATUS_DESC">UPDATE_TIME 속성의 초기 값입니다.</param> |
|
1003 |
public static CHECK_LIST_HISTORY CreateCHECK_LIST_HISTORY(global::System.String id, global::System.String cHECKLIST_ID, global::System.String rEVISION, global::System.String sTATUS, |
|
1004 |
global::System.DateTime cREATE_TIME, global::System.DateTime uPDATE_TIME, global::System.String sTATUS_DESC) |
|
1047 |
public static CHECK_LIST_HISTORY CreateCHECK_LIST_HISTORY(global::System.String id, global::System.String cHECKLIST_ID, global::System.String rEVISION, global::System.String sTATUS, global::System.DateTime cREATE_TIME, global::System.DateTime uPDATE_TIME) |
|
1005 | 1048 |
{ |
1006 | 1049 |
CHECK_LIST_HISTORY cHECK_LIST_HISTORY = new CHECK_LIST_HISTORY(); |
1007 | 1050 |
cHECK_LIST_HISTORY.ID = id; |
1008 | 1051 |
cHECK_LIST_HISTORY.CHECKLIST_ID = cHECKLIST_ID; |
1009 | 1052 |
cHECK_LIST_HISTORY.REVISION = rEVISION; |
1010 | 1053 |
cHECK_LIST_HISTORY.STATUS = sTATUS; |
1011 |
cHECK_LIST_HISTORY.STATUS_DESC = sTATUS_DESC; |
|
1012 | 1054 |
cHECK_LIST_HISTORY.CREATE_TIME = cREATE_TIME; |
1013 | 1055 |
cHECK_LIST_HISTORY.UPDATE_TIME = uPDATE_TIME; |
1014 | 1056 |
return cHECK_LIST_HISTORY; |
... | ... | |
2031 | 2073 |
private global::System.String _PROJECT_NO; |
2032 | 2074 |
partial void OnPROJECT_NOChanging(global::System.String value); |
2033 | 2075 |
partial void OnPROJECT_NOChanged(); |
2076 |
|
|
2077 |
/// <summary> |
|
2078 |
/// 사용 가능한 메타데이터 설명서가 없습니다. |
|
2079 |
/// </summary> |
|
2080 |
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)] |
|
2081 |
[DataMemberAttribute()] |
|
2082 |
public global::System.String ENSEMBLEINFO_URL |
|
2083 |
{ |
|
2084 |
get |
|
2085 |
{ |
|
2086 |
return _ENSEMBLEINFO_URL; |
|
2087 |
} |
|
2088 |
set |
|
2089 |
{ |
|
2090 |
OnENSEMBLEINFO_URLChanging(value); |
|
2091 |
ReportPropertyChanging("ENSEMBLEINFO_URL"); |
|
2092 |
_ENSEMBLEINFO_URL = StructuralObject.SetValidValue(value, true); |
|
2093 |
ReportPropertyChanged("ENSEMBLEINFO_URL"); |
|
2094 |
OnENSEMBLEINFO_URLChanged(); |
|
2095 |
} |
|
2096 |
} |
|
2097 |
private global::System.String _ENSEMBLEINFO_URL; |
|
2098 |
partial void OnENSEMBLEINFO_URLChanging(global::System.String value); |
|
2099 |
partial void OnENSEMBLEINFO_URLChanged(); |
|
2034 | 2100 |
|
2035 | 2101 |
#endregion |
2036 | 2102 |
|
... | ... | |
2247 | 2313 |
public partial class MARKUP_DATA : EntityObject |
2248 | 2314 |
{ |
2249 | 2315 |
#region 팩터리 메서드 |
2250 |
|
|
2316 |
|
|
2251 | 2317 |
/// <summary> |
2252 | 2318 |
/// 새 MARKUP_DATA 개체를 만듭니다. |
2253 | 2319 |
/// </summary> |
... | ... | |
2256 | 2322 |
/// <param name="dATA">DATA 속성의 초기 값입니다.</param> |
2257 | 2323 |
/// <param name="mARKUPINFO_VERSION_ID">MARKUPINFO_VERSION_ID 속성의 초기 값입니다.</param> |
2258 | 2324 |
/// <param name="dATA_TYPE">DATA_TYPE 속성의 초기 값입니다.</param> |
2259 |
/// <param name="sYMBOL_ID">SYMBOL_ID 속성의 초기 값입니다.</param> |
|
2260 |
public static MARKUP_DATA CreateMARKUP_DATA(global::System.String id, global::System.Int32 pAGENUMBER, global::System.String dATA, global::System.String mARKUPINFO_VERSION_ID, global::System.Int32 dATA_TYPE, global::System.String sYMBOL_ID) |
|
2325 |
public static MARKUP_DATA CreateMARKUP_DATA(global::System.String id, global::System.Int32 pAGENUMBER, global::System.String dATA, global::System.String mARKUPINFO_VERSION_ID, global::System.Int32 dATA_TYPE) |
|
2261 | 2326 |
{ |
2262 | 2327 |
MARKUP_DATA mARKUP_DATA = new MARKUP_DATA(); |
2263 | 2328 |
mARKUP_DATA.ID = id; |
... | ... | |
2265 | 2330 |
mARKUP_DATA.DATA = dATA; |
2266 | 2331 |
mARKUP_DATA.MARKUPINFO_VERSION_ID = mARKUPINFO_VERSION_ID; |
2267 | 2332 |
mARKUP_DATA.DATA_TYPE = dATA_TYPE; |
2268 |
mARKUP_DATA.SYMBOL_ID = sYMBOL_ID; |
|
2269 | 2333 |
return mARKUP_DATA; |
2270 | 2334 |
} |
2271 | 2335 |
|
... | ... | |
2419 | 2483 |
private global::System.String _SYMBOL_ID; |
2420 | 2484 |
partial void OnSYMBOL_IDChanging(global::System.String value); |
2421 | 2485 |
partial void OnSYMBOL_IDChanged(); |
2486 |
|
|
2487 |
/// <summary> |
|
2488 |
/// 사용 가능한 메타데이터 설명서가 없습니다. |
|
2489 |
/// </summary> |
|
2490 |
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)] |
|
2491 |
[DataMemberAttribute()] |
|
2492 |
public Nullable<global::System.Int64> GROUP_ID |
|
2493 |
{ |
|
2494 |
get |
|
2495 |
{ |
|
2496 |
return _GROUP_ID; |
|
2497 |
} |
|
2498 |
set |
|
2499 |
{ |
|
2500 |
OnGROUP_IDChanging(value); |
|
2501 |
ReportPropertyChanging("GROUP_ID"); |
|
2502 |
_GROUP_ID = StructuralObject.SetValidValue(value); |
|
2503 |
ReportPropertyChanged("GROUP_ID"); |
|
2504 |
OnGROUP_IDChanged(); |
|
2505 |
} |
|
2506 |
} |
|
2507 |
private Nullable<global::System.Int64> _GROUP_ID; |
|
2508 |
partial void OnGROUP_IDChanging(Nullable<global::System.Int64> value); |
|
2509 |
partial void OnGROUP_IDChanged(); |
|
2422 | 2510 |
|
2423 | 2511 |
#endregion |
2424 | 2512 |
|
... | ... | |
3269 | 3357 |
/// <summary> |
3270 | 3358 |
/// 사용 가능한 메타데이터 설명서가 없습니다. |
3271 | 3359 |
/// </summary> |
3360 |
[EdmEntityTypeAttribute(NamespaceName="CIModel", Name="MEMBER_DEPT_COLOR")] |
|
3361 |
[Serializable()] |
|
3362 |
[DataContractAttribute(IsReference=true)] |
|
3363 |
public partial class MEMBER_DEPT_COLOR : EntityObject |
|
3364 |
{ |
|
3365 |
#region 팩터리 메서드 |
|
3366 |
|
|
3367 |
/// <summary> |
|
3368 |
/// 새 MEMBER_DEPT_COLOR 개체를 만듭니다. |
|
3369 |
/// </summary> |
|
3370 |
/// <param name="cOLORID">COLORID 속성의 초기 값입니다.</param> |
|
3371 |
/// <param name="dISPLAYCOLOR">DISPLAYCOLOR 속성의 초기 값입니다.</param> |
|
3372 |
public static MEMBER_DEPT_COLOR CreateMEMBER_DEPT_COLOR(global::System.Int32 cOLORID, global::System.String dISPLAYCOLOR) |
|
3373 |
{ |
|
3374 |
MEMBER_DEPT_COLOR mEMBER_DEPT_COLOR = new MEMBER_DEPT_COLOR(); |
|
3375 |
mEMBER_DEPT_COLOR.COLORID = cOLORID; |
|
3376 |
mEMBER_DEPT_COLOR.DISPLAYCOLOR = dISPLAYCOLOR; |
|
3377 |
return mEMBER_DEPT_COLOR; |
|
3378 |
} |
|
3379 |
|
|
3380 |
#endregion |
|
3381 |
|
|
3382 |
#region 기본 속성 |
|
3383 |
|
|
3384 |
/// <summary> |
|
3385 |
/// 사용 가능한 메타데이터 설명서가 없습니다. |
|
3386 |
/// </summary> |
|
3387 |
[EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)] |
|
3388 |
[DataMemberAttribute()] |
|
3389 |
public global::System.Int32 COLORID |
|
3390 |
{ |
|
3391 |
get |
|
3392 |
{ |
|
3393 |
return _COLORID; |
|
3394 |
} |
|
3395 |
set |
|
3396 |
{ |
|
3397 |
if (_COLORID != value) |
|
3398 |
{ |
|
3399 |
OnCOLORIDChanging(value); |
|
3400 |
ReportPropertyChanging("COLORID"); |
|
3401 |
_COLORID = StructuralObject.SetValidValue(value); |
|
3402 |
ReportPropertyChanged("COLORID"); |
|
3403 |
OnCOLORIDChanged(); |
|
3404 |
} |
|
3405 |
} |
|
3406 |
} |
|
3407 |
private global::System.Int32 _COLORID; |
|
3408 |
partial void OnCOLORIDChanging(global::System.Int32 value); |
|
3409 |
partial void OnCOLORIDChanged(); |
|
3410 |
|
|
3411 |
/// <summary> |
|
3412 |
/// 사용 가능한 메타데이터 설명서가 없습니다. |
|
3413 |
/// </summary> |
|
3414 |
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=true)] |
|
3415 |
[DataMemberAttribute()] |
|
3416 |
public global::System.String DEPARTMENT |
|
3417 |
{ |
|
3418 |
get |
|
3419 |
{ |
|
3420 |
return _DEPARTMENT; |
|
3421 |
} |
|
3422 |
set |
|
3423 |
{ |
|
3424 |
OnDEPARTMENTChanging(value); |
|
3425 |
ReportPropertyChanging("DEPARTMENT"); |
|
3426 |
_DEPARTMENT = StructuralObject.SetValidValue(value, true); |
|
3427 |
ReportPropertyChanged("DEPARTMENT"); |
|
3428 |
OnDEPARTMENTChanged(); |
|
3429 |
} |
|
3430 |
} |
|
3431 |
private global::System.String _DEPARTMENT; |
|
3432 |
partial void OnDEPARTMENTChanging(global::System.String value); |
|
3433 |
partial void OnDEPARTMENTChanged(); |
|
3434 |
|
|
3435 |
/// <summary> |
|
3436 |
/// 사용 가능한 메타데이터 설명서가 없습니다. |
|
3437 |
/// </summary> |
|
3438 |
[EdmScalarPropertyAttribute(EntityKeyProperty=false, IsNullable=false)] |
|
3439 |
[DataMemberAttribute()] |
|
3440 |
public global::System.String DISPLAYCOLOR |
|
3441 |
{ |
|
3442 |
get |
|
3443 |
{ |
|
3444 |
return _DISPLAYCOLOR; |
|
3445 |
} |
|
3446 |
set |
|
3447 |
{ |
|
3448 |
OnDISPLAYCOLORChanging(value); |
|
3449 |
ReportPropertyChanging("DISPLAYCOLOR"); |
|
3450 |
_DISPLAYCOLOR = StructuralObject.SetValidValue(value, false); |
|
3451 |
ReportPropertyChanged("DISPLAYCOLOR"); |
|
3452 |
OnDISPLAYCOLORChanged(); |
|
3453 |
} |
|
3454 |
} |
|
3455 |
private global::System.String _DISPLAYCOLOR; |
|
3456 |
partial void OnDISPLAYCOLORChanging(global::System.String value); |
|
3457 |
partial void OnDISPLAYCOLORChanged(); |
|
3458 |
|
|
3459 |
#endregion |
|
3460 |
|
|
3461 |
|
|
3462 |
#region 탐색 속성 |
|
3463 |
|
|
3464 |
/// <summary> |
|
3465 |
/// 사용 가능한 메타데이터 설명서가 없습니다. |
|
3466 |
/// </summary> |
|
3467 |
[XmlIgnoreAttribute()] |
|
3468 |
[SoapIgnoreAttribute()] |
|
3469 |
[DataMemberAttribute()] |
|
3470 |
[EdmRelationshipNavigationPropertyAttribute("CIModel", "FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR", "MEMBER_DEPT_COLORINFO")] |
|
3471 |
public EntityCollection<MEMBER_DEPT_COLORINFO> MEMBER_DEPT_COLORINFO |
|
3472 |
{ |
|
3473 |
get |
|
3474 |
{ |
|
3475 |
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedCollection<MEMBER_DEPT_COLORINFO>("CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR", "MEMBER_DEPT_COLORINFO"); |
|
3476 |
} |
|
3477 |
set |
|
3478 |
{ |
|
3479 |
if ((value != null)) |
|
3480 |
{ |
|
3481 |
((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedCollection<MEMBER_DEPT_COLORINFO>("CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR", "MEMBER_DEPT_COLORINFO", value); |
|
3482 |
} |
|
3483 |
} |
|
3484 |
} |
|
3485 |
|
|
3486 |
#endregion |
|
3487 |
|
|
3488 |
} |
|
3489 |
|
|
3490 |
/// <summary> |
|
3491 |
/// 사용 가능한 메타데이터 설명서가 없습니다. |
|
3492 |
/// </summary> |
|
3493 |
[EdmEntityTypeAttribute(NamespaceName="CIModel", Name="MEMBER_DEPT_COLORINFO")] |
|
3494 |
[Serializable()] |
|
3495 |
[DataContractAttribute(IsReference=true)] |
|
3496 |
public partial class MEMBER_DEPT_COLORINFO : EntityObject |
|
3497 |
{ |
|
3498 |
#region 팩터리 메서드 |
|
3499 |
|
|
3500 |
/// <summary> |
|
3501 |
/// 새 MEMBER_DEPT_COLORINFO 개체를 만듭니다. |
|
3502 |
/// </summary> |
|
3503 |
/// <param name="cVALUEID">CVALUEID 속성의 초기 값입니다.</param> |
|
3504 |
/// <param name="dISPLAYCOLOR">DISPLAYCOLOR 속성의 초기 값입니다.</param> |
|
3505 |
/// <param name="cOLORID">COLORID 속성의 초기 값입니다.</param> |
|
3506 |
public static MEMBER_DEPT_COLORINFO CreateMEMBER_DEPT_COLORINFO(global::System.Int64 cVALUEID, global::System.String dISPLAYCOLOR, global::System.Int32 cOLORID) |
|
3507 |
{ |
|
3508 |
MEMBER_DEPT_COLORINFO mEMBER_DEPT_COLORINFO = new MEMBER_DEPT_COLORINFO(); |
|
3509 |
mEMBER_DEPT_COLORINFO.CVALUEID = cVALUEID; |
|
3510 |
mEMBER_DEPT_COLORINFO.DISPLAYCOLOR = dISPLAYCOLOR; |
|
3511 |
mEMBER_DEPT_COLORINFO.COLORID = cOLORID; |
|
3512 |
return mEMBER_DEPT_COLORINFO; |
|
3513 |
} |
|
3514 |
|
|
3515 |
#endregion |
|
3516 |
|
|
3517 |
#region 기본 속성 |
|
3518 |
|
|
3519 |
/// <summary> |
|
3520 |
/// 사용 가능한 메타데이터 설명서가 없습니다. |
|
3521 |
/// </summary> |
|
3522 |
[EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)] |
|
3523 |
[DataMemberAttribute()] |
|
3524 |
public global::System.Int64 CVALUEID |
|
3525 |
{ |
|
3526 |
get |
|
3527 |
{ |
|
3528 |
return _CVALUEID; |
|
3529 |
} |
|
3530 |
set |
|
3531 |
{ |
|
3532 |
if (_CVALUEID != value) |
|
3533 |
{ |
|
3534 |
OnCVALUEIDChanging(value); |
|
3535 |
ReportPropertyChanging("CVALUEID"); |
|
3536 |
_CVALUEID = StructuralObject.SetValidValue(value); |
|
3537 |
ReportPropertyChanged("CVALUEID"); |
|
3538 |
OnCVALUEIDChanged(); |
|
3539 |
} |
|
3540 |
} |
|
3541 |
} |
|
3542 |
private global::System.Int64 _CVALUEID; |
|
3543 |
partial void OnCVALUEIDChanging(global::System.Int64 value); |
|
3544 |
partial void OnCVALUEIDChanged(); |
|
3545 |
|
|
3546 |
/// <summary> |
|
3547 |
/// 사용 가능한 메타데이터 설명서가 없습니다. |
|
3548 |
/// </summary> |
|
3549 |
[EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)] |
|
3550 |
[DataMemberAttribute()] |
|
3551 |
public global::System.String DISPLAYCOLOR |
|
3552 |
{ |
|
3553 |
get |
|
3554 |
{ |
|
3555 |
return _DISPLAYCOLOR; |
|
3556 |
} |
|
3557 |
set |
|
3558 |
{ |
|
3559 |
if (_DISPLAYCOLOR != value) |
|
3560 |
{ |
|
3561 |
OnDISPLAYCOLORChanging(value); |
|
3562 |
ReportPropertyChanging("DISPLAYCOLOR"); |
|
3563 |
_DISPLAYCOLOR = StructuralObject.SetValidValue(value, false); |
|
3564 |
ReportPropertyChanged("DISPLAYCOLOR"); |
|
3565 |
OnDISPLAYCOLORChanged(); |
|
3566 |
} |
|
3567 |
} |
|
3568 |
} |
|
3569 |
private global::System.String _DISPLAYCOLOR; |
|
3570 |
partial void OnDISPLAYCOLORChanging(global::System.String value); |
|
3571 |
partial void OnDISPLAYCOLORChanged(); |
|
3572 |
|
|
3573 |
/// <summary> |
|
3574 |
/// 사용 가능한 메타데이터 설명서가 없습니다. |
|
3575 |
/// </summary> |
|
3576 |
[EdmScalarPropertyAttribute(EntityKeyProperty=true, IsNullable=false)] |
|
3577 |
[DataMemberAttribute()] |
|
3578 |
public global::System.Int32 COLORID |
|
3579 |
{ |
|
3580 |
get |
|
3581 |
{ |
|
3582 |
return _COLORID; |
|
3583 |
} |
|
3584 |
set |
|
3585 |
{ |
|
3586 |
if (_COLORID != value) |
|
3587 |
{ |
|
3588 |
OnCOLORIDChanging(value); |
|
3589 |
ReportPropertyChanging("COLORID"); |
|
3590 |
_COLORID = StructuralObject.SetValidValue(value); |
|
3591 |
ReportPropertyChanged("COLORID"); |
|
3592 |
OnCOLORIDChanged(); |
|
3593 |
} |
|
3594 |
} |
|
3595 |
} |
|
3596 |
private global::System.Int32 _COLORID; |
|
3597 |
partial void OnCOLORIDChanging(global::System.Int32 value); |
|
3598 |
partial void OnCOLORIDChanged(); |
|
3599 |
|
|
3600 |
#endregion |
|
3601 |
|
|
3602 |
|
|
3603 |
#region 탐색 속성 |
|
3604 |
|
|
3605 |
/// <summary> |
|
3606 |
/// 사용 가능한 메타데이터 설명서가 없습니다. |
|
3607 |
/// </summary> |
|
3608 |
[XmlIgnoreAttribute()] |
|
3609 |
[SoapIgnoreAttribute()] |
|
3610 |
[DataMemberAttribute()] |
|
3611 |
[EdmRelationshipNavigationPropertyAttribute("CIModel", "FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR", "MEMBER_DEPT_COLOR")] |
|
3612 |
public MEMBER_DEPT_COLOR MEMBER_DEPT_COLOR |
|
3613 |
{ |
|
3614 |
get |
|
3615 |
{ |
|
3616 |
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<MEMBER_DEPT_COLOR>("CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR", "MEMBER_DEPT_COLOR").Value; |
|
3617 |
} |
|
3618 |
set |
|
3619 |
{ |
|
3620 |
((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<MEMBER_DEPT_COLOR>("CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR", "MEMBER_DEPT_COLOR").Value = value; |
|
3621 |
} |
|
3622 |
} |
|
3623 |
/// <summary> |
|
3624 |
/// 사용 가능한 메타데이터 설명서가 없습니다. |
|
3625 |
/// </summary> |
|
3626 |
[BrowsableAttribute(false)] |
|
3627 |
[DataMemberAttribute()] |
|
3628 |
public EntityReference<MEMBER_DEPT_COLOR> MEMBER_DEPT_COLORReference |
|
3629 |
{ |
|
3630 |
get |
|
3631 |
{ |
|
3632 |
return ((IEntityWithRelationships)this).RelationshipManager.GetRelatedReference<MEMBER_DEPT_COLOR>("CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR", "MEMBER_DEPT_COLOR"); |
|
3633 |
} |
|
3634 |
set |
|
3635 |
{ |
|
3636 |
if ((value != null)) |
|
3637 |
{ |
|
3638 |
((IEntityWithRelationships)this).RelationshipManager.InitializeRelatedReference<MEMBER_DEPT_COLOR>("CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR", "MEMBER_DEPT_COLOR", value); |
|
3639 |
} |
|
3640 |
} |
|
3641 |
} |
|
3642 |
|
|
3643 |
#endregion |
|
3644 |
|
|
3645 |
} |
|
3646 |
|
|
3647 |
/// <summary> |
|
3648 |
/// 사용 가능한 메타데이터 설명서가 없습니다. |
|
3649 |
/// </summary> |
|
3272 | 3650 |
[EdmEntityTypeAttribute(NamespaceName="CIModel", Name="SIGN_INFO")] |
3273 | 3651 |
[Serializable()] |
3274 | 3652 |
[DataContractAttribute(IsReference=true)] |
KCOMDataModel/DataModel/CIModel.edmx | ||
---|---|---|
85 | 85 |
<Property Name="RESULT_FILE" Type="nvarchar" MaxLength="500" /> |
86 | 86 |
<Property Name="RESULT" Type="nvarchar" MaxLength="50" /> |
87 | 87 |
<Property Name="PROJECT_NO" Type="nvarchar" MaxLength="10" Nullable="false" /> |
88 |
<Property Name="ENSEMBLEINFO_URL" Type="nvarchar" MaxLength="500" /> |
|
88 | 89 |
</EntityType> |
89 | 90 |
<EntityType Name="MARKUP_CHECKLIST"> |
90 | 91 |
<Key> |
... | ... | |
108 | 109 |
<Property Name="MARKUPINFO_VERSION_ID" Type="nvarchar" MaxLength="50" Nullable="false" /> |
109 | 110 |
<Property Name="DATA_TYPE" Type="int" Nullable="false" /> |
110 | 111 |
<Property Name="SYMBOL_ID" Type="nvarchar" MaxLength="50" /> |
112 |
<Property Name="GROUP_ID" Type="bigint" /> |
|
111 | 113 |
</EntityType> |
112 | 114 |
<EntityType Name="MARKUP_INFO"> |
113 | 115 |
<Key> |
... | ... | |
146 | 148 |
<Property Name="MODIFIED_DATETIME" Type="datetime" /> |
147 | 149 |
<Property Name="ISLICENSE" Type="int" /> |
148 | 150 |
</EntityType> |
151 |
<EntityType Name="MEMBER_DEPT_COLOR"> |
|
152 |
<Key> |
|
153 |
<PropertyRef Name="COLORID" /> |
|
154 |
</Key> |
|
155 |
<Property Name="COLORID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" /> |
|
156 |
<Property Name="DEPARTMENT" Type="nvarchar" MaxLength="50" /> |
|
157 |
<Property Name="DISPLAYCOLOR" Type="nvarchar" MaxLength="10" Nullable="false" /> |
|
158 |
</EntityType> |
|
159 |
<EntityType Name="MEMBER_DEPT_COLORINFO"> |
|
160 |
<Key> |
|
161 |
<PropertyRef Name="CVALUEID" /> |
|
162 |
<PropertyRef Name="DISPLAYCOLOR" /> |
|
163 |
<PropertyRef Name="COLORID" /> |
|
164 |
</Key> |
|
165 |
<Property Name="CVALUEID" Type="bigint" StoreGeneratedPattern="Identity" Nullable="false" /> |
|
166 |
<Property Name="DISPLAYCOLOR" Type="nvarchar" MaxLength="10" Nullable="false" /> |
|
167 |
<Property Name="COLORID" Type="int" Nullable="false" /> |
|
168 |
</EntityType> |
|
149 | 169 |
<EntityType Name="SIGN_INFO"> |
150 | 170 |
<Key> |
151 | 171 |
<PropertyRef Name="ID" /> |
... | ... | |
223 | 243 |
</Dependent> |
224 | 244 |
</ReferentialConstraint> |
225 | 245 |
</Association> |
226 |
<Association Name="FK_SIGNINFO_MEMBER">
|
|
227 |
<End Role="MEMBER" Type="Self.MEMBER" Multiplicity="1" />
|
|
228 |
<End Role="SIGN_INFO" Type="Self.SIGN_INFO" Multiplicity="*" />
|
|
246 |
<Association Name="FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR">
|
|
247 |
<End Role="MEMBER_DEPT_COLOR" Type="Self.MEMBER_DEPT_COLOR" Multiplicity="1" />
|
|
248 |
<End Role="MEMBER_DEPT_COLORINFO" Type="Self.MEMBER_DEPT_COLORINFO" Multiplicity="*" />
|
|
229 | 249 |
<ReferentialConstraint> |
230 |
<Principal Role="MEMBER"> |
|
231 |
<PropertyRef Name="ID" /> |
|
250 |
<Principal Role="MEMBER_DEPT_COLOR">
|
|
251 |
<PropertyRef Name="COLORID" />
|
|
232 | 252 |
</Principal> |
233 |
<Dependent Role="SIGN_INFO">
|
|
234 |
<PropertyRef Name="MEMBER_USER_ID" />
|
|
253 |
<Dependent Role="MEMBER_DEPT_COLORINFO">
|
|
254 |
<PropertyRef Name="COLORID" />
|
|
235 | 255 |
</Dependent> |
236 | 256 |
</ReferentialConstraint> |
237 | 257 |
</Association> |
... | ... | |
246 | 266 |
<EntitySet Name="MARKUP_INFO" EntityType="Self.MARKUP_INFO" Schema="dbo" store:Type="Tables" /> |
247 | 267 |
<EntitySet Name="MARKUP_INFO_VERSION" EntityType="Self.MARKUP_INFO_VERSION" Schema="dbo" store:Type="Tables" /> |
248 | 268 |
<EntitySet Name="MEMBER" EntityType="Self.MEMBER" Schema="dbo" store:Type="Tables" /> |
269 |
<EntitySet Name="MEMBER_DEPT_COLOR" EntityType="Self.MEMBER_DEPT_COLOR" Schema="dbo" store:Type="Tables" /> |
|
270 |
<EntitySet Name="MEMBER_DEPT_COLORINFO" EntityType="Self.MEMBER_DEPT_COLORINFO" Schema="dbo" store:Type="Tables" /> |
|
249 | 271 |
<EntitySet Name="SIGN_INFO" EntityType="Self.SIGN_INFO" Schema="dbo" store:Type="Tables" /> |
250 | 272 |
<EntitySet Name="TALK" EntityType="Self.TALK" Schema="dbo" store:Type="Tables" /> |
251 | 273 |
<AssociationSet Name="FK_DOCINFODOFPAGE" Association="Self.FK_DOCINFODOFPAGE"> |
... | ... | |
264 | 286 |
<End Role="MARKUP_INFO" EntitySet="MARKUP_INFO" /> |
265 | 287 |
<End Role="MARKUP_INFO_VERSION" EntitySet="MARKUP_INFO_VERSION" /> |
266 | 288 |
</AssociationSet> |
267 |
<AssociationSet Name="FK_SIGNINFO_MEMBER" Association="Self.FK_SIGNINFO_MEMBER">
|
|
268 |
<End Role="MEMBER" EntitySet="MEMBER" />
|
|
269 |
<End Role="SIGN_INFO" EntitySet="SIGN_INFO" />
|
|
289 |
<AssociationSet Name="FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" Association="Self.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR">
|
|
290 |
<End Role="MEMBER_DEPT_COLOR" EntitySet="MEMBER_DEPT_COLOR" />
|
|
291 |
<End Role="MEMBER_DEPT_COLORINFO" EntitySet="MEMBER_DEPT_COLORINFO" />
|
|
270 | 292 |
</AssociationSet> |
271 | 293 |
</EntityContainer> |
272 | 294 |
</Schema></edmx:StorageModels> |
... | ... | |
306 | 328 |
<EntitySet Name="TALK" EntityType="CIModel.TALK" /> |
307 | 329 |
<EntitySet Name="CHECK_LIST" EntityType="CIModel.CHECK_LIST" /> |
308 | 330 |
<EntitySet Name="CHECK_LIST_HISTORY" EntityType="CIModel.CHECK_LIST_HISTORY" /> |
331 |
<EntitySet Name="MEMBER_DEPT_COLOR" EntityType="CIModel.MEMBER_DEPT_COLOR" /> |
|
332 |
<EntitySet Name="MEMBER_DEPT_COLORINFO" EntityType="CIModel.MEMBER_DEPT_COLORINFO" /> |
|
333 |
<AssociationSet Name="FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" Association="CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR"> |
|
334 |
<End Role="MEMBER_DEPT_COLOR" EntitySet="MEMBER_DEPT_COLOR" /> |
|
335 |
<End Role="MEMBER_DEPT_COLORINFO" EntitySet="MEMBER_DEPT_COLORINFO" /> |
|
336 |
</AssociationSet> |
|
309 | 337 |
</EntityContainer> |
310 | 338 |
<EntityType Name="DOCUMENT_ITEM"> |
311 | 339 |
<Key> |
... | ... | |
321 | 349 |
<Property Name="RESULT_FILE" Type="String" MaxLength="500" FixedLength="false" Unicode="true" /> |
322 | 350 |
<Property Name="RESULT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
323 | 351 |
<Property Name="PROJECT_NO" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" /> |
352 |
<Property Name="ENSEMBLEINFO_URL" Type="String" MaxLength="500" FixedLength="false" Unicode="true" /> |
|
324 | 353 |
</EntityType> |
325 | 354 |
<EntityType Name="DOCINFO"> |
326 | 355 |
<Key> |
... | ... | |
357 | 386 |
<Property Name="DATA_TYPE" Type="Int32" Nullable="false" /> |
358 | 387 |
<NavigationProperty Name="MARKUP_INFO_VERSION" Relationship="CIModel.FK_MARKUPINFO_VERSIONMARKUPDATA" FromRole="MARKUP_DATA" ToRole="MARKUP_INFO_VERSION" /> |
359 | 388 |
<Property Name="SYMBOL_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
389 |
<Property Name="GROUP_ID" Type="Int64" /> |
|
360 | 390 |
</EntityType> |
361 | 391 |
<EntityType Name="MARKUP_INFO"> |
362 | 392 |
<Key> |
... | ... | |
547 | 577 |
<Property Name="CREATE_TIME" Type="DateTime" Nullable="false" Precision="3" /> |
548 | 578 |
<Property Name="UPDATE_TIME" Type="DateTime" Nullable="false" Precision="3" /> |
549 | 579 |
</EntityType> |
580 |
<EntityType Name="MEMBER_DEPT_COLOR"> |
|
581 |
<Key> |
|
582 |
<PropertyRef Name="COLORID" /> |
|
583 |
</Key> |
|
584 |
<Property Name="COLORID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> |
|
585 |
<Property Name="DEPARTMENT" Type="String" MaxLength="50" FixedLength="false" Unicode="true" /> |
|
586 |
<Property Name="DISPLAYCOLOR" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" /> |
|
587 |
<NavigationProperty Name="MEMBER_DEPT_COLORINFO" Relationship="CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" FromRole="MEMBER_DEPT_COLOR" ToRole="MEMBER_DEPT_COLORINFO" /> |
|
588 |
</EntityType> |
|
589 |
<EntityType Name="MEMBER_DEPT_COLORINFO"> |
|
590 |
<Key> |
|
591 |
<PropertyRef Name="CVALUEID" /> |
|
592 |
<PropertyRef Name="DISPLAYCOLOR" /> |
|
593 |
<PropertyRef Name="COLORID" /> |
|
594 |
</Key> |
|
595 |
<Property Name="CVALUEID" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" /> |
|
596 |
<Property Name="DISPLAYCOLOR" Type="String" Nullable="false" MaxLength="10" FixedLength="false" Unicode="true" /> |
|
597 |
<Property Name="COLORID" Type="Int32" Nullable="false" /> |
|
598 |
<NavigationProperty Name="MEMBER_DEPT_COLOR" Relationship="CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" FromRole="MEMBER_DEPT_COLORINFO" ToRole="MEMBER_DEPT_COLOR" /> |
|
599 |
</EntityType> |
|
600 |
<Association Name="FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR"> |
|
601 |
<End Type="CIModel.MEMBER_DEPT_COLOR" Role="MEMBER_DEPT_COLOR" Multiplicity="1" /> |
|
602 |
<End Type="CIModel.MEMBER_DEPT_COLORINFO" Role="MEMBER_DEPT_COLORINFO" Multiplicity="*" /> |
|
603 |
<ReferentialConstraint> |
|
604 |
<Principal Role="MEMBER_DEPT_COLOR"> |
|
605 |
<PropertyRef Name="COLORID" /> |
|
606 |
</Principal> |
|
607 |
<Dependent Role="MEMBER_DEPT_COLORINFO"> |
|
608 |
<PropertyRef Name="COLORID" /> |
|
609 |
</Dependent> |
|
610 |
</ReferentialConstraint> |
|
611 |
</Association> |
|
550 | 612 |
</Schema> |
551 | 613 |
</edmx:ConceptualModels> |
552 | 614 |
<!-- C-S mapping content --> |
... | ... | |
556 | 618 |
<EntitySetMapping Name="DOCUMENT_ITEM"> |
557 | 619 |
<EntityTypeMapping TypeName="IsTypeOf(CIModel.DOCUMENT_ITEM)"> |
558 | 620 |
<MappingFragment StoreEntitySet="DOCUMENT_ITEM"> |
559 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
|
621 |
<ScalarProperty Name="ENSEMBLEINFO_URL" ColumnName="ENSEMBLEINFO_URL" /> |
|
622 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
|
560 | 623 |
<ScalarProperty Name="REVISION" ColumnName="REVISION" /> |
561 | 624 |
<ScalarProperty Name="DOCUMENT_NO" ColumnName="DOCUMENT_NO" /> |
562 | 625 |
<ScalarProperty Name="DOCUMENT_NAME" ColumnName="DOCUMENT_NAME" /> |
... | ... | |
595 | 658 |
<EntitySetMapping Name="MARKUP_DATA"> |
596 | 659 |
<EntityTypeMapping TypeName="IsTypeOf(CIModel.MARKUP_DATA)"> |
597 | 660 |
<MappingFragment StoreEntitySet="MARKUP_DATA"> |
598 |
<ScalarProperty Name="SYMBOL_ID" ColumnName="SYMBOL_ID" /> |
|
661 |
<ScalarProperty Name="GROUP_ID" ColumnName="GROUP_ID" /> |
|
662 |
<ScalarProperty Name="SYMBOL_ID" ColumnName="SYMBOL_ID" /> |
|
599 | 663 |
<ScalarProperty Name="ID" ColumnName="ID" /> |
600 | 664 |
<ScalarProperty Name="PAGENUMBER" ColumnName="PAGENUMBER" /> |
601 | 665 |
<ScalarProperty Name="DATA" ColumnName="DATA" /> |
... | ... | |
735 | 799 |
</MappingFragment> |
736 | 800 |
</EntityTypeMapping> |
737 | 801 |
</EntitySetMapping> |
802 |
<EntitySetMapping Name="MEMBER_DEPT_COLOR"> |
|
803 |
<EntityTypeMapping TypeName="CIModel.MEMBER_DEPT_COLOR"> |
|
804 |
<MappingFragment StoreEntitySet="MEMBER_DEPT_COLOR"> |
|
805 |
<ScalarProperty Name="DISPLAYCOLOR" ColumnName="DISPLAYCOLOR" /> |
|
806 |
<ScalarProperty Name="DEPARTMENT" ColumnName="DEPARTMENT" /> |
|
807 |
<ScalarProperty Name="COLORID" ColumnName="COLORID" /> |
|
808 |
</MappingFragment> |
|
809 |
</EntityTypeMapping> |
|
810 |
</EntitySetMapping> |
|
811 |
<EntitySetMapping Name="MEMBER_DEPT_COLORINFO"> |
|
812 |
<EntityTypeMapping TypeName="CIModel.MEMBER_DEPT_COLORINFO"> |
|
813 |
<MappingFragment StoreEntitySet="MEMBER_DEPT_COLORINFO"> |
|
814 |
<ScalarProperty Name="COLORID" ColumnName="COLORID" /> |
|
815 |
<ScalarProperty Name="DISPLAYCOLOR" ColumnName="DISPLAYCOLOR" /> |
|
816 |
<ScalarProperty Name="CVALUEID" ColumnName="CVALUEID" /> |
|
817 |
</MappingFragment> |
|
818 |
</EntityTypeMapping> |
|
819 |
</EntitySetMapping> |
|
738 | 820 |
</EntityContainerMapping> |
739 | 821 |
</Mapping></edmx:Mappings> |
740 | 822 |
</edmx:Runtime> |
... | ... | |
774 | 856 |
<EntityTypeShape EntityType="CIModel.TALK" Width="1.5" PointX="3.375" PointY="0.75" /> |
775 | 857 |
<EntityTypeShape EntityType="CIModel.CHECK_LIST" Width="1.5" PointX="0.75" PointY="4.75" /> |
776 | 858 |
<EntityTypeShape EntityType="CIModel.CHECK_LIST_HISTORY" Width="1.5" PointX="5.375" PointY="0.75" /> |
859 |
<EntityTypeShape EntityType="CIModel.MEMBER_DEPT_COLOR" Width="1.5" PointX="7.375" PointY="0.875" /> |
|
860 |
<EntityTypeShape EntityType="CIModel.MEMBER_DEPT_COLORINFO" Width="1.5" PointX="9.625" PointY="0.875" /> |
|
861 |
<AssociationConnector Association="CIModel.FK_MEMBER_DEPT_COLORINFO_MEMBER_DEPT_COLOR" /> |
|
777 | 862 |
</Diagram> |
778 | 863 |
</Diagrams> |
779 | 864 |
</Designer> |
KCOM_API/ServiceDeepView.svc.cs | ||
---|---|---|
518 | 518 |
using (CIEntities entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(ProjectNo).ToString())) |
519 | 519 |
{ |
520 | 520 |
var markupListData = entity.MARKUP_INFO.Where(data => data.DOCINFO_ID == DocInfoId).ToList(); |
521 |
|
|
522 |
var markupList = from markup in markupListData |
|
523 |
orderby markup.CREATE_TIME descending |
|
524 |
select new MarkupInfoItem |
|
525 |
{ |
|
526 |
MarkupInfoID = markup.ID, |
|
527 |
UserID = markup.USER_ID, |
|
528 |
MarkupVersionID = markup.MARKUP_INFO_VERSION.Count() == 0 ? null : markup.MARKUP_INFO_VERSION.OrderByDescending(data => data.CREATE_DATE).FirstOrDefault().ID, |
|
529 |
CreateTime = markup.CREATE_TIME, |
|
530 |
Consolidate = markup.CONSOLIDATE, |
|
531 |
Description = markup.DESCRIPTION, |
|
532 |
AvoidConsolidate = markup.AVOID_CONSOLIDATE, |
|
533 |
PartConsolidate = markup.PART_CONSOLIDATE, |
|
534 |
UpdateTime = DateTime.Parse(markup.UPDATE_TIME.ToString()), |
|
535 |
}; |
|
536 |
|
|
537 |
if (markupList.Count() > 0) |
|
538 |
{ |
|
539 |
_result = markupList.ToList(); |
|
540 |
} |
|
541 |
|
|
542 |
_result.ForEach(r => |
|
543 |
{ |
|
544 |
|
|
545 |
r.MarkupList = (from markupData in entity.MARKUP_DATA |
|
546 |
where markupData.MARKUPINFO_VERSION_ID == r.MarkupVersionID |
|
547 |
orderby markupData.PAGENUMBER |
|
548 |
select new MarkupItem { ID = markupData.ID, PageNumber = markupData.PAGENUMBER, Data = markupData.DATA, Data_Type = markupData.DATA_TYPE, Symbol_ID = markupData.SYMBOL_ID }).ToList(); |
|
549 |
}); |
|
550 |
|
|
551 |
Random random = new Random(); |
|
552 |
|
|
553 |
_MemberDeptColors memberDeptColors = new _MemberDeptColors(); |
|
554 |
_MemberDeptColorsInfo memberDeptColorsInfo = new _MemberDeptColorsInfo(); |
|
555 |
|
|
556 |
|
|
557 |
memberDeptColors._memberDeptColors = (from memberdeptcolor in entity.MEMBER_DEPT_COLOR |
|
558 |
//where memberdeptcolor.DEPARTMENT == "DisplayColor" |
|
559 |
select memberdeptcolor).ToList(); |
|
560 |
memberDeptColorsInfo._memberDeptColorsInfo = (from memberdeptcolorinfo in entity.MEMBER_DEPT_COLORINFO |
|
561 |
//where memberdeptcolor.DEPARTMENT == "DisplayColor" |
|
562 |
select memberdeptcolorinfo).ToList(); |
|
563 |
|
|
564 |
|
|
565 |
foreach (var item in _result) |
|
566 |
{ |
|
567 |
var _member = entity.MEMBER.Where(member => member.ID == item.UserID); |
|
568 |
|
|
569 |
if (_member.Count() > 0) |
|
570 |
{ |
|
571 |
item.UserName = _member.First().NAME; |
|
572 |
item.Depatment = _member.First().DEPARTMENT; |
|
573 |
} |
|
574 |
|
|
575 |
foreach (var dept in memberDeptColors._memberDeptColors) |
|
576 |
{//dept 지정 색상 |
|
577 |
if (dept.DEPARTMENT == item.Depatment) |
|
578 |
{ |
|
579 |
var colorlist = memberDeptColorsInfo._memberDeptColorsInfo.Where(d => d.COLORID == dept.COLORID).ToList(); |
|
580 |
|
|
581 |
int colorIdx = random.Next(1, colorlist.Count()); |
|
582 |
if (colorlist.Count > 0) |
|
583 |
{ |
|
584 |
item.DisplayColor = "#FF" + colorlist[colorIdx].DISPLAYCOLOR; |
|
585 |
memberDeptColorsInfo._memberDeptColorsInfo.Remove(colorlist[colorIdx]); |
|
586 |
break; |
|
587 |
} |
|
588 |
else |
|
589 |
{ |
|
590 |
item.DisplayColor = String.Format("#FF{0:X6}", random.Next(0x1000000)); |
|
591 |
break; |
|
592 |
} |
|
593 |
} |
|
594 |
} |
|
595 |
|
|
596 |
|
|
597 |
if (item.DisplayColor == null) |
|
598 |
{ |
|
599 |
foreach (var dept in memberDeptColors._memberDeptColors) |
|
600 |
{ |
|
601 |
if (dept.DEPARTMENT == null) |
|
602 |
{ |
|
603 |
dept.DEPARTMENT = item.Depatment; |
|
604 |
var colorlist = memberDeptColorsInfo._memberDeptColorsInfo.Where(d => d.COLORID == dept.COLORID).ToList(); |
|
605 |
int colorIdx = random.Next(1, colorlist.Count()); |
|
606 |
if (colorlist.Count > 0) |
|
607 |
{ |
|
608 |
item.DisplayColor = "#FF" + colorlist[colorIdx].DISPLAYCOLOR; |
|
609 |
memberDeptColorsInfo._memberDeptColorsInfo.Remove(colorlist[colorIdx]); |
|
610 |
break; |
|
611 |
} |
|
612 |
else |
|
613 |
{ |
|
614 |
item.DisplayColor = String.Format("#FF{0:X6}", random.Next(0x1000000)); |
|
615 |
break; |
|
616 |
} |
|
617 |
} |
|
618 |
} |
|
619 |
} |
|
620 |
|
|
621 |
if (item.DisplayColor == null) |
|
622 |
{ |
|
623 |
item.DisplayColor = String.Format("#FF{0:X6}", random.Next(0x1000000)); |
|
624 |
} |
|
625 |
} |
|
626 |
} |
|
627 |
} |
|
628 |
catch (Exception EX) |
|
629 |
{ |
|
630 |
System.Diagnostics.Debug.WriteLine(this.GetType().ToString() + " " + EX); |
|
631 |
return _result; |
|
632 |
} |
|
633 |
finally |
|
634 |
{ |
|
635 |
GC.Collect(2); |
|
636 |
} |
|
637 |
|
|
638 |
return _result; |
|
639 |
} |
|
640 |
|
|
641 |
/* |
|
642 |
[OperationContract] |
|
643 |
public List<MarkupInfoItem> GetMarkupInfoItems(string ProjectNo, string DocInfoId) |
|
644 |
{ |
|
645 |
List<MarkupInfoItem> _result = new List<MarkupInfoItem>(); |
|
646 |
try |
|
647 |
{ |
|
648 |
using (CIEntities entity = new CIEntities(ConnectStringBuilder.ProjectCIConnectString(ProjectNo).ToString())) |
|
649 |
{ |
|
650 |
var markupListData = entity.MARKUP_INFO.Where(data => data.DOCINFO_ID == DocInfoId).ToList(); |
|
521 | 651 |
//foreach (var item in markupListData) |
522 | 652 |
//{ |
523 | 653 |
// if (!item.AVOID_CONSOLIDATE.HasValue) |
... | ... | |
609 | 739 |
|
610 | 740 |
return _result; |
611 | 741 |
} |
612 |
|
|
742 |
*/ |
|
613 | 743 |
[OperationContract] |
614 | 744 |
public List<MarkupInfoItem> GetSyncMarkupInfoItems(string ProjectNo, string DocInfoId, string currentUser) |
615 | 745 |
{ |
내보내기 Unified diff