public string SelectCountTable(SqlRelationModel model) { CountTemplate template = new CountTemplate(); StringBuilder sql = new StringBuilder(); sql.Append(template.SelectCount(model.EntityModel)); sql.Append(JoinRule(model, model.Tables)); return(sql.ToString()); }
public string SelectCountSource(SqlRelationModel model) { CountTemplate template = new CountTemplate(); StringBuilder sql = new StringBuilder(); model.UseDefaultFilter(); sql.Append(template.SelectCount(model.EntityModel)); sql.Append(JoinRule(model, model.Sources)); model.ClearFilter(); return(sql.ToString()); }
/// <summary> /// 根据model信息生成 SELECT COUNT(*) FROM [TableName] WHERE + condition /// </summary> /// <param name="model"></param> /// <param name="condition"></param> /// <returns></returns> public static string CustomerCount(SqlModel model, string condition) { return($"{Count.SelectCount(model)} WHERE {condition}"); }