protected void btnThem_Click(object sender, EventArgs e)
{
string sql = "";
string drAn = drl.SelectedValue;
if (drl.SelectedValue == "")
{
drAn = "1";
}
if (GetSelectedRecord() == "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Thông Báo", "alert('Chưa chọn bài viết')", true);
}
else
{
if (Request.QueryString["id"] == null)
{
sql = "insert into tbl_baiviethot values('" + GetSelectedRecord() + "','" + drAn + "','" + DateTime.Now.ToString() + "')";
}
else
{
string sqlA = "select id from tbl_baiviethot where id_baiviet = " + Request.QueryString["id"];
int ann = Connection.AExcuteSQL(sqlA);
sql = "update tbl_baiviethot set id_baiviet = '" + GetSelectedRecord() + "', announcements = '" + drAn + "', inup = '" + DateTime.Now.ToString() + "' where id = " + ann;
}
if (Connection.ExcuteSQL(sql))
{
string sqlcount = "select count(*) from tbl_baiviethot";
int count = Connection.AExcuteSQL(sqlcount);
if (count > 10)
{
string d = "delete from tbl_baiviethot where id = (select top 1 id from tbl_baiviethot order by inup asc)";
Connection.ExcuteSQL(d);
}
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Thông Báo", "alert('Thành công!')", true);
Response.Redirect("frmBaiVietHot.aspx");
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Thông Báo", "alert('Đã xảy ra lỗi!')", true);
}
}
}
private void getLoaiHienThi()
{
if (drl.SelectedItem == null)
{
List <ListItem> items = new List <ListItem>();
drl.Items.Clear();
items.Add(new ListItem("Chọn Loại Hiển Thị", ""));
for (int i = 0; i < LoaiBaiVietHot.loaiBVH.Count(); i++)
{
items.Add(new ListItem(LoaiBaiVietHot.loaiBVH[i], (i + 1).ToString()));
}
drl.Items.AddRange(items.ToArray());
if (Request.QueryString["id"] != null)
{
string sqlA = "select announcements from tbl_baiviethot where id_baiviet = " + Request.QueryString["id"];
int ann = Connection.AExcuteSQL(sqlA);
drl.SelectedValue = ann.ToString();
}
}
}