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)); }