private static string CriteriaOut(Filter whereFilter) { var sb = new StringBuilder(); if (whereFilter != null && whereFilter.rules != null) { foreach (var rule in whereFilter.rules) { sb.Append(string.Format("{0}:{1}:{2},", rule.field, rule.op, rule.data)); } } return(sb.ToString()); }
Filter ProjectNameRule (string projectName) { var whereFilter = new Filter { groupOp = "AND" }; var rules = new List <Rule> { new Rule { field = "ProjectName", data = projectName, op = "ET" } }; whereFilter.rules = rules.ToArray(); return(whereFilter); }
public void TestProjectGetByProjectName() { var sut = new PatService(); var gridSettings = new MvcJqGrid.GridSettings { IsSearch = true, PageSize = 99999999, PageIndex = 1, SortColumn = "ProjectId" }; var rule1 = new MvcJqGrid.Rule { field = "ProjectName", op = DataConstants.SqlOperationContains, data = "Steve" }; var ruleArray = new MvcJqGrid.Rule[1]; ruleArray[0] = rule1; var filter = new MvcJqGrid.Filter { rules = ruleArray }; gridSettings.Where = filter; var projectList = sut.GetProjects(gridSettings); Assert.IsTrue(projectList.Any()); }