/// <summary>
/// 根据name获取信息
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public ResultInfo.Info GetInfoByName(string name)
{
info.ResultType = ResultInfo.BaseResultType.Error;
var data = db.EnterpriseInfo.AsQueryable().Where(p => p.Title == name).Select(p => new { p.Id, p.Title, p.Content, p.Admin, p.AddDate, p.HtmlRegion, p.HtmlRegion.HtmlPage });
if (data != null)
{
var list = data.ToList();
LimitPropsContractResolver limitProps = null;
if (list.Count() > 0)
{
limitProps = new LimitPropsContractResolver();
limitProps.Add <EnterpriseInfo>(p => new { p.Id, p.Title, p.Content, p.Admin, p.AddDate, p.HtmlRegion });
limitProps.Add <Admin>(p => new { p.Id, p.Name });
limitProps.Add <HtmlRegion>(p => new { p.Id, p.RegionName, p.HtmlPage });
limitProps.Add <HtmlPage>(p => new { p.Id, p.PageName });
}
info.DataObj = list.ToJson(limitProps);
info.ResultType = ResultInfo.BaseResultType.Success;
info.Msg = "获取成功！";
}
else
{
info.Msg = "获取失败！或许已经删除";
}
return(info);
}
/// <summary>
/// 查询企业信息
/// </summary>
/// <returns></returns>
public ResultInfo.Info QueryInfo(string startDate, string endDate, string title)
{
var data = db.EnterpriseInfo.AsQueryable().Select(p => new { p.Id, p.Title, p.Admin, p.AddDate, p.HtmlRegion, p.HtmlRegion.HtmlPage });
if (!string.IsNullOrEmpty(startDate))
{
var time = Convert.ToDateTime(startDate);
data = data.Where(p => Convert.ToDateTime(p.AddDate) > time);
}
if (!string.IsNullOrEmpty(endDate))
{
var time = Convert.ToDateTime(endDate);
data = data.Where(p => Convert.ToDateTime(p.AddDate) < time);
}
if (!string.IsNullOrEmpty(title))
{
data = data.Where(p => p.Title.Contains(title));
}
var list = data.OrderByDescending(p => p.AddDate).ToList();
LimitPropsContractResolver limitProps = null;
if (list.Count() > 0)
{
limitProps = new LimitPropsContractResolver();
limitProps.Add <EnterpriseInfo>(p => new { p.Id, p.Title, p.Admin, p.AddDate, p.HtmlRegion });
limitProps.Add <Admin>(p => new { p.Id, p.Name });
limitProps.Add <HtmlRegion>(p => new { p.Id, p.RegionName, p.HtmlPage });
limitProps.Add <HtmlPage>(p => new { p.Id, p.PageName });
}
info.DataObj = list.ToJson(limitProps);
info.ResultType = ResultInfo.BaseResultType.Success;
return(info);
}
/// <summary>
/// 获取该图片组的信息
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public ResultInfo.Info GetImageList(string tile)
{
var data = db.HtmlElement.Where(p => p.Title == tile).Select(p => new { p.Id, p.Title, p.Admin, p.AddDate, p.HtmlRegion, p.HtmlRegion.HtmlPage, p.Image, p.Width, p.Height, p.Remark });
var list = data.ToList();
LimitPropsContractResolver limitProps = null;
if (list.Count() > 0)
{
limitProps = new LimitPropsContractResolver();
limitProps.Add <HtmlElement>(p => new { p.Id, p.Title, p.Admin, p.AddDate, p.HtmlRegion, p.Image });
limitProps.Add <Admin>(p => new { p.Id, p.Name });
limitProps.Add <HtmlRegion>(p => new { p.Id, p.RegionName, p.HtmlPage });
limitProps.Add <HtmlPage>(p => new { p.Id, p.PageName });
limitProps.Add <Image>(p => new { p.Id, p.Name, p.Sort, p.Url, p.Alt });
info.DataObj = list.ToJson(limitProps);
info.ResultType = ResultInfo.BaseResultType.Success;
}
else
{
info.ResultType = ResultInfo.BaseResultType.Error;
info.Msg = "未查询到该图片组！";
}
return(info);
}
/// <summary>
/// 查询留言
/// </summary>
/// <returns></returns>
public ResultInfo.Info QueryMessage(string startDate, string endDate, string keyWord, string htmlPageId, bool?isAdmin)
{
var data = db.Message.AsQueryable();
if (!string.IsNullOrEmpty(startDate))
{
var time = Convert.ToDateTime(startDate);
data = data.Where(p => Convert.ToDateTime(p.AddDate) > time);
}
if (!string.IsNullOrEmpty(endDate))
{
var time = Convert.ToDateTime(endDate);
data = data.Where(p => Convert.ToDateTime(p.AddDate) < time);
}
if (!string.IsNullOrEmpty(keyWord))
{
data = data.Where(p => p.Mobile.Contains(keyWord) || p.MessageContent.Contains(keyWord) || p.Nick.Contains(keyWord));
}
if (!string.IsNullOrEmpty(htmlPageId))
{
data = data.Where(p => p.HtmlPage.Id == Convert.ToInt32(htmlPageId));
}
if (isAdmin != null)
{
data = data.Where(p => p.IsAdmin == isAdmin);
}
var list = data.OrderByDescending(p => p.Id).ToList();
LimitPropsContractResolver limitProps = null;
if (list.Count() > 0)
{
limitProps = new LimitPropsContractResolver();
limitProps.Add <Message>(p => new { p.Id, p.MessageContent, p.Admin, p.AddDate, p.HtmlPage, p.Mobile, p.Nick, p.UpperLeve });
limitProps.Add <Admin>(p => new { p.Id, p.Name });
limitProps.Add <HtmlPage>(p => new { p.Id, p.PageName });
}
info.DataObj = list.ToJson(limitProps);
info.ResultType = ResultInfo.BaseResultType.Success;
return(info);
}
/// <summary>
/// 获取指定id的留言
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ResultInfo.Info GetMessageById(int id)
{
var data = db.Message.Where(p => p.Id == id).Select(p => new { p.Id, p.MessageContent, p.Admin, p.AddDate, p.HtmlPage, p.Mobile, p.Nick, p.UpperLeve }).ToList();
if (data != null)
{
LimitPropsContractResolver limitProps = null;
if (data.Count() > 0)
{
limitProps = new LimitPropsContractResolver();
limitProps.Add <Message>(p => new { p.Id, p.MessageContent, p.Admin, p.AddDate, p.HtmlPage, p.Mobile, p.Nick, p.UpperLeve });
limitProps.Add <Admin>(p => new { p.Id, p.Name });
limitProps.Add <HtmlPage>(p => new { p.Id, p.PageName });
}
info.DataObj = data.ToJson(limitProps);
info.ResultType = ResultInfo.BaseResultType.Success;
}
else
{
info.Msg = "该留言不存在，或已被删除！";
info.ResultType = ResultInfo.BaseResultType.Error;
}
return(info);
}