/// <summary>
/// 根据Sql获得单个对象
/// </summary>
/// <param name="sql"></param>
/// <param name="param"></param>
/// <returns></returns>
public static T GetSingleObjectBySql(string sql, params MySqlParameter[] param)
{
DataTable dt = MySqlHelper1.ExecuteDataTable(sql, param);
IList <T> ts = ModelConvertHelper <T> .ConvertToModel(dt);
return(ts.Count == 0 ? null : ts[0]);
}
///<summary>
///获得所有数据，返回DataTable
///生成时间：2010-10-10 21:28:26
///</summary>
public DataTable GetMutilDTServer()
{
return(MySqlHelper1.ExecuteDataTable(SQL_SELECTALL, null));
}
/// <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));
}
