private void LoadDanhMuc()
{
try
{
NhomSanPham nsp = new NhomSanPham();
DataSet ds = nsp.SelectNhomSanPhamByNhomChaID(0);
ds.Tables[0].DefaultView.Sort = "SapXep ASC";
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
TableRow tr = new TableRow();
TableCell td = new TableCell();
td.Text = "<a href=\"maincategory.aspx?mcid=" + dr["NhomSanPhamID"] + "\">" + dr["TenNhomSanPham"] +
"</a>";
tr.Cells.Add(td);
tblDanhMuc.Rows.Add(tr);
}
}
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
int firstCatId = 0;
foreach (UltraGridRow row in grdCat.Rows)
{
int id = int.Parse(row.Cells.FromKey("NhomSanPhamID").Value.ToString());
NhomSanPham nsp = new NhomSanPham();
if (Request.QueryString["rid"] != null)
{
int rid = int.Parse(Request.QueryString["rid"]);
if (bool.Parse(row.Cells.FromKey("Selected").Text))
nsp.UpdateFields(id, null, null, null, null, null, null, null, null, null, null, rid);
else
nsp.UpdateFields(id, null, null, null, null, null, null, null, null, null, null, 0);
}
else
{
nsp.UpdateFields(id, null, null, null, bool.Parse(row.Cells.FromKey("Selected").Text), null, null, null,
null, null, null, null);
}
if (firstCatId == 0)
{
if (bool.Parse(row.Cells.FromKey("Selected").Text)) firstCatId = id;
}
}
Cache.Remove("dmnsp");
string strScript = "<script language='JavaScript'>" + "window.parent.RefreshProduct04(" + firstCatId +
");</script>";
ClientScript.RegisterStartupScript(GetType(), "Refresh", strScript);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Common.LoaiNguoiDungID() == 3)
{
if (!Page.IsPostBack)
{
if (Request.QueryString["mcid"] != null)
{
mcid = int.Parse(Request.QueryString["mcid"]);
}
LoadDanhMuc();
//LoadQuangCao11();
LoadQuangCao12();
LoadQuangCao13();
LoadSanPham11();
LoadSanPham12();
LoadSanPham13();
LoadSanPham14();
LoadGianHang();
NhomSanPham nsp = new NhomSanPham();
DataSet ds = nsp.SelectByID(mcid);
if (ds.Tables[0].Rows.Count == 1) lblDanhMuc.Text = ds.Tables[0].Rows[0]["TenNhomSanPham"].ToString();
hidCatId.Value = mcid.ToString();
}
else
{
mcid = int.Parse(hidCatId.Value);
}
}
else
{
Response.Redirect("../message.aspx?msg=Access denied");
}
}
private void LoadNhomSanPham(int nhomsanphamid)
{
NhomSanPham nsp = new NhomSanPham();
DataSet ds1 = nsp.SelectByID(nhomsanphamid);
if (ds1.Tables[0].Rows.Count > 0)
txtDanhMucSanPham.Text = ds1.Tables[0].Rows[0]["TenNhomSanPham"].ToString();
}
private void LoadDanhMuc(int CuaHangid, int NhomChaID)
{
NhomSanPham nsp = new NhomSanPham();
DataSet ds = nsp.SelectNhomSanPhamNotInCuaHangbyCuaHangID(CuaHangid, NhomChaID);
DataRow[] selectedRows = ds.Tables[0].Select("Show=true");
grdCat.DataSource = ds;
grdCat.DataBind();
//return selectedRows.Length;
}
private void BindToGrid()
{
NhomSanPham nsp = new NhomSanPham();
DataSet ds = nsp.SelectNhomSanPhamByCuaHangID(CuaHangID);
grvNhomSanPham.DataSource = ds.Tables[0];
grvNhomSanPham.DataBind();
}
protected void tmDanhMuc_Tick(object sender, EventArgs e)
{
NhomSanPham nsp = new NhomSanPham();
DataSet ds;
ds = nsp.SelectRanDomNhomSanPhamShowed();
if (Cache["dmnsp"] != null)
Cache.Remove("dmnsp");
Cache["dmnsp"] = ds;
LoadSanPham04();
}
protected void btnLuu_Click(object sender, EventArgs e)
{
try
{
if (Common.LoaiNguoiDungID() == 3)
{
NhomSanPham nhomsanpham = new NhomSanPham();
if (Request.QueryString["subid"] == null)
{
nhomsanpham.InsertFields(txtTenNhomCon.Text, null, Convert.ToInt32(Request.QueryString["id"]), false,
Convert.ToInt32(txtThuTu.Text), null, null, null, null, null, null);
}
else
{
nhomsanpham.UpdateFields(Convert.ToInt32(Request.QueryString["subid"]), txtTenNhomCon.Text, null,
Convert.ToInt32(Request.QueryString["id"]), null,
Convert.ToInt32(txtThuTu.Text), null, null, null, null, null, null);
}
}
else if (Common.LoaiNguoiDungID()==2)
{
NhomSanPhamCuaHang nhomsanpham = new NhomSanPhamCuaHang();
CuaHangNhomSanPham chnsp = new CuaHangNhomSanPham();
if (Request.QueryString["id"] == null)
{
int chnspid = chnsp.InsertFields(int.Parse(CuaHangID), int.Parse(ddlNhomSanPham.SelectedValue), null);
nhomsanpham.InsertFields(Convert.ToInt32(Request.QueryString["pid"]), int.Parse(ddlNhomSanPham.SelectedValue)
, Convert.ToInt32(txtThuTu.Text), int.Parse(CuaHangID), txtTenNhomCon.Text, chnspid);
}
else
{
NhomSanPhamCuaHang nsp = new NhomSanPhamCuaHang();
DataSet ds = nsp.SelectByID(int.Parse(Request["id"]));
int chnspid = int.Parse("0" + ds.Tables[0].Rows[0]["CuaHangNhomSanPhamID"].ToString());
//chnsp.UpdateFields();
nhomsanpham.UpdateFields(Convert.ToInt32(Request.QueryString["id"]),
null, int.Parse(ddlNhomSanPham.SelectedValue),
Convert.ToInt32(txtThuTu.Text), null, txtTenNhomCon.Text,null);
chnsp.UpdateFields(chnspid,int.Parse(CuaHangID),int.Parse(ddlNhomSanPham.SelectedValue),null);
}
}
string strScript = "<script language='JavaScript'>" + "window.parent.RefreshCat();</script>";
ClientScript.RegisterStartupScript(GetType(), "Refresh", strScript);
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
private int LoadDanhMuc()
{
NhomSanPham nsp = new NhomSanPham();
DataSet ds = nsp.SelectNhomSanPhamByNhomChaID(0);
DataRow[] selectedRows = ds.Tables[0].Select("Show=true");
ds.Tables[0].Columns.Add("Selected", Type.GetType("System.String"));
ds.Tables[0].Columns["Selected"].DefaultValue = "false";
for (int i = 0; i < selectedRows.Length; i++)
{
selectedRows[i]["Selected"] = "True";
}
grdCat.DataSource = ds;
grdCat.DataBind();
return selectedRows.Length;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["pcode"] != null)
{
promotion_code = Request.QueryString["pcode"];
if (Request.QueryString["cid"] != null)
{
try
{
catid = int.Parse(Request.QueryString["cid"]);
NhomSanPham nsp = new NhomSanPham();
DataSet ds = nsp.SelectByID(catid);
if (ds.Tables[0].Rows.Count >= 0)
{
lblCatName.Text = "> " + ds.Tables[0].Rows[0]["TenNhomSanPham"];
}
}
catch (Exception ex)
{
Response.Redirect("./message.aspx?msg=" + ex.Message);
}
}
}
else
{
Response.Redirect("./message.aspx?msg=Invalid parameter");
}
if (!Page.IsPostBack)
{
//LoadDanhMuc();
LoadMenu(0);
if (promotion_code == "moi" || promotion_code == "km" || promotion_code == "gg" || promotion_code == "uc")
{
if (Request.QueryString["cid"] != null)
{
LoadSanPham(promotion_code, catid, 1);
}
else
{
LoadSanPham(promotion_code, 0, 1);
}
}
else
{
Response.Redirect("./message.aspx?msg=Invalid parameter");
}
}
}
protected void btnLuu_Click(object sender, EventArgs e)
{
try
{
if (txtTenNhomSanPham.Text.Trim() != "")
{
if (Common.LoaiNguoiDungID() == 3)
{
NhomSanPham nhomsanpham = new NhomSanPham();
if (Request.QueryString["id"] == null)
{
nhomsanpham.InsertFields(txtTenNhomSanPham.Text, "", 0, false, Convert.ToInt32(txtThuTu.Text), null,
null, null, null, null, null);
}
else
{
nhomsanpham.UpdateFields(Convert.ToInt32(Request.QueryString["id"]),
txtTenNhomSanPham.Text, null, null, null, Convert.ToInt32(txtThuTu.Text),
null, null, null, null, null, null);
}
Cache.Remove("dm1");
}
else if (Common.LoaiNguoiDungID() == 2)
{
NhomSanPhamCuaHang nhomsanpham = new NhomSanPhamCuaHang();
if (Request.QueryString["id"] == null)
{
nhomsanpham.InsertFields( 0, 0, int.Parse("0" + txtThuTu.Text),int.Parse(cuahangid),txtTenNhomSanPham.Text,null);
}
else
{
nhomsanpham.UpdateFields(Convert.ToInt32(Request.QueryString["id"]),
null, null, int.Parse("0" + txtThuTu.Text), null, txtTenNhomSanPham.Text,null);
}
}
string strScript = "<script language='JavaScript'>" + "window.parent.RefreshCat();</script>";
ClientScript.RegisterStartupScript(GetType(), "Refresh", strScript);
}
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
protected void LoadDanhMuc3()
{
int index = ddlDanhMuc3.SelectedIndex;
ddlDanhMuc3.Items.Clear();
if (ddlDanhMuc2.SelectedIndex != 0)
{
NhomSanPham nsp = new NhomSanPham();
DataSet ds = nsp.SelectNhomSanPhamByNhomChaID(int.Parse(ddlDanhMuc2.SelectedValue));
ddlDanhMuc3.DataSource = ds.Tables[0];
ddlDanhMuc3.DataTextField = "TenNhomSanPham";
ddlDanhMuc3.DataValueField = "NhomSanPhamID";
ddlDanhMuc3.DataBind();
ddlDanhMuc3.Items.Insert(0, "Tất cả");
ddlDanhMuc3.Items[0].Value = "0";
}
if ((index > 0) && (index < ddlDanhMuc3.Items.Count))
{
ddlDanhMuc3.Items[index].Selected = true;
}
}
private void LoadUltraMenu()
{
NhomSanPham nsp = new NhomSanPham();
//get Nhomsanpham
DataSet ds;
if (Cache["Menu"] == null)
{
ds = nsp.SelectAllNhomSanPhamByLevel();
Cache["menu"] = ds;
}
else
{
ds = (DataSet) Cache["menu"];
}
ds.Relations.Add("menu", ds.Tables[0].Columns["NhomSanPhamID"],
ds.Tables[1].Columns["NhomChaID"], false);
ds.Relations.Add("menucon", ds.Tables[1].Columns["NhomSanPhamID"],
ds.Tables[2].Columns["NhomChaID"], false);
//ds.WriteXml(Server.MapPath("." + "\\menu.xml"), XmlWriteMode.WriteSchema);
//ds.WriteXml(Server.MapPath(".") + "\\menu.xml");
//
//DataView dv = ds1.Tables[0].DefaultView;
uwmMenu.DataSource = ds;
uwmMenu.Levels[0].ColumnName = "TenNhomSanPham";
// this.uwmMenu.Levels[i].LevelImage = "../../../ig_common/images/dir.png";
uwmMenu.Levels[0].RelationName = "menu";
uwmMenu.Levels[0].LevelKeyField = "NhomSanPhamID";
uwmMenu.Levels[0].TargetUrlName = "TargetUrl";
uwmMenu.Levels[1].ColumnName = "TenNhomSanPham";
// this.uwmMenu.Levels[i].LevelImage = "../../../ig_common/images/dir.png";
uwmMenu.Levels[1].RelationName = "menucon";
uwmMenu.Levels[1].LevelKeyField = "NhomSanPhamID";
uwmMenu.Levels[1].TargetUrlName = "TargetUrl";
uwmMenu.Levels[2].ColumnName = "TenNhomSanPham";
// this.uwmMenu.Levels[i].LevelImage = "../../../ig_common/images/dir.png";
//uwmMenu.Levels[1].RelationName = "con";
uwmMenu.Levels[2].TargetUrlName = "TargetUrl";
uwmMenu.Levels[2].LevelKeyField = "NhomSanPhamID";
uwmMenu.DataMember = ds.Tables[0].TableName;
uwmMenu.DataBind();
}
private void LoadSanPham04()
{
//LoadDanhMuc04
NhomSanPham nsp = new NhomSanPham();
DataSet ds = nsp.SelectNhomSanPhamByNhomChaID(0);
DataRow[] dr = ds.Tables[0].Select("Show=true");
int n = 4;
if (dr.Length < 4) n = dr.Length;
TableRow tr = new TableRow();
for (int i = 0; i < n; i++)
{
if ((!Page.IsPostBack && i == 0) || hidCatId.Value == "0")
hidCatId.Value = dr[0]["NhomSanPhamID"].ToString();
TableCell td = new TableCell();
td.Width = Unit.Percentage(100/n);
if (hidCatId.Value.Trim().Length > 0)
{
if (dr[i]["NhomSanPhamID"].ToString() == hidCatId.Value)
{
string 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=\"28\" /></td>";
content += "<td style=\"background-color:#AFAFAF;\" class=\"tab_active\">" + dr[i]["TenNhomSanPham"] +
"</td>";
content +=
"<td width=\"12\"><img src=\"./images/right_tab.jpg\" width=\"12\" height=\"28\" /></td></tr></table>";
td.VerticalAlign = VerticalAlign.Bottom;
td.Text = content;
tr.Cells.Add(td);
//LoadSanPham04
SanPham sp = new SanPham();
DataSet sds = sp.SelectSanPhamAtViTriSanPhamInNhomSanPhamID(4,
int.Parse(
dr[i]["NhomSanPhamID"].ToString()));
int sn = sds.Tables[0].Rows.Count;
for (int j = 0; j < 2; j++)
{
TableRow str = new TableRow();
for (int si = 0; si < 6; si++)
{
TableCell std = new TableCell();
string scontent = "";
if (j*6 + si < sn)
{
scontent +=
"<table class=\"product\" width=\"100%\" border=\"0\" cellspacing=\"4\" cellpadding=\"0\">";
scontent += "<tr><td align=\"center\"><a href=\"productdetail.aspx?id=" +
sds.Tables[0].Rows[j*6 + si]["SanPhamID"]
+ "\"><img src=\"" + sds.Tables[0].Rows[j*6 + si]["AnhSanPham"]
+
"\" alt=\"\" width=\"99\" height=\"89\" border=\"0\" style=\"border:#CCCCCC 1px solid\" /></a></td>";
scontent += "</tr><tr><td align=\"center\"><a href=\"productdetail.aspx?id=" +
sds.Tables[0].Rows[j*6 + si]["SanPhamID"]
+ "\">" + sds.Tables[0].Rows[j*6 + si]["TenSanPham"]
+ "</a><br />";
scontent += "Giá: <span class=\"price\">" +
String.Format("{0:0,0}", sds.Tables[0].Rows[j*6 + si]["GiaSanPham"]).Replace
(",", ".")
+ "</span><br/>" + sds.Tables[0].Rows[j*6 + si]["DonViTienTe"] +
"</td></tr></table>";
}
std.Text = scontent;
if (j == 0) std.Width = Unit.Percentage(16);
str.Cells.Add(std);
}
tblSanPham04.Rows.Add(str);
}
}
else
{
string content = "<a href=\"javascript:RefreshProduct04(" + dr[i]["NhomSanPhamID"] + ")\">" +
dr[i]["TenNhomSanPham"] + "</a>";
td.CssClass = "tab_noactive";
td.Text = content;
tr.Cells.Add(td);
}
}
else
{
td.Text = "Selected Tab parameter is misisng!";
tr.Cells.Add(td);
}
}
tblDanhMuc04.Rows.Add(tr);
}
private void LoadDanhMuc1()
{
NhomSanPham nsp = new NhomSanPham();
DataSet ds = nsp.SelectNhomSanPhamByNhomChaID(0);
ddlDanhMuc1.DataSource = ds.Tables[0];
ddlDanhMuc1.DataTextField = "TenNhomSanPham";
ddlDanhMuc1.DataValueField = "NhomSanPhamID";
ddlDanhMuc1.DataBind();
ddlDanhMuc1.Items.Insert(0, "Tất cả");
ddlDanhMuc1.Items[0].Value = "0";
if (Request.QueryString["cid"] != null)
{
ddlDanhMuc1.SelectedValue = Request.QueryString["cid"];
ddlDanhMuc1.Enabled = false;
}
else
ddlDanhMuc1.Enabled = true;
}
private void LoadDanhMuc(int NhomChaID, int loaddm)
{
loaddm++;
string sign = "";
switch (loaddm)
{
case 1:
sign = "";
break;
case 2:
sign = "++";
break;
case 3:
sign = "-----";
break;
case 4:
sign = "........";
break;
}
try
{
NhomSanPham nhomsanpham = new NhomSanPham();
DataSet ds = nhomsanpham.SelectNhomSanPhamByNhomChaID(NhomChaID);
ds.Tables[0].DefaultView.Sort = "SapXep ASC";
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
//if (dr["NhomChaID"].ToString() == "" || dr["NhomChaID"].ToString() == "0")
//{
HtmlTableRow tbr = new HtmlTableRow();
tbr.Style.Add("padding-left", (loaddm*15) + "px");
HtmlTableCell tbc1 = new HtmlTableCell();
HtmlTableCell tbc2 = new HtmlTableCell();
//image cells
HtmlTableCell tbc3 = new HtmlTableCell();
HtmlTableCell tbc4 = new HtmlTableCell();
HtmlTableCell tbc5 = new HtmlTableCell();
//tbc1.Style.Add("width", "1px");
tbc2.InnerText = sign + " " + dr["SapXep"] + "." + dr["TenNhomSanPham"];
tbc2.ColSpan = 2;
tbc3.Style.Add("width", "16px");
tbc4.Style.Add("width", "16px");
tbc5.Style.Add("width", "16px");
tbc3.Style.Add("padding", "0");
tbc3.Style.Add("margin", "0");
tbc3.Style.Add("cursor", "hand");
tbc4.Style.Add("padding", "0");
tbc4.Style.Add("margin", "0");
tbc4.Style.Add("cursor", "hand");
tbc5.Style.Add("padding", "0");
tbc5.Style.Add("margin", "0");
tbc5.Style.Add("cursor", "hand");
HtmlImage img1 = new HtmlImage();
HtmlImage img2 = new HtmlImage();
HtmlImage img3 = new HtmlImage();
img1.Src = "../images/edit.gif";
img2.Src = "../images/delete.gif";
img3.Src = "../images/add.gif";
img1.Alt = "Sửa danh mục cha";
img2.Alt = "Xóa danh mục cha";
img3.Alt = "Thêm danh mục con";
img1.Attributes.Add("onclick", "Edit(" + dr["NhomSanPhamID"] + ");");
img2.Attributes.Add("onclick", "Delete(" + dr["NhomSanPhamID"] + ");");
img3.Attributes.Add("onclick", "AddSub(" + dr["NhomSanPhamID"] + ",'" +
dr["TenNhomSanPham"] + "');");
tbc3.Controls.Add(img1);
tbc4.Controls.Add(img2);
if (loaddm < 3)
tbc5.Controls.Add(img3);
//tbr.Cells.Add(tbc1);
tbr.Cells.Add(tbc2);
tbr.Cells.Add(tbc3);
tbr.Cells.Add(tbc4);
tbr.Cells.Add(tbc5);
tblDanhMuc.Rows.Add(tbr);
LoadDanhMuc(int.Parse(dr["NhomSanPhamID"].ToString()), loaddm);
// }
}
}
// tblDanhMuc.Controls.Add(tbl);
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
private bool CheckNhomCon()
{
NhomSanPham nsp = new NhomSanPham();
DataSet ds = nsp.SelectNhomSanPhamByNhomChaID(
int.Parse("0" + ddlNhomSanPham.SelectedValue));
if (ds.Tables[0].Rows.Count > 0)
return false;
else
return true;
}
//private void LoadQuangCao41()
//{
//QuangCao qcao = new QuangCao();
//DataSet ds = qcao.SelectQuangCaoAtViTriQuangCaoByNguoiDungID(int.Parse(ViewState["NguoiDungID"].ToString()), 41);
//HtmlGenericControl spnQuangCao41 = (HtmlGenericControl)this.Master.FindControl("spnQuangCao01");
//if (ds.Tables[0].Rows.Count >= 1)
//{
// if (ds.Tables[0].Rows[0]["LoaiAnh"].ToString() == "FLASH")
// {
// spnQuangCao41.InnerHtml = "<object classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\""
// + "codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0\""
// + "width=\"210\" height=\"75\" title=\"Quang Cao\">"
// + "<param name=\"movie\" value=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"].ToString() + "\" />"
// + "<param name=\"quality\" value=\"high\" />"
// + "<embed src=\"." + ds.Tables[0].Rows[0]["DuongDanAnh"].ToString() + "\" quality=\"high\""
// + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\""
// + "width=\"210\" height=\"75\"></embed></object>";
// }
// else
// {
// spnQuangCao41.InnerHtml = "<a href=\"" + ds.Tables[0].Rows[0]["DuongDan"].ToString()
// + "\" target=\"_blank\"><img alt=\"" + ds.Tables[0].Rows[0]["NoiDungQuangCao"].ToString()
// + "\" src=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"].ToString() + "\" height=\"75px\" width=\"210px\" style=\"Border:none\"/></a>";
// }
//}
//else
//{
// spnQuangCao41.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"75px\" width=\"210px\" style=\"border:none\"/>";
//}
//}
//private void LoadQuangCao42()
//{
//QuangCao qcao = new QuangCao();
//DataSet ds = qcao.SelectQuangCaoAtViTriQuangCaoByNguoiDungID(int.Parse(ViewState["NguoiDungID"].ToString()), 42);
//int n = ds.Tables[0].Rows.Count;
//spnQuangCao42a.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"312px\" style=\"border:solid 1px #C9C3C3\"/>";
//spnQuangCao42b.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"312px\" style=\"border:solid 1px #C9C3C3\"/>";
//spnQuangCao42c.InnerHtml = "<img alt=\"Moi quang cao\" src=\"./images/advblank.jpg\" height=\"122px\" width=\"312px\" style=\"border:solid 1px #C9C3C3\"/>";
//if (n >= 1)
//{
// if (ds.Tables[0].Rows[0]["LoaiAnh"].ToString() == "FLASH")
// {
// spnQuangCao42a.InnerHtml = "<object style=\"border:solid 1px #C9C3C3\" classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\""
// + "codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0\""
// + "width=\"312\" height=\"122\" title=\"Quang Cao\">"
// + "<param name=\"movie\" value=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"].ToString() + "\" />"
// + "<param name=\"quality\" value=\"high\" />"
// + "<embed src=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"].ToString() + "\" quality=\"high\""
// + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\""
// + "width=\"312\" height=\"122\"></embed></object>";
// }
// else
// {
// spnQuangCao42a.InnerHtml = "<a href=\"" + ds.Tables[0].Rows[0]["DuongDan"].ToString()
// + "\" target=\"_blank\"><img alt=\"" + ds.Tables[0].Rows[0]["NoiDungQuangCao"].ToString()
// + "\" src=\"" + ds.Tables[0].Rows[0]["DuongDanAnh"].ToString() + "\" height=\"122px\" width=\"312px\" style=\"border:solid 1px #C9C3C3\"/></a>";
// }
// if (n >= 2)
// {
// if (ds.Tables[0].Rows[1]["LoaiAnh"].ToString() == "FLASH")
// {
// spnQuangCao42b.InnerHtml = "<object style=\"border:solid 1px #C9C3C3\" classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\""
// + "codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0\""
// + "width=\"312\" height=\"122\" title=\"Quang Cao\">"
// + "<param name=\"movie\" value=\"" + ds.Tables[0].Rows[1]["DuongDanAnh"].ToString() + "\" />"
// + "<param name=\"quality\" value=\"high\" />"
// + "<embed src=\"" + ds.Tables[0].Rows[1]["DuongDanAnh"].ToString() + "\" quality=\"high\""
// + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\""
// + "width=\"312\" height=\"122\"></embed></object>";
// }
// else
// {
// spnQuangCao42b.InnerHtml = "<a href=\"" + ds.Tables[0].Rows[1]["DuongDan"].ToString()
// + "\" target=\"_blank\"><img alt=\"" + ds.Tables[0].Rows[1]["NoiDungQuangCao"].ToString()
// + "\" src=\"" + ds.Tables[0].Rows[1]["DuongDanAnh"].ToString() + "\" height=\"122px\" width=\"312px\" style=\"border:solid 1px #C9C3C3\"/></a>";
// }
// if (n >= 3)
// {
// if (ds.Tables[0].Rows[2]["LoaiAnh"].ToString() == "FLASH")
// {
// spnQuangCao42c.InnerHtml = "<object style=\"border:solid 1px #C9C3C3\" classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\""
// + "codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0\""
// + "width=\"312\" height=\"122\" title=\"Quang Cao\">"
// + "<param name=\"movie\" value=\"" + ds.Tables[0].Rows[2]["DuongDanAnh"].ToString() + "\" />"
// + "<param name=\"quality\" value=\"high\" />"
// + "<embed src=\"" + ds.Tables[0].Rows[2]["DuongDanAnh"].ToString() + "\" quality=\"high\""
// + "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\""
// + "width=\"312\" height=\"122\"></embed></object>";
// }
// else
// {
// spnQuangCao42c.InnerHtml = "<a href=\"" + ds.Tables[0].Rows[2]["DuongDan"].ToString()
// + "\" target=\"_blank\"><img alt=\"" + ds.Tables[0].Rows[2]["NoiDungQuangCao"].ToString()
// + "\" src=\"" + ds.Tables[0].Rows[2]["DuongDanAnh"].ToString() + "\" height=\"122px\" width=\"312px\" style=\"border:solid 1px #C9C3C3\"/></a>";
// }
// }
// }
//}
//else
//{
// tblQuangCao42.Visible = false;
//}
//}
private void ShowLink(int NhomSanPhamId)
{
NhomSanPham nsp = new NhomSanPham();
DataSet ds2 = nsp.SelectByID(NhomSanPhamId);
if (ds2.Tables[0].Rows.Count == 1)
{
lblDanhMucCon.Text = ds2.Tables[0].Rows[0]["TenNhomSanPham"].ToString();
}
DataSet ds1 = nsp.SelectByID(int.Parse(ds2.Tables[0].Rows[0]["NhomChaID"].ToString()));
if (ds1.Tables[0].Rows.Count == 1)
{
lnkDanhMucCha.Text = ds1.Tables[0].Rows[0]["TenNhomSanPham"].ToString();
lnkDanhMucCha.PostBackUrl = "maincategory.aspx?mcid=" + ds2.Tables[0].Rows[0]["NhomChaID"];
lblArrow.Visible = true;
}
else
{
lblArrow.Visible = false;
}
}
private void LoadTreeItems(TreeNode tn, int NhomChaID)
{
NhomSanPham nsp = new NhomSanPham();
DataSet ds = nsp.SelectNhomSanPhamByNhomChaID(NhomChaID);
foreach (DataRow dr in ds.Tables[0].Rows)
{
TreeNode node = new TreeNode(dr["TenNhomSanPham"].ToString(), dr["NhomSanPhamID"].ToString());
LoadTreeItems(node, int.Parse(dr["NhomSanPhamID"].ToString()));
tn.ChildNodes.Add(node);
}
}
private void LoadData(string Id)
{
try
{
NhomSanPham nhomsanpham = new NhomSanPham();
DataSet ds = nhomsanpham.SelectByID(Convert.ToInt32(Id));
if (ds.Tables[0].Rows.Count > 0)
{
txtTenNhomCon.Text = ds.Tables[0].Rows[0]["TenNhomSanPham"].ToString();
txtThuTu.Text = ds.Tables[0].Rows[0]["SapXep"].ToString();
}
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
private void AddNhomSanPhamToCuaHang(int NhomSanPhamID, int CuaHangID)
{
CuaHangNhomSanPham chnsp = new CuaHangNhomSanPham();
DataSet dschnsp = chnsp.SelectByNhomSanPhamCuaHangID(CuaHangID, NhomSanPhamID);
if (dschnsp.Tables[0].Rows.Count <= 0)
{
chnsp.Insert(CuaHangID, NhomSanPhamID, "");
NhomSanPham nsp = new NhomSanPham();
DataSet ds = nsp.SelectByID(NhomSanPhamID);
int NhomChaID = int.Parse(ds.Tables[0].Rows[0]["NhomChaID"].ToString());
if (NhomChaID != 0)
AddNhomSanPhamToCuaHang(NhomChaID, CuaHangID);
}
}
private void LoadMenuItems(MenuItem mi, int NhomSanPhamID)
{
NhomSanPham nsp = new NhomSanPham();
DataSet ds = nsp.SelectNhomSanPhamByNhomChaID(NhomSanPhamID);
foreach (DataRow dr in ds.Tables[0].Rows)
{
MenuItem mni = new MenuItem(
dr["TenNhomSanPham"].ToString(), dr["NhomSanPhamID"].ToString());
LoadMenuItems(mni, int.Parse(dr["NhomSanPhamID"].ToString()));
mni.NavigateUrl = "promotion.aspx?pcode=" + promotion_code + "&cid=" +
dr["NhomSanPhamID"];
mi.ChildItems.Add(mni);
}
}
//protected override void OnLoad(EventArgs e)
//{
// base.OnLoad(e);
//}
private void LoadDanhMucCon(int NhomChaID, int loaddm)
{
NhomSanPham nhomsanpham = new NhomSanPham();
DataSet ds;
string cachNsp = "nsp" + NhomChaID;
if (Cache[cachNsp] == null)
{
ds = nhomsanpham.SelectNhomSanPhamByNhomChaID(NhomChaID);
Cache.Insert(cachNsp, ds);
}
else
{
ds = (DataSet) Cache[cachNsp];
}
if (NhomChaID == 0)
loaddm = 0;
string indent = "";
switch (loaddm)
{
case 0:
indent = "+ ";
break;
case 1:
indent = "+...";
break;
case 2:
indent = "+.....";
break;
case 3:
indent = "+.......";
break;
case 4:
indent = "+.........";
break;
}
int n = ddlNhomSanPham.SelectedIndex;
loaddm++;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ListItem item = new ListItem(indent + ds.Tables[0].Rows[i]["TenNhomSanPham"],
ds.Tables[0].Rows[i]["NhomSanPhamID"].ToString());
ddlNhomSanPham.Items.Add(item);
//item.Enabled = false;
LoadDanhMucCon(int.Parse(ds.Tables[0].Rows[i]["NhomSanPhamID"].ToString()), loaddm);
//item.Enabled = true;
}
}
private void LoadMenu(int NhomChaID)
{
try
{
NhomSanPham nsp = new NhomSanPham();
DataSet ds = nsp.SelectNhomSanPhamByNhomChaID(NhomChaID);
foreach (DataRow dr in ds.Tables[0].Rows)
{
MenuItem mni = new MenuItem(
dr["TenNhomSanPham"].ToString(), dr["NhomSanPhamID"].ToString());
LoadMenuItems(mni, int.Parse(dr["NhomSanPhamID"].ToString()));
mni.NavigateUrl = "promotion.aspx?pcode=" + promotion_code + "&cid=" +
dr["NhomSanPhamID"];
mnuNhomSanPham.Items.Add(mni);
;
}
}
catch (Exception ex)
{
Response.Redirect("../message.aspx?msg=" + ex.ToString().Replace("\r\n", ""));
}
}
private void LoadNhomSanPham()
{
NhomSanPham nhomsanpham = new NhomSanPham();
DataSet ds = nhomsanpham.SelectNhomSanPhamByNhomChaID(0);
ddlNhomSanPham.Items.Insert(0, "Danh mục sản phẩm");
ddlNhomSanPham.Items[0].Value = "0";
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ListItem item = new ListItem("+ " + ds.Tables[0].Rows[i]["TenNhomSanPham"],
ds.Tables[0].Rows[i]["NhomSanPhamID"].ToString());
ddlNhomSanPham.Items.Add(item);
DataSet subds =
nhomsanpham.SelectNhomSanPhamByNhomChaID(int.Parse(ds.Tables[0].Rows[i]["NhomSanPhamID"].ToString()));
for (int j = 0; j < subds.Tables[0].Rows.Count; j++)
{
ListItem subitem = new ListItem("+.... " + subds.Tables[0].Rows[j]["TenNhomSanPham"],
subds.Tables[0].Rows[j]["NhomSanPhamID"].ToString());
ddlNhomSanPham.Items.Add(subitem);
}
}
}
private void LoadDanhMuc()
{
NhomSanPham nsp = new NhomSanPham();
DataSet ds = nsp.SelectNhomSanPhamByNhomChaID(0);
ds.Tables[0].DefaultView.Sort = "SapXep ASC";
if (ds.Tables[0].Rows.Count > 0)
{
//Set default category
if (mcid == 0) mcid = int.Parse(ds.Tables[0].Rows[0]["NhomSanPhamID"].ToString());
foreach (DataRow dr in ds.Tables[0].Rows)
{
TableRow tr = new TableRow();
TableCell td = new TableCell();
td.Text = "<a href=\"cat1config.aspx?mcid=" + dr["NhomSanPhamID"] + "\">" + dr["TenNhomSanPham"] +
"</a>";
tr.Cells.Add(td);
tblDanhMuc.Rows.Add(tr);
}
}
}
private void LoadDanhMuc1()
{
NhomSanPham nsp = new NhomSanPham();
DataSet ds;
if (Cache["dm1"] == null)
{
ds = nsp.SelectNhomSanPhamByNhomChaID(0);
Cache.Insert("dm1", ds);
}
else
{
ds = (DataSet) Cache["dm1"];
}
ddlDanhMuc1.DataSource = ds.Tables[0];
ddlDanhMuc1.DataTextField = "TenNhomSanPham";
ddlDanhMuc1.DataValueField = "NhomSanPhamID";
ddlDanhMuc1.DataBind();
ddlDanhMuc1.Items.Insert(0, "Tất cả");
ddlDanhMuc1.Items[0].Value = "0";
}
private void LoadDanhMucConForDropDown(int NhomChaID, int CuaHangID, int loaddm)
{
NhomSanPham nsp = new NhomSanPham();
DataSet ds = nsp.SelectNhomSanPhamByNhomChaAndCuaHangID(CuaHangID, NhomChaID);
if (NhomChaID == 0)
loaddm = 0;
string indent = "";
switch (loaddm)
{
case 0:
indent = "+ ";
break;
case 1:
indent = "+...";
break;
case 2:
indent = "+.....";
break;
case 3:
indent = "+.......";
break;
case 4:
indent = "+.........";
break;
}
loaddm++;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
ListItem item = new ListItem(indent + ds.Tables[0].Rows[i]["TenNhomSanPham"],
ds.Tables[0].Rows[i]["NhomSanPhamID"].ToString());
ddlNhomSanPham.Items.Add(item);
//item.Enabled = false;
LoadDanhMucConForDropDown(int.Parse(ds.Tables[0].Rows[i]["NhomSanPhamID"].ToString()), CuaHangID, loaddm);
}
}
private void LoadDanhMuc(int mcid)
{
try
{
NhomSanPham nsp = new NhomSanPham();
DataSet ds = nsp.SelectNhomSanPhamByNhomChaID(0);
ds.Tables[0].DefaultView.Sort = "SapXep ASC";
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
TableRow tr = new TableRow();
TableCell td = new TableCell();
td.Text = "<a href=\"maincategory.aspx?mcid=" + dr["NhomSanPhamID"] + "\">" + dr["TenNhomSanPham"] +
"</a>";
tr.Cells.Add(td);
tblDanhMuc.Rows.Add(tr);
if (int.Parse(dr["NhomSanPhamID"].ToString()) == mcid)
{
//Danh muc con ;
DataSet sds = nsp.SelectNhomSanPhamByNhomChaID(mcid);
sds.Tables[0].DefaultView.Sort = "SapXep ASC";
if (sds.Tables[0].Rows.Count > 0)
{
foreach (DataRow sdr in sds.Tables[0].Rows)
{
TableRow str = new TableRow();
TableCell std = new TableCell();
std.Style.Value = "padding-left:20px";
std.Text = "<a href=\"subcategory.aspx?mcid=" + dr["NhomSanPhamID"] + "&scid=" +
sdr["NhomSanPhamID"] + "\">" + "+ " + sdr["TenNhomSanPham"] + "</a>";
str.Cells.Add(std);
tblDanhMuc.Rows.Add(str);
}
}
}
}
}
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
private void LoadDanhMuc()
{
try
{
NhomSanPham nhomsanpham = new NhomSanPham();
DataSet ds = nhomsanpham.SelectAll();
ds.Tables[0].DefaultView.Sort = "SapXep ASC";
//Table tbl = new Table();
// tbl.CssClass = "ListCat";
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["NhomChaID"].ToString() == "" || dr["NhomChaID"].ToString() == "0")
{
HtmlTableRow tbr = new HtmlTableRow();
//tbr.Style.Add("margin", "0");
//tbr.Style.Add("padding", "0");
//tbr.Style.Add("padding", "0");
HtmlTableCell tbc1 = new HtmlTableCell();
HtmlTableCell tbc2 = new HtmlTableCell();
//image cells
HtmlTableCell tbc3 = new HtmlTableCell();
HtmlTableCell tbc4 = new HtmlTableCell();
HtmlTableCell tbc5 = new HtmlTableCell();
tbc1.Style.Add("width", "3%");
tbc2.InnerText = dr["SapXep"] + "." + dr["TenNhomSanPham"];
tbc2.ColSpan = 2;
tbc3.Style.Add("width", "16px");
tbc4.Style.Add("width", "16px");
tbc5.Style.Add("width", "16px");
tbc3.Style.Add("padding", "0");
tbc3.Style.Add("margin", "0");
tbc3.Style.Add("cursor", "hand");
tbc4.Style.Add("padding", "0");
tbc4.Style.Add("margin", "0");
tbc4.Style.Add("cursor", "hand");
tbc5.Style.Add("padding", "0");
tbc5.Style.Add("margin", "0");
tbc5.Style.Add("cursor", "hand");
HtmlImage img1 = new HtmlImage();
HtmlImage img2 = new HtmlImage();
HtmlImage img3 = new HtmlImage();
img1.Src = "../images/edit.gif";
img2.Src = "../images/delete.gif";
img3.Src = "../images/add.gif";
img1.Alt = "Sửa danh mục cha";
img2.Alt = "Xóa danh mục cha";
img3.Alt = "Thêm danh mục con";
img1.Attributes.Add("onclick", "Edit(" + dr["NhomSanPhamID"] + ");");
img2.Attributes.Add("onclick", "Delete(" + dr["NhomSanPhamID"] + ");");
img3.Attributes.Add("onclick", "AddSub(" + dr["NhomSanPhamID"] + ",'" +
dr["TenNhomSanPham"] + "');");
tbc3.Controls.Add(img1);
tbc4.Controls.Add(img2);
tbc5.Controls.Add(img3);
tbr.Cells.Add(tbc1);
tbr.Cells.Add(tbc2);
tbr.Cells.Add(tbc3);
tbr.Cells.Add(tbc4);
tbr.Cells.Add(tbc5);
ds.Tables[0].DefaultView.RowFilter = "NhomChaID=" + dr["NhomSanPhamID"];
DataView dv = ds.Tables[0].DefaultView;
if (dv.Count > 0)
{
img2.Disabled = true;
}
tblDanhMuc.Rows.Add(tbr);
for (int i = 0; i < dv.Count; i++)
{
HtmlTableRow tvr = new HtmlTableRow();
HtmlTableCell tvc1 = new HtmlTableCell();
HtmlTableCell tvc2 = new HtmlTableCell();
HtmlTableCell tvc3 = new HtmlTableCell();
HtmlTableCell tvc4 = new HtmlTableCell();
HtmlTableCell tvc5 = new HtmlTableCell();
//HtmlTableCell tvc6 = new HtmlTableCell();
HtmlImage imgv1 = new HtmlImage();
HtmlImage imgv2 = new HtmlImage();
tvc4.Style.Add("padding", "0");
tvc4.Style.Add("margin", "0");
tvc5.Style.Add("padding", "0");
tvc5.Style.Add("margin", "0");
tvc4.Style.Add("cursor", "hand");
tvc5.Style.Add("cursor", "hand");
//HtmlImage img3 = new HtmlImage();
imgv1.Src = "../images/Edit.gif";
imgv2.Src = "../images/Delete.gif";
imgv1.Attributes.Add("onclick", "EditSub(" + dr["NhomSanPhamID"] + ",'" +
dr["TenNhomSanPham"] + "'," + dv[i]["NhomSanPhamID"] + ");");
imgv2.Attributes.Add("onclick", "Delete(" + dv[i]["NhomSanPhamID"] + ");");
//img3.Src = "../images/AddSub.gif";
imgv1.Alt = "Sửa danh mục con";
imgv2.Alt = "Xóa danh mục con";
tvc4.Controls.Add(imgv1);
tvc5.Controls.Add(imgv2);
//tbc5.Controls.Add(img3);
tvr.Cells.Add(tvc1);
tvr.Cells.Add(tvc2);
tvr.Cells.Add(tvc3);
tvr.Cells.Add(tvc4);
tvr.Cells.Add(tvc5);
//tvr.Cells.Add(tvc6);
tvc3.InnerText = dv[i]["SapXep"] + "." + dv[i]["TenNhomSanPham"];
tblDanhMuc.Rows.Add(tvr);
}
}
}
}
//tblDanhMuc.Controls.Add(tbl);
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}