/// <summary>
/// 插入
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="sqlStr"></param>
/// <returns></returns>
public virtual int Insert <T>(IDbConnection conn, T t) where T : BaseEntity
{
//获取实体信息
var entityInfo = new EntityMapping <T>();
var dataTableName = entityInfo.GetTableName();
//获取实体字段
var fields = entityInfo.GetFields(t).Where(l => l.Value != null && l.Value.ToString() != string.Empty);
var strFieldNames = string.Join(',', fields.Select(l => l.Name));
var strFieldVals = string.Join(',', fields.Select(l => $"'{l.Value}'"));
var sqlStr = $"insert into {dataTableName}({strFieldNames}) values ({strFieldVals})";
var data = SqlMapper.Execute(conn, sqlStr);
return(data);
}
/// <summary>
/// 查询
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="queryParam">查询条件</param>
/// <returns></returns>
public virtual IEnumerable <T> Query <T>(IDbConnection conn, string queryParam = "", string fieldNames = "") where T : BaseEntity
{
//获取实体信息
var entityInfo = new EntityMapping <T>();
var dataTableName = entityInfo.GetTableName();
var sqlStr = $"select * from {dataTableName}";
if (!string.IsNullOrEmpty(queryParam.Trim()))
{
sqlStr += $" where {queryParam}";
}
var data = SqlMapper.Query <T>(conn, sqlStr);
return(data);
}
/// <summary>
/// 删除
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="conn"></param>
/// <param name="id">当前主键的值</param>
/// <returns></returns>
public virtual int Delete <T>(IDbConnection conn, string id) where T : BaseEntity
{
//获取实体信息
var entityInfo = new EntityMapping <T>();
var dataTableName = entityInfo.GetTableName();
//获取主键key
var keyFieldName = entityInfo.GetKeyFieldName();
if (keyFieldName == null)
{
throw new Exception("key was not found!");
}
var sqlStr = $"delete from {dataTableName} where {keyFieldName}= '{id}'";
var data = SqlMapper.Execute(conn, sqlStr);
return(data);
}
/// <summary>
/// 更新
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="sqlStr"></param>
/// <returns></returns>
public virtual int Update <T>(IDbConnection conn, T t) where T : BaseEntity
{
//获取实体信息
var entityInfo = new EntityMapping <T>();
var dataTableName = entityInfo.GetTableName();
//获取实体字段
var fields = entityInfo.GetFields(t).Where(l => l.Value != null && l.Value.ToString() != string.Empty);
var strFieldNames = string.Join(',', fields.Where(l => !l.IsKey).Select(l => l.Name));
var strFieldVals = string.Join(',', fields.Where(l => !l.IsKey).Select(l => $"'{l.Value}'"));
//获取主键key
var keyField = fields.FirstOrDefault(l => l.IsKey);
if (keyField == null)
{
throw new Exception("key was not found!");
}
var paramStr = string.Join(',', fields.Select(l => string.Format("{0}={1}", l.Name, l.Value is String ? $"'{l.Value}'" : l.Value)));
var sqlStr = $"update {dataTableName} set {paramStr} where {keyField.Name}= '{keyField.Value}'";
var data = SqlMapper.Execute(conn, sqlStr);
return(data);
}
