private void LoadData()
{
DataAccess da = new DataAccess();
DataSet ds = da.SelectByQuery("Select * from viewcuahang order by loaicuahangID");
//ds.Tables[0].Select("LoaiCuaHang <> " + type);
grdGianHang.DataSource = ds.Tables[0];
grdGianHang.DataBind();
}
private void ShowGianHangDamBao()
{
DataAccess da = new DataAccess();
string strSql = "Select * from viewsanpham where sanphamid <>" + int.Parse(ViewState["SanPhamID"].ToString())
+
(ddlKhuVuc.SelectedIndex == 0
? ""
: " and KhuVucID=" + ddlKhuVuc.Items[ddlKhuVuc.SelectedIndex].Value)
+ " AND sanphammauid=" + int.Parse(0 + ViewState["SanPhamMauID"].ToString()) +
" AND BaoDam <> 0 ORDER BY BaoDam desc, GiaSanPham, Diem DESC, TenCuaHang ";
DataSet ds = da.SelectByQuery(strSql);
tblGianHangDuocDamBao.Rows.Clear();
if (ds.Tables[0].Rows.Count > 0)
{
divGianHangDamBao.Style.Add("height", "100px");
lblGianHangDamBao.Visible = false;
for (int index = 0; index < ds.Tables[0].Rows.Count; index++)
{
lblGianHangDamBao.Visible = false;
DataRow dr = ds.Tables[0].Rows[index];
HtmlTableRow str = new HtmlTableRow();
HtmlTableCell std1 = new HtmlTableCell();
HtmlTableCell std2 = new HtmlTableCell();
HtmlTableCell std3 = new HtmlTableCell();
HtmlTableCell std4 = new HtmlTableCell();
HtmlTableCell std5 = new HtmlTableCell();
std1.Align = "center";
std1.Width = "5%";
std2.Align = "left";
std2.Style.Add("padding-left", "15px");
std2.Width = "13%";
std3.Width = "47%";
std3.Align = "Center";
std3.Style.Add("padding-right", "10px");
std4.Width = "20%";
std4.Align = "center";
std5.Width = "16%";
std5.Align = "center";
std1.Style.Add("border-right", "1pt solid");
std1.Style.Add("border-bottom", "1pt solid");
std2.Style.Add("border-right", "1pt solid");
std2.Style.Add("border-bottom", "1pt solid");
std3.Style.Add("border-right", "1pt solid");
std3.Style.Add("border-bottom", "1pt solid");
std4.Style.Add("border-right", "1pt solid");
std4.Style.Add("border-bottom", "1pt solid");
std5.Style.Add("border-right", "1pt solid");
std5.Style.Add("border-bottom", "1pt solid");
std1.InnerHtml = (index + 1).ToString();
std2.InnerHtml = "<img src=\"http://opi.yahoo.com/online?u=" + dr["YM"] + "&t=1\" border=\"0\">";
std3.InnerHtml = "<a href=\"./estore.aspx?sid=" + dr["CuaHangID"] + "\">" + dr["TenCuaHang"] +
"(" + dr["TenKhuVuc"] + ")</a>";
std4.InnerHtml = "<b>" +
String.Format("{0:0,0}", decimal.Parse("0" + dr["GiaSanPham"])).Replace(",", ".") +
" VNĐ </b>";
std5.InnerHtml = "<a href=\"./shoppingcart.aspx?spid=" + dr["SanPhamID"] +
"\"><img border=\"0\" src=\"./images/muahang.jpg\"></a>";
str.Cells.Add(std1);
str.Cells.Add(std2);
str.Cells.Add(std3);
str.Cells.Add(std4);
str.Cells.Add(std5);
tblGianHangDuocDamBao.Rows.Add(str);
}
}
else
{
divGianHangDamBao.Style.Add("height", "40px");
lblGianHangDamBao.Visible = true;
}
}
private void LoadTabContent02()
{
tblTraGiaContent.Visible = false;
tblHoiDap.Visible = false;
tblHoiDapContent.Visible = false;
tblCacCuaHang.Visible = true;
tblContent.Rows.Clear();
DataAccess da = new DataAccess();
string strSql = "Select * from viewsanpham where (sanphamid <>" + int.Parse(ViewState["SanPhamID"].ToString())
+
(ddlKhuVuc.SelectedIndex == 0
? ""
: " and KhuVucID=" + ddlKhuVuc.Items[ddlKhuVuc.SelectedIndex].Value)
+ " AND sanphammauid<>0 AND sanphammauid=" + int.Parse(0 + ViewState["SanPhamMauID"].ToString())
+ " OR (Lower(TenSanPham) = (select Lower(TenSanPham) from sanpham where sanphamid=" +
int.Parse(ViewState["SanPhamID"].ToString())
+ " AND NhomSanPhamID=(select nhomsanphamid from sanpham where sanphamid=" +
int.Parse(ViewState["SanPhamID"].ToString())
+ ")))) ORDER BY GiaSanPham, Diem DESC, TenCuaHang ";
DataSet ds = da.SelectByQuery(strSql);
if (ds.Tables[0].Rows.Count > 0)
{
lblCuaHangBan.Visible = false;
//string strThongTin = sds.Tables[0].Rows[0]["ThongTinSanPham"].ToString();
int countrow = tblcontencuahang.Rows.Count;
for (int j = 1; j < countrow; j++)
{
tblcontencuahang.Rows.Remove(tblcontencuahang.Rows[1]);
}
for (int index = 0; index < ds.Tables[0].Rows.Count; index++)
{
string GiaThapNhat = ds.Tables[0].Rows[0]["GiaSanPham"].ToString();
DataRow dr = ds.Tables[0].Rows[index];
string GiaHienTai = dr["GiaSanPham"].ToString();
HtmlTableRow str = new HtmlTableRow();
HtmlTableCell std1 = new HtmlTableCell();
HtmlTableCell std2 = new HtmlTableCell();
HtmlTableCell std3 = new HtmlTableCell();
HtmlTableCell std4 = new HtmlTableCell();
HtmlTableCell std5 = new HtmlTableCell();
std1.Align = "center";
std2.Align = "left";
std2.Style.Add("padding-left", "15px");
std3.Align = "right";
std3.Style.Add("padding-right", "10px");
std4.Align = "center";
std5.Align = "center";
std1.Style.Add("border-right", "1pt solid");
std1.Style.Add("border-bottom", "1pt solid");
std2.Style.Add("border-right", "1pt solid");
std2.Style.Add("border-bottom", "1pt solid");
std3.Style.Add("border-right", "1pt solid");
std3.Style.Add("border-bottom", "1pt solid");
std4.Style.Add("border-right", "1pt solid");
std4.Style.Add("border-bottom", "1pt solid");
std5.Style.Add("border-right", "1pt solid");
std5.Style.Add("border-bottom", "1pt solid");
std1.InnerHtml = (index + 1).ToString();
std2.InnerHtml = "<a href=\"./estore.aspx?sid=" + dr["CuaHangID"] + "\">" + dr["TenCuaHang"] + "</a>" +
"<br><a href=\"./shoppingcart.aspx?spid=" + dr["SanPhamID"] +
"\"><img border=\"0\" src=\"./images/muahang.jpg\"></a>" +
"<a href=\"ymsgr:sendIM?" + dr["YM"] + "\"><img src=\"http://opi.yahoo.com/online?u=" +
dr["YM"] + "&t=1\" border=\"0\"></a>";
std3.InnerHtml = "<b>" +
String.Format("{0:0,0}", decimal.Parse("0" + dr["GiaSanPham"])).Replace(",", ".") +
" VNĐ </b>";
if (GiaHienTai == GiaThapNhat)
std3.InnerHtml += "<br><font color=red>Giá thấp nhất</font>";
if (dr["NgayCapNhat"].ToString() != "")
{
std3.InnerHtml += "<br><b> Cập nhật: " +
DateTime.Parse(dr["NgayCapNhat"].ToString()).ToString("dd/MM/yyyy") +
" Lúc: " + DateTime.Parse(dr["NgayCapNhat"].ToString()).ToString("hh:mm") + "</b>";
}
else if (dr["NgayThemSanPham"].ToString() != "")
{
std3.InnerHtml += "<br><b> Cập nhật: " +
DateTime.Parse(dr["NgayThemSanPham"].ToString()).ToString("dd/MM/yyyy") +
" Lúc: " + DateTime.Parse(dr["NgayThemSanPham"].ToString()).ToString("hh:mm") +
"</b>";
}
//std4.InnerHtml = dr["diem"].ToString();
int sodiem = (int)decimal.Parse("0" + dr["diem"]);
for (int i = 0; i < sodiem; i++)
{
std4.InnerHtml += "<img align=\"absmiddle\" border=\"0\" src=\"./images/star1.gif\">";
}
for (int i = 10; i > sodiem; i--)
{
std4.InnerHtml += "<img align=\"absmiddle\" border=\"0\" src=\"./images/star0.gif\">";
}
std4.InnerHtml += string.Format("{0:0.0}", decimal.Parse("0" + dr["diem"]));
std4.InnerHtml += "<br><a href=#><img border=0 src=\"./images/poll.gif\">Đánh giá</a>";
std5.InnerHtml = dr["DiaChi"] + "<b>(" + dr["TenKhuVuc"] + "</b>)<br><b> Tel: </b>" +
dr["DienThoaiDiDong"];
str.Cells.Add(std1);
str.Cells.Add(std2);
str.Cells.Add(std3);
str.Cells.Add(std4);
str.Cells.Add(std5);
tblcontencuahang.Rows.Add(str);
}
}
else
{
lblCuaHangBan.Visible = true;
}
}
private void LoadData()
{
try
{
SanPham sanpham = new SanPham();
DataSet dsSanPham = sanpham.SelectByID(int.Parse(ViewState["SanPhamID"].ToString()));
if (dsSanPham.Tables[0].Rows.Count > 0)
{
DataRow drSanPham = dsSanPham.Tables[0].Rows[0];
string filename = Server.MapPath(drSanPham["AnhSanPham"].ToString());
Image image;
if (File.Exists(filename))
{
image = Image.FromFile(filename);
int srcWidth = image.Width;
int srcHeight = image.Height;
if (image.Width > 323)
{
Decimal sizeRatio = ((Decimal)srcHeight / srcWidth);
int thumbHeight = Decimal.ToInt32(sizeRatio * 323);
imgSanPham.Width = 323;
imgSanPham.Height = thumbHeight;
}
else if (image.Height > 323)
{
Decimal sizeRatio = ((Decimal)srcWidth / srcHeight);
int thumbWidth = Decimal.ToInt32(sizeRatio * 323);
imgSanPham.Height = 323;
imgSanPham.Width = thumbWidth;
}
else
{
imgSanPham.Height = srcHeight;
imgSanPham.Width = srcWidth;
}
}
imgSanPham.Src = drSanPham["AnhSanPham"].ToString();
lblTenSanPham.Text = drSanPham["TenSanPham"] + " " + drSanPham["TenSanPhamPhu"];
Title = lblTenSanPham.Text;
ViewState["TenGocSanPham"] = drSanPham["TenSanPham"].ToString();
lblProdName.Text = lblTenSanPham.Text;
divThongTinSanPham.InnerHtml += drSanPham["MoTaSanPham"].ToString().Replace("\r\n", "<br/>");
if (bool.Parse(drSanPham["KhuyenMai"].ToString()))
{
tblKhuyenMai.Visible = true;
divThongTinKhuyenMai.InnerHtml = drSanPham["MoTaKhuyenMai"].ToString();
}
else
{
tblKhuyenMai.Visible = false;
}
if (bool.Parse(drSanPham["GiamGia"].ToString()))
{
lbl2.Visible = true;
lblGiaMoi.Visible = true;
lbl3.Visible = true;
lbl1.Text = "Giá cũ: ";
lbl2.Text = "Giá mới: ";
lblGiaSanPham.Text = String.Format("{0:0,0}", drSanPham["GiaSanPham"]).Replace(",", ".");
lblGiaSanPham.Font.Strikeout = true;
lblGiaMoi.Text = String.Format("{0:0,0}", drSanPham["GiaKhuyenMai"]).Replace(",", ".");
lblGiaSanPhamTraGia.Text = String.Format("{0:0,0}", drSanPham["GiaKhuyenMai"]).Replace(",", ".");
}
else
{
lbl1.Text = "Giá sản phẩm";
lblGiaSanPham.Text = String.Format("{0:0,0}", drSanPham["GiaSanPham"]).Replace(",", ".");
lblGiaSanPhamTraGia.Text = String.Format("{0:0,0}", drSanPham["GiaSanPham"]).Replace(",", ".");
lbl2.Visible = false;
lblGiaMoi.Visible = false;
lbl3.Visible = false;
}
lblDonViTienTe.Text = "VNĐ";
lblMaSoSanPham.Text = drSanPham["MaSoSanPham"].ToString();
ShowLink(int.Parse(drSanPham["NhomSanPhamID"].ToString()));
ShowAnhSanPham();
ShowNhaCungCap(int.Parse(drSanPham["NguoiDungID"].ToString()));
ViewState["NguoiDungID"] = drSanPham["NguoiDungID"].ToString();
if (drSanPham["SanPhamMauID"].ToString() != "")
ViewState["SanPhamMauID"] = drSanPham["SanPhamMauID"].ToString();
ViewState["NhomSanPhamID"] = drSanPham["NhomSanPhamID"].ToString();
LoadSanPhamCungLoai(int.Parse(drSanPham["NhomSanPhamID"].ToString()));
if (!Page.IsPostBack)
{
AddSanPhamDaXem(dsSanPham.Tables[0]);
// bak3 la truong dung de luu so lan xem san pham
sanpham.UpdateFields(int.Parse(ViewState["SanPhamID"].ToString()), null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null,
int.Parse(drSanPham["bak3"].ToString()) + 1
, null, null, null, null, null, null, null);
}
ShowGianHangDamBao();
DataAccess da = new DataAccess();
string strSql =
"Select count(distinct cuahangid) as soluong from viewsanpham where ((Lower(TenSanPham) = (select Lower(TenSanPham) from sanpham where sanphamid=" +
int.Parse(ViewState["SanPhamID"].ToString()) +
")) OR ((sanphammauid <>0) and (sanphammauid=" + int.Parse(0 + ViewState["SanPhamMauID"].ToString()) +
")))";
DataSet dssch = da.SelectByQuery(strSql);
lblSoCuaHang.Text = dssch.Tables[0].Rows[0]["soluong"].ToString() != "0" ? dssch.Tables[0].Rows[0]["soluong"].ToString() : "1";
}
}
catch (Exception ex)
{
//Response.Redirect("Message.aspx?msg=" + ex.Message.Replace("\r\n"," "), false);
Response.Write(ex.ToString());
}
}
/*
private void SelectSanPhamData()
{
int intSanPhamID = int.Parse(ViewState["SanPhamID"].ToString());
SanPham sp = new SanPham();
DataSet ds = sp.SelectByID(intSanPhamID);
string strThongTinSP = ds.Tables[0].Rows[0]["ThongTinSanPham"].ToString();
NhanXetSanPham nx = new NhanXetSanPham();
DataTable dtNhanXet = nx.SelectBySanPhamID(intSanPhamID).Tables[0];
HoiDapSanPham hd = new HoiDapSanPham();
DataTable dtHoiDap = hd.SelectBySanPhamID(intSanPhamID).Tables[0];
TableRow tr = new TableRow();
TableCell td = new TableCell();
if (hidTabId.Value.Trim().Length > 0)
{
string content = "";
switch (hidTabId.Value)
{
case "1":
content += "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
content +=
"<tr><td width=\"12\"><img src=\"./images/left_tab.jpg\" width=\"12\" height=\"27\" /></td>";
content += "<td style=\"background-color:#AFAFAF;\" class=\"tab_active\">Thông tin sản phẩm</td>";
content +=
"<td width=\"12\"><img src=\"./images/right_tab.jpg\" width=\"12\" height=\"27\" /></td></tr></table>";
td.VerticalAlign = VerticalAlign.Bottom;
td.Text = content;
tr.Cells.Add(td);
//lblTab.Text = "Thông tin sản phẩm";
TableRow str = new TableRow();
TableCell std = new TableCell();
string scontent = "";
scontent = "";
scontent +=
"<table class=\"product\" width=\"100%\" border=\"0\" cellspacing=\"4\" cellpadding=\"0\">";
scontent += "<tr><td align=\"center\">" + strThongTinSP;
scontent += "</td></tr></table>";
std.Text = scontent;
std.Width = Unit.Percentage(16);
str.Cells.Add(std);
tblContent.Rows.Add(str);
break;
case "2":
content = "";
content += "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
content +=
"<tr><td width=\"12\"><img src=\"./images/left_tab.jpg\" width=\"12\" height=\"27\" /></td>";
content += "<td style=\"background-color:#AFAFAF;\" class=\"tab_active\">Các cửa hàng bán</td>";
content +=
"<td width=\"12\"><img src=\"./images/right_tab.jpg\" width=\"12\" height=\"27\" /></td></tr></table>";
td.VerticalAlign = VerticalAlign.Bottom;
td.Text = content;
tr.Cells.Add(td);
//lblTab.Text = "Hỏi Đáp";
break;
case "3":
content = "";
content += "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
content +=
"<tr><td width=\"12\"><img src=\"./images/left_tab.jpg\" width=\"12\" height=\"27\" /></td>";
content += "<td style=\"background-color:#AFAFAF;\" class=\"tab_active\">Hỏi đáp, phản hồi</td>";
content +=
"<td width=\"12\"><img src=\"./images/right_tab.jpg\" width=\"12\" height=\"27\" /></td></tr></table>";
td.VerticalAlign = VerticalAlign.Bottom;
td.Text = content;
tr.Cells.Add(td);
//lblTab.Text = "Nhận xét sản phẩm";
break;
case "4":
content = "";
content += "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
content +=
"<tr><td width=\"12\"><img src=\"./images/left_tab.jpg\" width=\"12\" height=\"27\" /></td>";
content += "<td style=\"background-color:#AFAFAF;\" class=\"tab_active\">Trả giá</td>";
content +=
"<td width=\"12\"><img src=\"./images/right_tab.jpg\" width=\"12\" height=\"27\" /></td></tr></table>";
td.VerticalAlign = VerticalAlign.Bottom;
td.Text = content;
tr.Cells.Add(td);
//lblTab.Text = "Nhận xét sản phẩm";
break;
}
}
else
{
td.Text = "Selected Tab parameter is misisng!";
tr.Cells.Add(td);
}
tblTab.Rows.Add(tr);
}
*/
private void ShowNhaCungCap(int id)
{
try
{
DataAccess da = new DataAccess();
string strSql = "Select * from viewcuahang where nguoidungid =" + id;
DataSet ds = da.SelectByQuery(strSql);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
lblNguoiBan.Text = dr["HoVaTen"].ToString();
//LoaiCuaHangID = dr["LoaiCuaHangID"];
lblNhaCungCap.Text = dr["TenCuaHang"].ToString();
lblDienThoaiCoDinh.Text = dr["DienThoaiCoDinh"].ToString();
lblDienThoaiDiDong.Text = dr["DienThoaiDiDong"].ToString();
lblDiemDanhGia.Text = string.Format("{0:0.0}", decimal.Parse("0" + dr["Diem"])).Replace(".", ",")
+ "(" + int.Parse("0" + dr["Solandanhgia"]) + ")";
//bak1 = YM
ViewState["YM"] = dr["YM"].ToString();
int DamBao = int.Parse("0" + dr["BaoDam"]);
pnlDamBao.Controls.Clear();
for (int i = 0; i < DamBao; i++)
{
HtmlImage img = new HtmlImage();
img.Src = "./images/kc.jpg";
img.Border = 0;
pnlDamBao.Controls.Add(img);
}
//CuaHang cuahang = new CuaHang();
//DataSet dsCuaHang = cuahang.SelectByNguoiDungID(id);
ViewState["CuaHangID"] = dr["CuaHangID"].ToString();
if (dr["LoaiCuaHangID"].ToString() == LoaiGianHang)
{
hrefLinkGianHang.HRef = "NewEstore.aspx?sid=" + ViewState["CuaHangID"].ToString();
}
else
{
hrefLinkGianHang.HRef = "Estore.aspx?sid=" + ViewState["CuaHangID"].ToString();
}
}
}
catch (Exception ex)
{
//Response.Redirect("Message.aspx?msg=" + ex.Message.Replace("\r\n", " "), false);
Response.Write(ex.ToString());
}
}
private void LoadThongTinCuaHang(int id)
{
try
{
pnlDamBao.Controls.Clear();
DataAccess da = new DataAccess();
string strSql = "Select * from viewcuahang where nguoidungid =" + id;
DataSet ds = da.SelectByQuery(strSql);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
lblDiemDanhGia.Text = string.Format("{0:0.0}", decimal.Parse("0" + dr["Diem"])).Replace(".", ",")
+ "(" + int.Parse("0" + dr["Solandanhgia"]) + ")";
int DamBao = int.Parse("0" + dr["BaoDam"]);
for (int i = 0; i < DamBao; i++)
{
HtmlImage img = new HtmlImage();
img.Src = "./images/kc.jpg";
img.Border = 0;
pnlDamBao.Controls.Add(img);
}
}
}
catch (Exception ex)
{
//Response.Redirect("Message.aspx?msg=" + ex.Message.Replace("\r\n", " "), false);
Response.Write(ex.ToString());
}
}