private void InitPage()
{
int id = CommonMethod.ConvertToInt(Request["id"], 0);
XiHuan_NewsEntity news = new XiHuan_NewsEntity();
news.Id = id;
news.Retrieve();
if (news.IsPersistent)
{
lblType.Text = Enum.GetName(typeof(XiHuan_NewsFacade.NewsType), news.Type);
lblTitle.Text = lblTitle2.Text = news.Title;
lblTime.Text = news.CreateDate.ToString("yyyy-MM-dd HH:mm:ss");
lblContent.Text = news.Content;
Header.Title = news.Title + "-" + SystemConfigFacade.Instance().WebSiteTitle;
hidId.Value = id.ToString();
}
string sql = string.Format(@"select top 1 Title,NewsUrl from XiHuan_News with(nolock) where Id<{0} order by Id desc;
select top 1 Title,NewsUrl from XiHuan_News with(nolock) where Id>{0} ;
select Top 10 Title,NewsUrl from XiHuan_News with(nolock) order by ViewCount desc; ", id);
DataSet ds = Query.ProcessMultiSql(sql, GlobalVar.DataBase_Name);
DataTable dtpre = ds.Tables[0];
string url = string.Empty;
if (dtpre != null && dtpre.Rows.Count > 0)
{
url = CommonMethod.FinalString(dtpre.Rows[0][1]);
bool res = (url.ToLower().IndexOf("http") > -1);
lblPre.Text = string.Format("<a title=\"{0}\" href=\"{1}\" target=\"{2}\">{0}</a>", dtpre.Rows[0][0], res ? url : SrcRootPath + url, res ? "_blank" : "_self");
}
else
{
lblPre.Text = "没有了";
}
DataTable dtnext = ds.Tables[1];
if (dtnext != null && dtnext.Rows.Count > 0)
{
url = CommonMethod.FinalString(dtnext.Rows[0][1]);
bool res = (url.ToLower().IndexOf("http") > -1);
lblNext.Text = string.Format("<a title=\"{0}\" href=\"{1}\">{0}</a>", dtnext.Rows[0][0], res ? url : SrcRootPath + url, res ? "_blank" : "_self");
}
else
{
lblNext.Text = "没有了";
}
rptHotNews.DataSource = ds.Tables[2];
rptHotNews.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
base.Page_Load();
if (!IsPostBack)
{
CommonMethod.ListContolDataBindFromEnum(ddlNewsType, typeof(XiHuan_NewsFacade.NewsType), "公告", "0", true);
if (IsEdit)
{
XiHuan_NewsEntity news = XiHuan_NewsEntityAction.RetrieveAXiHuan_NewsEntity(CommonMethod.ConvertToInt(Request["id"], 0));
txtLinkName.Text = news.Title;
CommonMethod.SelectFlg(ddlNewsType, news.Type.ToString());
txtLinkUrl.Text = news.NewsUrl;
NewContent.Value = news.Content;
txtSort.Text = news.SortNumber.ToString();
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Transaction t = new Transaction();
XiHuan_NewsEntity news = null;
if (IsEdit)
{
news = XiHuan_NewsEntityAction.RetrieveAXiHuan_NewsEntity(CommonMethod.ConvertToInt(Request["id"], 0));
}
else
{
news = new XiHuan_NewsEntity();
}
news.Title = txtLinkName.Text.Trim();
news.Content = rbtContent.Checked ? NewContent.Value.Trim() : txtLinkUrl.Text.Trim();
news.Type = byte.Parse(ddlNewsType.SelectedValue.Trim());
if (!IsEdit)
{
news.CreateDate = DateTime.Now;
}
news.SortNumber = CommonMethod.ConvertToInt(txtSort.Text.Trim(), 0);
if (rbtLink.Checked)
{
news.NewsUrl = txtLinkUrl.Text.Trim();
}
t.DoSaveObject(news);
string newsurl = string.Empty;
if (!rbtLink.Checked)
{
newsurl = "news/" + news.CreateDate.Year.ToString() + "/" + news.CreateDate.Month.ToString() + "/" + news.CreateDate.Day.ToString() + "/newsshow" + news.Id.ToString() + ".html";
t.DoSqlNonQueryString(string.Format("update XiHuan_News set NewsUrl='{0}' where Id=" + news.Id, newsurl), GlobalVar.DataBase_Name);
CommonMethod.readAspxAndWriteHtmlSoruce("../shownews.aspx?id=" + news.Id, "../" + newsurl);
}
try
{
t.Commit();
Alert("恭喜： 保存成功！");
ExecScript("parent.__doPostBack('lnkRefresh','');");
}
catch
{
t.RollBack();
Alert("抱歉：保存出现错误！");
}
}
protected void lnkDelNews_Click(object sender, EventArgs e)
{
XiHuan_NewsEntity link = new XiHuan_NewsEntity();
link.Id = CommonMethod.ConvertToInt(hidNewsId.Value, 0);
link.Retrieve();
if (link.IsPersistent)
{
try
{
if (System.IO.File.Exists(Server.MapPath(link.NewsUrl)))
{
System.IO.File.Delete(Server.MapPath(link.NewsUrl));
}
}
catch
{
}
link.Delete();
Alert("删除成功！");
BindNews();
}
}
