public List <WishList> GetWishReport(GetReportDataParams param, out int totalCount)
{
DataSet ds = MSSqlHelper.GetReportData("WishList", param, XMLID.Admin, out totalCount);
var dt = ds.Tables[0];
if (dt == null)
{
return(new List <WishList>());
}
var article = (from l in dt.AsEnumerable()
select new WishList
{
ID = l.Field <int>("ID"),
Count = l.Field <int>("Count"),
DateStart = l.Field <DateTime?>("DateStart"),
Name = l.Field <string>("Name"),
Title = l.Field <string>("Title"),
Support = l.Field <int>("Support"),
StatusID = l.Field <int>("Status"),
UserName = l.Field <string>("AddUser"),
ApplyUser = l.Field <string>("ApplyUser"),
UserID = l.Field <int>("UserID"),
ApplyUserID = l.Field <int>("ApplyUserID"),
PictureFile = l.Field <string>("PictureFile"),
}).ToList();
article.ForEach(m => m.Status = GetStatusName(m.StatusID));
return(article);
}
public List <ColumnList> GetColumnList(GetReportDataParams param, out int totalCount)
{
DataSet ds = MSSqlHelper.GetReportData("ColumnList", param, out totalCount);
var dt = ds.Tables[0];
if (dt == null)
{
return(new List <ColumnList>());
}
var article = (from l in dt.AsEnumerable()
select new ColumnList
{
ColumuName = l.Field <string>("ColumnName"),
ID = l.Field <int>("ID"),
IsPublic = l.Field <string>("IsPublic"),
AdminListUrl = l.Field <string>("AdminListUrl"),
ContentTemplateID = l.Field <int>("ContentTemplateID"),
ParentID = l.Field <int?>("ParentID"),
SortOrder = l.Field <int>("SortOrder"),
UpdateDate = l.Field <DateTime>("UpdateDate"),
UpdateUser = l.Field <string>("UserName"),
}).ToList();
return(article);
}
public List <User> GetUserList(GetReportDataParams param, out int totalCount)
{
DataSet ds = MSSqlHelper.GetReportData("UserList", param, XMLID.Admin, out totalCount);
var dt = ds.Tables[0];
if (dt == null)
{
return(new List <User>());
}
var list = (from l in dt.AsEnumerable()
select new User
{
ID = l.Field <int>("ID"),
//Count = l.Field<int>("Count"),
DateStart = l.Field <DateTime>("DateStart"),
//DateEnd = l.Field<DateTime?>("DateEnd"),
Description = l.Field <string>("Description"),
Support = l.Field <int>("Support"),
Phone = l.Field <string>("Phone"),
HeadPicture = l.Field <string>("HeadPicture"),
UserName = l.Field <string>("UserName"),
LastLoginDate = l.Field <DateTime>("LastLoginDate"),
Heart = l.Field <int>("Heart")
}).ToList();
return(list);
}
public List <ArticleList> GetArticleList(GetReportDataParams param, out int totalCount)
{
DataSet ds = MSSqlHelper.GetReportData("ArticleList", param, out totalCount);
var dt = ds.Tables[0];
if (dt == null)
{
return(new List <ArticleList>());
}
List <ArticleList> article = (from l in dt.AsEnumerable()
select new ArticleList
{
ID = l.Field <int>("ID"),
ColumnName = l.Field <string>("ColumnName"),
PageVisits = l.Field <int>("PageVisits"),
UpdateTime = l.Field <DateTime>("UpdateTime"),
UpdateUser = l.Field <string>("UpdateUser"),
ShortTitle = l.Field <string>("ShortTitle"),
SortOrder = l.Field <int>("SortOrder"),
Title = l.Field <string>("Title")
}).ToList();
return(article.ToList());
}
/// <summary>
/// 课程列表
/// </summary>
/// <param name="param"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public List <CourseEntity> GetCourseReport(GetReportDataParams param, out int totalCount)
{
DataSet ds = MSSqlHelper.GetReportData("CourseList", param, out totalCount);
var dt = ds.Tables[0];
if (dt == null)
{
return(new List <CourseEntity>());
}
var article = (from l in dt.AsEnumerable()
select new CourseEntity
{
ID = l.Field <int>("ID"),
AddUserName = l.Field <string>("UserName"),
Contact = l.Field <string>("Contact"),
AddDate = l.Field <DateTime>("AddDate"),
StartDate = l.Field <DateTime?>("StartDate"),
CourseName = l.Field <string>("CourseName"),
Industry = l.Field <string>("Industry"),
CourseType = l.Field <string>("CourseType"),
ApplyCount = l.Field <int?>("ApplyCount"),
State = l.Field <int>("State")
}).ToList();
return(article);
}
public List <DocumentEntity> GetDocumentList(GetReportDataParams param, out int totalCount)
{
DataSet ds = MSSqlHelper.GetReportData("DocumentsList", param, out totalCount);
var dt = ds.Tables[0];
if (dt == null)
{
return(new List <DocumentEntity>());
}
var article = (from l in dt.AsEnumerable()
select new DocumentEntity
{
Content = l.Field <string>("Content"),
ID = l.Field <int>("ID"),
MetaDescription = l.Field <string>("MetaDescription"),
MetaKeywords = l.Field <string>("MetaKeywords"),
Overview = l.Field <string>("Overview"),
PageTitle = l.Field <string>("PageTitle"),
PageVisits = l.Field <int?>("PageVisits"),
Slug = l.Field <string>("Slug"),
Title = l.Field <string>("Title"),
UpdateUser = l.Field <int?>("UpdateUser"),
DateCreated = l.Field <DateTime>("DateCreated"),
UpdateUserName = l.Field <string>("UpdateUserName")
}).ToList();
return(article);
}
public List <UserEntity> GetUserListReport(GetReportDataParams param, out int totalCount)
{
DataSet ds = MSSqlHelper.GetReportData("UserList", param, out totalCount);
var dt = ds.Tables[0];
if (dt == null)
{
return(new List <UserEntity>());
}
var article = (from l in dt.AsEnumerable()
select new UserEntity
{
ID = l.Field <int>("ID"),
DateCreated = l.Field <DateTime>("DateCreated"),
DateLastLogin = l.Field <DateTime>("DateLastLogin"),
IsActive = l.Field <string>("IsActive"),
UserName = l.Field <string>("UserName")
}).ToList();
return(article);
}
public List <ArticleImageEntity> GetArticleImageList(GetReportDataParams param, out int totalCount)
{
DataSet ds = MSSqlHelper.GetReportData("ArticleImageList", param, out totalCount);
var dt = ds.Tables[0];
if (dt == null)
{
return(new List <ArticleImageEntity>());
}
var article = (from l in dt.AsEnumerable()
select new ArticleImageEntity
{
Author = l.Field <string>("Author"),
UpdateUser = l.Field <string>("UserName"),
Title = l.Field <string>("Title"),
Source = l.Field <string>("Source"),
SortOrder = l.Field <int>("SortOrder"),
Slug = l.Field <string>("Slug"),
ShortTitle = l.Field <string>("ShortTitle"),
PageVisits = l.Field <int>("PageVisits"),
PageTitle = l.Field <string>("PageTitle"),
MetaKeywords = l.Field <string>("MetaKeywords"),
MetaDescription = l.Field <string>("MetaDescription"),
DateCreated = l.Field <DateTime>("DateCreated"),
//Content = l.Field<string>("Content"),
//IsDelete = l.IsDelete,
Overview = l.Field <string>("Overview"),
Photo = l.Field <string>("Photo"),
ColumnID = l.Field <int>("ColumnID"),
ID = l.Field <int>("ID")
}).ToList();
//article.ForEach(m => m.Photo =
// _db.Pictures.Where(l => l.TargetID == m.ID && l.Type == PictureType.ArticleImage
// && l.IsDefault == PublicType.Yes).Select(n => n.PictureUrl).FirstOrDefault());
return(article.ToList());
}
public List <SidebarEntity> GetSidebarList(GetReportDataParams param, out int totalCount)
{
DataSet ds = MSSqlHelper.GetReportData("SidebarList", param, out totalCount);
var dt = ds.Tables[0];
if (dt == null)
{
return(new List <SidebarEntity>());
}
var article = (from l in dt.AsEnumerable()
select new SidebarEntity
{
UpdateUser = l.Field <string>("UpdateUser"),
Title = l.Field <string>("Title"),
Type = l.Field <string>("Type"),
UpdateDate = l.Field <DateTime>("UpdateDate"),
ColumnID = l.Field <int>("ColumnID"),
ID = l.Field <int>("ID")
}).ToList();
return(article.ToList());
}
public List <News> GetNewsList(GetReportDataParams param, out int totalCount)
{
DataSet ds = MSSqlHelper.GetReportData("NewsList", param, XMLID.Admin, out totalCount);
var dt = ds.Tables[0];
if (dt == null)
{
return(new List <News>());
}
var article = (from l in dt.AsEnumerable()
select new News
{
ID = l.Field <int>("ID"),
Count = l.Field <int>("Count"),
Title = l.Field <string>("Title"),
Content = l.Field <string>("Content"),
SortOrder = l.Field <int>("SortOrder"),
DateCreated = l.Field <DateTime>("DateCreated")
}).ToList();
return(article);
}
public List <IndustryEntity> GetIndustryListReport(GetReportDataParams param, out int totalCount)
{
DataSet ds = MSSqlHelper.GetReportData("IndustryList", param, out totalCount);
var dt = ds.Tables[0];
if (dt == null)
{
return(new List <IndustryEntity>());
}
var article = (from l in dt.AsEnumerable()
select new IndustryEntity
{
ID = l.Field <int>("ID"),
AddDate = l.Field <DateTime>("AddDate"),
UserID = l.Field <int?>("UserID"),
UserName = l.Field <string>("UserName"),
IndustryName = l.Field <string>("IndustryName"),
Description = l.Field <string>("Description")
}).ToList();
return(article.ToList());
}
/// <summary>
/// 课程类型列表
/// </summary>
/// <param name="param"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public List <CourseTypeEntity> GetCourseTypeReport(GetReportDataParams param, out int totalCount)
{
DataSet ds = MSSqlHelper.GetReportData("CourseTypeList", param, out totalCount);
var dt = ds.Tables[0];
if (dt == null)
{
return(new List <CourseTypeEntity>());
}
var article = (from l in dt.AsEnumerable()
select new CourseTypeEntity
{
ID = l.Field <int>("ID"),
ParentID = l.Field <int>("ParentID"),
AddDate = l.Field <DateTime>("AddDate"),
UserID = l.Field <int>("UserID"),
UserName = l.Field <string>("UserName"),
SortOrder = l.Field <int>("SortOrder"),
TypeName = l.Field <string>("TypeName")
}).ToList();
return(article);
}
