Cubes Cubes Mandant ORIGINAL,ID,ID,ID,System.Int64,_x0037_f5282f1cdf740049c82240d6069ca85 ORIGINAL,LegalForm,LegalForm,LegalForm,System.Int64,_x0038_ac078629ee24558a06b9b4d79d6f0d1 ORIGINAL,RegistrationCode,RegistrationCode,RegistrationCode,System.String,_x0037_b1c7eede4fa49078e025d75494e5107 ORIGINAL,DiscountDays,DiscountDays,DiscountDays,System.Int32,_x0031_8e3b89a6b5b41b79101b32ff10f76bf ORIGINAL,DiscountPercent,DiscountPercent,DiscountPercent,System.Double,_x0032_e8693cb45a54966a1d54f83f34b18ec ORIGINAL,DiscountDays2,DiscountDays2,DiscountDays2,System.Int32,_x0035_5148186b79b4e73a0b3966d9d4d3188 ORIGINAL,DiscountPercent2,DiscountPercent2,DiscountPercent2,System.Double,_x0031_da2a7b1b4804989a1f63990e625c6d3 ORIGINAL,NetDays,NetDays,NetDays,System.Int32,_x0038_a2026ebe129410ea35370d0fd8b6796 ORIGINAL,Label,Label,Label,System.String,_x0036_a4f3a45a8ea4199823b7d012a4d365f ORIGINAL,Street,Street,Street,System.String,_x0033_a2c057690e54a649af64888658d6b77 ORIGINAL,ZipCode,ZipCode,ZipCode,System.String,_x0031_17f59e764524d54b20971c545a36763 ORIGINAL,CityLabel,CityLabel,CityLabel,System.String,_x0039_ffddbe196b34b56b7f8ae3742f5b193 ORIGINAL,CountryLabel,CountryLabel,CountryLabel,System.String,_x0031_2d76821093a489e9aa2f114a6a5eb8a ORIGINAL,UIDNumber,UIDNumber,UIDNumber,System.String,_x0033_c597e069dac4f8ba323a718cda304d3 ORIGINAL,Photo,Photo,Photo,System.Byte[],cac865a184fb4be5b4446e4015d037db ORIGINAL,Mandant_Telefon,Mandant_Telefon,Mandant_Telefon,System.String,_x0033_784a193254449f084c971238fc05558 ORIGINAL,Mandant_Homepage,Mandant_Homepage,Mandant_Homepage,System.String,_x0039_670515afe184e709e3fbd983720fe50 ORIGINAL,Mandant_Fax,Mandant_Fax,Mandant_Fax,System.String,_x0039_dcbb205219c42df8c8b8e5e77f900eb ORIGINAL,Mandant_Email,Mandant_Email,Mandant_Email,System.String,_x0037_27db5a0a43a454bbd29120549f4ad68 ORIGINAL,countrycode,countrycode,countrycode,System.String,d65ab1e444c047fa8d58db8a4b0b3400 30 ed85f41e8128417cb036ad352cb2bb82 Mandant Cubes select Label, Street, ZipCode, CityLabel, CountryLabel, UIDNumber, RegistrationCode, Photo, countrycode, (select top 1 Value from [doContactInfo-view] Where disabled = 0 and Address = acv.ID and Label Like '%Telefon%') as Mandant_Telefon, (select top 1 Value from [doContactInfo-view] Where disabled = 0 and Address = acv.ID and Label Like '%Homepage%') as Mandant_Homepage, (select top 1 Value from [doContactInfo-view] Where disabled = 0 and Address = acv.ID and Label Like '%Fax%') as Mandant_Fax, (select top 1 Value from [doContactInfo-view] Where disabled = 0 and Address = acv.ID and Label Like '%mail%') as Mandant_Email from [doAccount-view] acv where acv.disabled = 0 and acv.id = ( select CONVERT(bigint,CONVERT(varchar, [Value])) from doProfileEntry where [Key] like 'frameCube.CustomerAddressID' and [User] is NULL ) Mitarbeiter ORIGINAL,id,id,id,System.Int64,_x0031_9547ca75eea4c4fa3af4199a5e1dbbc ORIGINAL,Nachname,Nachname,Nachname,System.String,ea08120525f3407aace7fdebd298d633 ORIGINAL,Vorname,Vorname,Vorname,System.String,_x0035_d870e81318146ca8ef508ee1501a4d9 ORIGINAL,Job,Job,Job,System.String,d23b8ab6789f45898bfa4a7c6f5b7ad8 ORIGINAL,Adresse,Adresse,Adresse,System.String,ae40425bee194b9e94b3202de8dec893 30 d08ebc8397be4b42a79faba8f9a154b2 Mitarbeiter Cubes Select c.ID as id, c.Lastname as Nachname, c.Firstname as Vorname, c.Job, CONCAT(a.street,', ', a.ZipCode,' ', a.CityLabel) as Adresse from [doContact-View] as c inner join [doAddress-View] as a on a.ID = c.id inner join [doEmployee-View] as ma on MA.id = c.id where c.id = {DataObjectID} Ansprechpartner cid,System.Int64 Kunde,System.String Bezeichnung,System.String kundeid,System.Int64 30 09344ce87978425caae6191f3180ce38 Ansprechpartner Cubes select C.id as cid, C.label as Bezeichnung, a.Label as Kunde, a.ID as kundeid from [doContact-View] as c inner join [doConnection-View] as con on con.SourceObject = c.ID and con.Label like 'ddl-Ansprechpartner%' and con.disabled = 0 inner join [doAddress-View] as a on a.ID = con.TargetObject and a.disabled = 0 where c.id = {DataObjectID} Verantwortlichkeiten cid,System.Int64 Bezeichnung,System.String Sikill,System.String skillid,System.Int64 Art,System.String 30 ec490682891347ccaaca5fb47ad3f71c Verantwortlichkeiten Cubes select C.id as cid, C.label as Bezeichnung, s.Label as Sikill, s.ID as skillid, con.label as Art from [doContact-View] as c inner join [doConnection-View] as con on con.TargetObject = c.ID and con.disabled = 0 inner join [doskill-View] as s on s.ID = con.SourceObject where c.id = {DataObjectID} and s.disabled = 0 order by con.Label ,DataObjectID,DataObjectID,,System.Int64,_x0030_,True,False,False,False ,CubeUserID,CubeUserID,,System.Int64,_x0031_18631,True,False,False,False EngineV2 d67536c69dc94c9abddf7e4862508e8e None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,19,1.2 Transparent 0,0,4.2,0.8 Arial,14,Bold 0,0,0,0 Text117 {Mandant.Label} Black DataColumn True if (Mandant.Photo != null) { System.IO.MemoryStream ms = new System.IO.MemoryStream(Mandant.Photo); System.Runtime.Serialization.Formatters.Binary.BinaryFormatter bf = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter(); Bitmap bitmap = (Bitmap)bf.Deserialize(ms); Image3.Image = bitmap; } None;[37:141:191];1;Solid;False;4;Black Transparent 15.6,0,3.4,1.2 Mandant.Photo d0cdd293405d44b6984fb15990bd1481 68, 114, 196 0,0,0,0 Image3 True PageHeaderBand1 Transparent 0,26.9,19,0.8 Transparent 2.8,0.14,13.4,0.6 Arial,8 Center 0,0,0,0 Text141 {Mandant.Street}, {Mandant.ZipCode} {Mandant.CityLabel} - {Mandant.Mandant_Telefon} - {Mandant.Mandant_Email} - {Mandant.Mandant_Homepage} Black Expression Bottom Transparent 16.2,0.14,2.8,0.6 Arial,8 Right 0,0,0,0 Text135 {PageNofM} Black SystemVariables Bottom Transparent 0,0.14,1.4,0.6 Arial,8 0,0,0,0 Text139 {Today} Black SystemVariables Bottom Transparent 1.4,0.14,1.4,0.6 Arial,8 0,0,0,0 Text140 {Time} Black SystemVariables Bottom PageFooterBand1 Transparent 0,2.4,19,1.4 Transparent 0,0,7.4,0.6 Arial,14,Bold 0,0,0,0 Text1 {Mitarbeiter.Vorname} Black Transparent 0,0.6,7.4,0.6 Arial,14,Bold 0,0,0,0 Text2 {Mitarbeiter.Nachname} Black Transparent 11,0,8,0.6 Arial,14,Bold Right 0,0,0,0 Text3 {Mitarbeiter.Job} Black Transparent True 11,0.6,8,0.6 Arial,14,Bold True Right 0,0,0,0 Text4 {Mitarbeiter.Adresse} Black ,,,,WordWrap=True,A=0 Mitarbeiter DataBand1 Transparent 0,4.6,19,1.2 Transparent 0,0,9.6,1.2 Arial,14,Bold 0,0,0,0 Text7 Ansprechpartner Black Expression Bottom DataBand4 Transparent 0,6.6,19,0.6 Bottom;Black;1;Dot;False;4;Black Transparent True try { StiComponent comp = sender as StiComponent; Int64 id = Int64.Parse(comp.HyperlinkValue.ToString()); FormManager.GetFormManager().Show(FrameCube.Context, id, null); } catch(Exception ex) { MessageBox.Show(ex.Message); } 0,0,19,0.6 Arial,12 True {Ansprechpartner.kundeid} 0,0,0,0 Text5 {Ansprechpartner.Kunde} Black ,,,,WordWrap=True,A=0 Ansprechpartner DataBand2 Transparent 0,8,19,1.2 Transparent 0,0,9.6,1.2 Arial,14,Bold 0,0,0,0 Text8 Verantwortlichkeiten Black Expression Bottom DataBand5 Transparent 0,10,19,0.6 Bottom;Black;1;Dot;False;4;Black Transparent True 7.6,0,11.4,0.6 Arial,12 True Right 0,0,0,0 Text6 {Verantwortlichkeiten.Sikill} Black ,,,,WordWrap=True,A=0 Bottom;Black;1;Dot;False;4;Black Transparent True 0,0,7.6,0.6 Arial,12 True 0,0,0,0 Text9 {Verantwortlichkeiten.Art} Black ,,,,WordWrap=True,A=0 Verantwortlichkeiten DataBand3 ASC Art 87b373657bf8480693a6ef418cde78b8 1,1,1,1 Page1 29.7 21 System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll DataObjects.NET.Dll baseCubeData.Dll baseCubeUI.Dll projectCubeData.Dll DevExpress.Utils.v23.2.dll DevExpress.XtraRichEdit.v23.2.dll DevExpress.XtraBars.v23.2.dll DevExpress.Data.v23.2.dll DevExpress.RichEdit.v23.2.Core.dll DevExpress.XtraEditors.v23.2.dll DevExpress.Printing.v23.2.Core.dll DevExpress.Drawing.v23.2.dll DevExpress.Docs.v23.2.dll DevExpress.Pdf.v23.2.Core.dll DevExpress.Pdf.v23.2.Drawing.dll Report 2/6/2025 12:23:43 PM 6/6/2024 12:10:58 PM 9ecf4d92538d474a959d0817862d8bff Report Centimeters 2024.1.3.0 CSharp