protected override string GetSelectSql()
{
StringBuilder sql = new StringBuilder();
if (TopNumber > 0)
{
sql.AppendLine(string.Format("SELECT TOP {0} ", TopNumber));
}
else
{
sql.AppendLine("SELECT ");
}
sql.AppendLine(string.Format("{0}", base.GetSelectColumnSql()));
sql.AppendLine(string.Format("FROM {0} ", base.EntityInfo.TableName));
if (ParamValues.Any())
{
if (base.SqlType == Infrastructure.SqlType.Select && base.OrderByColums.Any())
{
return(string.Format("{0} {1} {2}", sql, base.WhereSql, base.OrderBySql));
}
return(string.Format("{0} {1}", sql, base.WhereSql));
}
return(sql.ToString());
}
protected override string GetCountSql()
{
var result = string.Format("SELECT COUNT(1) FROM {0}", base.EntityInfo.TableName);
if (!ParamValues.Any())
{
return(result);
}
return(string.Format("{0} {1}", result, base.WhereSql));
}
protected override string GetDeleteSql()
{
StringBuilder sql = new StringBuilder();
sql.AppendLine(string.Format("UPDATE {0} SET ", base.EntityInfo.TableName));
sql.AppendLine(string.Format(" Disabled=1,{0} ", base.GetUpdateColumnsSql()));
sql.AppendLine(string.Format(" {0} AND Disabled=0 ", WhereSql));
if (ParamValues.Any())
{
return(sql.ToString());
}
var p = base.er.GetPrimary(base.EntityInfo);
sql.AppendFormat(" AND {0}={1} ", p.Column, this.ParamPrefix + p.Field);
return(sql.ToString());
}
