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()); }