private void LoadData(string Id) { try { CuaHang ch = new CuaHang(); DataSet ds = ch.SelectByID(Convert.ToInt32(Id)); if (ds.Tables[0].Rows.Count > 0) { txtTenCuaHang.Text = ds.Tables[0].Rows[0]["TenCuaHang"].ToString(); if (ds.Tables[0].Rows[0]["LoaiCuaHang"].ToString() != "") { ddlLoaiGianHang.SelectedValue = ds.Tables[0].Rows[0]["LoaiCuaHangID"].ToString(); } else { ddlLoaiGianHang.SelectedIndex = 0; } } } catch (Exception ex) { Response.Write(ex.ToString()); } }
private void LoadGianHang() { CuaHang ch = new CuaHang(); DataSet ds = ch.SelectCuaHangAtViTriCuaHang(1); int n = ds.Tables[0].Rows.Count; for (int j = 0; j < 4; j++) { TableRow tr = new TableRow(); for (int i = 0; i < 4; i++) { TableCell td = new TableCell(); string content = ""; if (j*4 + i < n) { content += "<table width=\"100%\" border=\"0\" cellspacing=\"4\" cellpadding=\"0\">"; content += "<tr><td><a href=\"estore.aspx?sid=" + ds.Tables[0].Rows[j*4 + i]["CuaHangID"] + "\"><img src=\"" + ds.Tables[0].Rows[j*4 + i]["Anh"] + "\" width=\"110\" height=\"73\" style=\"border:#ece2a4 1px solid\" /></a></td>"; content += "<td><a href=\"estore.aspx?sid=" + ds.Tables[0].Rows[j*4 + i]["CuaHangID"] + "\"><b>" + ds.Tables[0].Rows[j*4 + i]["TenCuaHang"] + "</b></a></td></tr></table>"; } td.Text = content; td.HorizontalAlign = HorizontalAlign.Left; if (j == 0) td.Width = Unit.Percentage(25); tr.Cells.Add(td); } tblGianHang.Rows.Add(tr); } }
private bool CheckExistCuaHang(int id) { CuaHang ch = new CuaHang(); DataSet ds = ch.SelectByNguoiDungID(id); if (ds.Tables[0].Rows.Count > 0) return true; return false; }
protected void btnSave_Click(object sender, EventArgs e) { CuaHang ch = new CuaHang(); string path = Server.MapPath("../Upload/StoreImages"); string randomString = ""; string relativePath = ""; if (fileStore.PostedFile.FileName != "") { try { if (fileStore.PostedFile.ContentLength <= 300000) { int pos = fileStore.PostedFile.FileName.LastIndexOf('\\'); string absolutePath = path + "\\" + fileStore.PostedFile.FileName.Remove(0, pos + 1); if (File.Exists(absolutePath)) { randomString = DateTime.Now.Ticks + "_"; absolutePath = path + "\\" + randomString + fileStore.PostedFile.FileName.Remove(0, pos + 1); } //fileStore.PostedFile.SaveAs(absolutePath); Common.ResizeFromStream(absolutePath, 320, fileStore.PostedFile.InputStream); //File.Delete(Server.MapPath(imgAnhQuangCao.Src)); relativePath = "./Upload/StoreImages/" + randomString + fileStore.PostedFile.FileName.Remove(0, pos + 1); } else { Response.Redirect("../message.aspx?msg=File size is too big!"); return; } } catch (Exception ex) { Response.Redirect("../message.aspx?msg=" + ex.Message); return; } } if (relativePath != "") { ch.UpdateFields(sid, txtTen.Text, txtGioiThieu.Text, null, txtEmail.Text, relativePath, txtDiDong.Text, txtCoDinh.Text, txtLienHe.Text, txtDiaChi.Text, txtWebSite.Text, txtFax.Text, txtYahoo.Text, null, null, null, null, null, null, null, null, null, null, null, null, null, null); } else { ch.UpdateFields(sid, txtTen.Text, txtGioiThieu.Text, null, txtEmail.Text, null, txtDiDong.Text, txtCoDinh.Text, txtLienHe.Text, txtDiaChi.Text, txtWebSite.Text, txtFax.Text, txtYahoo.Text, null, null, null, null, null, null, null, null, null, null, null, null, null, null); } string strScript = "<script language='JavaScript'>" + "window.parent.RefreshStoreInfo();</script>"; ClientScript.RegisterStartupScript(GetType(), "Refresh", strScript); }
private void LoadHoTro() { CuaHang ch = new CuaHang(); DataSet ds = ch.SelectByNguoiDungID(Common.NguoiDungID()); if (ds.Tables[0].Rows.Count != 1) { Response.Redirect("../message.aspx?msg=You haven't got a store yet"); } else { DataRow dr = ds.Tables[0].Rows[0]; lblTenCuaHang.Text = dr["TenCuaHang"].ToString(); lblCoDinh.Text = dr["DienThoaiCoDinh"].ToString(); lblDiDong.Text = dr["DienThoaiDiDong"].ToString(); CuaHangID = int.Parse(dr["CuaHangID"].ToString()); } }
// Tạo cửa hàng protected void pnlUser_ContentRefresh(object sender, EventArgs e) { try { CuaHang cuahang = new CuaHang(); if (CheckExistCuaHang(int.Parse(hidID.Value)) != true) { cuahang.InsertFields(null, null, int.Parse(hidID.Value), null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, 3); } LoadGridData(); } catch (Exception ex) { Response.Write(ex.ToString()); } }
protected void btnLuu_Click(object sender, EventArgs e) { try { CuaHang ch = new CuaHang(); ch.UpdateFields(int.Parse(Request.QueryString["sid"]), null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, short.Parse(ddlBaoDam.SelectedValue),null, short.Parse(ddlLoaiGianHang.SelectedValue)); string strScript = "<script language='JavaScript'>" + "window.parent.Refresh();</script>"; ClientScript.RegisterStartupScript(GetType(), "Refresh", strScript); } catch (Exception ex) { Response.Write(ex.ToString()); } }
private void LoadCuaHang(int CuaHangID) { CuaHang ch = new CuaHang(); DataSet ds = ch.SelectByID(CuaHangID); if (ds.Tables[0].Rows.Count != 1) { Response.Redirect("./message.aspx?msg=Failed in loading store"); } else { DataRow dr = ds.Tables[0].Rows[0]; string content = ""; content += "Gian Hàng: " + dr["TenCuaHang"] + "<br/>"; content += "Địa chỉ liên hệ: " + dr["DiaChi"] + "<br/>"; content += "Điện thoại: " + dr["DienThoaiCoDinh"] + " - " + dr["DienThoaiDiDong"]; content += "Email: " + dr["Email"]; ViewState["email"] = dr["Email"].ToString(); divGianHang.InnerHtml = content; //content += int.Parse(dr["NguoiDungID"].ToString()); //switch (dr["LoaiCuaHang"].ToString()) //{ // case "1": // stsGianHang.Href = "GianHang/VIP/css/style.css"; // LoadTinTuc(); // break; // case "2": // stsGianHang.Href = "GianHang/CN/css/style.css"; // LoadTinTuc(); // break; // case "3": // stsGianHang.Href = "GianHang/TT/css/style.css"; // break; //} //if ((dr["LoaiCuaHang"].ToString() == "1") || // (dr["LoaiCuaHang"].ToString() == "2")) //{ // LoadTinTuc(); //} } }
private void LoadCuaHang() { CuaHang ch = new CuaHang(); DataSet ds = ch.SelectByID(CuaHangID); if (ds.Tables[0].Rows.Count != 1) { Response.Redirect("./message.aspx?msg=Failed in loading store"); } else { DataRow dr = ds.Tables[0].Rows[0]; lblTenCuaHang.Text = "<a href=\"estore.aspx?sid=" + dr["CuaHangID"] + "\">" + dr["TenCuaHang"] + "</a>"; lblGioiThieu.Text = dr["GioiThieu"].ToString(); lblDiaChi.Text = dr["DiaChi"].ToString(); lblEmail.Text = dr["Email"].ToString(); lblCoDinh.Text = dr["DienThoaiCoDinh"].ToString(); lblDiDong.Text = dr["DienThoaiDiDong"].ToString(); lblFax.Text = dr["Fax"].ToString(); lblBack.Text = "<a href=\"estore.aspx?sid=" + dr["CuaHangID"] + "\"><span style=\"color:blue;text-decoration:underline;\">QUAY LẠI TRANG TRƯỚC</span></a>"; } }
private int LoadCuaHang(int ViTriCuaHang, int KhuVucID) { if (Common.LoaiNguoiDungID() == 3) { //For administrator CuaHang ch = new CuaHang(); DataSet ds = ch.SelectAllCuaHangAtViTriCuaHang(ViTriCuaHang); ds.Tables[0].Columns.Add("Selected", Type.GetType("System.String")); ds.Tables[0].Columns["Selected"].DefaultValue = "false"; DataRow[] selectedRows = ds.Tables[0].Select("ViTriCuaHang=" + ViTriCuaHang + " AND KhuVucID=" + KhuVucID); for (int i = 0; i < selectedRows.Length; i++) { selectedRows[i]["Selected"] = "true"; } grdStore.DataSource = ds; grdStore.DataBind(); return selectedRows.Length; } else if (Common.LoaiNguoiDungID() == 2) { //For e-store manager QuangCao qcao = new QuangCao(); CuaHang ch = new CuaHang(); DataSet ds = ch.SelectAllCuaHangAtViTriCuaHangByNguoiDungID(Common.NguoiDungID(), ViTriCuaHang); ds.Tables[0].Columns.Add("Selected", Type.GetType("System.String")); ds.Tables[0].Columns["Selected"].DefaultValue = "false"; DataRow[] selectedRows = ds.Tables[0].Select("ViTriCuaHang=" + ViTriCuaHang + " AND KhuVucID=" + KhuVucID); for (int i = 0; i < selectedRows.Length; i++) { selectedRows[i]["Selected"] = "true"; } grdStore.DataSource = ds; grdStore.DataBind(); return selectedRows.Length; } return 0; }
private void LoadCuaHang() { CuaHang ch = new CuaHang(); DataSet ds = ch.SelectByID(CuaHangID); if (ds.Tables[0].Rows.Count != 1) { Response.Redirect("./message.aspx?msg=Failed in loading store"); } else { DataRow dr = ds.Tables[0].Rows[0]; //lblTenCuaHang.Text = dr["TenCuaHang"].ToString(); //lblDiaChi.Text = dr["DiaChi"].ToString(); //lblDTCD.Text = dr["DienThoaiCoDinh"].ToString(); //lblDTDD.Text = dr["DienThoaiDiDong"].ToString(); ChuCuaHangID = int.Parse(dr["NguoiDungID"].ToString()); //imgLoGo.Src = dr["Anh"].ToString(); //switch (dr["LoaiCuaHang"].ToString()) //{ // case "1": // stsGianHang.Href = "GianHang/VIP/css/style.css"; // //LoadTinTuc(); // break; // case "2": // stsGianHang.Href = "GianHang/CN/css/style.css"; // //LoadTinTuc(); // break; // case "3": // stsGianHang.Href = "GianHang/TT/css/style.css"; // break; // default: // stsGianHang.Href = "GianHang/TT/css/style.css"; // break; //} //if ((dr["LoaiCuaHang"].ToString() == "1") || // (dr["LoaiCuaHang"].ToString() == "2")) //{ // LoadTinTuc(); //} } }
private void LoadCuaHang() { CuaHang ch = new CuaHang(); DataSet ds = ch.SelectByID(CuaHangID); if (ds.Tables[0].Rows.Count != 1) { Response.Redirect("./message.aspx?msg=Failed in loading store"); } else { DataRow dr = ds.Tables[0].Rows[0]; ChuCuaHangID = int.Parse(dr["NguoiDungID"].ToString()); } }
private void LoadCuaHang() { if (Session["UserFullName"] != null) { tblchaomung.Visible = true; divDangNhap.Visible = false; } CuaHang ch = new CuaHang(); DataSet ds = ch.SelectByCuaHangID(CuaHangID); if (ds.Tables[0].Rows.Count != 1) { Response.Redirect("./message.aspx?msg=Failed in loading store"); } else { DataRow dr = ds.Tables[0].Rows[0]; lblLienHe.Text = dr["TenCuaHang"].ToString() + " " + dr["DiaChi"].ToString() + " - " + dr["DienThoaiCoDinh"].ToString() + " - " + dr["DienThoaiDiDong"].ToString(); ChuCuaHangID = int.Parse(dr["NguoiDungID"].ToString()); ViewState["chucuahangid"] = ChuCuaHangID; LoaiGianHangID = dr["LoaiCuaHangID"].ToString(); //switch (dr["LoaiCuaHangID"].ToString()) //{ // //case "1": // // stsGianHang.Href = "GianHang/VIP/css/style.css"; // // //LoadTinTuc(); // // break; // case "2": // stsGianHang.Href = "GianHang/CN/css/style.css"; // //LoadTinTuc(); // break; // case "3": // stsGianHang.Href = "GianHang/TT/css/style.css"; // break; // default: // stsGianHang.Href = "GianHang/" + dr["TenLoaiCuaHang"].ToString() + "/css/style.css"; // break; //} //if ((dr["LoaiCuaHang"].ToString() == "1") || // (dr["LoaiCuaHang"].ToString() == "2")) //{ // //LoadTinTuc(); //} } }
private void LoadCuaHang(int sid) { CuaHang ch = new CuaHang(); DataSet ds = ch.SelectByID(sid); if (ds.Tables[0].Rows.Count == 1) { DataRow dr = ds.Tables[0].Rows[0]; txtTen.Text = dr["TenCuaHang"].ToString(); txtDiaChi.Text = dr["DiaChi"].ToString(); txtCoDinh.Text = dr["DienThoaiCoDinh"].ToString(); txtDiDong.Text = dr["DienThoaiDiDong"].ToString(); txtFax.Text = dr["Fax"].ToString(); txtEmail.Text = dr["Email"].ToString(); ; txtWebSite.Text = dr["WebSite"].ToString(); txtYahoo.Text = dr["YM"].ToString(); txtLienHe.Text = dr["ThongTinLienHe"].ToString(); txtGioiThieu.Text = dr["GioiThieu"].ToString(); imgStore.ImageUrl = "." + dr["Anh"]; } else { Response.Redirect("../message.aspx?msg=Invalid parameter"); } }
void Page_PreInit(Object sender, EventArgs e) { CuaHang ch = new CuaHang(); DataSet ds = ch.SelectByCuaHangID(int.Parse(Request["sid"])); if ((ds.Tables[0].Rows.Count > 0) && (ds.Tables[0].Rows[0]["LoaiCuaHangID"].ToString() == "26")) { //ContentPlaceHolderID = "contentEstore"; this.MasterPageFile = "NewEstoreMaster.master"; } if (Session["masterpage"] != null) { this.MasterPageFile = (String)Session["masterpage"]; } }
//protected void grdSanPham_InitializeLayout(object sender, Infragistics.WebUI.UltraWebGrid.LayoutEventArgs e) //{ // e.Layout.Grid.Columns.FromKey("Command").AllowRowFiltering = false; // e.Layout.Grid.Columns.FromKey("TenSanPham").FilterOperatorDefaultValue = FilterComparisionOperator.Contains; // e.Layout.Grid.Columns.FromKey("Dates").FilterOperatorDefaultValue = FilterComparisionOperator.Contains; // e.Layout.Grid.Columns.FromKey("TenNhomSanPham").FilterOperatorDefaultValue = FilterComparisionOperator.Contains; // //if (rbtTatCa.Checked == true) // //{ // // e.Layout.Pager.AllowPaging = false; // //} // //else // //{ // // e.Layout.Pager.AllowPaging = true; // //} //} //protected void rbtPhanTrang_CheckedChanged(object sender, EventArgs e) //{ // LoadData(); //} //protected void rbtTatCa_CheckedChanged(object sender, EventArgs e) //{ // LoadData(); //} private void LoadGianHang() { CuaHang ch = new CuaHang(); DataSet ds = ch.SelectAll(); ddlGianHang.DataSource = ds.Tables[0]; ddlGianHang.DataTextField = "TenCuaHang"; ddlGianHang.DataValueField = "CuaHangID"; ddlGianHang.DataBind(); ddlGianHang.Items.Insert(0, "Tất cả gian hàng"); ddlGianHang.SelectedIndex = 0; }
private void RedirectToCuahangbyUrlName() { string url = Request.RawUrl.ToLower(); if (url.IndexOf("estore.aspx") == -1) { string[] urls = url.Split('/'); string tencuahang = urls[urls.Length - 1]; CuaHang ch = new CuaHang(); DataSet ds = ch.SelectByField("TenCuaHang", tencuahang, "nvarchar"); if (ds.Tables[0].Rows.Count > 0) { Response.Redirect("Estore.aspx?sid=" + ds.Tables[0].Rows[0]["CuaHangID"]); } } }
private void LoadSanPhamTheoMau(int spmid) { try { SanPhamMau spm = new SanPhamMau(); DataSet ds = spm.SelectByID(spmid); if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; int NhomSanPhamID = int.Parse(dr["NhomSanPhamID"].ToString()); CuaHang ch = new CuaHang(); DataSet dsch = ch.SelectByNguoiDungID(Common.NguoiDungID()); int CuaHangID = int.Parse(dsch.Tables[0].Rows[0]["CuaHangID"].ToString()); if (checkNhomSanPham(NhomSanPhamID, CuaHangID) == false) { AddNhomSanPhamToCuaHang(NhomSanPhamID, CuaHangID); ddlNhomSanPham.Items.Clear(); LoadDanhMucConForDropDown(0, CuaHangID, 0); ddlNhomSanPham.SelectedValue = NhomSanPhamID.ToString(); } ddlNhomSanPham.SelectedValue = dr["NhomSanPhamID"].ToString(); txtTenSanPham.Text = dr["TenSanPham"].ToString(); //txtMaSoSanPham.Text = dr["MaSoSanPham"].ToString(); txtGiaSanPham.Text = dr["GiaSanPham"].ToString(); ddlHangSanXuat.SelectedValue = dr["HangSanXuatID"].ToString(); ddlKhuVuc.SelectedValue = dr["KhuVucID"].ToString(); chkKhuyenMai.Checked = dr["KhuyenMai"].ToString() != "" ? bool.Parse(dr["KhuyenMai"].ToString()) : false; chkGiamGia.Checked = dr["GiamGia"].ToString() != "" ? bool.Parse(dr["GiamGia"].ToString()) : false; //txtMoTaSanPham.Text = dr["MoTaSanPham"].ToString(); wheMoTaSanPham.Text = dr["MoTaSanPham"].ToString(); imgAnhChinh.ImageUrl = "." + dr["AnhSanPham"]; wheThongTinSanPham.Text = dr["ThongTinSanPham"].ToString(); hidAnhChinh.Value = dr["AnhSanPham"].ToString(); if (chkGiamGia.Checked) { cvGiaMoi.Enabled = true; txtGiaMoi.Enabled = true; txtGiaMoi.Text = dr["GiaKhuyenMai"].ToString(); } else { txtGiaMoi.Enabled = false; } //txtDonViTienTe.Text = dr["DonViTienTe"].ToString(); //txtThongTinSanPham.Text = dr["ThongTinSanPham"].ToString(); LoadAnhPhuTheoMau(spmid); LoadThuocTinhCha(); LoadThuocTinh(); if (chkKhuyenMai.Checked) { wdcBatDauKM.Enabled = true; wdcBatDauKM.Value = DateTime.Parse(dr["BatDauKhuyenMai"].ToString()); wdcKetThucKM.Enabled = true; wdcKetThucKM.Value = DateTime.Parse(dr["KetThucKhuyenMai"].ToString()); txtMoTaKhuyenMai.Enabled = true; txtMoTaKhuyenMai.Text = dr["MoTaKhuyenMai"].ToString(); cvKhuyenMai.Enabled = true; } else { txtMoTaKhuyenMai.Enabled = false; wdcBatDauKM.Enabled = false; wdcKetThucKM.Enabled = false; } } } catch (Exception ex) { Response.Write(ex.ToString()); } }
private void LoadCuaHang() { CuaHang ch = new CuaHang(); DataSet ds = ch.SelectByNguoiDungID(Common.NguoiDungID()); if (ds.Tables[0].Rows.Count != 1) { Response.Redirect("../message.aspx?msg=You haven't got a store yet"); } else { DataRow dr = ds.Tables[0].Rows[0]; //lblTenCuaHang.Text = dr["TenCuaHang"].ToString(); CuaHangID = int.Parse(dr["CuaHangID"].ToString()); imgLogo.Src = "." + dr["Anh"].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (Common.LoaiNguoiDungID() == 2) { LoadCuaHang(); } lbluser.Text = Page.User.Identity.Name; if (Common.LoaiNguoiDungID() == 3) { //Administrator mnuChoNet.Items[0].Hidden = false; mnuChoNet.Items[7].Hidden = false; //mnuChoNet.Items[1].Hidden = true; //mnuChoNet.Items[7].Hidden = true; mnuChoNet.Items[2].Items[1].Hidden = false; //mnuChoNet.Items[2].Items[2].Hidden = false; mnuChoNet.Items[2].Items[3].Hidden = false; mnuChoNet.Items[6].Items[0].Hidden = false; mnuChoNet.Items[6].Items[1].Hidden = false; mnuChoNet.Items[6].Items[2].Hidden = true; mnuChoNet.Items[6].Items[3].Hidden = false; mnuChoNet.Items[6].Items[4].Hidden = true; mnuChoNet.Items[6].Items[5].Hidden = true; mnuChoNet.Items[6].Items[6].Hidden = true; } else if (Common.LoaiNguoiDungID() == 2) { //e-Store mnuChoNet.Items[0].Hidden = true; //mnuChoNet.Items[8].Hidden = true; //mnuChoNet.Items[1].Hidden = false; mnuChoNet.Items[7].Hidden = true; mnuChoNet.Items[2].Items[1].Hidden = true; //mnuChoNet.Items[2].Items[2].Hidden = true; mnuChoNet.Items[2].Items[3].Hidden = true; mnuChoNet.Items[6].Items[0].Hidden = true; mnuChoNet.Items[6].Items[1].Hidden = true; mnuChoNet.Items[6].Items[2].Hidden = true; mnuChoNet.Items[6].Items[3].Hidden = true; mnuChoNet.Items[6].Items[4].Hidden = false; mnuChoNet.Items[6].Items[5].Hidden = false; mnuChoNet.Items[6].Items[6].Hidden = false; CuaHang ch = new CuaHang(); DataSet ds = ch.SelectByNguoiDungID(Common.NguoiDungID()); if ((ds.Tables[0].Rows.Count > 0) && ((ds.Tables[0].Rows[0]["LoaiCuaHang"].ToString() == "1") || (ds.Tables[0].Rows[0]["LoaiCuaHang"].ToString() == "2"))) { mnuChoNet.Items[3].Hidden = false; } else { mnuChoNet.Items[3].Hidden = true; } lblTenCongTy.Text = "<b>CÔNG TY TNHH TM quảng cáo trực tuyến CN</b><br/>TEL: 09808080808"; } else { Response.Redirect("../message.aspx?msg=Access denied"); } } }
private void LoadCuaHang() { CuaHang ch = new CuaHang(); DataSet ds = ch.SelectByID(sid); if (ds.Tables[0].Rows.Count == 1) { DataRow dr = ds.Tables[0].Rows[0]; imgStore.ImageUrl = "." + dr["Anh"]; } else { Response.Redirect("../message.aspx?msg=Invalid parameter"); } }
private string GetThongTinCuaHang(int NguoiDungID, out int chid, out string tench) { CuaHang ch = new CuaHang(); DataSet ds = ch.SelectByNguoiDungID(NguoiDungID); string strThongTin = ""; chid = 0; tench = ""; if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; chid = int.Parse(dr["CuaHangID"].ToString()); tench = dr["TenCuaHang"].ToString(); strThongTin = "<p><b>Giỏ hàng của bạn tại công ty: <a class=pathway href='EStore.aspx?sid=" + dr["CuaHangID"] + "'>" + dr["TenCuaHang"] + "</a><br>"; strThongTin += "Liên hệ theo số điện thoại: " + dr["DienThoaiCoDinh"] + ", " + dr["DienThoaiDiDong"] + " </b></p>"; } return strThongTin; }
//loai cua hang = 1 -> VIP //loai cua hang = 2 -> Chuyên nghiệp //loai cua hang = 0 -> Binh Thuong private void LoadGianHang(int LoaiCuaHang, int CurrentPage) { tblGianHang.Rows.Clear(); int RowStart = (CurrentPage - 1)*PageSize + 1; CuaHang ch = new CuaHang(); DataSet ds = new DataSet(); int NhomSanPhamID = 0; if (Request.QueryString["cid"] != null) NhomSanPhamID = int.Parse(Request.QueryString["cid"]); if (LoaiCuaHang != 0) { ds = ch.SelectCuaHangInLoaiCuaHangNhomSanPhamIDPaging(txtKeySearch.Text, LoaiCuaHang, NhomSanPhamID, RowStart, PageSize); } else { if (NhomSanPhamID == 0) ds = ch.SelectAllCuaHangPaging(txtKeySearch.Text, RowStart, PageSize); else ds = ch.SelectAllCuaHangByNhomSanPhamIDPaging(NhomSanPhamID, txtKeySearch.Text, RowStart, PageSize); } int n = ds.Tables[0].Rows.Count; for (int j = 0; j < 10; j++) { TableRow tr = new TableRow(); for (int i = 0; i < 2; i++) { TableCell td = new TableCell(); string content = ""; if (j*2 + i < n) { DataRow dr = ds.Tables[0].Rows[j * 2 + i]; content += "<table width=\"100%\" border=\"0\" cellspacing=\"4\" cellpadding=\"0\">"; if (dr["LoaiCuaHangID"].ToString() == "26") { content += "<tr><td style=\"widht:110px\"><a href=\"Newestore.aspx?sid=" + dr["CuaHangID"] + "\"><img src=\"" + dr["Anh"] + "\" width=\"110\" height=\"73\" style=\"border:#ece2a4 1px solid\" /></a></td>"; content += "<td style=\"width:80%\"><a href=\"Newestore.aspx?sid=" + dr["CuaHangID"] + "\"><b>" + dr["TenCuaHang"] + "</b><br> Đánh giá: "; } else { content += "<tr><td style=\"widht:110px\"><a href=\"estore.aspx?sid=" + dr["CuaHangID"] + "\"><img src=\"" + dr["Anh"] + "\" width=\"110\" height=\"73\" style=\"border:#ece2a4 1px solid\" /></a></td>"; content += "<td style=\"width:80%\"><a href=\"estore.aspx?sid=" + dr["CuaHangID"] + "\"><b>" + dr["TenCuaHang"] + "</b><br> Đánh giá: "; } int sodiem = (int) decimal.Parse("0" + dr["diem"]); for (int m = 0; m < sodiem; m++) { content += "<img align=\"absmiddle\" border=\"0\" src=\"./images/star1.gif\">"; } for (int m = 10; m > sodiem; m--) { content += "<img align=\"absmiddle\" border=\"0\" src=\"./images/star0.gif\">"; } content += string.Format("{0:0.0}", decimal.Parse("0" + dr["diem"])); if (dr["LoaiCuaHang"].ToString() == "1") { content += "<br><img border=0 src=\"./images/store2.jpg\" /><img src=\"./images/vip.jpg\" border=0 />"; } else { content += "<br><img border=0 src=\"./images/store1.jpg\" />"; } content += "</a></td></tr></table>"; } td.Text = content; td.HorizontalAlign = HorizontalAlign.Left; if (j == 0) td.Width = Unit.Percentage(50); tr.Cells.Add(td); } tblGianHang.Rows.Add(tr); } int NumberOfRow = int.Parse(ds.Tables[1].Rows[0]["Total"].ToString()); int NumberOfPage = NumberOfRow/PageSize; if (NumberOfPage*PageSize < NumberOfRow) NumberOfPage += 1; string strPage = "Trang"; for (int i = 1; i <= NumberOfPage; i++) { if (i == CurrentPage) { strPage += " [" + i + "]"; } else { strPage += " <a href=\"javascript:GoToPage(" + i + ")\">" + i + "</a>"; } } lblPage.Text = strPage; ddlPage.Items.Clear(); for (int i = 1; i <= NumberOfPage; i++) { ListItem li = new ListItem(i.ToString(), i.ToString()); if (i == CurrentPage) li.Selected = true; ddlPage.Items.Add(li); } }
private void LoadCuaHang() { try { CuaHang ch = new CuaHang(); DataSet ds = ch.SelectByNguoiDungID(Common.NguoiDungID()); if (ds.Tables[0].Rows.Count == 1) { DataRow dr = ds.Tables[0].Rows[0]; Session["CuaHangID"] = dr["CuaHangID"].ToString(); } } catch (Exception ex) { Response.Write(ex.ToString()); } }
private void LoadDropDownDaTa() { try { CuaHang ch = new CuaHang(); DataSet dsch; string cacheCh = "ch" + Common.NguoiDungID(); if (Cache[cacheCh] == null) { dsch = ch.SelectByNguoiDungID(Common.NguoiDungID()); Cache.Insert(cacheCh, dsch); } else { dsch = (DataSet) Cache[cacheCh]; } if (dsch.Tables[0].Rows.Count > 0) { LoadDanhMucConForDropDown(0, int.Parse(dsch.Tables[0].Rows[0]["CuaHangID"].ToString()), 0); } HangSanXuat hangsanxuat = new HangSanXuat(); DataSet dsHangSanXuat = hangsanxuat.SelectAll(); if (Cache["hsx"] == null) { dsHangSanXuat = hangsanxuat.SelectAll(); Cache.Insert("hsx", dsHangSanXuat); } else { dsHangSanXuat = (DataSet) Cache["hsx"]; } DataTable dtHangSanXuat = dsHangSanXuat.Tables[0]; ddlHangSanXuat.DataSource = dtHangSanXuat; ddlHangSanXuat.DataTextField = "TenHangSanXuat"; ddlHangSanXuat.DataValueField = "HangSanXuatID"; ddlHangSanXuat.DataBind(); KhuVuc khuvuc = new KhuVuc(); DataSet dsKhuVuc; if (Cache["kv"] == null) { dsKhuVuc = khuvuc.SelectAll(); Cache.Insert("kv", dsKhuVuc); } else { dsKhuVuc = (DataSet) Cache["kv"]; } DataTable dtKhuVuc = dsKhuVuc.Tables[0]; ddlKhuVuc.DataSource = dtKhuVuc; ddlKhuVuc.DataTextField = "TenKhuVuc"; ddlKhuVuc.DataValueField = "KhuVucID"; ddlKhuVuc.DataBind(); } catch (Exception ex) { Response.Write(ex.ToString()); } }