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;
        }
    }
     */
}