public NewsPapersController() : base()
{
var connectionString = ConfigurationManager.ConnectionStrings["MyDBConnection"].ToString();
paperService = new NewsPaperService(connectionString);
publishHouseService = new PaperPublishHouseService(connectionString);
var t = publishHouseService.ShowPublishHouse().ToList();
}
protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "delRecord")
{
int nid = Convert.ToInt32(e.CommandArgument);
NewsPaperService.Delete_NewsPaper(nid);
binddata();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int nid = Convert.ToInt32(Request.QueryString["nid"]);
NewsPaper paper = NewsPaperService.Get_NewsPaperModel(nid);
lblPosition.Text = paper.N_Title;
lblPosition.Font.Bold = true;
lblPosition.ForeColor = Color.Red;
CLinkButtonColor(btnPage1);
NewsImg.ImageUrl = "../newspaper/" + paper.N_AImg;
ViewState["paper"] = paper;
}
}
void binddata()
{
DataTable dt = NewsPaperService.Get_NewsPaperList(0);
AspNetPager1.RecordCount = dt.Rows.Count;
if (dt.Rows.Count >= 0)
{
PagedDataSource ps = new PagedDataSource();
DataView dv = new DataView(dt);
ps.DataSource = dv;
ps.AllowPaging = true;
ps.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
ps.PageSize = AspNetPager1.PageSize;
rptNewsPaper.DataSource = ps;
rptNewsPaper.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CommonFunction.isLoginCheck();
ViewState["strAction"] = Request.QueryString["action"];
ViewState["strAImg"] = "";
ViewState["strAImgView"] = "";
ViewState["strBImg"] = "";
ViewState["strBImgView"] = "";
ViewState["strCImg"] = "";
ViewState["strCImgView"] = "";
ViewState["strDImg"] = "";
ViewState["strDImgView"] = "";
if (Request.QueryString["nid"] != null)
{
int nid = Convert.ToInt32(Request.QueryString["nid"]);
ViewState["nid"] = nid;
NewsPaper paper = NewsPaperService.Get_NewsPaperModel(nid);
txtTitle.Text = paper.N_Title;
txtTime.Text = Convert.ToDateTime(paper.N_Time).ToShortDateString();
ImgA.ImageUrl = "../newspaper/" + paper.N_AImgView;
ImgB.ImageUrl = "../newspaper/" + paper.N_BImgView;
ImgC.ImageUrl = "../newspaper/" + paper.N_CImgView;
ImgD.ImageUrl = "../newspaper/" + paper.N_DImgView;
ViewState["strAImg"] = paper.N_AImg;
ViewState["strAImgView"] = paper.N_AImgView;
ViewState["strBImg"] = paper.N_BImg;
ViewState["strBImgView"] = paper.N_BImgView;
ViewState["strCImg"] = paper.N_CImg;
ViewState["strCImgView"] = paper.N_CImgView;
ViewState["strDImg"] = paper.N_DImg;
ViewState["strDImgView"] = paper.N_DImgView;
}
else
{
txtTime.Text = DateTime.Now.ToShortDateString();
}
}
}
/// <summary>
/// 未处理的报事
/// </summary>
/// <returns>返回操作结果</returns>
public virtual ActionResult GetStare()
{
return(this.JsonFormat(NewsPaperService.GetStare(1)));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//行业规章
DataTable dtHYGZ = NewsInfoService.Get_TopNewsInfoViewList(20, 6);
rptHYGZ.DataSource = dtHYGZ;
rptHYGZ.DataBind();
//经验交流
DataTable dtJYJL = NewsInfoService.Get_TopNewsInfoViewList(21, 6);
rptJYJL.DataSource = dtJYJL;
rptJYJL.DataBind();
//资料下载
DataTable dtDownload = FileDownloadService.Get_TopFileDownloadView(2, 6);
rptDownLoad.DataSource = dtDownload;
rptDownLoad.DataBind();
//ISO国际标准化认证
DataTable dtISO = NewsInfoService.Get_TopNewsInfoViewList(24, 6);
rptISO.DataSource = dtISO;
rptISO.DataBind();
//通知公告
DataTable dtTZGG = NewsInfoService.Get_TopNewsInfoViewList(25, 6);
rptTZGG.DataSource = dtTZGG;
rptTZGG.DataBind();
//驿站新闻
DataTable dtServiceNews = NewsInfoService.Get_TopNewsInfoViewList(26, 8);
rptServiceNews.DataSource = dtServiceNews;
rptServiceNews.DataBind();
//驿站文化
DataTable dtYZWH = NewsInfoService.Get_TopNewsInfoViewList(27, 6);
rptYZWH.DataSource = dtYZWH;
rptYZWH.DataBind();
//行业报刊
DataTable dtNewsPaper = NewsPaperService.Get_NewsPaperList(4);
rptNewsPaper.DataSource = dtNewsPaper;
rptNewsPaper.DataBind();
//所有服务区列表
DataTable dtServices = PubClass.DBHelper.GetDataSet("select top 36 * from T_ServiceInfo order by S_QuarterRank asc,S_Star desc");
rptServices.DataSource = dtServices;
rptServices.DataBind();
//特色服务区
DataTable dtTSFWQ = NewsInfoService.Get_TopNewsInfoViewList(130, 10);
rptTSFWQ.DataSource = dtTSFWQ;
rptTSFWQ.DataBind();
//开图走四方
DataTable dtKTZSF = NewsInfoService.Get_TopNewsInfoViewList(131, 10);
rptKTZSF.DataSource = dtKTZSF;
rptKTZSF.DataBind();
//精品旅游线路
DataTable dtJPLYXL = NewsInfoService.Get_TopNewsInfoViewList(132, 10);
rptJPLYXL.DataSource = dtJPLYXL;
rptJPLYXL.DataBind();
//吃住行游
DataTable dtCZXY = NewsInfoService.Get_TopNewsInfoViewList(133, 10);
rptCZXY.DataSource = dtCZXY;
rptCZXY.DataBind();
//古道遗风
DataTable dtGDYF = NewsInfoService.Get_TopNewsInfoViewList(134, 10);
rptGDYF.DataSource = dtGDYF;
rptGDYF.DataBind();
}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
if (FileUploadImgA.HasFile)
{
string fileName = CommonFunction.Get_DynamicString() + FileUploadImgA.FileName;
string vfileName = "v_" + fileName;
string file_Path = Server.MapPath("~/newspaper/" + fileName);
string vfile_Path = Server.MapPath("~/newspaper/" + vfileName);
if (!CommonFunction.Is_FileUploadSuccessfully(FileUploadImgA, Literal1, file_Path, new string[] { ".gif", ".jpg", ".jpeg" }))
{
return;
}
ImgUploadFunction.MakeThumbnail(file_Path, vfile_Path, 152, 225, "HW");
ViewState["strAImg"] = fileName;
ViewState["strAImgView"] = vfileName;
}
if (FileUploadImgB.HasFile)
{
string fileName = CommonFunction.Get_DynamicString() + FileUploadImgB.FileName;
string vfileName = "v_" + fileName;
string file_Path = Server.MapPath("~/newspaper/" + fileName);
string vfile_Path = Server.MapPath("~/newspaper/" + vfileName);
if (!CommonFunction.Is_FileUploadSuccessfully(FileUploadImgB, Literal1, file_Path, new string[] { ".gif", ".jpg", ".jpeg" }))
{
return;
}
ImgUploadFunction.MakeThumbnail(file_Path, vfile_Path, 152, 225, "HW");
ViewState["strBImg"] = fileName;
ViewState["strBImgView"] = vfileName;
}
if (FileUploadImgC.HasFile)
{
string fileName = CommonFunction.Get_DynamicString() + FileUploadImgC.FileName;
string vfileName = "v_" + fileName;
string file_Path = Server.MapPath("~/newspaper/" + fileName);
string vfile_Path = Server.MapPath("~/newspaper/" + vfileName);
if (!CommonFunction.Is_FileUploadSuccessfully(FileUploadImgC, Literal1, file_Path, new string[] { ".gif", ".jpg", ".jpeg" }))
{
return;
}
ImgUploadFunction.MakeThumbnail(file_Path, vfile_Path, 152, 225, "HW");
ViewState["strCImg"] = fileName;
ViewState["strCImgView"] = vfileName;
}
if (FileUploadImgD.HasFile)
{
string fileName = CommonFunction.Get_DynamicString() + FileUploadImgD.FileName;
string vfileName = "v_" + fileName;
string file_Path = Server.MapPath("~/newspaper/" + fileName);
string vfile_Path = Server.MapPath("~/newspaper/" + vfileName);
if (!CommonFunction.Is_FileUploadSuccessfully(FileUploadImgD, Literal1, file_Path, new string[] { ".gif", ".jpg", ".jpeg" }))
{
return;
}
ImgUploadFunction.MakeThumbnail(file_Path, vfile_Path, 152, 225, "HW");
ViewState["strDImg"] = fileName;
ViewState["strDImgView"] = vfileName;
}
NewsPaper paper = new NewsPaper();
paper.N_Title = txtTitle.Text;
paper.N_Time = txtTime.Text;
paper.N_AImg = ViewState["strAImg"].ToString();
paper.N_AImgView = ViewState["strAImgView"].ToString();
paper.N_BImg = ViewState["strBImg"].ToString();
paper.N_BImgView = ViewState["strBImgView"].ToString();
paper.N_CImg = ViewState["strCImg"].ToString();
paper.N_CImgView = ViewState["strCImgView"].ToString();
paper.N_DImg = ViewState["strDImg"].ToString();
paper.N_DImgView = ViewState["strDImgView"].ToString();
if (ViewState["strAction"].ToString() == "update")
{
paper.N_ID = Convert.ToInt32(ViewState["nid"]);
NewsPaperService.Update_NewsPaper(paper);
}
else if (ViewState["strAction"].ToString() == "add")
{
NewsPaperService.Insert_NewsPaper(paper);
}
CommonFunction.AlertAndRedirect(Literal1, "操作成功", "NewsPaperMgr.aspx");
}
