/// <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);
foreach (var r in rows)
{
if (pkName == r.Key)
{
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)
{
if (par.SqlDbType == SqlDbType.Udt || par.ParameterName.ToLower().Contains("hierarchyid"))
{
par.UdtTypeName = "HIERARCHYID";
}
parsList.Add(par);
}
}
try
{
var updateRowCount = ExecuteCommand(sbSql.ToString(), parsList.ToArray());
return(updateRowCount > 0);
}
catch (Exception ex)
{
throw new Exception("sql:" + sbSql.ToString() + "\n" + ex.Message);
}
}
/// <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="expression">new {id=100}</param>
/// <returns></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);
StringBuilder sbSql = new StringBuilder(string.Format(" UPDATE {0} SET ", type.Name));
Dictionary <string, string> rows = SqlSugarTool.GetObjectToDictionary(rowObj);
string pkName = SqlSugarTool.GetPrimaryKeyByTableName(this, type.Name);
foreach (var r in rows)
{
if (pkName == r.Key)
{
if (rowObj.GetType() == type)
{
continue;
}
}
sbSql.Append(string.Format(" {0} =@{0} ,", r.Key));
}
sbSql.Remove(sbSql.Length - 1, 1);
sbSql.Append(" WHERE 1=1 ");
ResolveExpress re = new ResolveExpress();
re.ResolveExpression(re, expression);
sbSql.Append(re.SqlWhere);;
List <SqlParameter> parsList = new List <SqlParameter>();
parsList.AddRange(re.Paras);
parsList.AddRange(rows.Select(c => new SqlParameter("@" + c.Key, c.Value)));
var updateRowCount = ExecuteCommand(sbSql.ToString(), parsList.ToArray());
return(updateRowCount > 0);
}