oleDBConnection Provider=SQLOLEDB.1;Password=sysadm;Persist Security Info=True;User ID=sysadm;Initial Catalog=SPMMUHCN;Data Source=PRJHKGS1\SQL2008 oleDBConnection dsDatabaseVersion VERSIONNO,System.String 30 dsDatabaseVersion oleDBConnection select dbv.versionno from databaseversion dbv where dbv.databaseversion = ( select max(dbv2.databaseversion) from databaseversion dbv2) dsProject projectno,System.String project,System.Int32 name,System.String 30 dsProject oleDBConnection dspProject,pProject,200,255 select project.project, project.projectno, project.name from project where d.inDelimStr(?, project.project, ',') = 1 order by project.project dsProjectData Period,System.String DateForReport,System.DateTime LocationCode,System.String Location,System.String Item,System.String DatePlanned,System.DateTime DateActual,System.DateTime DayDiff,System.Int32 Notes,System.String project,System.Int32 projectno,System.String FilePath,System.String 30 dsProjectData oleDBConnection select 1 as Period, MediaProgress.DateForReport, MediaLocation.code as LocationCode, MediaLocation.Description as Location, MediaProgressItem.Item, MediaProgressItem.DatePlanned, MediaProgressItem.DateActual, DATEDIFF(dd,MediaProgressItem.DatePlanned, MediaProgressItem.DateActual) as DayDiff, MediaProgressItem.Notes, project.project, project.projectno, d.concat3(SysPath.paramvalue, d.concat5('\',project.busent, '-', project.projectno,'\Project\') , d.concat3(MediaFolder.Name,'\', MediaItem.MediaFileName) ) as FilePath from MediaProgress left join MediaProgressItem on MediaProgressItem.MediaProgress = MediaProgress.MediaProgress left join MediaLocation on MediaLocation.MediaLocation = MediaProgress.MediaLocation left join MediaItem on MediaItem.MediaItem = MediaProgress.MediaItem join project on project.project = MediaLocation.Project join MediaFolder on MediaFolder.Project = project.project and MediaFolder.IsSiteProgress = 1 join (select paramvalue from kpmsystemparam where kpmsystemparam = 6026)SysPath on 1=1 where MediaProgress.DateForReport >= (select glperiod.startdate from glperiod join finyear on finyear.finyear = glperiod.finyear where finyear.busent = 1 and glperiod.glperiod = {pUptoDate}) and MediaProgress.DateForReport <= (select glperiod.finishdate from glperiod join finyear on finyear.finyear = glperiod.finyear where finyear.busent = 1 and glperiod.glperiod = {pUptoDate}) and project.project = {pProject} UNION select 2 as Period, MediaProgress.DateForReport, MediaLocation.code as LocationCode, MediaLocation.Description as Location, MediaProgressItem.Item, MediaProgressItem.DatePlanned, MediaProgressItem.DateActual, DATEDIFF(dd,MediaProgressItem.DatePlanned, MediaProgressItem.DateActual) as DayDiff, MediaProgressItem.Notes, project.project, project.projectno, d.concat3(SysPath.paramvalue, d.concat5('\',project.busent, '-', project.projectno,'\Project\') , d.concat3(MediaFolder.Name,'\', MediaItem.MediaFileName) ) as FilePath from MediaProgress left join MediaProgressItem on MediaProgressItem.MediaProgress = MediaProgress.MediaProgress left join MediaLocation on MediaLocation.MediaLocation = MediaProgress.MediaLocation left join MediaItem on MediaItem.MediaItem = MediaProgress.MediaItem join project on project.project = MediaLocation.Project join MediaFolder on MediaFolder.Project = project.project and MediaFolder.IsSiteProgress = 1 join (select paramvalue from kpmsystemparam where kpmsystemparam = 6026)SysPath on 1=1 where MediaProgress.DateForReport >= (select glperiod.startdate from glperiod where glperiod.finishdate = (select glperiod.startdate-1 from glperiod join finyear on finyear.finyear = glperiod.finyear where finyear.busent = 1 and glperiod.glperiod = {pUptoDate}) ) and MediaProgress.DateForReport <= (select glperiod.finishdate from glperiod where glperiod.finishdate = (select glperiod.startdate-1 from glperiod join finyear on finyear.finyear = glperiod.finyear where finyear.busent = 1 and glperiod.glperiod = {pUptoDate}) ) and project.project = {pProject} dsPeriod shortdescription,System.String 30 dsPeriod oleDBConnection select right(convert(varchar, glperiod.finishdate, 106), 8) as shortdescription from glperiod join finyear on finyear.finyear = glperiod.finyear where finyear.busent = {pBusinessEntity} and glperiod.glperiod = {pUptoDate} dsProjectLocation Period,System.String Seq,System.Int32 DateForReport,System.DateTime LocationCode,System.String Location,System.String FilePath,System.String 30 dsProjectLocation oleDBConnection select 1 as Period, 1 as Seq, MediaProgress.DateForReport, MediaLocation.code as LocationCode, MediaLocation.Description as Location, d.concat3(SysPath.paramvalue, d.concat5('\',project.busent, '-', project.projectno,'\Project\') , d.concat3(MediaFolder.Name,'\', MediaItem.MediaFileName) ) as FilePath from MediaProgress left join MediaProgressItem on MediaProgressItem.MediaProgress = MediaProgress.MediaProgress left join MediaLocation on MediaLocation.MediaLocation = MediaProgress.MediaLocation left join MediaItem on MediaItem.MediaItem = MediaProgress.MediaItem join project on project.project = MediaLocation.Project join MediaFolder on MediaFolder.Project = project.project and MediaFolder.IsSiteProgress = 1 join (select paramvalue from kpmsystemparam where kpmsystemparam = 6026)SysPath on 1=1 where MediaProgress.DateForReport >= (select glperiod.startdate from glperiod join finyear on finyear.finyear = glperiod.finyear where finyear.busent = 1 and glperiod.glperiod = {pUptoDate}) and MediaProgress.DateForReport <= (select glperiod.finishdate from glperiod join finyear on finyear.finyear = glperiod.finyear where finyear.busent = 1 and glperiod.glperiod = {pUptoDate}) and project.project = {pProject} UNION select 2 as Period, 2 as Seq, MediaProgress.DateForReport, MediaLocation.code as LocationCode, MediaLocation.Description as Location, d.concat3(SysPath.paramvalue, d.concat5('\',project.busent, '-', project.projectno,'\Project\') , d.concat3(MediaFolder.Name,'\', MediaItem.MediaFileName) ) as FilePath from MediaProgress left join MediaProgressItem on MediaProgressItem.MediaProgress = MediaProgress.MediaProgress left join MediaLocation on MediaLocation.MediaLocation = MediaProgress.MediaLocation left join MediaItem on MediaItem.MediaItem = MediaProgress.MediaItem join project on project.project = MediaLocation.Project join MediaFolder on MediaFolder.Project = project.project and MediaFolder.IsSiteProgress = 1 join (select paramvalue from kpmsystemparam where kpmsystemparam = 6026)SysPath on 1=1 where MediaProgress.DateForReport >= (select glperiod.startdate from glperiod where glperiod.finishdate = (select glperiod.startdate-1 from glperiod join finyear on finyear.finyear = glperiod.finyear where finyear.busent = 1 and glperiod.glperiod = {pUptoDate}) ) and MediaProgress.DateForReport <= (select glperiod.finishdate from glperiod where glperiod.finishdate = (select glperiod.startdate-1 from glperiod join finyear on finyear.finyear = glperiod.finyear where finyear.busent = 1 and glperiod.glperiod = {pUptoDate}) ) and project.project = {pProject} order by seq dsProjectLocation_ProjectData LocationCode Period dsProjectLocation_ProjectData Relation LocationCode Period ,vReportCode,vReportCode,System.String,HLDCN-DOC-0043,True,False ,vReportVersion,vReportVersion,System.String,_x0030_01,True,False ,pDatabaseName,pDatabaseName,System.String,,False,False ,pUserID,pUserID,System.String,,False,False ,pAuthUser,pAuthUser,System.String,,False,False ,pCompanyName,pCompanyName,System.String,,False,False ,pReportLogo,pReportLogo,System.String,RptLogo.bmp,False,False ,pProject,pProject,System.String,_x0031_1,False,False ,pProjectText,pProjectText,System.String,,False,False ,pUptoDate,pUptoDate,System.Int32,_x0037_7,False,False ,pUptoDateText,pUptoDateText,System.String,,False,False ,pBusinessEntity,pBusinessEntity,System.String,_x0031_,False,False ,pBusinessEntityText,pBusinessEntityText,System.String,,False,False EngineV1 None;Black;2;Solid;False;4;Black Transparent Transparent 0,0.4,40,2.8 Transparent 0.2,0.2,18.6,0.8 DFKai-SB,12,Italic 0,0,0,0 StdPageHeaderReportName {ReportName} Black Transparent 33.8,0.2,6.2,0.8 DFKai-SB,12,Italic ec7f9a1b52904a2282a63c963f42bcfe Right 0,0,0,0 Text2 编制日期： {Year(Today)}年{Month(Today)}月{Day(Today)}日 Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Transparent 33.2,1.2,6.8,0.6 DFKai-SB,12,Bold 71c33ed4456042c0b0137307d95a92d7 0,0,0,0 Text6 更新：{dsPeriod.shortdescription} Black Expression Transparent True 0.2,1.2,3.2,0.6 DFKai-SB,12,Bold 9a3b5049a8bd4f578041766daf415714 0,0,0,0 Text8 项目名称: Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Transparent True 3.4,1.2,15.4,0.6 DFKai-SB,12,Bold 7f377d1c4aab43c7b3f7a49bf13d4706 0,0,0,0 Text10 {pProjectText} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression 0,0,40,0.0254 Black Black HorizontalLine2 Black StdPageHeader ExceptFirstPage Transparent 0,26.9,40,0.8 Transparent 0,0.2,37.4,0.6 DFKai-SB,12,Italic 0,0,0,0 StdPageFooterText Report {vReportCode} (version {vReportVersion}) generated by {pUserID} on {Format("{0:dd MMMM yyyy}", Time)} at {Format("{0:HH:mm:ss}", Time)} from database {pDatabaseName} (version {dsDatabaseVersion.VERSIONNO}) Black Expression Transparent 37.8,0.2,2.2,0.6 DFKai-SB,12,Italic Right 0,0,0,0 StdPageFooterPageNumber Page {PageNumber} Black Expression 0.2,0,39.8,0.0254 Black Black StdPageFooterLine Black StdPageFooter Transparent 0,4,40,2.6 Transparent 0.2,0.8,15.6,0.7 DFKai-SB,16,Bold 0,0,0,0 StdReportHeaderReportName {ReportName} Black Transparent 0.2,0.2,16.4,0.45 DFKai-SB,12,Italic 0,0,0,0 StdReportHeaderCompanyName {pCompanyName} Black Expression Transparent 33.2,1.8,6.8,0.6 DFKai-SB,12,Bold 0,0,0,0 StdReportTitleParameter2 更新：{dsPeriod.shortdescription} Black Expression Transparent 33.8,0.4,6.2,0.6 DFKai-SB,12,Italic Right 0,0,0,0 StdReportTitleNotesText 编制日期： {Year(Today)}年{Month(Today)}月{Day(Today)}日 Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Transparent True 0.2,1.8,3.2,0.6 DFKai-SB,12,Bold 0,0,0,0 StdReportTitleParameter1 项目名称: Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Transparent True 3.4,1.8,15.4,0.6 DFKai-SB,12,Bold 739132569d894a28b80dd53581dcef13 0,0,0,0 Text4 {pProjectText} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression 0,0,40,0.0254 Black Black HorizontalLine1 Black StdReportTitle Transparent 0,7.4,40,2.2 Transparent 0,0.2,40,0.6 DFKai-SB,16,Bold 1fea9d1091714de882e8c98ff1a5824c Center 0,0,0,0 Text3 工程形象进度 Black Expression Center Transparent 0,0.8,40,0.8 DFKai-SB,16,Bold 97801e174931424d980193d8b34a2c43 Center 0,0,0,0 Text1 （按各栋大楼土建、园林、精装修等类别提供工地進度的文字描述及最新照片（同一位置/角度））（模板--允许报告人增加报告內容） Black Expression Bottom ChildBand1 All;Black;1;Solid;False;4;Black Transparent 0,10.4,40,1 All;Black;1;Solid;False;4;Black Transparent True 0,0,12,1 DFKai-SB,16,Bold 9f1945995ac14856acadd4f81648cfcb 0,0,0,0 Text5 现场部位：{dsProjectData.LocationCode} - {dsProjectData.Location} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center All;Black;1;Solid;False;4;Black Transparent 12,0,10,1 DFKai-SB,16,Bold 74a75b55bd974a1f8fab8a5ae0f960ab Center 0,0,0,0 Text23 本月施工内容 Black Expression Center All;Black;1;Solid;False;4;Black Transparent 22,0,3.8,1 DFKai-SB,16,Bold bb593525905a4bfdb9840fd6172bf1ba Center 0,0,0,0 Text24 计划 Black dd/MM/yyyy Expression Center All;Black;1;Solid;False;4;Black Transparent 25.8,0,3.8,1 DFKai-SB,16,Bold a1f8915ccd6049b981c0d9064de15d30 Center 0,0,0,0 Text25 实际 Black dd/MM/yyyy Expression Center All;Black;1;Solid;False;4;Black Transparent 34.2,0,5.8,1 DFKai-SB,16,Bold f7bf085a102e463c9eb285c33234ebc4 Center 0,0,0,0 Text26 备注 Black Expression Center All;Black;1;Solid;False;4;Black Transparent 29.6,0,4.6,1 DFKai-SB,16,Bold 2a9ef0870fb54c7a9fb4e734ca046bfa Center 0,0,0,0 Text27 提前/落后（天） Black Expression Center {dsProjectLocation.LocationCode} GroupHeaderBand1 True Transparent 0,12.2,40,0 {dsProjectLocation.Period} GroupHeaderBand2 Bottom;Black;1;Solid;False;4;Black Transparent 0,13,40,10 Transparent True 0,0,12,10 Transparent 0,9.2,12,0.8 DFKai-SB,16,Bold 0581b598dd0d492780dcf5215cb95cb5 Center 0,0,0,0 Text15 {IIF(dsProjectLocation.Period == "1","本月进度","上月进度")} Black Expression Center True Transparent 0.2,0.2,11.6,8.8 Center {dsProjectLocation.FilePath} Image1 True Center 12,10,0,0 EndPointPrimitive2 e66d43833bb440de85a2352088882369 0,10,0,0 EndPointPrimitive3 c9d6e1b8d35b4266910c7e81478832f5 True Container2 Transparent True 12,0,28,10 Transparent 0,0.4,28,0.8 All;Black;1;Solid;False;4;Black Transparent True 0,0,10,0.8 DFKai-SB,16 51da94c9929749898f91e48db1fb7d26 0,0,0,0 Text9 {dsProjectData.Item} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, Expression Center All;Black;1;Solid;False;4;Black Transparent 10,0,3.8,0.8 DFKai-SB,16 d775814c930247008147d4d861d9999a Center 0,0,0,0 Text11 {dsProjectData.DatePlanned} Black dd/MM/yyyy DataColumn Center All;Black;1;Solid;False;4;Black Transparent 13.8,0,3.8,0.8 DFKai-SB,16 87cf9ef48dc842d7879000ed3bc91096 Center 0,0,0,0 Text12 {dsProjectData.DateActual} Black dd/MM/yyyy DataColumn Center All;Black;1;Solid;False;4;Black Transparent True 22.2,0,5.8,0.8 DFKai-SB,16 d89263fec65f4002b4010b152ddaeda3 0,0,0,0 Text13 {dsProjectData.Notes} Black HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20, DataColumn Center All;Black;1;Solid;False;4;Black Transparent 17.6,0,4.6,0.8 DFKai-SB,16 debebc146ea149d2abc07a79f866c028 Center 0,0,0,0 Text14 {dsProjectData.DayDiff} Black Expression Center Relation dsProjectData _x007B_dsProjectData.Item_x0020__x0021__x003D__x0020__x0022__x0022__x007D_ DataBand2 10,10,0,0 EndPointPrimitive1 8af95d9eb41a48bda486c8679839dca9 22.2,10,0,0 EndPointPrimitive10 0fdf7d43d67a4864a43780b73d997a94 17.6,10,0,0 EndPointPrimitive11 e5232b31ce4e4de4befdf16511e29c97 13.8,10,0,0 EndPointPrimitive12 d8d22863eefc424490d6220808dc9107 28,10,0,0 EndPointPrimitive4 f3ace684d08a4380891a44a16219ffe7 True Container1 12,-0.4,0,0 StartPointPrimitive2 e66d43833bb440de85a2352088882369 22,-0.4,0,0 StartPointPrimitive1 8af95d9eb41a48bda486c8679839dca9 25.8,-0.4,0,0 StartPointPrimitive12 d8d22863eefc424490d6220808dc9107 29.6,-0.4,0,0 StartPointPrimitive11 e5232b31ce4e4de4befdf16511e29c97 34.2,-0.4,0,0 StartPointPrimitive10 0fdf7d43d67a4864a43780b73d997a94 0,-0.4,0,0 StartPointPrimitive3 c9d6e1b8d35b4266910c7e81478832f5 40,-0.4,0,0 StartPointPrimitive4 f3ace684d08a4380891a44a16219ffe7 dsProjectLocation DataBand1 DESC Seq Transparent 0,23.8,40,0 GroupFooterBand2 Transparent 0,24.6,40,0 GroupFooterBand1 22,12.6,0.0254,10.4 Black Black 8af95d9eb41a48bda486c8679839dca9 VerticalLinePrimitive1 Black 12,12.6,0.0254,10.4 Black Black e66d43833bb440de85a2352088882369 VerticalLinePrimitive2 Black 34.2,12.6,0.0254,10.4 Black Black 0fdf7d43d67a4864a43780b73d997a94 VerticalLinePrimitive10 Black 29.6,12.6,0.0254,10.4 Black Black e5232b31ce4e4de4befdf16511e29c97 VerticalLinePrimitive11 Black 25.8,12.6,0.0254,10.4 Black Black d8d22863eefc424490d6220808dc9107 VerticalLinePrimitive12 Black 0,12.6,0.0254,10.4 Black Black c9d6e1b8d35b4266910c7e81478832f5 VerticalLinePrimitive3 Black 40,12.6,0.0254,10.4 Black Black f3ace684d08a4380891a44a16219ffe7 VerticalLinePrimitive4 Black 13b67299979c4eaea5e3ae1f31d0dedc 1,1,1,1 Page1 Landscape 29.7 42 A3 True Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll 项目月报 - 工程形象进度 Projection 5/6/2013 9:39:25 AM 9/27/2007 4:24:26 PM C:\Documents and Settings\chl\My Documents\HLDCN SS Reports\SS 2011\PM2 Monthly Report by Period\A3\HLDCN-DOC-0043.mrt 7c279c93597047ebae6b24a551560b68 项目月报 - 工程形象进度 Centimeters 2011.1.919 CSharp