如题以下语句
TModulesService ms = new TModulesService();
TList<TModules> l = ms.Find("moduleid > 3");
会报错
是否find无法使用大于号进行查询,如果是那该如何进行查询?
TModulesService ms = new TModulesService();
TList<TModules> l = ms.Find("moduleid > 3");
会报错
是否find无法使用大于号进行查询,如果是那该如何进行查询?
{
public UsersFacade()
: base() { }
public Users ValidateUser(string username, string password)
{
SqlFilterBuilder<UsersColumn> filter = new SqlFilterBuilder<UsersColumn>();
filter.Junction = SqlUtil.AND;
filter.AppendEquals(UsersColumn.Name, username);
filter.AppendEquals(UsersColumn.Password, password);
int count = 0;
TList<Users> users = DataRepository.UsersProvider.GetPaged(filter.ToString(), null, 0, 20, out count);
if (users.Count > 0)
return users[0];
else
return null;
}
public Users ValidateUserAlter(string username, string password)
{
TList<Users> users = Find(string.Format("Name = '{0}' AND Password = '{1}'", username, password));
if (users != null && users.Count > 0)
return users[0];
else
return null;
}
public Users ValidateUserThird(string username, string password)
{
GB.Data.ParameterizedSqlFilterBuilder<Users> filter = new ParameterizedSqlFilterBuilder<Users>();
filter.AppendEquals("Name", "Darkangel");
filter.AppendEquals("Password", "5364241");
TList<Users> users = GB.Data.DataRepository.UsersProvider.Find(filter.GetParameters());
if (users != null && users.Count > 0)
return users[0];
else
return null;
}
}
ParameterizedSqlFilterBuilder<TModulesColumn> Filters = new ParameterizedSqlFilterBuilder<TModulesColumn>();
Filters.AppendGreaterThan(TModulesColumn.moduleid , "3");