chenghuang-mdsol

       In ConfigurationExcelReport.cs
       
       private static IStateAccessor _accessor = DependencyResolver.Resolve<IStateService>().ForClass<ConfigurationExcelReport>();
        
       private void DefineNamedRangeForTsdvLoader(int studyId, int projectId)
        {
            var study = Study.Fetch(studyId, InteractionCtrl.Interaction);
            var roleId = InteractionCtrl.Interaction.RoleID;
            var locale = InteractionCtrl.Interaction.DefaultLocale;
            var forms = Helper.GetForms(projectId, 0, locale).Consume<ExpandoObject>(o =>

chenghuang-mdsol

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.VisualStudio.TestTools.UnitTesting;
using Ploeh.AutoFixture;
using Ploeh.AutoFixture.AutoRhinoMock;
using Medidata.Cloud.ExcelLoader.CellTypeConverters;
namespace Medidata.Cloud.ExcelLoader.Tests.CellTypeConverters
{

chenghuang-mdsol

--ctrl-9
sp_executesql N'SELECT name object_name from sys.objects where type in (''U'',''V'',''P'',''FN'') and name like ''%''+ @keyword + ''%'' order by type, name', N'@keyword nvarchar(255)',

--ctrl-0
sp_executesql N'select c.name as column_name, t.name as [type], o.name as object_name from sys.columns c inner join sys.objects o on c.object_id = o.object_id inner join sys.types t on c.system_type_id = t.system_type_id where c.name like ''%''+@keyword+''%'' order by o.name, o.object_id, o.type', N'@keyword nvarchar(255)',