protected void Page_Load(object sender, EventArgs e) { // XỬ LÝ TIÊU ĐỀ CHO PAGE // string vmk_title_page = "THÔNG TIN"; string ten_cua_hang = ClassMain.Xu_Ly_Session("GET", "ten_cua_hang"); if (ten_cua_hang != null) { if (ten_cua_hang.Trim() != "") { vmk_title_page += " - " + ten_cua_hang; } } ContentPlaceHolder vmk_ContentPlaceHolder_for_title_page = (ContentPlaceHolder)this.Master.FindControl("vmk_ContentPlaceHolder_for_title_page"); vmk_ContentPlaceHolder_for_title_page.Controls.Add(new LiteralControl(vmk_title_page)); //// if (!IsPostBack) { // LẤY LOẠI TIN TỨC TỪ BIẾN TRUYỀN TRONG URL // string loai_tt = ""; if (Request.QueryString["loai"] != null && Request.QueryString["loai"].ToString() != "") { loai_tt = Request.QueryString["loai"].ToString().ToLower(); } // LẤY ID TIN TỨC TỪ BIẾN TRUYỀN TRONG URL // int id_tt = 0; if (Request.QueryString["id"] != null && Request.QueryString["id"].ToString() != "") { bool check_id_tt = int.TryParse(Request.QueryString["id"].ToString(), out id_tt); if (!check_id_tt) { id_tt = 0; } } // XỬ LÝ LOẠI TIN TỨC & ID TIN TỨC // string cau_lenh_sql = "select * from tin_tuc"; if (id_tt > 0) { cau_lenh_sql = "select top(1) id_tt, tieu_de, noi_dung, luot_xem, ngay_tt, thang_tt, nam_tt, ho_ten" + " from tin_tuc, thanh_vien" + " where tin_tuc.id_tv = thanh_vien.id_tv and id_tt = @id_tt and luu_nhap = 0" + " order by nam_tt desc, thang_tt desc, ngay_tt desc, id_tt desc" ; } else { if (loai_tt == "tintuc") { cau_lenh_sql = "select id_tt, tieu_de, noi_dung, luot_xem, ngay_tt, thang_tt, nam_tt, ho_ten" + " from tin_tuc, thanh_vien" + " where tin_tuc.id_tv = thanh_vien.id_tv and ky_thuat = 0 and luu_nhap = 0" + " order by nam_tt desc, thang_tt desc, ngay_tt desc, id_tt desc" ; this.Page.Title = "Tin Tức - " + this.Page.Title; label_tenloai.Text = "<a href='TinTuc.aspx?loai=TinTuc' style='color: #4285F4'>TIN TỨC</a>"; } else if (loai_tt == "kythuat") { cau_lenh_sql = "select id_tt, tieu_de, noi_dung, luot_xem, ngay_tt, thang_tt, nam_tt, ho_ten" + " from tin_tuc, thanh_vien" + " where tin_tuc.id_tv = thanh_vien.id_tv and ky_thuat = 1 and luu_nhap = 0" + " order by nam_tt desc, thang_tt desc, ngay_tt desc, id_tt desc" ; this.Page.Title = "Tin Kỹ Thuật - " + this.Page.Title; label_tenloai.Text = "<a href='TinTuc.aspx?loai=KyThuat' style='color: #4285F4'>TIN KỸ THUẬT</a>"; } else { Response.Redirect("Default.aspx"); return; } } // TIẾN HÀNH LẤY DỮ LIỆU TỪ CSDL // ClassCSDL vmk_csdl = new ClassCSDL(); vmk_csdl.sql_query = cau_lenh_sql; DataTable sql_param = vmk_csdl.sql_param; sql_param.Rows.Add("@id_tt", id_tt, SqlDbType.Int); vmk_csdl.sql_param = sql_param; DataTable BANG_KQ = vmk_csdl.VMK_SQL_SELECT(); if (BANG_KQ.Rows.Count == 0) { return; } // ĐƯA DỮ LIỆU LÊN GIAO DIỆN // if (id_tt > 0) { txt_id_tt.Value = HTML_Encode(BANG_KQ.Rows[0][0].ToString()); label_tieudebaiviet.Text = HTML_Encode(BANG_KQ.Rows[0][1].ToString()); label_noidungbaiviet.Text = ClassMain.Decode_BBCode(HTML_Encode(BANG_KQ.Rows[0][2], true)); Int64 luot_xem = Convert.ToInt64(BANG_KQ.Rows[0][3]); string ngay = BANG_KQ.Rows[0][4].ToString(); string thang = BANG_KQ.Rows[0][5].ToString(); string nam = BANG_KQ.Rows[0][6].ToString(); string ho_ten = BANG_KQ.Rows[0][7].ToString(); label_ngaythangnam.Text = Xu_Ly_Ngay_Thang_Nam(ngay, thang, nam); label_nguoidangtin.Text = ho_ten; label_solanxem.Text = luot_xem.ToString(); // CẬP NHẬT LƯỢT XEM // luot_xem += 1; ClassCSDL vmk_csdl1 = new ClassCSDL(); vmk_csdl1.sql_query = "update tin_tuc set luot_xem=@luot_xem where id_tt=@id_tt"; DataTable sql_param1 = vmk_csdl1.sql_param; sql_param1.Rows.Add("@luot_xem", luot_xem, SqlDbType.BigInt); sql_param1.Rows.Add("@id_tt", id_tt, SqlDbType.Int); vmk_csdl1.sql_param = sql_param1; int sql_status1 = vmk_csdl1.VMK_SQL_INSERT_DELETE_UPDATE(); } else { panel_nhieu_tintuc.Visible = true; panel_mot_tintuc.Visible = false; repeater_list_data.DataSource = BANG_KQ; repeater_list_data.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { // XỬ LÝ TIÊU ĐỀ CHO PAGE // string vmk_title_page = "SẢN PHẨM"; string ten_cua_hang = ClassMain.Xu_Ly_Session("GET", "ten_cua_hang"); if (ten_cua_hang != null) { if (ten_cua_hang.Trim() != "") { vmk_title_page += " - " + ten_cua_hang; } } ContentPlaceHolder vmk_ContentPlaceHolder_for_title_page = (ContentPlaceHolder)this.Master.FindControl("vmk_ContentPlaceHolder_for_title_page"); vmk_ContentPlaceHolder_for_title_page.Controls.Add(new LiteralControl(vmk_title_page)); //// if (!IsPostBack) { // LẤY ID DANH MỤC TỪ BIẾN TRUYỀN TRONG URL // int id_dm = 0; if (Request.QueryString["iddm"] != null && Request.QueryString["iddm"].ToString() != "") { bool check_id_dm = int.TryParse(Request.QueryString["iddm"].ToString(), out id_dm); if (!check_id_dm) { id_dm = 0; } } // LẤY ID SẢN PHẨM TỪ BIẾN TRUYỀN TRONG URL // int id_sp = 0; if (Request.QueryString["idsp"] != null && Request.QueryString["idsp"].ToString() != "") { bool check_id_sp = int.TryParse(Request.QueryString["idsp"].ToString(), out id_sp); if (!check_id_sp) { id_sp = 0; } } // XỬ LÝ DANH MỤC & ID SẢN PHẨM // string cau_lenh_sql = "select * from san_pham"; if (id_sp > 0) { cau_lenh_sql = "select top(1) id_sp, san_pham.id_dm, ten_dm, ten_sp, gioi_thieu, ngay_sp, thang_sp, nam_sp, don_gia, luot_xem, (select ten_dvt from don_vi_tinh where id_dvt = san_pham.id_dvt) as ten_dvt" + " from san_pham, danh_muc" + " where san_pham.id_dm = danh_muc.id_dm and id_sp = @id_sp" + " order by nam_sp desc, thang_sp desc, ngay_sp desc, id_sp desc" ; } else { if (id_dm > 0) { cau_lenh_sql = "select id_sp, san_pham.id_dm, ten_dm, ten_sp, gioi_thieu, ngay_sp, thang_sp, nam_sp, don_gia, luot_xem, (select ten_dvt from don_vi_tinh where id_dvt = san_pham.id_dvt) as ten_dvt" + " from san_pham, danh_muc" + " where (san_pham.id_dm = danh_muc.id_dm) and (san_pham.id_dm in (select id_dm from danh_muc where (id_dm = @id_dm) or (id_dm_cha = @id_dm)))" + " order by nam_sp desc, thang_sp desc, ngay_sp desc, id_sp desc" ; } else { Response.Redirect("Default.aspx"); return; } panel_nhieu_sanpham.Visible = true; panel_mot_sanpham.Visible = false; } // TIẾN HÀNH LẤY DỮ LIỆU TỪ CSDL // ClassCSDL vmk_csdl = new ClassCSDL(); vmk_csdl.sql_query = cau_lenh_sql; DataTable sql_param = vmk_csdl.sql_param; sql_param.Rows.Add("@id_sp", id_sp, SqlDbType.Int); sql_param.Rows.Add("@id_dm", id_dm, SqlDbType.Int); vmk_csdl.sql_param = sql_param; DataTable BANG_KQ = vmk_csdl.VMK_SQL_SELECT(); if (BANG_KQ.Rows.Count == 0) { // KHÔNG CÓ DỮ LIỆU return; } // ĐƯA DỮ LIỆU LÊN GIAO DIỆN // if (id_sp != 0) { hplink_themvaogiohang.NavigateUrl = hplink_themvaogiohang.NavigateUrl + BANG_KQ.Rows[0][0].ToString(); hplink_danh_muc.NavigateUrl = hplink_danh_muc.NavigateUrl + BANG_KQ.Rows[0][1].ToString(); label_tendanhmuc.Text = HTML_Encode(BANG_KQ.Rows[0][2].ToString()); label_tensp.Text = HTML_Encode(BANG_KQ.Rows[0][3].ToString()); label_gioithieu.Text = ClassMain.Decode_BBCode(HTML_Encode(BANG_KQ.Rows[0][4], true)); string ngay = BANG_KQ.Rows[0][5].ToString(); string thang = BANG_KQ.Rows[0][6].ToString(); string nam = BANG_KQ.Rows[0][7].ToString(); string don_gia = String.Format("{0:#,## vnđ}", BANG_KQ.Rows[0][8]); label_dongia.Text = don_gia; label_ngaythangnam.Text = Xu_Ly_Ngay_Thang_Nam(ngay, thang, nam); Int64 luot_xem = Convert.ToInt64(BANG_KQ.Rows[0][9]); label_solanxem.Text = luot_xem.ToString(); label_dvt.Text = HTML_Encode(BANG_KQ.Rows[0][10].ToString()); // CẬP NHẬT LƯỢT XEM // luot_xem += 1; ClassCSDL vmk_csdl1 = new ClassCSDL(); vmk_csdl1.sql_query = "update san_pham set luot_xem=@luot_xem where id_sp=@id_sp"; DataTable sql_param1 = vmk_csdl1.sql_param; sql_param1.Rows.Add("@luot_xem", luot_xem, SqlDbType.BigInt); sql_param1.Rows.Add("@id_sp", id_sp, SqlDbType.Int); vmk_csdl1.sql_param = sql_param1; int sql_status1 = vmk_csdl1.VMK_SQL_INSERT_DELETE_UPDATE(); } else { label_tendm.Text = HTML_Encode(BANG_KQ.Rows[0][2].ToString()); this.Page.Title = label_tendm.Text + " - " + this.Page.Title; repeater_list_data.DataSource = BANG_KQ; repeater_list_data.DataBind(); } } }