public class LoadData

    {

        /// <summary>

        ///

        /// </summary>

        /// <returns></returns>

        public static string GetCunliangfang(string idNo)

        {

            string oraclePath = Application.StartupPath + @"\Lib";

            Environment.SetEnvironmentVariable("PATH", oraclePath, EnvironmentVariableTarget.Process);

            Environment.SetEnvironmentVariable("NLS_LANG", "SIMPLIFIED CHINESE_CHINA.ZHS16GBK", EnvironmentVariableTarget.Process);

            string rtn = string.Empty;

            //string connString = "Provider=OraOLEDB.Oracle.1;User ID=tax;Password=tax;Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = ****)(PORT = *****))) (CONNECT_DATA = (SERVICE_NAME = orcl)))";

            string connString = "Persist Security Info=True;User ID=tax;Password=tax;Unicode=True;Data Source=(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST =140.28.21.14)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)));";

            OracleConnection conn = new OracleConnection(connString);

            conn.Open();

            string sql = string.Format("select * from FDCJY_JYFCXX_HZ", idNo);// WHERE ID_SNO='{0}'

            OracleCommand cmd = new OracleCommand(sql, conn);

            OracleDataReader dr = cmd.ExecuteReader();

            if (dr.Read())

            {

                ArrayList arr = new ArrayList();

                arr.Add(dr["OC_CQRZJLX"]);//卖方证件类型代码

                arr.Add(dr["OC_CQRLXDH"]);//联系电话

                arr.Add(dr["OC_CQRGJ"]);//卖方国籍代码

                arr.Add(dr["OC_CQRLXDZ"]);//卖方地址

                arr.Add(dr["OC_MFXM"]);//"买方姓名

                arr.Add(dr["OC_MFZJLX"]);//"买方证件类型

                arr.Add(dr["OC_MFZJHM"]);//证件号码

                arr.Add(dr["OC_MFGJ"]);//国籍代码

                arr.Add(dr["OC_MFLXDH"]);//联系电话

                arr.Add(dr["OC_MFLXDZ"]);//联系地址

                //房屋信息

                arr.Add(dr["DT_HTQDRQ"].ToString()); //合同签订日期

                arr.Add(dr["OC_QXDM"]);//行政区划

                arr.Add(dr["OC_JDXZ"]);//街道乡镇

                arr.Add(dr["OC_FWZL"]);//房屋所属地，有默认

                arr.Add(dr["OC_FCZH"]);//房产证号

                arr.Add(dr["OC_HTZJ"].ToString());//合同金额

                arr.Add(dr["OC_FCLX"]);//房产类型

                arr.Add(dr["OC_FCZH"]);//房屋幢号

                arr.Add(dr["OC_SZLC"]);//楼层

                arr.Add(dr["OC_SCJYFS"]);//上次取得房屋方式

                ////arr.Add(dr["OC_HTZJ"]);//交易价格--临时不用

                arr.Add(dr["DT_SCJYSJ"].ToString());//上次交易时间

                arr.Add(dr["oc_fwtc"]);//上次房屋取得成本

                arr.Add(dr["OC_JYLX"]);//交易类型

                arr.Add(dr["OC_BZ"]);//备注

                rtn = string.Join(",", (string[])arr.ToArray(typeof(string)));

            }

            conn.Close();

            cmd.Dispose();

            return rtn;

        }

    }