/// <summary>
/// 将实体对象更新到数据库
/// </summary>
/// <typeparam name="T"></typeparam>
/// <typeparam name="FiledType"></typeparam>
/// <param name="rowObj">rowObj为匿名对象时只更新指定列( 例如:new{ name='abc'}只更新name )，为T类型将更新整个实体(排除主键、自增列和禁止更新列)</param>
/// <param name="whereIn">主键集合</param>
/// <returns>更新成功返回true</returns>
public bool Update <T, FiledType>(object rowObj, params FiledType[] whereIn) where T : class
{
if (rowObj == null)
{
throw new ArgumentNullException("SqlSugarClient.Update.rowObj");
}
Type type = typeof(T);
string typeName = type.Name;
typeName = GetTableNameByClassType(typeName);
StringBuilder sbSql = new StringBuilder(string.Format(" UPDATE [{0}] SET ", typeName));
Dictionary <string, object> rows = SqlSugarTool.GetObjectToDictionary(rowObj);
string pkName = SqlSugarTool.GetPrimaryKeyByTableName(this, typeName);
var identityNames = SqlSugarTool.GetIdentitiesKeyByTableName(this, typeName);
foreach (var r in rows)
{
var isPk = pkName != null && pkName.ToLower() == r.Key.ToLower();
var isIdentity = identityNames.Any(it => it.Value.ToLower() == r.Key.ToLower());
var isDisableUpdateColumns = DisableUpdateColumns != null && DisableUpdateColumns.Any(it => it.ToLower() == r.Key.ToLower());
if (this.IsIgnoreErrorColumns)
{
if (!SqlSugarTool.GetColumnsByTableName(this, typeName).Any(it => it.ToLower() == r.Key.ToLower()))
{
continue;
}
}
if (isPk || isIdentity || isDisableUpdateColumns)
{
if (rowObj.GetType() == type)
{
continue;
}
}
sbSql.Append(string.Format(" [{0}] =@{0} ,", r.Key));
}
sbSql.Remove(sbSql.Length - 1, 1);
if (whereIn.Count() == 0)
{
var value = type.GetProperties().Cast <PropertyInfo>().Single(it => it.Name == pkName).GetValue(rowObj, null);
sbSql.AppendFormat("WHERE {1} IN ('{2}')", typeName, pkName, value);
}
else
{
sbSql.AppendFormat("WHERE {1} IN ({2})", typeName, pkName, whereIn.ToJoinSqlInVal());
}
List <SqlParameter> parsList = new List <SqlParameter>();
var pars = rows.Select(c => new SqlParameter("@" + c.Key, c.Value));
if (pars != null)
{
foreach (var par in pars)
{
var isDisableUpdateColumns = DisableUpdateColumns != null && DisableUpdateColumns.Any(it => it.ToLower() == par.ParameterName.TrimStart('@').ToLower());
if (par.SqlDbType == SqlDbType.Udt || par.ParameterName.ToLower().Contains("hierarchyid"))
{
par.TypeName = "HIERARCHYID";
}
if (!isDisableUpdateColumns)
{
parsList.Add(par);
}
}
}
try
{
var updateRowCount = ExecuteCommand(sbSql.ToString(), parsList.ToArray());
return(updateRowCount > 0);
}
catch (Exception ex)
{
throw new SqlSugarException(ex.Message, sbSql.ToString(), new { rowObj = rowObj, whereIn = whereIn });
}
}
private bool SqlBulkReplace <T>(IEnumerable <T> entities) where T : class
{
if (entities == null)
{
return(false);
}
;
StringBuilder sbSql = new StringBuilder("");
Type type = typeof(T);
string typeName = type.Name;
typeName = GetTableNameByClassType(typeName);
string pkName = SqlSugarTool.GetPrimaryKeyByTableName(this, typeName);
Check.Exception(pkName.IsNullOrEmpty(), "没有找到主键。");
var identityNames = SqlSugarTool.GetIdentitiesKeyByTableName(this, typeName);
var isIdentity = identityNames != null && identityNames.Count > 0;
var columnNames = SqlSugarTool.GetColumnsByTableName(this, typeName);
if (isIdentity)
{
columnNames = columnNames.Where(c => !identityNames.Any(it => it.Value == c)).ToList();//去掉自添列
}
//属性缓存
string cachePropertiesKey = "db." + type.FullName + ".GetProperties";
var cachePropertiesManager = CacheManager <PropertyInfo[]> .GetInstance();
PropertyInfo[] props = null;
if (cachePropertiesManager.ContainsKey(cachePropertiesKey))
{
props = cachePropertiesManager[cachePropertiesKey];
}
else
{
props = type.GetProperties();
cachePropertiesManager.Add(cachePropertiesKey, props, cachePropertiesManager.Day);
}
foreach (var entity in entities)
{
string pkValue = string.Empty;
sbSql.Append(" UPDATE ");
sbSql.Append(typeName);
sbSql.Append(" SET ");
pkValue = props.Single(it => it.Name.ToLower() == pkName.ToLower()).GetValue(entity, null).ToString();
foreach (var name in columnNames)
{
var isPk = pkName != null && pkName.ToLower() == name.ToLower();
var isDisableUpdateColumns = DisableUpdateColumns != null && DisableUpdateColumns.Any(it => it.ToLower() == name.ToLower());
var isLastName = name == columnNames.Last();
var prop = props.Single(it => it.Name == name);
var objValue = prop.GetValue(entity, null);
if (this.IsIgnoreErrorColumns)
{
if (!SqlSugarTool.GetColumnsByTableName(this, typeName).Any(it => it.ToLower() == name.ToLower()))
{
continue;
}
}
if (isPk || isDisableUpdateColumns)
{
continue;
}
bool isNullable = false;
var underType = SqlSugarTool.GetUnderType(prop, ref isNullable);
if (objValue == null)
{
objValue = "NULL";
}
else if (underType == SqlSugarTool.DateType)
{
objValue = "'" + objValue.ToString() + "'";
}
else if (underType == SqlSugarTool.BoolType)
{
objValue = Convert.ToBoolean(objValue) ? 1 : 0;
}
else if (underType == SqlSugarTool.StringType)
{
//string参数需要处理注入 (因为SqlParameter参数上限为2100所以无法使用参数化)
objValue = "'" + objValue.ToString().ToSqlFilter() + "'";
}
else
{
objValue = "'" + objValue.ToString() + "'";
}
sbSql.AppendFormat(" [{0}]={1}{2} ", name, objValue, ",");
}
sbSql.Remove(sbSql.ToString().LastIndexOf(","), 1);
sbSql.AppendFormat("WHERE [{0}]='{1}' ", pkName, pkValue.ToSuperSqlFilter());
}
var reval = base.ExecuteCommand(sbSql.ToString());
sbSql = null;
return(reval > 0);
}
/// <summary>
/// 根据表达式条件将实体对象更新到数据库
/// </summary>
/// <typeparam name="T">实体类型</typeparam>
/// <param name="rowObj">rowObj为匿名对象时只更新指定列( 例如:new{ name='abc'}只更新name )，为T类型将更新整个实体(排除主键、自增列和禁止更新列)</param>
/// <param name="expression">表达式条件</param>
/// <returns>更新成功返回true</returns>
public bool Update <T>(object rowObj, Expression <Func <T, bool> > expression) where T : class
{
if (rowObj == null)
{
throw new ArgumentNullException("SqlSugarClient.Update.rowObj");
}
if (expression == null)
{
throw new ArgumentNullException("SqlSugarClient.Update.expression");
}
Type type = typeof(T);
string typeName = type.Name;
typeName = GetTableNameByClassType(typeName);
var rows = SqlSugarTool.GetParameters(rowObj);
var isDynamic = rowObj.GetType() != type;
var isClass = !isDynamic;
//sql语句缓存
string cacheSqlKey = "db.update." + type.FullName + rows.Length;
var cacheSqlManager = CacheManager <StringBuilder> .GetInstance();
string pkName = SqlSugarTool.GetPrimaryKeyByTableName(this, typeName);
var identityNames = SqlSugarTool.GetIdentitiesKeyByTableName(this, typeName);
ResolveExpress re = new ResolveExpress();
re.ResolveExpression(re, expression);
StringBuilder sbSql = new StringBuilder();
if (cacheSqlManager.ContainsKey(cacheSqlKey) && isClass)
{
sbSql = cacheSqlManager[cacheSqlKey];
}
else
{
sbSql = new StringBuilder(string.Format(" UPDATE [{0}] SET ", typeName));
foreach (var r in rows)
{
var name = r.ParameterName.TrimStart('@');
var isPk = pkName != null && pkName.ToLower() == name.ToLower();
var isIdentity = identityNames.Any(it => it.Value.ToLower() == name.ToLower());
var isDisableUpdateColumns = DisableUpdateColumns != null && DisableUpdateColumns.Any(it => it.ToLower() == name.ToLower());
if (this.IsIgnoreErrorColumns)
{
if (!SqlSugarTool.GetColumnsByTableName(this, typeName).Any(it => it.ToLower() == name.ToLower()))
{
continue;
}
}
if (isPk || isIdentity || isDisableUpdateColumns)
{
if (isClass)
{
continue;
}
}
sbSql.Append(string.Format(" [{0}] =@{0} ,", name));
}
sbSql.Remove(sbSql.Length - 1, 1);
sbSql.Append(" WHERE 1=1 ");
sbSql.Append(re.SqlWhere);
cacheSqlManager.Add(cacheSqlKey, sbSql, cacheSqlManager.Day);
}
List <SqlParameter> parsList = new List <SqlParameter>();
parsList.AddRange(re.Paras);
var pars = rows;
if (pars != null)
{
foreach (var par in pars)
{
if (par.SqlDbType == SqlDbType.Udt)
{
par.TypeName = "HIERARCHYID";
}
SqlSugarTool.SetParSize(par);
parsList.Add(par);
}
}
try
{
var updateRowCount = ExecuteCommand(sbSql.ToString(), parsList.ToArray());
return(updateRowCount > 0);
}
catch (Exception ex)
{
throw new SqlSugarException(ex.Message, sbSql.ToString(), new { rowObj = rowObj, expression = expression + "" });
}
}
