protected void btnAdd_Click(object sender, ImageClickEventArgs e) { string fileName = fileName = CommonFunction.Get_DynamicString() + FileUploadImg.FileName; string vfileName = "v_" + fileName; string vvfileName = "vv_" + fileName; string file_Path = Server.MapPath("~/CertificateImg/" + fileName); string vfile_Path = Server.MapPath("~/CertificateImg/" + vfileName); string vvfile_Path = Server.MapPath("~/CertificateImg/" + vvfileName); if (!CommonFunction.Is_FileUploadSuccessfully(FileUploadImg, Literal1, file_Path, new string[] { ".gif", ".jpg", ".jpeg" })) { return; } ImgUploadFunction.MakeThumbnail(file_Path, vfile_Path, 120, 90, "W"); ImgUploadFunction.MakeThumbnail(file_Path, vvfile_Path, 600, 450, "W"); System.IO.File.Delete(file_Path); ServiceNews news = new ServiceNews(); news.N_Title = "[" + vfileName + "]{" + vvfileName + "}"; news.N_Content = txtRemark.Text; news.N_SID = ((UserInfo)Session["ServiceUser"]).U_SID; news.N_Time = DateTime.Now; news.N_NewsType = "9"; news.N_From = "本站原创"; ServiceNewService.Insert_News(news); CommonFunction.AlertAndRedirect(Literal1, "操作成功", "CertificateMgr.aspx"); }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { string strContent = Request.Form["t_contents"].ToString(); if (strContent == "") { CommonFunction.Alert(Literal1, "文章内容不能为空"); return; } ServiceNews news = new ServiceNews(); news.N_Title = txtTitle.Text; news.N_Content = strContent; news.N_SID = ((UserInfo)Session["ServiceUser"]).U_SID; news.N_NewsType = ViewState["tid"].ToString(); news.N_From = txtForm.Text; news.N_Time = DateTime.Parse(txtdate.Text); if (ViewState["strAction"].ToString() == "add") { ServiceNewService.Insert_News(news); } else if (ViewState["strAction"].ToString() == "update") { news.N_ID = Convert.ToInt32(ViewState["nid"]); ServiceNewService.Update_News(news); } CommonFunction.AlertAndRedirect(Literal1, "操作成功", "blank.aspx"); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { DataSet newsDataset = new DataSet(); DataSet notifyDataset = new DataSet(); ServiceNews serviceNews = new ServiceNews(); newsDataset = serviceNews.GetSingleOutlineNewsListWithPageNumber(2, 5, 1); notifyDataset = serviceNews.GetSingleOutlineNewsListWithPageNumber(3, 5, 1); if (null == newsDataset || 0 == newsDataset.Tables.Count) { this.news_list.InnerText = "目前尚未有新闻"; } else { this.news_list.InnerHtml = getDetailList(newsDataset.Tables[0]); } if (null == notifyDataset || 0 == notifyDataset.Tables.Count) { this.news_list.InnerText = "目前尚未有通知"; } else { this.notify_list.InnerHtml = getDetailList(notifyDataset.Tables[0]); } } }
/// <summary> /// 添加站内新闻 /// </summary> /// <param name="news"></param> /// <returns></returns> public static int Insert_News(ServiceNews news) { string ins = "insert into T_ServiceNews(N_Title,N_Content,N_Time,N_Frorm,N_SID,N_NewsType) values(@title,@content,@ntime,@frorm,@sid,@newstype)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@title", news.N_Title), new SqlParameter("@content", news.N_Content), new SqlParameter("@ntime", news.N_Time), new SqlParameter("@frorm", news.N_From), new SqlParameter("@sid", news.N_SID.ToString()), new SqlParameter("@newstype", news.N_NewsType) }; return(Smart.DBUtility.SqlServerHelper.ExecuteSql(ins, param)); }
protected void btnSaveImage_Click(object sender, ImageClickEventArgs e) { if (ViewState["strAction"].ToString() == "add" || FileUploadImg.HasFile) { string fileName = CommonFunction.Get_DynamicString() + FileUploadImg.FileName; string vfileName = "v_" + fileName; string vvfileName = "vv_" + fileName; string filePath = Server.MapPath("~/newsImages/" + fileName); string vfilePath = Server.MapPath("~/newsImages/" + vfileName); string vvfilePath = Server.MapPath("~/newsImages/" + vvfileName); if (!CommonFunction.Is_FileUploadSuccessfully(FileUploadImg, Literal1, filePath, new string[] { ".gif", ".jpg", ".jpeg" })) { return; } ImgUploadFunction.MakeThumbnail(filePath, vfilePath, 150, 112, "W"); ImgUploadFunction.MakeThumbnail(filePath, vvfilePath, 600, 480, "W"); System.IO.File.Delete(filePath); ViewState["VImgURL"] = vfileName; ViewState["VVImgURL"] = vvfileName; } string strContent = Request.Form["t_contents"].ToString(); string strTitle = "(" + txtTitle.Text + ")[" + ViewState["VImgURL"].ToString() + "]{" + ViewState["VVImgURL"].ToString() + "}"; ServiceNews news = new ServiceNews(); news.N_Title = strTitle; news.N_Content = strContent; news.N_From = "本站原创"; news.N_SID = ((UserInfo)Session["ServiceUser"]).U_SID; news.N_NewsType = "6"; news.N_Time = DateTime.Parse(txtdate.Text.Trim()); if (ViewState["strAction"].ToString() == "update") { news.N_ID = Convert.ToInt32(ViewState["nid"]); ServiceNewService.Update_News(news); } else if (ViewState["strAction"].ToString() == "add") { ServiceNewService.Insert_News(news); } CommonFunction.AlertAndRedirect(Literal1, "操作成功", "blank.aspx"); }
protected void btnAdd_Click(object sender, ImageClickEventArgs e) { ServiceNews news = new ServiceNews(); news.N_Title = ""; news.N_Content = txtNotice.Text; news.N_SID = ((UserInfo)Session["ServiceUser"]).U_SID; news.N_NewsType = "2"; news.N_From = "本站原创"; news.N_Time = DateTime.Parse(txtdate.Text); if (ViewState["strAction"].ToString() == "add") { ServiceNewService.Insert_News(news); } else if (ViewState["strAction"].ToString() == "update") { news.N_ID = Convert.ToInt32(ViewState["nid"]); ServiceNewService.Update_News(news); } CommonFunction.AlertAndRedirect(Literal1, "操作成功", "blank.aspx"); }
/// <summary> /// 获取指定服务区信息 /// </summary> /// <param name="sid"></param> /// <returns></returns> public static List <ServiceNews> GetInfoList(int sid) { List <ServiceNews> listInfo = new List <ServiceNews>(); DataTable dataTableInfo = Get_NewsById(sid); foreach (DataRow dr in dataTableInfo.Rows) { ServiceNews serviceNews = new ServiceNews(); serviceNews.N_ID = (int)dr["N_ID"]; serviceNews.N_Title = (string)dr["N_Title"]; serviceNews.N_Time = (DateTime)dr["N_Time"]; serviceNews.N_From = (string)dr["N_Frorm"]; serviceNews.N_SID = (int)dr["N_SID"]; serviceNews.N_Content = (string)dr["N_Content"]; serviceNews.N_NewsType = (string)dr["N_TypeName"];//出错 serviceNews.N_ViewedCount = (int)dr["N_ViewedCount"]; listInfo.Add(serviceNews); } return(listInfo); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { string categoryType = Request.QueryString["type"]; //获取页面传递的type值 int categoryId = Convert.ToInt32(categoryType); //转换成int型 if (null == categoryType || categoryType.Equals(string.Empty)) //传值为空 { this.showFalseMessage("请输入正确的请求代号!"); return; } string pageRequestString = Request.QueryString["page_request"]; //获取页面传值的page_request值 int pageRequest = Convert.ToInt32(pageRequestString); if (null == pageRequestString || pageRequestString.Equals(string.Empty)) { this.showFalseMessage("请输入正确的页码!"); return; //告诉计算机执行完毕,可以没有return } ServiceNews serviceNews = new ServiceNews(); //调用webservice int pageCount = serviceNews.GetNewsPageCountCategory(categoryId, 20); //用存储过程获得子类page数 if (0 == pageCount) { this.showOverflowMessage("该栏目目前还没有资源!"); this.initPageNumber(pageCount, pageRequest, categoryId); return; } this.initPageNumber(pageCount, pageRequest, categoryId); DataSet dataset = serviceNews.GetSingleCategoryNewsListWithPageNumber(categoryId, 20, pageRequest); //用存储过程获得新闻列表 if (null == dataset || 0 == dataset.Tables.Count || 0 == dataset.Tables[0].Rows.Count) { this.showOverflowMessage("页码超出范围!"); return; } this.initNewsList(dataset.Tables[0]); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { string outlineType = Request.QueryString["type"]; int outlineId = Convert.ToInt32(outlineType); if (null == outlineType || outlineType.Equals(string.Empty)) { this.showFalseMessage("请输入正确的请求代号!"); return; } string pageRequestString = Request.QueryString["page_request"]; int pageRequest = Convert.ToInt32(pageRequestString); if (null == pageRequestString || pageRequestString.Equals(string.Empty)) { this.showFalseMessage("请输入正确的页码!"); return; } ServiceNews serviceNews = new ServiceNews(); int pageCount = serviceNews.GetNewsPageCountOutline(outlineId, 20); if (0 == pageCount) { this.showOverflowMessage("该栏目目前还没有资源!"); this.initPageNumber(pageCount, pageRequest, outlineId); return; } this.initPageNumber(pageCount, pageRequest, outlineId); DataSet dataset = serviceNews.GetSingleOutlineNewsListWithPageNumber(outlineId, 20, pageRequest); if (null == dataset || 0 == dataset.Tables.Count || 0 == dataset.Tables[0].Rows.Count) { this.showOverflowMessage("页码超出范围!"); return; } this.initNewsList(dataset.Tables[0]); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { string NewsID = Request.QueryString["id"]; //获得页面传值的id值 int newsID = Convert.ToInt32(NewsID); //将其转换成int型 if (null == NewsID || NewsID.Equals(string.Empty)) { this.showFalseMessage("请输入正确的请求代号!"); return; } ServiceNews serviceNews = new ServiceNews();//调用webservice DataSet dataSet = serviceNews.GetNewsDetail(newsID); if (null == dataSet || 0 == dataSet.Tables.Count || 0 == dataSet.Tables[0].Rows.Count) { this.showFalseMessage("目前尚未有新闻!"); return; } init_displaynewsTitle(dataSet.Tables[0]); init_displaynewsArticle(dataSet.Tables[0]); } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { string categoryType = Request.QueryString["id"]; int categoryId = Convert.ToInt32(categoryType); if (null == categoryType || categoryType.Equals(string.Empty)) { this.showFalseMessage("请输入正确的请求代号!"); return; } ServiceNews serviceNews = new ServiceNews(); DataSet informationDataset = serviceNews.GetInformation(categoryId); if (null == informationDataset || 1 > informationDataset.Tables.Count || 1 > informationDataset.Tables[0].Rows.Count) { this.showFalseMessage("此类别内容待添加!"); return; } this.TitleLabel.Text = informationDataset.Tables[0].Rows[0]["name"].ToString(); this.ContentLabel.Text = informationDataset.Tables[0].Rows[0]["article"].ToString(); } }
/// <summary> /// 编辑站内新闻 /// </summary> /// <param name="news"></param> /// <returns></returns> public static int Update_News(ServiceNews news) { string sqlStr = "update T_ServiceNews set N_Title='" + news.N_Title + "',N_Content='" + news.N_Content + "',N_Time='" + news.N_Time + "',N_Frorm='" + news.N_From + "' where N_ID=" + news.N_ID; return(DBHelper.ExecuteCommand(sqlStr)); }