//热门数据
private void BindNews1()
{
DataTable dt = NewsService.SelectAll();
if (dt != null && dt.Rows.Count != 0)
{
TopNews.DataSource = dt;
TopNews.DataBind();
}
}
/// <summary>
/// 获取对象
/// </summary>
private void LoadModelInfo()
{
TopNews item = TopNewsService.GetModel(id);
if (item != null)
{
txtTitle.Text = item.remark;
txtZhaiYao.Text = item.baseInfo;
ViewState["newsImg1"] = item.imgURL;
}
}
static void Main(string[] _)
{
try
{
// Create a session into the platform
using ISession session = Configuration.Sessions.GetSession();
if (session.Open() == Session.State.Opened)
{
// Top News
var top = TopNews.Definition().GetData();
DisplayNews(top);
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
static void Main(string[] _)
{
try
{
// Create a session into the platform
using ISession session = Sessions.GetSession();
if (session.Open() == Session.State.Opened)
{
// Top News
var top = TopNews.Definition().GetData();
if (top.IsSuccess)
{
if (top.Data.Categories.Count > 0)
{
// Retrieve a headlines ID from one of the categories
var newsId = top.Data.Categories["Main"]?[0].TopNewsID;
Console.WriteLine($"Retrieving top news headlines based on the news ID: {newsId}");
var headlines = TopNewsHeadlines.Definition(newsId).GetData();
DisplayNews(headlines);
}
else
{
Console.WriteLine("No headlines found");
}
}
else
{
Console.WriteLine($"Unable to retrieve Top news: {top.HttpStatus}");
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
/// <summary>
/// 发布资讯
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnRelease_Click(object sender, EventArgs e)
{
if (Session["loginUser"] == null)
{
Jscript.AlertAndRedirect("请登录", "/admin/login.aspx");
return;
}
if (newsId != 0)
{
TopNews item = new TopNews();
item.newsId = newsId;
item.newsType = CRequest.GetInt("newsType", 0);
item.imgURL = "";
if (ViewState["newsImg1"] != null)
{
item.imgURL = ViewState["newsImg1"].ToString();
}
else
{
item.imgURL = "";
}
item.baseInfo = txtZhaiYao.Text.Trim();
item.orderNum = 0;
item.status = 0;
item.remark = txtTitle.Text.Trim();
item.addtime = DateTime.Now;
item.adduser = (Session["loginUser"] as AdminUser).id;
item.infoType = 0;
if (item.imgURL == "" || item.baseInfo == "")
{
this.lblError.Text = "请填写信息内容并上传图片";
return;
}
if (item.baseInfo.Length > 500)
{
this.lblError.Text = "信息内容不能超过500字";
return;
}
int num = TopNewsService.Add(item);
if (num > 0)
{
NewsService.UpdateTop(item.newsId, 1);
Response.Redirect("infoList.aspx");
}
else
{
lblError.Text = "设置置顶失败";
}
}
if (id != 0)
{
TopNews item = TopNewsService.GetModel(id);
if (item != null)
{
item.imgURL = "";
if (ViewState["newsImg1"] != null)
{
item.imgURL = ViewState["newsImg1"].ToString();
}
else
{
item.imgURL = "";
}
item.remark = txtTitle.Text.Trim();
item.baseInfo = txtZhaiYao.Text.Trim();
int num = TopNewsService.Update(item);
if (num > 0)
{
Response.Redirect("topInfoList.aspx");
}
else
{
lblError.Text = "修改失败";
}
}
}
}
public async Task <ActionResult> UpdateNews(UpdateNews newForUpdate)
{
var dbHelpre = DBHelper.Instance;
dbHelpre.BeginTransaction();
return(await Task.Run(() =>
{
try
{
bool IsNotValid = false;
ViewBag.Message = "Updating News.....";
if (ModelState.IsValid)
{
var news = new TopNews
{
TopNewsID = newForUpdate.NewsID,
Heading = newForUpdate.Heading.Trim(),
ShortDescription = newForUpdate.ShortDesc.Trim(),
NewsDescription = string.IsNullOrEmpty(newForUpdate.Description) ? string.Empty : newForUpdate.Description.Trim(),
IsActive = newForUpdate.IsActiveNews ? 1 : 0,
IsApproved = newForUpdate.IsApprovedNews ? 1 : 0
};
var image = new ImageDetail
{
ImageType = 1,
ImageUrl = newForUpdate.ImageUrl,
Caption = newForUpdate.Caption,
IsActive = 1,
IsFirst = 1
};
var fileName = string.Empty;
if (newForUpdate.Image != null && newForUpdate.Image.ContentLength > 0)
{
fileName = new Random().Next(1000000000).ToString() + Path.GetFileName(newForUpdate.Image.FileName);
image.ImageUrl = ImagePath.TopTenNewsImage + "/" + fileName;
image.IsActive = 1;
image.IsFirst = 1;
}
var user = (IUsers)this.Session[Constants.UserSessionKey];
TopNewsBL.Instance.UpdateNews(ref dbHelpre, news, image, user);
if (!string.IsNullOrEmpty(fileName))
{
if (SaveImage(ImagePath.TopTenNewsImage, fileName, newForUpdate.Image))
{
if (DeleteImage(ImagePath.TopTenNewsImage, newForUpdate.ImageUrl))
{
ViewBag.Message = "Updated successfully.";
ModelState.Clear();
}
else
{
IsNotValid = true;
}
}
else
{
IsNotValid = true;
}
}
newForUpdate.ImageUrl = image.ImageUrl;
}
else
{
IsNotValid = true;
}
if (IsNotValid)
{
dbHelpre.RollbackTransaction();
ModelState.AddModelError("INSERT", "Oops ! There is some error.");
ViewBag.Message = "Oops ! There is some error.";
}
else
{
ViewBag.Message = "Updated successfully.";
}
dbHelpre.CommitTransaction();
}
catch (Exception ex)
{
dbHelpre.RollbackTransaction();
throw ex;
}
finally
{
dbHelpre.ClearAllParameters();
dbHelpre.CloseConnection();
dbHelpre.Dispose();
}
return View(newForUpdate);
}));
}
public async Task <ActionResult> InsertNews(CreateNews newForInsert)
{
return(await Task.Run(() =>
{
var dbHelpre = DBHelper.Instance;
var BLInstance = TopNewsBL.Instance;
dbHelpre.BeginTransaction();
try
{
if (ModelState.IsValid)
{
var news = new TopNews
{
Heading = newForInsert.Heading.Trim(),
ShortDescription = newForInsert.ShortDesc.Trim(),
NewsDescription = string.IsNullOrEmpty(newForInsert.Description) ? string.Empty : newForInsert.Description.Trim(),
IsActive = 0,
IsApproved = 0
};
var image = new ImageDetail
{
ImageType = (int)ImageType.TopNewsImage,
ImageUrl = " ",
Caption = newForInsert.ImageCaption,
CaptionLink = newForInsert.CaptionLink,
IsActive = 0,
IsFirst = 0
};
var fileName = string.Empty;
if (newForInsert.Image != null && newForInsert.Image.ContentLength > 0)
{
fileName = new Random().Next(1000000000).ToString() + Path.GetFileName(newForInsert.Image.FileName);
image.ImageUrl = ImagePath.TopTenNewsImage + "/" + fileName;
image.IsActive = 1;
image.IsFirst = 1;
}
string dirPath = ImagePath.TopTenNewsImage;
var user = (IUsers)this.Session[Constants.UserSessionKey];
BLInstance.Insert(ref dbHelpre, news, image, user);
if (SaveImage(ImagePath.TopTenNewsImage, fileName, newForInsert.Image))
{
newForInsert = new CreateNews();
ViewBag.Message = "Successfully Inserter.";
ModelState.Clear();
}
}
else
{
ModelState.AddModelError("INSERT", "Oops ! There is some error.");
ViewBag.Message = "Oops ! There is some error.";
}
dbHelpre.CommitTransaction();
return View(newForInsert);
}
catch (Exception ex)
{
dbHelpre.RollbackTransaction();
throw ex;
}
finally
{
dbHelpre.Dispose();
BLInstance.Dispose();
}
}));
}
