/// <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);
}
