public ExtServiceBlog queryPageBlog(Dictionary <String, object> condition)
{
int currentPage = 0;
int start = 0, limit = 10;
if (condition.ContainsKey("limit"))
{
limit = Convert.ToInt16(condition["limit"]);
}
if (condition.ContainsKey("start"))
{
start = Convert.ToInt16(condition["start"]);
}
UtilDictionary.Removes(condition, "start", "limit");
int PageCount = limit;
currentPage = start / PageCount;
this.Stores = new List <Object>();
//this.Stores.Clear();
int User_ID = 0;
string Blog_Name = "";
if (condition.ContainsKey("User_ID"))
{
if (condition["User_ID"].ToString().Trim().Length > 0)
{
User_ID = Convert.ToInt16(condition["User_ID"]);
}
}
if (condition.ContainsKey("Blog_Name"))
{
Blog_Name = Convert.ToString(condition["Blog_Name"]);
}
int rowCount = 0;//总行记录数
rowCount = db.Blog.Where(e => e.Blog_Name.Contains(Blog_Name)).Count();
var blogs = db.Blog.Where(e => e.Blog_Name.Contains(Blog_Name)).
OrderByDescending(p => p.ID).Skip(start).Take(PageCount);
List <Blog> listBlogs = blogs.ToList <Blog>();
int i = 1;
foreach (Blog blog in listBlogs)
{
blog.Username = blog.User.Username;
blog.Blog_ContentShow = Regex.Replace(blog.Blog_Content, "<\\s*img\\s+[^>]*?src\\s*=\\s*(\'|\")(.*?)\\1[^>]*?\\/?\\s*>", "<a href='${2}' target='_blank'>${0}</a>");
blog.Blog_ContentShow = blog.Blog_ContentShow.Replace("\\\"", "");
this.Stores.Add((Blog)ClearInclude(blog));
i++;
}
this.TotalCount = rowCount;
this.Success = true;
return(this);
}
public ExtServiceComment queryPageComment(Dictionary <String, object> condition)
{
int currentPage = 0;
int start = 0, limit = 10;
if (condition.ContainsKey("limit"))
{
limit = Convert.ToInt16(condition["limit"]);
}
if (condition.ContainsKey("start"))
{
start = Convert.ToInt16(condition["start"]);
}
UtilDictionary.Removes(condition, "start", "limit");
int PageCount = limit;
currentPage = start / PageCount;
this.Stores = new List <Object>();
//this.Stores.Clear();
int Blog_ID = 0;
if (condition.ContainsKey("Blog_ID"))
{
Blog_ID = Convert.ToInt16(condition["Blog_ID"]);
}
int rowCount = 0;//总行记录数
rowCount = db.Comment.Where(e => e.Blog_ID == Blog_ID).Count();
var comments = db.Comment.Where(e => e.Blog_ID == Blog_ID).
OrderByDescending(p => p.ID).Skip(start).Take(PageCount);
List <Comment> listComments = comments.ToList <Comment>();
foreach (Comment comment in listComments)
{
comment.Username = comment.User.Username;
comment.Blog_Name = comment.Blog.Blog_Name;
comment.Content = comment.Comment1;
this.Stores.Add((Comment)ClearInclude(comment));
}
this.TotalCount = rowCount;
this.Success = true;
return(this);
}
public ExtServiceAdmin queryPageAdmin(Dictionary <String, object> condition)
{
int StartPoint = 1, EndPoint = 15;
if (condition.ContainsKey("start"))
{
StartPoint = Convert.ToInt16(condition["start"]) + 1;
}
if (condition.ContainsKey("limit"))
{
EndPoint = Convert.ToInt16(condition["limit"]);
EndPoint = StartPoint + EndPoint - 1;
}
UtilDictionary.Removes(condition, "start", "limit");
if (adminService == null)
{
adminService = new ServiceAdmin();
}
string WhereClause = FiltertoCondition(condition);
int RowCount = adminService.Count(WhereClause);//总行记录数
if (RowCount > 0)
{
List <Admin> listAdmins = adminService.QueryPage(StartPoint, EndPoint, WhereClause).ToList <Admin>();
if (EndPoint > RowCount)
{
EndPoint = RowCount;
}
this.Stores = new List <Object>();
foreach (Admin admin in listAdmins)
{
admin.RoletypeShow = EnumRoletype.RoletypeShow(Convert.ToChar(admin.Roletype));
admin.SeescopeShow = EnumSeescope.SeescopeShow(Convert.ToChar(admin.Seescope));
admin.Department_Name = admin.Department.Department_Name;
this.Stores.Add((Admin)ClearInclude(admin));
}
}
this.TotalCount = RowCount;
this.Success = true;
return(this);
}
