private string GetCondition(bool flag)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append(GetJoin());
if (WhereClip.Count > 0)
{
string sqlWhereClip = "";
List <DbParameter> parameters = new List <DbParameter>();
WhereClip.GetPartmerStrings(excuteImport, ref sqlWhereClip, ref parameters);
lstDbParmeters.AddRange(parameters);
if (flag)
{
//是where条件语句的头部
stringBuilder.Append(" WHERE " + sqlWhereClip);
}
else
{
stringBuilder.Append(" AND " + sqlWhereClip);
}
}
if (GroupByClip.Count > 0)
{
stringBuilder.Append(" GROUP BY " + GroupByClip.ToString());
}
if (OrderByClip.Count > 0)
{
stringBuilder.Append(" ORDER BY " + OrderByClip.ToString());
}
return(stringBuilder.ToString());
}
public void GetCondition(ref StringBuilder strBuilder)
{
strBuilder.Append(GetJoin());
if (WhereClip.Count > 0)
{
string sqlWhereClip = "";
List <DbParameter> parameters = new List <DbParameter>();
WhereClip.GetPartmerStrings(excuteImport, ref sqlWhereClip, ref parameters);
lstDbParmeters.AddRange(parameters);
strBuilder.Append(" WHERE " + sqlWhereClip);
}
if (GroupByClip.Count > 0)
{
strBuilder.Append(" GROUP BY " + GroupByClip.ToString());
}
if (OrderByClip.Count > 0)
{
strBuilder.Append(" ORDER BY " + OrderByClip.ToString());
}
}