/// <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>
/// <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 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>
/// 返回JsonResult
/// </summary>
/// <param name="data">数据</param>
/// <param name="contractResolver">只显示指定字段</param>
/// <returns>JsonReuslt</returns>
protected JsonResult Json(object data, LimitPropsContractResolver contractResolver)
{
return(Json(
data,
null,
System.Text.Encoding.UTF8,
JsonRequestBehavior.AllowGet,
contractResolver
));
}
/// <summary>
/// 序列化Json字符串（默认Json配置：空值的属性不序列化、Json中存在的属性，实体中不存在的属性不反序列化，避免出错）
/// </summary>
/// <param name="source"></param>
/// <param name="limitPropsContractResolver">序列化属性设置</param>
/// <returns></returns>
public static string ToJson(this object source, LimitPropsContractResolver limitPropsContractResolver)
{
if (source == null || source is DBNull)
{
return(null);
}
var jsonSettings = Utility.DefaultJsonSettings;
jsonSettings.ContractResolver = limitPropsContractResolver;
return(JsonConvert.SerializeObject(source, jsonSettings));
}
/// <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);
}
/// <summary>
/// 返回JsonResult
/// </summary>
/// <param name="data">数据</param>
/// <param name="contentType">内容类型</param>
/// <param name="contentEncoding">内容编码</param>
/// <param name="behavior">行为</param>
/// <param name="contractResolver">只显示指定字段</param>
/// <returns>JsonReuslt</returns>
protected JsonResult Json(object data, string contentType, System.Text.Encoding contentEncoding, JsonRequestBehavior behavior, LimitPropsContractResolver contractResolver)
{
return(new CustomJsonResult
{
Data = data,
ContentType = contentType,
ContentEncoding = contentEncoding,
JsonRequestBehavior = behavior,
FormateStr = "yyyy-MM-dd HH:mm:ss",
ContractResolver = contractResolver
});
}
