/// <summary>
/// 更新
/// 注意：rowObj为T类型将更新该实体的非主键所有列，如果rowObj类型为匿名类将更新指定列
/// 使用说明:sqlSugar.Update《T》(rowObj,whereObj);
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="rowObj">new T(){name="张三",sex="男"}或者new {name="张三",sex="男"}</param>
/// <param name="whereIn">new int[]{1,2,3}</param>
/// <returns></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 (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 <MySqlParameter> parsList = new List <MySqlParameter>();
var pars = rows.Select(c => new MySqlParameter("@" + 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 (!isDisableUpdateColumns)
{
parsList.Add(par);
}
}
}
try
{
var updateRowCount = ExecuteCommand(sbSql.ToString(), parsList.ToArray());
return(updateRowCount > 0);
}
catch (Exception ex)
{
var cacheManager = CacheManager <string> .GetInstance();
cacheManager.RemoveAll(it => it.Contains("KeyBy"));
throw new Exception("sql:" + sbSql.ToString() + "\n" + ex.Message);
}
}