/// <summary> /// And /// </summary> /// <param name="where"></param> /// <returns></returns> public WhereClip And(WhereClip where) { if (WhereClip.IsNullOrEmpty(this) && WhereClip.IsNullOrEmpty(where)) { return(All); } if (WhereClip.IsNullOrEmpty(where)) { return(this); } if (WhereClip.IsNullOrEmpty(this)) { return(where); } WhereClip andwhere = new WhereClip(string.Concat(this.Where, " AND ", where.Where)); andwhere.parameters.AddRange(this.Parameters); andwhere.parameters.AddRange(where.Parameters); return(andwhere); }
/// <summary> /// Or /// </summary> /// <param name="leftWhere"></param> /// <param name="rightWhere"></param> /// <returns></returns> public static WhereClip operator |(WhereClip leftWhere, WhereClip rightWhere) { if (WhereClip.IsNullOrEmpty(leftWhere)) { return(rightWhere); } return(leftWhere.Or(rightWhere)); }
/// <summary> /// 删除 /// </summary> /// <typeparam name="TEntity"></typeparam> /// <param name="entity"></param> /// <returns></returns> public void Delete <TEntity>(TEntity entity) where TEntity : Entity { Check.Require(!EntityCache.IsReadOnly <TEntity>(), string.Concat("Entity(", EntityCache.GetTableName <TEntity>(), ") is readonly!")); WhereClip where = DataUtils.GetPrimaryKeyWhere(entity); Check.Require(!WhereClip.IsNullOrEmpty(where), "entity must have the primarykey!"); Delete <TEntity>(where); //2015-08-20注释 //Delete<TEntity>(entity, where); }
/// <summary> /// 更新 /// </summary> /// <typeparam name="TEntity"></typeparam> /// <param name="entity"></param> public void Update <TEntity>(TEntity entity) where TEntity : Entity { if (entity.GetModifyFields().Count == 0) { return; } WhereClip where = DataUtils.GetPrimaryKeyWhere(entity); Check.Require(!WhereClip.IsNullOrEmpty(where), "entity must have the primarykey!"); Update <TEntity>(entity, where); }
/// <summary> /// 更新全部字段 /// </summary> /// <typeparam name="TEntity"></typeparam> /// <param name="entity"></param> public void UpdateAll <TEntity>(TEntity entity) where TEntity : Entity { if (entity == null) { return; } WhereClip where = DataUtils.GetPrimaryKeyWhere(entity); Check.Require(!WhereClip.IsNullOrEmpty(where), "entity must have the primarykey!"); UpdateAll <TEntity>(entity, where); }
/// <summary> /// 更新 /// </summary> /// <typeparam name="TEntity"></typeparam> /// <param name="entity"></param> public void Update <TEntity>(TEntity entity) where TEntity : Entity { if (!entity.IsModify()) { return; } var where = DataUtils.GetPrimaryKeyWhere(entity); Check.Require(!WhereClip.IsNullOrEmpty(where), "entity must have the primarykey!"); Update <TEntity>(entity, where); }
/// <summary> /// 创建删除DbCommand /// </summary> /// <param name="tableName"></param> /// <param name="where"></param> /// <returns></returns> public DbCommand CreateDeleteCommand(string tableName, WhereClip where) { if (WhereClip.IsNullOrEmpty(where)) { throw new Exception("请传入删除条件,删除整表数据请使用.DeleteAll<T>()方法。"); } //where = WhereClip.All; //2015-08-08 StringBuilder sql = new StringBuilder(); sql.Append("DELETE FROM "); sql.Append(db.DbProvider.BuildTableName(tableName)); sql.Append(where.WhereString); DbCommand cmd = db.GetSqlStringCommand(sql.ToString()); db.AddCommandParameter(cmd, where.Parameters.ToArray()); return(cmd); }
/// <summary> /// AND /// </summary> /// <param name="where"></param> public void And(WhereClip where) { if (WhereClip.IsNullOrEmpty(where)) { return; } if (expressionStringBuilder.Length > 0) { expressionStringBuilder.Append(" AND "); expressionStringBuilder.Append(where.ToString()); expressionStringBuilder.Append(")"); expressionStringBuilder.Insert(0, "("); } else { expressionStringBuilder.Append(where.ToString()); } parameters.AddRange(where.Parameters); }
/// <summary> /// Or /// </summary> /// <param name="where"></param> /// <returns></returns> public WhereClip Or(WhereClip where) { if (WhereClip.IsNullOrEmpty(this) && WhereClip.IsNullOrEmpty(where)) { return(All); } if (WhereClip.IsNullOrEmpty(where)) { return(this); } if (WhereClip.IsNullOrEmpty(this)) { return(where); } WhereClip orwhere = new WhereClip(string.Concat(this.Where, " OR ", where.Where)); orwhere.parameters.AddRange(this.Parameters); orwhere.parameters.AddRange(where.Parameters); return(orwhere); }
/// <summary> /// 创建更新DbCommand /// </summary> /// <typeparam name="TEntity"></typeparam> /// <param name="fields"></param> /// <param name="values"></param> /// <param name="where"></param> /// <returns></returns> public DbCommand CreateUpdateCommand <TEntity>(Field[] fields, object[] values, WhereClip where) where TEntity : Entity { Check.Require(!EntityCache.IsReadOnly <TEntity>(), string.Concat("Entity(", EntityCache.GetTableName <TEntity>(), ") is readonly!")); if (null == fields || fields.Length == 0 || null == values || values.Length == 0) { return(null); } Check.Require(fields.Length == values.Length, "fields.Length must be equal values.Length"); int length = fields.Length; if (WhereClip.IsNullOrEmpty(where)) { where = WhereClip.All; } StringBuilder sql = new StringBuilder(); sql.Append("UPDATE "); sql.Append(db.DbProvider.BuildTableName(EntityCache.GetTableName <TEntity>())); sql.Append(" SET "); Field identityField = EntityCache.GetIdentityField <TEntity>(); bool identityExist = !Field.IsNullOrEmpty(identityField); List <Parameter> list = new List <Parameter>(); StringBuilder colums = new StringBuilder(); for (int i = 0; i < length; i++) { if (identityExist) { //标识列 排除 if (fields[i].PropertyName.Equals(identityField.PropertyName)) { continue; } } colums.Append(","); colums.Append(fields[i].FieldName); colums.Append("="); if (values[i] is Expression) { Expression expression = (Expression)values[i]; colums.Append(expression.ToString()); list.AddRange(expression.Parameters); } else if (values[i] is Field) { Field fieldValue = (Field)values[i]; colums.Append(fieldValue.TableFieldName); } else { string pname = DataUtils.MakeUniqueKey(fields[i]); //string pname = fields[i].tableName + fields[i].Name + i; colums.Append(pname); Parameter p = new Parameter(pname, values[i], fields[i].ParameterDbType, fields[i].ParameterSize); list.Add(p); } } sql.Append(colums.ToString().Substring(1)); sql.Append(where.WhereString); list.AddRange(where.Parameters); DbCommand cmd = db.GetSqlStringCommand(sql.ToString()); db.AddCommandParameter(cmd, list.ToArray()); return(cmd); }