/// <summary> /// 返回每日箴言 /// </summary> /// <returns></returns> public string Tips() { string sqlwhere = ""; string order = ""; sqlwhere = " Time_Update>='" + FormatTime(System.DateTime.Now.Date) + "' and Time_Update<'" + FormatTime(System.DateTime.Now.Date.AddDays(1)) + "'"; if (LB.DataAccess.BaseUtils.BaseUtilsInstance.DBType == "sqlserver") { order = "newid()"; } else if (LB.DataAccess.BaseUtils.BaseUtilsInstance.DBType == "access") { order = "id desc"; } else if (LB.DataAccess.BaseUtils.BaseUtilsInstance.DBType == "mysql") { order = "rand()"; } Lebi_Tips tips = B_Lebi_Tips.GetModel(sqlwhere); if (tips != null) { return(Lang(tips.Content)); } else { List <Lebi_Tips> tipslist = B_Lebi_Tips.GetList("", order); tips = tipslist.FirstOrDefault(); if (tips == null) { tips = new Lebi_Tips(); } else { tips.Time_Update = System.DateTime.Now; B_Lebi_Tips.Update(tips); return(Lang(tips.Content)); } } return(""); }
/// <summary> /// 返回每日箴言 /// </summary> /// <returns></returns> public string Tips() { string sqlwhere = ""; string order = ""; if (DataBase.DBType == "sqlserver") { sqlwhere = " datediff(d,Time_Update,'" + FormatTime(System.DateTime.Now) + "')=0"; order = "newid()"; } if (DataBase.DBType == "access") { sqlwhere = " datediff('d',Time_Update,'" + FormatTime(System.DateTime.Now) + "')=0"; order = "id desc"; } Lebi_Tips tips = B_Lebi_Tips.GetModel(sqlwhere); if (tips != null) { return(Lang(tips.Content)); } else { List <Lebi_Tips> tipslist = B_Lebi_Tips.GetList("", order); tips = tipslist.FirstOrDefault(); if (tips == null) { tips = new Lebi_Tips(); } else { tips.Time_Update = System.DateTime.Now; B_Lebi_Tips.Update(tips); return(Lang(tips.Content)); } } return(""); }