private string GetRecommend()
{
string sDiv = string.Empty;
int iDescLength = 108;
DataTable dt = new DAL.CategoryDAL().GetRecommendZT(sCategoryPath, iYIndex + 1);
for (int i = 0; i < dt.Rows.Count; i++)
{
DataTable dtArticle = new DAL.Article().GetArticleList(dt.Rows[i]["CategoryGUID"].ToString(), false, 4);
string sTitle = dt.Rows[i]["CategoryName"].ToString();
string sContent = new DAL.CategoryDAL().GetZTSummaryFromTitle(sZTSummaryAlias, sTitle);
sContent = DAL.Article.RemoveHtml(sContent);
string sDesc = sContent;
if (sContent.Length > iDescLength)
{
sContent = sContent.Substring(0, iDescLength);
sDesc = sDesc.Remove(0, iDescLength);
if (sDesc.StartsWith(">"))
{
sDesc.Remove(0, 1);
}
}
else
{
sDesc = string.Empty;
}
sDiv += "<div class=\"SpecialAttentionLeftCommendItem\">";
sDiv += "<div class=\"SpecialAttentionNewLeft\">";
sDiv += string.Format("<a href=\"SpecialAttentionLite.aspx?ID={0}&Title={1}\" title=\"{2}\" target=\"_blank\">", dt.Rows[i]["CategoryGUID"].ToString(), HttpUtility.UrlEncode(sTitle), sTitle);
sDiv += "<img width=\"158\" height=\"118\" src=\"ShowZTImage.aspx?Title=" + HttpUtility.UrlEncode(sTitle) + "\" alt=\"\" border=\"0\" /></a>";
sDiv += "</div>";
sDiv += "<div class=\"SpecialAttentionNewRightL\">";
sDiv += "<div class=\"SpecialAttentionNewTitleL\">";
sDiv += string.Format("<a href=\"SpecialAttentionLite.aspx?ID={0}&Title={1}\" target=\"_blank\">{2}</a></div>", dt.Rows[i]["CategoryGUID"].ToString(), HttpUtility.UrlEncode(sTitle), sTitle);
sDiv += string.Format("<div class=\"ZTSummary\" data-tooltip=\"{0}\" data-placement=\"bottom\">", string.IsNullOrEmpty(sDesc) ? string.Empty : string.Format("<div class='divTooltip'>{0}</div>", sDesc));
sDiv += string.Format("<a href=\"SpecialAttentionLite.aspx?ID={0}&Title={1}\" target=\"_blank\">", dt.Rows[i]["CategoryGUID"].ToString(), HttpUtility.UrlEncode(sTitle)) + sContent + "</a>";
sDiv += "</div><table class=\"SpecialAttentionNewTableL\" style=\"table-layout:fixed;\" width=\"465\">";
if (dtArticle.Rows.Count > 0)
{
for (int j = 0; j < dtArticle.Rows.Count; j++)
{
if (j % 2 == 0)
{
sDiv += "<tr>";
}
sDiv += "<td class=\"SpecialAttentionNewTableTitleL\" style=\"overflow:hidden;text-overflow:ellipsis;white-space:nowrap;\" width=\"48%\">";
sDiv += string.Format("<a href=\"ShowVideo.aspx?ID={0}\" title=\"{1}\" target=\"_blank\">{1}</a></td>", dtArticle.Rows[j]["ArticleGUID"].ToString(), dtArticle.Rows[j]["Title"].ToString());
if (j % 2 == 1)
{
sDiv += "</tr>";
}
}
}
sDiv += "</table></div></div>";
}
return(sDiv);
}
// Map DAL.Article object to WebArticle object
public static WebArticle MapArticle(DAL.Article article)
{
try
{
if (article == null)
{
return(null);
}
WebArticle art = new WebArticle()
{
Title = article.Title,
Description = article.Description,
Url = article.Url,
UrlToImage = article.UrlToImage,
ID = article.ID
};
return(art);
}
catch (Exception ex)
{
logger.Error(ex, "Attempt to map DAL.Article " + article.ID + " to WebArticle failed: " + ex.Message);
return(null);
}
}
// 绑定技能、培训课件ListView(嵌套)
protected void TabIndex1Box_ItemDataBound(object sender, ListViewItemEventArgs e)
{
Label CategoryAliasLabel = (Label)e.Item.FindControl("SkillCategoryAlias");
string CategoryAlias = CategoryAliasLabel.Text.ToString();
DataTable ListDataTable = new DataTable();
string CategoryGUID = DataQuery.CategoryAliasToID(CategoryAlias);
//ListDataTable = new DAL.Article().GetArticleListAll(CategoryGUID, false, "desc" , true, 16); //ALL
ListDataTable = new DAL.Article().GetArticleList(CategoryGUID, false, 16);
if (ListDataTable.Rows.Count > 0)
{
var ListInfo = from row in ListDataTable.AsEnumerable()
select row;
var LeftInfoSrc = ListInfo.Take(8);
var RightInfoSrc = ListInfo.Skip(8).Take(8);
DataTable LeftInfo = LeftInfoSrc.CopyToDataTable <DataRow>();
ListView SkillListLeft = (ListView)e.Item.FindControl("TabUlLeft");
SkillListLeft.DataSource = LeftInfo;
SkillListLeft.DataBind();
if (ListDataTable.Rows.Count > 8)
{
DataTable RightInfo = RightInfoSrc.CopyToDataTable <DataRow>();
ListView SkillListRight = (ListView)e.Item.FindControl("TabUlRight");
SkillListRight.DataSource = RightInfo;
SkillListRight.DataBind();
}
}
}
// _修改:课件 前N条 从栏目别名
public static DataTable GetArticleListFromAlias(string CategoryAlias, bool NeedSummary, string sSort, int iStartRow, int iEndRow)
{
string sCategoryGUID = CategoryAliasToID(CategoryAlias);
DataTable dt = new DAL.Article().GetArticleList(sCategoryGUID, NeedSummary, sSort, false);
if (dt.Rows.Count > 0)
{
if (iEndRow != 0)
{
DataTable dtRS = dt.Clone();
if (dt.Rows.Count <= iEndRow)
{
iEndRow = dt.Rows.Count;
}
for (int i = iStartRow; i < iEndRow;)
{
dtRS.ImportRow(dt.Rows[i]);
i++;
}
return(dtRS);
}
else
{
return(dt);
}
}
else
{
return(null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Login OP
string sTokenEx = "";
if (this.Context.Request.Cookies["USSUserID"] == null)
{
this.Context.Response.Redirect("index.aspx?showlogin=1");
}
else
{
sTokenEx = this.Context.Request.Cookies["USSToken"].Value + "@" + this.Context.Request.UserHostAddress;
try
{
DLLUserService.User USSUser = new DLLUserService.User();
USSUser.Authenticate(sTokenEx, 0);
}
catch (Exception ex)
{
Context.Response.Redirect("index.aspx");
}
}
//Login ED
if (string.IsNullOrEmpty(Request.QueryString["ID"]))
{
return;
}
string sArticleGUID = Request.QueryString["ID"];
string indexPath = new DAL.Article().GetArticlePath(sArticleGUID);
string strFilePath = System.Configuration.ConfigurationManager.AppSettings["FileRootPath"];
string[] pathList = strFilePath.Split('|');
for (int i = 0; i < pathList.Length; i++)
{
if (string.IsNullOrEmpty(pathList[i]))
{
continue;
}
string sPath = pathList[i];
if (!sPath.EndsWith("\\"))
{
sPath = sPath + "\\";
}
if (File.Exists(sPath.Split(',')[1] + indexPath))
{
indexPath = sPath.Split(',')[0] + "/" + indexPath;
break;
}
}
if (string.IsNullOrEmpty(indexPath))
{
vframe.InnerHtml = "很抱歉，视频文件不存在！";
}
else
{
this.VideoShowFrame.Attributes["src"] = indexPath;
//Response.Redirect(indexPath);
}
}
protected void Page_Init(object sender, EventArgs e)
{
url = "http://" + Request.Url.Authority + Request.ApplicationPath + "/";
//热门关键词
string sHotKey_Alias = ConfigurationManager.AppSettings["HotKeyAlias"];
divHotKey.InnerHtml = new DAL.CategoryDAL().GetHotKeyLite(sHotKey_Alias);
//导航
string VoidGuid = ConfigurationManager.AppSettings["Void_Guid"];
string VersionMark = ConfigurationManager.AppSettings["Version_Mark"];
DataTable NaviListData = DataQuery.GetNaviCategories(VoidGuid, "10", VersionMark);
//TopNaviList.DataSource = NaviListData;
//TopNaviList.DataBind();
string ChannelAlias = null;
string ChannelTitle = null;
try
{
ChannelAlias = Request.QueryString["alias"].ToString();
}
catch
{
ChannelAlias = "gxchannel1";
}
ChannelTitle = DataQuery.GetNameByCategoryAlias(ChannelAlias);
// 导视
String GuideAlias = DataQuery.GetChannelAliasByName(ChannelAlias, "导视");
String GuideGuid = DataQuery.CategoryAliasToID(GuideAlias);
DataTable GuideCourses = new DAL.Article().GetArticleList(GuideGuid, true, 5);
//Remove Html
SlideShowPic.DataSource = GuideCourses;
SlideShowPic.DataBind();
SlideShowText.DataSource = GuideCourses;
SlideShowText.DataBind();
// 图片
Level2Title.ImageUrl = "../images/" + ChannelAlias + ".png";
//预告
String TrailerAlias = ConfigurationManager.AppSettings["ChannelTrailer"];
string EnCodeChannelTitle = HttpUtility.UrlEncode(ChannelTitle, Encoding.GetEncoding("utf-8"));
PreviewPic.ImageUrl = "../ShowBytePic.aspx?Title=" + EnCodeChannelTitle + "&Alias=" + TrailerAlias;
String TrailerText = DataQuery.GetTrailerText(TrailerAlias, ChannelTitle);
if (TrailerText != null)
{
TrailerText = TrailerText.Replace("；", ";");
string[] TrailerInfo = TrailerText.Split(';');
PreviewTitle.Text = DataProcessing.SubstringText(TrailerInfo[0], 10);
PreviewTitle.ToolTip = TrailerInfo[0].ToString();
PreviewSpeaker.Text = TrailerInfo[1];
PreviewSpeakerInfo.Text = DataProcessing.SubstringText(TrailerInfo[2], 10);
PreviewSpeakerInfo.ToolTip = TrailerInfo[2].ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
url = "http://" + Request.Url.Authority + Request.ApplicationPath + "/";
string ChannelAlias = Request.QueryString["alias"].ToString();
string ChannelTitle = DataQuery.GetNameByCategoryAlias(ChannelAlias);
// 推荐
String CommendAlias = DataQuery.GetChannelAliasByName(ChannelAlias, "推荐");
string CommendGuid = DataQuery.CategoryAliasToID(CommendAlias);
DataTable CommendCourses = new DAL.Article().GetArticleList(CommendGuid, false, 12);
CommendList.DataSource = CommendCourses;
CommendList.DataBind();
//排行
//DataTable HotListDataSrc = DataQuery.GetHotList();
//HotList.DataSource = HotListDataSrc;
//HotList.DataBind();
// 主列表
String CategoryLv2Alias = DataQuery.GetChannelAliasByName(ChannelAlias, "栏目");
string Version = ConfigurationManager.AppSettings["Version_Mark"];
DataTable GetSubCategories = DataQuery.GetSubCategoriesApart(CategoryLv2Alias, Version);
Level2MainRight.DataSource = GetSubCategories;
Level2MainRight.DataBind();
Image Level2MainBanner = (Image)FindControl <Image>("Level2MainBanner");
Level2MainBanner.ImageUrl = "images/AD" + ChannelAlias + ".gif";
//LeftPic
LeftPicAliasText = ConfigurationManager.AppSettings["ChannelPicCategory"];
LeftPicLv2AliasText = DataQuery.GetChannelAliasByName(LeftPicAliasText, ChannelTitle);
Level2LeftPicBot.ImageUrl = "ShowBytePic.aspx?Title=底部图片&Alias=" + LeftPicLv2AliasText;
int LeftPicCount = (GetSubCategories.Rows.Count - 6) / 2;
String LeftPicAlias = DataQuery.GetChannelAliasByName(ChannelAlias, "图片专题");
DataTable LeftPicGetSubCategories = DataQuery.GetSubCategories(LeftPicAlias, LeftPicCount.ToString());
LeftPicList.DataSource = LeftPicGetSubCategories;
LeftPicList.DataBind();
//Level2LeftPic1.ImageUrl = "images/" + ChannelAlias + "_1.jpg";
//int SubCategoriesCount = GetSubCategories.Rows.Count;
//if (SubCategoriesCount >= 10)
//{
// Level2LeftPic2.Visible = true;
// Level2LeftPic2.ImageUrl = "images/" + ChannelAlias + "_2.jpg";
//}
//if (SubCategoriesCount >= 12)
//{
// Level2LeftPic3.Visible = true;
// Level2LeftPic3.ImageUrl = "images/" + ChannelAlias + "_3.jpg";
//}
//if (SubCategoriesCount >= 14)
//{
// Level2LeftPic4.Visible = true;
// Level2LeftPic4.ImageUrl = "images/" + ChannelAlias + "_4.jpg";
//}
}
public HomeChannelListBS(string Alias, int PicNumber)
{
string guid = DataQuery.CategoryAliasToID(Alias);
DataTable ListTable = new DAL.Article().GetArticleList(guid, false, PicNumber);
if (ListTable.Rows.Count > 0)
{
var ListInfo = from row in ListTable.AsEnumerable()
select row;
var PicInfoSrc = ListInfo.Take(PicNumber);
PicInfo = PicInfoSrc.CopyToDataTable <DataRow>();
}
}
protected void TrainList_ItemDataBound(object sender, ListViewItemEventArgs e)
{
Label CategoryAliasLabel = (Label)e.Item.FindControl("TrainCategoryAlias");
string CategoryAlias = CategoryAliasLabel.Text.ToString();
DataTable ListDataTable = new DataTable();
string CategoryGUID = DataQuery.CategoryAliasToID(CategoryAlias);
ListDataTable = new DAL.Article().GetArticleList(CategoryGUID, false, 4);
ListView SkillListCourse = (ListView)e.Item.FindControl("TrainListCourse");
SkillListCourse.DataSource = ListDataTable;
SkillListCourse.DataBind();
}
private string GetLastNew()
{
int iDescLength = 110;
DataTable dt = new DAL.CategoryDAL().GetLastNewZT(sCategoryPath, iYIndex + 1);
if (dt == null || dt.Rows.Count == 0)
{
return(string.Empty);
}
DataTable dtArticle = new DAL.Article().GetArticleList(dt.Rows[0]["CategoryGUID"].ToString(), false, 3);
string sTitle = dt.Rows[0]["CategoryName"].ToString();
string sContent = new DAL.CategoryDAL().GetZTSummaryFromTitle(sZTSummaryAlias, sTitle);
sContent = DAL.Article.RemoveHtml(sContent);
string sDesc = sContent;
if (sContent.Length > iDescLength)
{
sContent = sContent.Replace(" ", "");//*CC*
sContent = sContent.Substring(0, iDescLength);
sDesc = sDesc.Remove(0, iDescLength);
if (sDesc.StartsWith(">"))
{
sDesc.Remove(0, 1);
}
}
string sDiv = "<div class=\"SpecialAttentionNewLeft\">";
sDiv += string.Format("<a href=\"SpecialAttentionLite.aspx?ID={0}&Title={1}\" title=\"{2}\" target=\"_blank\">", dt.Rows[0]["CategoryGUID"].ToString(), HttpUtility.UrlEncode(sTitle), sTitle);
sDiv += "<img width=\"276\" height=\"195\" src=\"ShowZTImage.aspx?Title=" + HttpUtility.UrlEncode(sTitle) + "\" alt=\"\" border=\"0\" /></a>";
sDiv += "</div><div class=\"SpecialAttentionNewRight\"><div class=\"SpecialAttentionNewTitle\">";
sDiv += string.Format("<a href=\"SpecialAttentionLite.aspx?ID={0}&Title={1}\" target=\"_blank\">{2}</a>", dt.Rows[0]["CategoryGUID"].ToString(), HttpUtility.UrlEncode(sTitle), DataProcessing.SubstringText(sTitle, 19)); //*CC*
sDiv += "</div>";
sDiv += string.Format("<div class=\"ZTSummary\" data-tooltip=\"{0}\" data-placement=\"bottom\">", string.IsNullOrEmpty(sDesc) ? string.Empty : string.Format("<div class='divTooltip'>{0}</div>", sDesc));
sDiv += string.Format("<a href=\"SpecialAttentionLite.aspx?ID={0}&Title={1}\" target=\"_blank\">", dt.Rows[0]["CategoryGUID"].ToString(), HttpUtility.UrlEncode(sTitle)) + sContent + "</a>";
sDiv += "</div><table class=\"SpecialAttentionNewTable\" style=\"table-layout:fixed;\" width=\"355\">";
if (dtArticle.Rows.Count > 0)
{
for (int i = 0; i < dtArticle.Rows.Count; i++)
{
sDiv += "<tr><td class=\"SpecialAttentionNewTableTitle SpecialAttentionNewTableTitleZTTop\" style=\"overflow:hidden;text-overflow:ellipsis;white-space:nowrap;\">";
sDiv += string.Format("<a href=\"ShowVideo.aspx?ID={0}\" title=\"{1}\" target=\"_blank\">{2}</a></td>", dtArticle.Rows[i]["ArticleGUID"].ToString(), dtArticle.Rows[i]["Title"].ToString(), DataProcessing.SubstringText(dtArticle.Rows[i]["Title"].ToString(), 18));//*CC*
sDiv += "<td align=\"right\">" + DateTime.Parse(dtArticle.Rows[i]["CreateTime"].ToString()).ToString("yyyy-MM-dd") + "</td></tr>";
}
}
sDiv += "</table></div>";
return(sDiv);
}
// _修改:课件 从栏目别名
public static DataTable GetArticleListFromAlias(string CategoryAlias, bool NeedSummary, string sSort)
{
string sCategoryGUID = CategoryAliasToID(CategoryAlias);
DataTable dt = new DAL.Article().GetArticleList(sCategoryGUID, NeedSummary, sSort, false);
if (dt.Rows.Count > 0)
{
return(dt);
}
else
{
return(null);
}
}
private string GetAreaJson(string sLikeWords)
{
string sStr = string.Empty;
try
{
DataTable dt = new DAL.Article().GetList("Area", string.Format("Area<>'' {0}", string.IsNullOrEmpty(sLikeWords) ? string.Empty : string.Format(" and Area like '%{0}%' order by Area", sLikeWords)));
foreach (DataRow dr in dt.Rows)
{
sStr += ",{" + string.Format("Area:\"{0}\"", dr["Area"]) + "}";
}
}
catch { sStr = string.Empty; }
return(string.Format("[{0}]", string.IsNullOrEmpty(sStr) ? string.Empty : sStr.Substring(1)));
}
public string GetUrl(string sArticleGUID, out string PicPath)
{
string indexPath = new DAL.Article().GetArticlePath(sArticleGUID);
string CourseID = indexPath.Split('/')[0];
string[] pathList = { "http://vodedu.cei.com.cn//ccmfile3/", "http://vodedu.cei.com.cn//ccmfile2/", "http://vodedu.cei.com.cn//ccmfile/" };
PicPath = "";
for (int i = 0; i < pathList.Length; i++)
{
if (CheckUri(pathList[i] + indexPath) == true)
{
indexPath = pathList[i] + indexPath;
PicPath = pathList[i] + CourseID + "/355x235.png";
break;
}
}
return(indexPath);
}
protected void Page_Load(object sender, EventArgs e)
{
url = "http://" + Request.Url.Authority + Request.ApplicationPath + "/";
string ChannelAlias = ConfigurationManager.AppSettings["ChannelFame"];
string ChannelTitle = DataQuery.GetNameByCategoryAlias(ChannelAlias);
//LeftList1
string Lv2FameLeftListAlias = DataQuery.GetChannelAliasByName(ChannelAlias, "名家谈时事");
Lv2FameLeftLink1.NavigateUrl = "Level3Fame.aspx?alias=" + Lv2FameLeftListAlias + "&IsChild=1";
string Lv2FameLeftListGuid = DataQuery.CategoryAliasToID(Lv2FameLeftListAlias);
DataTable Lv2FameLeftList1Courses = new DAL.Article().GetArticleList(Lv2FameLeftListGuid, false, 3);
Lv2FameLeftList1.DataSource = Lv2FameLeftList1Courses;
Lv2FameLeftList1.DataBind();
//LeftList2
Lv2FameLeftListAlias = DataQuery.GetChannelAliasByName(ChannelAlias, "名家谈管理");
Lv2FameLeftLink2.NavigateUrl = "Level3Fame.aspx?alias=" + Lv2FameLeftListAlias + "&IsChild=1";
string Lv2FameLeftListGuid2 = DataQuery.CategoryAliasToID(Lv2FameLeftListAlias);
DataTable Lv2FameLeftList2Courses = new DAL.Article().GetArticleList(Lv2FameLeftListGuid2, false, 3);
Lv2FameLeftList2.DataSource = Lv2FameLeftList2Courses;
Lv2FameLeftList2.DataBind();
//排行
//DataTable HotListDataSrc = DataQuery.GetHotList();
//HotList.DataSource = HotListDataSrc;
//HotList.DataBind();
//MidList
string Lv2FameMidListAlias = DataQuery.GetChannelAliasByName(ChannelAlias, "名师推荐");
Lv2FameMidLink.NavigateUrl = "Level3Fame.aspx?alias=" + Lv2FameLeftListAlias + "&IsChild=1";
string Lv2FameMidListGuid = DataQuery.CategoryAliasToID(Lv2FameMidListAlias);
DataTable Lv2FameMidListCourses = new DAL.Article().GetArticleList(Lv2FameMidListGuid, true, 5);
Lv2FameMidList.DataSource = Lv2FameMidListCourses;
Lv2FameMidList.DataBind();
//RightList1
string Lv2RightListAlias = DataQuery.GetChannelAliasByName(ChannelAlias, "专家名录");
Lv2FameRightLink1.NavigateUrl = "Level3Fame.aspx?alias=" + Lv2RightListAlias + "&IsChild=0";
DataTable Lv2RightListItems = DataQuery.GetSubCategories(Lv2RightListAlias, "48");
Lv2FameRightList1.DataSource = Lv2RightListItems;
Lv2FameRightList1.DataBind();
}
public CategoryLv2List(string Alias, int PicNumber, int TextNumber)
{
DataTable ListTable = new DataTable();
string Guid = DataQuery.CategoryAliasToID(Alias);
int count = PicNumber + TextNumber;
ListTable = new DAL.Article().GetArticleList(Guid, false, count);
if (ListTable.Rows.Count > 0)
{
var ListInfo = from row in ListTable.AsEnumerable()
select row;
var PicInfoSrc = ListInfo.Take(PicNumber);
PicInfo = PicInfoSrc.CopyToDataTable <DataRow>();
if (TextNumber != 0)
{
var TextInfoLSrc = ListInfo.Skip(PicNumber).Take(TextNumber);
TextInfo = TextInfoLSrc.CopyToDataTable <DataRow>();
}
}
}
public HomeChannelListB(string Alias, int PicNumber, int TextNumber)
{
Alias = DataQuery.GetChannelAliasByName(Alias, "栏目");
DataTable ListTable = new DataTable();
string Guid = DataQuery.CategoryAliasToID(Alias);
ListTable = new DAL.Article().GetArticleList(Guid, false, 11);
if (ListTable.Rows.Count > 0)
{
//PicInfo = from row in ListTable.AsEnumerable() where Convert.ToInt32(row["_RowNumber"]) > 0 && Convert.ToInt32(row["_RowNumber]"]) <= 5 select row;
var ListInfo = from row in ListTable.AsEnumerable()
select row;
var PicInfoSrc = ListInfo.Take(PicNumber);
PicInfo = PicInfoSrc.CopyToDataTable <DataRow>();
if (TextNumber != 0)
{
var TextInfoLSrc = ListInfo.Skip(PicNumber).Take(TextNumber);
TextInfo = TextInfoLSrc.CopyToDataTable <DataRow>();
}
}
}
public HomeChannelListA(string Alias)
{
Alias = DataQuery.GetChannelAliasByName(Alias, "栏目");
SubSortTable = DataQuery.GetSubCategories(Alias, "4");
DataTable ListTable = new DataTable();
string Guid = DataQuery.CategoryAliasToID(Alias);
//ListTable = DataQuery.GetArticleIndexList(Guid, "11", "desc");
ListTable = new DAL.Article().GetArticleList(Guid, false, 11);
if (ListTable.Rows.Count > 0)
{
//PicInfo = from row in ListTable.AsEnumerable() where Convert.ToInt32(row["_RowNumber"]) > 0 && Convert.ToInt32(row["_RowNumber]"]) <= 5 select row;
var ListInfo = from row in ListTable.AsEnumerable()
select row;
var PicInfoSrc = ListInfo.Take(5);
var TextInfoLSrc = ListInfo.Skip(5).Take(3);
var TextInfoRSrc = ListInfo.Skip(8).Take(3);
PicInfo = PicInfoSrc.CopyToDataTable <DataRow>();
TextInfoL = TextInfoLSrc.CopyToDataTable <DataRow>();
TextInfoR = TextInfoRSrc.CopyToDataTable <DataRow>();
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
//context.Response.Write("Hello World");
//Request
StreamReader sr = new StreamReader(HttpContext.Current.Request.InputStream);
string strReq = sr.ReadToEnd();
//Test
//JObject Req = new JObject(
// new JProperty("ChannelAlias", "gxchannel1")
// );
//string strReq = Req.ToString();
#region Level2FocusPic
if (HttpContext.Current.Request["method"] == "level2focuspic")
{
string PicPath = "";
JObject o = JObject.Parse(strReq);
string ChannelAlias = (string)o["ChannelAlias"];
String GuideAlias = DataQuery.GetChannelAliasByName(ChannelAlias, "导视");
String GuideGuid = DataQuery.CategoryAliasToID(GuideAlias);
DataTable GuideCourses = new DAL.Article().GetArticleList(GuideGuid, true, 5);
JObject rss = new JObject();
rss = new JObject(
//new JProperty("method", "mytask")
);
JObject JCourse =
new JObject(
new JProperty("Course",
new JArray(
from cc in GuideCourses.AsEnumerable()
orderby cc["XIndexTime"] descending
select new JObject(
//new JProperty("CustomProjectId", oc.CustomProjectId),
//new JProperty("CustomProjectNo", oc.No),
//new JProperty("Title", oc.Title),
//new JProperty("SendingDate", oc.SendingDate.ToString("D")),
//new JProperty("Lecturer", oc.Lecturer),
//new JProperty("ProgressText", oc.ProgressText)
from col in cc.Table.Columns.Cast <DataColumn>()
select new JProperty(
col.ColumnName, cc[col.Ordinal].ToString()
),
new JProperty("Url", GetUrl(cc["ArticleGUID"].ToString(), out PicPath)),
new JProperty("PicPath", PicPath)
)
)
)
);
rss.Merge(JCourse, new JsonMergeSettings
{
MergeArrayHandling = MergeArrayHandling.Concat
}
);
context.Response.Write(rss.ToString());
}
#endregion Level2FocusPic
}
protected void Page_Load(object sender, EventArgs e)
{
url = "http://" + Request.Url.Authority + Request.ApplicationPath + "/";
string ChannelAlias = "";
string ChannelTitle = "";
try
{
ChannelAlias = Request.QueryString["alias"].ToString();
}
catch
{
ChannelAlias = "gxchannel1";
}
ChannelTitle = DataQuery.GetNameByCategoryAlias(ChannelAlias);
// 推荐
String CommendAlias = DataQuery.GetChannelAliasByName(ChannelAlias, "推荐");
string CommendGuid = DataQuery.CategoryAliasToID(CommendAlias);
DataTable CommendCourses = new DAL.Article().GetArticleList(CommendGuid, false, 12);
CommendList.DataSource = CommendCourses;
CommendList.DataBind();
//排行
//DataTable HotListDataSrc = DataQuery.GetHotList();
//HotList.DataSource = HotListDataSrc;
//HotList.DataBind();
// 主列表
String CategoryLv2Alias = DataQuery.GetChannelAliasByName(ChannelAlias, "栏目");
string Version = ConfigurationManager.AppSettings["Version_Mark"];
DataTable GetSubCategories = DataQuery.GetSubCategoriesApart(CategoryLv2Alias, Version);
// Level2MainRight.DataSource = GetSubCategories;
// Level2MainRight.DataBind();
// Image Level2MainBanner = (Image)FindControl<Image>("Level2MainBanner");
//Level2MainBanner.ImageUrl = "images/AD" + ChannelAlias + ".gif";
//LeftPic
LeftPicAliasText = ConfigurationManager.AppSettings["ChannelPicCategory"];
LeftPicLv2AliasText = DataQuery.GetChannelAliasByName(LeftPicAliasText, ChannelTitle);
//Level2LeftPicBot.ImageUrl = "ShowBytePic.aspx?Title=底部图片&Alias=" + LeftPicLv2AliasText;
//int LeftPicCount = (GetSubCategories.Rows.Count - 6) / 2;
int LeftPicCount = 1;
String LeftPicAlias = DataQuery.GetChannelAliasByName(ChannelAlias, "图片专题");
DataTable LeftPicGetSubCategories = DataQuery.GetSubCategories(LeftPicAlias, LeftPicCount.ToString());
LeftPicList.DataSource = LeftPicGetSubCategories;
LeftPicList.DataBind();
//Level2LeftPic1.ImageUrl = "images/" + ChannelAlias + "_1.jpg";
//int SubCategoriesCount = GetSubCategories.Rows.Count;
//if (SubCategoriesCount >= 10)
//{
// Level2LeftPic2.Visible = true;
// Level2LeftPic2.ImageUrl = "images/" + ChannelAlias + "_2.jpg";
//}
//if (SubCategoriesCount >= 12)
//{
// Level2LeftPic3.Visible = true;
// Level2LeftPic3.ImageUrl = "images/" + ChannelAlias + "_3.jpg";
//}
//if (SubCategoriesCount >= 14)
//{
// Level2LeftPic4.Visible = true;
// Level2LeftPic4.ImageUrl = "images/" + ChannelAlias + "_4.jpg";
//}
String CategoryGUID = "";
string TraceText = "";
if (Request.QueryString["id"] == null)
{
CategoryGUID = "1c68f666dc914382b95456acf6be87a5";
}
else
{
CategoryGUID = Request.QueryString["id"].ToString();
}
char[] PathSeparator = { '/' };
string CategoryPath = DataQuery.CategoryPath(CategoryGUID);
string[] CategoryPaths = CategoryPath.Split(PathSeparator);
for (int i = 4; i < CategoryPaths.Length; i++)
{
string title = DataQuery.GetNameByCategoryID(CategoryPaths[i]);
TraceText += title + " / ";
}
Trace.Text = TraceText;
}
protected void Page_Load(object sender, EventArgs e)
{
CacheTest.Text = DateTime.Now.ToString();
url = "http://" + Request.Url.Authority + Request.ApplicationPath + "/";
//图片新闻
// Text
string NewsCommendAlias = ConfigurationManager.AppSettings["NewsCommendAlias"];
DataTable NewsCommendText = new DataTable();
NewsCommendText = DataQuery.GetSubCategories(NewsCommendAlias);
FocusTabsTxt.DataSource = NewsCommendText;
FocusTabsTxt.DataBind();
// Pic
if (NewsCommendText.Rows.Count > 0)
{
DataTable NewsCommendPic = new DataTable();
//NewsCommendPic = new DAL.Article().GetArticleList(NewsCommendText.Rows[0][1].ToString(),false,1); //缓存
NewsCommendPic = DataQuery.ArticleQuery("", "1", NewsCommendText.Rows[0][2].ToString()).Tables[0];
if (NewsCommendPic != null)
{
NewsCommendPic.Columns.Add("FocusTabsIndex", typeof(String));
NewsCommendPic.Rows[0]["FocusTabsIndex"] = NewsCommendText.Rows[0]["XIndex"];
DataTable NewsCommendPicMerge = new DataTable();
for (int i = 1; i < NewsCommendText.Rows.Count; i++)
{
//NewsCommendPicMerge = new DAL.Article().GetArticleList(NewsCommendText.Rows[i][1].ToString(),false,1); //缓存
NewsCommendPicMerge = DataQuery.ArticleQuery("", "1", NewsCommendText.Rows[i][2].ToString()).Tables[0];
NewsCommendPicMerge.Columns.Add("FocusTabsIndex", typeof(String));
NewsCommendPicMerge.Rows[0]["FocusTabsIndex"] = NewsCommendText.Rows[i]["XIndex"];
NewsCommendPic.Merge(NewsCommendPicMerge);
}
FocusTabsPic.DataSource = NewsCommendPic;
FocusTabsPic.DataBind();
}
}
//特别关注
string SubjectGUID = DataQuery.CategoryAliasToID(ConfigurationManager.AppSettings["TBGZ_Alias"]);
string SubjectPath = DataQuery.CategoryPath(SubjectGUID); //专题路径
DataTable HotSubjects = new DataTable();
HotSubjects = DataQuery.GetNHotZT();
// 获取课件
//string SubjectHotGUID = DataQuery.CategoryAliasToID(ConfigurationManager.AppSettings["SAHot_Alias"]);
// string SubjectHotPath = DataQuery.CategoryPath(SubjectGUID);
DataTable HotCoursesMerge = new DataTable();
// 第一个专题
if (HotSubjects.Rows.Count > 0)
{
//string SubjectHotItemPath = SubjectPath + "/" + HotSubjects.Rows[0][0].ToString();
// DataTable HotCourses = new DAL.CategoryDAL().GetArticleIndexList(SubjectHotItemPath, "最新动态", 2, false);
string HotSubjectAlias = DataQuery.CategoryIDToAlias(HotSubjects.Rows[0][0].ToString());
string SubjectNewAlias = DataQuery.GetChannelAliasByName(HotSubjectAlias, "最新动态");
string SubjectNewGuid = DataQuery.CategoryAliasToID(SubjectNewAlias);
DataTable HotCourses = new DAL.Article().GetArticleList(SubjectNewGuid, false, 2);
HotCourses.Columns.Add("SubjectID", Type.GetType("System.String"));
HotCourses.Columns.Add("SubjectTitle", Type.GetType("System.String"));
for (int i = 0; i < HotCourses.Rows.Count; i++)
{
HotCourses.Rows[i]["SubjectID"] = HotSubjects.Rows[0][0].ToString();
HotCourses.Rows[i]["SubjectTitle"] = HotSubjects.Rows[0][1].ToString();
}
// 后N个专题
for (int i = 1; i < HotSubjects.Rows.Count; i++)
{
//SubjectHotItemPath = SubjectPath + "/" + HotSubjects.Rows[i][0].ToString();
//HotCoursesMerge = new DAL.CategoryDAL().GetArticleIndexList(SubjectHotItemPath, "最新动态", 2, false);
HotSubjectAlias = DataQuery.CategoryIDToAlias(HotSubjects.Rows[i][0].ToString());
SubjectNewGuid = DataQuery.GetSubChannelGuidByName(HotSubjectAlias, "最新动态");
HotCoursesMerge = new DAL.Article().GetArticleList(SubjectNewGuid, false, 2);
HotCoursesMerge.Columns.Add("SubjectID", Type.GetType("System.String"));
HotCoursesMerge.Columns.Add("SubjectTitle", Type.GetType("System.String"));
for (int j = 0; j < HotCoursesMerge.Rows.Count; j++)
{
HotCoursesMerge.Rows[j]["SubjectID"] = HotSubjects.Rows[i][0].ToString();
HotCoursesMerge.Rows[j]["SubjectTitle"] = HotSubjects.Rows[i][1].ToString();
}
HotCourses.Merge(HotCoursesMerge);
}
SpecialFocusContent.DataSource = HotCourses;
SpecialFocusContent.DataBind();
}
//热点
ZjspccmEntities DB = new ZjspccmEntities();
var query = (from cn in DB.CategoryNodePositions
join c in DB.Categories
on cn.CategoryGUID equals c.CategoryGUID
where (cn.CategoryPath.Contains("0c46ef80013847acb095bb5c902d08bd")) && (cn.YIndex == 5)
orderby cn.XIndex descending
select new
{
title = c.CategoryName,
id = c.CategoryGUID
}).Take(8);
ListViewHotpoint.DataSource = query.ToList();
ListViewHotpoint.DataBind();
//树
if (!Page.IsPostBack)
{
#region sync
//SeminarTree.ShowLines = true;
//SeminarTree.ShowExpandCollapse = true;
TreeNodeCollection tnc = new TreeNodeCollection();
//tnc = SeminarTree.Nodes;
//tncRecursion(tnc, "2461c3d8f92d451599e054c1fb46fa11");
//TreeNodeCollection tnc2 = new TreeNodeCollection();
//tnc2 = SujectTree.Nodes;
//tncRecursion(tnc2, "50ac3b6925644d269836e0a45e4671b4");
#endregion sync
}
#region async
//SeminarTree.Nodes.Clear();
//Bind_Root("2461c3d8f92d451599e054c1fb46fa11", SeminarTree);
#endregion async
//导航
string NaviList1Alias = ConfigurationManager.AppSettings["subject"];
DataTable NaviList1Items = DataQuery.GetSubCategories(NaviList1Alias, "9");
//NaviList1.DataSource = NaviList1Items;
// NaviList1.DataBind();
string NaviList2Alias = ConfigurationManager.AppSettings["MAJOR"];
DataTable NaviList2Items = DataQuery.GetSubCategories(NaviList2Alias, "9");
//NaviList2.DataSource = NaviList2Items;
// NaviList2.DataBind();
string NaviList3Alias = ConfigurationManager.AppSettings["INSTITUTION"];
DataTable NaviList3Items = DataQuery.GetSubCategories(NaviList3Alias, "9");
// NaviList3.DataSource = NaviList3Items;
// NaviList3.DataBind();
//主列表
string ChannelListAliasA1 = ConfigurationManager.AppSettings["HomeChannelListA_CategoryAlias_1"];
WebModules.HomeChannelListA HomeChannelListA1 = new WebModules.HomeChannelListA(ChannelListAliasA1);
// ColumnShowSort1.DataSource = HomeChannelListA1.SubSortTable;
//ColumnShowSort1.DataBind();
//ColumnVideo1.DataSource = HomeChannelListA1.PicInfo;
// ColumnVideo1.DataBind();
// ColumnOtherL1.DataSource = HomeChannelListA1.TextInfoL;
//ColumnOtherL1.DataBind();
// ColumnOtherR1.DataSource = HomeChannelListA1.TextInfoR;
// ColumnOtherR1.DataBind();
string ChannelListATitle1 = ConfigurationManager.AppSettings["HomeChannelListA_Title_1"];
// ListATitle1.Text = ChannelListATitle1;
// ListALink1.NavigateUrl = "level2.aspx?alias=" + ChannelListAliasA1;
string ChannelListAliasA2 = ConfigurationManager.AppSettings["HomeChannelListA_CategoryAlias_2"];
WebModules.HomeChannelListA HomeChannelListA2 = new WebModules.HomeChannelListA(ChannelListAliasA2);
// ColumnShowSort2.DataSource = HomeChannelListA2.SubSortTable;
// ColumnShowSort2.DataBind();
// ColumnVideo2.DataSource = HomeChannelListA2.PicInfo;
// ColumnVideo2.DataBind();
//ColumnOtherL2.DataSource = HomeChannelListA2.TextInfoL;
// ColumnOtherL2.DataBind();
// ColumnOtherR2.DataSource = HomeChannelListA2.TextInfoR;
// ColumnOtherR2.DataBind();
string ChannelListATitle2 = ConfigurationManager.AppSettings["HomeChannelListA_Title_2"];
// ListATitle2.Text = ChannelListATitle2;
//ListALink2.NavigateUrl = "level2.aspx?alias=" + ChannelListAliasA2;
string ChannelListAliasA3 = ConfigurationManager.AppSettings["HomeChannelListA_CategoryAlias_3"];
WebModules.HomeChannelListA HomeChannelListA3 = new WebModules.HomeChannelListA(ChannelListAliasA3);
// ColumnShowSort3.DataSource = HomeChannelListA3.SubSortTable;
// ColumnShowSort3.DataBind();
// ColumnVideo3.DataSource = HomeChannelListA3.PicInfo;
// ColumnVideo3.DataBind();
// ColumnOtherL3.DataSource = HomeChannelListA3.TextInfoL;
// ColumnOtherL3.DataBind();
// ColumnOtherR3.DataSource = HomeChannelListA3.TextInfoR;
// ColumnOtherR3.DataBind();
string ChannelListATitle3 = ConfigurationManager.AppSettings["HomeChannelListA_Title_3"];
// ListATitle3.Text = ChannelListATitle3;
// ListALink3.NavigateUrl = "level2.aspx?alias=" + ChannelListAliasA3;
string ChannelListAliasA4 = ConfigurationManager.AppSettings["HomeChannelListA_CategoryAlias_4"];
WebModules.HomeChannelListA HomeChannelListA4 = new WebModules.HomeChannelListA(ChannelListAliasA4);
// ColumnShowSort4.DataSource = HomeChannelListA4.SubSortTable;
// ColumnShowSort4.DataBind();
// ColumnVideo4.DataSource = HomeChannelListA4.PicInfo;
// ColumnVideo4.DataBind();
//ColumnOtherL4.DataSource = HomeChannelListA4.TextInfoL;
//ColumnOtherL4.DataBind();
// ColumnOtherR4.DataSource = HomeChannelListA4.TextInfoR;
// ColumnOtherR4.DataBind();
string ChannelListATitle4 = ConfigurationManager.AppSettings["HomeChannelListA_Title_4"];
// ListATitle4.Text = ChannelListATitle4;
// ListALink4.NavigateUrl = "level2.aspx?alias=" + ChannelListAliasA4;
//右侧列表
string ChannelListAliasB2 = ConfigurationManager.AppSettings["HomeChannelListB_CategoryAlias_2"];
WebModules.HomeChannelListB HomeChannelListB2 = new WebModules.HomeChannelListB(ChannelListAliasB2, 1, 8);
//VerticalShowVideo2.DataSource = HomeChannelListB2.PicInfo;
// VerticalShowVideo2.DataBind();
// VerticalShowList2.DataSource = HomeChannelListB2.TextInfo;
// VerticalShowList2.DataBind();
string ChannelListBTitle2 = ConfigurationManager.AppSettings["HomeChannelListB_Title_2"];
// ListBTitle2.Text = ChannelListBTitle2;
// ListBLink2.NavigateUrl = "level2.aspx?alias=" + ChannelListAliasB2;
string ChannelListAliasB3 = ConfigurationManager.AppSettings["HomeChannelListB_CategoryAlias_3"];
WebModules.HomeChannelListB HomeChannelListB3 = new WebModules.HomeChannelListB(ChannelListAliasB3, 1, 4);
//VerticalShowVideo3.DataSource = HomeChannelListB3.PicInfo;
// VerticalShowVideo3.DataBind();
// VerticalShowList3.DataSource = HomeChannelListB3.TextInfo;
// VerticalShowList3.DataBind();
string ChannelListBTitle3 = ConfigurationManager.AppSettings["HomeChannelListB_Title_3"];
// ListBTitle3.Text = ChannelListBTitle3;
// ListBLink3.NavigateUrl = "level2.aspx?alias=" + ChannelListAliasB3;
//右侧名家
string ChannelListAliasBS1 = ConfigurationManager.AppSettings["HomeChannelListBS_CategoryAlias_1"];
WebModules.HomeChannelListBS HomeChannelListBS1 = new WebModules.HomeChannelListBS(ChannelListAliasBS1, 2);
// VerticalShowVideo1.DataSource = HomeChannelListBS1.PicInfo;
// VerticalShowVideo1.DataBind();
string ChannelListBSTitle1 = ConfigurationManager.AppSettings["HomeChannelListBS_Title_1"];
// ListBTitle1.Text = ChannelListBSTitle1;
string FameAlias = ConfigurationManager.AppSettings["ChannelFame"];
// ListBLink1.NavigateUrl = "level2.aspx?alias=" + FameAlias;
//右侧公开课
string ChannelListAliasBS2 = ConfigurationManager.AppSettings["ChannelClass"];
//WebModules.HomeChannelListBS HomeChannelListBS2 = new WebModules.HomeChannelListBS(ChannelListAliasBS2, 2);
//VerticalShowVideo4.DataSource = HomeChannelListBS2.PicInfo;
//VerticalShowVideo4.DataBind();
//LeftList
string Lv2ClassLeftListAlias = DataQuery.GetChannelAliasByName(ChannelListAliasBS2, "国内985大学");
DataTable Lv2ClassLeftList1Items = DataQuery.GetSubCategories(Lv2ClassLeftListAlias, "6");
// TabIndex2List1.DataSource = Lv2ClassLeftList1Items;
// TabIndex2List1.DataBind();
//LeftList
Lv2ClassLeftListAlias = DataQuery.GetChannelAliasByName(ChannelListAliasBS2, "国外大学");
DataTable Lv2ClassLeftList2Items = DataQuery.GetSubCategories(Lv2ClassLeftListAlias, "6");
// TabIndex2List2.DataSource = Lv2ClassLeftList2Items;
// TabIndex2List2.DataBind();
//下方列表
string SkillListAlias = ConfigurationManager.AppSettings["HomeChannelListC_CategoryAlias"];
DataTable SkillCategoryInfo = DataQuery.GetSubCategoriesNote(DataQuery.GetChannelAliasByName(SkillListAlias, "栏目"), "8");
SkillTabs.DataSource = SkillCategoryInfo;
SkillTabs.DataBind();
TabIndex1Box.DataSource = SkillCategoryInfo;
TabIndex1Box.DataBind();
SkillNote.DataSource = SkillCategoryInfo;
SkillNote.DataBind();
string ChannelListAliasD = ConfigurationManager.AppSettings["HomeChannelListD_CategoryAlias"];
WebModules.HomeChannelListC HomeChannelListC2 = new WebModules.HomeChannelListC(ChannelListAliasD);
TrainList.DataSource = HomeChannelListC2.CategoryInfo;
TrainList.DataBind();
// TEST
//GridView1.DataSource = HomeChannelListA1.TextInfoL;
//GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
url = "http://" + Request.Url.Authority + Request.ApplicationPath + "/";
string ChannelTitle = null;
// 痕迹&栏目标题
if (Request.QueryString["alias"] == null)
{
//Response.Redirect("index.aspx");
alias = "gxchannel1_topics_1";
IsChild = "0";
}
else
{
SetAliasAndIsChild();
}
string CategoryGUID = DataQuery.CategoryAliasToID(alias);
string CategoryPath = DataQuery.CategoryPath(CategoryGUID);
char[] PathSeparator = { '/' };
string[] CategoryPaths = CategoryPath.Split(PathSeparator);
ChannelAlias = DataQuery.CategoryIDToAlias(CategoryPaths[4]);
string Lv2Alias = DataQuery.CategoryIDToAlias(CategoryPaths[6]);//2级分类
ChannelTitle = DataQuery.GetNameByCategoryAlias(ChannelAlias);
CurrentTrace.Text = ChannelTitle;
CurrentCategoryName.Text = ChannelTitle;
TraceLv2Link.NavigateUrl = "level2.aspx?alias=" + ChannelAlias;
//竖导航
String Lv2sAlias = DataQuery.GetChannelAliasByName(ChannelAlias, "栏目");
DataTable Lv2CategoriesInfo = DataQuery.GetSubCategories(Lv2sAlias);
DataRow[] Lv2Current = Lv2CategoriesInfo.Select("CategoryAlias = '" + Lv2Alias + "'");
if (Lv2Current.Length > 0)
{
Lv2CategoriesIndex = Array.IndexOf(Lv2CategoriesInfo.Select("", "XIndex asc"), Lv2Current[0]);
}
Lv3Navi.DataSource = Lv2CategoriesInfo;
Lv3Navi.DataBind();
//主列表
if (Request.QueryString["order"] == null)
{
ListOrder = "desc";
RadioDesc.Checked = true;
}
else
{
ListOrder = Request.QueryString["order"].ToString();
switch (ListOrder)
{
case "asc":
RadioAsc.Checked = true;
break;
case "desc":
RadioDesc.Checked = true;
break;
default:
RadioDesc.Checked = true;
break;
}
}
//
ListType = GetListType();
//
guid = DataQuery.CategoryAliasToID(alias);
Lv3Pager.PageSize = int.Parse(System.Configuration.ConfigurationManager.AppSettings["PageSize"]);
if (!IsPostBack)
{
DataTable dt = new DAL.Article().GetArticleList(guid, false, "desc", true);
int iTotalRowsCount = dt.Rows.Count;
Lv3Pager.RecordCount = iTotalRowsCount;
MainDataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
CacheTest.Text = DateTime.Now.ToString();
url = "http://" + Request.Url.Authority + Request.ApplicationPath + "/";
//图片新闻
// Text
string NewsCommendAlias = ConfigurationManager.AppSettings["NewsCommendAlias"];
DataTable NewsCommendText = new DataTable();
NewsCommendText = DataQuery.GetSubCategories(NewsCommendAlias);
FocusTabsTxt.DataSource = NewsCommendText;
FocusTabsTxt.DataBind();
// Pic
if (NewsCommendText.Rows.Count > 0)
{
DataTable NewsCommendPic = new DataTable();
//NewsCommendPic = new DAL.Article().GetArticleList(NewsCommendText.Rows[0][1].ToString(),false,1); //缓存
NewsCommendPic = DataQuery.ArticleQuery("", "1", NewsCommendText.Rows[0][2].ToString()).Tables[0];
if (NewsCommendPic != null)
{
NewsCommendPic.Columns.Add("FocusTabsIndex", typeof(String));
NewsCommendPic.Rows[0]["FocusTabsIndex"] = NewsCommendText.Rows[0]["XIndex"];
DataTable NewsCommendPicMerge = new DataTable();
for (int i = 1; i < NewsCommendText.Rows.Count; i++)
{
//NewsCommendPicMerge = new DAL.Article().GetArticleList(NewsCommendText.Rows[i][1].ToString(),false,1); //缓存
NewsCommendPicMerge = DataQuery.ArticleQuery("", "1", NewsCommendText.Rows[i][2].ToString()).Tables[0];
NewsCommendPicMerge.Columns.Add("FocusTabsIndex", typeof(String));
NewsCommendPicMerge.Rows[0]["FocusTabsIndex"] = NewsCommendText.Rows[i]["XIndex"];
NewsCommendPic.Merge(NewsCommendPicMerge);
}
FocusTabsPic.DataSource = NewsCommendPic;
FocusTabsPic.DataBind();
}
}
//特别关注
string SubjectGUID = DataQuery.CategoryAliasToID(ConfigurationManager.AppSettings["TBGZ_Alias"]);
string SubjectPath = DataQuery.CategoryPath(SubjectGUID); //专题路径
DataTable HotSubjects = new DataTable();
HotSubjects = DataQuery.GetNHotZT();
// 获取课件
//string SubjectHotGUID = DataQuery.CategoryAliasToID(ConfigurationManager.AppSettings["SAHot_Alias"]);
// string SubjectHotPath = DataQuery.CategoryPath(SubjectGUID);
DataTable HotCoursesMerge = new DataTable();
// 第一个专题
if (HotSubjects.Rows.Count > 0)
{
//string SubjectHotItemPath = SubjectPath + "/" + HotSubjects.Rows[0][0].ToString();
// DataTable HotCourses = new DAL.CategoryDAL().GetArticleIndexList(SubjectHotItemPath, "最新动态", 2, false);
string HotSubjectAlias = DataQuery.CategoryIDToAlias(HotSubjects.Rows[0][0].ToString());
string SubjectNewAlias = DataQuery.GetChannelAliasByName(HotSubjectAlias, "最新动态");
string SubjectNewGuid = DataQuery.CategoryAliasToID(SubjectNewAlias);
DataTable HotCourses = new DAL.Article().GetArticleList(SubjectNewGuid, false, 2);
HotCourses.Columns.Add("SubjectID", Type.GetType("System.String"));
HotCourses.Columns.Add("SubjectTitle", Type.GetType("System.String"));
for (int i = 0; i < HotCourses.Rows.Count; i++)
{
HotCourses.Rows[i]["SubjectID"] = HotSubjects.Rows[0][0].ToString();
HotCourses.Rows[i]["SubjectTitle"] = HotSubjects.Rows[0][1].ToString();
}
// 后N个专题
for (int i = 1; i < HotSubjects.Rows.Count; i++)
{
//SubjectHotItemPath = SubjectPath + "/" + HotSubjects.Rows[i][0].ToString();
//HotCoursesMerge = new DAL.CategoryDAL().GetArticleIndexList(SubjectHotItemPath, "最新动态", 2, false);
HotSubjectAlias = DataQuery.CategoryIDToAlias(HotSubjects.Rows[i][0].ToString());
SubjectNewGuid = DataQuery.GetSubChannelGuidByName(HotSubjectAlias, "最新动态");
HotCoursesMerge = new DAL.Article().GetArticleList(SubjectNewGuid, false, 2);
HotCoursesMerge.Columns.Add("SubjectID", Type.GetType("System.String"));
HotCoursesMerge.Columns.Add("SubjectTitle", Type.GetType("System.String"));
for (int j = 0; j < HotCoursesMerge.Rows.Count; j++)
{
HotCoursesMerge.Rows[j]["SubjectID"] = HotSubjects.Rows[i][0].ToString();
HotCoursesMerge.Rows[j]["SubjectTitle"] = HotSubjects.Rows[i][1].ToString();
}
HotCourses.Merge(HotCoursesMerge);
}
SpecialFocusContent.DataSource = HotCourses;
SpecialFocusContent.DataBind();
}
//时事新闻
DataTable HomeTopDataTable1 = new DataTable();
string HomeNews1Guid = DataQuery.CategoryAliasToID(ConfigurationManager.AppSettings["HomeTop1Alias"]);
HomeTopDataTable1 = new DAL.Article().GetArticleList(HomeNews1Guid, true, 1);
if (HomeTopDataTable1 != null)
{
//
//TopVideoPic1.ImageUrl = DataQuery.GetCoursePicPath(HomeTopDataTable1.Rows[0][0].ToString(), url, "000.jpg");
TopVideoLink1a.NavigateUrl = "ShowVideo.aspx?ID=" + HomeTopDataTable1.Rows[0][0].ToString();
TopVideoLink1b.NavigateUrl = "ShowVideo.aspx?ID=" + HomeTopDataTable1.Rows[0][0].ToString();
string TopVideoLink1Title = HomeTopDataTable1.Rows[0][1].ToString();
string[] TopVideoLink1Array = TopVideoLink1Title.Split(new char[] { '[' });
TopVideoLink1Title = TopVideoLink1Array[1].Replace("]", "");
TopVideoLink1b.Text = TopVideoLink1Title;
TopVideoText1.Text = DataProcessing.SubstringText(HomeTopDataTable1.Rows[0][10].ToString(), 26);
//
DataTable HomeTopDataTable2 = new DataTable();
string HomeNews2Guid = DataQuery.CategoryAliasToID(ConfigurationManager.AppSettings["HomeTop2Alias"]);
HomeTopDataTable2 = new DAL.Article().GetArticleList(HomeNews2Guid, false, 1);
//TopVideoPic2.ImageUrl = DataQuery.GetCoursePicPath(HomeTopDataTable2.Rows[0][0].ToString(), url, "000.jpg");
TopVideoLink2a.NavigateUrl = "ShowVideo.aspx?ID=" + HomeTopDataTable2.Rows[0][0].ToString();
TopVideoLink2b.NavigateUrl = "ShowVideo.aspx?ID=" + HomeTopDataTable2.Rows[0][0].ToString();
string TopVideoLink2Title = HomeTopDataTable2.Rows[0][1].ToString();
string[] TopVideoLink2Array = TopVideoLink2Title.Split(new char[] { '[' });
TopVideoLink2Title = TopVideoLink2Array[1].Replace("]", "");
TopVideoLink2b.Text = TopVideoLink2Title;
string CSVPath = DataQuery.GetFileStreamPath(HomeTopDataTable2.Rows[0][0].ToString(), "vod/data.csv");
//string CSVPath = DataQuery.GetFileStreamPath(HomeTopDataTable2.Rows[0][0].ToString(), "vod/");
if (CSVPath != null)
{
DataTable CSVDataSrc = new DataTable();
try
{
CSVDataSrc = DataProcessing.ImportCSV(CSVPath);
//CSVDataSrc = DataProcessing.getCsvData(CSVPath, "data.csv");
var CSVData = from row in CSVDataSrc.AsEnumerable()
select row;
CSVDataSrc = CSVData.Take(1).CopyToDataTable <DataRow>();
//DailyVideoInfoTextLines.DataSource = CSVDataSrc;
//DailyVideoInfoTextLines.DataBind();
string CSVDataText = CSVDataSrc.Rows[0][5].ToString();
CSVDataText = CSVDataText.Remove(0, 1);
TopVideoText2.Text = DataProcessing.SubstringText(CSVDataText, 26);
}
catch (Exception ex)
{
}
}
}
//导航
string NaviList1Alias = ConfigurationManager.AppSettings["subject"];
DataTable NaviList1Items = DataQuery.GetSubCategories(NaviList1Alias, "9");
NaviList1.DataSource = NaviList1Items;
NaviList1.DataBind();
string NaviList2Alias = ConfigurationManager.AppSettings["MAJOR"];
DataTable NaviList2Items = DataQuery.GetSubCategories(NaviList2Alias, "9");
NaviList2.DataSource = NaviList2Items;
NaviList2.DataBind();
string NaviList3Alias = ConfigurationManager.AppSettings["INSTITUTION"];
DataTable NaviList3Items = DataQuery.GetSubCategories(NaviList3Alias, "9");
NaviList3.DataSource = NaviList3Items;
NaviList3.DataBind();
//主列表
string ChannelListAliasA1 = ConfigurationManager.AppSettings["HomeChannelListA_CategoryAlias_1"];
WebModules.HomeChannelListA HomeChannelListA1 = new WebModules.HomeChannelListA(ChannelListAliasA1);
ColumnShowSort1.DataSource = HomeChannelListA1.SubSortTable;
ColumnShowSort1.DataBind();
ColumnVideo1.DataSource = HomeChannelListA1.PicInfo;
ColumnVideo1.DataBind();
ColumnOtherL1.DataSource = HomeChannelListA1.TextInfoL;
ColumnOtherL1.DataBind();
ColumnOtherR1.DataSource = HomeChannelListA1.TextInfoR;
ColumnOtherR1.DataBind();
string ChannelListATitle1 = ConfigurationManager.AppSettings["HomeChannelListA_Title_1"];
ListATitle1.Text = ChannelListATitle1;
ListALink1.NavigateUrl = "level2.aspx?alias=" + ChannelListAliasA1;
string ChannelListAliasA2 = ConfigurationManager.AppSettings["HomeChannelListA_CategoryAlias_2"];
WebModules.HomeChannelListA HomeChannelListA2 = new WebModules.HomeChannelListA(ChannelListAliasA2);
ColumnShowSort2.DataSource = HomeChannelListA2.SubSortTable;
ColumnShowSort2.DataBind();
ColumnVideo2.DataSource = HomeChannelListA2.PicInfo;
ColumnVideo2.DataBind();
ColumnOtherL2.DataSource = HomeChannelListA2.TextInfoL;
ColumnOtherL2.DataBind();
ColumnOtherR2.DataSource = HomeChannelListA2.TextInfoR;
ColumnOtherR2.DataBind();
string ChannelListATitle2 = ConfigurationManager.AppSettings["HomeChannelListA_Title_2"];
ListATitle2.Text = ChannelListATitle2;
ListALink2.NavigateUrl = "level2.aspx?alias=" + ChannelListAliasA2;
string ChannelListAliasA3 = ConfigurationManager.AppSettings["HomeChannelListA_CategoryAlias_3"];
WebModules.HomeChannelListA HomeChannelListA3 = new WebModules.HomeChannelListA(ChannelListAliasA3);
ColumnShowSort3.DataSource = HomeChannelListA3.SubSortTable;
ColumnShowSort3.DataBind();
ColumnVideo3.DataSource = HomeChannelListA3.PicInfo;
ColumnVideo3.DataBind();
ColumnOtherL3.DataSource = HomeChannelListA3.TextInfoL;
ColumnOtherL3.DataBind();
ColumnOtherR3.DataSource = HomeChannelListA3.TextInfoR;
ColumnOtherR3.DataBind();
string ChannelListATitle3 = ConfigurationManager.AppSettings["HomeChannelListA_Title_3"];
ListATitle3.Text = ChannelListATitle3;
ListALink3.NavigateUrl = "level2.aspx?alias=" + ChannelListAliasA3;
string ChannelListAliasA4 = ConfigurationManager.AppSettings["HomeChannelListA_CategoryAlias_4"];
WebModules.HomeChannelListA HomeChannelListA4 = new WebModules.HomeChannelListA(ChannelListAliasA4);
ColumnShowSort4.DataSource = HomeChannelListA4.SubSortTable;
ColumnShowSort4.DataBind();
ColumnVideo4.DataSource = HomeChannelListA4.PicInfo;
ColumnVideo4.DataBind();
ColumnOtherL4.DataSource = HomeChannelListA4.TextInfoL;
ColumnOtherL4.DataBind();
ColumnOtherR4.DataSource = HomeChannelListA4.TextInfoR;
ColumnOtherR4.DataBind();
string ChannelListATitle4 = ConfigurationManager.AppSettings["HomeChannelListA_Title_4"];
ListATitle4.Text = ChannelListATitle4;
ListALink4.NavigateUrl = "level2.aspx?alias=" + ChannelListAliasA4;
//右侧列表
string ChannelListAliasB2 = ConfigurationManager.AppSettings["HomeChannelListB_CategoryAlias_2"];
WebModules.HomeChannelListB HomeChannelListB2 = new WebModules.HomeChannelListB(ChannelListAliasB2, 1, 8);
VerticalShowVideo2.DataSource = HomeChannelListB2.PicInfo;
VerticalShowVideo2.DataBind();
VerticalShowList2.DataSource = HomeChannelListB2.TextInfo;
VerticalShowList2.DataBind();
string ChannelListBTitle2 = ConfigurationManager.AppSettings["HomeChannelListB_Title_2"];
ListBTitle2.Text = ChannelListBTitle2;
ListBLink2.NavigateUrl = "level2.aspx?alias=" + ChannelListAliasB2;
string ChannelListAliasB3 = ConfigurationManager.AppSettings["HomeChannelListB_CategoryAlias_3"];
WebModules.HomeChannelListB HomeChannelListB3 = new WebModules.HomeChannelListB(ChannelListAliasB3, 1, 4);
VerticalShowVideo3.DataSource = HomeChannelListB3.PicInfo;
VerticalShowVideo3.DataBind();
VerticalShowList3.DataSource = HomeChannelListB3.TextInfo;
VerticalShowList3.DataBind();
string ChannelListBTitle3 = ConfigurationManager.AppSettings["HomeChannelListB_Title_3"];
ListBTitle3.Text = ChannelListBTitle3;
ListBLink3.NavigateUrl = "level2.aspx?alias=" + ChannelListAliasB3;
//右侧名家
string ChannelListAliasBS1 = ConfigurationManager.AppSettings["HomeChannelListBS_CategoryAlias_1"];
WebModules.HomeChannelListBS HomeChannelListBS1 = new WebModules.HomeChannelListBS(ChannelListAliasBS1, 2);
VerticalShowVideo1.DataSource = HomeChannelListBS1.PicInfo;
VerticalShowVideo1.DataBind();
string ChannelListBSTitle1 = ConfigurationManager.AppSettings["HomeChannelListBS_Title_1"];
ListBTitle1.Text = ChannelListBSTitle1;
string FameAlias = ConfigurationManager.AppSettings["ChannelFame"];
ListBLink1.NavigateUrl = "level2.aspx?alias=" + FameAlias;
//右侧公开课
string ChannelListAliasBS2 = ConfigurationManager.AppSettings["ChannelClass"];
//WebModules.HomeChannelListBS HomeChannelListBS2 = new WebModules.HomeChannelListBS(ChannelListAliasBS2, 2);
//VerticalShowVideo4.DataSource = HomeChannelListBS2.PicInfo;
//VerticalShowVideo4.DataBind();
//LeftList
string Lv2ClassLeftListAlias = DataQuery.GetChannelAliasByName(ChannelListAliasBS2, "国内985大学");
DataTable Lv2ClassLeftList1Items = DataQuery.GetSubCategories(Lv2ClassLeftListAlias, "6");
TabIndex2List1.DataSource = Lv2ClassLeftList1Items;
TabIndex2List1.DataBind();
//LeftList
Lv2ClassLeftListAlias = DataQuery.GetChannelAliasByName(ChannelListAliasBS2, "国外大学");
DataTable Lv2ClassLeftList2Items = DataQuery.GetSubCategories(Lv2ClassLeftListAlias, "6");
TabIndex2List2.DataSource = Lv2ClassLeftList2Items;
TabIndex2List2.DataBind();
//下方列表
string SkillListAlias = ConfigurationManager.AppSettings["HomeChannelListC_CategoryAlias"];
DataTable SkillCategoryInfo = DataQuery.GetSubCategoriesNote(DataQuery.GetChannelAliasByName(SkillListAlias, "栏目"), "8");
SkillTabs.DataSource = SkillCategoryInfo;
SkillTabs.DataBind();
TabIndex1Box.DataSource = SkillCategoryInfo;
TabIndex1Box.DataBind();
SkillNote.DataSource = SkillCategoryInfo;
SkillNote.DataBind();
string ChannelListAliasD = ConfigurationManager.AppSettings["HomeChannelListD_CategoryAlias"];
WebModules.HomeChannelListC HomeChannelListC2 = new WebModules.HomeChannelListC(ChannelListAliasD);
TrainList.DataSource = HomeChannelListC2.CategoryInfo;
TrainList.DataBind();
// TEST
//GridView1.DataSource = HomeChannelListA1.TextInfoL;
//GridView1.DataBind();
}
protected void Page_Init(object sender, EventArgs e)
{
url = "http://" + Request.Url.Authority + Request.ApplicationPath + "/";
//热门关键词
string sHotKey_Alias = ConfigurationManager.AppSettings["HotKeyAlias"];
divHotKey.InnerHtml = new DAL.CategoryDAL().GetHotKey(sHotKey_Alias);
//导航
string VoidGuid = ConfigurationManager.AppSettings["Void_Guid"];
string VersionMark = ConfigurationManager.AppSettings["Version_Mark"];
DataTable NaviListData = DataQuery.GetNaviCategories(VoidGuid, "10", VersionMark);
TopNaviList.DataSource = NaviListData;
TopNaviList.DataBind();
string ChannelAlias = null;
string ChannelTitle = null;
// 跳转&痕迹
string CurrentPage = Path.GetFileName(Request.PhysicalPath);
if (CurrentPage == "Level2Fame.aspx")
{
ChannelAlias = ConfigurationManager.AppSettings["ChannelFame"];
ChannelTitle = DataQuery.GetNameByCategoryAlias(ChannelAlias);
CurrentTrace.Text = ChannelTitle;
TraceLv2Link.NavigateUrl = "Level2Fame.aspx";
}
else if (CurrentPage == "Level2Class.aspx")
{
ChannelAlias = ConfigurationManager.AppSettings["ChannelClass"];
ChannelTitle = DataQuery.GetNameByCategoryAlias(ChannelAlias);
CurrentTrace.Text = ChannelTitle;
TraceLv2Link.NavigateUrl = "Level2Class.aspx";
}
else if (CurrentPage == "Level2News.aspx")
{
ChannelAlias = ConfigurationManager.AppSettings["ChannelNews"];
ChannelTitle = DataQuery.GetNameByCategoryAlias(ChannelAlias);
CurrentTrace.Text = ChannelTitle;
TraceLv2Link.NavigateUrl = "Level2News.aspx";
}
else
{
try
{
ChannelAlias = Request.QueryString["alias"].ToString();
}
catch (Exception AliasNull)
{
Response.Redirect("index.aspx");
}
if (ChannelAlias == ConfigurationManager.AppSettings["ChannelFame"])
{
Response.Redirect("Level2Fame.aspx");
}
else if (ChannelAlias == ConfigurationManager.AppSettings["ChannelClass"])
{
Response.Redirect("Level2Class.aspx");
}
//else if (ChannelAlias == ConfigurationManager.AppSettings["ChannelNews"])
//{
// Response.Redirect("Level2News.aspx");
//}
else
{
ChannelTitle = DataQuery.GetNameByCategoryAlias(ChannelAlias);
CurrentTrace.Text = ChannelTitle;
TraceLv2Link.NavigateUrl = "level2.aspx?alias=" + ChannelAlias;
}
}
// 导视
String GuideAlias = DataQuery.GetChannelAliasByName(ChannelAlias, "导视");
String GuideGuid = DataQuery.CategoryAliasToID(GuideAlias);
DataTable GuideCourses = new DAL.Article().GetArticleList(GuideGuid, true, 5);
//Remove Html
SlideShowPic.DataSource = GuideCourses;
SlideShowPic.DataBind();
SlideShowText.DataSource = GuideCourses;
SlideShowText.DataBind();
// 图片
Level2Title.ImageUrl = "../images/" + ChannelAlias + ".png";
//预告
String TrailerAlias = ConfigurationManager.AppSettings["ChannelTrailer"];
string EnCodeChannelTitle = HttpUtility.UrlEncode(ChannelTitle, Encoding.GetEncoding("utf-8"));
PreviewPic.ImageUrl = "../ShowBytePic.aspx?Title=" + EnCodeChannelTitle + "&Alias=" + TrailerAlias;
String TrailerText = DataQuery.GetTrailerText(TrailerAlias, ChannelTitle);
if (TrailerText != null)
{
TrailerText = TrailerText.Replace("；", ";");
string[] TrailerInfo = TrailerText.Split(';');
PreviewTitle.Text = DataProcessing.SubstringText(TrailerInfo[0], 10);
PreviewTitle.ToolTip = TrailerInfo[0].ToString();
PreviewSpeaker.Text = TrailerInfo[1];
PreviewSpeakerInfo.Text = DataProcessing.SubstringText(TrailerInfo[2], 10);
PreviewSpeakerInfo.ToolTip = TrailerInfo[2].ToString();
}
}
