/// <summary>
/// 插入数据
/// </summary>
/// <returns>返回,成功:true,失败:false</returns>
public int Insert()
{
int result = 0;
T entity = Clone() as T;
if (entity != null)
{
try
{
using (MySqlConnection connection = RunConnection.GetOpenConnection())
{
//using (MySqlTransaction transaction = connection.BeginTransaction())//事务,对目前的封装来说,不适合使用
//{
result = connection.Insert <T>(entity);
//result = connection.Insert<T>(entity, transaction);
//transaction.Commit();
//}
}
}
catch (DbException e)
{
log.Error("插入数据失败", e);
}
}
return(result);
}
/// <summary>
/// 根据主键ID删除数据
/// </summary>
/// <param name="id">主键ID的值</param>
/// <param name="name">主键ID的数据库字段名称，默认是ID</param>
/// <returns></returns>
public bool Delete(int id, string name = "ID")
{
bool result = false;
T entity = Clone() as T;
if (id > 0)
{
try
{
string tableName = (typeof(T).GetCustomAttributes(false).Where(attr => attr.GetType().Name == "TableAttribute").SingleOrDefault() as dynamic).Name;
using (MySqlConnection connection = RunConnection.GetOpenConnection())
{
if (!string.IsNullOrEmpty(name))
{
result = connection.Execute(string.Format("delete from {0} where {1} = @{1}", tableName, name), new { id }) > 0;
}
}
}
catch (Exception e)
{
log.Error("删除数据失败", e);
}
}
return(result);
}
/// <summary>
/// 根据SQL语句查询一个结果值
/// </summary>
/// <param name="sql"></param>
/// <param name="param"></param>
/// <returns></returns>
public object GetScalar(string sql, object param = null)
{
object totalCount = null;
if (!string.IsNullOrEmpty(sql))
{
try
{
using (MySqlConnection connection = RunConnection.GetOpenConnection())
{
totalCount = connection.ExecuteScalar <object>(sql, param, null, null, null);
}
}
catch (Exception e)
{
log.Error("获取结果值失败", e);
}
}
return(totalCount);
}
/// <summary>
/// Delete，根据实体对象删除
/// </summary>
/// <returns>返回,成功:true,失败:false</returns>
public bool Delete()
{
bool result = false;
T entity = Clone() as T;
if (entity != null)
{
try
{
using (MySqlConnection connection = RunConnection.GetOpenConnection())
{
result = connection.Delete <T>(entity);
}
}
catch (Exception e)
{
log.Error("删除数据失败", e);
}
}
return(result);
}
/// <summary>
/// 获取该实体的查询
/// </summary>
/// <param name="specification">满足表达式规范的组合</param>
/// <returns>DemoInfo实体对象的List集合</returns>
public List <T> GetList(string sql, object param = null)
{
T entity = Clone() as T;
List <T> list = null;
if (!string.IsNullOrEmpty(sql))
{
try
{
using (MySqlConnection connection = RunConnection.GetOpenConnection())
{
list = connection.Query <T>(sql, param).ToList();
}
}
catch (Exception e)
{
log.Error("获取列表数据失败", e);
}
}
return(list);
}
/// <summary>
/// 根据主键ID查询单一实体数据
/// </summary>
/// <param name="id">主键ID的值</param>
/// <param name="name">主键ID的数据库字段名称，默认是ID</param>
/// <returns></returns>
public T Get(string where, object param = null)
{
T entity = Clone() as T;
if (!string.IsNullOrEmpty(where))
{
try
{
string tableName = (typeof(T).GetCustomAttributes(false).Where(attr => attr.GetType().Name == "TableAttribute").SingleOrDefault() as dynamic).Name;
using (MySqlConnection connection = RunConnection.GetOpenConnection())
{
entity = connection.Query <T>(string.Format("select * from {0} where {1} ", tableName, where), param).FirstOrDefault();
}
}
catch (Exception e)
{
log.Error("查询单一数据失败", e);
}
}
return(entity);
}