private void Load_NavigateConten(string strType) { if (strType == "hr") { zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL(); System.Data.DataTable dt = generalBasicSettingBLL.GetList("DisplayName='" + strType + "'").Tables[0]; zlzw.BLL.ExchangeCornerListBLL exchangeCornerListBLL = new zlzw.BLL.ExchangeCornerListBLL(); System.Data.DataTable dt01 = exchangeCornerListBLL.GetList("ExchangeCornerTypeKey='" + dt.Rows[0]["SettingKey"].ToString() + "'").Tables[0]; titleName.Text = dt01.Rows[0]["ExchangeCornerTitle"].ToString(); System.Text.StringBuilder strBuilder = new System.Text.StringBuilder(); strBuilder.Append("<table style='width:100%;'><tr><td algin='center' style='width:38%;font-size:14px;'>文件名称</td><td style='font-size:14px;'>文件大小</td><td style='font-size:14px;'>发布日期</td><td style='font-size:14px;'>点击下载</td></tr>"); for (int nCount = 0; nCount < dt01.Rows.Count; nCount++) { strBuilder.Append("<tr><td algin='center'><a href='" + dt01.Rows[nCount]["ExchangeCornerFilePath"].ToString().Split('~')[1] + "' style='text-decoration:none;color:#000; href='" + dt01.Rows[nCount]["ExchangeCornerFilePath"].ToString().Split('~')[1] + "' style='color:#355F95;font-weight:bold;text-decoration:none;''>" + dt01.Rows[nCount]["ExchangeCornerTitle"].ToString() + "</a></td><td algin='center'>" + Get_FileSize(int.Parse(dt01.Rows[nCount]["ExchangeCornerFileSize"].ToString())) + "</td><td algin='center'>" + Set_DateFormat(dt01.Rows[nCount]["PublishDate"].ToString()) + "</td><td algin='center'><a href='" + dt01.Rows[nCount]["ExchangeCornerFilePath"].ToString().Split('~')[1] + "' style='color:#355F95;font-weight:bold;text-decoration:none;'>下载地址</td></tr>"); } strBuilder.Append("</table>"); labContent.Text = strBuilder.ToString(); } else { zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL(); System.Data.DataTable dt = generalBasicSettingBLL.GetList("DisplayName='" + strType + "'").Tables[0]; zlzw.BLL.ExchangeCornerListBLL exchangeCornerListBLL = new zlzw.BLL.ExchangeCornerListBLL(); System.Data.DataTable dt01 = exchangeCornerListBLL.GetList("ExchangeCornerTypeKey='" + dt.Rows[0]["SettingKey"].ToString() + "'").Tables[0]; titleName.Text = dt01.Rows[0]["ExchangeCornerTitle"].ToString(); labContent.Text = dt01.Rows[0]["exchangecornercontent"].ToString(); } }
private void ExchangeCornerList_BindGrid() { zlzw.BLL.ExchangeCornerListBLL exchangeCornerListBLL = new zlzw.BLL.ExchangeCornerListBLL(); DataTable dt = exchangeCornerListBLL.GetList(grid1.PageSize, grid1.PageIndex + 1, "*", "PublishDate", 0, "asc", "IsEnable=1").Tables[0]; grid1.DataSource = dt; grid1.DataBind(); }
/// <summary> /// 获取总页数 /// </summary> /// <returns></returns> private int Get_ExchangeCornerListTotalCount() { zlzw.BLL.ExchangeCornerListBLL exchangeCornerListBLL = new zlzw.BLL.ExchangeCornerListBLL(); DataTable dt = exchangeCornerListBLL.GetList("IsEnable=1").Tables[0]; if (dt.Rows.Count > 0) { return dt.Rows.Count; } else { return 0; } }
private void LoadData(string strType) { if (strType == "1") { string strID = Request.QueryString["value"];//操作ID zlzw.BLL.ExchangeCornerListBLL exchangeCornerListBLL = new zlzw.BLL.ExchangeCornerListBLL(); zlzw.Model.ExchangeCornerListModel exchangeCornerListModel = exchangeCornerListBLL.GetModel(int.Parse(Get_ID(exchangeCornerListBLL, strID))); txbExchangeCornerTitle.Text = exchangeCornerListModel.ExchangeCornerTitle;//标题 drpExchangeCornerTypeKey.SelectedValue = exchangeCornerListModel.ExchangeCornerTypeKey;//所属分类 txbContent.Text = exchangeCornerListModel.ExchangeCornerContent; ViewState["FilePath"] = exchangeCornerListModel.ExchangeCornerFilePath;//文件路径 ViewState["FileSize"] = exchangeCornerListModel.ExchangeCornerFileSize;//文件尺寸 ViewState["PublishDate"] = exchangeCornerListModel.PublishDate.ToString(); ViewState["ExchangeCornerGUID"] = exchangeCornerListModel.ExchangeCornerGUID.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.ExchangeCornerListBLL exchangeCornerListBLL = new zlzw.BLL.ExchangeCornerListBLL(); DataTable dt = exchangeCornerListBLL.GetList("ExchangeCornerGUID='" + strSelectID + "'").Tables[0]; zlzw.Model.ExchangeCornerListModel exchangeCornerListModel = exchangeCornerListBLL.GetModel(int.Parse(dt.Rows[0]["ExchangeCornerID"].ToString())); exchangeCornerListModel.IsEnable = 0; exchangeCornerListBLL.Update(exchangeCornerListModel); ExchangeCornerList_BindGrid(); #endregion } else { return; } }
protected void btnSaveRefresh_Click(object sender, EventArgs e) { if (Request.QueryString["Type"] == "1") { //编辑保存 zlzw.Model.ExchangeCornerListModel exchangeCornerListModel = new zlzw.Model.ExchangeCornerListModel(); exchangeCornerListModel.ExchangeCornerTitle = txbExchangeCornerTitle.Text; exchangeCornerListModel.ExchangeCornerTypeKey = drpExchangeCornerTypeKey.SelectedValue; exchangeCornerListModel.IsEnable = 1; exchangeCornerListModel.ExchangeCornerContent = txbContent.Text; if (fileExchangeCornerFilePath.PostedFile.ContentLength > 0) { fileExchangeCornerFilePath.SaveAs(Server.MapPath(ViewState["FilePath"].ToString())); exchangeCornerListModel.ExchangeCornerFilePath = ViewState["FilePath"].ToString(); exchangeCornerListModel.ExchangeCornerFileSize = ViewState["FileSize"].ToString(); } else { exchangeCornerListModel.ExchangeCornerFilePath = ViewState["FilePath"].ToString(); exchangeCornerListModel.ExchangeCornerFileSize = fileExchangeCornerFilePath.PostedFile.ContentLength.ToString(); } exchangeCornerListModel.PublishDate = DateTime.Parse(ViewState["PublishDate"].ToString()); exchangeCornerListModel.ExchangeCornerGUID = new Guid(ViewState["ExchangeCornerGUID"].ToString()); zlzw.BLL.ExchangeCornerListBLL exchangeCornerListBLL = new zlzw.BLL.ExchangeCornerListBLL(); exchangeCornerListModel.ExchangeCornerID = int.Parse(Get_ID(exchangeCornerListBLL, Request.QueryString["value"])); exchangeCornerListBLL.Update(exchangeCornerListModel); } else { //添加保存 zlzw.Model.ExchangeCornerListModel exchangeCornerListModel = new zlzw.Model.ExchangeCornerListModel(); exchangeCornerListModel.ExchangeCornerTitle = txbExchangeCornerTitle.Text; exchangeCornerListModel.ExchangeCornerTypeKey = drpExchangeCornerTypeKey.SelectedValue; exchangeCornerListModel.IsEnable = 1; exchangeCornerListModel.ExchangeCornerContent = txbContent.Text; exchangeCornerListModel.PublishDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")); if (fileExchangeCornerFilePath.PostedFile.ContentLength > 0) { string fileName = DateTime.Now.Ticks.ToString() + "_" + fileExchangeCornerFilePath.FileName; fileExchangeCornerFilePath.SaveAs(Server.MapPath("~/ExchangeCornerFile/" + fileName)); exchangeCornerListModel.ExchangeCornerFilePath = "~/ExchangeCornerFile/" + fileName;//保存图片路径 exchangeCornerListModel.ExchangeCornerFileSize = fileExchangeCornerFilePath.PostedFile.ContentLength.ToString();//文件尺寸 } zlzw.BLL.ExchangeCornerListBLL exchangeCornerListBLL = new zlzw.BLL.ExchangeCornerListBLL(); exchangeCornerListBLL.Add(exchangeCornerListModel); } // 2. Close this window and Refresh parent window PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference()); }