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));
}
