{"id":340,"date":"2025-10-31T03:00:00","date_gmt":"2025-10-30T19:00:00","guid":{"rendered":"http:\/\/pipingpig.com\/index.php\/2025\/10\/31\/smart3d-0685\/"},"modified":"2026-08-20T19:50:14","modified_gmt":"2026-08-20T11:50:14","slug":"smart3d-0685","status":"publish","type":"post","link":"https:\/\/www.pipingpig.com\/index.php\/2025\/10\/31\/smart3d-0685\/","title":{"rendered":"Smart 3D\u67e5\u8be2\u793a\u4f8b\u4ee3\u7801"},"content":{"rendered":"
\n
<\/section>\n
<\/section>\n
public override DataTable Execute( string action, string argument)\n        {\n            try\n            {\n                \/\/ Create a record DataColumn list that will contain all the\n                \/\/ column DataColumns\n                List FieldColumnList = new List();\n                Column recFieldColumnOID = new Column("OID", typeof(System.String));\n                FieldColumnList.Add(recFieldColumnOID);\n                Column recFieldColumnName = new Column( "name", typeof(System.String) );\n                FieldColumnList.Add( recFieldColumnName );\n                Column recFieldColumnDryWeight = new Column( "Dry Weight", typeof(System.Double) );\n                FieldColumnList.Add(recFieldColumnDryWeight);\n                Column recFieldColumnTime = new Column( "Date Created", typeof(System.DateTime) );\n                FieldColumnList.Add( recFieldColumnTime );\n                Column recApprovalState = new Column( "Approval State", typeof(System.String) ) ;\n                FieldColumnList.Add( recApprovalState );\n                Column recFieldColumnDotNetLabel = new Column( "DotNetLabel", typeof(System.String) );\n                FieldColumnList.Add( recFieldColumnDotNetLabel );\n                \/\/ create and initialize the Data Table with the Columns ( user added\n                \/\/ columns and returned properties from the Delegated Query)\n                m_DataTable = InitializeDataTable( FieldColumnList );\n                \/\/ if the Evaluate property is set to true that means we need to\n                \/\/ return the data table with only columns names to the designer\n                \/\/ so that the control can display the column names at the design time\n                \/\/ The Query Builder calls the Execute with Evaluate set to true\n                if( EvaluateOnly )\n                {\n                    return m_DataTable;\n                }\n                \/\/ loop through all the objects in the input objects\n                foreach ( BusinessObject oBO in InputObjects )\n                {\n                    double dryWeightVal = 0.0;\n                    \/\/ check if the Business Object supports the IJWeight.\n                    if( oBO.SupportsInterface( "IJWeightCG" ) )\n                    {\n                        PropertyValueDouble dblWeight = ( PropertyValueDouble )oBO.GetPropertyValue( "IJWeightCG", "DryWeight" );\n                        if ( null != dblWeight.PropValue )\n                        {\n                            dryWeightVal = (double)dblWeight.PropValue;\n                        }\n                    }\n                    \/\/ data row to hold the data for current object\n                    DataRow currentRow = m_DataTable.NewRow();\n                    currentRow.SetField("OID", oBO.ObjectID.ToString());\n                    currentRow.SetField("name", oBO.ToString());\n                    currentRow.SetField("Dry Weight", dryWeightVal);\n                    \/\/ Removed *time* portion of date created since it is highly dependent on\n                    \/\/ the local time zone and will therefore not match the baseline for other zones.\n                    currentRow.SetField("Date Created", oBO.DateCreated.Date);\n                    currentRow.SetField("Approval State", oBO.ApprovalStatus.ToString());\n                    currentRow.SetField("DotNetLabel", "[Equipment Properties]");\n                    \/\/ Execute the Delegated Query.\n                    System.Data.DataTable DelegatedDataTable = ExecuteDelegatedQuery(oBO);\n                    \/\/ add the new row with the value  to the record set\n                    if ( DelegatedDataTable != null )\n                    {\n                        if ( DelegatedDataTable.Rows.Count >= 1 )\n                        {\n                            DataRow row = DelegatedDataTable.Rows[0];\n                            \/\/ merge the column value pair to data table, excluding the oid column\n                            foreach ( DataColumn col in row.Table.Columns )\n                            {\n                                if (col.ColumnName.ToLower() != "oid")\n                                {\n                                    currentRow.SetField(col.ColumnName, row[col.ColumnName]);\n                                }\n                            }\n                        }\n                    }\n                    \/\/ add the new row to the master data table\n                    m_DataTable.Rows.Add(currentRow);\n                }\n                return m_DataTable;\n            }\n            catch ( Exception e )\n            {\n                MiddleServiceProvider.ErrorLogger.Log(0, typeof(ExampleQueryInterpreter).FullName, e.ToString(), string.Empty, (new StackTrace()).GetFrame(1).GetMethod().Name, string.Empty, string.Empty, -1);\n                throw;\n            }\n        }\n    }<\/code><\/pre>\n

<\/span><\/span><\/p>\n

<\/span><\/span><\/p>\n

<\/span><\/span><\/p>\n
\u76f8\u5173\u9605\u8bfb\uff1a<\/span><\/span><\/p>\n
Smart3D\u4e8c\u6b21\u5f00\u53d1\u8d44\u6e90\u7b80\u4ecb<\/a><\/span><\/span><\/p>\n
Intergraph Smart\u00ae 3D\u81ea\u5b9a\u4e49\u547d\u4ee4\u90e8\u7f72\u65b9\u5f0f\u53ca\u81ea\u5b9a\u4e49\u5de5\u5177\u6761\u5f00\u53d1\u7b80\u8ff0<\/a><\/span><\/span><\/p>\n
Update\u547d\u4ee4\u4f18\u5316<\/a><\/span><\/span><\/p>\n
Smart 3D\u4e2d\u793a\u4f8b\u547d\u540d\u89c4\u5219<\/a><\/span><\/span><\/p>\n

<\/span><\/span><\/p>\n

<\/span><\/section>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
public override DataTable Execute( string action, strin […]<\/p>\n","protected":false},"author":1,"featured_media":338,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[9,28,15],"tags":[],"class_list":["post-340","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-smart3d","category-dev","category-15"],"_links":{"self":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts\/340","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/comments?post=340"}],"version-history":[{"count":5,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts\/340\/revisions"}],"predecessor-version":[{"id":8360,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/posts\/340\/revisions\/8360"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/media\/338"}],"wp:attachment":[{"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/media?parent=340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/categories?post=340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pipingpig.com\/index.php\/wp-json\/wp\/v2\/tags?post=340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}