1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
|
String requete = "SELECT TCD.CartoEntry_Key as CartoEntryId ";
requete += ", TCD.CartoEntry as CartoEntryLabel ";
requete += ", TCD.CartoEntry_CodBasicat as CartoEntryBasicat ";
requete += ", TCD.CartoEntry_Status as CartoEntryStatus ";
requete += ", TCD.CartoEntry_Object_Type as CartoEntryObjectType ";
requete += ", TCD.CartoEntry_Origin as CartoEntryOrigin ";
requete += ", TRBD.Business_Domain as CartoEntryDomain ";
requete += ", TRBS.Business_SubDomain as CartoEntrySubDomain ";
requete += ", TCD.CartoEntry_ShortDesc_English as CartoEntryDescription ";
requete += ", TLCCBO.Contact_Business_Owner_key as CartoEntry_BusinessOwnerKey ";
requete += ", TLCCBO.Contact_Business_Owner_CUID as CartoEntry_BusinessOwnerCuid ";
requete += ", TLCCBO.Contact_Business_Owner_First_Name + ' ' + TLCCBO.Contact_Business_Owner_Last_Name as CartoEntry_BusinessOwnerName ";
requete += ", TLCCBO.Contact_Business_Owner_Role as CartoEntry_BusinessOwnerRole ";
requete += ", TLCCBO.Contact_Business_Owner_Department as CartoEntry_BusinessOwnerOrganization ";
requete += ", TLCC.Contact_key as CartoEntry_ItContactKey ";
requete += ", TLCC.Contact_CUID as CartoEntry_ItContactCuid ";
requete += ", TLCC.Contact_First_Name + ' ' + TLCC.Contact_Last_Name as CartoEntry_ItContactName ";
requete += ", TLCC.Contact_Role as CartoEntry_ItContactRole ";
requete += ", TLCC.Contact_Department as CartoEntry_ItContactOrganization ";
requete += "FROM T_cartoentry_description as TCD left outer join t_ref_business_domain as TRBD on TCD.cartoentry_business_domain=TRBD.Business_domain_description ";
requete += "left outer join t_ref_business_subdomain as TRBS on TCD.cartoentry_business_subdomain=TRBS.Business_subdomain_description ";
requete += "left outer join t_link_cartoentry_business_product as TLCBP on TCD.CartoEntry=TLCBP.CartoEntry ";
requete += "left outer join T_CartoEntry_Organization as TCO on TCD.CartoEntry=TCO.CartoEntry ";
requete += "left outer join T_Ref_Business_Owner_Department as TRBOD ON TCO.CartoEntry_BO_Department = TRBOD.BO_Department_Email ";
requete += "left outer join T_Ref_Business_Owner_Department_Level2 as TRBODL ON TCO.CartoEntry_BO_Department2 = TRBODL.BO_Department2_Email ";
requete += "left outer join T_Link_CartoEntry_End_User as TLCEU on TCO.CartoEntry = TLCEU.CartoEntry ";
requete += "left outer join T_Ref_Manager_Development as TRMD on TCO.CartoEntry_Manager_Development = TRMD.Manager_Development_Email ";
requete += "left outer join T_Ref_Manager_Development_Level2 as TRMDL on TCO.CartoEntry_Manager_Development2 = TRMDL.Manager_Development2_Email ";
requete += "left outer join T_Ref_Manager_Implementation as TRMI on TCO.CartoEntry_Manager_Implementation = TRMI.Manager_Implementation_Email ";
requete += "left outer join T_Ref_Manager_Service as TRMS on TCO.CartoEntry_Manager_Service = TRMS.Manager_Service_Email ";
requete += "left outer join T_CartoEntry_Ops_Services as TCOS on TCD.CartoEntry=TCOS.CartoEntry ";
requete += "left outer join T_Ref_Manager_Operations as TRMO on TCO.CartoEntry_Manager_Operations = TRMO.Manager_Operations_Email ";
requete += "left outer join T_Link_CartoEntry_Contact_Business_Owner as TLCCBO on TLCCBO.CartoEntry = TCD.CartoEntry ";
requete += "left outer join T_Link_CartoEntry_Contact as TLCC on TLCC.CartoEntry = TCD.CartoEntry ";
requete += "WHERE 1=1 ";
subRequestCartoEntryKey += "AND TCD.CartoEntry_Key like '%"+s+"%'";
ObjectQuery<DbDataRecord> query = new ObjectQuery<DbDataRecord>(requete, bdd);
log.LoggerFactory(new LogEvent(LogLevel.Error, " [SQL]Execute Request : " + requete));
list = query.ToList().ConvertTo<CartoEntryForSearchDto>(); |
Partager