BN089-BS开发框架MVC4版/source20131023/Zephyr.Net/Zephyr.Data/Providers/Common/Builders/DeleteBuilderSqlGenerator.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

namespace Zephyr.Data.Providers.Common.Builders
{
	internal class DeleteBuilderSqlGenerator
	{
		public string GenerateSql(IDbProvider provider, string parameterPrefix, BuilderData data)
		{
            //mod by liuhuisheng start
            //var whereSql = "";
            var whereSql = data.WhereSql;
            //mod by liuhuisheng end
			foreach (var column in data.Columns)
			{
				if (whereSql.Length > 0)
					whereSql += " and ";

				whereSql += string.Format("{0} = {1}{2}",
												provider.EscapeColumnName(column.ColumnName),
												parameterPrefix,
												column.ParameterName);
			}

			var sql = string.Format("delete from {0} where {1}", data.ObjectName, whereSql);
			return sql;
		}
	}
}