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());
}
