/// <summary>
/// Stored Procudure 실행 후 OUTPUT, RETURN_VALUE 값을 응답개체(XdsResponseItem)에 추가한다.
/// </summary>
/// <param name="outputs">Command Parameter 중에 INPUT이 아닌 Parameter 들</param>
/// <param name="response">Instance of XdsResponseItem to build with result of execution of DbCommand
/// <param name="responseIndex">index of response</param>
protected static void ExtractParameters(IAdoParameter[] outputs, XdsResponseItem response, int responseIndex)
{
if (outputs == null || outputs.Length == 0)
{
return;
}
foreach (var output in outputs)
{
response.Fields.Add(new XdsField(output.Name.RemoveParameterPrefix(),
DbFunc.GetLanguageType(output.ValueType).FullName,
output.Size.GetValueOrDefault(0)));
}
var record = new XdsRecord();
foreach (var output in outputs)
{
record.Columns.AddColumn(output.Value);
}
response.Records.Add(record);
}
/// <summary>
/// Add new <see cref="XdsResponseItem"/>
/// </summary>
/// <param name="responseItem">Instance of <see cref="XdsResponseItem"/> to add.</param>
/// <returns>index of collection, if <paramref name="responseItem"/> is null, return -1</returns>
public int AddResponseItem(XdsResponseItem responseItem) {
return Responses.AddResponseItem(responseItem);
}
/// <summary>
/// Stored Procudure 실행 후 OUTPUT, RETURN_VALUE 값을 응답개체(XdsResponseItem)에 추가한다.
/// </summary>
/// <param name="outputs">Command Parameter 중에 INPUT이 아닌 Parameter 들</param>
/// <param name="response">Instance of XdsResponseItem to build with result of execution of DbCommand
/// <param name="responseIndex">index of response</param>
protected static void ExtractParameters(IAdoParameter[] outputs, XdsResponseItem response, int responseIndex) {
if(outputs == null || outputs.Length == 0)
return;
foreach(var output in outputs) {
response.Fields.Add(new XdsField(output.Name.RemoveParameterPrefix(),
DbFunc.GetLanguageType(output.ValueType).FullName,
output.Size.GetValueOrDefault(0)));
}
var record = new XdsRecord();
foreach(var output in outputs)
record.Columns.AddColumn(output.Value);
response.Records.Add(record);
}
