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");