private CollectionSortInfo ConvertToColumnName(CollectionSortInfo _SortingInfo)
        {
            bool success = true;
            DbStatementResultSetInfo resultSetinfo = DbStatementResultSetInfoProvider.GetDbStatementInfo(StatementName);

            if (resultSetinfo == null)
            {
                success = false;
            }
            else
            {
                foreach (FieldSortInfo fsi in _SortingInfo.SortInfoList)
                {
                    string colName = resultSetinfo.GetMappedColumn(fsi.FieldName);
                    if (!string.IsNullOrEmpty(colName))
                    {
                        fsi.FieldName = colName;
                    }
                    else
                    {
                        success = false;
                        break;
                    }
                }
            }

            if (!success)
            {
                _SortingInfo.SortInfoList = null;
            }
            return(_SortingInfo);
        }
示例#2
0
        public static DbStatementResultSetInfo GetDbStatementInfo(string statementName)
        {
            DbStatementResultSetInfo val = null;

            if (_ResultSetInfoList != null && _ResultSetInfoList.Length > 0)
            {
                foreach (DbStatementResultSetInfo dbsi in _ResultSetInfoList)
                {
                    if (statementName.Equals(dbsi.StatementName, StringComparison.Ordinal))
                    {
                        val = dbsi;
                        break;
                    }
                }
            }

            return(val);
        }