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());
}
}
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());
}
}
private void LoadDataForCuaHang(string Id)
{
try
{
NhomSanPhamCuaHang nhomsanpham = new NhomSanPhamCuaHang();
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 LoadUltraMenuItems(Item mi, int NhomSanPhamID,Boolean bl)
{
NhomSanPhamCuaHang nsp = new NhomSanPhamCuaHang();
DataSet ds = nsp.SelectByCuaHangIDAndNhomChaID(CuaHangID, NhomSanPhamID);
foreach (DataRow dr in ds.Tables[0].Rows)
{
Item mni = new Item();
mni.Text = dr["TenNhomSanPham"].ToString().Length > 30
? dr["TenNhomSanPham"].ToString().Substring(0, 30) + "..."
: dr["TenNhomSanPham"].ToString();
mni.Tag = dr["NhomSanPhamCuaHangID"].ToString();
//mni.ToolTip = dr["TenNhomSanPham"].ToString();
LoadUltraMenuItems(mni, int.Parse(dr["NhomSanPhamCuaHangID"].ToString()),true);
if (bl)
{
if (LoaiGianHangID == LoaiGianHang)
{
mni.TargetUrl = "Newestore.aspx?sid=" + CuaHangID + "&cid=" + dr["NhomSanPhamID"];
}
else
{
mni.TargetUrl = "estore.aspx?sid=" + CuaHangID + "&cid=" + dr["NhomSanPhamID"];
}
}
else
{
if (LoaiGianHangID == LoaiGianHang)
{
mni.TargetUrl = "Newestore.aspx?sid=" + CuaHangID + "&cid=" + dr["NhomSanPhamCuahangID"];
}
else
{
mni.TargetUrl = "estore.aspx?sid=" + CuaHangID + "&cid=" + dr["NhomSanPhamCuahangID"];
}
}
mi.Items.Add(mni);
}
}
private void LoadUltraMenu(int NhomChaID)
{
try
{
NhomSanPhamCuaHang nsp = new NhomSanPhamCuaHang();
DataSet ds;
string cachemenu = "nsp" + CuaHangID + "_" + NhomChaID;
if (Cache[cachemenu] == null)
{
ds = nsp.SelectByCuaHangIDAndNhomChaID(CuaHangID, NhomChaID);
Cache[cachemenu] = ds;
}
else
{
ds = (DataSet)Cache[cachemenu];
}
foreach (DataRow dr in ds.Tables[0].Rows)
{
Item mni = new Item();
mni.Text = dr["TenNhomSanPham"].ToString().Length > 30
? dr["TenNhomSanPham"].ToString().Substring(0, 30) + "..."
: dr["TenNhomSanPham"].ToString();
mni.Tag = dr["NhomSanPhamCuaHangID"].ToString();
//mni.ToolTip = dr["TenNhomSanPham"].ToString();
LoadUltraMenuItems(mni, int.Parse(dr["NhomSanPhamCuaHangID"].ToString()),false);
if (LoaiGianHangID == LoaiGianHang)
{
mni.TargetUrl = "newestore.aspx?sid=" + CuaHangID + "&cid=" + dr["NhomSanPhamCuaHangID"];
}
else
{
mni.TargetUrl = "estore.aspx?sid=" + CuaHangID + "&cid=" + dr["NhomSanPhamCuaHangID"];
}
uwmMenu.Items.Add(mni);
}
}
catch (Exception ex)
{
Response.Redirect("../message.aspx?msg=" + ex.ToString().Replace("\r\n", ""));
}
}
private void deleteNhomSanPhamCuaHang(int id)
{
NhomSanPhamCuaHang nsp = new NhomSanPhamCuaHang();
DataSet ds = nsp.SelectByID(id);
if (ds.Tables[0].Rows.Count > 0)
{
CuaHangNhomSanPham chnsp = new CuaHangNhomSanPham();
chnsp.Delete(int.Parse(ds.Tables[0].Rows[0]["CuaHangNhomSanPhamID"].ToString()));
}
nsp.Delete(id);
}
private void LoadDanhMucCon(int NhomChaID, int CuaHangID, int loaddm)
{
loaddm++;
try
{
NhomSanPhamCuaHang nhomsanpham = new NhomSanPhamCuaHang();
DataSet ds = nhomsanpham.SelectByCuaHangIDAndNhomChaID(CuaHangID, 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*10) + "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", "3%");
tbc2.InnerText = dr["SapXep"] + "." + dr["TenNhomSanPham"];
tbc2.ColSpan = 2;
tbc4.Style.Add("width", "16px");
tbc5.Style.Add("width", "16px");
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 img2 = new HtmlImage();
HtmlImage img3 = new HtmlImage();
img2.Src = "../images/delete.gif";
img3.Src = "../images/add.gif";
img2.Alt = "Xóa danh mục cha";
img3.Alt = "Thêm danh mục con";
tbc3.Style.Add("width", "16px");
tbc3.Style.Add("padding", "0");
tbc3.Style.Add("margin", "0");
tbc3.Style.Add("cursor", "hand");
HtmlImage img1 = new HtmlImage();
img1.Src = "../images/edit.gif";
img1.Alt = "Sửa danh mục";
if (loaddm < 3)
{
img1.Attributes.Add("onclick", "Edit(" + dr["NhomSanPhamCuaHangID"] + "," + CuaHangID + ");");
img3.Attributes.Add("onclick", "AddSub(" + dr["NhomSanPhamCuaHangID"] + "," + CuaHangID + ",'" +
dr["TenNhomSanPham"] + "');");
}
else if (loaddm==3)
{
img1.Attributes.Add("onclick", "EditSub(" + dr["NhomSanPhamCuaHangID"] + ",'" +
dr["TenNhomSanPham"] + "'," + CuaHangID + ");");
}
tbc3.Controls.Add(img1);
img2.Attributes.Add("onclick", "Delete(" + dr["NhomSanPhamCuaHangID"] + ");");
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);
//if (dr["NhomSanPhamID"].ToString()!="0")
LoadDanhMucCon(int.Parse(dr["NhomSanPhamCuaHangID"].ToString()), CuaHangID, loaddm);
// }
}
}
// tblDanhMuc.Controls.Add(tbl);
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
