private void GridViewDataBind()
{
MyAspNetPager.PageSize = 18;
Int32 recordcount;
string sql = "SELECT * FROM T_NEWSBASE WHERE NODEID=37 and STATUS=" + this.rblStatus.SelectedValue;
if (!string.IsNullOrEmpty(txtTITLE.Text))
{
sql += " AND TITLE LIKE '%" + txtTITLE.Text + "%'";
}
if (!string.IsNullOrEmpty(txtCOPYRIGHT.Text))
{
sql += " AND COPYRIGHT LIKE '%" + txtCOPYRIGHT.Text + "%'";
}
if (!string.IsNullOrEmpty(txtAUTHOR.Text))
{
sql += " AND AUTHOR LIKE '%" + txtAUTHOR.Text + "%'";
}
sql += " ORDER BY ID DESC";
DataTable DT = Pages.GetPage(sql, MyAspNetPager.CurrentPageIndex, MyAspNetPager.PageSize, out recordcount);
GridViewNews.DataSource = DT;
GridViewNews.DataBind();
this.MyAspNetPager.RecordCount = recordcount;
MyAspNetPager.TextBeforeInputBox = "共" + this.MyAspNetPager.RecordCount + "条 转到第";
MyAspNetPager.TextAfterInputBox = "页";
this.lblRecordCount.Text = recordcount.ToString();
this.lblPageSize.Text = MyAspNetPager.CurrentPageIndex.ToString();
}
private void GridViewDataBind()
{
MyAspNetPager.PageSize = 18;
Int32 recordcount;
string sql = "SELECT * FROM T_PRODUCT WHERE 1=1 ";
if (!"".Equals(txtTITLE.Text.Trim()))
{
sql = sql + " AND PRONAME LIKE '%'" + txtTITLE.Text.Trim() + "%'";
}
if (!string.Equals(this.TxtCARCOLOR.SelectedValue, "null"))
{
sql = sql + " AND PROTYPE ='" + TxtCARCOLOR.SelectedValue + "'";
}
if (!string.Equals(this.rblStatus.SelectedValue, "null"))
{
sql = sql + " AND STATUS =" + rblStatus.SelectedValue;
}
sql = sql + " ORDER BY ID ASC";
DataTable DT = Pages.GetPage(sql, MyAspNetPager.CurrentPageIndex, MyAspNetPager.PageSize, out recordcount);
GridViewNews.DataSource = DT;
GridViewNews.DataBind();
this.MyAspNetPager.RecordCount = recordcount;
MyAspNetPager.TextBeforeInputBox = "共" + this.MyAspNetPager.RecordCount + "条 转到第";
MyAspNetPager.TextAfterInputBox = "页";
this.lblRecordCount.Text = recordcount.ToString();
this.lblPageSize.Text = MyAspNetPager.CurrentPageIndex.ToString();
}
private void GridViewDataBind()
{
MyAspNetPager.PageSize = 18;
Int32 recordcount;
string sql = "SELECT * FROM T_ADVERTISMENT WHERE ISDELETE='N' ";
if (!string.IsNullOrEmpty(txtTITLE.Text))
{
sql += " AND TITLE LIKE '%" + txtTITLE.Text + "%'";
}
if (ddlADVTYPE.SelectedValue != "00")
{
sql += " AND ADVTYPE LIKE '%" + ddlADVTYPE.SelectedValue + "%'";
}
if (ddlPOSITION.SelectedValue != "00")
{
sql += " AND POSITION LIKE '%" + ddlPOSITION.SelectedValue + "%'";
}
sql += " ORDER BY ID DESC";
DataTable DT = Pages.GetPage(sql, MyAspNetPager.CurrentPageIndex, MyAspNetPager.PageSize, out recordcount);
GridViewNews.DataSource = DT;
GridViewNews.DataBind();
this.MyAspNetPager.RecordCount = recordcount;
MyAspNetPager.TextBeforeInputBox = "共" + this.MyAspNetPager.RecordCount + "条 转到第";
MyAspNetPager.TextAfterInputBox = "页";
this.lblRecordCount.Text = recordcount.ToString();
this.lblPageSize.Text = MyAspNetPager.CurrentPageIndex.ToString();
}
protected void LoadNews()
{
DataTable dt = new DataTable();
dt = dal.SelectAllInformation();
GridViewNews.DataSource = dt;
GridViewNews.DataBind();
}
protected void btnAddNews_Click(object sender, EventArgs e)
{
int id = SqlData.getInstance().getMaxId("news") + 1;
String sqlstr = String.Format("INSERT INTO news(id, movie_id, reldate) VALUES ('{0:d}', '{1:s}', '{2:s}')",
id, getMovieId(), DateTime.Now.Date.ToShortDateString());
MyLog.v(sqlstr);
SqlData.getInstance().ExecuteSQL(sqlstr);
GridViewNews.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
DataColumn col = table.Columns.Add("Заглавие на новина");
DataColumn col1 = table.Columns.Add("Линк");
XmlTextRssReader = new XmlTextReader("http://www.btv.bg/rss__news");
XmlDocumentRss = new XmlDocument();
// Зареждане на XML съдържанието в XmlDocument
XmlDocumentRss.Load(XmlTextRssReader);
// Цикъл за проверка за <rss> tag
for (int i = 0; i < XmlDocumentRss.ChildNodes.Count; i++)
{
if (XmlDocumentRss.ChildNodes[i].Name == "rss")
{ // при намерен <rss> tag се зареждат данните за съответния таг и подтаговете му
XmlNodeRss = XmlDocumentRss.ChildNodes[i];
}
}
// Проверка, ако има намерени тагове в RSS да изпълнява следващите команди
if (XmlNodeRss.ChildNodes.Count != 0)
{ // Цикъл за проверка за <channel> tag
for (int i = 0; i < XmlNodeRss.ChildNodes.Count; i++)
{
if (XmlNodeRss.ChildNodes[i].Name == "channel")
{ // при намерен <channel> tag
nodeChannel = XmlNodeRss.ChildNodes[i];
}
}
// Попълване на данни за канала в етикетите
//lblTitle.Text = "Title: " + nodeChannel["title"].InnerText;
//lblLanguage.Text = "Language: " + nodeChannel["language"].InnerText;
//lblLink.Text = "Link: " + nodeChannel["link"].InnerText;
//lblDescription.Text = "Description: " + nodeChannel["description"].InnerText;
// Цикъл за попълване на заглавия и линкове към новините в GridView-то
for (int i = 0; i < nodeChannel.ChildNodes.Count; i++)
{
if (nodeChannel.ChildNodes[i].Name == "item")// Проверка само на новините
{
nodeItem = nodeChannel.ChildNodes[i];
// Създаване на ред в GridView-то, съдържащ информация за новините (заглавие и линк), взета от таговете
DataRow row = table.NewRow();
row[0] = nodeItem["title"].InnerText;
row[1] = nodeItem["link"].InnerText;
table.Rows.Add(row);
table.AcceptChanges();
GridViewNews.DataSource = table;
GridViewNews.DataBind();
}
}
}
}
private void bindData()
{
GridViewBlockTrade.DataSource = _BlockTrade;
GridViewBlockTrade.DataBind();
GridViewMarginTrade.DataSource = _MarginTrade;
GridViewMarginTrade.DataBind();
GridViewStrangeTrade.DataSource = _StrangeTrade;
GridViewStrangeTrade.DataBind();
GridViewRestrictStock.DataSource = _RestrictStock;
GridViewRestrictStock.DataBind();
GridViewIPOSEO.DataSource = _IPOSEO;
GridViewIPOSEO.DataBind();
GridViewNews.DataSource = _MarketNews;
GridViewNews.DataBind();
}
private void GridViewDataBind()
{
MyAspNetPager.PageSize = 18;
Int32 recordcount;
string sql = "SELECT * FROM T_NEWSBASE WHERE NODEID = 81";
if (!string.IsNullOrEmpty(txtTITLE.Text))
{
sql += " AND TITLE LIKE '%" + txtTITLE.Text + "%'";
}
DataTable DT = Pages.GetPage(sql, MyAspNetPager.CurrentPageIndex, MyAspNetPager.PageSize, out recordcount);
GridViewNews.DataSource = DT;
GridViewNews.DataBind();
this.MyAspNetPager.RecordCount = recordcount;
MyAspNetPager.TextBeforeInputBox = "共" + this.MyAspNetPager.RecordCount + "条 转到第";
MyAspNetPager.TextAfterInputBox = "页";
this.lblRecordCount.Text = recordcount.ToString();
this.lblPageSize.Text = MyAspNetPager.CurrentPageIndex.ToString();
}
protected void GridViewNews_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
LoadNews();
GridViewNews.PageIndex = e.NewPageIndex;
GridViewNews.DataBind();
}
