// GET: User
public ActionResult Index()
{
Models.Pager <UserModels> pager = new Models.Pager <UserModels>();
pager.CurrentPageIndex = 1;
pager.PageSize = 10;
pager.TotalItemCount = 100000;
pager.ShowItemNum = 20;
return(View(pager));
}
/// <summary>
/// get user info as List<base_community_buildinginfo>
/// </summary>
/// <param name="userKey"></param>
/// <param name="paramDicts"></param>
/// <returns></returns>
public ArrayList GetUserList(string userKey, Dictionary <string, object>[] paramDicts)
{
return(Excute(() =>
{
Models.Pager <sys_user_baseinfo> pager = null;
if (paramDicts[0].ContainsKey("Pager`1"))
{
pager = paramDicts[0].As <Models.Pager <sys_user_baseinfo> >();
}
return Entity.GetModelList <sys_user_baseinfo, object>(
model => model.dr != true,//model => model.user_name == "aaa",
model => model.user_name,
pager);
}));
}
//public IQueryable<JiaJiNewWebModel.erweima> QueryShowErWeiMa()
//{
// return QueryEntities(m => m.IsShowCaiDan == 1).OrderBy(s => s.ShowCaiDanIndex);
//}
public ActionResult SouSuo(string selName, int pageIndex = 1, int pageSize = 10)
{
JiaJiNewWebModel.Home.selectmodel model = new JiaJiNewWebModel.Home.selectmodel();
model.Activetable.ActiveTitle = selName;
model.Activetable.Datails = selName;
model.Infortable.Title = selName;
model.Infortable.content = selName;
model.Strategytable.StrategyTitle = selName;
model.Strategytable.StrategyContent = selName;
model.Navtable.NavTitleOne = selName;
model.Navtable.NavTitleTwo = selName;
model.Navtable.NavContentOne = selName;
List <JiaJiNewWebModel.Home.SearchDetails> infolist = new JiaJiNewWebBLL.InformationBLL().Select(model);
var count = infolist.Count;
var pageTotal = (int)Math.Ceiling((double)(count) / pageSize);
if (pageIndex < 1)
{
pageIndex = 1;
}
if (pageIndex >= pageTotal)
{
pageIndex = pageTotal;
}
infolist = infolist.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
ViewBag.OptionImage = new JiaJiNewWebBLL.OptionBLL().HotOptionImage();
ViewBag.activelist = new JiaJiNewWebBLL.ActiveBLL().ActiveLsitIndex();//加载活动
ViewBag.optionlist = new JiaJiNewWebBLL.OptionBLL().HotOption();
ViewBag.selName = selName;
if (infolist.Count == 0)
{
return(Content("<script>alert('暂无该搜索结果');location.href='/Home/Index';</script>"));
}
else
{
Models.Pager <JiaJiNewWebModel.Home.SearchDetails> pager = new Models.Pager <JiaJiNewWebModel.Home.SearchDetails>();
pager.PageIndex = pageIndex;
pager.PageSize = pageSize;
pager.PageTotal = pageTotal;
pager.Model = infolist;
return(View(pager));
}
}
/// <summary>
/// get building info as List<base_community_buildinginfo>
/// </summary>
/// <param name="userKey"></param>
/// <param name="paramDicts"></param>
/// <returns></returns>
public ArrayList GetBuildingList(string userKey, Dictionary <string, object>[] paramDicts)
{
Exception erro = null;
object data = null;
string message = null;
Models.Pager <base_community_buildinginfo> pager = null;
if (paramDicts[0].ContainsKey("Pager`1"))
{
pager = paramDicts[0].As <Models.Pager <base_community_buildinginfo> >();
}
try
{
var community_id = new Guid(paramDicts[0]["community_id"].ToString());
using (var context = new Data.CbooEntities())
{
var models = from building in context.base_community_buildinginfo
where building.community_id == community_id && building.status != -1
orderby building.building_name
select building;
if (pager == null)
{
data = models.ToList();
}
else
{
data = models.Page(pager);
}
}
}
catch (Exception ex)
{
erro = ex;
message = ex.Message;
}
ArrayList revList = new ArrayList();
revList.Add(new Models.ServerResult()
{
succeed = erro == null, data = data, message = message
});
return(revList);
}
public static Models.Pager <TEntity> Page <TEntity>(this IEnumerable <TEntity> query, Models.Pager <TEntity> pager) where TEntity : class
{
pager.data_list = query.Skip((pager.page_index) * pager.page_size).Take(pager.page_size).ToList();
pager.total = query.Count();
return(pager);
}
public static object GetModelList <TEntity, TKey>(Func <TEntity, bool> where, Func <TEntity, TKey> orderby, Models.Pager <TEntity> pager) where TEntity : class
{
using (var context = new Data.CbooEntities())
{
IEnumerable <TEntity> models = (from model in context.CreateObjectSet <TEntity>()
select model);
if (where != null)
{
models = models.Where(where);
}
if (orderby != null)
{
models = models.OrderBy(orderby);
}
if (pager != null)
{
return(models.Page(pager));
}
return(models.ToList());
}
}
