//
// GET: /Xueya/
public ActionResult Index(int? p)
{
Pager pager = new Pager();
pager.table = "CMSXueya";
pager.strwhere = "1=1";
pager.PageSize = 30;
pager.PageNo = p ?? 1;
pager.FieldKey = "XueyaId";
pager.FiledOrder = "XueyaId Desc";
pager = CMSService.SelectAll("Xueya", pager);
List<XueyaDto> list = new List<XueyaDto>();
foreach (DataRow dr in pager.EntityDataTable.Rows)
{
XueyaDto dto = XueyaMapping.getDTO(dr);
list.Add(dto);
}
pager.Entity = list.AsQueryable();
ViewBag.PageNo = p ?? 1;
ViewBag.PageCount = pager.PageCount;
ViewBag.RecordCount = pager.Amount;
ViewBag.Message = pager.Amount;
// ViewBag.CustomerId = id;
//ViewBag.CustomerName = MyService.CustomerIdToName("CustomerId=" + id);
return View(pager.Entity);
}
public ActionResult Daizhen(int? p)
{
Pager pager = new Pager();
pager.table = "CMSCustomer";
pager.strwhere = "1=1";
pager.PageSize = 10;
pager.PageNo = p ?? 1;
pager.FieldKey = "CustomerId";
pager.FiledOrder = "CustomerId Desc";
pager.strwhere = pager.strwhere + " and CustomerTizhi='0'";
pager = CMSService.SelectAll("Customer", pager);
List<CustomerDto> list = new List<CustomerDto>();
foreach (DataRow dr in pager.EntityDataTable.Rows)
{
CustomerDto dto = CustomerMapping.getDTO(dr);
list.Add(dto);
}
pager.Entity = list.AsQueryable();
ViewBag.PageNo = p ?? 1;
ViewBag.PageCount = pager.PageCount;
ViewBag.RecordCount = pager.Amount;
ViewBag.Message = pager.Amount;
return View(pager.Entity);
}
/// <summary>
/// 获取论坛板块列表 CategoryModel
/// </summary>
/// <param name="cid"></param>
/// <returns></returns>
public IQueryable<BbsBoardModel> GetBbsBoards(int cid)
{
IQueryable<CategoryModel> list = GetSubCategoryList(cid);
List<BbsBoardModel> boardlist = new List<BbsBoardModel>();
foreach (CategoryModel c in list)
{
boardlist.Add(GetBbsBoard(c));
}
return boardlist.AsQueryable();
}
public static Pager GetEditorPage(Pager pager, string strwhere, string table)
{
SqlParameter[] arParms = new SqlParameter[9];
//@tbname --要分页显示的表名
arParms[0] = new SqlParameter("@tbname", SqlDbType.NVarChar, 30);
arParms[0].Value = table;
// @FieldKey --用于定位记录的主键(惟一键)字段,可以是逗号分隔的多个字段
arParms[1] = new SqlParameter("@FieldKey", SqlDbType.NVarChar, 40);
arParms[1].Value = "EditorId";
//@PageCurrent --要显示的页码
arParms[2] = new SqlParameter("@PageCurrent", SqlDbType.Int);
arParms[2].Value = pager.PageNo + 1;
// @PageSize --每页的大小(记录数)
arParms[3] = new SqlParameter("@PageSize", SqlDbType.Int);
arParms[3].Value = pager.PageSize;
//@FieldShow --以逗号分隔的要显示的字段列表,如果不指定,则显示所有字段
arParms[4] = new SqlParameter("@FieldShow", SqlDbType.NVarChar, 500);
arParms[4].Value = "*";
//@FieldOrder --以逗号分隔的排序字段列表,可以指定在字段后面指定DESC/ASC用于指定排序顺序
arParms[5] = new SqlParameter("@FieldOrder", SqlDbType.NVarChar, 500);
arParms[5].Value = "EditorId desc";
//@Where --查询条件
arParms[6] = new SqlParameter("@Where", SqlDbType.VarChar, 8000);
arParms[6].Value = strwhere;
//@PageCount --总页数
arParms[7] = new SqlParameter("@PageCount", SqlDbType.Int);
arParms[7].Direction = ParameterDirection.Output;
//@RecordCount --总记录数
arParms[8] = new SqlParameter("@RecordCount", SqlDbType.Int);
arParms[8].Direction = ParameterDirection.Output;
SqlConnection myconn = new SqlConnection(CommonDal.ConnectionString);
try
{
EditorDto editorDto = null;
List<EditorDto> list = new List<EditorDto>();
DataTable dt = null;
DataSet ds = SqlHelper.ExecuteDataset(myconn, CommandType.StoredProcedure, "sp_AspNetPageView", arParms);
dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
editorDto = EditorDal.getDataRowToEditorDto(dr);
list.Add(editorDto);
}
var totalItems = (int)arParms[8].Value;
pager.Amount = totalItems;
pager.Entity = list.AsQueryable();
pager.PageCount = (int)arParms[7].Value;
return pager;
}
catch (SqlException ex)
{
throw ex;
}
finally
{
myconn.Close();
myconn.Dispose();
}
}
// 显示用户列表页
public ActionResult Index(int? p, int? roleId)
{
int RoleId = roleId ?? 0;
Pager pager = new Pager();
pager.table = "CMSUser";
pager.strwhere = "1=1";
pager.PageSize = 10;
pager.PageNo = p ?? 1;
pager.FieldKey = "UserId";
pager.FiledOrder = "UserId Desc";
if (RoleId > 0)
{
pager.strwhere = pager.strwhere + " and charindex('" + RoleId + "',UserRoles)>0";
}
pager = CMSService.SelectAll("User", pager);
List<UserDto> list = new List<UserDto>();
foreach (DataRow dr in pager.EntityDataTable.Rows)
{
UserDto dto = UserMapping.getDTO(dr);
dto.UserRoles = MyService.RolesIdToRolesName(dto.UserRoles);
list.Add(dto);
}
pager.Entity = list.AsQueryable();
ViewBag.PageNo = p ?? 1;
ViewBag.PageCount = pager.PageCount;
ViewBag.RecordCount = pager.Amount;
ViewBag.Message = pager.Amount;
ViewData["Roles"] = MyService.GetRolesList("1=1");
return View(pager.Entity);
}
// Category列表
public ActionResult Index(int? p, int id, string CategoryParentName)
{
Pager pager = new Pager();
pager.table = "CMSCategory";
pager.strwhere = "CategoryParentId="+id;
pager.PageSize = 10;
pager.PageNo = p ?? 1;
pager.FieldKey = "CategoryId";
pager.FiledOrder = "CategoryId Desc";
pager = CMSService.SelectAll("Category", pager);
List<CategoryDto> list = new List<CategoryDto>();
foreach (DataRow dr in pager.EntityDataTable.Rows)
{
CategoryDto dto = CategoryMapping.getDTO(dr);
list.Add(dto);
}
pager.Entity = list.AsQueryable();
ViewBag.PageNo = p ?? 1;
ViewBag.PageCount = pager.PageCount;
ViewBag.RecordCount = pager.Amount;
ViewBag.Message = pager.Amount;
ViewBag.CategoryParentName = CategoryParentName;
ViewBag.CategoryParentId = id;
return View(pager.Entity);
}
//
// GET: /Role/
public ActionResult Index(int? p)
{
Pager pager = new Pager();
pager.table = "CMSRole";
pager.strwhere = "1=1";
pager.PageSize = 10;
pager.PageNo = p ?? 1;
pager.FieldKey = "RoleId";
pager.FiledOrder = "RoleId Desc";
pager = CMSService.SelectAll("Role", pager);
List<RoleDto> list = new List<RoleDto>();
foreach (DataRow dr in pager.EntityDataTable.Rows)
{
RoleDto dto = RoleMapping.getDTO(dr);
list.Add(dto);
}
pager.Entity = list.AsQueryable();
ViewBag.PageNo = p ?? 1;
ViewBag.PageCount = pager.PageCount;
ViewBag.RecordCount = pager.Amount;
ViewBag.Message = pager.Amount;
return View(pager.Entity);
}
/// <summary>
/// 获取指定分类下所有相册信息
/// </summary>
public IQueryable<AlbumModel> GetAlbums(int cid,int count=0)
{
IQueryable<blog_varticle> varticles;
if(cid==0)
varticles = GetArticles(4, 0, count);
else
varticles = GetArticles(4, GetCategoryIds(cid), count);
varticles = varticles.OrderBy(m => m.catepath);
List<AlbumModel> lst = new List<AlbumModel>();
foreach (blog_varticle varticle in varticles)
{
lst.Add(GetAlbum(varticle));
}
return lst.AsQueryable();
}
//
// GET: /Customer/
public ActionResult Index(int? p, string category,string guidang)
{
string Category = category ?? "全部";
string Guidang = guidang ?? "0";
Pager pager = new Pager();
pager.table = "CMSCustomer";
pager.strwhere = "1=1";
pager.PageSize = 10;
pager.PageNo = p ?? 1;
pager.FieldKey = "CustomerId";
pager.FiledOrder = "CustomerId Desc";
if (Category !="全部")
{
pager.strwhere = pager.strwhere + " and charindex('" + Category + "',CustomerTizhi)>0";
}
if (Guidang != "0")
{
pager.strwhere = pager.strwhere + " and charindex('" + Guidang + "',CustomerGuidang)>0";
}
pager = CMSService.SelectAll("Customer", pager);
List<CustomerDto> list = new List<CustomerDto>();
foreach (DataRow dr in pager.EntityDataTable.Rows)
{
CustomerDto dto = CustomerMapping.getDTO(dr);
list.Add(dto);
}
pager.Entity = list.AsQueryable();
ViewBag.PageNo = p ?? 1;
ViewBag.PageCount = pager.PageCount;
ViewBag.RecordCount = pager.Amount;
ViewBag.Message = pager.Amount;
ViewData["Category"] = MyService.GetCategoryList("CategoryParentId=20");
ViewData["Guidang"] = MyService.GetCategoryList("CategoryParentId=30");
return View(pager.Entity);
}
//
// GET: /Liangbiao/Details/5
public ActionResult List(int?p,int id)
{
Pager pager = new Pager();
pager.table = "CMSTizhi";
pager.strwhere = "TizhiCustomerId="+id;
pager.PageSize = 10;
pager.PageNo = p ?? 1;
pager.FieldKey = "TizhiId";
pager.FiledOrder = "TizhiId Desc";
pager = CMSService.SelectAll("Tizhi", pager);
List<TizhiDto> list = new List<TizhiDto>();
foreach (DataRow dr in pager.EntityDataTable.Rows)
{
TizhiDto dto = TizhiMapping.getDTO(dr);
list.Add(dto);
}
pager.Entity = list.AsQueryable();
ViewBag.PageNo = p ?? 1;
ViewBag.PageCount = pager.PageCount;
ViewBag.RecordCount = pager.Amount;
ViewBag.Message = pager.Amount;
ViewBag.CustomerId = id;
ViewBag.CustomerName = MyService.CustomerIdToName("CustomerId=" + id);
return View(pager.Entity);
}
/// <summary>
/// 记录结果处理
/// </summary>
private IQueryable<ArtilceWithDecorate> GetNewArticleQuery(IQueryable<blog_varticle> d, out string jsonSummaryImg)
{
configinfo.DecorateImgCount = WebUtils.GetDecorateCount(WebUtils.GetCurrentTheme());
List<ArtilceWithDecorate> list = new List<ArtilceWithDecorate>();
string str = "[";
string img = "";
int tmpKey = 0;
Random ran = new Random();
string themepath = WebUtils.GetCurrentTheme() == "" ? "/Content/" : "/Themes/" + WebUtils.GetCurrentTheme() + "/Content/";
foreach (blog_varticle a in d)
{
//提取summary中第一张图
img = Utils.GetImg(a.summary);
//提取内容中的第一张图
//if (img == "")
// img = Utils.GetImg(a.content);
if (img == "" && configinfo.DecorateImgCount > 0)
{
int RandKey = ran.Next(1001, 1000 + configinfo.DecorateImgCount);
if (RandKey == tmpKey)
RandKey++;
RandKey = RandKey > 1000 + configinfo.DecorateImgCount ? 1001 : RandKey;
tmpKey = RandKey;
img = themepath+"image/decorate/" + RandKey.ToString() + ".jpg";
}
if (img != "")
str += "{\"id\":\"" + a.id.ToString() + "\",\"img\":\"" + img + "\"},";
list.Add(
new ArtilceWithDecorate
{
id=a.id,
title=a.title,
cateid=a.cateid,
typeid=a.typeid,
createdate=a.createdate,
viewcount=a.viewcount,
subcount=a.subcount,
catepath = myService.GetCategoryPathUrl(a.catepath),
rename=a.rename,
url=a.url,
istop=a.istop,
iscommend=a.iscommend,
Decorate=img,
summary = Utils.ClearImgs(a.summary).Trim() == "" ? Utils.CutString(Utils.RemoveHtml(a.content), 0, configinfo.MaxSummaryCharCount) + "..." : Utils.ClearImgs(a.summary),
FullSummary = a.summary.Trim() == "" ? Utils.CutString(Utils.RemoveHtml(a.content), 0, configinfo.MaxSummaryCharCount) + "..." : a.summary.Trim()
});
}
jsonSummaryImg = "var summaryimgs=" + str.Trim(',') + "];";
return list.AsQueryable<ArtilceWithDecorate>();
}
