private void LoadData(string strType) { if (strType == "1") { string strID = Request.QueryString["value"];//操作ID zlzw.BLL.BannerListBLL bannerListBLL = new zlzw.BLL.BannerListBLL(); zlzw.Model.BannerListModel bannerListModel = bannerListBLL.GetModel(int.Parse(Get_BannerID(strID))); txbBannerTitle.Text = bannerListModel.BannerTitle; //焦点图名称 txbBannerContent.Text = bannerListModel.BannerContent; //焦点图简介 txbBannerLinks.Text = bannerListModel.BannerLinks; //焦点图链接地址 if (bannerListModel.IsHot == 1) { ckbIsHot.Checked = true; } else { ckbIsHot.Checked = false; } labPreviweImg.ImageUrl = bannerListModel.BannerImage.Split('~')[1]; ViewState["BannerImage"] = bannerListModel.BannerImage;//焦点图路径 ViewState["PublishDate"] = bannerListModel.PublishDate.ToString(); ViewState["BannerGUID"] = bannerListModel.BannerGUID.ToString(); ToolbarText2.Text = "编辑一个焦点图"; } btnClose.OnClientClick = ActiveWindow.GetConfirmHideReference(); }
protected void btnDel_Click(object sender, EventArgs e) { if (grid1.SelectedRowIndexArray != null && grid1.SelectedRowIndexArray.Length > 0) { string strSelectID = "0"; for (int i = 0, count = grid1.SelectedRowIndexArray.Length; i < count; i++) { int rowIndex = grid1.SelectedRowIndexArray[i]; foreach (object key in grid1.DataKeys[rowIndex]) { strSelectID = key.ToString(); } } #region 删除逻辑 zlzw.BLL.BannerListBLL BannerListBLL = new zlzw.BLL.BannerListBLL(); zlzw.Model.BannerListModel bannerListModel = BannerListBLL.GetModel(int.Parse(Get_BannerID(strSelectID))); bannerListModel.IsEnable = 0; BannerListBLL.Update(bannerListModel); BannerList_BindGrid(); #endregion } else { return; } }
private string Get_BannerID(string strBannerGUID) { zlzw.BLL.BannerListBLL bannerListBLL = new zlzw.BLL.BannerListBLL(); DataTable dt = bannerListBLL.GetList("BannerGUID='" + strBannerGUID + "'").Tables[0]; return(dt.Rows[0]["BannerID"].ToString()); }
private void BannerList_BindGrid() { zlzw.BLL.BannerListBLL bannerListBLL = new zlzw.BLL.BannerListBLL(); DataTable dt = bannerListBLL.GetList(grid1.PageSize, grid1.PageIndex + 1, "*", "PublishDate", 0, "desc", "IsEnable=1 and BannerType=0").Tables[0]; grid1.DataSource = dt; grid1.DataBind(); }
private void Load_labAdvertisingInfo() { zlzw.BLL.BannerListBLL bannerListBLL = new zlzw.BLL.BannerListBLL(); DataTable dt = bannerListBLL.GetList(1, "BannerType=1 and IsEnable=1 and IsHot=1", "PublishDate desc").Tables[0]; if (dt.Rows.Count > 0) { labAdvertising.Text = "<a href='" + dt.Rows[0]["BannerLinks"].ToString() + "' target='_blank'><img style='border:0px;' width='1000' src='" + dt.Rows[0]["BannerImage"].ToString().Split('~')[1] + "' alt='" + dt.Rows[0]["BannerTitle"].ToString() + "'/></a>"; } }
/// <summary> /// 获取总页数 /// </summary> /// <returns></returns> private int Get_BannerListTotalCount() { zlzw.BLL.BannerListBLL bannerListBLL = new zlzw.BLL.BannerListBLL(); DataTable dt = bannerListBLL.GetList("").Tables[0]; if (dt.Rows.Count > 0) { return dt.Rows.Count; } else { return 0; } }
public string Get_BannerList() { zlzw.BLL.BannerListBLL bannerListBLL = new zlzw.BLL.BannerListBLL(); DataTable dt = bannerListBLL.GetList("BannerType=0 and IsHot=1 and IsEnable=1").Tables[0]; System.Text.StringBuilder strBuilder = new System.Text.StringBuilder(); for (int nCount = 0; nCount < dt.Rows.Count; nCount++) { strBuilder.Append("<div><a target='_blank' href='" + dt.Rows[nCount]["BannerLinks"].ToString() + "'><img style='border:0px;' src='" + dt.Rows[nCount]["BannerImage"].ToString().Split('~')[1] + "' alt='' /></a></div>"); } return(strBuilder.ToString()); }
/// <summary> /// 获取总页数 /// </summary> /// <returns></returns> private int Get_SpecialTopicTotalCount() { zlzw.BLL.BannerListBLL bannerListBLL = new zlzw.BLL.BannerListBLL(); DataTable dt = bannerListBLL.GetList("IsEnable=1 and BannerType=1").Tables[0]; if (dt.Rows.Count > 0) { return(dt.Rows.Count); } else { return(0); } }
protected void btnSaveRefresh_Click(object sender, EventArgs e) { if (Request.QueryString["Type"] == "1") { //编辑保存 zlzw.Model.BannerListModel bannerListModel = new zlzw.Model.BannerListModel(); bannerListModel.BannerTitle = txbBannerTitle.Text; bannerListModel.BannerContent = txbBannerContent.Text; bannerListModel.BannerType = 1; bannerListModel.IsEnable = 1; bannerListModel.BannerLinks = txbBannerLinks.Text; if (btnBannerUpload.PostedFile.ContentLength > 0) { btnBannerUpload.SaveAs(Server.MapPath(ViewState["BannerImage"].ToString())); bannerListModel.BannerImage = ViewState["BannerImage"].ToString();//保存横幅广告路径 } else { bannerListModel.BannerImage = ViewState["BannerImage"].ToString(); } if (ckbIsHot.Checked) { bannerListModel.IsHot = 1; } else { bannerListModel.IsHot = 0; } bannerListModel.PublishDate = DateTime.Parse(ViewState["PublishDate"].ToString()); bannerListModel.BannerGUID = new Guid(ViewState["BannerGUID"].ToString()); bannerListModel.BannerID = int.Parse(Get_BannerID(Request.QueryString["value"])); zlzw.BLL.BannerListBLL bannerListBLL = new zlzw.BLL.BannerListBLL(); bannerListBLL.Update(bannerListModel); } else { //添加保存 zlzw.Model.BannerListModel bannerListModel = new zlzw.Model.BannerListModel(); bannerListModel.BannerTitle = txbBannerTitle.Text; bannerListModel.BannerContent = txbBannerContent.Text; bannerListModel.BannerType = 1; bannerListModel.IsEnable = 1; bannerListModel.BannerLinks = txbBannerLinks.Text; if (btnBannerUpload.PostedFile.ContentLength > 0) { string fileName = DateTime.Now.Ticks.ToString() + "_" + btnBannerUpload.FileName; btnBannerUpload.SaveAs(Server.MapPath("~/BannerImages/" + fileName)); bannerListModel.BannerImage = "~/BannerImages/" + fileName;//保存横幅广告路径 } else { Alert.Show("请上传一张宽度为910的横幅广告", "错误提醒", MessageBoxIcon.Error); return; } if (ckbIsHot.Checked) { bannerListModel.IsHot = 1; } else { bannerListModel.IsHot = 0; } bannerListModel.PublishDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")); bannerListModel.BannerGUID = System.Guid.NewGuid(); zlzw.BLL.BannerListBLL bannerListBLL = new zlzw.BLL.BannerListBLL(); bannerListBLL.Add(bannerListModel); } // 2. Close this window and Refresh parent window PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); }