public IEnumerable <ArticleDTO> GetArticleByType(string MovieType)
{
string str = "SELECT * FROM Article WHERE MovieType=@MovieType ORDER BY LastReplyTime DESC";
IDictionary <string, string> SqlParameter = new Dictionary <string, string>();
SqlParameter.Add("@MovieType", MovieType);
DataTable dt = _coonDB.LoadTable_SQL(str, SqlParameter);
List <ArticleDTO> _ArticleDTO = dt.AsEnumerable()
.Select(x => new ArticleDTO()
{
id = x.Field <int>("id"),
MovieType = x.Field <string>("MovieType"),
Name = x.Field <string>("Name"),
Content = x.Field <string>("Content"),
CreateTime = x.Field <DateTime>("CreateTime"),
Title = x.Field <string>("Title"),
LastReplyTime = x.Field <DateTime>("LastReplyTime"),
YoutubeUrl = x.Field <string>("YoutubeUrl"),
ImagePath = x.Field <string>("ImagePath"),
StrCreateTime = x.Field <DateTime>("CreateTime").ToString("yyyy-MM-dd hh:mm:ss"),
StrLastReplyTime = x.Field <DateTime>("LastReplyTime").ToString("yyyy-MM-dd hh:mm:ss"),
}).ToList();
return(_ArticleDTO);
}
public UserDTO GetUser(LoginDTO loginDTO)
{
if (string.IsNullOrEmpty(loginDTO.Account) || string.IsNullOrEmpty(loginDTO.Password))
{
return(null);
}
loginDTO.Password = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(loginDTO.Password + "ABCD", "sha1");
string sqlstr = "SELECT * FROM [dbo].[User] where Account=@Account and Password=@Password";
IDictionary <string, string> SqlParameter = new Dictionary <string, string>();
SqlParameter.Add("@Account", loginDTO.Account);
SqlParameter.Add("@Password", loginDTO.Password);
DataTable dt = _coonDB.LoadTable_SQL(sqlstr, SqlParameter);
UserDTO userDTO = dt.AsEnumerable()
.Select(x => new UserDTO()
{
Account = x.Field <string>("Account"),
Authority = x.Field <byte>("Authority"),
Name = x.Field <string>("Name"),
Email = x.Field <string>("Email"),
Phone = x.Field <string>("Phone"),
Birthday = x.Field <DateTime>("Birthday"),
Status = x.Field <byte>("Status")
}).SingleOrDefault();
return(userDTO);
}
public IEnumerable <HotLinkDTO> GetHotSrc(List <string> listHotSortNum)
{
string sqlstr = "SELECT 'linkbtn'+Convert(VARCHAR,Sort) AS Sort,title,src FROM HotLink WHERE Sort BETWEEN @MIN AND @MAX ";
IDictionary <string, string> SqlParameter = new Dictionary <string, string>();
SqlParameter.Add("@MIN", listHotSortNum[0]);
SqlParameter.Add("@MAX", listHotSortNum[1]);
DataTable dt = _coonDB.LoadTable_SQL(sqlstr, SqlParameter);
IEnumerable <HotLinkDTO> _hotLinkDTO = dt.AsEnumerable().Select(x => new HotLinkDTO()
{
Sort = x.Field <string>("Sort"),
title = x.Field <string>("title"),
src = x.Field <string>("src"),
});
return(_hotLinkDTO);
}
