diff --git a/ClassExecuteSQL.cs b/ClassExecuteSQL.cs
index bee1e28..61482a9 100644
--- a/ClassExecuteSQL.cs
+++ b/ClassExecuteSQL.cs
@@ -1,11 +1,66 @@
using System;
using System.Collections.Generic;
+using System.Data;
using System.Linq;
using System.Text;
namespace Cyberpipe
{
+ public class UpdateParam
+ {
+ public string cloumn;
+ public string value;
+ }
+ /*
class ClassExecuteSQL
{
+ public static void GetUpdateResult(string table, string cloumn,string value, string id)
+ {
+ string sql = "update " + table + " t set t." + cloumn + " = '" + value + "' where t.lssys_id=" + id;
+
+ OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql);
+ }
+
+ public string GetSql(string LSSYS_ID_VALUE)
+ {
+ string sqlCount = "select count(1) from 标识器 where 使用状态 = '使用中'";
+
+ string sqlData = "select 编号,标识器ID号,标识器型号,地面高程,标识器埋深,所属道路,LSSYS_ID as " +
+ 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());
+
+ return sqlData;
+ }
+
+ public string GetSql(int pageIndex, string LSSYS_ID_VALUE, int maxPageIndex)
+ {
+ int minPage = (pageIndex - 1) * maxPageIndex + 1;
+ int maxPage = pageIndex * maxPageIndex;
+ 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坐标,使用状态,权属单位,设计单位,设计人姓名,施工单位,施工责任人,施工监理,监理责任人,备注 " +
+ "from (select t.*,rownum row_num from 标识器 t where 使用状态 = '使用中'";
+
+ if (!String.IsNullOrEmpty(txt_no.Text.Trim()))
+ {
+ sqlCount += " and 编号 like '%" + txt_no.Text.Trim() + "%'";
+ sqlData += " and 编号 like '%" + txt_no.Text.Trim() + "%'";
+ }
+ if (null != combo_street.SelectedItem && !String.IsNullOrEmpty(combo_street.SelectedItem.ToString().Trim()))
+ {
+ sqlData += " and 所属道路='" + combo_street.SelectedItem.ToString().Trim() + "'";
+ sqlCount += " and 所属道路='" + combo_street.SelectedItem.ToString().Trim() + "'";
+ }
+
+ sqlData += " order by 编号)b " +
+ "where(b.row_num between " + minPage + " and " + maxPage + ")";
+ rows = int.Parse(OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, CommandType.Text, sqlCount).ToString());
+
+ return sqlData;
+ }
}
+ */
}
diff --git a/ClassExecuteSQL.cs b/ClassExecuteSQL.cs
index bee1e28..61482a9 100644
--- a/ClassExecuteSQL.cs
+++ b/ClassExecuteSQL.cs
@@ -1,11 +1,66 @@
using System;
using System.Collections.Generic;
+using System.Data;
using System.Linq;
using System.Text;
namespace Cyberpipe
{
+ public class UpdateParam
+ {
+ public string cloumn;
+ public string value;
+ }
+ /*
class ClassExecuteSQL
{
+ public static void GetUpdateResult(string table, string cloumn,string value, string id)
+ {
+ string sql = "update " + table + " t set t." + cloumn + " = '" + value + "' where t.lssys_id=" + id;
+
+ OracleUtils.ExecuteNonQuery(OracleUtils.ConnectionString, CommandType.Text, sql);
+ }
+
+ public string GetSql(string LSSYS_ID_VALUE)
+ {
+ string sqlCount = "select count(1) from 标识器 where 使用状态 = '使用中'";
+
+ string sqlData = "select 编号,标识器ID号,标识器型号,地面高程,标识器埋深,所属道路,LSSYS_ID as " +
+ 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());
+
+ return sqlData;
+ }
+
+ public string GetSql(int pageIndex, string LSSYS_ID_VALUE, int maxPageIndex)
+ {
+ int minPage = (pageIndex - 1) * maxPageIndex + 1;
+ int maxPage = pageIndex * maxPageIndex;
+ 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坐标,使用状态,权属单位,设计单位,设计人姓名,施工单位,施工责任人,施工监理,监理责任人,备注 " +
+ "from (select t.*,rownum row_num from 标识器 t where 使用状态 = '使用中'";
+
+ if (!String.IsNullOrEmpty(txt_no.Text.Trim()))
+ {
+ sqlCount += " and 编号 like '%" + txt_no.Text.Trim() + "%'";
+ sqlData += " and 编号 like '%" + txt_no.Text.Trim() + "%'";
+ }
+ if (null != combo_street.SelectedItem && !String.IsNullOrEmpty(combo_street.SelectedItem.ToString().Trim()))
+ {
+ sqlData += " and 所属道路='" + combo_street.SelectedItem.ToString().Trim() + "'";
+ sqlCount += " and 所属道路='" + combo_street.SelectedItem.ToString().Trim() + "'";
+ }
+
+ sqlData += " order by 编号)b " +
+ "where(b.row_num between " + minPage + " and " + maxPage + ")";
+ rows = int.Parse(OracleUtils.ExecuteScalar(OracleUtils.ConnectionString, CommandType.Text, sqlCount).ToString());
+
+ return sqlData;
+ }
}
+ */
}
diff --git a/Cyberpipe.csproj b/Cyberpipe.csproj
index da65155..b9c7155 100644
--- a/Cyberpipe.csproj
+++ b/Cyberpipe.csproj
@@ -206,6 +206,7 @@
+
@@ -2287,6 +2288,7 @@
Cyberpipe_BackUpDB_GSOBackOracle
+