//0711TODO KO 需增加ElementIds的关联表加载处理
public static void FetchDepthNodeElements(this TDetail entity, SQLiteConnection connection)
{
var command = connection.CreateCommand();
var nodeElement = new TDepthNodeElement();
List <KeyOperatorValue> wheres = new List <KeyOperatorValue>();
wheres.Add(new KeyOperatorValue(nameof(entity.Segregation), SQLiteOperater.Eq, SQLiteHelper.ToSQLiteString(UniqueIdHelper.UniqueIdStr)));
command.CommandText = SQLiteHelper.GetSQLiteQuery_Select(null, $"{nodeElement.TableName}", wheres);
//var command = connection.CreateCommand();
//var node = new TDepthNode();
//var nodeElement = new TDepthNodeElement();
//string tableSuffix = "n.";
//List<KeyOperatorValue> wheres = new List<KeyOperatorValue>();
//wheres.Add(new KeyOperatorValue(tableSuffix + nameof(entity.Segregation), SQLiteOperater.Eq, SQLiteHelper.ToSQLiteString(UniqueIdHelper.UniqueIdStr)));
//wheres.Add(new KeyOperatorValue(tableSuffix + nameof(entity.IssueDateTime), SQLiteOperater.Eq, SQLiteHelper.ToSQLiteString(entity.IssueDateTime)));
//wheres.Add(new KeyOperatorValue(tableSuffix + nameof(entity.IssueType), SQLiteOperater.Eq, SQLiteHelper.ToSQLiteString<EIssueType>(entity.IssueType)));
//command.CommandText = SQLiteHelper.GetSQLiteQuery_SelectWithJoin("ne.*", $"{node.TableName} n left join {nodeElement.TableName} ne on n.{nameof(node.Segregation)}=ne.{nameof(nodeElement.Segregation)} and n.{nameof(node.NodeCode)}=ne.{nameof(nodeElement.NodeCode)} and n.{nameof(node.Depth)}=ne.{nameof(nodeElement.Depth)}", wheres);
var reader = command.ExecuteReader();
while (reader.Read())
{
nodeElement = new TDepthNodeElement(reader);
var node = entity.DepthNodes.FirstOrDefault(c => c.NodeCode == nodeElement.NodeCode && c.Depth == nodeElement.Depth);
if (node != null)
{
node.ElementIds = nodeElement.ElementIds;
}
}
}
public static bool DbInsertOrReplace(this TDepthNodeElement entity, SQLiteConnection session)
{
var command = session.CreateCommand();
Dictionary <string, string> NameValues = new Dictionary <string, string>();
NameValues.Add(nameof(entity.Segregation), SQLiteHelper.ToSQLiteString(UniqueIdHelper.UniqueIdStr));
NameValues.Add(nameof(entity.NodeCode), SQLiteHelper.ToSQLiteString(entity.NodeCode));
NameValues.Add(nameof(entity.Depth), SQLiteHelper.ToSQLiteString(entity.Depth));
NameValues.Add(nameof(entity.ElementIds), SQLiteHelper.ToSQLiteString(entity.ElementIds));
command.CommandText = SQLiteHelper.GetSQLiteQuery_InsertOrReplace(entity.TableName, NameValues);
return(command.ExecuteNonQuery() == 1);
}
public static void FetchDepthNodes(this TDetail entity, SQLiteConnection connection)
{
var command = connection.CreateCommand();
var node = new TDepthNode();
var nodeElement = new TDepthNodeElement();
string tableSuffix = "n.";
List <KeyOperatorValue> wheres = new List <KeyOperatorValue>();
wheres.Add(new KeyOperatorValue(tableSuffix + nameof(entity.Segregation), SQLiteOperater.Eq, SQLiteHelper.ToSQLiteString(UniqueIdHelper.UniqueIdStr)));
wheres.Add(new KeyOperatorValue(tableSuffix + nameof(entity.IssueDateTime), SQLiteOperater.Eq, SQLiteHelper.ToSQLiteString(entity.IssueDateTime)));
wheres.Add(new KeyOperatorValue(tableSuffix + nameof(entity.IssueType), SQLiteOperater.Eq, SQLiteHelper.ToSQLiteString <EIssueType>(entity.IssueType)));
//0711TODO KO 需增加ElementIds的关联表加载处理
command.CommandText = SQLiteHelper.GetSQLiteQuery_SelectWithJoin($"n.*,ne.{nameof(nodeElement.ElementIds)}", $"{node.TableName} n left join {nodeElement.TableName} ne on n.{nameof(node.Segregation)}=ne.{nameof(nodeElement.Segregation)} and n.{nameof(node.NodeCode)}=ne.{nameof(nodeElement.NodeCode)} and n.{nameof(node.Depth)}=ne.{nameof(nodeElement.Depth)}", wheres);
var reader = command.ExecuteReader();
while (reader.Read())
{
entity.DepthNodes.Add(new TDepthNode(reader));
}
}
