public string RelationalJsonSelectQuery(string fk, string pk, string conditionConstValue)
{
var readSelectTemplate = System.IO.File.ReadAllText("sqlTemplates\\relationJsonTemplate.txt");
var result =
readSelectTemplate.
Replace("#RELATIONCONST#", (conditionConstValue + "_" + SqlConstString)).
Replace("#TABLE#", TABLE_NAME).
Replace("#RELATIONCONSTANDKEY#", conditionConstValue).
Replace("#SCHEMA#", TABLE_SCHEMA).
Replace("#FK#", fk).
Replace("#PK#", pk).
Replace("#SELECTNAMES#", TableSqlCodeInfoes.SelectNameSingleInfo(Properties, (conditionConstValue + "_" + SqlConstString)));
return(result);
}
public string ManyRelationalCountSelectQuery(string conditionConstValue, string fkCol, string pkCol, IEnumerable <EntityCode> EntityCodeList, IEnumerable <SqlRelationNames> AllKeys)
{
var readSelectTemplate = System.IO.File.ReadAllText("sqlTemplates\\selectCountManyRelation.txt");
var result =
readSelectTemplate.
Replace("#RELATIONCONST#", (conditionConstValue + "_" + SqlConstString)).
Replace("#MANYCONST#", (conditionConstValue + "_" + SqlConstString)).
Replace("#RELATIONSJSON#", "").
Replace("#TABLE#", TABLE_NAME).
Replace("#NAME#", TABLE_NAME).
Replace("#RELATIONCONSTANDKEY#", conditionConstValue).
Replace("#SCHEMA#", TABLE_SCHEMA).
Replace("#SELECTNAMES#", TableSqlCodeInfoes.SelectNameSingleInfo(Properties, (conditionConstValue + "_" + SqlConstString))).
Replace("#PKEYCOLUMN#", pkCol).
Replace("#FKEYCOLUMN#", fkCol).
Replace("#SELECTCONST#", conditionConstValue);
return(result);
}