/// <summary>
/// 根据存储过程获得单个对象
/// </summary>
/// <param name="proc">存储过程名称</param>
/// <param name="pas">参数数组</param>
/// <returns>单个对象</returns>
public static T GetSingleObjectByProc(string proc, params MySqlParameter[] pas)
{
DataTable dt = MySqlHelper.ExecuteDataTableProc(proc, pas);
IList <T> ts = ModelConvertHelper <T> .ConvertToModel(dt);
return(ts.Count == 0 ? null : ts[0]);
}
/// <summary>
/// 根据存储过程获得某对象的集合
/// </summary>
/// <param name="proc">存储过程名称</param>
/// <param name="pas">参数数组</param>
/// <returns>对象集合</returns>
public static IList <T> GetObjectsByProc(string proc, params MySqlParameter[] pas)
{
DataTable dt = MySqlHelper2.ExecuteDataTableProc(proc, pas);
return(ModelConvertHelper <T> .ConvertToModel(dt));
}
/// <summary>
/// 根据Sql获得某对象的集合
/// </summary>
/// <param name="sql">SQL语句</param>
/// <param name="pas">参数数组</param>
/// <returns>对象集合</returns>
public static IList <T> GetObjectsBySql(string sql, params MySqlParameter[] pas)
{
DataTable dt = MySqlHelper1.ExecuteDataTable(sql, pas);
return(ModelConvertHelper <T> .ConvertToModel(dt));
}
