protected void ddl_hsx2_SelectedIndexChanged(object sender, EventArgs e)
{
WSSDT.WSSDT dthoai = new WSSDT.WSSDT();
DataSet ds = new DataSet();
string idHSX = ddl_hsx2.SelectedValue.ToString();
string sql = "SELECT idDT, TenDT FROM DIENTHOAI WHERE ANHIEN=1 AND idHSX=" + idHSX;
//string sql = "SELECT idDT, TenDT FROM DIENTHOAI";
ds = dthoai.SelectQuery(sql);
DataTable dt = new DataTable();
dt = ds.Tables[0];
ListItem item;
ddl_dt2.Items.Clear();
item = new ListItem();
item.Value = "0";
item.Value = "-----Chọn Model-----";
ddl_dt2.Items.Add(item);
for (int i = 0; i < dt.Rows.Count; i++)
{
item = new ListItem();
item.Value = dt.Rows[i]["idDT"].ToString();
item.Text = dt.Rows[i]["TenDT"].ToString();
ddl_dt2.Items.Add(item);
}
}
public void ShowDienThoaiTrungCap()
{
WSSDT.WSSDT dtsc = new WSSDT.WSSDT();
DataSet ds = new DataSet();
ds = dtsc.SelectQuery("SELECT TOP 8 idDT, TenDT, TenHSX, Gia, HinhAnh FROM DIENTHOAI dt, HANGSANXUAT hsx WHERE dt.idHSX = hsx.idHSX AND dt.AnHien = 1 AND Gia < 7000000 AND Gia >= 4000000");
DienThoaiTrungCap.DataSource = ds;
DienThoaiTrungCap.DataBind();
}
public void ShowDienThoaiMoi()
{
WSSDT.WSSDT dtm = new WSSDT.WSSDT();
DataSet ds = new DataSet();
ds = dtm.SelectQuery("SELECT TOP 8 idDT, TenDT, TenHSX, Gia, HinhAnh FROM DIENTHOAI dt, HANGSANXUAT hsx WHERE dt.idHSX = hsx.idHSX AND dt.AnHien = 1");
DienThoaiMoiXuatHien.DataSource = ds;
DienThoaiMoiXuatHien.DataBind();
}
public void ShowDienThoaiMoi()
{
WSSDT.WSSDT dtm = new WSSDT.WSSDT();
DataSet ds = new DataSet();
ds = dtm.SelectQuery("SELECT TOP 8 idDT, TenDT, TenHSX, Gia, HinhAnh FROM DIENTHOAI dt, HANGSANXUAT hsx WHERE dt.idHSX = hsx.idHSX AND dt.AnHien = 1");
DienThoaiMoiXuatHien.DataSource = ds;
DienThoaiMoiXuatHien.DataBind();
}
public void ShowDienThoaiThongDung()
{
WSSDT.WSSDT dtsc = new WSSDT.WSSDT();
DataSet ds = new DataSet();
ds = dtsc.SelectQuery("SELECT TOP 8 idDT, TenDT, TenHSX, Gia, HinhAnh FROM DIENTHOAI dt, HANGSANXUAT hsx WHERE dt.idHSX = hsx.idHSX AND dt.AnHien = 1 AND Gia < 4000000");
DienThoaiThongDung.DataSource = ds;
DienThoaiThongDung.DataBind();
}
public void ShowTitleTenHSX()
{
string idHSX = Request.QueryString["idHSX"].ToString();
WSSDT.WSSDT dthsx = new WSSDT.WSSDT();
DataSet ds = new DataSet();
string sql = "SELECT TenHSX FROM HANGSANXUAT WHERE idHSX = " + idHSX ;
ds = dthsx.SelectQuery(sql);
TitleTenHSX.DataSource = ds;
TitleTenHSX.DataBind();
}
public void ShowTitleTenHSX()
{
string idHSX = Request.QueryString["idHSX"].ToString();
WSSDT.WSSDT dthsx = new WSSDT.WSSDT();
DataSet ds = new DataSet();
string sql = "SELECT TenHSX FROM HANGSANXUAT WHERE idHSX = " + idHSX;
ds = dthsx.SelectQuery(sql);
TitleTenHSX.DataSource = ds;
TitleTenHSX.DataBind();
}
public void ShowDienThoaiTheoHSX()
{
string idHSX = Request.QueryString["idHSX"].ToString() ;
if (idHSX == "")
{
idHSX = "4";
}
WSSDT.WSSDT dthsx = new WSSDT.WSSDT();
DataSet ds = new DataSet();
string sql = "SELECT TOP 10 idDT, TenDT, TenHSX, Gia, HinhAnh, MoTa FROM DIENTHOAI DT, HANGSANXUAT HSX WHERE DT.idHSX = HSX.idHSX AND DT.idHSX = " + idHSX + " AND DT.AnHien = 1";
ds = dthsx.SelectQuery(sql);
DienThoaiTheoHSX.DataSource = ds;
DienThoaiTheoHSX.DataBind();
}
public void ShowThongTinChiTiet()
{
string idDT = Request.QueryString["idDT"].ToString();
WSSDT.WSSDT dtct = new WSSDT.WSSDT();
DataSet ds = new DataSet();
string sql = "";
sql = "SELECT BaiViet ";
sql += "FROM THONGTINCHITIET ";
sql += "WHERE idDT = " + idDT;
//Response.Write(sql);
ds = dtct.SelectQuery(sql);
ThongTinChiTiet.DataSource = ds;
ThongTinChiTiet.DataBind();
}
public void ShowDienThoaiChiTiet()
{
string idDT = Request.QueryString["idDT"].ToString();
WSSDT.WSSDT dtct = new WSSDT.WSSDT();
DataSet ds = new DataSet();
string sql="";
sql = "SELECT idDT, TenDT, TenHSX, Gia, HinhAnh, MoTa, PhuKien, BaoHanh, KhuyenMai, NgayCapNhat ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX AND DT.idDT = " + idDT;
//Response.Write(sql);
ds = dtct.SelectQuery(sql);
DienThoaiChiTiet.DataSource = ds;
DienThoaiChiTiet.DataBind();
}
public void ShowTinhNangDienThoai()
{
string idDT = Request.QueryString["idDT"].ToString();
WSSDT.WSSDT dtct = new WSSDT.WSSDT();
DataSet ds = new DataSet();
string sql = "";
sql = "SELECT * ";
sql += "FROM TINHNANGDIENTHOAI ";
sql += "WHERE idDT = " + idDT;
//Response.Write(sql);
ds = dtct.SelectQuery(sql);
TinhNangDienThoai.DataSource = ds;
TinhNangDienThoai.DataBind();
}
public void ShowDienThoaiChiTiet()
{
string idDT = Request.QueryString["idDT"].ToString();
WSSDT.WSSDT dtct = new WSSDT.WSSDT();
DataSet ds = new DataSet();
string sql = "";
sql = "SELECT idDT, TenDT, TenHSX, Gia, HinhAnh, MoTa, PhuKien, BaoHanh, KhuyenMai, NgayCapNhat ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX AND DT.idDT = " + idDT;
//Response.Write(sql);
ds = dtct.SelectQuery(sql);
DienThoaiChiTiet.DataSource = ds;
DienThoaiChiTiet.DataBind();
}
public void ShowThongTinChiTiet()
{
string idDT = Request.QueryString["idDT"].ToString();
WSSDT.WSSDT dtct = new WSSDT.WSSDT();
DataSet ds = new DataSet();
string sql = "";
sql = "SELECT BaiViet ";
sql += "FROM THONGTINCHITIET ";
sql += "WHERE idDT = " + idDT;
//Response.Write(sql);
ds = dtct.SelectQuery(sql);
ThongTinChiTiet.DataSource = ds;
ThongTinChiTiet.DataBind();
}
public void ShowTinhNangDienThoai()
{
string idDT = Request.QueryString["idDT"].ToString();
WSSDT.WSSDT dtct = new WSSDT.WSSDT();
DataSet ds = new DataSet();
string sql = "";
sql = "SELECT * ";
sql += "FROM TINHNANGDIENTHOAI ";
sql += "WHERE idDT = " + idDT;
//Response.Write(sql);
ds = dtct.SelectQuery(sql);
TinhNangDienThoai.DataSource = ds;
TinhNangDienThoai.DataBind();
}
public void ShowDienThoaiDongGia()
{
string idDT = Request.QueryString["idDT"].ToString();
WSSDT.WSSDT dtdg = new WSSDT.WSSDT();
DataSet ds = new DataSet();
string sql = "";
sql = "SELECT idDT, TenDT, Gia ";
sql += "FROM DIENTHOAI ";
sql += "WHERE Gia >= ((SELECT Gia FROM DIENTHOAI WHERE idDT = " + idDT + ") - 1000000) ";
sql += "AND Gia <= ((SELECT Gia FROM DIENTHOAI WHERE idDT = " + idDT + ") + 1000000)";
//Response.Write(sql);
ds = dtdg.SelectQuery(sql);
DienThoaiDongGia.DataSource = ds;
DienThoaiDongGia.DataBind();
}
public void ShowDienThoaiDongGia()
{
string idDT = Request.QueryString["idDT"].ToString();
WSSDT.WSSDT dtdg = new WSSDT.WSSDT();
DataSet ds = new DataSet();
string sql = "";
sql = "SELECT idDT, TenDT, Gia ";
sql += "FROM DIENTHOAI ";
sql += "WHERE Gia >= ((SELECT Gia FROM DIENTHOAI WHERE idDT = " + idDT + ") - 1000000) ";
sql += "AND Gia <= ((SELECT Gia FROM DIENTHOAI WHERE idDT = " + idDT + ") + 1000000)";
//Response.Write(sql);
ds = dtdg.SelectQuery(sql);
DienThoaiDongGia.DataSource = ds;
DienThoaiDongGia.DataBind();
}
public void ShowDienThoaiTheoHSX()
{
string idHSX = Request.QueryString["idHSX"].ToString();
if (idHSX == "")
{
idHSX = "4";
}
WSSDT.WSSDT dthsx = new WSSDT.WSSDT();
DataSet ds = new DataSet();
string sql = "SELECT TOP 10 idDT, TenDT, TenHSX, Gia, HinhAnh, MoTa FROM DIENTHOAI DT, HANGSANXUAT HSX WHERE DT.idHSX = HSX.idHSX AND DT.idHSX = " + idHSX + " AND DT.AnHien = 1";
ds = dthsx.SelectQuery(sql);
DienThoaiTheoHSX.DataSource = ds;
DienThoaiTheoHSX.DataBind();
}
public void ShowHSX()
{
WSSDT.WSSDT hsxss = new WSSDT.WSSDT();
DataSet ds = new DataSet();
ds = hsxss.SelectQuery("SELECT idHSX, TenHSX FROM HANGSANXUAT WHERE ANHIEN=1");
DataTable dt = new DataTable();
dt = ds.Tables[0];
ListItem item;
for (int i = 0; i < dt.Rows.Count; i++)
{
item = new ListItem();
item.Value = dt.Rows[i]["idHSX"].ToString();
item.Text = dt.Rows[i]["TenHSX"].ToString();
ddl_hsx1.Items.Add(item);
ddl_hsx2.Items.Add(item);
ddl_hsx3.Items.Add(item);
}
}
public void ShowHSX()
{
WSSDT.WSSDT hsxss = new WSSDT.WSSDT();
DataSet ds = new DataSet();
ds = hsxss.SelectQuery("SELECT idHSX, TenHSX FROM HANGSANXUAT WHERE ANHIEN=1");
DataTable dt = new DataTable();
dt = ds.Tables[0];
ListItem item;
for (int i = 0; i < dt.Rows.Count; i++)
{
item = new ListItem();
item.Value = dt.Rows[i]["idHSX"].ToString();
item.Text = dt.Rows[i]["TenHSX"].ToString();
ddl_hsx1.Items.Add(item);
ddl_hsx2.Items.Add(item);
ddl_hsx3.Items.Add(item);
}
}
public void ShowSoSanhDienThoai3()
{
string idDT3 = ddl_dt3.SelectedValue.ToString();
WSSDT.WSSDT ssdt = new WSSDT.WSSDT();
DataSet ds = new DataSet();
string sql = "";
sql = "SELECT DT.idDT, TenHSX, TenDT, Gia, HinhAnh, Mang2G, Mang3G, Sim, KichThuoc, TrongLuong, ";
sql += "MauSac, LoaimanHinh, KichThuocManHinh, Audio, Video, Radio, KieuChuong, ";
sql += "LoaNgoai, BoNhoTrong, TheNho, Wlan, GPRS, HSPDA, Bluetooth, USB, GPS, Jack35, ";
sql += "CameraChinh, ChucNang, CameraPhu, QuayPhim, TinNhan, TrinhDuyet, HeDieuHanh, ";
sql += "CPU, Chipset, GPU, JAVA, TroChoi, LoaiPin, ThoiGianCho, ThoiGianHoatDong, Khac ";
sql += "FROM DIENTHOAI dt, HANGSANXUAT hsx, TINHNANGDIENTHOAI tndt ";
sql += "WHERE dt.idHSX = hsx.idHSX AND dt.idDT = tndt.idDT AND DT.idDT = " + idDT3;
//Response.Write(sql);
ds = ssdt.SelectQuery(sql);
DataTable dt = new DataTable();
dt = ds.Tables[0];
ltr_TenDT3.Text = dt.Rows[0]["TenDT"].ToString();
img_HinhAnh3.ImageUrl = "images/" + dt.Rows[0]["TenHSX"] + "/" + dt.Rows[0]["HinhAnh"];
ltr_Gia3.Text = dt.Rows[0]["Gia"].ToString() + "VNĐ";
ltr_Mang2G3.Text = dt.Rows[0]["Mang2G"].ToString();
ltr_Mang3G3.Text = dt.Rows[0]["Mang3G"].ToString();
ltr_Sim3.Text = dt.Rows[0]["Sim"].ToString();
ltr_KichThuoc3.Text = dt.Rows[0]["KichThuoc"].ToString();
ltr_TrongLuong3.Text = dt.Rows[0]["TrongLuong"].ToString();
ltr_MauSac3.Text = dt.Rows[0]["MauSac"].ToString();
ltr_LoaiManHinh3.Text = dt.Rows[0]["LoaiManHinh"].ToString();
ltr_KichThuocManHinh3.Text = dt.Rows[0]["KichThuocManHinh"].ToString();
ltr_Audio3.Text = dt.Rows[0]["Audio"].ToString();
ltr_Video3.Text = dt.Rows[0]["Video"].ToString();
ltr_Radio3.Text = dt.Rows[0]["Radio"].ToString();
ltr_KieuChuong3.Text = dt.Rows[0]["KieuChuong"].ToString();
ltr_LoaNgoai3.Text = dt.Rows[0]["LoaNgoai"].ToString();
ltr_BoNhoTrong3.Text = dt.Rows[0]["BoNhoTrong"].ToString();
ltr_TheNho3.Text = dt.Rows[0]["TheNho"].ToString();
ltr_Wlan3.Text = dt.Rows[0]["Wlan"].ToString();
ltr_GPRS3.Text = dt.Rows[0]["GPRS"].ToString();
ltr_HSPDA3.Text = dt.Rows[0]["HSPDA"].ToString();
ltr_Bluetooth3.Text = dt.Rows[0]["Bluetooth"].ToString();
ltr_USB3.Text = dt.Rows[0]["USB"].ToString();
ltr_GPS3.Text = dt.Rows[0]["GPS"].ToString();
ltr_Jack353.Text = dt.Rows[0]["Jack35"].ToString();
ltr_CameraChinh3.Text = dt.Rows[0]["CameraChinh"].ToString();
ltr_ChucNang3.Text = dt.Rows[0]["ChucNang"].ToString();
ltr_CameraPhu3.Text = dt.Rows[0]["CameraPhu"].ToString();
ltr_QuayPhim3.Text = dt.Rows[0]["QuayPhim"].ToString();
ltr_TinNhan3.Text = dt.Rows[0]["TinNhan"].ToString();
ltr_TrinhDuyet3.Text = dt.Rows[0]["TrinhDuyet"].ToString();
ltr_HeDieuHanh3.Text = dt.Rows[0]["HeDieuHanh"].ToString();
ltr_CPU3.Text = dt.Rows[0]["CPU"].ToString();
ltr_Chipset3.Text = dt.Rows[0]["Chipset"].ToString();
ltr_GPU3.Text = dt.Rows[0]["GPU"].ToString();
ltr_JAVA3.Text = dt.Rows[0]["JAVA"].ToString();
ltr_TroChoi3.Text = dt.Rows[0]["TroChoi"].ToString();
ltr_LoaiPin3.Text = dt.Rows[0]["LoaiPin"].ToString();
ltr_ThoiGianCho3.Text = dt.Rows[0]["ThoiGianCho"].ToString();
ltr_ThoiGianHoatDong3.Text = dt.Rows[0]["ThoiGianHoatDong"].ToString();
ltr_Khac3.Text = dt.Rows[0]["Khac"].ToString();
}
public void ShowTimKiemDienThoai()
{
string idhsx = Request.QueryString["idhsx"].ToString();
string keyword = Request.QueryString["keyword"].ToString();
string price1 = Request.QueryString["price1"].ToString();
string price2 = Request.QueryString["price2"].ToString();
string sql = "";
if (idhsx == "0")
{
if (keyword != "" && price1 == "-1" && price2 == "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX AND TenDT LIKE '%" + keyword + "%' ";
sql += "ORDER BY Gia";
}
if (keyword != "" && price1 != "-1" && price2 != "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX AND TenDT LIKE '%" + keyword + "%' ";
sql += "AND Gia >= '" + price1 + "' AND Gia <= '" + price2 + "' ";
sql += "ORDER BY Gia";
}
if (keyword != "" && price1 != "-1" && price2 == "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND TenDT LIKE '%" + keyword + "%' ";
sql += "AND Gia >= '" + price1 + "' ";
sql += "ORDER BY Gia";
}
if (keyword != "" && price1 == "-1" && price2 != "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND TenDT LIKE '%" + keyword + "%' ";
sql += "AND Gia <= '" + price2 + "' ";
sql += "ORDER BY Gia";
}
if (keyword == "" && price1 != "-1" && price2 != "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND Gia >= '" + price1 + "' AND Gia <= '" + price2 + "' ";
sql += "ORDER BY Gia";
}
if (keyword == "" && price1 != "-1" && price2 == "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND Gia >= '" + price1 + "' ";
sql += "ORDER BY Gia";
}
if (keyword == "" && price1 == "-1" && price2 != "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND Gia <= '" + price2 + "' ";
sql += "ORDER BY Gia";
}
}
else
{
if (keyword != "" && price1 == "-1" && price2 == "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX AND TenDT LIKE '%" + keyword + "%' ";
sql += "AND DT.idHSX = '" + idhsx + "' ";
sql += "ORDER BY Gia";
}
if (keyword != "" && price1 != "-1" && price2 != "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX AND TenDT LIKE '%" + keyword + "%' ";
sql += "AND Gia >= '" + price1 + "' AND Gia <= '" + price2 + "' ";
sql += "AND DT.idHSX = '" + idhsx + "' ";
sql += "ORDER BY Gia";
}
if (keyword != "" && price1 != "-1" && price2 == "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND TenDT LIKE '%" + keyword + "%' ";
sql += "AND Gia >= '" + price1 + "' ";
sql += "AND DT.idHSX = '" + idhsx + "' ";
sql += "ORDER BY Gia";
}
if (keyword != "" && price1 == "-1" && price2 != "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND TenDT LIKE '%" + keyword + "%' ";
sql += "AND Gia <= '" + price2 + "' ";
sql += "AND DT.idHSX = '" + idhsx + "' ";
sql += "ORDER BY Gia";
}
if (keyword == "" && price1 != "-1" && price2 != "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND Gia >= '" + price1 + "' AND Gia <= '" + price2 + "' ";
sql += "AND DT.idHSX = '" + idhsx + "' ";
sql += "ORDER BY Gia";
}
if (keyword == "" && price1 != "-1" && price2 == "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND Gia >= '" + price1 + "' ";
sql += "AND DT.idHSX = '" + idhsx + "' ";
sql += "ORDER BY Gia";
}
if (keyword == "" && price1 == "-1" && price2 != "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND Gia <= '" + price2 + "' ";
sql += "AND DT.idHSX = '" + idhsx + "' ";
sql += "ORDER BY Gia";
}
if (keyword == "" && price1 == "-1" && price2 == "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND DT.idHSX = '" + idhsx + "' ";
sql += "ORDER BY Gia";
}
}
WSSDT.WSSDT search = new WSSDT.WSSDT();
DataSet ds = new DataSet();
//Response.Write(sql);
ds = search.SelectQuery(sql);
TimKiemDienThoai.DataSource = ds;
TimKiemDienThoai.DataBind();
}
protected void ddl_hsx3_SelectedIndexChanged(object sender, EventArgs e)
{
WSSDT.WSSDT dthoai = new WSSDT.WSSDT();
DataSet ds = new DataSet();
string idHSX = ddl_hsx3.SelectedValue.ToString();
string sql = "SELECT idDT, TenDT FROM DIENTHOAI WHERE ANHIEN=1 AND idHSX=" + idHSX;
//string sql = "SELECT idDT, TenDT FROM DIENTHOAI";
ds = dthoai.SelectQuery(sql);
DataTable dt = new DataTable();
dt = ds.Tables[0];
ListItem item;
ddl_dt3.Items.Clear();
item = new ListItem();
item.Value = "0";
item.Value = "-----Chọn Model-----";
ddl_dt3.Items.Add(item);
for (int i = 0; i < dt.Rows.Count; i++)
{
item = new ListItem();
item.Value = dt.Rows[i]["idDT"].ToString();
item.Text = dt.Rows[i]["TenDT"].ToString();
ddl_dt3.Items.Add(item);
}
}
public void ShowSoSanhDienThoai1(string idDT1)
{
if (idDT1 == "0")
{
return;
}
WSSDT.WSSDT ssdt = new WSSDT.WSSDT();
DataSet ds = new DataSet();
string sql = "";
sql = "SELECT DT.idDT, TenHSX, TenDT, Gia, HinhAnh, Mang2G, Mang3G, Sim, KichThuoc, TrongLuong, ";
sql += "MauSac, LoaimanHinh, KichThuocManHinh, Audio, Video, Radio, KieuChuong, ";
sql += "LoaNgoai, BoNhoTrong, TheNho, Wlan, GPRS, HSPDA, Bluetooth, USB, GPS, Jack35, ";
sql += "CameraChinh, ChucNang, CameraPhu, QuayPhim, TinNhan, TrinhDuyet, HeDieuHanh, ";
sql += "CPU, Chipset, GPU, JAVA, TroChoi, LoaiPin, ThoiGianCho, ThoiGianHoatDong, Khac ";
sql += "FROM DIENTHOAI dt, HANGSANXUAT hsx, TINHNANGDIENTHOAI tndt ";
sql += "WHERE dt.idHSX = hsx.idHSX AND dt.idDT = tndt.idDT AND DT.idDT = " + idDT1;
//Response.Write(sql);
ds = ssdt.SelectQuery(sql);
DataTable dt = new DataTable();
dt = ds.Tables[0];
ltr_TenDT1.Text = dt.Rows[0]["TenDT"].ToString();
img_HinhAnh1.ImageUrl = "images/" + dt.Rows[0]["TenHSX"] + "/" + dt.Rows[0]["HinhAnh"];
ltr_Gia1.Text = dt.Rows[0]["Gia"].ToString() + "VNĐ";
ltr_Mang2G1.Text = dt.Rows[0]["Mang2G"].ToString();
ltr_Mang3G1.Text = dt.Rows[0]["Mang3G"].ToString();
ltr_Sim1.Text = dt.Rows[0]["Sim"].ToString();
ltr_KichThuoc1.Text = dt.Rows[0]["KichThuoc"].ToString();
ltr_TrongLuong1.Text = dt.Rows[0]["TrongLuong"].ToString();
ltr_MauSac1.Text = dt.Rows[0]["MauSac"].ToString();
ltr_LoaiManHinh1.Text = dt.Rows[0]["LoaiManHinh"].ToString();
ltr_KichThuocManHinh1.Text = dt.Rows[0]["KichThuocManHinh"].ToString();
ltr_Audio1.Text = dt.Rows[0]["Audio"].ToString();
ltr_Video1.Text = dt.Rows[0]["Video"].ToString();
ltr_Radio1.Text = dt.Rows[0]["Radio"].ToString();
ltr_KieuChuong1.Text = dt.Rows[0]["KieuChuong"].ToString();
ltr_LoaNgoai1.Text = dt.Rows[0]["LoaNgoai"].ToString();
ltr_BoNhoTrong1.Text = dt.Rows[0]["BoNhoTrong"].ToString();
ltr_TheNho1.Text = dt.Rows[0]["TheNho"].ToString();
ltr_Wlan1.Text = dt.Rows[0]["Wlan"].ToString();
ltr_GPRS1.Text = dt.Rows[0]["GPRS"].ToString();
ltr_HSPDA1.Text = dt.Rows[0]["HSPDA"].ToString();
ltr_Bluetooth1.Text = dt.Rows[0]["Bluetooth"].ToString();
ltr_USB1.Text = dt.Rows[0]["USB"].ToString();
ltr_GPS1.Text = dt.Rows[0]["GPS"].ToString();
ltr_Jack351.Text = dt.Rows[0]["Jack35"].ToString();
ltr_CameraChinh1.Text = dt.Rows[0]["CameraChinh"].ToString();
ltr_ChucNang1.Text = dt.Rows[0]["ChucNang"].ToString();
ltr_CameraPhu1.Text = dt.Rows[0]["CameraPhu"].ToString();
ltr_QuayPhim1.Text = dt.Rows[0]["QuayPhim"].ToString();
ltr_TinNhan1.Text = dt.Rows[0]["TinNhan"].ToString();
ltr_TrinhDuyet1.Text = dt.Rows[0]["TrinhDuyet"].ToString();
ltr_HeDieuHanh1.Text = dt.Rows[0]["HeDieuHanh"].ToString();
ltr_CPU1.Text = dt.Rows[0]["CPU"].ToString();
ltr_Chipset1.Text = dt.Rows[0]["Chipset"].ToString();
ltr_GPU1.Text = dt.Rows[0]["GPU"].ToString();
ltr_JAVA1.Text = dt.Rows[0]["JAVA"].ToString();
ltr_TroChoi1.Text = dt.Rows[0]["TroChoi"].ToString();
ltr_LoaiPin1.Text = dt.Rows[0]["LoaiPin"].ToString();
ltr_ThoiGianCho1.Text = dt.Rows[0]["ThoiGianCho"].ToString();
ltr_ThoiGianHoatDong1.Text = dt.Rows[0]["ThoiGianHoatDong"].ToString();
ltr_Khac1.Text = dt.Rows[0]["Khac"].ToString();
}
public void ShowTimKiemDienThoai()
{
string idhsx = Request.QueryString["idhsx"].ToString();
string keyword = Request.QueryString["keyword"].ToString();
string price1 = Request.QueryString["price1"].ToString();
string price2 = Request.QueryString["price2"].ToString();
string sql = "";
if (idhsx == "0")
{
if (keyword != "" && price1 == "-1" && price2 == "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX AND TenDT LIKE '%" + keyword + "%' ";
sql += "ORDER BY Gia";
}
if (keyword != "" && price1 != "-1" && price2 != "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX AND TenDT LIKE '%" + keyword + "%' ";
sql += "AND Gia >= '" + price1 + "' AND Gia <= '" + price2 + "' ";
sql += "ORDER BY Gia";
}
if (keyword != "" && price1 != "-1" && price2 == "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND TenDT LIKE '%" + keyword + "%' ";
sql += "AND Gia >= '" + price1 + "' ";
sql += "ORDER BY Gia";
}
if (keyword != "" && price1 == "-1" && price2 != "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND TenDT LIKE '%" + keyword + "%' ";
sql += "AND Gia <= '" + price2 + "' ";
sql += "ORDER BY Gia";
}
if (keyword == "" && price1 != "-1" && price2 != "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND Gia >= '" + price1 + "' AND Gia <= '" + price2 + "' ";
sql += "ORDER BY Gia";
}
if (keyword == "" && price1 != "-1" && price2 == "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND Gia >= '" + price1 + "' ";
sql += "ORDER BY Gia";
}
if (keyword == "" && price1 == "-1" && price2 != "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND Gia <= '" + price2 + "' ";
sql += "ORDER BY Gia";
}
}
else
{
if (keyword != "" && price1 == "-1" && price2 == "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX AND TenDT LIKE '%" + keyword + "%' ";
sql += "AND DT.idHSX = '" + idhsx + "' ";
sql += "ORDER BY Gia";
}
if (keyword != "" && price1 != "-1" && price2 != "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX AND TenDT LIKE '%" + keyword + "%' ";
sql += "AND Gia >= '" + price1 + "' AND Gia <= '" + price2 + "' ";
sql += "AND DT.idHSX = '" + idhsx + "' ";
sql += "ORDER BY Gia";
}
if (keyword != "" && price1 != "-1" && price2 == "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND TenDT LIKE '%" + keyword + "%' ";
sql += "AND Gia >= '" + price1 + "' ";
sql += "AND DT.idHSX = '" + idhsx + "' ";
sql += "ORDER BY Gia";
}
if (keyword != "" && price1 == "-1" && price2 != "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND TenDT LIKE '%" + keyword + "%' ";
sql += "AND Gia <= '" + price2 + "' ";
sql += "AND DT.idHSX = '" + idhsx + "' ";
sql += "ORDER BY Gia";
}
if (keyword == "" && price1 != "-1" && price2 != "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND Gia >= '" + price1 + "' AND Gia <= '" + price2 + "' ";
sql += "AND DT.idHSX = '" + idhsx + "' ";
sql += "ORDER BY Gia";
}
if (keyword == "" && price1 != "-1" && price2 == "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND Gia >= '" + price1 + "' ";
sql += "AND DT.idHSX = '" + idhsx + "' ";
sql += "ORDER BY Gia";
}
if (keyword == "" && price1 == "-1" && price2 != "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND Gia <= '" + price2 + "' ";
sql += "AND DT.idHSX = '" + idhsx + "' ";
sql += "ORDER BY Gia";
}
if (keyword == "" && price1 == "-1" && price2 == "-1")
{
sql = "SELECT idDT, TenDT, TenHSX, HinhAnh, Gia, MoTa ";
sql += "FROM DIENTHOAI DT, HANGSANXUAT HSX ";
sql += "WHERE DT.idHSX = HSX.idHSX ";
sql += "AND DT.idHSX = '" + idhsx + "' ";
sql += "ORDER BY Gia";
}
}
WSSDT.WSSDT search = new WSSDT.WSSDT();
DataSet ds = new DataSet();
//Response.Write(sql);
ds = search.SelectQuery(sql);
TimKiemDienThoai.DataSource = ds;
TimKiemDienThoai.DataBind();
}