/// <summary>
/// 绑定信息
/// </summary>
private void BindInfo()
{
//Title
bll_config.Load(new string[] { "pageTitle" });
Page.Title = model.Title + " - " + bll_config["pageTitle"];
//KeyWord
WebUtility.CreateMeta(Page, "keywords", model.Keywords);
//Description
WebUtility.CreateMeta(Page, "description", model.Descn);
//List<string> fieldList = new List<string>();
//fieldList.Add(ProductModel.PKID);
//fieldList.Add(ProductModel.TITLE);
//fieldList.Add(ProductModel.PRICE1);
//fieldList.Add(ProductModel.SUMMARY);
//fieldList.Add(ProductModel.PIC);
//List<SqlWhere> sqlWhereList = new List<SqlWhere>();
//sqlWhereList.Add(new SqlWhere(ProductModel.ENABLED, SqlWhere.Oper.Equal, true));
//sqlWhereList.Add(new SqlWhere(ProductModel.CATEGORYID, SqlWhere.Oper.Equal, cid));
//int iRecordsTotal = bll_product.DoCount(sqlWhereList);
//QianZhu.Utility.Pagination pagination = new QianZhu.Utility.Pagination(Request.QueryString["page"], iRecordsTotal, iPageSize, "/prolist/" + cid + "/page/$p/", false);
//Paging.InnerHtml = pagination.Show();
//productList = bll_product.GetList(pagination.PageIndex, iPageSize, fieldList, sqlWhereList, null);
}
/// <summary>
/// 绑定信息
/// </summary>
private void BindInfo()
{
bll_config.Load(new string[] { "pageTitle", "keywords", "descn", "video" });
//Title
Page.Title = "合作伙伴" + " - " + bll_config["pageTitle"];
//KeyWord
WebUtility.CreateMeta(Page, "keywords", bll_config["keywords"]);
//Description
WebUtility.CreateMeta(Page, "description", bll_config["descn"]);
//组合查询字段
List <string> fieldList = new List <string>();
fieldList.Add(AdFixedModel.PIC);
fieldList.Add(AdFixedModel.NOTES);
fieldList.Add(AdFixedModel.PKID);
fieldList.Add(AdFixedModel.TITLE);
fieldList.Add(AdFixedModel.URL);
fieldList.Add(AdFixedModel.CREATETIME);
//文章
List <SqlWhere> sqlWhereList = new List <SqlWhere>();
sqlWhereList.Add(new SqlWhere(AdFixedModel.ENABLED, SqlWhere.Oper.Equal, true));
sqlWhereList.Add(new SqlWhere(AdFixedModel.GROUPID, SqlWhere.Oper.Equal, 7));
//读取分页数据
int iRecordsTotal = bll_article.DoCount(sqlWhereList);
QianZhu.Utility.Pagination pagination = new QianZhu.Utility.Pagination(Request.QueryString["page"], iRecordsTotal, iPageSize, "/partner/page/$p/", false);
//pagination.HomePage = category.Url;
Paging.InnerHtml = pagination.Show();
articleList = bll_article.GetList(pagination.PageIndex, iPageSize, fieldList, sqlWhereList, null);
}
protected void Page_Load(object sender, EventArgs e)
{
bll_config.Load(new string[] { "pageTitle", "keywords", "descn", "video" });
//Title
Page.Title = bll_config["pageTitle"];
//KeyWord
WebUtility.CreateMeta(Page, "keywords", bll_config["keywords"]);
//Description
WebUtility.CreateMeta(Page, "description", bll_config["descn"]);
}
/// <summary>
/// 绑定信息
/// </summary>
private void BindInfo()
{
//Title
bll_config.Load(new string[] { "pageTitle" });
if (!String.IsNullOrEmpty(category.PageTitle))
{
Page.Title = category.PageTitle;
}
else
{
Page.Title = category.Title + " - " + bll_config["pageTitle"];
}
//KeyWord
WebUtility.CreateMeta(Page, "keywords", category.Keywords);
//Description
WebUtility.CreateMeta(Page, "description", category.Descn);
//组合查询字段
List <string> fieldList = new List <string>();
fieldList.Add(ArticleModel.PIC);
fieldList.Add(ArticleModel.AUTHOR);
fieldList.Add(ArticleModel.PKID);
fieldList.Add(ArticleModel.TITLE);
fieldList.Add(ArticleModel.FILES);
fieldList.Add(ArticleModel.SOURCE);
fieldList.Add(ArticleModel.PUBDATE);
fieldList.Add(ArticleModel.CREATETIME);
//文章
List <SqlWhere> sqlWhereList = new List <SqlWhere>();
sqlWhereList.Add(new SqlWhere(ArticleModel.ENABLED, SqlWhere.Oper.Equal, true));
//sqlWhereList.Add(new SqlWhere(ArticleModel.CATEGORYID, SqlWhere.Oper.In, bll_category.GetIds(category.Pkid.ToString())));
sqlWhereList.Add(new SqlWhere(ArticleModel.CATEGORYID, SqlWhere.Oper.In, bll_category.GetIds(category.Pkid.ToString())));
//读取分页数据
int iRecordsTotal = bll_article.DoCount(sqlWhereList);
QianZhu.Utility.Pagination pagination = new QianZhu.Utility.Pagination(Request.QueryString["page"], iRecordsTotal, iPageSize, "/expert/" + category.Pkid.ToString() + "/page/$p/", false);
//pagination.HomePage = category.Url;
Paging.InnerHtml = pagination.Show();
articleList = bll_article.GetList(pagination.PageIndex, iPageSize, fieldList, sqlWhereList, null);
}
/// <summary>
/// 绑定信息
/// </summary>
private void BindInfo()
{
//Title
bll_config.Load(new string[] { "pageTitle" });
if (!String.IsNullOrEmpty(model.PageTitle))
{
Page.Title = model.PageTitle;
}
else
{
Page.Title = model.Title + " - " + bll_config["pageTitle"];
}
//KeyWord
WebUtility.CreateMeta(Page, "keywords", model.Keywords);
//Description
WebUtility.CreateMeta(Page, "description", model.Descn);
}
/// <summary>
/// 绑定信息
/// </summary>
private void BindInfo()
{
//Title
bll_config.Load(new string[] { "pageTitle" });
Page.Title = model.Title + " - " + bll_config["pageTitle"];
//KeyWord
WebUtility.CreateMeta(Page, "keywords", model.Keywords);
//Description
WebUtility.CreateMeta(Page, "description", model.Descn);
//Nav
// Nav.InnerHtml = " > <a class='cor_hs' href='" + onepage.Url + "'>" + onepage.Title + "</a> > " + model.Title;
List <string> fieldList = new List <string>();
fieldList.Add(ProductModel.PKID);
fieldList.Add(ProductModel.TITLE);
fieldList.Add(ProductModel.PRICE1);
fieldList.Add(ProductModel.SUMMARY);
fieldList.Add(ProductModel.CONTENT);
List <SqlWhere> sqlWhereList = new List <SqlWhere>();
sqlWhereList.Add(new SqlWhere(ProductModel.ENABLED, SqlWhere.Oper.Equal, true));
sqlWhereList.Add(new SqlWhere(ProductModel.CATEGORYID, SqlWhere.Oper.In, bll_category.GetIds(cid))); //类别
//sqlWhereList.Add(new SqlWhere(ProductModel.CATEGORYID, SqlWhere.Oper.Equal, cid));
//读取分页数据
//int iRecordsTotal = bll_product.DoCount(sqlWhereList);
//QianZhu.Utility.Pagination pagination = new QianZhu.Utility.Pagination(Request.QueryString["page"], iRecordsTotal, iPageSize, "/prolist/" + cid + "/page/$p/", false);
//pagination.HomePage = category.Url;
// Paging.InnerHtml = pagination.Show();
//productList = bll_product.GetList(pagination.PageIndex, iPageSize, fieldList, sqlWhereList, null);
productList = bll_product.GetList(1, 0, fieldList, sqlWhereList, null);
}
/// <summary>
/// 绑定信息
/// </summary>
private void BindInfo()
{
bll_config.Load(new string[] { "pageTitle", "keywords", "descn", "video" });
//Title
Page.Title = bll_config["pageTitle"];
//KeyWord
WebUtility.CreateMeta(Page, "keywords", bll_config["keywords"]);
//Description
WebUtility.CreateMeta(Page, "description", bll_config["descn"]);
video = bll_config["video"];
//局部页面
ad4 = bll_adFixed.GetModel(41);
ad5 = bll_adFixed.GetModel(42);
ad6 = bll_adFixed.GetModel(43);
ad7 = bll_adFixed.GetModel(44);
ad8 = bll_adFixed.GetModel(49);
ad9 = bll_adFixed.GetModel(50);
ad10 = bll_adFixed.GetModel(51);
ad11 = bll_adFixed.GetModel(52);
ad12 = bll_adFixed.GetModel(53);
ad13 = bll_adFixed.GetModel(54);
pageSection = bll_pageSection.GetModel(2);
pageSection1 = bll_pageSection.GetModel(3);
//轮播
List <SqlWhere> sqlWhereList = new List <SqlWhere>();
sqlWhereList.Add(new SqlWhere(AdFixedModel.ENABLED, SqlWhere.Oper.Equal, true));
sqlWhereList.Add(new SqlWhere(AdFixedModel.GROUPID, SqlWhere.Oper.Equal, 9));
adFixedList = bll_adFixed.GetList(sqlWhereList);
//内训案例
sqlWhereList.Clear();
sqlWhereList.Add(new SqlWhere(AdFixedModel.ENABLED, SqlWhere.Oper.Equal, true));
sqlWhereList.Add(new SqlWhere(AdFixedModel.GROUPID, SqlWhere.Oper.Equal, 10));
adFixedList1 = bll_adFixed.GetList(1, 0, sqlWhereList);
//专家
List <string> fieldList = new List <string>();
fieldList.Add(ArticleModel.PKID);
fieldList.Add(ArticleModel.TITLE);
fieldList.Add(ArticleModel.PIC);
fieldList.Add(ArticleModel.FILES);
fieldList.Add(ArticleModel.PUBDATE);
fieldList.Add(ArticleModel.ISORT);
fieldList.Add(ArticleModel.ISTOP);
fieldList.Add(ArticleModel.CREATETIME);
sqlWhereList.Clear();
sqlWhereList.Add(new SqlWhere(ArticleModel.ENABLED, SqlWhere.Oper.Equal, true));
//sqlWhereList.Add(new SqlWhere(ArticleModel.ISTOP, SqlWhere.Oper.Equal, true));
sqlWhereList.Add(new SqlWhere(ArticleModel.CATEGORYID, SqlWhere.Oper.Equal, "12"));
articleList = bll_article.GetList(1, 6, fieldList, sqlWhereList, null);
// 内训
categoryList = bll_category.GetListByFatherId(10);
//热门课程
fieldList.Clear();
fieldList.Add(ProductModel.ISORT);
fieldList.Add(ProductModel.ISTOP);
fieldList.Add(ProductModel.PKID);
fieldList.Add(ProductModel.TITLE);
fieldList.Add(ProductModel.PUBDATE);
sqlWhereList.Clear();
sqlWhereList.Add(new SqlWhere(ProductModel.ISHOT, SqlWhere.Oper.Equal, true));
sqlWhereList.Add(new SqlWhere(ProductModel.ENABLED, SqlWhere.Oper.Equal, true));
sqlWhereList.Add(new SqlWhere(ProductModel.CATEGORYID, SqlWhere.Oper.In, bll_category.GetIds("10")));
productList1 = bll_product.GetList(1, 7, fieldList, sqlWhereList, null);
}
/// <summary>
/// 绑定信息
/// </summary>
private void BindInfo()
{
bll_config.Load(new string[] { "pageTitle", "keywords", "descn", "video" });
//Title
Page.Title = bll_config["pageTitle"];
//KeyWord
WebUtility.CreateMeta(Page, "keywords", bll_config["keywords"]);
//Description
WebUtility.CreateMeta(Page, "description", bll_config["descn"]);
video = bll_config["video"];
//局部页面
ad4 = bll_adFixed.GetModel(7);
ad5 = bll_adFixed.GetModel(8);
ad6 = bll_adFixed.GetModel(9);
ad7 = bll_adFixed.GetModel(10);
ad8 = bll_adFixed.GetModel(11);
ad9 = bll_adFixed.GetModel(12);
ad10 = bll_adFixed.GetModel(13);
ad11 = bll_adFixed.GetModel(14);
ad12 = bll_adFixed.GetModel(1);
//ad13 = bll_adFixed.GetModel(18);
//pageSection = bll_pageSection.GetModel(2);
//pageSection1 = bll_pageSection.GetModel(3);
//pageSection2 = bll_pageSection.GetModel(7);
//轮播
List <SqlWhere> sqlWhereList = new List <SqlWhere>();
sqlWhereList.Add(new SqlWhere(AdFixedModel.ENABLED, SqlWhere.Oper.Equal, true));
sqlWhereList.Add(new SqlWhere(AdFixedModel.GROUPID, SqlWhere.Oper.Equal, 3));
adFixedList = bll_adFixed.GetList(sqlWhereList);
//中部轮播小图
sqlWhereList.Clear();
sqlWhereList.Add(new SqlWhere(AdFixedModel.ENABLED, SqlWhere.Oper.Equal, true));
sqlWhereList.Add(new SqlWhere(AdFixedModel.GROUPID, SqlWhere.Oper.Equal, 5));
adFixedList1 = bll_adFixed.GetList(1, 0, sqlWhereList);
//底部轮播小图
sqlWhereList.Clear();
sqlWhereList.Add(new SqlWhere(AdFixedModel.ENABLED, SqlWhere.Oper.Equal, true));
sqlWhereList.Add(new SqlWhere(AdFixedModel.GROUPID, SqlWhere.Oper.Equal, 6));
adFixedList3 = bll_adFixed.GetList(1, 0, sqlWhereList);
//合作伙伴
sqlWhereList.Clear();
sqlWhereList.Add(new SqlWhere(AdFixedModel.ENABLED, SqlWhere.Oper.Equal, true));
sqlWhereList.Add(new SqlWhere(AdFixedModel.GROUPID, SqlWhere.Oper.Equal, 7));
adFixedList4 = bll_adFixed.GetList(1, 0, sqlWhereList);
//友情链接
sqlWhereList.Clear();
sqlWhereList.Add(new SqlWhere(AdFixedModel.ENABLED, SqlWhere.Oper.Equal, true));
sqlWhereList.Add(new SqlWhere(AdFixedModel.GROUPID, SqlWhere.Oper.Equal, 2));
adFixedList5 = bll_adFixed.GetList(1, 0, sqlWhereList);
//首页CMA考试
sqlWhereList.Clear();
sqlWhereList.Add(new SqlWhere(AdFixedModel.ENABLED, SqlWhere.Oper.Equal, true));
sqlWhereList.Add(new SqlWhere(AdFixedModel.GROUPID, SqlWhere.Oper.Equal, 8));
adFixedList6 = bll_adFixed.GetList(1, 0, sqlWhereList);
//新闻资讯
List <string> fieldList = new List <string>();
fieldList.Add(ArticleModel.PKID);
fieldList.Add(ArticleModel.TITLE);
fieldList.Add(ArticleModel.ISORT);
fieldList.Add(ArticleModel.ISTOP);
fieldList.Add(ArticleModel.PIC);
fieldList.Add(ArticleModel.FILES);
fieldList.Add(ArticleModel.PUBDATE);
fieldList.Add(ArticleModel.CREATETIME);
sqlWhereList.Clear();
sqlWhereList.Add(new SqlWhere(ArticleModel.ENABLED, SqlWhere.Oper.Equal, true));
//sqlWhereList.Add(new SqlWhere(ArticleModel.ISTOP, SqlWhere.Oper.Equal, true));
sqlWhereList.Add(new SqlWhere(ArticleModel.CATEGORYID, SqlWhere.Oper.In, bll_category.GetIds("3")));
articleList = bll_article.GetList(1, 5, fieldList, sqlWhereList, null);
// 装修案例
//categoryList = bll_category.GetListByFatherId(2);
// 考试资讯
fieldList.Clear();
fieldList.Add(ArticleModel.PKID);
fieldList.Add(ArticleModel.TITLE);
fieldList.Add(ArticleModel.ISHEAD);
fieldList.Add(ArticleModel.ISORT);
fieldList.Add(ArticleModel.ISTOP);
fieldList.Add(ArticleModel.PIC);
fieldList.Add(ArticleModel.FILES);
fieldList.Add(ArticleModel.PUBDATE);
fieldList.Add(ArticleModel.CREATETIME);
sqlWhereList.Clear();
sqlWhereList.Add(new SqlWhere(ArticleModel.ENABLED, SqlWhere.Oper.Equal, true));
sqlWhereList.Add(new SqlWhere(ArticleModel.CATEGORYID, SqlWhere.Oper.Equal, "16"));
articleList1 = bll_article.GetList(1, 5, fieldList, sqlWhereList, null);
// 考试心得
fieldList.Clear();
fieldList.Add(ArticleModel.PKID);
fieldList.Add(ArticleModel.TITLE);
fieldList.Add(ArticleModel.PIC);
fieldList.Add(ArticleModel.ISORT);
fieldList.Add(ArticleModel.ISTOP);
fieldList.Add(ArticleModel.FILES);
fieldList.Add(ArticleModel.PUBDATE);
fieldList.Add(ArticleModel.CREATETIME);
sqlWhereList.Clear();
sqlWhereList.Add(new SqlWhere(ArticleModel.ENABLED, SqlWhere.Oper.Equal, true));
sqlWhereList.Add(new SqlWhere(ArticleModel.CATEGORYID, SqlWhere.Oper.Equal, "4"));
articleList2 = bll_article.GetList(1, 5, fieldList, sqlWhereList, null);
// 精彩视频
fieldList.Clear();
fieldList.Add(ArticleModel.PKID);
fieldList.Add(ArticleModel.TITLE);
fieldList.Add(ArticleModel.PIC);
fieldList.Add(ArticleModel.FILES);
fieldList.Add(ArticleModel.PUBDATE);
fieldList.Add(ArticleModel.ISORT);
fieldList.Add(ArticleModel.ISTOP);
fieldList.Add(ArticleModel.CREATETIME);
sqlWhereList.Clear();
sqlWhereList.Add(new SqlWhere(ArticleModel.ENABLED, SqlWhere.Oper.Equal, true));
sqlWhereList.Add(new SqlWhere(ArticleModel.CATEGORYID, SqlWhere.Oper.Equal, "8"));
articleList3 = bll_article.GetList(1, 10, fieldList, sqlWhereList, null);
//管理会计俱乐部
fieldList.Clear();
fieldList.Add(ArticleModel.PKID);
fieldList.Add(ArticleModel.TITLE);
fieldList.Add(ArticleModel.PIC);
fieldList.Add(ArticleModel.ISORT);
fieldList.Add(ArticleModel.ISTOP);
fieldList.Add(ArticleModel.FILES);
fieldList.Add(ArticleModel.PUBDATE);
fieldList.Add(ArticleModel.CREATETIME);
sqlWhereList.Clear();
sqlWhereList.Add(new SqlWhere(ArticleModel.ENABLED, SqlWhere.Oper.Equal, true));
sqlWhereList.Add(new SqlWhere(ArticleModel.CATEGORYID, SqlWhere.Oper.Equal, "15"));
articleList4 = bll_article.GetList(1, 8, fieldList, sqlWhereList, null);
//课程
sqlWhereList.Clear();
sqlWhereList.Add(new SqlWhere(CourseModel.ENABLED, SqlWhere.Oper.Equal, true));
CourseList = bll_course.GetList(1, 5, null, sqlWhereList, null);
// 业绩
//fieldList.Clear();
//fieldList.Add(ProductModel.PKID);
//fieldList.Add(ProductModel.TITLE);
//fieldList.Add(ProductModel.PIC);
//sqlWhereList.Clear();
//sqlWhereList.Add(new SqlWhere(ProductModel.ISHOT, SqlWhere.Oper.Equal, true));
//sqlWhereList.Add(new SqlWhere(ProductModel.ENABLED, SqlWhere.Oper.Equal, true));
//sqlWhereList.Add(new SqlWhere(ProductModel.CATEGORYID, SqlWhere.Oper.In, bll_category.GetIds("5")));
//productList1 = bll_product.GetList(1, 5, fieldList, sqlWhereList, null);
}