/// <summary> /// 根据存储过程获得单个对象 /// </summary> /// <param name="proc">存储过程名称</param> /// <param name="pas">参数数组</param> /// <returns>单个对象</returns> public static T GetSingleObjectByProc(string proc, params MySqlParameter[] pas) { DataTable dt = MySqlHelper2.ExecuteDataTableProc(proc, pas); IList <T> ts = ModelConvertHelper <T> .ConvertToModel(dt); return(ts.Count == 0 ? null : ts[0]); }
/// <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> /// 根据存储过程获得某对象的集合 /// </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)); }