public T FindEntity <T>(object keyValue) where T : class
{
using (var dbConnection = Connection)
{
string name = EntityAttribute.GetEntityTable <T>();
string key2 = EntityAttribute.GetEntityKey <T>();
var data = dbConnection.Query <T>(string.Format("select * from {0} where {1}=@key", EntityAttribute.GetEntityTable <T>(), EntityAttribute.GetEntityKey <T>()), new { key = keyValue.ToString() });
return(data.FirstOrDefault());
}
}
public int Delete <T>(object[] keyValue) where T : class
{
DynamicParameters dynamicParameters = new global::Dapper.DynamicParameters();
string whereString = string.Empty;
string keyString = EntityAttribute.GetEntityKey <T>();
for (int i = 0; i < keyValue.Length; i++)
{
string ParametersName = string.Format("@primarykey{0}", i);
dynamicParameters.Add(ParametersName, keyValue[i]);
whereString += string.Format("{0} {1} = {2}", i == 0 ? string.Empty : " OR ", keyString, ParametersName);
}
string deleteString = "Delete " + EntityAttribute.GetEntityTable <T>() + " where ";
ExecuteBySql(string.Format("{0}{1}", deleteString, whereString), dynamicParameters);
return(dbTransaction == null?Commit() : 0);
}
public int Delete <T>(object keyValue) where T : class
{
T entity = dbTransaction.Connection.Query <T>(string.Format("select * from {0} where {1}=?primarykey", EntityAttribute.GetEntityTable <T>(), EntityAttribute.GetEntityKey <T>()), new { primarykey = keyValue }).FirstOrDefault();
return(Delete <T>(entity));
}
public T FindEntity <T>(object keyValue) where T : class
{
using (var dbConnection = Connection)
{
var data = dbConnection.Query <T>(string.Format("select * from {0} where {1}=?key", EntityAttribute.GetEntityTable <T>(), EntityAttribute.GetEntityKey <T>()), new { key = keyValue }, null, true, CommandTimeout);
return(data.FirstOrDefault());
}
}
/// <summary>
/// 删除实例
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="keyValue">主键值</param>
/// <returns></returns>
public int Delete <T>(object keyValue) where T : class
{
string sql = $"select * from {EntityAttribute.GetEntityTable<T>()} where {EntityAttribute.GetEntityKey<T>()}=@primarykey";
T entity = dbTransaction.Connection.Query <T>(sql, new { primarykey = keyValue }).FirstOrDefault();
return(Delete <T>(entity));
}
public T FindEntity <T>(object keyValue) where T : class
{
using (var dbConnection = Connection)
{
Type type = typeof(T);
string viewName = "";
var viewAttribute = type.GetCustomAttributes(true).OfType <ViewAttribute>();
var descriptionAttributes = viewAttribute as ViewAttribute[] ?? viewAttribute.ToArray();
if (descriptionAttributes.Any())
{
viewName = descriptionAttributes.ToList()[0].viewName;
}
string tableName = string.IsNullOrWhiteSpace(viewName) ? EntityAttribute.GetEntityTable <T>() : viewName;
var data = dbConnection.Query <T>("select * from " + tableName + " where " + EntityAttribute.GetEntityKey <T>() + "=@key", new { key = keyValue.ToString() });
return(data.FirstOrDefault());
}
}
public int Delete <T>(object keyValue) where T : class
{
DynamicParameters dynamicParameters = new global::Dapper.DynamicParameters();
dynamicParameters.Add("@primarykey", keyValue);
return(ExecuteBySql("Delete " + EntityAttribute.GetEntityTable <T>() + " where " + EntityAttribute.GetEntityKey <T>() + "=@primarykey", dynamicParameters));
}
