/// <summary> /// where条件语句判断 /// </summary> /// <param name="field"></param> /// <param name="value"></param> /// <param name="sqlOperator"></param> /// <param name="condition"></param> public void AddCondition(string field, object value, SqlOperator sqlOperator, bool condition = true) { if (field.Length > 0) { if (value != null) { #region 逻辑判断 if (sqlOperator.Equals(SqlOperator.Between))//两者之间 { whereStr = field + " between " + value; } else if (sqlOperator.Equals(SqlOperator.Equal))//等于 { whereStr = field + " = " + value; } else if (sqlOperator.Equals(SqlOperator.NotEqual))//不等于 { whereStr = field + " != " + value; } else if (sqlOperator.Equals(SqlOperator.GreaterThan))//大于 { whereStr = field + " > " + value; } else if (sqlOperator.Equals(SqlOperator.GreaterThanEqual))//大于等于 { whereStr = field + " >= " + value; } else if (sqlOperator.Equals(SqlOperator.LessThan))//小于 { whereStr = field + " < " + value; } else if (sqlOperator.Equals(SqlOperator.LessThanEqual))//小于等于 { whereStr = field + " <= " + value; } else if (sqlOperator.Equals(SqlOperator.Like))//模糊查询 { whereStr = field + " like '%" + value + "%'"; } else if (sqlOperator.Equals(SqlOperator.LikeLeft))//左侧模糊 { whereStr = field + " like '%" + value + "'"; } else if (sqlOperator.Equals(SqlOperator.LikeRight))//右侧模糊 { whereStr = field + " like '" + value + "%'"; } else if (sqlOperator.Equals(SqlOperator.In))//包含 { whereStr = field + " in (" + value + ")"; } #endregion } } }