示例#1
0
    protected void dtMota_UpdateCommand(object source, DataListCommandEventArgs e)
    {
        TextBox   txtTen = (TextBox)e.Item.FindControl("txtTen");
        TextBox   txtQuocGia = (TextBox)e.Item.FindControl("txtQuocGia");
        TextBox   txtMota = (TextBox)e.Item.FindControl("txtMota");
        string    oldurl = "", newurl = "";
        DataTable dt = XLDL.LayDuLieu("select tencty from congty where macty=" + int.Parse(Request.QueryString["macty"].ToString()));

        if (dt.Rows.Count > 0)
        {
            oldurl = "~/images/" + dt.Rows[0][0];
        }
        try
        {
            XLDL.Chaylenh("update congty set tencty=N'" + txtTen.Text.Trim() + "',quocgia=N'" + txtQuocGia.Text.Trim() + "',mota=N'" + txtMota.Text.Trim() + "' where macty = " + Request.QueryString["macty"]);
            newurl = "~/images/" + txtTen.Text.Trim();
            if (Directory.Exists(Server.MapPath(oldurl)) && txtTen.Text.Trim() != dt.Rows[0][0].ToString())
            {
                Directory.Move(Server.MapPath(oldurl), Server.MapPath(newurl));
            }
            Response.Redirect("~/congty.aspx");
        }
        catch
        {
            Response.Write("<script>alert('Lỗi trong quá trình ghi dữ liệu, vui lòng thử lại sau')</script>");
        }
    }
 protected void Page_Load(object sender, EventArgs e)
 {
     if (Session["nguoidung"] == null)
     {
         mtvThongTin.ActiveViewIndex = 1;
         //lblErr.Text = "Lỗi: Không tìm thấy thông tin người dùng.";
     }
     else//đã đăng nhập
     {
         mtvThongTin.ActiveViewIndex = 0;
         string    tennguoidung = Session["nguoidung"].ToString();
         string    thongtinkh   = "select * from Nguoi_Dung where Ten_Nguoi_Dung='" + tennguoidung + "'";
         DataTable dt           = XLDL.docbang(thongtinkh);
         int       manguoidung  = int.Parse(dt.Rows[0]["Ma_Nguoi_Dung"].ToString());
         lblTenNguoiDung.Text       = tennguoidung;
         lblMatKhau.Text            = "******";
         lblHoTen.Text              = dt.Rows[0]["Ho_Ten"].ToString();
         lblGioiTinh.Text           = dt.Rows[0]["Gioi_Tinh"].ToString();
         lblDiaChi.Text             = dt.Rows[0]["Dia_Chi"].ToString();
         lblCMND.Text               = dt.Rows[0]["CMND"].ToString();
         lblEmail.Text              = dt.Rows[0]["Email"].ToString();
         lblSDT.Text                = dt.Rows[0]["SDT"].ToString();
         hypCapNhatMK.NavigateUrl   = "~/Doi_Mat_Khau.aspx?";
         hypCapNhatTTCN.NavigateUrl = "~/Cap_Nhat_TT.aspx?";
     }
 }
示例#3
0
    private void aTimKiem()
    {
        DataTable dt = XLDL.LayDuLieu("select * from DIENTHOAI where TenSP like N'%" + XLDL.Timkiem + "%'");

        if (dt.Rows.Count > 0)
        {
            dlTimKiem.DataSource = XLDL.LayDuLieu("select * from DIENTHOAI where TenSP like N'%" + XLDL.Timkiem + "%'");
            dlTimKiem.DataBind();
            kq.Controls.Add(new LiteralControl("Kết quả tìm kiếm cho từ khóa \"<span style=\"color:#F00\">" + XLDL.Timkiem + "</span>\""));
            lbThongBao.Visible = false;
        }
        else
        {
            kq.Controls.Add(new LiteralControl("Không tìm thấy kết quả nào phù hợp cho từ khóa \"<span style=\"color:#F00\">" + XLDL.Timkiem + "</span>\""));
            lbThongBao.Controls.Add(new LiteralControl("<div style=\"padding-left: 20px\">"));
            lbThongBao.Controls.Add(new LiteralControl("<div>Để tìm được kết quả chính xác hơn, bạn vui lòng:</div>"));
            lbThongBao.Controls.Add(new LiteralControl("<ul style=\"font-size: 13px; padding-left: 20px\">"));
            lbThongBao.Controls.Add(new LiteralControl("<li>Kiểm tra lỗi chính tả của từ khóa đã nhập</li>"));
            lbThongBao.Controls.Add(new LiteralControl("<li>Thử lại bằng từ khóa khác</li>"));
            lbThongBao.Controls.Add(new LiteralControl("<li>Thử lại bằng những từ khóa tổng quát hơn</li>"));
            lbThongBao.Controls.Add(new LiteralControl("<li>Thử lại bằng những từ khóa ngắn gọn hơn</li>"));
            lbThongBao.Controls.Add(new LiteralControl("</ul>"));
            lbThongBao.Controls.Add(new LiteralControl("</div>"));
        }
    }
 protected void Page_Load(object sender, EventArgs e)
 {
     if (Session["nguoidung"] == null)
     {
         mtvChiTietDDH.ActiveViewIndex = 1;
     }
     else
     {
         if (Request.QueryString["Ma_DDH"] == null)
         {
             mtvChiTietDDH.ActiveViewIndex = 2;
         }
         else
         {
             int    maddh    = int.Parse(Request.QueryString["Ma_DDH"]);
             string sqlctddh = "select * from Chi_Tiet_DDH CT,Xe where CT.Ma_Xe = Xe.Ma_Xe and Ma_DDH = " + maddh;
             lblMaDDH.Text = maddh.ToString();
             DataTable dt = XLDL.docbang(sqlctddh);
             if (dt.Rows.Count > 0)
             {
                 mtvChiTietDDH.ActiveViewIndex = 0;
                 gdvChiTietDDH.DataSource      = dt;
                 gdvChiTietDDH.DataBind();
             }
             else
             {
                 mtvChiTietDDH.ActiveViewIndex = 2;
             }
         }
     }
 }
示例#5
0
        private int countMess()
        {
            DataTable dt = new DataTable();

            dt = XLDL.GetData("select * from ThongTinLienHe where DaDuyet = 0");
            return(int.Parse(dt.Rows.Count.ToString()));
        }
 protected void btnLuu_Click(object sender, EventArgs e)
 {
     try
     {
         string thumuc = "~/images/news";
         if (!Directory.Exists(thumuc))
         {
             Directory.CreateDirectory(Server.MapPath(thumuc));
         }
         if (FileUpload1.HasFile)
         {
             if (XLDL.CheckFileType(FileUpload1.FileName))
             {
                 string tenhinh = "~/images/news/" + DateTime.Now.ToString("ddMMyyyy_hhmmss_tt_") + FileUpload1.FileName;
                 FileUpload1.SaveAs(Server.MapPath(tenhinh));
             }
         }
         string hinh = DateTime.Now.ToString("ddMMyyyy_hhmmss_tt_") + FileUpload1.FileName;
         XLDL.Chaylenh("insert into tintuc(tieude,tomtat,hinh,url,ngaydang) values(N'" + txtTieuDe.Text.Trim() + "',N'" + txtTomTat.Text.Trim() + "','" + hinh + "','" + txtLink.Text.Trim() + "','" + DateTime.Today.ToShortDateString() + "')");
         Response.Redirect("~/viewtintuc.aspx");
     }
     catch
     {
         Response.Write("<script>alert('Lỗi ! Vui lòng thử lại sau')</script>");
     }
 }
示例#7
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!Page.IsPostBack)
     {
         if (Session["nguoidung"] == null)
         {
             mtvQLHX.ActiveViewIndex = 1;
             lblErr_admin.Text       = "Bạn không được quyền truy cập trang này";
         }
         else
         {
             string    tennguoidung = Session["nguoidung"].ToString();
             string    thongtinkh   = "select * from Nguoi_Dung where Ten_Nguoi_Dung='" + tennguoidung + "'";
             DataTable dt           = XLDL.docbang(thongtinkh);
             int       manguoidung  = int.Parse(dt.Rows[0][0].ToString());
             int       IsAdmin      = int.Parse(dt.Rows[0]["Admin"].ToString());
             if (IsAdmin == 1)
             {
                 mtvQLHX.ActiveViewIndex    = 0;
                 MultiView1.ActiveViewIndex = 0;
                 show_chungloai();
             }
             else
             {
                 mtvQLHX.ActiveViewIndex = 1;
                 lblErr_admin.Text       = "Bạn không được quyền truy cập trang này";
             }
         }
     }
 }
示例#8
0
    protected void dlDonHang_ItemDataBound(object sender, DataListItemEventArgs e)
    {
        int       sodh        = int.Parse(dlDonHang.DataKeys[e.Item.ItemIndex].ToString());
        Label     lbthanhtoan = (Label)e.Item.FindControl("lbthanhtoan");
        CheckBox  cb          = (CheckBox)e.Item.FindControl("CheckBox1");
        DataTable dt          = XLDL.LayDuLieu("select thanhtoan,dagiao from donhang where sodh=" + sodh);

        if (dt.Rows.Count > 0)
        {
            if (dt.Rows[0][0].ToString() == "True")
            {
                lbthanhtoan.Text = "Chuyển Khoản";
            }
            else
            {
                lbthanhtoan.Text = "Tiền Mặt";
            }
            if (dt.Rows[0][1].ToString() == "True")
            {
                cb.Checked = true;
            }
            else
            {
                cb.Checked = false;
            }
        }
    }
示例#9
0
        protected void gvThongTinKH_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "Xoa")
            {
                try
                {
                    int chiso = int.Parse(e.CommandArgument.ToString());

                    string    ma = gvThongTinKH.Rows[chiso].Cells[0].Text;
                    DataTable dt = XLDL.GetData("select MaKH from KhachHang where MaKH='" + ma + "'");
                    if (dt.Rows.Count > 1)
                    {
                        lbBaoLoi.Text = "Khách hàng đang có bài viết nên không thể xóa.<br/> Bạn cần xóa hết các bài viết của khách hàng này trước";
                    }
                    else
                    {
                        string str = "delete from KhachHang where MaKH='" + ma + "'";
                        XLDL.Excute(str);
                        Response.Redirect("~/AD/KhachHang.aspx");
                    }
                }
                catch
                {
                    lbBaoLoi.Text = "Thất bại";
                    //Response.Write("<script>alert('Xóa Thất Bại!!!');</script>");
                }
            }
        }
示例#10
0
    protected void dlTongQuat_ItemDataBound(object sender, DataListItemEventArgs e)
    {
        CheckBox     cbTraGop  = (CheckBox)e.Item.FindControl("cbTraGop");
        DropDownList ddlHangSX = (DropDownList)e.Item.FindControl("ddlHangSX");
        DataTable    dt1       = XLDL.LayDuLieu("select tencty from congty");

        if (dt1.Rows.Count > 0)
        {
            for (int i = 0; i < dt1.Rows.Count; i++)
            {
                ddlHangSX.Items.Add(dt1.Rows[i][0].ToString());
            }
        }
        DataTable dt = XLDL.LayDuLieu("select tragop,dienthoai.macty,tencty from dienthoai,congty where congty.macty=dienthoai.macty and masp='" + Request.QueryString["MaSP"] + "'");

        if (dt.Rows.Count > 0)
        {
            string bit = dt.Rows[0][0].ToString();
            if (bit == "True")
            {
                cbTraGop.Checked = true;
            }
            else
            {
                cbTraGop.Checked = false;
            }
            ddlHangSX.SelectedValue = dt.Rows[0][2].ToString();
        }
    }
示例#11
0
 protected void imgbtnCapNhat_Click(object sender, ImageClickEventArgs e)
 {
     if (Session["nguoidung"] == null)
     {
         Response.Redirect("~/Cap_Nhat_TT.aspx");
     }
     else
     {
         string    tennguoidung = Session["nguoidung"].ToString();
         string    thongtinkh   = "select * from Nguoi_Dung where Ten_Nguoi_Dung='" + tennguoidung + "'";
         DataTable dt           = XLDL.docbang(thongtinkh);
         manguoidung = int.Parse(dt.Rows[0]["Ma_Nguoi_Dung"].ToString());
         string dienthoai = txtSoDT.Text;
         string gioitinh  = ddlGioiTinh.SelectedItem.Value.ToString();
         string cmnd      = txtSoCMND.Text;
         try
         {
             string str = "update Nguoi_Dung set Ho_Ten='" + txtHoTen.Text + "' , Dia_Chi ='" + txtDiaChi.Text + "' , SDT='" + dienthoai + "' , Email='" + txtEmail.Text + "', Gioi_Tinh='" + gioitinh + "', CMND='" + txtSoCMND.Text + "' where Ma_Nguoi_Dung=" + manguoidung;
             XLDL.thuchienlenh(str);
             Response.Redirect("Thanh_Cong.aspx?capnhattt=1&capnhatmk=&dangky=&thanhtoan=");
         }
         catch (Exception ex)
         {
             lblErrCapNhat.Visible = true;
             lblErrCapNhat.Text    = "Lỗi: Không cập nhật được thông tin";
         }
     }
 }
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         if (Session["nguoidung"] == null)
         {
             mtvAdmin.ActiveViewIndex = 1;
         }
         else
         {
             string    tennguoidung = Session["nguoidung"].ToString();
             string    thongtinkh   = "select * from Nguoi_Dung where Ten_Nguoi_Dung='" + tennguoidung + "'";
             DataTable dt           = XLDL.docbang(thongtinkh);
             int       manguoidung  = int.Parse(dt.Rows[0][0].ToString());
             int       IsAdmin      = int.Parse(dt.Rows[0]["Admin"].ToString());
             if (IsAdmin == 1)
             {
                 mtvAdmin.ActiveViewIndex = 0;
             }
             else
             {
                 mtvAdmin.ActiveViewIndex = 1;
             }
         }
     }
 }
示例#13
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (Session["nguoidung"] == null)
     {
         mtvCapNhatTT.ActiveViewIndex = 1;
     }
     else
     {
         mtvCapNhatTT.ActiveViewIndex = 0;
         if (!IsPostBack)
         {
             string    tennguoidung = Session["nguoidung"].ToString();
             string    thongtinkh   = "select * from Nguoi_Dung where Ten_Nguoi_Dung='" + tennguoidung + "'";
             DataTable dt           = XLDL.docbang(thongtinkh);
             manguoidung   = int.Parse(dt.Rows[0]["Ma_Nguoi_Dung"].ToString());
             txtHoTen.Text = dt.Rows[0]["Ho_Ten"].ToString();
             string gioitinh = dt.Rows[0]["Gioi_Tinh"].ToString();
             if (gioitinh == "Nam")
             {
                 ddlGioiTinh.SelectedIndex = 0;
             }
             else
             {
                 ddlGioiTinh.SelectedIndex = 1;
             }
             txtDiaChi.Text = dt.Rows[0]["Dia_Chi"].ToString();
             txtSoCMND.Text = dt.Rows[0]["CMND"].ToString();
             txtEmail.Text  = dt.Rows[0]["Email"].ToString();
             txtSoDT.Text   = dt.Rows[0]["SDT"].ToString();
         }
     }
 }
示例#14
0
    protected void Button2_Click(object sender, EventArgs e)
    {
        int bit = 0;

        foreach (DataListItem item in dlHinh.Items)
        {
            int      id     = int.Parse(dlHinh.DataKeys[item.ItemIndex].ToString());
            CheckBox cbHinh = (CheckBox)item.FindControl("cbHinh");
            if (cbHinh.Checked == true)
            {
                bit = 1;
            }
            else
            {
                bit = 0;
            }
            XLDL.Chaylenh("update bannerhome set hien=" + bit + " where id=" + id);
        }
        string             tenhinh        = "~/images/home/banner/";
        HttpFileCollection fileCollection = Request.Files;

        for (int i = 0; i < fileCollection.Count; i++)
        {
            HttpPostedFile uploadfile = fileCollection[i];
            string         fileName   = Path.GetFileName(uploadfile.FileName);
            if (uploadfile.ContentLength > 0)
            {
                string hinh = DateTime.Now.ToString("ddMMyyyy_hhmmss_tt_") + fileName;
                uploadfile.SaveAs(Server.MapPath(tenhinh) + hinh);
                XLDL.Chaylenh("insert into bannerhome(hinh) values('" + hinh + "')");
            }
        }
        slide();
    }
示例#15
0
 protected void btnGui_Click(object sender, EventArgs e)
 {
     if (taBinhLuan.Text.Trim() != "")
     {
         string    tendn = XLDL.MaHoa(Session["TenDN"].ToString());
         DataTable dt    = XLDL.LayDuLieu("select * from khachhang where TenDN='" + tendn + "'");
         if (dt.Rows.Count > 0)
         {
             int makh = int.Parse(dt.Rows[0][0].ToString());
             try
             {
                 SqlConnection con = new SqlConnection(XLDL.strcon);
                 SqlCommand    cmd = new SqlCommand("insert into binhluan(masp,makh,binhluan,thoigian) values('" + Request.QueryString["MaSP"] + "'," + makh + ",N'" + taBinhLuan.Text.Trim() + "',@thoigian)", con);
                 cmd.Parameters.Add("@thoigian", SqlDbType.DateTime);
                 cmd.Parameters["@thoigian"].Value = DateTime.Now;
                 con.Open();
                 cmd.ExecuteNonQuery();
                 con.Close();
             }
             catch { }
             taBinhLuan.Text = "";
             binhluan();
             slbl();
             CreateBanner();
         }
     }
     else
     {
         taBinhLuan.Text = "";
         CreateBanner();
     }
 }
示例#16
0
        protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
        {
            String strSearch = txtTimKiem.Text;
            String sql, datenew;
            int    luotTruyCap = 1;

            datenew = DateTime.Now.ToString();
            DataTable dt = XLDL.GetData("select * from TimKiem where TuKhoa = '" + strSearch + "'");

            if (dt.Rows.Count > 0)
            {
                luotTruyCap = int.Parse(dt.Rows[0]["LuotTruyCap"].ToString());
                luotTruyCap++;
                sql = "UPDATE TimKiem SET LuotTruyCap = " + luotTruyCap + "" +
                      ", NgayNhapGanNhat = '" + datenew +
                      "' WHERE TuKhoa = '" + strSearch + "'";
                XLDL.GetData(sql);
            }
            else
            {
                sql = "INSERT INTO TimKiem VALUES('" + strSearch + "'" +
                      "," + luotTruyCap + "" +
                      ",'" + datenew + "')";
                XLDL.GetData(sql);
            }
            Response.Redirect("~/SP_Search.aspx?Search=" + strSearch + "");
        }
示例#17
0
        protected void gvNhaTro_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "Xoa")
            {
                try
                {
                    int chiso = int.Parse(e.CommandArgument.ToString());

                    string    ma = gvNhaTro.Rows[chiso].Cells[0].Text;
                    DataTable dt = XLDL.GetData("select MaNhaTro from NhaTroChoThue where MaNhaTro='" + ma + "'");
                    if (dt.Rows.Count > 1)
                    {
                        lbBaoLoi.Text = "Xóa thất bại";
                    }
                    else
                    {
                        XLDL.Excute("Delete HinhAnhChiTietNhaTro from HinhAnhChiTietNhaTro where HinhAnhChiTietNhaTro.MaNhaTro =" + ma);
                        XLDL.Excute("Delete DanhGia from DanhGia where DanhGia.MaNhaTro=" + ma);
                        XLDL.Excute("Delete NhaTroChoThue from NhaTroChoThue where NhaTroChoThue.MaNhaTro =" + ma);
                        Response.Redirect("~/AD/NhaTro.aspx");
                    }
                }
                catch
                {
                    lbBaoLoi.Text = "Thất bại";
                    //Response.Write("<script>alert('Xóa Thất Bại!!!');</script>");
                }
            }
        }
示例#18
0
    protected void dlHang_ItemDataBound(object sender, DataListItemEventArgs e)
    {
        DataList dlDienThoai = (DataList)e.Item.FindControl("dlDienThoai");
        int      macty       = int.Parse(dlHang.DataKeys[e.Item.ItemIndex].ToString());

        dlDienThoai.DataSource = XLDL.LayDuLieu("select * from dienthoai where macty=" + macty + " order by masp desc");
        dlDienThoai.DataBind();
    }
示例#19
0
    protected void dlBinhLuan_ItemCommand(object source, DataListCommandEventArgs e)
    {
        Label      Label35 = (Label)e.Item.FindControl("Label35");
        LinkButton lThich  = (LinkButton)e.Item.FindControl("lThich");
        string     sl      = Label35.Text.Trim();

        if (e.CommandName == "Thich")
        {
            string chuoi;
            if (Session["TenDN"] != null)
            {
                DataTable dt = XLDL.LayDuLieu("select maKH from khachhang where tendn='" + XLDL.MaHoa(Session["TenDN"].ToString()) + "'");
                string[]  a  = sl.Split(',');
                if (sl.Contains(dt.Rows[0][0].ToString()) == false)
                {
                    chuoi = dt.Rows[0][0].ToString();
                }
                else
                {
                    chuoi = "";
                }
                if (a.Length > 1)
                {
                    for (int i = 0; i < a.Length; i++)
                    {
                        if (a[i] == dt.Rows[0][0].ToString())
                        {
                            continue;
                        }
                        if (chuoi == "")
                        {
                            chuoi = a[i];
                            continue;
                        }
                        chuoi = chuoi + "," + a[i];
                    }
                }
                else
                {
                    if (a[0] != "")
                    {
                        if (chuoi != "")
                        {
                            chuoi = chuoi + "," + a[0];
                        }
                        else
                        {
                            chuoi = "";
                        }
                    }
                }
                XLDL.Chaylenh("update binhluan set thich='" + chuoi + "' where ID=" + (int)dlBinhLuan.DataKeys[e.Item.ItemIndex]);
            }
            binhluan();
            CreateBanner();
        }
    }
示例#20
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         Title();
         motaCty();
         TenCT.Text = XLDL.LayDuLieu("select tencty from congty where macty='" + Request.QueryString["MaCty"] + "'").Rows[0][0].ToString();
     }
 }
示例#21
0
    protected void Page_Load(object sender, EventArgs e)
    {
        int       maloaixe = int.Parse(Request.QueryString["Ma_Loai_xe"]);
        string    loaixe   = "select * from Loai_Xe where Ma_Loai_Xe=" + maloaixe;
        DataTable dt1      = XLDL.docbang(loaixe);

        lblTenHang.Text = dt1.Rows[0]["Ten_Loai_Xe"].ToString();
        load(Request.QueryString["Ma_Loai_xe"].ToString());
    }
示例#22
0
    protected void dlThongSo_UpdateCommand(object source, DataListCommandEventArgs e)
    {
        try
        {
            string  masp       = dlThongSo.DataKeys[e.Item.ItemIndex].ToString();
            TextBox txtManHinh = (TextBox)e.Item.FindControl("txtManHinh");
            TextBox txtCPU     = (TextBox)e.Item.FindControl("txtCPU");
            TextBox txtRam1    = (TextBox)e.Item.FindControl("txtRam1");
            TextBox txtRom     = (TextBox)e.Item.FindControl("txtRom");
            TextBox txtHdh1    = (TextBox)e.Item.FindControl("txtHdh1");
            TextBox txtCamera  = (TextBox)e.Item.FindControl("txtCamera");
            TextBox txtSelfie  = (TextBox)e.Item.FindControl("txtSelfie");
            TextBox txtPin1    = (TextBox)e.Item.FindControl("txtPin1");
            XLDL.Chaylenh("update thongso set manhinh=N'" + txtManHinh.Text.Trim() + "',cpu=N'" + txtCPU.Text.Trim() + "',ram1=N'" + txtRam1.Text.Trim() + "',rom=N'" + txtRom.Text.Trim() + "',hdh1=N'" + txtHdh1.Text.Trim() + "',camera=N'" + txtCamera.Text.Trim() + "',selfie=N'" + txtSelfie.Text.Trim() + "',pin1=N'" + txtPin1.Text.Trim() + "' where masp='" + masp + "'");

            TextBox txtCNMH            = (TextBox)e.Item.FindControl("txtCNMH");
            TextBox txtDoPhanGiai      = (TextBox)e.Item.FindControl("txtDoPhanGiai");
            TextBox txtMHRong          = (TextBox)e.Item.FindControl("txtMHRong");
            TextBox txtCamUng          = (TextBox)e.Item.FindControl("txtCamUng");
            TextBox txtDoPhanGiaiSau   = (TextBox)e.Item.FindControl("txtDoPhanGiaiSau");
            TextBox txtQuayPhimSau     = (TextBox)e.Item.FindControl("txtQuayPhimSau");
            TextBox txtFlash           = (TextBox)e.Item.FindControl("txtFlash");
            TextBox txtChupAnhNangCao  = (TextBox)e.Item.FindControl("txtChupAnhNangCao");
            TextBox txtDoPhanGiaiTruoc = (TextBox)e.Item.FindControl("txtDoPhanGiaiTruoc");
            TextBox txtVideoCall       = (TextBox)e.Item.FindControl("txtVideoCall");
            TextBox txtThongTinKhac    = (TextBox)e.Item.FindControl("txtThongTinKhac");
            TextBox txtHdh             = (TextBox)e.Item.FindControl("txtHdh");
            TextBox txtChipset         = (TextBox)e.Item.FindControl("txtChipset");
            TextBox txtTocDoCPU        = (TextBox)e.Item.FindControl("txtTocDoCPU");
            TextBox txtGpu             = (TextBox)e.Item.FindControl("txtGpu");
            TextBox txtRam             = (TextBox)e.Item.FindControl("txtRam");
            TextBox txtBoNhoTrong      = (TextBox)e.Item.FindControl("txtBoNhoTrong");
            TextBox txtTheNho          = (TextBox)e.Item.FindControl("txtTheNho");
            TextBox txtSim             = (TextBox)e.Item.FindControl("txtSim");
            TextBox txtSac             = (TextBox)e.Item.FindControl("txtSac");
            TextBox txtTainghe         = (TextBox)e.Item.FindControl("txtTainghe");
            TextBox txtThietKe         = (TextBox)e.Item.FindControl("txtThietKe");
            TextBox txtChatLieu        = (TextBox)e.Item.FindControl("txtChatLieu");
            TextBox txtKichThuoc       = (TextBox)e.Item.FindControl("txtKichThuoc");
            TextBox txtTrongLuong      = (TextBox)e.Item.FindControl("txtTrongLuong");
            TextBox txtPin             = (TextBox)e.Item.FindControl("txtPin");
            TextBox txtLoaiPin         = (TextBox)e.Item.FindControl("txtLoaiPin");
            TextBox txtCNPin           = (TextBox)e.Item.FindControl("txtCNPin");
            TextBox txtThoiDiem        = (TextBox)e.Item.FindControl("txtThoiDiem");
            XLDL.Chaylenh("update thongsochitiet set cnmanhinh=N'" + txtCNMH.Text.Trim() + "',dophangiaimh=N'" + txtDoPhanGiai.Text.Trim() + "',mhrong=N'" + txtMHRong.Text.Trim() + "',camung=N'" + txtCamUng.Text.Trim() + "',dophangiaicamsau=N'" + txtDoPhanGiaiSau.Text.Trim() + "',quayphimsau=N'" + txtQuayPhimSau.Text.Trim() + "',denflash=N'" + txtFlash.Text.Trim() + "',chupanhnangcao=N'" + txtChupAnhNangCao.Text.Trim() + "',dophangiaicamtruoc=N'" + txtDoPhanGiaiTruoc.Text.Trim() + "',videocall=N'" + txtVideoCall.Text.Trim() + "',thongtinkhac=N'" + txtThongTinKhac.Text.Trim() + "',hdh=N'" + txtHdh.Text.Trim() + "',chipset=N'" + txtChipset.Text.Trim() + "',tocdocpu=N'" + txtTocDoCPU.Text.Trim() + "',gpu=N'" + txtGpu.Text.Trim() + "',ram=N'" + txtRam.Text.Trim() + "',bonhotrong=N'" + txtBoNhoTrong.Text.Trim() + "',thenho=N'" + txtTheNho.Text.Trim() + "',sim=N'" + txtSim.Text.Trim() + "',sac=N'" + txtSac.Text.Trim() + "',tainghe=N'" + txtTainghe.Text.Trim() + "',chatlieu=N'" + txtChatLieu.Text.Trim() + "',kichthuoc=N'" + txtKichThuoc.Text.Trim() + "',trongluong=N'" + txtTrongLuong.Text.Trim() + "',pin=N'" + txtPin.Text.Trim() + "',loaipin=N'" + txtLoaiPin.Text.Trim() + "',congnghepin=N'" + txtCNPin.Text.Trim() + "',thoidiemramat=N'" + txtThoiDiem.Text.Trim() + "' where masp='" + masp + "'");

            thongso();
            alert.Visible = true;
        }
        catch
        {
            error.Visible = true;
        }
    }
示例#23
0
    private void LayThongTin(string ms)
    {
        string    str = "Select S.*, TenChuDe FROM HOA S INNER JOIN CHUDE C ON S.MaCD=C.MaCD WHERE S.MaHoa=" + int.Parse(ms);
        DataTable dt  = XLDL.GetData(str);

        if (dt.Rows.Count > 0)
        {
            dlChiTietHoa.DataSource = dt;
            dlChiTietHoa.DataBind();
        }
    }
示例#24
0
    protected void dlAdmin_DeleteCommand(object source, DataListCommandEventArgs e)
    {
        int id = int.Parse(dlAdmin.DataKeys[e.Item.ItemIndex].ToString());

        try
        {
            XLDL.Chaylenh("delete admin where id=" + id);
            admin();
        }
        catch { }
    }
示例#25
0
    public HttpResponseMessage GetFileContent(string id)
    {
        XLDL   x   = new XLDL();
        string sql = "select URLBaiHat from BAIHAT where Id=" + id;

        path = x.GetDaTaID(sql);

        var httpResponce = Request.CreateResponse();

        httpResponce.Content = new PushStreamContent((Action <Stream, HttpContent, TransportContext>)WriteContentToStream);
        return(httpResponce);
    }
示例#26
0
    protected void ddlHangSX_Load(object sender, EventArgs e)
    {
        DataTable dt = XLDL.LayDuLieu("select tencty from congty");

        if (dt.Rows.Count > 0)
        {
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                ddlHangSX.Items.Add(dt.Rows[i][0].ToString());
            }
        }
    }
示例#27
0
 protected void dlKhuyenMai_DeleteCommand(object source, DataListCommandEventArgs e)
 {
     try
     {
         int ID = int.Parse(dlKhuyenMai.DataKeys[e.Item.ItemIndex].ToString());
         XLDL.Chaylenh("delete from khuyenmaisp where id=" + ID);
         Response.Redirect(HttpContext.Current.Request.Url.AbsoluteUri);
     }
     catch
     {
     }
 }
示例#28
0
 protected void btnLuu_Click(object sender, EventArgs e)
 {
     try
     {
         XLDL.Chaylenh("insert into admin(HoTen,DiaChi,sdt,email,TenDN,MatKhau) values(N'" + txtHoTen.Text.Trim() + "',N'" + txtDiaChi.Text.Trim() + "','" + txtSDT.Text.Trim() + "','" + txtEmail.Text.Trim() + "','" + XLDL.MaHoa(txtTenDN.Text.ToLower().Trim()) + "','" + XLDL.MaHoa(txtMatKhau.Text.Trim()) + "')");
         Response.Redirect("~/quantrivien.aspx");
     }
     catch
     {
         lbThongbaoloi.Text = "Tên đăng nhập đã tồn tại, vui lòng thử lại với tên khác !";
     }
 }
示例#29
0
 protected void LuuDN()
 {
     if (cbLuu.Checked)
     {
         HttpCookie cookie = new HttpCookie("Luu", "yes");
         Response.Cookies.Add(cookie);
         cookie = new HttpCookie("TenDNandPass");
         cookie.Values.Add("TenDN", XLDL.MaHoa(txtTen.Text.Trim().ToLower()));
         cookie.Values.Add("Pass", XLDL.MaHoa(txtMatkhau.Text.Trim()));
         Response.Cookies.Add(cookie);
     }
 }
示例#30
0
    private void tendt()
    {
        DataTable dt = XLDL.LayDuLieu("select tensp from dienthoai where masp='" + Request.QueryString["MaSP"] + "'");

        if (dt.Rows.Count > 0)
        {
            TenDT.Text = dt.Rows[0][0].ToString();
        }
        else
        {
            Response.Redirect("~/dienthoai.aspx");
        }
    }