Ejemplo n.º 1
0
    protected void dlDienThoai_DeleteCommand(object source, DataListCommandEventArgs e)
    {
        string    masp = dlDienThoai.DataKeys[e.Item.ItemIndex].ToString();
        string    url = "", urlfile = "";
        DataTable td = XLDL.LayDuLieu("select tencty,dienthoai.hinhanh from DIENTHOAI,CONGTY where DIENTHOAI.macty=CONGTY.macty and masp='" + masp + "'");

        if (td.Rows.Count > 0)
        {
            url     = "~/images/" + td.Rows[0][0] + "/" + masp;
            urlfile = "~/images/home/" + td.Rows[0][1];
        }
        DataTable dt = XLDL.LayDuLieu("select masp from CTDONHANG where masp='" + masp + "'");

        if (dt.Rows.Count > 0)
        {
            Response.Write("<script>alert('Lỗi ! Không thể xóa sản phẩm')</script>");
        }
        else
        {
            //try
            {
                if (Directory.Exists(Server.MapPath(url)))
                {
                    XLDL.DeleteFolder(Server.MapPath(url));
                }
                if (File.Exists(Server.MapPath(urlfile)))
                {
                    File.Delete(Server.MapPath(urlfile));
                }
                XLDL.Chaylenh("delete from bannersp where masp='" + masp + "'");
                XLDL.Chaylenh("delete from kho where masp='" + masp + "'");
                XLDL.Chaylenh("delete from thongso where masp='" + masp + "'");
                XLDL.Chaylenh("delete from thongsochitiet where masp='" + masp + "'");
                XLDL.Chaylenh("delete from danhgia where masp='" + masp + "'");
                XLDL.Chaylenh("delete from dienthoai where masp='" + masp + "'");
                Response.Write("<script>alert('Sản phẩm được gỡ bỏ thành công')</script>");
                dienthoai();
            }

            /*catch
             * {
             *  Response.Write("<script>alert('Lỗi ! Không thể xóa sản phẩm')</script>");
             * }*/
        }
    }