/// <summary>
/// 测试存储过程调用
/// </summary>
public StoreProcedureList <TestUser> TestStoreProcedureList(string ProcedureName, params object[] values)
{
StoreProcedureList <TestUser> info = ExecuteProcedureList <TestUser>(
ProcedureName,
EntityTools.ChangeType <TestUser>,
values);
return(info);
}
/// <summary>
/// HowTO: 7. 基本数据库操作(执行存储过程返回泛型列表)
/// </summary>
static void HowTO_7()
{
Console.WriteLine("HowTO: 7. 执行存储过程返回泛型列表");
TestAbstractDA da = new TestAbstractDA();
StoreProcedureList <TestUser> info = da.TestStoreProcedureList("p_test", 2);
Console.WriteLine("存储过程p_test的返回值:{0}", info.ReturnCode);
foreach (string s in info.OutputParameters.Keys)
{
Console.WriteLine("\t输出参数:{0}:{1}", s, info.OutputParameters[s]);
}
foreach (TestUser u in info.List)
{
Console.WriteLine("\tID={0}, UserName={1}, UserPass={2}",
u.ID, u.UserName, u.UserPass);
}
}
