diff --git a/Cyberpipe.suo b/Cyberpipe.suo index 610c02a..a9d6b2f 100644 --- a/Cyberpipe.suo +++ b/Cyberpipe.suo Binary files differ diff --git a/Cyberpipe.suo b/Cyberpipe.suo index 610c02a..a9d6b2f 100644 --- a/Cyberpipe.suo +++ b/Cyberpipe.suo Binary files differ diff --git a/FrmFlagManagers.cs b/FrmFlagManagers.cs index ec08749..05861d1 100644 --- a/FrmFlagManagers.cs +++ b/FrmFlagManagers.cs @@ -218,7 +218,7 @@ string sqlCount = "select count(1) from 标识器 where 使用状态 = '使用中'"; string sqlData = "select 编号,标识器ID号,标识器型号,地面高程,标识器埋深,所属道路,LSSYS_ID as " + - LSSYS_ID_VALUE + ",X坐标,Y坐标,使用状态,权属单位,设计单位,设计人姓名,施工单位,施工责任人,施工监理,监理责任人,备注 " + + LSSYS_ID_VALUE + ",X坐标,Y坐标,使用状态,权属单位,备注 " + "from (select t.*,rownum row_num from 标识器 t where 使用状态 = '使用中' order by 编号)b " + " where 1=1"; rows = int.Parse(OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, CommandType.Text, sqlCount).ToString()); @@ -233,7 +233,7 @@ string sqlCount = "select count(1) from 标识器 where 使用状态 = '使用中'"; string sqlData = "select 编号,标识器ID号,标识器型号,round(地面高程,2) as 地面高程,round(标识器埋深,2) as 标识器埋深,所属道路,LSSYS_ID as " + - LSSYS_ID_VALUE + ",X坐标,Y坐标,使用状态,权属单位,设计单位,设计人姓名,施工单位,施工责任人,施工监理,监理责任人,备注 " + + LSSYS_ID_VALUE + ",X坐标,Y坐标,使用状态,权属单位,备注 " + "from (select t.*,rownum row_num from 标识器 t where 使用状态 = '使用中'"; if (!String.IsNullOrEmpty(txt_no.Text.Trim()))