public virtual void Delete() { QueueSql.Sql = new StringBuilder(); var strWhereSql = Visit.Where(QueueSql.ExpWhere); if (!string.IsNullOrWhiteSpace(strWhereSql)) { strWhereSql = "WHERE " + strWhereSql; } QueueSql.Sql.AppendFormat("DELETE FROM {0} {1}", QueueManger.DbProvider.KeywordAegis(QueueSql.Name), strWhereSql); }
private static SqlCaluse NotLikeMethod(MethodCallExpression exp, SqlCaluse sqlCaluse) { ExpressionVisit.Where(exp.Arguments[0], sqlCaluse); sqlCaluse += " Not Like "; sqlCaluse.LikeMode = 1; ExpressionVisit.Where(exp.Arguments[1], sqlCaluse); return(sqlCaluse); }
protected override SqlCaluse Where(BinaryExpression exp, SqlCaluse sqlCaluse) { ExpressionVisit.Where(exp.Left, sqlCaluse); var insertIndex = sqlCaluse.Length; ExpressionVisit.Where(exp.Right, sqlCaluse); var endIndex = sqlCaluse.Length; var b = endIndex - insertIndex == 5 && sqlCaluse.EndWith("null"); OperatorParser(exp.NodeType, insertIndex, sqlCaluse.Sql, b); return(sqlCaluse); }
public virtual void ToInfo() { Queue.Sql = new StringBuilder(); var strSelectSql = Visit.Select(Queue.ExpSelect); var strWhereSql = Visit.Where(Queue.ExpWhere); var strOrderBySql = Visit.OrderBy(Queue.ExpOrderBy); if (string.IsNullOrWhiteSpace(strSelectSql)) { strSelectSql = "*"; } if (!string.IsNullOrWhiteSpace(strWhereSql)) { strWhereSql = "WHERE " + strWhereSql; } if (!string.IsNullOrWhiteSpace(strOrderBySql)) { strOrderBySql = "ORDER BY " + strOrderBySql; } Queue.Sql.AppendFormat("SELECT {0} FROM {1} {2} {3} rownum <=1", strSelectSql, Query.DbProvider.KeywordAegis(TableName), strWhereSql, strOrderBySql); }
protected override SqlCaluse Where(UnaryExpression exp, SqlCaluse sqlCaluse) { ExpressionVisit.Where(exp.Operand, sqlCaluse); return(sqlCaluse); }
public virtual Queue ToEntity() { Queue.Sql = new StringBuilder(); var strSelectSql = Visit.Select(Queue.ExpSelect); var strWhereSql = Visit.Where(Queue.ExpWhere); var strOrderBySql = Visit.OrderBy(Queue.ExpOrderBy); if (string.IsNullOrWhiteSpace(strSelectSql)) { strSelectSql = "*"; } if (!string.IsNullOrWhiteSpace(strWhereSql)) { strWhereSql = "WHERE " + strWhereSql; } if (!string.IsNullOrWhiteSpace(strOrderBySql)) { strOrderBySql = "ORDER BY " + strOrderBySql; } Queue.Sql.AppendFormat("SELECT TOP 1 {0} FROM {1} {2} {3}", strSelectSql, QueueManger.DbProvider.KeywordAegis(Queue.Name), strWhereSql, strOrderBySql); return(Queue); }