oradata.cs

网通网关Cngp

using System;
using Oracle.DataAccess;
using Oracle.DataAccess.Client;
using Oracle.DataAccess.Types;
using Pierce.DBHelper;
using Pierce.AttributeClass;
using System.Data;
namespace Cngp
{
	/// <summary>
	/// OraData 的摘要说明。
	/// </summary>
	public class OraData
	{
		private Pierce.DBHelper.Oracle.OraParameter Ora=new Pierce.DBHelper.Oracle.OraParameter();
		public OraData()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		}
		/// <summary>
		/// 获取数据库数据
		/// </summary>
		/// <returns>返回信息数组</returns>
		[LastModified("2006-06-21","从数据库获取信息数组")]
		[LastModified("2007-02-05","获取号码，位数最高应该为12位，因为济南和青岛升级")]
		public string[][] GetData(string procedure,int messageCount)
		{
			
			string[] matrixmobile=new string[messageCount];
			string[] matrixcontent=new string[messageCount];
			string[] matrixfeetype=new string[messageCount];
			string[] matrixfeecode=new string[messageCount];
			string[] matrixserviceid=new string[messageCount];
			string[] matrixsourceid=new string[messageCount];
			string[] matrixpriority=new string[messageCount];
			


			OracleParameter mobile=Ora.OraPara("mobile",ref matrixmobile,12,OracleDbType.Varchar2,messageCount,ParameterDirection.Output);
			OracleParameter content=Ora.OraPara("content",ref matrixcontent,400,OracleDbType.Varchar2,messageCount,ParameterDirection.Output);
			OracleParameter feetype=Ora.OraPara("feetype",ref matrixfeetype,4,OracleDbType.Varchar2,messageCount,ParameterDirection.Output);
			OracleParameter feecode=Ora.OraPara("feecode",ref matrixfeecode,10,OracleDbType.Varchar2,messageCount,ParameterDirection.Output);
			OracleParameter serviceid=Ora.OraPara("serviceid",ref matrixserviceid,10,OracleDbType.Varchar2,messageCount,ParameterDirection.Output);
			OracleParameter sourceid=Ora.OraPara("sourceid",ref matrixsourceid,21,OracleDbType.Varchar2,messageCount,ParameterDirection.Output);
			OracleParameter priority=Ora.OraPara("priority",ref matrixpriority,1,OracleDbType.Varchar2,messageCount,ParameterDirection.Output);
//			OracleParameter count=Ora.OraPara("count",OracleDbType.Varchar2,somevalue,ParameterDirection.Output,4);
			//
			//
			OracleParameter[] matrixpara=new OracleParameter[]{mobile,content,feetype,feecode,serviceid,sourceid,priority};
			
			Pierce.DBHelper.Oracle.OraHelper helper=new Pierce.DBHelper.Oracle.OraHelper();
			helper.OraName=ConfigInformation.OraUser;
			helper.OraPassword=ConfigInformation.OraPassword;
			helper.OraService=ConfigInformation.OraService;
			helper.Init();
			helper.CallProcedureInOut(procedure,null,ref matrixpara);
			//
			//计算数组信息数
			//
			
			
			string[] oramobile=ConvertOra2String((OracleString[])mobile.Value);
			string[] oracontent=ConvertOra2String((OracleString[])content.Value);
			string[] orafeetype=ConvertOra2String((OracleString[])feetype.Value);
			string[] orafeecode=ConvertOra2String((OracleString[])feecode.Value);
			string[] oraserviceid=ConvertOra2String((OracleString[])serviceid.Value);
			string[] orasourceid=ConvertOra2String((OracleString[])sourceid.Value);
			string[] orapriority=ConvertOra2String((OracleString[])priority.Value);
			//
			string[][] matrixMessage=new string[][]{oramobile,oracontent,orafeetype,orafeecode,oraserviceid,orasourceid,
			orapriority};
			
			return matrixMessage;			


		}
		/// <summary>
		/// 转换函数，将OracleString[] 转换为string[]
		/// </summary>
		/// <param name="para">OracleString[]</param>
		/// <returns>返回字符数组</returns>
		[LastModified("2006-06-21","转换函数，将OracleString[]转换为string[]")]
		private string[] ConvertOra2String(OracleString[] para)
		{
			string[] matrix=new string[para.Length];
			for(int i=0;i<para.Length;i++)
			{
				matrix[i]=para[i].ToString();
			}
			//
			return matrix;
		}
	}
}