WebService 的简单封装接口调用方法

/// <summary>
/// 封装同一的接口调用方法
/// </summary>
/// <param name="_strSql">传入的简单sql</param>
/// <param name="_strConnNmae">连接数据库字符串</param>
/// <returns>返回的dataset</returns>
[WebMethod]
public DataSet GeneralDataSet(string _strSql, string _strConnNmae)
{
DataSet dsResult = null;
//连接HIS数据库串
ConnectionStringSettings css = new ConnectionStringSettings();
css = ConfigurationManager.ConnectionStrings[_strConnNmae];
using (OleDbConnection conn = new OleDbConnection(css.ConnectionString))
{
conn.Open();
OleDbCommand cmd = conn.CreateCommand();
using (OleDbDataAdapter ada = new OleDbDataAdapter())
{
try
{
cmdHIS.CommandText = _strSql;
ada.SelectCommand = cmdHIS;
ada.Fill(dsResult);
}
catch (Exception ex)
{
}
}
}
return dsResult;
}

<configuration>
<appSettings>
<add key="EmrSoapRole" value="http://www.goodwill.com/EMR"/>
</appSettings>
<connectionStrings>
 
<add name="HISConnectionString" connectionString="Data Source=DLFY;Persist Security Info=True;Password=medrec;User ID=medrec" providerName="System.Data.OracleClient"/>

//调用示例
DataSet ds = GeneralDataSet("select * from emp","HisConnectionString");