예제 #1
0
        /// <inheritdoc />
        /// TODO Edit XML Comment Template for GetDataTableList
        public object GetDataTableList(LocalizedGroupDataItemDataTablesInput o)
        {
            string sQuery = $"EXEC [dbo].[sp_GetLocalizedGroupDataItemsDt] @sSearch=@sSearch, @nRowStart=@nRowStart, @nPageSize=@nPageSize, @sSortCol=@sSortCol, @sSortDir=@sSortDir, @sGroupKey=@sGroupKey, @sGroupFilter=@sGroupFilter";
            var    dt     = new DataTablesBase(o, _dbClient);

            dt.AddExtraParams("sSortCol", o?.columns?.ElementAtOrDefault(o?.order?.FirstOrDefault()?.column ?? 0)?.data);
            dt.AddExtraParams("sSortDir", o?.order?.FirstOrDefault()?.dir);
            dt.AddExtraParams("sGroupKey", o.GroupKey);
            dt.AddExtraParams("sGroupFilter", string.IsNullOrWhiteSpace(o.GroupFilter) ? null : o.GroupFilter);
            dt.SetDebug(false);
            return(dt.FetchQuery(_connString, sQuery));
        }
        /// <inheritdoc />
        /// TODO Edit XML Comment Template for GetDataTableList
        public object GetDataTableList(LocalizedContentTextDataTablesInput o)
        {
            string sQuery = $"EXEC [dbo].[sp_GetLocalizedContentTextDt] @sSearch=@sSearch, @nRowStart=@nRowStart, @nPageSize=@nPageSize, @sSortCol=@sSortCol, @sSortDir=@sSortDir, @sGroupKey = @sGroupKey, @sFieldKey = @sFieldKey, @sLanguage = @sLanguage, @sParentKey=@sParentKey";
            var    dt     = new DataTablesBase(o, _dbClient);

            if (!dt.UseOrderedPaging)
            {
                sQuery = $"EXEC [dbo].[sp_GetLocalizedContentTextDt] @sSearch=@sSearch, @nRowStart=0, @nPageSize=1000, @sSortCol=@sSortCol, @sSortDir=@sSortDir, @sGroupKey = @sGroupKey, @sFieldKey = @sFieldKey, @sLanguage = @sLanguage, @sParentKey=@sParentKey";
            }

            dt.AddExtraParams("sSortCol", o?.columns?.ElementAtOrDefault(o?.order?.FirstOrDefault()?.column ?? 0)?.data);
            dt.AddExtraParams("sSortDir", o?.order?.FirstOrDefault()?.dir);

            dt.AddExtraParams("sFieldKey", o?.FieldKey);
            dt.AddExtraParams("sParentKey", o?.ParentKey);
            dt.AddExtraParams("sGroupKey", o?.GroupKey);
            dt.AddExtraParams("sLanguage", o?.Language);

            dt.SetDebug(false);
            return(dt.FetchQuery(_connString, sQuery));
        }