public ActionResult GetMessageDataGridList(int page = 1, int rows = 10, string KeyWord = "", string KeyWordType = "TitleOrContent")
{
//为搜索拼接条件字符串
string sql = "";
if (KeyWord != "")
{
if (KeyWordType == "TitleOrContent")
{
sql = "AND (Title LIKE N'%" + KeyWord + "%' OR Content LIKE N'%" + KeyWord + "%')";
}
else if (KeyWordType == "Username")
{
sql = "AND Username LIKE N'%" + KeyWord + "%'";
}
}
//得到数据总条数
int total = MessageService.GetMessageCountBySql(sql);
//分页查询
SelectPageInfo info = new SelectPageInfo()
{
Min = rows * (page - 1),
Count = rows,
WhereSql = sql
};
IList <Message> msgs = MessageService.GetMessagesPageBySql(info);
return(Json(new { total = total, rows = msgs, page = page }));
}
public IList <Message> GetMessagesPageBySql(SelectPageInfo info, ISqlMapper sqlMapper)
{
IList <Message> msgs = new List <Message>();
try {
msgs = sqlMapper.QueryForList <Message>("Message.GetMessagesPageBySql", info);
}
catch (Exception) {
throw;
}
return(msgs);
}
////得到所有用户
//public IList<MyUser> GetAllUser() {
// IList<MyUser> users = new List<MyUser>();
// try {
// //条件为空字符串，得到所有
// users = MyUserDao.GetUsersBySql("", DataMapper.Instance);
// }
// catch (Exception) {
// throw;
// }
// return users;
//}
//public IList<MyUser> GetUsersBySql(string whereSql) {
// IList<MyUser> users = new List<MyUser>();
// try {
// //
// users = MyUserDao.GetUsersBySql(whereSql, DataMapper.Instance);
// }
// catch (Exception) {
// throw;
// }
// return users;
//}
public IList <MyUser> GetUsersPageBySql(SelectPageInfo info)
{
IList <MyUser> users = new List <MyUser>();
try {
users = MyUserDao.GetUsersPageBySql(info, DataMapper.Instance);
}
catch (Exception) {
throw;
}
return(users);
}
//public IList<MyUser> GetUsersBySql(string whereSql, ISqlMapper sqlMapper) {
// IList<MyUser> users = new List<MyUser>();
// try {
// users = sqlMapper.QueryForList<MyUser>("MyUser.GetUsersBySql", whereSql);
// }
// catch (Exception) {
// throw;
// }
// return users;
//}
public IList <MyUser> GetUsersPageBySql(SelectPageInfo info, ISqlMapper sqlMapper)
{
IList <MyUser> users = new List <MyUser>();
try {
users = sqlMapper.QueryForList <MyUser>("MyUser.GetUsersPageBySql", info);
}
catch (Exception) {
throw;
}
return(users);
}
public IList <Message> GetMessagesPageBySql(SelectPageInfo info)
{
IList <Message> msgs = new List <Message>();
try {
msgs = MessageDao.GetMessagesPageBySql(info, DataMapper.Instance);
}
catch (Exception) {
throw;
}
return(msgs);
}
//得到用户的分页数据
public ActionResult GetUserDataGridList(int page = 1, int rows = 10, string KeyWord = "")
{
//为搜索拼接条件字符串
string sql = "";
if (KeyWord != "")
{
sql = "AND Username LIKE N'%" + KeyWord + "%'";
}
//得到数据总条数
int total = MyUserService.GetUserCountBySql(sql);
//分页查询
SelectPageInfo info = new SelectPageInfo()
{
Min = rows * (page - 1),
Count = rows,
WhereSql = sql
};
IList <MyUser> users = MyUserService.GetUsersPageBySql(info);
return(Json(new { total = total, rows = users, page = page }));
}
