public void AddUp() { if (((IQueueTable)Queue).ExpAssign == null || ((IQueueTable)Queue).ExpAssign.Count == 0) { throw new Exception("赋值的参数不能为空!"); } Queue.Sql = new StringBuilder(); var strWhereSql = Visit.Where(Queue.ExpWhere); if (!string.IsNullOrWhiteSpace(strWhereSql)) { strWhereSql = "WHERE " + strWhereSql; } #region 字段赋值 var sqlAssign = new StringBuilder(); foreach (var keyValue in ((IQueueTable)Queue).ExpAssign) { var strAssemble = Visit.Assign(keyValue.Key); var strs = strAssemble.Split(','); foreach (var s in strs) { sqlAssign.AppendFormat("{0} = {0} + {1},", s, keyValue.Value); } } if (sqlAssign.Length > 0) { sqlAssign = sqlAssign.Remove(sqlAssign.Length - 1, 1); } #endregion Queue.Sql.AppendFormat("UPDATE {0} SET {1} {2}", Query.DbProvider.KeywordAegis(TableName), sqlAssign, strWhereSql); }
public void Update(TEntity entity) { Queue.Sql = new StringBuilder(); var strWhereSql = Visit.Where(Queue.ExpWhere); var strAssemble = Visit.Assign(entity); if (!string.IsNullOrWhiteSpace(strWhereSql)) { strWhereSql = "WHERE " + strWhereSql; } Queue.Sql.AppendFormat("UPDATE {0} SET {1} {2}", Query.DbProvider.KeywordAegis(TableName), strAssemble, strWhereSql); }