本文整理汇总了C#中CSS2.Models.SafeDataReader.NextResult方法的典型用法代码示例。如果您正苦于以下问题：C# SafeDataReader.NextResult方法的具体用法？C# SafeDataReader.NextResult怎么用？C# SafeDataReader.NextResult使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类CSS2.Models.SafeDataReader的用法示例。
在下文中一共展示了SafeDataReader.NextResult方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetDisbursementItemsByID
/// <summary>
/// Description : Get Disbursement details by ID
/// Created By : Shiva
/// Created Date : 6 June 2014
/// Modified By :
/// Modified Date:
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
public static WorkOrdersAndDItemsInfo GetDisbursementItemsByID(int ID, string VenderRefID)
{
var data = new WorkOrdersAndDItemsInfo();
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
try
{
SqlParameter[] sqlParams = new SqlParameter[2];
sqlParams[0] = new SqlParameter("@ID", ID);
sqlParams[1] = new SqlParameter("@VenderRefID", VenderRefID);
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "SPGetDisbursementDataByID", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var SearchDisbursementItem = new DisbursementItem();
SearchDisbursementItem.FetchDisbursementItemsByID(SearchDisbursementItem, safe);
data.OrdersList.Add(SearchDisbursementItem);
}
safe.NextResult();
while (reader.Read())
{
data.VendorAmount = Convert.ToDecimal(reader["Amount"]);
data.VendorReport = Convert.ToString(reader["VRID"]);
}
safe.NextResult();
while (reader.Read())
{
data.OrdersCount = Convert.ToInt32(reader["RelatedDICount"]);
}
return data;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return data;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}