如何从具有SPROC参数的SubSonic SPROC调用返回强类型对象？
|
我有一个数据调用者方法，该方法返回类型为ItemDatumCollection的SubSonic集合。
sproc执行如下：
itemDatumCollection.LoadAndCloseReader(sp.GetReader());
itemsDataSet = sp.GetDataSet();
actualNumberOfResults = ((Int64)sp.OutputValues[1]);
numberOfResultsReturned = ((Int64)sp.OutputValues[2]);
没有找到相关结果
已邀请:
1 个回复
蔬谢窗港
public void COMPANIES_ACTIVATE_PACKAGE(long PI_COMPANY_ID, string PI_ACTIVE, long PI_USER_ID, out long PO_ERRCODE, out string PO_ERRMSG, out string PO_ORA_ERRMSG){ StoredProcedure sp=new StoredProcedure(\"COMPANIES.ACTIVATE_PACKAGE\",this.Provider); sp.Command.AddParameter(\"PI_COMPANY_ID\",PI_COMPANY_ID,DbType.Decimal); sp.Command.AddParameter(\"PI_ACTIVE\",PI_ACTIVE,DbType.AnsiString); sp.Command.AddParameter(\"PI_USER_ID\",PI_USER_ID,DbType.Decimal); sp.Command.AddOutputParameter(\"PO_ERRCODE\",DbType.AnsiString); sp.Command.AddOutputParameter(\"PO_ERRMSG\",DbType.AnsiString); sp.Command.AddOutputParameter(\"PO_ORA_ERRMSG\",DbType.AnsiString); sp.Execute(); var prms = sp.Command.Parameters; PO_ERRCODE = ConvertValue<long>(prms.GetParameter(\"PO_ERRCODE\").ParameterValue); PO_ERRMSG = ConvertValue<string>(prms.GetParameter(\"PO_ERRMSG\").ParameterValue); PO_ORA_ERRMSG = ConvertValue<string>(prms.GetParameter(\"PO_ORA_ERRMSG\").ParameterValue); }而不是。 然后在我的实际应用程序代码中，我可以像任何其他函数一样调用存储的proc：long errorCode; string errorMsg, oraErrorMsg; db.COMPANIES_ACTIVATE_PACKAGE(123, \"Y\", 456, out errorCode, out errorMsg, out oraErrorMsg); if(errorCode > 0) // ... handle error...<#@ template language=\"C#\" debug=\"False\" hostspecific=\"True\" #> <#@ output extension=\".cs\" #> <#@ include file=\"DB2DataProvider.ttinclude\" #> <# var sps = GetSPs(); if(sps.Count>0){ #> using System; using System.Data; using System.ComponentModel; using SubSonic; using SubSonic.Schema; using SubSonic.DataProviders; namespace <#=Namespace#>{ public partial class <#=DatabaseName#>DB{ public T ConvertValue<T>(object paramVal) { if (paramVal == null || Convert.IsDBNull(paramVal)) // if the value is null, return the default for the desired type. return default(T); if (typeof(T) == paramVal.GetType()) // if types are already equal, no conversion needed. just cast. return (T)paramVal; else // types don\'t match. try to convert. { var conversionType = typeof(T); if (conversionType.IsGenericType && conversionType.GetGenericTypeDefinition().Equals(typeof(Nullable<>))) { NullableConverter nullableConverter = new NullableConverter(conversionType); conversionType = nullableConverter.UnderlyingType; } return (T)Convert.ChangeType(paramVal, conversionType); } } <# foreach(var sp in sps){#> public void <#=sp.CleanName#>(<#=sp.ArgList#>){ StoredProcedure sp=new StoredProcedure(\"<#=sp.Name#>\",this.Provider); <# foreach(var par in sp.Parameters) { if(par.In && !par.Out) {#> sp.Command.AddParameter(\"<#=par.Name#>\",<#=par.CleanName#>,DbType.<#=par.DbType#>); <# } else if(!par.In && par.Out) {#> sp.Command.AddOutputParameter(\"<#=par.Name#>\",DbType.<#=par.DbType#>); <# } else {#> sp.Command.AddParameter(\"<#=par.Name#>\",<#=par.CleanName#>,DbType.<#=par.DbType#>,ParameterDirection.InputOutput); <# }}#> sp.Execute(); <# bool hasOut = false; foreach(var par in sp.Parameters) { if(par.Out) hasOut = true; } if(hasOut) { #> var prms = sp.Command.Parameters; <# } foreach(var par in sp.Parameters) { if(par.Out) {#> <#=par.Name#> = ConvertValue<<#=par.SysType#>>(prms.GetParameter(\"<#=par.Name#>\").ParameterValue); <# }}#> } <# }#> } } <# }#>