/// <summary>
/// 用户登录
/// </summary>
/// <param name="userName">用户名</param>
/// <param name="password">用户密码</param>
/// <returns></returns>
public ActionResult UserLogin(string userName, string password)
{
password = Common.EncryptHelper.Encrypt(password);
#region 处理验证
string yzjg = Verification();
if (string.IsNullOrEmpty(yzjg) || yzjg == "sb")
{
return(Json(SysEnum.失败, "请点击按钮进行验证"));
}
#endregion
#region 处理用户名密码
var administrator = AdministratorService.LoadEntities(u => u.login_account == userName && u.login_pwd == password).FirstOrDefault();
if (administrator == null)
{
SaveSyslog("用户名或密码错误！", SysLogType.后台日志, userName);
return(Json(SysEnum.用户名或密码错误, "用户名或密码错误"));
}
#endregion
administrator.last_login_time = DateTime.Now;
administrator.last_login_IP_address = Request.UserHostAddress;
AdministratorService.EditEntity(administrator);
//添加到缓存里
CacheHelper.AddCache(administrator.id.ToString(), administrator, DateTime.Now.AddMinutes(60));
SaveSyslog("登陆后台管理", SysLogType.后台日志, userName);
dynamic data = new { token = Common.EncryptHelper.Encrypt(string.Format("{0}|{1}", administrator.id.ToString(), Request.UserHostAddress)) };
return(Json(SysEnum.成功, data, "登录成功"));
}
public JsonResult Listar()
{
if (CacheHelper.GetCache("Gridview") != null)
{
return(Json((List <GridViewModel>)CacheHelper.GetCache("Gridview"), JsonRequestBehavior.AllowGet));
}
List <GridViewModel> lst = new List <GridViewModel>();
for (int i = 0; i < 30; i++)
{
lst.Add(new GridViewModel()
{
ID = (i + 1),
CompanyName = "CompanyName " + (i + 1),
Address = "Address " + (i + 1),
City = "City " + (i + 1),
State = "State " + (i + 1),
Zipcode = "Zipcode " + (i + 1),
Phone = "Phone " + (i + 1),
Fax = "Fax " + (i + 1),
Website = "Website " + (i + 1)
});
}
CacheHelper.AddCache("Gridview", lst, DateTime.Now.AddMinutes(10));
return(Json(lst, JsonRequestBehavior.AllowGet));
}
public ActionResult GetUser_ChildList(int id)
{
var uf = CacheHelper.GetCache($"user_first_child_{id}") as List <user>;
if (uf == null || uf.Count() == 0)
{
uf = UserService.LoadEntities(n => n.pid == id).ToList();
if (uf.Any())
{
CacheHelper.AddCache($"user_first_child_{id}", uf, DateTime.Now.AddMinutes(10));
}
}
if (uf.Any())
{
var item = UserService.LoadEntities(n => n.id == id).FirstOrDefault();
var data = uf.Select(n => new
{
n.id,
n.name,
n.state,
n.isbuy,
children = GetSecondChild(n.id)
}).ToList();
var data1 = new
{
item.id,
item.name,
item.state,
children = data,
};
return(Json(SysEnum.成功, data1, "获取数据成功", uf.Count()));
}
return(Json(SysEnum.失败, "未找到对象"));
}
private Tuple <List <int>, List <int> > GetFirstLevelChild(int id)
{
var uf = CacheHelper.GetCache($"user_first_child_{id}") as List <user>;
var us = CacheHelper.GetCache($"user_second_child_{id}") as List <user>;
var f = new List <int>();
var s = new List <int>();
if (uf == null || uf.Count() == 0)
{
uf = UserService.LoadEntities(n => n.pid == id).ToList();
if (uf.Any())
{
CacheHelper.AddCache($"user_first_child_{id}", uf, DateTime.Now.AddMinutes(10));
}
}
f = uf.Select(n => n.id).ToList();
if (us == null || us.Count() == 0)
{
us = UserService.LoadEntities(n => f.Contains(n.pid)).ToList();
if (us.Any())
{
CacheHelper.AddCache($"user_second_child_{id}", us, DateTime.Now.AddMinutes(10));
}
}
s = us.Select(n => n.id).ToList();
return(new Tuple <List <int>, List <int> >(f, s));
}
public ActionResult Login(LoginModel model)
{
if (ModelState.IsValid)
{
if (model.UserName == "yjq" && model.Pwd == "123456")
{
string ticket = CrypHelper.GetNonce();
CookieHelper.SetCookie("SSO_Ticket", ticket);
CacheHelper.AddCache(ticket, 1, TimeSpan.FromHours(5));
if (string.IsNullOrWhiteSpace(model.BackUrl))
{
model.BackUrl = "/Home/Index";
}
if (model.BackUrl.IndexOf('?') > 0)
{
model.BackUrl += "&ticket=" + ticket;
}
else
{
model.BackUrl += "?ticket=" + ticket;
}
return(Redirect(model.BackUrl));
}
}
return(View(model));
}
/// <summary>
/// 查询当前分类的玄机图库
/// </summary>
/// <param name="newsId">新闻Id</param>
/// <param name="newsTitle">新闻标题</param>
/// <param name="lType">彩种Id</param>
/// <returns></returns>
public List <Gallery> GetGalleries(long newsId, string newsTitle, int lType)
{
string memKey = string.Format(RedisKeyConst.Base_GalleryId, newsId); //"base_gallery_id_" + newsId;
var list = CacheHelper.GetCache <List <Gallery> >(memKey);
if (list != null && list.Any())
{
return(list);
}
string sql = @"select a.Id, a.FullHead as Name,a.[TypeId],right(ISNULL(a.LotteryNumber,''),3) as Issue, c.RPath as Picture
from News a
left join ResourceMapping c on c.FkId=a.Id and c.[Type]=1
where a.FullHead=@FullHead and a.[TypeId]=@TypeId and DeleteMark=0 and EnabledMark=1
order by a.LotteryNumber desc";
var parameters = new[]
{
new SqlParameter("@FullHead", SqlDbType.NVarChar),
new SqlParameter("@TypeId", SqlDbType.Int)
};
parameters[0].Value = newsTitle;
parameters[1].Value = lType;
list = Util.ReaderToList <Gallery>(sql, parameters) ?? new List <Gallery>();
//CacheHelper.WriteCache(memKey, list);
CacheHelper.AddCache(memKey, list);
return(list);
}
public ActionResult GetMenu()
{
//获取当前管理员所有菜单信息
if (!(CacheHelper.GetCache($"adminactionidList_{nowManager.id}") is List <int> adminactionidList) || adminactionidList.Count == 0)
{
adminactionidList = new List <int>();
foreach (var item in nowManager.role.ToList())
{
var acid = item.action.ToList().Select(n => n.id).ToList();
adminactionidList.AddRange(acid);
}
adminactionidList.Distinct();
if (adminactionidList.Count > 0)
{
CacheHelper.AddCache($"adminactionidList_{nowManager.id}", adminactionidList, DateTime.Now.AddHours(2));
}
}
if (adminactionidList.Any())
{
var actionList = ActionService.LoadEntities(n => adminactionidList.Contains(n.id) && n.del_flag == (int)Del_flag.正常 && n.type == (int)ActionType.菜单权限).ToList();
List <dynamic> data = new List <dynamic>();
if (actionList.Any())
{
data = GetMenuTree(actionList.OrderBy(n => n.sort).ToList());
}
return(Json(SysEnum.成功, data, "获取数据成功", data.Count));
}
return(Json(SysEnum.权限不足, "权限不足"));
}
/// <summary>
/// 获取新闻资讯彩种分类列表
/// </summary>
/// <returns></returns>
public ApiResult <List <LotteryTypeResDto> > GetLotteryTypeList()
{
string cachekey = RedisKeyConst.Base_LotteryType;
List <LotteryType> list = CacheHelper.GetCache <List <LotteryType> >(cachekey);
if (list == null)
{
list = Util.GetEntityAll <LotteryType>().OrderBy(x => x.SortCode).ToList();
//CacheHelper.WriteCache("base_lottery_type", list);
CacheHelper.AddCache(cachekey, list);
}
var resDto = list.Select(x => new LotteryTypeResDto()
{
Id = x.Id,
LType = Util.GetlTypeById(x.Id.ToInt32()),
LTypeName = x.TypeName,
SortCode = x.SortCode
}).ToList();
return(new ApiResult <List <LotteryTypeResDto> >()
{
Data = resDto
});
}
public ActionResult Watch()
{
#region Parameter Verify
string id = Request.QueryString[Const.VIDEOID].ToString();
if (string.IsNullOrEmpty(id))
{
id = "8";
}
int ids = 0;
if (!int.TryParse(id, out ids))
{
return(View());
}
#endregion
//Get Cache
StartRecommendModel modelCache = CacheHelper.GetCacheBy(id) as StartRecommendModel;
if (modelCache != null)
{
return(View(modelCache));
}
//if no cache,serach data from db,add to cache.
StartRecommendModel model = _service.GetSpecialVideoBy(ids);
CacheHelper.AddCache(id, model);
return(View(model));
}
//区间下拉
private void BindRegionTypeListBox()
{
DataTable dt = new DataTable();
if (Cache["regiontype"] != null)
{
dt = (DataTable)Cache["regiontype"];
}
else
{
dt = bll.GetListBoxData(userId, "RegionTypeFull", "RegionType", "ASC");
CacheHelper.AddCache("regiontype", dt, CacheItemPriority.Normal);
}
this.RegionTypeListBox.DataSource = dt;
this.RegionTypeListBox.DataTextField = "RegionTypeFull";
this.RegionTypeListBox.DataValueField = "RegionType";
this.RegionTypeListBox.DataBind();
string[] arr = regionType.Split(',');
foreach (ListItem item in this.RegionTypeListBox.Items)
{
foreach (string str in arr)
{
if (item.Value == str)
{
item.Selected = true;
}
}
}
}
public static bool ShowDiscountProduct(DateTime date)
{
bool result = false;
DiscountModel model = new DiscountModel();
try
{
if (CacheHelper.IsCacheDB($"DiscountProduct-{DateTime.Now.ToString("ddMMyyyy")}"))
{
result = CommonLib.IsNullBool(CacheHelper.GetCache($"DiscountProduct-{DateTime.Now.ToString("ddMMyyyy")}"));
}
else
{
var list = JsonCacheHepler.GetJsonContent <List <DiscountModel> >("/Upload/xml", "DiscountProduct");
if (list != null && list.Count > 0)
{
var item = list.Where(m => m.StartDate <= date && m.EndDate >= date && m.IsShow == 1).FirstOrDefault();
if (item != null)
{
result = true;
}
}
CacheHelper.AddCache($"DiscountProduct-{DateTime.Now.ToString("ddMMyyyy")}", result, 24 * 60);
}
}
catch (Exception ex)
{
WriteLog.Current.WriteFileLog("DataAccess\\ProductRP", "ProductRP=>ShowDiscountProduct", ex);
}
return(result);
}
public ActionResult GetUseMsgLink(int id)
{
if (!(CacheHelper.GetCache($"user_msg_record") is List <user_msg_record> list) || list.Count == 0)
{
var d = DateTime.Now.AddDays(-61);
list = User_msg_recordService.LoadEntities(n => n.msg_type == (int)Msg_type.提问 && n.add_time < d).ToList(); //最近61天内的数据
if (list.Any())
{
CacheHelper.AddCache($"user_msg_record", list, DateTime.Now.AddMinutes(20));
}
}
if (list.Any())
{
var data = new List <user_msg_record>();
data.Add(GetParentMsg(list, id));
if (data.Any())
{
var res = data.OrderBy(n => n.add_time).Select(n => new {
n.id,
user_name = n.user.name,
n.user_id,
n.title,
n.msg_content,
n.isread,
msg_type = Enum.GetName(typeof(Msg_type), n.msg_type),
add_time = n.add_time.ToString(),
n.remark,
admin_name = n.administrator == null ? string.Empty : n.administrator.name,
}).ToList();
return(Json(SysEnum.成功, data, "获取数据成功", list.Count()));
}
return(Json(SysEnum.失败, "没有任何数据"));
}
return(Json(SysEnum.失败, "没有任何数据"));
}
protected void Page_Load(object sender, EventArgs e)
{
string url = Request.QueryString["url"];
if (!string.IsNullOrEmpty(url))
{
try
{
url = HttpUtility.UrlDecode(url);
string state = EncryptHelper.MD5Encrypt(url);
//判断url根据MD5生成的密文在缓存中是否存在
object objUrl = CacheHelper.GetCache(state);
if (objUrl == null)
{
CacheHelper.AddCache(state, url, 5);//不存在则将url和对应的密文存储在缓存中，存储时长为5分钟
}
else
{
CacheHelper.SetCache(state, url, 5);//存在则将url和对应的密文在缓存中更新，更新存储时长为5分钟
}
Response.Redirect(string.Format("https://open.weixin.qq.com/connect/oauth2/authorize?appid={0}&redirect_uri={1}&response_type=code&scope=snsapi_base&state={2}#wechat_redirect", appId, ConfigurationManager.AppSettings["apppath"] + "/Auth.aspx", state));
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 微信公众号引导页
/// </summary>
/// <param name="url">微信前端传递的跳转url</param>
/// <returns>成功时，重定向至获取用户信息</returns>
public ActionResult Index(string url)
{
if (!string.IsNullOrEmpty(url))
{
url = WXHelper.DecodeBase64(url);
string state = EncryptHelper.MD5Encrypt(url);
//判断url根据MD5生成的密文在缓存中是否存在
object objUrl = CacheHelper.GetCache(state);
if (objUrl == null)
{
CacheHelper.AddCache(state, url, 5);//不存在则将url和对应的密文存储在缓存中，存储时长为5分钟
}
else
{
CacheHelper.SetCache(state, url, 5);//存在则将url和对应的密文在缓存中更新，更新存储时长为5分钟
}
return(Redirect(string.Format("https://open.weixin.qq.com/connect/oauth2/authorize?appid={0}&redirect_uri={1}&response_type=code&scope=snsapi_base&state={2}#wechat_redirect", appId, ConfigurationManager.AppSettings["zp_apppath"] + "/Recruitment/Auth/GetUserInfo", state)));
}
else
{
ViewData["errmsg"] = "重定向url不能为空！";
}
return(View());
}
public void GetKefu(System.Web.HttpContext context)
{
System.Collections.Generic.Dictionary <string, string> dictionary = new System.Collections.Generic.Dictionary <string, string>();
if (System.Web.HttpRuntime.Cache["kefu"] == null)
{
ConfigInfo configInfo = FacadeManage.aideNativeWebFacade.GetConfigInfo(AppConfig.SiteConfigKey.ContactConfig.ToString());
if (configInfo != null)
{
dictionary["kefu53"] = configInfo.Field4;
dictionary["kefuinfo"] = configInfo.Field5;
dictionary["kefudesc"] = configInfo.Field6;
dictionary["qq"] = configInfo.Field7;
CacheHelper.AddCache("kefu", dictionary);
}
}
else
{
dictionary = (System.Web.HttpRuntime.Cache["kefu"] as System.Collections.Generic.Dictionary <string, string>);
}
string text = dictionary["kefu53"];
string value = dictionary["kefuinfo"];
string value2 = dictionary["kefudesc"];
string value3 = dictionary["qq"];
AjaxJsonValid ajaxJsonValid = new AjaxJsonValid();
ajaxJsonValid.AddDataItem("kefu53", text);
if (text == "")
{
ajaxJsonValid.AddDataItem("kefuinfo", value);
}
ajaxJsonValid.AddDataItem("kefudesc", value2);
ajaxJsonValid.AddDataItem("qq", value3);
ajaxJsonValid.SetValidDataValue(true);
context.Response.Write(ajaxJsonValid.SerializeToJson());
}
protected void Page_Load(object sender, System.EventArgs e)
{
System.Collections.Generic.Dictionary <string, string> dictionary = new System.Collections.Generic.Dictionary <string, string>();
if (System.Web.HttpRuntime.Cache["kefu"] == null)
{
ConfigInfo configInfo = FacadeManage.aideNativeWebFacade.GetConfigInfo(AppConfig.SiteConfigKey.ContactConfig.ToString());
if (configInfo != null)
{
dictionary["kefu53"] = configInfo.Field4;
dictionary["kefuinfo"] = configInfo.Field5;
CacheHelper.AddCache("kefu", dictionary);
}
}
else
{
dictionary = (System.Web.HttpRuntime.Cache["kefu"] as System.Collections.Generic.Dictionary <string, string>);
}
string text = dictionary["kefu53"];
string arg_91_0 = dictionary["kefuinfo"];
if (text != "")
{
base.Response.Redirect(text);
}
}
//专题下拉
private void BindZhuanTiListBox()
{
string zttype = string.Format("zttype_{0}", userId);
DataTable dt = new DataTable();
if (Cache[zttype] != null)
{
dt = (DataTable)Cache[zttype];
}
else
{
dt = bll.GetListBoxData(userId, "ZhuanTiName", "ZhuanTiID", "ASC");
CacheHelper.AddCache(zttype, dt, CacheItemPriority.Normal);
}
this.ZhuanTiListBox.DataSource = dt;
this.ZhuanTiListBox.DataTextField = "ZhuanTiName";
this.ZhuanTiListBox.DataValueField = "ZhuanTiID";
this.ZhuanTiListBox.DataBind();
string[] arr = ztId.Split(',');
foreach (ListItem item in this.ZhuanTiListBox.Items)
{
foreach (string str in arr)
{
if (item.Value == str)
{
item.Selected = true;
}
}
}
}
//钱包下拉
private void BindCardListBox()
{
DataTable dt = new DataTable();
if (Cache["cardtype"] != null)
{
dt = (DataTable)Cache["cardtype"];
}
else
{
dt = bll.GetListBoxData(userId, "CardName", "CardID", "ASC");
CacheHelper.AddCache("cardtype", dt, CacheItemPriority.Normal);
}
this.CardListBox.DataSource = dt;
this.CardListBox.DataTextField = "CardName";
this.CardListBox.DataValueField = "CardID";
this.CardListBox.DataBind();
string[] arr = cardId.Split(',');
foreach (ListItem item in this.CardListBox.Items)
{
if (cardId == "")
{
item.Selected = true;
}
foreach (string str in arr)
{
if (item.Value == str)
{
item.Selected = true;
}
}
}
}
/// <summary>
/// 检查版本更新
/// </summary>
/// <param name="version">客户端版本</param>
/// <param name="clientType">设备类型</param>
/// <param name="customerSourceId">客户来源Id</param>
/// <param name="appName">App编码</param>
/// <returns></returns>
public CheckerResDto CheckVersion(ApiVersion version, DevicePlatform clientType, byte customerSourceId,
string appName)
{
long versionCode = GetDefaultVersionCode(version.FullVersion, clientType);
//客户端版本
string clientSourceKey = string.Format(RedisKeyConst.Installationpackage_ClientSourceKey,
GetDefaultVersionCode(version.FullVersion, clientType),
(int)clientType, customerSourceId, appName);
var resDto = CacheHelper.GetCache <CheckerResDto>(clientSourceKey);
if (resDto == null)
{
var sourceVersion = GetSourceVersion(clientType, customerSourceId, appName, versionCode);
if (sourceVersion != null)
{
resDto = new CheckerResDto()
{
Status = sourceVersion.UpdateType,
Content = string.Empty,
Downurl = string.Empty
};
if ((sourceVersion.UpdateType == (int)ClientUpdateStatus.Optional ||
sourceVersion.UpdateType == (int)ClientUpdateStatus.Force) && sourceVersion.UpdateToVersionCode > 0)
{
var updateToSourceVersion = GetSourceVersion(clientType, customerSourceId, appName,
sourceVersion.UpdateToVersionCode);
if (updateToSourceVersion != null)
{
resDto.Content = string.IsNullOrWhiteSpace(updateToSourceVersion.ClientVersionDesc)
? ""
: updateToSourceVersion.ClientVersionDesc;
resDto.Downurl = string.IsNullOrWhiteSpace(updateToSourceVersion.UpdateLink)
? ""
: updateToSourceVersion.UpdateLink;
}
}
//CacheHelper.WriteCache(clientSourceKey, resDto, 1440);
CacheHelper.AddCache(clientSourceKey, resDto, 1440);
}
else
{
resDto = new CheckerResDto()
{
Status = (int)ClientUpdateStatus.None,
Content = "",
Downurl = ""
};
}
}
return(resDto);
}
/// <summary>
/// 获取广告列表
/// </summary>
/// <param name="location">栏目Id</param>
/// <param name="adtype">广告类型 1=栏目 2=文章 3=六彩栏目</param>
/// <param name="deviceType">设备类型 1=网页等其他 2=ios 3=安卓</param>
/// <param name="city">所在城市</param>
/// <returns></returns>
public ApiResult <List <AdvertisementResDto> > GetAdvertList(int location, int adtype, int deviceType, string city, string reqIp)
{
//string memKey = string.Format("advertisement_{0}_{1}_{2}", location, adtype, deviceType);
string memKey = string.Format(RedisKeyConst.Advertisement_List, adtype, deviceType, location);
var list = CacheHelper.GetCache <List <Advertisement> >(memKey);
if (list == null)
{
string strsql;
if (adtype == 3)
{
//六彩栏目列表
strsql = string.Format(@"select * from [dbo].[Advertisement] where charindex(',{1},',','+[where]+',')>0 and
AdType={0} and (State=1 or (State=0 and getdate()>=BeginTime and EndTime>getdate()))", adtype, deviceType);
}
else
{
strsql = string.Format(@"select * from [dbo].[Advertisement] where charindex(',{2},',','+[where]+',')>0
and charindex(',{0},',','+[Location]+',')>0 and AdType={1} and (State=1 or (State=0 and getdate()>=BeginTime and EndTime>getdate()))", location, adtype, deviceType);
}
list = Util.ReaderToList <Advertisement>(strsql);
if (list != null)
{
// CacheHelper.WriteCache(memKey, list);
CacheHelper.AddCache(memKey, list);
}
}
if (list != null)
{
string cityId = Tool.GetCityIdByCityandIp(city, reqIp);
var resDto = list.Select(x => new AdvertisementResDto()
{
Title = x.Title,
CommentsNumber = x.CommentsNumber,
Company = x.Company,
Layer = x.Layer,
ThumbStyle = x.ThumbStyle,
TransferUrl = x.TransferUrl,
ThumbList = GetAdvertisementPictures(x.ThumbStyle, x.Id),
SubTime = x.SubTime,
Display = IsShow(cityId, x.RestrictedAreas)
}).ToList();
return(new ApiResult <List <AdvertisementResDto> >()
{
Data = resDto
});
}
return(new ApiResult <List <AdvertisementResDto> >());
}
public static List <Models.ExamPlace> GetExamPlaces()
{
if (!Utility.CacheHelper.IsExistCache("ExamPlaces"))
{
var result = EnterRepository.GetRepositoryEnter().ExamPlaceRepository.LoadEntities().ToList().ToList();
CacheHelper.AddCache("ExamPlaces", result, 1);
return(result);
}
return(CacheHelper.GetCache("ExamPlaces") as List <Models.ExamPlace>);
}
private void SaveReadCount(system_msg_record smr)
{
if (System_msg_recordService.EditEntity(smr))
{
var sysmsg_list = System_msg_recordService.LoadEntities(n => n.del_flag == (int)Del_flag.正常).ToList();
if (sysmsg_list.Any())
{
CacheHelper.AddCache("sysmsg_list", sysmsg_list, DateTime.Now.AddMinutes(5));
}
}
}
public void RedisReadWriteTest()
{
for (int i = 0; i < 100000; i++)
{
string key = "redis_test_key_" + i;
CacheHelper.AddCache(key, "qwertyuiopasdfghjklzxcvbnm_" + i);
var data = CacheHelper.GetCache <string>(key);
Console.WriteLine("第{0}项->key:{1},value:{2}", i, key, data);
}
}
/// <summary>
/// 产品缓存
/// </summary>
/// <param name="name">The name.</param>
/// <returns></returns>
private List <product> ProductCache(string name)
{
if (!(CacheHelper.GetCache(name) is List <product> product_list) || product_list.Count == 0)
{
product_list = ProductService.LoadEntities(n => n.del_flag == (int)Del_flag.正常).ToList();
if (product_list.Any())
{
CacheHelper.AddCache(name, product_list, DateTime.Now.AddMinutes(2));
}
}
return(product_list);
}
/// <summary>
/// 产品缓存
/// </summary>
/// <param name="name">The name.</param>
/// <returns></returns>
private List <system_msg_record> SystemMsgCache(string name)
{
if (!(CacheHelper.GetCache(name) is List <system_msg_record> sysmsg_list) || sysmsg_list.Count == 0)
{
sysmsg_list = System_msg_recordService.LoadEntities(n => n.del_flag == (int)Del_flag.正常).ToList();
if (sysmsg_list.Any())
{
CacheHelper.AddCache(name, sysmsg_list, DateTime.Now.AddMinutes(5));
}
}
return(sysmsg_list);
}
private List <user_score_record> UsrCache(string name, int id)
{
if (!(CacheHelper.GetCache(name) is List <user_score_record> list) || list.Count == 0)
{
list = User_score_recordService.LoadEntities(n => n.user_id == id).ToList();
if (list.Any())
{
CacheHelper.AddCache(name, list, DateTime.Now.AddMinutes(2));
}
}
return(list);
}
/// <summary>
/// 用户积分记录缓存
/// </summary>
/// <param name="name"></param>
/// <param name="type"></param>
/// <returns></returns>
public List <user_score_record> CacheUserScoreRecord(string name, int type)
{
if (!(CacheHelper.GetCache(name) is List <user_score_record> user_Score_list) || user_Score_list.Count == 0)
{
user_Score_list = User_score_recordService.LoadEntities(n => n.type == type).ToList();
if (user_Score_list.Any())
{
CacheHelper.AddCache(name, user_Score_list, DateTime.Now.AddMinutes(5));
}
}
return(user_Score_list);
}
/// <summary>
///
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public List <user> CacheUser(string name)
{
if (!(CacheHelper.GetCache(name) is List <user> user_list) || user_list.Count == 0)
{
user_list = UserService.LoadEntities(n => true).ToList();
if (user_list.Any())
{
CacheHelper.AddCache(name, user_list, DateTime.Now.AddMinutes(2));
}
}
return(user_list);
}
/// <summary>
/// 获取热门新闻
/// </summary>
/// <param name="count">查询数量</param>
/// <returns></returns>
public ApiResult <List <NewsListResDto> > GetHotNewsList(int count)
{
string cachekey = RedisKeyConst.News_NewsListApi;
List <NewsListResDto> data = CacheHelper.GetCache <List <NewsListResDto> >(cachekey);
if (data == null)
{
//string hotArticlesql = "SELECT TOP " + count + @" [Id],[FullHead],[SortCode],[Thumb],[ReleaseTime],[ThumbStyle],[TypeId],
//(SELECT COUNT(1) FROM[dbo].[Comment] WHERE [ArticleId]=a.Id and RefCommentId=0) as CommentCount
//FROM [dbo].[News] a
//WHERE DeleteMark=0 AND EnabledMark=1
//ORDER BY CommentCount DESC,SortCode ASC ";
string hotArticlesql = @"select top " + count + @" n.Id,n.FullHead,n.SortCode,n.Thumb,n.ReleaseTime,n.ThumbStyle ,TypeId,
count(c.id) as CommentCount
from News n
left join Comment c on n.id = c.ArticleId and RefCommentId = 0
where n.id in(
select max(n.Id) from News n
join newsType nt on n.TypeId = nt.Id
where nt.lType in (1,2,3,4,6) and nt.SortCode = 1 and n.DeleteMark=0 and n.EnabledMark = 1
group by nt.lType
)
group by n.Id,n.FullHead,n.SortCode,n.Thumb,n.ReleaseTime,n.ThumbStyle,TypeId";
var list = Util.ReaderToList <News>(hotArticlesql);
//int sourceType = (int)ResourceTypeEnum.新闻缩略图;
data = list.Select(x => new NewsListResDto()
{
Id = x.Id,
ParentId = x.ParentId,
CommentCount = x.CommentCount,
ReleaseTime = x.ReleaseTime,
SortCode = x.SortCode,
ThumbStyle = x.ThumbStyle,
Title = x.FullHead,
TypeId = x.TypeId,
//ThumbList = sourceService.GetResources(sourceType, x.Id)
// .Select(n => n.RPath).ToList()
ThumbList = new List <string>()
}).ToList();
//新闻缓存2小时
CacheHelper.AddCache <List <NewsListResDto> >(cachekey, data, 2 * 60);
}
return(new ApiResult <List <NewsListResDto> >()
{
Data = data
});
}
public ActionResult TotalVideo()
{
IList <TopicModel> modelCache = CacheHelper.GetCacheBy(Const.HOME_TOTALVIDEO) as IList <TopicModel>;
if (modelCache != null)
{
return(View(modelCache));
}
IList <TopicModel> totalVideo = _service.GetTopicTotalVideo();
CacheHelper.AddCache(Const.HOME_TOTALVIDEO, totalVideo);
return(View(totalVideo));
}
