protected override IListSqlContext GetListSql(string selectFields, string tableName, IFieldInfo[] keyFields, string whereClause, string orderBy, int startNum, int endNum) { if (keyFields == null || keyFields.Length == 0) { IListSqlContext context = base.GetListSql(selectFields, tableName, keyFields, whereClause, orderBy, startNum, endNum); return(new YukonListSqlContext(context)); } string sql; if (endNum == 0) { sql = string.Format(ObjectUtil.SysCulture, "SELECT {0} FROM {1} {2} {3}", selectFields, tableName, whereClause, orderBy); } else { ProcessOrderBy(keyFields, ref orderBy); sql = string.Format(ObjectUtil.SysCulture, "SELECT * FROM (SELECT {0}, ROW_NUMBER() OVER ({3}) ROWNUMBER_ FROM {1} {2})" + " _TOOLKIT WHERE ROWNUMBER_ > {4} AND ROWNUMBER_ <= {5}", selectFields, tableName, whereClause, orderBy, startNum, endNum); } return(new YukonListSqlContext(sql)); }
void ISqlProvider.SetListData(IListSqlContext context, ISimpleAdapter adapter, DataSet dataSet, int startRecord, int maxRecords, string srcTable) { TkDebug.AssertArgumentNull(adapter, "adapter", this); TkDebug.AssertArgumentNull(dataSet, "dataSet", this); TkDebug.AssertArgumentNullOrEmpty(srcTable, "srcTable", this); SetListData(context, adapter, dataSet, startRecord, maxRecords, srcTable); }
public void SetListData(IListSqlContext context, ISimpleAdapter adapter, DataSet dataSet, int startRecord, int maxRecords, string srcTable) { TkDebug.AssertArgumentNull(adapter, "adapter", this); TkDebug.AssertArgumentNull(dataSet, "dataSet", this); TkDebug.AssertArgumentNullOrEmpty(srcTable, "srcTable", this); DbUtil.FillDataSet(adapter, dataSet, srcTable); }
protected virtual void SetListData(IListSqlContext context, ISimpleAdapter adapter, DataSet dataSet, int startRecord, int maxRecords, string srcTable) { TkDebug.AssertArgument(startRecord >= 0, "startRecord", string.Format( ObjectUtil.SysCulture, "参数startRecord不能为负数,现在的值为{0}", startRecord), this); TkDebug.AssertArgument(maxRecords >= 0, "number", string.Format(ObjectUtil.SysCulture, "参数maxRecords不能为负数,现在的值为{0}", maxRecords), this); DbUtil.FillDataSet(adapter, dataSet, srcTable, startRecord, maxRecords); }
void ISqlProvider.SetListData(IListSqlContext context, ISimpleAdapter adapter, DataSet dataSet, int startRecord, int maxRecords, string srcTable) { TkDebug.AssertArgumentNull(adapter, "adapter", this); TkDebug.AssertArgumentNull(dataSet, "dataSet", this); TkDebug.AssertArgumentNullOrEmpty(srcTable, "srcTable", this); TkDebug.AssertArgument(startRecord >= 0, "startRecord", string.Format(ObjectUtil.SysCulture, "参数startRecord不能为负数,现在的值为{0}", startRecord), this); TkDebug.AssertArgument(maxRecords >= 0, "number", string.Format(ObjectUtil.SysCulture, "参数maxRecords不能为负数,现在的值为{0}", maxRecords), this); DbUtil.FillDataSet(adapter, dataSet, srcTable, startRecord, maxRecords); }
protected override void SetListData(IListSqlContext context, ISimpleAdapter adapter, DataSet dataSet, int startRecord, int maxRecords, string srcTable) { TkDebug.AssertArgumentNull(context, "context", this); YukonListSqlContext sqlContext = context.Convert <YukonListSqlContext>(); if (sqlContext.UseTopSql) { base.SetListData(context, adapter, dataSet, startRecord, maxRecords, srcTable); } else { DbUtil.FillDataSet(adapter, dataSet, srcTable); } }
public void SetListData(IListSqlContext context, ISimpleAdapter adapter, DataSet dataSet, int startRecord, int maxRecords, string srcTable) { InternalSqlProvider.SetListData(context, adapter, dataSet, startRecord, maxRecords, srcTable); }
public YukonListSqlContext(IListSqlContext sqlContext) { fSqlContext = sqlContext; UseTopSql = true; }