diff --git a/ClassSearchAnalysis.cs b/ClassSearchAnalysis.cs index 61f667e..52e8cdb 100644 --- a/ClassSearchAnalysis.cs +++ b/ClassSearchAnalysis.cs @@ -77,22 +77,11 @@ /// public static DataTable ResultDistinctDataTable(out DataTable dt,string layerName,string filedObject) { - string sql = "select distinct "+filedObject+" from " + layerName; + string sql = "select distinct " + filedObject + " from " + layerName + " order by " + filedObject; dt = OledbHelper.QueryTable(sql); return dt; } /// - /// SQL查询不重复的值+排序 - /// - /// - /// - /// - /// - public static DataTable ResultDistinceDataTableOrder(out DataTable dt, string layerName, string filedObject) - { - - } - /// /// SQL查询,返回包含NULL的Table /// /// diff --git a/ClassSearchAnalysis.cs b/ClassSearchAnalysis.cs index 61f667e..52e8cdb 100644 --- a/ClassSearchAnalysis.cs +++ b/ClassSearchAnalysis.cs @@ -77,22 +77,11 @@ /// public static DataTable ResultDistinctDataTable(out DataTable dt,string layerName,string filedObject) { - string sql = "select distinct "+filedObject+" from " + layerName; + string sql = "select distinct " + filedObject + " from " + layerName + " order by " + filedObject; dt = OledbHelper.QueryTable(sql); return dt; } /// - /// SQL查询不重复的值+排序 - /// - /// - /// - /// - /// - public static DataTable ResultDistinceDataTableOrder(out DataTable dt, string layerName, string filedObject) - { - - } - /// /// SQL查询,返回包含NULL的Table /// /// diff --git a/Cyberpipe.suo b/Cyberpipe.suo index 221e34d..5e7841c 100644 --- a/Cyberpipe.suo +++ b/Cyberpipe.suo Binary files differ diff --git a/ClassSearchAnalysis.cs b/ClassSearchAnalysis.cs index 61f667e..52e8cdb 100644 --- a/ClassSearchAnalysis.cs +++ b/ClassSearchAnalysis.cs @@ -77,22 +77,11 @@ /// public static DataTable ResultDistinctDataTable(out DataTable dt,string layerName,string filedObject) { - string sql = "select distinct "+filedObject+" from " + layerName; + string sql = "select distinct " + filedObject + " from " + layerName + " order by " + filedObject; dt = OledbHelper.QueryTable(sql); return dt; } /// - /// SQL查询不重复的值+排序 - /// - /// - /// - /// - /// - public static DataTable ResultDistinceDataTableOrder(out DataTable dt, string layerName, string filedObject) - { - - } - /// /// SQL查询,返回包含NULL的Table /// /// diff --git a/Cyberpipe.suo b/Cyberpipe.suo index 221e34d..5e7841c 100644 --- a/Cyberpipe.suo +++ b/Cyberpipe.suo Binary files differ diff --git a/FrmQuerySQL.cs b/FrmQuerySQL.cs index 4260509..f5b4c8f 100644 --- a/FrmQuerySQL.cs +++ b/FrmQuerySQL.cs @@ -192,7 +192,7 @@ } } - ClassSearchAnalysis.ResultDistinctDataTable(table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); + ClassSearchAnalysis.ResultDistinctDataTable(out table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); for (int i = 0; i < table.Rows.Count; i++) { diff --git a/ClassSearchAnalysis.cs b/ClassSearchAnalysis.cs index 61f667e..52e8cdb 100644 --- a/ClassSearchAnalysis.cs +++ b/ClassSearchAnalysis.cs @@ -77,22 +77,11 @@ /// public static DataTable ResultDistinctDataTable(out DataTable dt,string layerName,string filedObject) { - string sql = "select distinct "+filedObject+" from " + layerName; + string sql = "select distinct " + filedObject + " from " + layerName + " order by " + filedObject; dt = OledbHelper.QueryTable(sql); return dt; } /// - /// SQL查询不重复的值+排序 - /// - /// - /// - /// - /// - public static DataTable ResultDistinceDataTableOrder(out DataTable dt, string layerName, string filedObject) - { - - } - /// /// SQL查询,返回包含NULL的Table /// /// diff --git a/Cyberpipe.suo b/Cyberpipe.suo index 221e34d..5e7841c 100644 --- a/Cyberpipe.suo +++ b/Cyberpipe.suo Binary files differ diff --git a/FrmQuerySQL.cs b/FrmQuerySQL.cs index 4260509..f5b4c8f 100644 --- a/FrmQuerySQL.cs +++ b/FrmQuerySQL.cs @@ -192,7 +192,7 @@ } } - ClassSearchAnalysis.ResultDistinctDataTable(table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); + ClassSearchAnalysis.ResultDistinctDataTable(out table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); for (int i = 0; i < table.Rows.Count; i++) { diff --git a/bin/x86/Debug/Cyberpipe.exe b/bin/x86/Debug/Cyberpipe.exe index 44feaae..d75f8f0 100644 --- a/bin/x86/Debug/Cyberpipe.exe +++ b/bin/x86/Debug/Cyberpipe.exe Binary files differ diff --git a/ClassSearchAnalysis.cs b/ClassSearchAnalysis.cs index 61f667e..52e8cdb 100644 --- a/ClassSearchAnalysis.cs +++ b/ClassSearchAnalysis.cs @@ -77,22 +77,11 @@ /// public static DataTable ResultDistinctDataTable(out DataTable dt,string layerName,string filedObject) { - string sql = "select distinct "+filedObject+" from " + layerName; + string sql = "select distinct " + filedObject + " from " + layerName + " order by " + filedObject; dt = OledbHelper.QueryTable(sql); return dt; } /// - /// SQL查询不重复的值+排序 - /// - /// - /// - /// - /// - public static DataTable ResultDistinceDataTableOrder(out DataTable dt, string layerName, string filedObject) - { - - } - /// /// SQL查询,返回包含NULL的Table /// /// diff --git a/Cyberpipe.suo b/Cyberpipe.suo index 221e34d..5e7841c 100644 --- a/Cyberpipe.suo +++ b/Cyberpipe.suo Binary files differ diff --git a/FrmQuerySQL.cs b/FrmQuerySQL.cs index 4260509..f5b4c8f 100644 --- a/FrmQuerySQL.cs +++ b/FrmQuerySQL.cs @@ -192,7 +192,7 @@ } } - ClassSearchAnalysis.ResultDistinctDataTable(table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); + ClassSearchAnalysis.ResultDistinctDataTable(out table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); for (int i = 0; i < table.Rows.Count; i++) { diff --git a/bin/x86/Debug/Cyberpipe.exe b/bin/x86/Debug/Cyberpipe.exe index 44feaae..d75f8f0 100644 --- a/bin/x86/Debug/Cyberpipe.exe +++ b/bin/x86/Debug/Cyberpipe.exe Binary files differ diff --git a/bin/x86/Debug/Cyberpipe.pdb b/bin/x86/Debug/Cyberpipe.pdb index 8516cd3..01cc654 100644 --- a/bin/x86/Debug/Cyberpipe.pdb +++ b/bin/x86/Debug/Cyberpipe.pdb Binary files differ diff --git a/ClassSearchAnalysis.cs b/ClassSearchAnalysis.cs index 61f667e..52e8cdb 100644 --- a/ClassSearchAnalysis.cs +++ b/ClassSearchAnalysis.cs @@ -77,22 +77,11 @@ /// public static DataTable ResultDistinctDataTable(out DataTable dt,string layerName,string filedObject) { - string sql = "select distinct "+filedObject+" from " + layerName; + string sql = "select distinct " + filedObject + " from " + layerName + " order by " + filedObject; dt = OledbHelper.QueryTable(sql); return dt; } /// - /// SQL查询不重复的值+排序 - /// - /// - /// - /// - /// - public static DataTable ResultDistinceDataTableOrder(out DataTable dt, string layerName, string filedObject) - { - - } - /// /// SQL查询,返回包含NULL的Table /// /// diff --git a/Cyberpipe.suo b/Cyberpipe.suo index 221e34d..5e7841c 100644 --- a/Cyberpipe.suo +++ b/Cyberpipe.suo Binary files differ diff --git a/FrmQuerySQL.cs b/FrmQuerySQL.cs index 4260509..f5b4c8f 100644 --- a/FrmQuerySQL.cs +++ b/FrmQuerySQL.cs @@ -192,7 +192,7 @@ } } - ClassSearchAnalysis.ResultDistinctDataTable(table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); + ClassSearchAnalysis.ResultDistinctDataTable(out table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); for (int i = 0; i < table.Rows.Count; i++) { diff --git a/bin/x86/Debug/Cyberpipe.exe b/bin/x86/Debug/Cyberpipe.exe index 44feaae..d75f8f0 100644 --- a/bin/x86/Debug/Cyberpipe.exe +++ b/bin/x86/Debug/Cyberpipe.exe Binary files differ diff --git a/bin/x86/Debug/Cyberpipe.pdb b/bin/x86/Debug/Cyberpipe.pdb index 8516cd3..01cc654 100644 --- a/bin/x86/Debug/Cyberpipe.pdb +++ b/bin/x86/Debug/Cyberpipe.pdb Binary files differ diff --git a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache index fb27b29..5f45ee7 100644 --- a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache +++ b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache Binary files differ diff --git a/ClassSearchAnalysis.cs b/ClassSearchAnalysis.cs index 61f667e..52e8cdb 100644 --- a/ClassSearchAnalysis.cs +++ b/ClassSearchAnalysis.cs @@ -77,22 +77,11 @@ /// public static DataTable ResultDistinctDataTable(out DataTable dt,string layerName,string filedObject) { - string sql = "select distinct "+filedObject+" from " + layerName; + string sql = "select distinct " + filedObject + " from " + layerName + " order by " + filedObject; dt = OledbHelper.QueryTable(sql); return dt; } /// - /// SQL查询不重复的值+排序 - /// - /// - /// - /// - /// - public static DataTable ResultDistinceDataTableOrder(out DataTable dt, string layerName, string filedObject) - { - - } - /// /// SQL查询,返回包含NULL的Table /// /// diff --git a/Cyberpipe.suo b/Cyberpipe.suo index 221e34d..5e7841c 100644 --- a/Cyberpipe.suo +++ b/Cyberpipe.suo Binary files differ diff --git a/FrmQuerySQL.cs b/FrmQuerySQL.cs index 4260509..f5b4c8f 100644 --- a/FrmQuerySQL.cs +++ b/FrmQuerySQL.cs @@ -192,7 +192,7 @@ } } - ClassSearchAnalysis.ResultDistinctDataTable(table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); + ClassSearchAnalysis.ResultDistinctDataTable(out table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); for (int i = 0; i < table.Rows.Count; i++) { diff --git a/bin/x86/Debug/Cyberpipe.exe b/bin/x86/Debug/Cyberpipe.exe index 44feaae..d75f8f0 100644 --- a/bin/x86/Debug/Cyberpipe.exe +++ b/bin/x86/Debug/Cyberpipe.exe Binary files differ diff --git a/bin/x86/Debug/Cyberpipe.pdb b/bin/x86/Debug/Cyberpipe.pdb index 8516cd3..01cc654 100644 --- a/bin/x86/Debug/Cyberpipe.pdb +++ b/bin/x86/Debug/Cyberpipe.pdb Binary files differ diff --git a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache index fb27b29..5f45ee7 100644 --- a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache +++ b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache Binary files differ diff --git a/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt b/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt index 656e8cd..7ae40aa 100644 --- a/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt +++ b/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt @@ -170,3 +170,175 @@ E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.SysRescInfoManager.resources E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.read.1.tlog E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.write.1.tlog +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.exe.config +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.csproj.ResolveComReference.cache +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.exe +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.pdb +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.exe +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.pdb +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\office.dll +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\office.xml +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\ResolveAssemblyReference.cache +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1数据输入输出.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1添加文件.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1添加项目.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FormDocumentManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmAddYuBiZiShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGBJCresult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmWait.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\PipeLine.Forms.FrmAddPipelineCoordinate.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGongShuiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmMnModify.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPipelineModelDataOneStep.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmShLayers.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmShRK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmTongXunAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmAddWellShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccess.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoriesgather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoryAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddValve.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddWellShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddYuBiZiShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAllWorkWellStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAnalysisGuiHuaResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPP.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPAuditor.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPFORASK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPFORASKReason.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPregion.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAppUSER.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAppUSERRESET.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBACKORACLE.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBSQDuoBianXingStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBSQStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBufferAnalysisBSQ.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmChangePassword.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCheckHistory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCodingQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCompareFeature.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCreateUser.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCustomLabel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDataBaseOpt.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDatabaseParaSetting2.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDbManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDocumentEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDownloadProgress.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmExportCADS.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlySetDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBasicQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBoosterValvers.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBufferAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDatabaseParaSetting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DigFillAnalysisDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBaseLineProfillAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGenAndFaMenTopu.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGenTopo.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCloseValves.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDigPitSetting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFittingQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlow.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlyToPosition.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFolderSelecter.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFTAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGBJC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGenAndFaMenTopu.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGHRK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHotFuncStat.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHotFuncStatTitle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmKeywordQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLayerControl.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogDescription.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogin.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogOper.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMDDictory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadata.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadataOutput.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadataStat.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMultiPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmOperMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPerm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPermMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeDeepstatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeDiametergather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Frmpipediameterstatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeMaterialGather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPaiShuiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmProject.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmRanQiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddPipeFitting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAllPipelineStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDiameterQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFWPipeLineStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRedlineResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleInfoManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleRescManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmShResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoManger.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoPassword.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmThreeOracle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRole.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValveStatistics.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMaterialSel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.frmPipeSetEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmProfileAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPropertiesMarker.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmOper.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQueryHistory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQueryMessage.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQuerySensorAlarm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegion.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionType.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionTypeMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRESC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRESCMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRole.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetGoalLayer.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmTackPolygonDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHDMAnalysis3.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLineCoordinate.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQuerySQL.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserAdd.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRepo.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRepoMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValiData.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmYJSHTC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Frm_password_reset.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSfiles.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSinout.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSProjedits.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.MainFrm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCreateTunnel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCitySevenLineType.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile_AddField.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile_DeleteField.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmExportVector.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFloodAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCityServerLineAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMarker.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPipelineIndented.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMFiles.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMInout.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMTitle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMProjedit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Properties.Resources.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetLatLonPos.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSceneLightSet.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetFlytoPos.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoriesSensor.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValiDataShowErrorMessage.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddInstrument.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.SysRescInfoManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.read.1.tlog +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.write.1.tlog diff --git a/ClassSearchAnalysis.cs b/ClassSearchAnalysis.cs index 61f667e..52e8cdb 100644 --- a/ClassSearchAnalysis.cs +++ b/ClassSearchAnalysis.cs @@ -77,22 +77,11 @@ /// public static DataTable ResultDistinctDataTable(out DataTable dt,string layerName,string filedObject) { - string sql = "select distinct "+filedObject+" from " + layerName; + string sql = "select distinct " + filedObject + " from " + layerName + " order by " + filedObject; dt = OledbHelper.QueryTable(sql); return dt; } /// - /// SQL查询不重复的值+排序 - /// - /// - /// - /// - /// - public static DataTable ResultDistinceDataTableOrder(out DataTable dt, string layerName, string filedObject) - { - - } - /// /// SQL查询,返回包含NULL的Table /// /// diff --git a/Cyberpipe.suo b/Cyberpipe.suo index 221e34d..5e7841c 100644 --- a/Cyberpipe.suo +++ b/Cyberpipe.suo Binary files differ diff --git a/FrmQuerySQL.cs b/FrmQuerySQL.cs index 4260509..f5b4c8f 100644 --- a/FrmQuerySQL.cs +++ b/FrmQuerySQL.cs @@ -192,7 +192,7 @@ } } - ClassSearchAnalysis.ResultDistinctDataTable(table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); + ClassSearchAnalysis.ResultDistinctDataTable(out table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); for (int i = 0; i < table.Rows.Count; i++) { diff --git a/bin/x86/Debug/Cyberpipe.exe b/bin/x86/Debug/Cyberpipe.exe index 44feaae..d75f8f0 100644 --- a/bin/x86/Debug/Cyberpipe.exe +++ b/bin/x86/Debug/Cyberpipe.exe Binary files differ diff --git a/bin/x86/Debug/Cyberpipe.pdb b/bin/x86/Debug/Cyberpipe.pdb index 8516cd3..01cc654 100644 --- a/bin/x86/Debug/Cyberpipe.pdb +++ b/bin/x86/Debug/Cyberpipe.pdb Binary files differ diff --git a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache index fb27b29..5f45ee7 100644 --- a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache +++ b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache Binary files differ diff --git a/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt b/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt index 656e8cd..7ae40aa 100644 --- a/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt +++ b/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt @@ -170,3 +170,175 @@ E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.SysRescInfoManager.resources E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.read.1.tlog E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.write.1.tlog +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.exe.config +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.csproj.ResolveComReference.cache +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.exe +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.pdb +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.exe +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.pdb +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\office.dll +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\office.xml +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\ResolveAssemblyReference.cache +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1数据输入输出.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1添加文件.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1添加项目.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FormDocumentManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmAddYuBiZiShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGBJCresult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmWait.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\PipeLine.Forms.FrmAddPipelineCoordinate.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGongShuiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmMnModify.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPipelineModelDataOneStep.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmShLayers.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmShRK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmTongXunAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmAddWellShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccess.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoriesgather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoryAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddValve.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddWellShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddYuBiZiShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAllWorkWellStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAnalysisGuiHuaResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPP.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPAuditor.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPFORASK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPFORASKReason.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPregion.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAppUSER.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAppUSERRESET.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBACKORACLE.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBSQDuoBianXingStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBSQStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBufferAnalysisBSQ.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmChangePassword.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCheckHistory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCodingQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCompareFeature.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCreateUser.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCustomLabel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDataBaseOpt.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDatabaseParaSetting2.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDbManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDocumentEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDownloadProgress.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmExportCADS.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlySetDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBasicQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBoosterValvers.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBufferAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDatabaseParaSetting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DigFillAnalysisDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBaseLineProfillAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGenAndFaMenTopu.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGenTopo.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCloseValves.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDigPitSetting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFittingQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlow.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlyToPosition.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFolderSelecter.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFTAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGBJC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGenAndFaMenTopu.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGHRK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHotFuncStat.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHotFuncStatTitle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmKeywordQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLayerControl.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogDescription.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogin.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogOper.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMDDictory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadata.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadataOutput.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadataStat.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMultiPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmOperMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPerm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPermMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeDeepstatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeDiametergather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Frmpipediameterstatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeMaterialGather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPaiShuiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmProject.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmRanQiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddPipeFitting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAllPipelineStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDiameterQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFWPipeLineStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRedlineResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleInfoManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleRescManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmShResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoManger.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoPassword.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmThreeOracle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRole.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValveStatistics.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMaterialSel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.frmPipeSetEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmProfileAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPropertiesMarker.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmOper.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQueryHistory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQueryMessage.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQuerySensorAlarm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegion.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionType.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionTypeMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRESC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRESCMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRole.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetGoalLayer.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmTackPolygonDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHDMAnalysis3.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLineCoordinate.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQuerySQL.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserAdd.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRepo.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRepoMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValiData.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmYJSHTC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Frm_password_reset.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSfiles.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSinout.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSProjedits.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.MainFrm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCreateTunnel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCitySevenLineType.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile_AddField.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile_DeleteField.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmExportVector.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFloodAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCityServerLineAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMarker.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPipelineIndented.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMFiles.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMInout.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMTitle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMProjedit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Properties.Resources.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetLatLonPos.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSceneLightSet.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetFlytoPos.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoriesSensor.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValiDataShowErrorMessage.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddInstrument.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.SysRescInfoManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.read.1.tlog +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.write.1.tlog diff --git a/obj/x64/Debug/Cyberpipe.exe b/obj/x64/Debug/Cyberpipe.exe index 44feaae..d75f8f0 100644 --- a/obj/x64/Debug/Cyberpipe.exe +++ b/obj/x64/Debug/Cyberpipe.exe Binary files differ diff --git a/ClassSearchAnalysis.cs b/ClassSearchAnalysis.cs index 61f667e..52e8cdb 100644 --- a/ClassSearchAnalysis.cs +++ b/ClassSearchAnalysis.cs @@ -77,22 +77,11 @@ /// public static DataTable ResultDistinctDataTable(out DataTable dt,string layerName,string filedObject) { - string sql = "select distinct "+filedObject+" from " + layerName; + string sql = "select distinct " + filedObject + " from " + layerName + " order by " + filedObject; dt = OledbHelper.QueryTable(sql); return dt; } /// - /// SQL查询不重复的值+排序 - /// - /// - /// - /// - /// - public static DataTable ResultDistinceDataTableOrder(out DataTable dt, string layerName, string filedObject) - { - - } - /// /// SQL查询,返回包含NULL的Table /// /// diff --git a/Cyberpipe.suo b/Cyberpipe.suo index 221e34d..5e7841c 100644 --- a/Cyberpipe.suo +++ b/Cyberpipe.suo Binary files differ diff --git a/FrmQuerySQL.cs b/FrmQuerySQL.cs index 4260509..f5b4c8f 100644 --- a/FrmQuerySQL.cs +++ b/FrmQuerySQL.cs @@ -192,7 +192,7 @@ } } - ClassSearchAnalysis.ResultDistinctDataTable(table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); + ClassSearchAnalysis.ResultDistinctDataTable(out table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); for (int i = 0; i < table.Rows.Count; i++) { diff --git a/bin/x86/Debug/Cyberpipe.exe b/bin/x86/Debug/Cyberpipe.exe index 44feaae..d75f8f0 100644 --- a/bin/x86/Debug/Cyberpipe.exe +++ b/bin/x86/Debug/Cyberpipe.exe Binary files differ diff --git a/bin/x86/Debug/Cyberpipe.pdb b/bin/x86/Debug/Cyberpipe.pdb index 8516cd3..01cc654 100644 --- a/bin/x86/Debug/Cyberpipe.pdb +++ b/bin/x86/Debug/Cyberpipe.pdb Binary files differ diff --git a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache index fb27b29..5f45ee7 100644 --- a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache +++ b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache Binary files differ diff --git a/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt b/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt index 656e8cd..7ae40aa 100644 --- a/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt +++ b/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt @@ -170,3 +170,175 @@ E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.SysRescInfoManager.resources E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.read.1.tlog E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.write.1.tlog +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.exe.config +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.csproj.ResolveComReference.cache +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.exe +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.pdb +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.exe +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.pdb +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\office.dll +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\office.xml +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\ResolveAssemblyReference.cache +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1数据输入输出.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1添加文件.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1添加项目.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FormDocumentManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmAddYuBiZiShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGBJCresult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmWait.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\PipeLine.Forms.FrmAddPipelineCoordinate.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGongShuiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmMnModify.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPipelineModelDataOneStep.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmShLayers.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmShRK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmTongXunAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmAddWellShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccess.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoriesgather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoryAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddValve.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddWellShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddYuBiZiShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAllWorkWellStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAnalysisGuiHuaResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPP.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPAuditor.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPFORASK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPFORASKReason.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPregion.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAppUSER.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAppUSERRESET.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBACKORACLE.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBSQDuoBianXingStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBSQStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBufferAnalysisBSQ.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmChangePassword.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCheckHistory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCodingQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCompareFeature.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCreateUser.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCustomLabel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDataBaseOpt.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDatabaseParaSetting2.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDbManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDocumentEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDownloadProgress.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmExportCADS.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlySetDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBasicQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBoosterValvers.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBufferAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDatabaseParaSetting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DigFillAnalysisDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBaseLineProfillAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGenAndFaMenTopu.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGenTopo.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCloseValves.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDigPitSetting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFittingQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlow.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlyToPosition.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFolderSelecter.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFTAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGBJC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGenAndFaMenTopu.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGHRK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHotFuncStat.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHotFuncStatTitle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmKeywordQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLayerControl.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogDescription.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogin.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogOper.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMDDictory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadata.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadataOutput.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadataStat.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMultiPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmOperMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPerm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPermMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeDeepstatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeDiametergather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Frmpipediameterstatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeMaterialGather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPaiShuiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmProject.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmRanQiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddPipeFitting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAllPipelineStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDiameterQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFWPipeLineStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRedlineResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleInfoManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleRescManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmShResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoManger.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoPassword.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmThreeOracle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRole.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValveStatistics.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMaterialSel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.frmPipeSetEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmProfileAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPropertiesMarker.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmOper.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQueryHistory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQueryMessage.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQuerySensorAlarm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegion.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionType.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionTypeMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRESC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRESCMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRole.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetGoalLayer.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmTackPolygonDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHDMAnalysis3.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLineCoordinate.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQuerySQL.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserAdd.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRepo.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRepoMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValiData.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmYJSHTC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Frm_password_reset.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSfiles.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSinout.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSProjedits.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.MainFrm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCreateTunnel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCitySevenLineType.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile_AddField.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile_DeleteField.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmExportVector.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFloodAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCityServerLineAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMarker.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPipelineIndented.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMFiles.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMInout.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMTitle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMProjedit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Properties.Resources.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetLatLonPos.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSceneLightSet.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetFlytoPos.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoriesSensor.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValiDataShowErrorMessage.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddInstrument.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.SysRescInfoManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.read.1.tlog +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.write.1.tlog diff --git a/obj/x64/Debug/Cyberpipe.exe b/obj/x64/Debug/Cyberpipe.exe index 44feaae..d75f8f0 100644 --- a/obj/x64/Debug/Cyberpipe.exe +++ b/obj/x64/Debug/Cyberpipe.exe Binary files differ diff --git a/obj/x64/Debug/Cyberpipe.pdb b/obj/x64/Debug/Cyberpipe.pdb index 8516cd3..01cc654 100644 --- a/obj/x64/Debug/Cyberpipe.pdb +++ b/obj/x64/Debug/Cyberpipe.pdb Binary files differ diff --git a/ClassSearchAnalysis.cs b/ClassSearchAnalysis.cs index 61f667e..52e8cdb 100644 --- a/ClassSearchAnalysis.cs +++ b/ClassSearchAnalysis.cs @@ -77,22 +77,11 @@ /// public static DataTable ResultDistinctDataTable(out DataTable dt,string layerName,string filedObject) { - string sql = "select distinct "+filedObject+" from " + layerName; + string sql = "select distinct " + filedObject + " from " + layerName + " order by " + filedObject; dt = OledbHelper.QueryTable(sql); return dt; } /// - /// SQL查询不重复的值+排序 - /// - /// - /// - /// - /// - public static DataTable ResultDistinceDataTableOrder(out DataTable dt, string layerName, string filedObject) - { - - } - /// /// SQL查询,返回包含NULL的Table /// /// diff --git a/Cyberpipe.suo b/Cyberpipe.suo index 221e34d..5e7841c 100644 --- a/Cyberpipe.suo +++ b/Cyberpipe.suo Binary files differ diff --git a/FrmQuerySQL.cs b/FrmQuerySQL.cs index 4260509..f5b4c8f 100644 --- a/FrmQuerySQL.cs +++ b/FrmQuerySQL.cs @@ -192,7 +192,7 @@ } } - ClassSearchAnalysis.ResultDistinctDataTable(table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); + ClassSearchAnalysis.ResultDistinctDataTable(out table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); for (int i = 0; i < table.Rows.Count; i++) { diff --git a/bin/x86/Debug/Cyberpipe.exe b/bin/x86/Debug/Cyberpipe.exe index 44feaae..d75f8f0 100644 --- a/bin/x86/Debug/Cyberpipe.exe +++ b/bin/x86/Debug/Cyberpipe.exe Binary files differ diff --git a/bin/x86/Debug/Cyberpipe.pdb b/bin/x86/Debug/Cyberpipe.pdb index 8516cd3..01cc654 100644 --- a/bin/x86/Debug/Cyberpipe.pdb +++ b/bin/x86/Debug/Cyberpipe.pdb Binary files differ diff --git a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache index fb27b29..5f45ee7 100644 --- a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache +++ b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache Binary files differ diff --git a/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt b/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt index 656e8cd..7ae40aa 100644 --- a/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt +++ b/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt @@ -170,3 +170,175 @@ E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.SysRescInfoManager.resources E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.read.1.tlog E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.write.1.tlog +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.exe.config +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.csproj.ResolveComReference.cache +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.exe +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.pdb +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.exe +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.pdb +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\office.dll +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\office.xml +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\ResolveAssemblyReference.cache +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1数据输入输出.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1添加文件.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1添加项目.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FormDocumentManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmAddYuBiZiShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGBJCresult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmWait.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\PipeLine.Forms.FrmAddPipelineCoordinate.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGongShuiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmMnModify.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPipelineModelDataOneStep.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmShLayers.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmShRK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmTongXunAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmAddWellShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccess.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoriesgather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoryAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddValve.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddWellShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddYuBiZiShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAllWorkWellStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAnalysisGuiHuaResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPP.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPAuditor.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPFORASK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPFORASKReason.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPregion.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAppUSER.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAppUSERRESET.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBACKORACLE.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBSQDuoBianXingStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBSQStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBufferAnalysisBSQ.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmChangePassword.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCheckHistory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCodingQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCompareFeature.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCreateUser.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCustomLabel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDataBaseOpt.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDatabaseParaSetting2.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDbManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDocumentEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDownloadProgress.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmExportCADS.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlySetDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBasicQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBoosterValvers.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBufferAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDatabaseParaSetting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DigFillAnalysisDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBaseLineProfillAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGenAndFaMenTopu.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGenTopo.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCloseValves.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDigPitSetting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFittingQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlow.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlyToPosition.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFolderSelecter.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFTAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGBJC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGenAndFaMenTopu.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGHRK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHotFuncStat.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHotFuncStatTitle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmKeywordQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLayerControl.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogDescription.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogin.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogOper.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMDDictory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadata.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadataOutput.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadataStat.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMultiPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmOperMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPerm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPermMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeDeepstatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeDiametergather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Frmpipediameterstatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeMaterialGather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPaiShuiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmProject.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmRanQiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddPipeFitting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAllPipelineStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDiameterQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFWPipeLineStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRedlineResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleInfoManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleRescManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmShResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoManger.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoPassword.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmThreeOracle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRole.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValveStatistics.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMaterialSel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.frmPipeSetEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmProfileAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPropertiesMarker.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmOper.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQueryHistory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQueryMessage.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQuerySensorAlarm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegion.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionType.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionTypeMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRESC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRESCMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRole.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetGoalLayer.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmTackPolygonDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHDMAnalysis3.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLineCoordinate.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQuerySQL.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserAdd.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRepo.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRepoMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValiData.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmYJSHTC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Frm_password_reset.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSfiles.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSinout.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSProjedits.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.MainFrm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCreateTunnel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCitySevenLineType.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile_AddField.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile_DeleteField.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmExportVector.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFloodAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCityServerLineAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMarker.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPipelineIndented.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMFiles.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMInout.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMTitle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMProjedit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Properties.Resources.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetLatLonPos.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSceneLightSet.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetFlytoPos.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoriesSensor.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValiDataShowErrorMessage.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddInstrument.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.SysRescInfoManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.read.1.tlog +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.write.1.tlog diff --git a/obj/x64/Debug/Cyberpipe.exe b/obj/x64/Debug/Cyberpipe.exe index 44feaae..d75f8f0 100644 --- a/obj/x64/Debug/Cyberpipe.exe +++ b/obj/x64/Debug/Cyberpipe.exe Binary files differ diff --git a/obj/x64/Debug/Cyberpipe.pdb b/obj/x64/Debug/Cyberpipe.pdb index 8516cd3..01cc654 100644 --- a/obj/x64/Debug/Cyberpipe.pdb +++ b/obj/x64/Debug/Cyberpipe.pdb Binary files differ diff --git a/obj/x64/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/obj/x64/Debug/DesignTimeResolveAssemblyReferencesInput.cache index b1407b2..19376ec 100644 --- a/obj/x64/Debug/DesignTimeResolveAssemblyReferencesInput.cache +++ b/obj/x64/Debug/DesignTimeResolveAssemblyReferencesInput.cache Binary files differ diff --git a/ClassSearchAnalysis.cs b/ClassSearchAnalysis.cs index 61f667e..52e8cdb 100644 --- a/ClassSearchAnalysis.cs +++ b/ClassSearchAnalysis.cs @@ -77,22 +77,11 @@ /// public static DataTable ResultDistinctDataTable(out DataTable dt,string layerName,string filedObject) { - string sql = "select distinct "+filedObject+" from " + layerName; + string sql = "select distinct " + filedObject + " from " + layerName + " order by " + filedObject; dt = OledbHelper.QueryTable(sql); return dt; } /// - /// SQL查询不重复的值+排序 - /// - /// - /// - /// - /// - public static DataTable ResultDistinceDataTableOrder(out DataTable dt, string layerName, string filedObject) - { - - } - /// /// SQL查询,返回包含NULL的Table /// /// diff --git a/Cyberpipe.suo b/Cyberpipe.suo index 221e34d..5e7841c 100644 --- a/Cyberpipe.suo +++ b/Cyberpipe.suo Binary files differ diff --git a/FrmQuerySQL.cs b/FrmQuerySQL.cs index 4260509..f5b4c8f 100644 --- a/FrmQuerySQL.cs +++ b/FrmQuerySQL.cs @@ -192,7 +192,7 @@ } } - ClassSearchAnalysis.ResultDistinctDataTable(table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); + ClassSearchAnalysis.ResultDistinctDataTable(out table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); for (int i = 0; i < table.Rows.Count; i++) { diff --git a/bin/x86/Debug/Cyberpipe.exe b/bin/x86/Debug/Cyberpipe.exe index 44feaae..d75f8f0 100644 --- a/bin/x86/Debug/Cyberpipe.exe +++ b/bin/x86/Debug/Cyberpipe.exe Binary files differ diff --git a/bin/x86/Debug/Cyberpipe.pdb b/bin/x86/Debug/Cyberpipe.pdb index 8516cd3..01cc654 100644 --- a/bin/x86/Debug/Cyberpipe.pdb +++ b/bin/x86/Debug/Cyberpipe.pdb Binary files differ diff --git a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache index fb27b29..5f45ee7 100644 --- a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache +++ b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache Binary files differ diff --git a/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt b/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt index 656e8cd..7ae40aa 100644 --- a/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt +++ b/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt @@ -170,3 +170,175 @@ E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.SysRescInfoManager.resources E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.read.1.tlog E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.write.1.tlog +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.exe.config +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.csproj.ResolveComReference.cache +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.exe +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.pdb +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.exe +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.pdb +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\office.dll +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\office.xml +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\ResolveAssemblyReference.cache +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1数据输入输出.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1添加文件.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1添加项目.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FormDocumentManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmAddYuBiZiShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGBJCresult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmWait.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\PipeLine.Forms.FrmAddPipelineCoordinate.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGongShuiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmMnModify.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPipelineModelDataOneStep.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmShLayers.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmShRK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmTongXunAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmAddWellShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccess.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoriesgather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoryAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddValve.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddWellShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddYuBiZiShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAllWorkWellStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAnalysisGuiHuaResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPP.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPAuditor.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPFORASK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPFORASKReason.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPregion.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAppUSER.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAppUSERRESET.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBACKORACLE.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBSQDuoBianXingStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBSQStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBufferAnalysisBSQ.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmChangePassword.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCheckHistory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCodingQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCompareFeature.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCreateUser.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCustomLabel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDataBaseOpt.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDatabaseParaSetting2.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDbManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDocumentEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDownloadProgress.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmExportCADS.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlySetDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBasicQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBoosterValvers.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBufferAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDatabaseParaSetting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DigFillAnalysisDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBaseLineProfillAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGenAndFaMenTopu.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGenTopo.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCloseValves.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDigPitSetting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFittingQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlow.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlyToPosition.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFolderSelecter.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFTAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGBJC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGenAndFaMenTopu.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGHRK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHotFuncStat.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHotFuncStatTitle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmKeywordQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLayerControl.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogDescription.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogin.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogOper.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMDDictory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadata.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadataOutput.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadataStat.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMultiPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmOperMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPerm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPermMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeDeepstatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeDiametergather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Frmpipediameterstatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeMaterialGather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPaiShuiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmProject.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmRanQiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddPipeFitting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAllPipelineStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDiameterQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFWPipeLineStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRedlineResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleInfoManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleRescManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmShResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoManger.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoPassword.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmThreeOracle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRole.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValveStatistics.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMaterialSel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.frmPipeSetEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmProfileAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPropertiesMarker.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmOper.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQueryHistory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQueryMessage.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQuerySensorAlarm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegion.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionType.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionTypeMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRESC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRESCMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRole.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetGoalLayer.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmTackPolygonDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHDMAnalysis3.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLineCoordinate.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQuerySQL.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserAdd.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRepo.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRepoMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValiData.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmYJSHTC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Frm_password_reset.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSfiles.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSinout.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSProjedits.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.MainFrm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCreateTunnel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCitySevenLineType.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile_AddField.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile_DeleteField.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmExportVector.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFloodAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCityServerLineAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMarker.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPipelineIndented.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMFiles.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMInout.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMTitle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMProjedit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Properties.Resources.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetLatLonPos.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSceneLightSet.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetFlytoPos.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoriesSensor.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValiDataShowErrorMessage.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddInstrument.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.SysRescInfoManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.read.1.tlog +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.write.1.tlog diff --git a/obj/x64/Debug/Cyberpipe.exe b/obj/x64/Debug/Cyberpipe.exe index 44feaae..d75f8f0 100644 --- a/obj/x64/Debug/Cyberpipe.exe +++ b/obj/x64/Debug/Cyberpipe.exe Binary files differ diff --git a/obj/x64/Debug/Cyberpipe.pdb b/obj/x64/Debug/Cyberpipe.pdb index 8516cd3..01cc654 100644 --- a/obj/x64/Debug/Cyberpipe.pdb +++ b/obj/x64/Debug/Cyberpipe.pdb Binary files differ diff --git a/obj/x64/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/obj/x64/Debug/DesignTimeResolveAssemblyReferencesInput.cache index b1407b2..19376ec 100644 --- a/obj/x64/Debug/DesignTimeResolveAssemblyReferencesInput.cache +++ b/obj/x64/Debug/DesignTimeResolveAssemblyReferencesInput.cache Binary files differ diff --git a/obj/x64/Debug/GenerateResource.read.1.tlog b/obj/x64/Debug/GenerateResource.read.1.tlog index c750843..5e7a155 100644 --- a/obj/x64/Debug/GenerateResource.read.1.tlog +++ b/obj/x64/Debug/GenerateResource.read.1.tlog Binary files differ diff --git a/ClassSearchAnalysis.cs b/ClassSearchAnalysis.cs index 61f667e..52e8cdb 100644 --- a/ClassSearchAnalysis.cs +++ b/ClassSearchAnalysis.cs @@ -77,22 +77,11 @@ /// public static DataTable ResultDistinctDataTable(out DataTable dt,string layerName,string filedObject) { - string sql = "select distinct "+filedObject+" from " + layerName; + string sql = "select distinct " + filedObject + " from " + layerName + " order by " + filedObject; dt = OledbHelper.QueryTable(sql); return dt; } /// - /// SQL查询不重复的值+排序 - /// - /// - /// - /// - /// - public static DataTable ResultDistinceDataTableOrder(out DataTable dt, string layerName, string filedObject) - { - - } - /// /// SQL查询,返回包含NULL的Table /// /// diff --git a/Cyberpipe.suo b/Cyberpipe.suo index 221e34d..5e7841c 100644 --- a/Cyberpipe.suo +++ b/Cyberpipe.suo Binary files differ diff --git a/FrmQuerySQL.cs b/FrmQuerySQL.cs index 4260509..f5b4c8f 100644 --- a/FrmQuerySQL.cs +++ b/FrmQuerySQL.cs @@ -192,7 +192,7 @@ } } - ClassSearchAnalysis.ResultDistinctDataTable(table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); + ClassSearchAnalysis.ResultDistinctDataTable(out table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); for (int i = 0; i < table.Rows.Count; i++) { diff --git a/bin/x86/Debug/Cyberpipe.exe b/bin/x86/Debug/Cyberpipe.exe index 44feaae..d75f8f0 100644 --- a/bin/x86/Debug/Cyberpipe.exe +++ b/bin/x86/Debug/Cyberpipe.exe Binary files differ diff --git a/bin/x86/Debug/Cyberpipe.pdb b/bin/x86/Debug/Cyberpipe.pdb index 8516cd3..01cc654 100644 --- a/bin/x86/Debug/Cyberpipe.pdb +++ b/bin/x86/Debug/Cyberpipe.pdb Binary files differ diff --git a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache index fb27b29..5f45ee7 100644 --- a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache +++ b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache Binary files differ diff --git a/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt b/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt index 656e8cd..7ae40aa 100644 --- a/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt +++ b/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt @@ -170,3 +170,175 @@ E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.SysRescInfoManager.resources E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.read.1.tlog E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.write.1.tlog +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.exe.config +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.csproj.ResolveComReference.cache +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.exe +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.pdb +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.exe +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.pdb +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\office.dll +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\office.xml +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\ResolveAssemblyReference.cache +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1数据输入输出.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1添加文件.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1添加项目.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FormDocumentManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmAddYuBiZiShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGBJCresult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmWait.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\PipeLine.Forms.FrmAddPipelineCoordinate.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGongShuiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmMnModify.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPipelineModelDataOneStep.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmShLayers.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmShRK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmTongXunAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmAddWellShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccess.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoriesgather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoryAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddValve.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddWellShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddYuBiZiShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAllWorkWellStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAnalysisGuiHuaResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPP.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPAuditor.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPFORASK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPFORASKReason.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPregion.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAppUSER.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAppUSERRESET.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBACKORACLE.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBSQDuoBianXingStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBSQStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBufferAnalysisBSQ.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmChangePassword.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCheckHistory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCodingQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCompareFeature.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCreateUser.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCustomLabel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDataBaseOpt.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDatabaseParaSetting2.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDbManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDocumentEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDownloadProgress.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmExportCADS.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlySetDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBasicQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBoosterValvers.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBufferAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDatabaseParaSetting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DigFillAnalysisDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBaseLineProfillAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGenAndFaMenTopu.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGenTopo.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCloseValves.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDigPitSetting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFittingQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlow.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlyToPosition.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFolderSelecter.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFTAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGBJC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGenAndFaMenTopu.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGHRK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHotFuncStat.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHotFuncStatTitle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmKeywordQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLayerControl.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogDescription.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogin.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogOper.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMDDictory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadata.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadataOutput.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadataStat.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMultiPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmOperMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPerm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPermMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeDeepstatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeDiametergather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Frmpipediameterstatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeMaterialGather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPaiShuiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmProject.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmRanQiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddPipeFitting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAllPipelineStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDiameterQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFWPipeLineStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRedlineResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleInfoManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleRescManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmShResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoManger.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoPassword.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmThreeOracle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRole.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValveStatistics.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMaterialSel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.frmPipeSetEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmProfileAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPropertiesMarker.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmOper.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQueryHistory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQueryMessage.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQuerySensorAlarm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegion.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionType.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionTypeMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRESC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRESCMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRole.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetGoalLayer.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmTackPolygonDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHDMAnalysis3.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLineCoordinate.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQuerySQL.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserAdd.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRepo.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRepoMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValiData.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmYJSHTC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Frm_password_reset.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSfiles.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSinout.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSProjedits.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.MainFrm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCreateTunnel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCitySevenLineType.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile_AddField.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile_DeleteField.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmExportVector.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFloodAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCityServerLineAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMarker.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPipelineIndented.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMFiles.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMInout.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMTitle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMProjedit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Properties.Resources.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetLatLonPos.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSceneLightSet.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetFlytoPos.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoriesSensor.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValiDataShowErrorMessage.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddInstrument.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.SysRescInfoManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.read.1.tlog +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.write.1.tlog diff --git a/obj/x64/Debug/Cyberpipe.exe b/obj/x64/Debug/Cyberpipe.exe index 44feaae..d75f8f0 100644 --- a/obj/x64/Debug/Cyberpipe.exe +++ b/obj/x64/Debug/Cyberpipe.exe Binary files differ diff --git a/obj/x64/Debug/Cyberpipe.pdb b/obj/x64/Debug/Cyberpipe.pdb index 8516cd3..01cc654 100644 --- a/obj/x64/Debug/Cyberpipe.pdb +++ b/obj/x64/Debug/Cyberpipe.pdb Binary files differ diff --git a/obj/x64/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/obj/x64/Debug/DesignTimeResolveAssemblyReferencesInput.cache index b1407b2..19376ec 100644 --- a/obj/x64/Debug/DesignTimeResolveAssemblyReferencesInput.cache +++ b/obj/x64/Debug/DesignTimeResolveAssemblyReferencesInput.cache Binary files differ diff --git a/obj/x64/Debug/GenerateResource.read.1.tlog b/obj/x64/Debug/GenerateResource.read.1.tlog index c750843..5e7a155 100644 --- a/obj/x64/Debug/GenerateResource.read.1.tlog +++ b/obj/x64/Debug/GenerateResource.read.1.tlog Binary files differ diff --git a/obj/x64/Debug/GenerateResource.write.1.tlog b/obj/x64/Debug/GenerateResource.write.1.tlog index d4eca55..ef1961e 100644 --- a/obj/x64/Debug/GenerateResource.write.1.tlog +++ b/obj/x64/Debug/GenerateResource.write.1.tlog Binary files differ diff --git a/ClassSearchAnalysis.cs b/ClassSearchAnalysis.cs index 61f667e..52e8cdb 100644 --- a/ClassSearchAnalysis.cs +++ b/ClassSearchAnalysis.cs @@ -77,22 +77,11 @@ /// public static DataTable ResultDistinctDataTable(out DataTable dt,string layerName,string filedObject) { - string sql = "select distinct "+filedObject+" from " + layerName; + string sql = "select distinct " + filedObject + " from " + layerName + " order by " + filedObject; dt = OledbHelper.QueryTable(sql); return dt; } /// - /// SQL查询不重复的值+排序 - /// - /// - /// - /// - /// - public static DataTable ResultDistinceDataTableOrder(out DataTable dt, string layerName, string filedObject) - { - - } - /// /// SQL查询,返回包含NULL的Table /// /// diff --git a/Cyberpipe.suo b/Cyberpipe.suo index 221e34d..5e7841c 100644 --- a/Cyberpipe.suo +++ b/Cyberpipe.suo Binary files differ diff --git a/FrmQuerySQL.cs b/FrmQuerySQL.cs index 4260509..f5b4c8f 100644 --- a/FrmQuerySQL.cs +++ b/FrmQuerySQL.cs @@ -192,7 +192,7 @@ } } - ClassSearchAnalysis.ResultDistinctDataTable(table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); + ClassSearchAnalysis.ResultDistinctDataTable(out table, cbox_Layers.SelectedItem.ToString(),listBox_Field.SelectedItem.ToString()); for (int i = 0; i < table.Rows.Count; i++) { diff --git a/bin/x86/Debug/Cyberpipe.exe b/bin/x86/Debug/Cyberpipe.exe index 44feaae..d75f8f0 100644 --- a/bin/x86/Debug/Cyberpipe.exe +++ b/bin/x86/Debug/Cyberpipe.exe Binary files differ diff --git a/bin/x86/Debug/Cyberpipe.pdb b/bin/x86/Debug/Cyberpipe.pdb index 8516cd3..01cc654 100644 --- a/bin/x86/Debug/Cyberpipe.pdb +++ b/bin/x86/Debug/Cyberpipe.pdb Binary files differ diff --git a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache index fb27b29..5f45ee7 100644 --- a/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache +++ b/obj/Debug/DesignTimeResolveAssemblyReferencesInput.cache Binary files differ diff --git a/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt b/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt index 656e8cd..7ae40aa 100644 --- a/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt +++ b/obj/x64/Debug/Cyberpipe.csproj.FileListAbsolute.txt @@ -170,3 +170,175 @@ E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.SysRescInfoManager.resources E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.read.1.tlog E:\wxl\work\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.write.1.tlog +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.exe.config +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.csproj.ResolveComReference.cache +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.exe +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.pdb +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.exe +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\Cyberpipe.pdb +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\office.dll +D:\GHFX\GHFX_REFACTOR\bin\x86\Debug\office.xml +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\ResolveAssemblyReference.cache +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1数据输入输出.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1添加文件.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DZ_Forms.F_GKT1添加项目.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FormDocumentManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmAddYuBiZiShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGBJCresult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmWait.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\PipeLine.Forms.FrmAddPipelineCoordinate.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGongShuiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmMnModify.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPipelineModelDataOneStep.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmShLayers.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmShRK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmTongXunAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmAddWellShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Form_RK.FrmPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccess.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoriesgather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoryAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddValve.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddWellShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddYuBiZiShp.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAllWorkWellStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAnalysisGuiHuaResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPP.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPAuditor.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPFORASK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPFORASKReason.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAPPregion.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAppUSER.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAppUSERRESET.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBACKORACLE.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBSQDuoBianXingStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBSQStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBufferAnalysisBSQ.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmChangePassword.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCheckHistory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCodingQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCompareFeature.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCreateUser.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCustomLabel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDataBaseOpt.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDatabaseParaSetting2.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDbManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDocumentEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDownloadProgress.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmExportCADS.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlySetDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBasicQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBoosterValvers.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBufferAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDatabaseParaSetting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.DigFillAnalysisDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmBaseLineProfillAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGenAndFaMenTopu.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmGenTopo.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCloseValves.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDigPitSetting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFittingQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlow.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFlyToPosition.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFolderSelecter.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFTAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGBJC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGenAndFaMenTopu.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmGHRK.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHotFuncStat.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHotFuncStatTitle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmKeywordQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLayerControl.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogDescription.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogin.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLogOper.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMDDictory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadata.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadataOutput.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMetadataStat.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMultiPipelineModelDB.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmOperMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPerm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPermMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeDeepstatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeDiametergather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Frmpipediameterstatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmpipeMaterialGather.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmPaiShuiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmProject.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Forms.FrmRanQiAttribute.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddPipeFitting.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAllPipelineStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmDiameterQuery.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFWPipeLineStatis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRedlineResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleInfoManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleRescManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmShResult.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoManger.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSysUserInfoPassword.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmThreeOracle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRole.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValveStatistics.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMaterialSel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.frmPipeSetEdit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmProfileAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPropertiesMarker.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmOper.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQueryHistory.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQueryMessage.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQuerySensorAlarm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegion.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionType.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRegionTypeMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRESC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRESCMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRole.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetGoalLayer.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmTackPolygonDlg.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmHDMAnalysis3.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmLineCoordinate.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmQuerySQL.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserAdd.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRepo.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRepoMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmUserRoleMgr.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValiData.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmYJSHTC.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Frm_password_reset.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSfiles.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSinout.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.HFS_Forms.Frm_HFSProjedits.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.MainFrm.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCreateTunnel.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCitySevenLineType.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile_AddField.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmEditShapeFile_DeleteField.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmExportVector.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmFloodAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmCityServerLineAnalysis.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmMarker.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmPipelineIndented.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMFiles.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMInout.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMTitle.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.PATM_Forms.F_PATMProjedit.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.Properties.Resources.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetLatLonPos.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSceneLightSet.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmSetFlytoPos.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAccessoriesSensor.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmValiDataShowErrorMessage.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.FrmAddInstrument.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\Cyberpipe.SysRescInfoManager.resources +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.read.1.tlog +D:\GHFX\GHFX_REFACTOR\obj\x64\Debug\GenerateResource.write.1.tlog diff --git a/obj/x64/Debug/Cyberpipe.exe b/obj/x64/Debug/Cyberpipe.exe index 44feaae..d75f8f0 100644 --- a/obj/x64/Debug/Cyberpipe.exe +++ b/obj/x64/Debug/Cyberpipe.exe Binary files differ diff --git a/obj/x64/Debug/Cyberpipe.pdb b/obj/x64/Debug/Cyberpipe.pdb index 8516cd3..01cc654 100644 --- a/obj/x64/Debug/Cyberpipe.pdb +++ b/obj/x64/Debug/Cyberpipe.pdb Binary files differ diff --git a/obj/x64/Debug/DesignTimeResolveAssemblyReferencesInput.cache b/obj/x64/Debug/DesignTimeResolveAssemblyReferencesInput.cache index b1407b2..19376ec 100644 --- a/obj/x64/Debug/DesignTimeResolveAssemblyReferencesInput.cache +++ b/obj/x64/Debug/DesignTimeResolveAssemblyReferencesInput.cache Binary files differ diff --git a/obj/x64/Debug/GenerateResource.read.1.tlog b/obj/x64/Debug/GenerateResource.read.1.tlog index c750843..5e7a155 100644 --- a/obj/x64/Debug/GenerateResource.read.1.tlog +++ b/obj/x64/Debug/GenerateResource.read.1.tlog Binary files differ diff --git a/obj/x64/Debug/GenerateResource.write.1.tlog b/obj/x64/Debug/GenerateResource.write.1.tlog index d4eca55..ef1961e 100644 --- a/obj/x64/Debug/GenerateResource.write.1.tlog +++ b/obj/x64/Debug/GenerateResource.write.1.tlog Binary files differ diff --git a/obj/x64/Debug/ResolveAssemblyReference.cache b/obj/x64/Debug/ResolveAssemblyReference.cache index c7efe5a..b8c1a76 100644 --- a/obj/x64/Debug/ResolveAssemblyReference.cache +++ b/obj/x64/Debug/ResolveAssemblyReference.cache Binary files differ