public int Execute(object[] storedProcedureParam, string storedProcedureName) { const string outParameterName = "result"; InitSimple(storedProcedureName); foreach (ParameterItem parameterItem in storedProcedureParam) { dataProvider.AddInParameter( parameterItem.ParameterValue, parameterItem.ParameterName ); } dataProvider.AddOutParameter(outParameterName); try { return(dataProvider.ExecuteSpGetResultValue(outParameterName)); }catch { } return(0); }
public int Execute(StoredProcedure storedProcedure) { /// The result value must have some name const string outParameterName = "result"; int result = 0; InitSimple(storedProcedure.Name); foreach (ParameterItem parameterItem in storedProcedure.ParameterValueCollection) { dataProvider.AddInParameter( parameterItem.ParameterValue, parameterItem.ParameterName); } dataProvider.AddOutParameter(outParameterName); try { result = dataProvider.ExecuteSpGetResultValue(outParameterName); } catch { throw new Exception("Execute(StoredProcedure storedProcedure) has failed to execute"); result = 0; } return(result); }