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 +