// 创建 DELETE 命令
protected override DbCommandDefinition ParseDeleteCommand <T>(DbQueryableInfo_Delete <T> dQuery, List <IDbDataParameter> parameters = null)
{
TypeRuntimeInfo typeRuntime = TypeRuntimeInfoCache.GetRuntimeInfo <T>();
ISqlBuilder builder = this.CreateSqlBuilder(parameters);
bool useKey = false;
builder.Append("DELETE FROM ");
builder.AppendMember(typeRuntime.TableName, !typeRuntime.IsTemporary);
builder.Append(" t0 ");
if (dQuery.Entity != null)
{
object entity = dQuery.Entity;
builder.AppendNewLine();
builder.Append("WHERE ");
foreach (var kv in typeRuntime.Invokers)
{
MemberInvokerBase invoker = kv.Value;
var column = invoker.Column;
if (column != null && column.IsKey)
{
useKey = true;
var value = invoker.Invoke(entity);
var seg = builder.GetSqlValue(value, column);
builder.AppendMember("t0", invoker.Member.Name);
builder.Append(" = ");
builder.Append(seg);
builder.Append(" AND ");
}
;
}
builder.Length -= 5;
if (!useKey)
{
throw new XFrameworkException("Delete<T>(T value) require T must have key column.");
}
}
else if (dQuery.SelectInfo != null)
{
TableAliasCache aliases = this.PrepareAlias <T>(dQuery.SelectInfo);
var cmd2 = new OracleDbCommandDefinition_Delete(this, aliases, builder.Parameters);
cmd2.HaveListNavigation = dQuery.SelectInfo.HaveListNavigation;
var visitor0 = new OracleJoinExpressionVisitor(this, aliases, dQuery.SelectInfo.Join, dQuery.SelectInfo.Where);
visitor0.Write(cmd2);
var visitor1 = new OracleWhereExpressionVisitor(this, aliases, dQuery.SelectInfo.Where);
visitor1.Write(cmd2.WhereFragment);
cmd2.AddNavMembers(visitor1.NavMembers);
builder.Append(cmd2.CommandText);
}
builder.Append(';');
return(new DbCommandDefinition(builder.ToString(), builder.Parameters, System.Data.CommandType.Text));
}
// 创建 DELETE 命令
protected override Command ResolveDeleteCommand <T>(DbQueryableInfo_Delete <T> dbQuery, ResolveToken token)
{
ISqlBuilder builder = this.CreateSqlBuilder(token);
TypeRuntimeInfo typeRuntime = TypeRuntimeInfoCache.GetRuntimeInfo <T>();
IDbQueryable sourceQuery = dbQuery.SourceQuery;
var context = (SqlServerDbContext)sourceQuery.DbContext;
builder.Append("DELETE t0 FROM ");
builder.AppendMember(typeRuntime.TableName, !typeRuntime.IsTemporary);
builder.Append(" t0 ");
if (dbQuery.Entity != null)
{
if (typeRuntime.KeyInvokers == null || typeRuntime.KeyInvokers.Count == 0)
{
throw new XFrameworkException("Delete<T>(T value) require entity must have key column.");
}
object entity = dbQuery.Entity;
builder.AppendNewLine();
builder.Append("WHERE ");
foreach (var invoker in typeRuntime.KeyInvokers)
{
var column = invoker.Column;
var value = invoker.Invoke(entity);
var seg = this.DbValue.GetSqlValue(value, token, column);
builder.AppendMember("t0", invoker.Member.Name);
builder.Append(" = ");
builder.Append(seg);
builder.Append(" AND ");
}
builder.Length -= 5;
}
else if (dbQuery.SelectInfo != null)
{
TableAliasCache aliases = this.PrepareTableAlias <T>(dbQuery.SelectInfo, token);
var cmd2 = new SqlServerMapperCommand(context, aliases, token)
{
HasMany = dbQuery.SelectInfo.HasMany
};
ExpressionVisitorBase visitor = new SqlServerJoinExpressionVisitor(context, aliases, dbQuery.SelectInfo.Joins);
visitor.Write(cmd2.JoinFragment);
visitor = new WhereExpressionVisitor(this, aliases, dbQuery.SelectInfo.Condtion);
visitor.Write(cmd2.WhereFragment);
cmd2.AddNavMembers(visitor.NavMembers);
builder.Append(cmd2.CommandText);
}
return(new Command(builder.ToString(), builder.Token != null ? builder.Token.Parameters : null, System.Data.CommandType.Text));
}
// 创建 DELETE 命令
protected override Command ParseDeleteCommand <T>(DbQueryableInfo_Delete <T> dQueryInfo, ResolveToken token)
{
TypeRuntimeInfo typeRuntime = TypeRuntimeInfoCache.GetRuntimeInfo <T>();
ISqlBuilder builder = this.CreateSqlBuilder(token);
builder.Append("DELETE FROM ");
builder.AppendMember(typeRuntime.TableName, !typeRuntime.IsTemporary);
builder.Append(" t0 ");
if (dQueryInfo.Entity != null)
{
if (typeRuntime.KeyInvokers == null || typeRuntime.KeyInvokers.Count == 0)
{
throw new XFrameworkException("Delete<T>(T value) require entity must have key column.");
}
object entity = dQueryInfo.Entity;
builder.AppendNewLine();
builder.Append("WHERE ");
foreach (var invoker in typeRuntime.KeyInvokers)
{
var column = invoker.Column;
var value = invoker.Invoke(entity);
var seg = this.DbValue.GetSqlValue(value, token, column);
builder.AppendMember("t0", invoker.Member.Name);
builder.Append(" = ");
builder.Append(seg);
builder.Append(" AND ");
}
builder.Length -= 5;
}
else if (dQueryInfo.SelectInfo != null)
{
TableAliasCache aliases = this.PrepareAlias <T>(dQueryInfo.SelectInfo, token);
var cmd2 = new NpgNavigationCommand(this, aliases, DbExpressionType.Delete, token)
{
HasMany = dQueryInfo.SelectInfo.HasMany
};
var visitor0 = new NpgJoinExpressionVisitor(this, aliases, dQueryInfo.SelectInfo.Joins, DbExpressionType.Delete);
visitor0.Write(cmd2);
var visitor1 = new NpgWhereExpressionVisitor(this, aliases, dQueryInfo.SelectInfo.WhereExpression);
visitor1.Write(cmd2.WhereFragment);
cmd2.AddNavMembers(visitor1.NavMembers);
builder.Append(cmd2.CommandText);
}
builder.Append(';');
return(new Command(builder.ToString(), builder.Token != null ? builder.Token.Parameters : null, System.Data.CommandType.Text));
}
// 获取实例的属性值
private static IDictionary <ValidationContext, object> GetPropertyValues(object instance, ValidationContext context)
{
IDictionary <ValidationContext, object> result = new Dictionary <ValidationContext, object>();
TypeRuntimeInfo typeRuntime = TypeRuntimeInfoCache.GetRuntimeInfo(instance.GetType());
foreach (var invoker in typeRuntime.Invokers)
{
if (invoker.MemberType == System.Reflection.MemberTypes.Property)
{
ValidationContext context2 = XFrameworkValidator.CreateValidationContext(instance, context);
context2.MemberName = invoker.Member.Name;
if (XFrameworkValidator._store.GetPropertyValidationAttributes(context2).Any <ValidationAttribute>())
{
result.Add(context2, invoker.Invoke(instance));
}
}
}
return(result);
}
// 创建 DELETE 命令
protected override Command ParseDeleteCommand <T>(DbQueryableInfo_Delete <T> dQueryInfo, ParserToken token)
{
TypeRuntimeInfo typeRuntime = TypeRuntimeInfoCache.GetRuntimeInfo <T>();
ISqlBuilder builder = this.CreateSqlBuilder(token);
bool useKey = false;
builder.Append("DELETE t0 FROM ");
builder.AppendMember(typeRuntime.TableName, !typeRuntime.IsTemporary);
builder.Append(" t0 ");
if (dQueryInfo.Entity != null)
{
object entity = dQueryInfo.Entity;
builder.AppendNewLine();
builder.Append("WHERE ");
foreach (var kv in typeRuntime.Invokers)
{
MemberInvokerBase invoker = kv.Value;
var column = invoker.Column;
if (column != null && column.IsKey)
{
useKey = true;
var value = invoker.Invoke(entity);
var seg = builder.GetSqlValue(value, column);
builder.AppendMember("t0", invoker.Member.Name);
builder.Append(" = ");
builder.Append(seg);
builder.Append(" AND ");
}
;
}
builder.Length -= 5;
if (!useKey)
{
throw new XFrameworkException("Delete<T>(T value) require T must have key column.");
}
}
else if (dQueryInfo.SelectInfo != null)
{
IDbQueryable dbQueryable = dQueryInfo.SourceQuery;
TableAliasCache aliases = this.PrepareAlias <T>(dQueryInfo.SelectInfo, token);
var cmd2 = new SelectCommand(this, aliases, token)
{
HasManyNavigation = dQueryInfo.SelectInfo.HasManyNavigation
};
ExpressionVisitorBase visitor = new JoinExpressionVisitor(this, aliases, dQueryInfo.SelectInfo.Joins);
visitor.Write(cmd2.JoinFragment);
visitor = new WhereExpressionVisitor(this, aliases, dQueryInfo.SelectInfo.WhereExpression);
visitor.Write(cmd2.WhereFragment);
cmd2.AddNavMembers(visitor.NavMembers);
builder.Append(cmd2.CommandText);
}
return(new Command(builder.ToString(), builder.Token != null ? builder.Token.Parameters : null, System.Data.CommandType.Text));
}
// 创建 INSRT 命令
protected override Command ParseInsertCommand <T>(DbQueryableInfo_Insert <T> nQueryInfo, ParserToken token)
{
ISqlBuilder builder = this.CreateSqlBuilder(token);
TypeRuntimeInfo typeRuntime = TypeRuntimeInfoCache.GetRuntimeInfo <T>();
TableAliasCache aliases = new TableAliasCache();
if (nQueryInfo.Entity != null)
{
object entity = nQueryInfo.Entity;
ISqlBuilder columnsBuilder = this.CreateSqlBuilder(token);
ISqlBuilder valuesBuilder = this.CreateSqlBuilder(token);
// 指定插入列
Dictionary <string, MemberInvokerBase> invokers = typeRuntime.Invokers;
if (nQueryInfo.EntityColumns != null && nQueryInfo.EntityColumns.Count > 0)
{
invokers = new Dictionary <string, MemberInvokerBase>();
for (int i = 0; i < nQueryInfo.EntityColumns.Count; i++)
{
Expression curExpr = nQueryInfo.EntityColumns[i];
if (curExpr.NodeType == ExpressionType.Lambda)
{
curExpr = (curExpr as LambdaExpression).Body.ReduceUnary();
}
if (curExpr.NodeType != ExpressionType.MemberAccess)
{
throw new XFrameworkException("ERR {0}: Only support MemberAccess expression.", nQueryInfo.EntityColumns[i]);
}
MemberExpression member = curExpr as MemberExpression;
string name = member.Member.Name;
invokers[name] = typeRuntime.Invokers[name];
}
}
foreach (var kv in invokers)
{
MemberInvokerBase invoker = kv.Value;
var column = invoker.Column;
if (column != null && column.NoMapped)
{
continue;
}
if (invoker.ForeignKey != null)
{
continue;
}
if (invoker.Column != null && column.DbType is SqlDbType && (SqlDbType)column.DbType == SqlDbType.Timestamp)
{
continue; // 行版本号
}
if (invoker.Member.MemberType == System.Reflection.MemberTypes.Method)
{
continue;
}
if (invoker != nQueryInfo.AutoIncrement)
{
columnsBuilder.AppendMember(invoker.Member.Name);
columnsBuilder.Append(',');
var value = invoker.Invoke(entity);
string seg = builder.GetSqlValueWidthDefault(value, column);
valuesBuilder.Append(seg);
valuesBuilder.Append(',');
}
}
columnsBuilder.Length -= 1;
valuesBuilder.Length -= 1;
if (nQueryInfo.Bulk == null || !nQueryInfo.Bulk.OnlyValue)
{
builder.Append("INSERT INTO ");
builder.AppendMember(typeRuntime.TableName, !typeRuntime.IsTemporary);
builder.Append('(');
builder.Append(columnsBuilder);
builder.Append(')');
builder.AppendNewLine();
builder.AppendNewTab();
builder.Append("VALUES");
}
if (nQueryInfo.Bulk != null && nQueryInfo.Bulk.OnlyValue)
{
builder.AppendNewTab();
}
builder.Append('(');
builder.Append(valuesBuilder);
builder.Append(')');
if (nQueryInfo.Bulk != null && !nQueryInfo.Bulk.IsEndPos)
{
builder.Append(",");
builder.AppendNewLine();
}
if (nQueryInfo.Bulk == null && nQueryInfo.AutoIncrement != null)
{
builder.AppendNewLine();
builder.Append("SELECT SCOPE_IDENTITY()");
builder.AppendAs(Constant.AUTOINCREMENTNAME);
}
}
else if (nQueryInfo.SelectInfo != null)
{
builder.Append("INSERT INTO ");
builder.AppendMember(typeRuntime.TableName, !typeRuntime.IsTemporary);
builder.Append('(');
int i = 0;
SelectCommand cmd2 = this.ParseSelectCommand(nQueryInfo.SelectInfo, 0, true, token) as SelectCommand;
foreach (var kvp in cmd2.Columns)
{
builder.AppendMember(kvp.Key);
if (i < cmd2.Columns.Count - 1)
{
builder.Append(',');
}
i++;
}
builder.Append(')');
builder.AppendNewLine();
builder.Append(cmd2.CommandText);
}
return(new Command(builder.ToString(), builder.Token != null ? builder.Token.Parameters : null, System.Data.CommandType.Text));
}
// 创建 INSRT 命令
protected override DbCommandDefinition ParseInsertCommand <T>(DbQueryableInfo_Insert <T> nQuery, List <IDbDataParameter> parameters = null)
{
ISqlBuilder builder = this.CreateSqlBuilder(parameters);
TypeRuntimeInfo typeRuntime = TypeRuntimeInfoCache.GetRuntimeInfo <T>();
TableAliasCache aliases = new TableAliasCache();
bool useSEQ = false;
if (nQuery.Entity != null)
{
// 如果没有Sequence列，使用 INSERT ALL INTO 语法，否则就一条一条逐行写入~~
// 批量 INSERT，自增列不会自动赋值
object entity = nQuery.Entity;
ISqlBuilder columnsBuilder = this.CreateSqlBuilder(builder.Parameters);
ISqlBuilder valuesBuilder = this.CreateSqlBuilder(builder.Parameters);
// 指定插入列
Dictionary <string, MemberInvokerBase> invokers = typeRuntime.Invokers;
if (nQuery.EntityColumns != null && nQuery.EntityColumns.Count > 0)
{
invokers = new Dictionary <string, MemberInvokerBase>();
for (int i = 0; i < nQuery.EntityColumns.Count; i++)
{
Expression curExpr = nQuery.EntityColumns[i];
if (curExpr.NodeType == ExpressionType.Lambda)
{
curExpr = (curExpr as LambdaExpression).Body.ReduceUnary();
}
if (curExpr.NodeType != ExpressionType.MemberAccess)
{
throw new XFrameworkException("Can't read field name from expression {0}", nQuery.EntityColumns[i]);
}
MemberExpression member = curExpr as MemberExpression;
string name = member.Member.Name;
invokers[name] = typeRuntime.Invokers[name];
}
}
// 自增列参数
IDbDataParameter seqParameter = null;
// 自增列标记
ColumnAttribute seqColumn = null;
foreach (var kv in invokers)
{
MemberInvokerBase invoker = kv.Value;
var column = invoker.Column;
if (column != null && column.NoMapped)
{
continue;
}
if (invoker.ForeignKey != null)
{
continue;
}
if (invoker.Member.MemberType == System.Reflection.MemberTypes.Method)
{
continue;
}
columnsBuilder.AppendMember(invoker.Member.Name);
columnsBuilder.Append(',');
if (invoker == nQuery.AutoIncrement)
{
seqColumn = column;
if (nQuery.Bulk == null)
{
// 非批量INSERT，产生一个 OUTPUT 类型的参数
string pName = string.Format("{0}p{1}", this.ParameterPrefix, builder.Parameters.Count);
var database = nQuery.SourceQuery.DbContext.Database;
seqParameter = database.CreateParameter(pName, -1, direction: ParameterDirection.Output);
builder.Parameters.Add(seqParameter);
valuesBuilder.Append(seqParameter.ParameterName);
valuesBuilder.Append(',');
}
else
{
valuesBuilder.Append(((OracleColumnAttribute)column).SEQName);
valuesBuilder.Append(".NEXTVAL");
valuesBuilder.Append(',');
}
}
else
{
var value = invoker.Invoke(entity);
string seg = builder.GetSqlValueWidthDefault(value, column);
valuesBuilder.Append(seg);
valuesBuilder.Append(',');
}
}
columnsBuilder.Length -= 1;
valuesBuilder.Length -= 1;
if (nQuery.Bulk == null)
{
// 非批量INSERT，产生一个 OUTPUT 类型的参数
if (seqParameter != null)
{
seqParameter.Direction = ParameterDirection.Output;
seqParameter.DbType = DbType.Int64;
builder.Append("SELECT ");
builder.Append(((OracleColumnAttribute)seqColumn).SEQName);
builder.Append(".NEXTVAL INTO ");
builder.Append(seqParameter.ParameterName);
builder.Append(" FROM DUAL;");
builder.AppendNewLine();
useSEQ = true;
}
builder.Append("INSERT ");
}
else
{
// 批量 INSERT
if (!nQuery.Bulk.OnlyValue || seqColumn != null)
{
builder.Append("INSERT ");
}
// 如果有自增列则不使用 INSERT ALL INTO 语法
if (!nQuery.Bulk.OnlyValue && seqColumn == null)
{
builder.Append("ALL ");
}
}
builder.Append("INTO ");
builder.AppendMember(typeRuntime.TableName, !typeRuntime.IsTemporary);
builder.Append('(');
builder.Append(columnsBuilder);
builder.Append(')');
builder.AppendNewLine();
builder.AppendNewTab();
builder.Append("VALUES");
builder.Append('(');
builder.Append(valuesBuilder);
builder.Append(')');
if (nQuery.Bulk == null)
{
builder.Append(';');
}
else
{
if (seqColumn != null)
{
if (nQuery.Bulk.IsEndPos)
{
builder.Append(";");
}
else
{
builder.AppendNewLine(";");
}
}
else
{
builder.AppendNewLine();
if (nQuery.Bulk.IsEndPos)
{
builder.Append("SELECT 1 FROM DUAL;");
}
}
}
}
else if (nQuery.SelectInfo != null)
{
builder.Append("INSERT INTO ");
builder.AppendMember(typeRuntime.TableName, !typeRuntime.IsTemporary);
builder.Append('(');
int i = 0;
DbCommandDefinition_Select cmd2 = this.ParseSelectCommand(nQuery.SelectInfo, 0, false, builder.Parameters) as DbCommandDefinition_Select;
foreach (var kvp in cmd2.Columns)
{
builder.AppendMember(kvp.Key);
if (i < cmd2.Columns.Count - 1)
{
builder.Append(',');
}
i++;
}
builder.Append(')');
builder.AppendNewLine();
builder.Append(cmd2.CommandText);
builder.Append(';');
}
var cmd = new OracleDbCommandDefinition_Insert(builder.ToString(), builder.Parameters, System.Data.CommandType.Text);
cmd.HaveSEQ = useSEQ;
return(cmd);
}
// 创建 INSRT 命令
protected override Command ResolveInsertCommand <T>(DbQueryableInfo_Insert <T> dbQuery, ResolveToken token)
{
ISqlBuilder builder = this.CreateSqlBuilder(token);
TypeRuntimeInfo typeRuntime = TypeRuntimeInfoCache.GetRuntimeInfo <T>();
TableAliasCache aliases = new TableAliasCache();
if (dbQuery.Entity != null)
{
object entity = dbQuery.Entity;
ISqlBuilder columnsBuilder = this.CreateSqlBuilder(token);
ISqlBuilder valuesBuilder = this.CreateSqlBuilder(token);
// 指定插入列
MemberInvokerCollection invokers = typeRuntime.Invokers;
if (dbQuery.EntityColumns != null && dbQuery.EntityColumns.Count > 0)
{
invokers = new MemberInvokerCollection();
for (int i = 0; i < dbQuery.EntityColumns.Count; i++)
{
Expression curExpr = dbQuery.EntityColumns[i];
if (curExpr.NodeType == ExpressionType.Lambda)
{
curExpr = (curExpr as LambdaExpression).Body.ReduceUnary();
}
if (curExpr.NodeType != ExpressionType.MemberAccess)
{
throw new XFrameworkException("Can't read field name from expression {0}", dbQuery.EntityColumns[i]);
}
MemberExpression member = curExpr as MemberExpression;
string name = member.Member.Name;
invokers[name] = typeRuntime.Invokers[name];
}
}
foreach (var invoker in invokers)
{
var column = invoker.Column;
if (column != null && column.NoMapped)
{
continue;
}
if (invoker.ForeignKey != null)
{
continue;
}
if (invoker.Member.MemberType == System.Reflection.MemberTypes.Method)
{
continue;
}
if (invoker != dbQuery.AutoIncrement)
{
columnsBuilder.AppendMember(invoker.Member.Name);
columnsBuilder.Append(',');
var value = invoker.Invoke(entity);
string seg = this.DbValue.GetSqlValueWidthDefault(value, token, column);
valuesBuilder.Append(seg);
valuesBuilder.Append(',');
}
}
columnsBuilder.Length -= 1;
valuesBuilder.Length -= 1;
if (dbQuery.Bulk == null || !dbQuery.Bulk.OnlyValue)
{
builder.Append("INSERT INTO ");
builder.AppendMember(typeRuntime.TableName, !typeRuntime.IsTemporary);
builder.Append('(');
builder.Append(columnsBuilder);
builder.Append(')');
builder.AppendNewLine();
builder.AppendNewTab();
builder.Append("VALUES");
}
builder.Append('(');
builder.Append(valuesBuilder);
builder.Append(')');
if (dbQuery.Bulk != null && !dbQuery.Bulk.IsEndPos)
{
builder.Append(",");
}
if (dbQuery.Bulk == null && dbQuery.AutoIncrement != null)
{
builder.Append(';');
builder.AppendNewLine();
// sequence，命名原则是 tablename_columnname_seq.
builder.AppendFormat("SELECT CURRVAL('{0}_{1}_seq')", typeRuntime.TableName, dbQuery.AutoIncrement.Member.Name);
builder.Append(" AS ");
builder.Append(this.QuotePrefix);
builder.Append(Constant.AUTOINCREMENTNAME);
builder.Append(this.QuoteSuffix);
}
}
else if (dbQuery.SelectInfo != null)
{
builder.Append("INSERT INTO ");
builder.AppendMember(typeRuntime.TableName, !typeRuntime.IsTemporary);
builder.Append('(');
int i = 0;
MapperCommand cmd2 = this.ResolveSelectCommandImpl(dbQuery.SelectInfo, 0, false, token) as MapperCommand;
//for (int i = 0; i < seg.Columns.Count; i++)
foreach (var column in cmd2.PickColumns)
{
builder.AppendMember(column.Name);
if (i < cmd2.PickColumns.Count - 1)
{
builder.Append(',');
}
i++;
}
builder.Append(')');
builder.AppendNewLine();
builder.Append(cmd2.CommandText);
}
if (dbQuery.Bulk == null || dbQuery.Bulk.IsEndPos)
{
builder.Append(';');
}
return(new Command(builder.ToString(), builder.Token != null ? builder.Token.Parameters : null, System.Data.CommandType.Text));
}
// 创建 INSRT 命令
protected override DbCommandDefinition ParseInsertCommand <T>(DbQueryableInfo_Insert <T> nQuery, List <IDbDataParameter> parameters = null)
{
ISqlBuilder builder = this.CreateSqlBuilder(parameters);
TypeRuntimeInfo typeRuntime = TypeRuntimeInfoCache.GetRuntimeInfo <T>();
TableAliasCache aliases = new TableAliasCache();
if (nQuery.Entity != null)
{
object entity = nQuery.Entity;
ISqlBuilder columnsBuilder = this.CreateSqlBuilder(builder.Parameters);
ISqlBuilder valuesBuilder = this.CreateSqlBuilder(builder.Parameters);
// 指定插入列
Dictionary <string, MemberInvokerBase> invokers = typeRuntime.Invokers;
if (nQuery.EntityColumns != null && nQuery.EntityColumns.Count > 0)
{
invokers = new Dictionary <string, MemberInvokerBase>();
for (int i = 0; i < nQuery.EntityColumns.Count; i++)
{
Expression curExpr = nQuery.EntityColumns[i];
if (curExpr.NodeType == ExpressionType.Lambda)
{
curExpr = (curExpr as LambdaExpression).Body.ReduceUnary();
}
if (curExpr.NodeType != ExpressionType.MemberAccess)
{
throw new XFrameworkException("Can't read field name from expression {0}", nQuery.EntityColumns[i]);
}
MemberExpression member = curExpr as MemberExpression;
string name = member.Member.Name;
invokers[name] = typeRuntime.Invokers[name];
}
}
foreach (var kv in invokers)
{
MemberInvokerBase invoker = kv.Value;
var column = invoker.Column;
if (column != null && column.NoMapped)
{
continue;
}
if (invoker.ForeignKey != null)
{
continue;
}
if (invoker.Member.MemberType == System.Reflection.MemberTypes.Method)
{
continue;
}
if (invoker != nQuery.AutoIncrement)
{
columnsBuilder.AppendMember(invoker.Member.Name);
columnsBuilder.Append(',');
var value = invoker.Invoke(entity);
string seg = builder.GetSqlValueWidthDefault(value, column);
valuesBuilder.Append(seg);
valuesBuilder.Append(',');
}
}
columnsBuilder.Length -= 1;
valuesBuilder.Length -= 1;
if (nQuery.Bulk == null || !nQuery.Bulk.OnlyValue)
{
builder.Append("INSERT INTO ");
builder.AppendMember(typeRuntime.TableName, !typeRuntime.IsTemporary);
builder.Append('(');
builder.Append(columnsBuilder);
builder.Append(')');
builder.AppendNewLine();
builder.AppendNewTab();
builder.Append("VALUES");
}
if (nQuery.Bulk != null && nQuery.Bulk.OnlyValue)
{
builder.AppendNewTab();
}
builder.Append('(');
builder.Append(valuesBuilder);
builder.Append(')');
if (nQuery.Bulk != null && !nQuery.Bulk.IsEndPos)
{
builder.Append(",");
builder.AppendNewLine();
}
if (nQuery.Bulk == null && nQuery.AutoIncrement != null)
{
builder.Append(';');
builder.AppendNewLine();
builder.Append("SELECT LAST_INSERT_ID()");
builder.AppendAs(Constant.AUTOINCREMENTNAME);
}
}
else if (nQuery.SelectInfo != null)
{
builder.Append("INSERT INTO ");
builder.AppendMember(typeRuntime.TableName, !typeRuntime.IsTemporary);
builder.Append('(');
int i = 0;
DbCommandDefinition_Select cmd2 = this.ParseSelectCommandImpl(nQuery.SelectInfo, 0, true, builder.Parameters) as DbCommandDefinition_Select;
foreach (var kvp in cmd2.Columns)
{
builder.AppendMember(kvp.Key);
if (i < cmd2.Columns.Count - 1)
{
builder.Append(',');
}
i++;
}
builder.Append(')');
builder.AppendNewLine();
builder.Append(cmd2.CommandText);
}
if (nQuery.Bulk == null || nQuery.Bulk.IsEndPos)
{
builder.Append(';');
}
return(new DbCommandDefinition(builder.ToString(), builder.Parameters, System.Data.CommandType.Text));
}
// 创建 DELETE 命令
protected override Command ParseDeleteCommand <T>(DbQueryableInfo_Delete <T> dQueryInfo, ResolveToken token)
{
ISqlBuilder builder = this.CreateSqlBuilder(token);
TypeRuntimeInfo typeRuntime = TypeRuntimeInfoCache.GetRuntimeInfo <T>();
builder.Append("DELETE FROM ");
builder.AppendMember(typeRuntime.TableName, !typeRuntime.IsTemporary);
builder.Append(" ");
if (dQueryInfo.Entity != null)
{
if (typeRuntime.KeyInvokers == null || typeRuntime.KeyInvokers.Count == 0)
{
throw new XFrameworkException("Delete<T>(T value) require entity must have key column.");
}
object entity = dQueryInfo.Entity;
builder.AppendNewLine();
builder.Append("WHERE ");
foreach (var invoker in typeRuntime.KeyInvokers)
{
var column = invoker.Column;
var value = invoker.Invoke(entity);
var seg = this.DbValue.GetSqlValue(value, token, column);
builder.AppendMember(invoker.Member.Name);
builder.Append(" = ");
builder.Append(seg);
builder.Append(" AND ");
}
builder.Length -= 5;
}
else if (dQueryInfo.SelectInfo != null)
{
LambdaExpression lambda = null;
var dbQuery = dQueryInfo.SourceQuery;
if (dbQuery.DbExpressions != null && dbQuery.DbExpressions.Count > 1)
{
switch (dbQuery.DbExpressions[1].DbExpressionType)
{
case DbExpressionType.Join:
case DbExpressionType.GroupJoin:
case DbExpressionType.GroupRightJoin:
lambda = (LambdaExpression)dbQuery.DbExpressions[1].Expressions[1];
break;
case DbExpressionType.Select:
case DbExpressionType.SelectMany:
lambda = (LambdaExpression)dbQuery.DbExpressions[1].Expressions[0];
break;
}
}
if (lambda == null)
{
DbExpression dbExpression = dQueryInfo.SelectInfo.SelectExpression;
dbExpression = dQueryInfo.SelectInfo.WhereExpression;
if (dbExpression != null && dbExpression.Expressions != null)
{
lambda = (LambdaExpression)dbExpression.Expressions[0];
}
}
// 解析查询以确定是否需要嵌套
var parameter = Expression.Parameter(typeof(SQLiteRowId), lambda != null ? lambda.Parameters[0].Name : "x");
var expression = Expression.MakeMemberAccess(parameter, (_rowIdExpression.Body as MemberExpression).Member);
dQueryInfo.SelectInfo.SelectExpression = new DbExpression(DbExpressionType.Select, expression);
var cmd = (MappingCommand)this.ParseSelectCommand <T>(dQueryInfo.SelectInfo, 1, false, null);
if (token != null && token.Extendsions == null)
{
token.Extendsions = new Dictionary <string, object>();
if (!token.Extendsions.ContainsKey("SQLiteDelete"))
{
token.Extendsions.Add("SQLiteDelete", null);
}
}
if ((cmd.NavMembers != null && cmd.NavMembers.Count > 0) || dQueryInfo.SelectInfo.Joins.Count > 0)
{
cmd = (MappingCommand)this.ParseSelectCommand <T>(dQueryInfo.SelectInfo, 1, false, token);
builder.Append("WHERE ");
builder.AppendMember("RowID");
builder.Append(" IN(");
builder.AppendNewLine(cmd.CommandText);
builder.Append(')');
}
else
{
TableAliasCache aliases = this.PrepareAlias <T>(dQueryInfo.SelectInfo, token);
ExpressionVisitorBase visitor = null;
visitor = new JoinExpressionVisitor(this, aliases, dQueryInfo.SelectInfo.Joins);
visitor.Write(builder);
visitor = new WhereExpressionVisitor(this, null, dQueryInfo.SelectInfo.WhereExpression);
visitor.Write(builder);
}
}
builder.Append(';');
return(new Command(builder.ToString(), builder.Token != null ? builder.Token.Parameters : null, System.Data.CommandType.Text));
}
// 添加导航属性关联
protected override void AppendNavigation()
{
if (base.NavMembers == null || base.NavMembers.Count == 0)
{
return;
}
// 如果有一对多的导航属性，肯定会产生嵌套查询。那么内层查询别名肯定是t0，所以需要清掉
if (this.HasMany)
{
_aliases = new TableAliasCache(_aliases.Declared);
}
//开始产生LEFT JOIN 子句
ISqlBuilder builder = this.JoinFragment;
foreach (var kvp in base.NavMembers)
{
string key = kvp.Key;
MemberExpression m = kvp.Value;
TypeRuntimeInfo typeRuntime = TypeRuntimeInfoCache.GetRuntimeInfo(m.Expression.Type);
ForeignKeyAttribute attribute = typeRuntime.GetInvokerAttribute <ForeignKeyAttribute>(m.Member.Name);
string innerKey = string.Empty;
string outerKey = key;
string innerAlias = string.Empty;
if (!m.Expression.Acceptable())
{
innerKey = m.Expression.NodeType == ExpressionType.Parameter
? (m.Expression as ParameterExpression).Name
: (m.Expression as MemberExpression).Member.Name;
}
else
{
MemberExpression mLeft = null;
if (m.Expression.NodeType == ExpressionType.MemberAccess)
{
mLeft = m.Expression as MemberExpression;
}
else if (m.Expression.NodeType == ExpressionType.Call)
{
mLeft = (m.Expression as MethodCallExpression).Object as MemberExpression;
}
string name = TypeRuntimeInfoCache.GetRuntimeInfo(mLeft.Type).TableName;
innerAlias = _aliases.GetJoinTableAlias(name);
if (string.IsNullOrEmpty(innerAlias))
{
string keyLeft = mLeft.GetKeyWidthoutAnonymous();
if (base.NavMembers.ContainsKey(keyLeft))
{
innerKey = keyLeft;
}
innerAlias = _aliases.GetNavigationTableAlias(innerKey);
}
}
string alias1 = !string.IsNullOrEmpty(innerAlias) ? innerAlias : _aliases.GetTableAlias(innerKey);
string alias2 = _aliases.GetNavigationTableAlias(outerKey);
builder.AppendNewLine();
builder.Append("LEFT JOIN ");
Type type = m.Type;
if (type.IsGenericType)
{
type = type.GetGenericArguments()[0];
}
var typeRuntime2 = TypeRuntimeInfoCache.GetRuntimeInfo(type);
builder.AppendMember(typeRuntime2.TableName, !typeRuntime2.IsTemporary);
builder.Append(" ");
builder.Append(alias2);
bool withNoLock = !typeRuntime2.IsTemporary && _context.NoLock && !string.IsNullOrEmpty(_provider.WidthNoLock);
if (withNoLock)
{
builder.Append(' ');
builder.Append(_provider.WidthNoLock);
}
builder.Append(" ON ");
for (int i = 0; i < attribute.InnerKeys.Length; i++)
{
builder.Append(alias1);
builder.Append('.');
builder.AppendMember(attribute.InnerKeys[i]);
builder.Append(" = ");
builder.Append(alias2);
builder.Append('.');
builder.AppendMember(attribute.OuterKeys[i]);
if (i < attribute.InnerKeys.Length - 1)
{
builder.Append(" AND ");
}
}
}
}
