protected void Button1_Click(object sender, EventArgs e) { string loi = "Sản phẩm này không tồn tại!"; try { string sql = "kiem_tra_san_pham " + TextBox1.Text; connect connect = new connect(); DataTable ds = new DataTable(); System.Data.SqlClient.SqlConnection ketnoi = new System.Data.SqlClient.SqlConnection(connect.getconnect()); ds = new DataTable(); new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql, ketnoi)).Fill(ds); if (ds.Rows.Count == 0) { int.Parse("a"); //hủy thao tác } loi = "Sản phẩm đã thêm vào trước đó!"; WebApplication2.QuanTri.maHoa mH = new WebApplication2.QuanTri.maHoa(); System.Data.SqlClient.SqlConnection connDB = new System.Data.SqlClient.SqlConnection(connect.getconnect()); System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("danh_sach_loai_san_pham_cua_san_pham_them", connDB); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@id_san_pham", System.Data.SqlDbType.NVarChar).Value = TextBox1.Text; cmd.Parameters.Add("@id_loai_san_pham", System.Data.SqlDbType.NVarChar).Value = int.Parse(Request.QueryString["id_loai_san_pham"]); connDB.Open(); cmd.ExecuteNonQuery(); connDB.Close(); Response.Write("<script language='javascript'> alert('Thêm thành công'); window.open('" + Page.Request.Url.ToString() + "','_self', 1); </script>"); } catch (Exception x) { Response.Write("<script language='javascript'> alert('" + loi + "');history.go(-1); </script>"); } }
protected void Page_Load(object sender, EventArgs e) { string sql = "select id_nguoi, email_nguoi, mat_khau_nguoi, ten_nguoi, cast(FORMAT(ngay_sinh, 'yyyy-MM-dd') as varchar) as ngay_sinh, dia_chi_nguoi, sdt_nguoi, gioi_tinh_nguoi from nguoi where id_nguoi="; int id_nguoi = 0; WebApplication2.QuanTri.maHoa mH = new WebApplication2.QuanTri.maHoa(); connect connect; try { if (Request.QueryString["id_nguoi"] != null && Request.QueryString["id_nguoi"] != "") { id_nguoi = int.Parse(Request.QueryString["id_nguoi"]); } } catch (Exception qqe) { } if (id_nguoi == 0) { Response.Redirect("./DanhSach.aspx"); } connect = new connect(); System.Data.SqlClient.SqlConnection ketnoi = new System.Data.SqlClient.SqlConnection(connect.getconnect()); DataTable ds = new DataTable(); new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql + +id_nguoi, ketnoi)).Fill(ds); if (ds == null || ds.Rows.Count == 0) { Response.Redirect("./DanhSach.aspx"); } maHoa m = new maHoa(); if (!IsPostBack) { TextBox6.Text = ds.Rows[0][0].ToString(); TextBox0.Text = ds.Rows[0][1].ToString(); TextBox1.Text = m.Base64Decode(ds.Rows[0][2].ToString()); TextBox1.Attributes["type"] = "password"; TextBox2.Text = ds.Rows[0][3].ToString(); TextBox3.Text = ds.Rows[0][4].ToString(); TextBox4.Text = ds.Rows[0][5].ToString(); TextBox5.Text = ds.Rows[0][6].ToString(); if (bool.Parse(ds.Rows[0][7].ToString()) == true) { RadioButton1.Checked = true; RadioButton2.Checked = false; } else { RadioButton1.Checked = false; RadioButton2.Checked = true; } } }
protected void Page_Load(object sender, EventArgs e) { id_thuong_hieu = -1; connect = new connect(); mH = new WebApplication2.QuanTri.maHoa(); try { if (Request.QueryString["id_thuong_hieu"] != null && Request.QueryString["id_thuong_hieu"] != "") { id_thuong_hieu = int.Parse(Request.QueryString["id_thuong_hieu"]); } } catch (Exception a) { } if (id_thuong_hieu == -1) { Response.Redirect("./danhSach.aspx"); } }
protected void Button1_Click(object sender, EventArgs e) { int id_san_pham = 0; try { if (Request.QueryString["id_san_pham"] != null && Request.QueryString["id_san_pham"] != "") { id_san_pham = int.Parse(Request.QueryString["id_san_pham"]); } } catch (Exception a) { } if (id_san_pham == 0) { Response.Redirect("./danhSach.aspx"); } { string loi = "Thêm bị lỗi"; try { WebApplication2.QuanTri.maHoa mH = new WebApplication2.QuanTri.maHoa(); WebApplication2.YNNSHOP56131778.CONGFIG.connect connect = new WebApplication2.YNNSHOP56131778.CONGFIG.connect(); System.Data.SqlClient.SqlConnection connDB = new System.Data.SqlClient.SqlConnection(connect.getconnect()); System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("danh_sach_anh_cua_san_pha_them", connDB); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@id_san_pham", System.Data.SqlDbType.NVarChar).Value = id_san_pham; cmd.Parameters.Add("@duong_link_anh", System.Data.SqlDbType.NVarChar).Value = mH.Base64Encode(TextBox1.Text); connDB.Open(); cmd.ExecuteNonQuery(); connDB.Close(); Response.Write("<script language='javascript'> alert('Thêm thành công'); window.open('" + Session["danhSachAnh"].ToString() + "','_self', 1); </script>"); } catch (Exception x) { Response.Write("<script language='javascript'> alert('" + loi + "');history.go(-1); </script>"); } } }
protected void Page_Load(object sender, EventArgs e) { connect connect; try { if (Request.QueryString["id_phieu_nhap"] != null && Request.QueryString["id_phieu_nhap"] != "") { id_phieu_nhap = int.Parse(Request.QueryString["id_phieu_nhap"]); } } catch (Exception a) { } if (id_phieu_nhap == 0) { Response.Redirect("./danhSach.aspx"); } WebApplication2.QuanTri.maHoa mH = new WebApplication2.QuanTri.maHoa(); string sql = "select id_kho_hang, ten_kho_hang from kho_hang"; connect = new connect(); System.Data.SqlClient.SqlConnection ketnoi = new System.Data.SqlClient.SqlConnection(connect.getconnect()); DataTable ds = new DataTable(); new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql, ketnoi)).Fill(ds); if (!IsPostBack) { DropDownList1.DataSource = ds; DropDownList1.DataTextField = "ten_kho_hang"; DropDownList1.DataValueField = "id_kho_hang"; DropDownList1.DataBind(); } sql = "select pnhh.id_phieu_nhap, pnhh.id_nguoi, n.ten_nguoi, pnhh.id_kho_hang, cast(FORMAT(pnhh.ngay_tao_phieu, 'yyyy-MM-dd') as varchar) as ngay_tao_phieu, pnhh.mo_ta_nguon_nhap, CASE WHEN DATEDIFF(HOUR, GETDATE(), pnhh.ngay_tao_phieu)>=-24 THEN 1 ELSE 0 END " + "from phieu_nhap_hang_hoa pnhh " + "join nguoi n on pnhh.id_nguoi=n.id_nguoi " + "where pnhh.id_phieu_nhap=" + id_phieu_nhap; connect = new connect(); ds = new DataTable(); new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql, ketnoi)).Fill(ds); if (ds == null || ds.Rows.Count == 0) { Response.Redirect("./danhSach.aspx"); } if (int.Parse(ds.Rows[0][6].ToString()) == 0) { hieu_luc = false; } else { hieu_luc = true; } if (hieu_luc == false) { Response.Redirect("./danhSach.aspx"); } if (!IsPostBack) { TextBox6.Text = ds.Rows[0][0].ToString(); TextBox7.Text = ds.Rows[0][2].ToString(); TextBox8.Text = ds.Rows[0][4].ToString(); TextBox3.Text = ds.Rows[0][5].ToString(); DropDownList1.SelectedValue = ds.Rows[0][3].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { connect connect = new connect(); System.Data.SqlClient.SqlConnection ketnoi = new System.Data.SqlClient.SqlConnection(connect.getconnect()); string loi = "Dữ liệu đầu vào lỗi"; string ngaybaydau = ""; string ngayketthuc = ""; try { try { if (Request.QueryString["ngaybaydau"] != null && Request.QueryString["ngaybaydau"].Length != 0) { ngaybaydau = Request.QueryString["ngaybaydau"]; } if (Request.QueryString["ngayketthuc"] != null && Request.QueryString["ngayketthuc"].Length != 0) { ngayketthuc = Request.QueryString["ngayketthuc"]; } } catch (Exception a) { } if (ngaybaydau.Length == 0 || ngayketthuc.Length == 0) { int.Parse("a"); } loi = "Lỗi không xác định!"; maHoa m = new maHoa(); ngaybaydau = m.Base64Decode(ngaybaydau); ngayketthuc = m.Base64Decode(ngayketthuc); if (!IsPostBack) { WebApplication2.QuanTri.maHoa mH = new WebApplication2.QuanTri.maHoa(); string sql = "select dh.id_don_hang, cast(FORMAT(dh.ngay_tao_don_hang, 'dd-MM-yyyy') as varchar) as ngay_tao_don_hang, " + " sp.ten_san_pham, ctdh.so_luong, " + " cast (sp.gia_nhap_san_pham as int) donGiaNhap, " + " cast(ctdh.so_luong * sp.gia_nhap_san_pham as int)thanhTienNhap, " + " cast(ctdh.gia_da_giam as int)donGiaBan, " + " cast(ctdh.so_luong * ctdh.gia_da_giam as int)thanhTienBan, " + " cast((ctdh.so_luong * ctdh.gia_da_giam - ctdh.so_luong * sp.gia_nhap_san_pham) as int) tienLoi " + " from don_hang dh join chi_tiet_don_hang ctdh on dh.id_don_hang = ctdh.id_don_hang " + " join san_pham sp on sp.id_san_pham=ctdh.id_san_pham " + " where " + " DATEDIFF(DAY,'" + ngaybaydau + "', dh.ngay_tao_don_hang) >= 0 " + " and DATEDIFF(DAY,dh.ngay_tao_don_hang, '" + ngayketthuc + "') >= 0 " + " and dh.id_ttdh=3 " + " order by dh.id_don_hang asc"; DataTable tmp = new DataTable(); new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql, ketnoi)).Fill(tmp); //khungHoaDon KHD = new khungHoaDon(); //DataTable BangChiTietDoanhThu = KHD.Tables["ChiTietSanPhamDonHang"]; DataTable BangChiTietDoanhThu = new DataTable(); BangChiTietDoanhThu.Columns.Add("id_don_hang"); BangChiTietDoanhThu.Columns.Add("ngay_tao_don_hang"); BangChiTietDoanhThu.Columns.Add("ten_san_pham"); BangChiTietDoanhThu.Columns.Add("so_luong"); BangChiTietDoanhThu.Columns.Add("donGiaNhap"); BangChiTietDoanhThu.Columns.Add("thanhTienNhap"); BangChiTietDoanhThu.Columns.Add("donGiaBan"); BangChiTietDoanhThu.Columns.Add("thanhTienBan"); BangChiTietDoanhThu.Columns.Add("tienLoi"); long tongdoanhthu = 0, tongtienloi = 0; for (int i = 0; i < tmp.Rows.Count; i++) { tongdoanhthu += int.Parse(tmp.Rows[i][7].ToString()); tongtienloi += int.Parse(tmp.Rows[i][8].ToString()); DataRow x = BangChiTietDoanhThu.NewRow(); x[0] = tmp.Rows[i][0].ToString(); x[1] = tmp.Rows[i][1].ToString(); x[2] = mH.Base64Decode(tmp.Rows[i][2].ToString()); x[3] = tmp.Rows[i][3].ToString(); x[4] = String.Format("{0:n0}", int.Parse(tmp.Rows[i][4].ToString())).Replace(",", ".") + " vnđ"; x[5] = String.Format("{0:n0}", int.Parse(tmp.Rows[i][5].ToString())).Replace(",", ".") + " vnđ"; x[6] = String.Format("{0:n0}", int.Parse(tmp.Rows[i][6].ToString())).Replace(",", ".") + " vnđ"; x[7] = String.Format("{0:n0}", int.Parse(tmp.Rows[i][7].ToString())).Replace(",", ".") + " vnđ"; x[8] = String.Format("{0:n0}", int.Parse(tmp.Rows[i][8].ToString())).Replace(",", ".") + " vnđ"; BangChiTietDoanhThu.Rows.Add(x); } ReportViewer1.ProcessingMode = ProcessingMode.Local; ReportViewer1.LocalReport.ReportPath = Server.MapPath("Report1.rdlc"); // ReportParameter[] param = new ReportParameter[4]; param[0] = new ReportParameter("thoiGianDauCuoi", "TỪ NGÀY " + ngaybaydau + " ĐẾN NGÀY " + ngayketthuc); param[1] = new ReportParameter("ngaytaobaocao", DateTime.Now.ToString("dd/MM/yyyy")); param[2] = new ReportParameter("tongdoanhthu", String.Format("{0:n0}", tongdoanhthu).Replace(",", ".") + " vnđ"); param[3] = new ReportParameter("tongtienloi", String.Format("{0:n0}", tongtienloi).Replace(",", ".") + " vnđ"); ReportViewer1.LocalReport.SetParameters(param); // ReportDataSource datasource = new ReportDataSource("PhaiChinhXac", BangChiTietDoanhThu); ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(datasource); } } catch (Exception a) { Response.Write("<script language='javascript'> alert('" + loi + "'); history.go(-1); </script>"); } // }
protected void Page_Load(object sender, EventArgs e) { mH = new WebApplication2.QuanTri.maHoa(); connect = new connect(); }
protected void Page_Load(object sender, EventArgs e) { connect connect; try { if (Request.QueryString["id_kho_hang"] != null && Request.QueryString["id_kho_hang"] != "") { id_kho_hang = int.Parse(Request.QueryString["id_kho_hang"]); } } catch (Exception qqe) { } if (id_kho_hang == 0) { Response.Redirect("./danhSach.aspx"); } WebApplication2.QuanTri.maHoa mH = new WebApplication2.QuanTri.maHoa(); connect = new connect(); System.Data.SqlClient.SqlConnection ketnoi = new System.Data.SqlClient.SqlConnection(connect.getconnect()); string sql = "select id_kho_hang, id_khu_vuc, ten_kho_hang, dia_chi_kho_hang_chi_tiet, dien_tich_kho, cast(FORMAT(ngay_tao_kho, 'yyyy-MM-dd') as varchar) as ngay_tao_kho, ghi_chu_kho " + "from kho_hang " + "where id_kho_hang=" + id_kho_hang; DataTable ds = new DataTable(); new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql, ketnoi)).Fill(ds); if (ds == null || ds.Rows.Count == 0) { Response.Redirect("./danhSach.aspx"); } //1. danh sách tỉnh sql = "select id_khu_vuc, ten_khu_vuc from khu_vuc where id_khu_vuc_cha=0"; connect = new connect(); DataTable tmp = new DataTable(); new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql, ketnoi)).Fill(tmp); if (!IsPostBack) { DropDownList2.DataSource = tmp; DropDownList2.DataTextField = "ten_khu_vuc"; DropDownList2.DataValueField = "id_khu_vuc"; DropDownList2.DataBind(); } //2. set mã tỉnh sql = "select id_khu_vuc_cha from khu_vuc where id_khu_vuc=" + ds.Rows[0][1].ToString(); tmp = new DataTable(); new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql, ketnoi)).Fill(tmp); string id_tinh = tmp.Rows[0][0].ToString(); //3. huyện sql = "select id_khu_vuc, ten_khu_vuc from khu_vuc where id_khu_vuc_cha=" + tmp.Rows[0][0].ToString(); tmp = new DataTable(); new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql, ketnoi)).Fill(tmp); if (!IsPostBack) { DropDownList1.DataSource = tmp; DropDownList1.DataTextField = "ten_khu_vuc"; DropDownList1.DataValueField = "id_khu_vuc"; DropDownList1.DataBind(); } if (!IsPostBack) { TextBox6.Text = ds.Rows[0][0].ToString(); TextBox7.Text = ds.Rows[0][2].ToString(); TextBox3.Text = ds.Rows[0][3].ToString(); TextBox8.Text = ds.Rows[0][4].ToString(); TextBox9.Text = ds.Rows[0][5].ToString(); TextBox10.Text = ds.Rows[0][6].ToString(); DropDownList2.SelectedValue = id_tinh; DropDownList1.SelectedValue = ds.Rows[0][1].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { int id_don_hang = 0; try { if (Request.QueryString["id_don_hang"] != null && Request.QueryString["id_don_hang"] != "") { id_don_hang = int.Parse(Request.QueryString["id_don_hang"]); } } catch (Exception a) { } if (id_don_hang == 0) { Response.Redirect("./danhSachTTDH.aspx"); } string sql = "select " + "dh.id_don_hang, " + "n.ten_nguoi, " + "ttn.ten_tinh_trang, " + "ttdh.ten_ttdh, " + "ptvc.ten_ptvc, " + "kv.ht+ ', ' +dh.dia_chi_nhan_hang_chi_tiet, " + "dh.ma_van_chuyen, " + "cast(dh.phi_van_chuyen as int), " + "cast(dh.phi_thu_ho as int), " + "cast(dh.tong_tien as int), " + "cast(FORMAT(dh.ngay_tao_don_hang, 'dd-MM-yyyy') as varchar) as ngay_tao_don_hang , " + "cast(FORMAT(dh.ngay_xac_nhan_don_hang_thanh_cong, 'dd-MM-yyyy') as varchar) as ngay_xac_nhan_don_hang_thanh_cong , " + "dh.so_ngay_giao_gan_nhat, " + "dh.so_ngay_giao_xa_nhat, " + "n.sdt_nguoi, " + "dh.id_ttdh, " + "n.id_nguoi " + "from don_hang dh " + "join nguoi n on dh.id_nguoi=n.id_nguoi " + "join tinh_trang_nguoi ttn on ttn.id_tinh_trang_nguoi=n.id_tinh_trang_nguoi " + "join tinh_trang_don_hang ttdh on ttdh.id_ttdh=dh.id_ttdh " + "join ( " + " select h.id_khu_vuc, t.ten_khu_vuc+ ', ' +h.ten_khu_vuc as 'ht' "+ " from khu_vuc h join khu_vuc t on h.id_khu_vuc_cha = t.id_khu_vuc "+ ") as kv on kv.id_khu_vuc=dh.id_khu_vuc " + "join phuong_thuc_van_chuyen ptvc on dh.id_ptvc=ptvc.id_ptvc " + "WHERE dh.id_don_hang=" + id_don_hang; connect connect = new connect(); DataTable ds = new DataTable(); System.Data.SqlClient.SqlConnection ketnoi = new System.Data.SqlClient.SqlConnection(connect.getconnect()); ds = new DataTable(); new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql, ketnoi)).Fill(ds); if (ds.Rows.Count == 0) { Response.Redirect("./danhSachTTDH.aspx"); } if (!IsPostBack) { WebApplication2.QuanTri.maHoa mH = new WebApplication2.QuanTri.maHoa(); sql = "select sp.id_san_pham, th.ten_thuong_hieu, sp.ten_san_pham, sp.anh_san_pham, ctdh.ma_giam_gia, ctdh.so_luong, cast(ctdh.gia_san_pham as int), cast(ctdh.gia_da_giam as int) " + "from chi_tiet_don_hang ctdh join san_pham sp on ctdh.id_san_pham=sp.id_san_pham " + "join thuong_hieu th on th.id_thuong_hieu=sp.id_thuong_hieu " + "where id_don_hang=" + id_don_hang; DataTable tmp = new DataTable(); new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql, ketnoi)).Fill(tmp); //khungHoaDon KHD = new khungHoaDon(); //DataTable BangChiTietSanPham = KHD.Tables["ChiTietSanPhamDonHang"]; DataTable BangChiTietSanPham = new DataTable(); BangChiTietSanPham.Columns.Add("Ten"); BangChiTietSanPham.Columns.Add("SL"); BangChiTietSanPham.Columns.Add("DG"); BangChiTietSanPham.Columns.Add("tamTinh"); BangChiTietSanPham.Columns.Add("Giam"); BangChiTietSanPham.Columns.Add("ThanhTien"); for (int i = 0; i < tmp.Rows.Count; i++) { DataRow x = BangChiTietSanPham.NewRow(); x["Ten"] = mH.Base64Decode(tmp.Rows[i][2].ToString()); x["SL"] = tmp.Rows[i][5].ToString(); x["DG"] = String.Format("{0:n0}", int.Parse(tmp.Rows[i][6].ToString())).Replace(",", ".") + " vnđ"; long tam1 = int.Parse(tmp.Rows[i][6].ToString()) * int.Parse(tmp.Rows[i][5].ToString()); long tam2 = int.Parse(tmp.Rows[i][7].ToString()) * int.Parse(tmp.Rows[i][5].ToString()); long tam3 = tam1 - tam2; x["tamTinh"] = String.Format("{0:n0}", tam1).Replace(",", ".") + " vnđ"; x["Giam"] = String.Format("{0:n0}", tam3).Replace(",", ".") + " vnđ"; x["ThanhTien"] = String.Format("{0:n0}", tam2).Replace(",", ".") + " vnđ"; BangChiTietSanPham.Rows.Add(x); } ReportViewer1.ProcessingMode = ProcessingMode.Local; ReportViewer1.LocalReport.ReportPath = Server.MapPath("Report1.rdlc"); // ReportParameter[] param = new ReportParameter[11]; param[0] = new ReportParameter("maDonHang", "#" + ds.Rows[0][0].ToString()); param[1] = new ReportParameter("hoTen", ds.Rows[0][1].ToString()); param[2] = new ReportParameter("SDT", ds.Rows[0][14].ToString()); param[3] = new ReportParameter("PTVC", ds.Rows[0][4].ToString()); param[4] = new ReportParameter("DCGH", ds.Rows[0][5].ToString()); param[5] = new ReportParameter("ngayDat", ds.Rows[0][10].ToString()); long tam = (long.Parse(ds.Rows[0][9].ToString()) - long.Parse(ds.Rows[0][8].ToString()) - long.Parse(ds.Rows[0][7].ToString())); param[6] = new ReportParameter("tongCong", String.Format(" {0:0,0}", tam).Replace(",", ".") + " vnđ"); param[7] = new ReportParameter("phiVanChuyen", String.Format(" {0:0,0}", long.Parse(ds.Rows[0][7].ToString())).Replace(",", ".") + " vnđ"); param[8] = new ReportParameter("phiThuHo", String.Format(" {0:0,0}", long.Parse(ds.Rows[0][8].ToString())).Replace(",", ".") + " vnđ"); param[9] = new ReportParameter("tongTienThanhToan", String.Format(" {0:0,0}", long.Parse(ds.Rows[0][9].ToString())).Replace(",", ".") + " vnđ"); param[10] = new ReportParameter("ngayBaoCao", DateTime.Now.ToString("dd/MM/yyyy")); ReportViewer1.LocalReport.SetParameters(param); // ReportDataSource datasource = new ReportDataSource("PhaiChinhXac", BangChiTietSanPham); ReportViewer1.LocalReport.DataSources.Clear(); ReportViewer1.LocalReport.DataSources.Add(datasource); } }
protected void Page_Load(object sender, EventArgs e) { id_loai_san_pham = 0; connect = new connect(); mH = new WebApplication2.QuanTri.maHoa(); try { if (Request.QueryString["id_loai_san_pham"] != null && Request.QueryString["id_loai_san_pham"] != "") { id_loai_san_pham = int.Parse(Request.QueryString["id_loai_san_pham"]); } } catch (Exception a) { } if (id_loai_san_pham == 0) { Response.Redirect("danhsachloaisanpham.aspx"); } System.Data.DataTable ds = new System.Data.DataTable(); { string sql = "select id_loai_san_pham, ten_loai_san_pham, anh_loai_san_pham, bieu_tuong_loai_san_pham, cap_do_loai_san_pham, id_cha_loai_san_pham from loai_san_pham where id_loai_san_pham=" + id_loai_san_pham; WebApplication2.YNNSHOP56131778.CONGFIG.connect cnt = new WebApplication2.YNNSHOP56131778.CONGFIG.connect(); System.Data.SqlClient.SqlConnection ketnoi = new System.Data.SqlClient.SqlConnection(connect.getconnect()); System.Data.SqlClient.SqlCommand lenh = new System.Data.SqlClient.SqlCommand(sql, ketnoi); ketnoi.Open(); System.Data.SqlClient.SqlDataAdapter data = new System.Data.SqlClient.SqlDataAdapter(lenh); data.Fill(ds); ketnoi.Close(); id_cha = ds.Rows[0][5].ToString(); if (!IsPostBack) { TextBox1.Text = mH.Base64Decode(ds.Rows[0][1].ToString()); TextBox4.Text = ds.Rows[0][4].ToString(); } //TextBox4.Text = ds.Rows[0][4].ToString(); } System.Data.DataTable lsp = new System.Data.DataTable(); { string sql = "select id_loai_san_pham, ten_loai_san_pham from loai_san_pham where cap_do_loai_san_pham = " + (int.Parse(TextBox4.Text) - 1); WebApplication2.YNNSHOP56131778.CONGFIG.connect cnt = new WebApplication2.YNNSHOP56131778.CONGFIG.connect(); System.Data.SqlClient.SqlConnection ketnoi = new System.Data.SqlClient.SqlConnection(connect.getconnect()); System.Data.SqlClient.SqlCommand lenh = new System.Data.SqlClient.SqlCommand(sql, ketnoi); ketnoi.Open(); System.Data.SqlClient.SqlDataAdapter data = new System.Data.SqlClient.SqlDataAdapter(lenh); data.Fill(lsp); ketnoi.Close(); for (int i = 0; i < lsp.Rows.Count; i++) { lsp.Rows[i][1] = mH.Base64Decode(lsp.Rows[i][1].ToString()); } if ((int.Parse(TextBox4.Text)) == 0) { System.Data.DataRow row; row = lsp.NewRow(); row[0] = 0; row[1] = "cao nhất"; lsp.Rows.Add(row); } DropDownList1.DataSource = lsp; DropDownList1.DataTextField = "ten_loai_san_pham"; DropDownList1.DataValueField = "id_loai_san_pham"; DropDownList1.DataBind(); try { DropDownList1.Items.FindByValue(id_cha + "").Selected = true; }catch (Exception a) { } } }