/// <summary>
/// 添加新闻
/// </summary>
/// <param name="title"></param>
/// <param name="cid"></param>
/// <param name="content"></param>
/// <returns></returns>
public static bool AddNews(string title, int cid, string author, string source, DateTime date, string content, bool ispic, bool isloop, string path)
{
try
{
string sql = "insert into News (Sid,Title,Source,Author,Content,PostTime,IsPicNews,IsLoopPicNews,PicNewsPath) values({0},{1},{2},{3},{4},{5},{6},{7},{8})";
using (var db = new SCenterEntities())
{
db.ExecuteStoreCommand(sql, new object[] {cid, title, source, author, content, date, ispic, isloop, path});
//db.SaveChanges();
//初始化Rank为它的唯一标识
List<News> list = db.News.Where(n => n.Rank == null).ToList();
if (list != null && list.Count >0)
{
foreach (var item in list)
{
item.Rank = item.Nid;
}
}
db.SaveChanges();
}
return true;
}
catch
{
return false;
throw;
}
}
/// <summary>
/// 添加人员
/// </summary>
/// <param name="name"></param>
/// <param name="cid"></param>
/// <param name="intro"></param>
/// <param name="path">头像</param>
/// <returns></returns>
public static bool AddBStaff(string name, int cid, string intro, string path)
{
try
{
string sql = "insert into Member (Sid,Name,Introduction,Photo) values({0},{1},{2},{3})";
using (var db = new SCenterEntities())
{
db.ExecuteStoreCommand(sql, new object[] { cid, name, intro, path });
//Rank初始化
List<Member> list = db.Members.Where(m => m.Rank == null).ToList();
if (list != null && list.Count >0)
{
foreach (var item in list)
{
item.Rank = item.Mid;
}
}
db.SaveChanges();
}
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 删除公告下载
/// </summary>
/// <param name="id">文章ID</param>
/// <returns>操作状态</returns>
public static bool DelBulletin(int id)
{
try
{
using (var db = new SCenterEntities())
{
db.ArticleWithAthmts.DeleteObject(db.ArticleWithAthmts.Single(a => a.Bid == id));
db.SaveChanges();
}
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 删除文章
/// </summary>
/// <param name="id">文章ID</param>
/// <returns>操作状态</returns>
public static bool DelUser(int id)
{
try
{
using (var db = new SCenterEntities())
{
db.Admins.DeleteObject(db.Admins.Single(a => a.Userid == id));
db.SaveChanges();
}
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 删除人员
/// </summary>
/// <param name="id">人员ID</param>
/// <returns>操作状态</returns>
public static bool DelStaff(int id)
{
try
{
using (var db = new SCenterEntities())
{
db.Members.DeleteObject(db.Members.Single(a => a.Mid == id));
db.SaveChanges();
}
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 删除新闻
/// </summary>
/// <param name="id">新闻ID</param>
/// <returns>操作状态</returns>
public static bool DelNews(int id)
{
try
{
using (var db = new SCenterEntities())
{
db.News.DeleteObject(db.News.Single(n => n.Nid == id));
db.SaveChanges();
}
return true;
}
catch
{
return false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
int id = Convert.ToInt32(RouteData.Values["id"]);
post = BulletinHelper.GetBulltin(id);
//bshare需要抓取的两个内容
Page.Header.Title = post.Title;
Page.Header.Description = post.Title;
//更新统计数据
using (var db = new SCenterEntities())
{
post.ClickCount += 1;
db.Attach(post);
db.ObjectStateManager.ChangeObjectState(post, System.Data.EntityState.Modified);
db.SaveChanges(System.Data.Objects.SaveOptions.AcceptAllChangesAfterSave);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//获取要查看的新闻ID
int id = Convert.ToInt32(RouteData.Values["id"]);
Msg = ArtiHelper.GetArticle(id);
//bshare需要抓取的两个内容
Page.Header.Title = Msg.Title;
Page.Header.Description = Msg.Title;
//更新统计数据
using (var db = new SCenterEntities())
{
Msg.ClickCount += 1;
db.Attach(Msg);
db.ObjectStateManager.ChangeObjectState(Msg, System.Data.EntityState.Modified);
db.SaveChanges(System.Data.Objects.SaveOptions.AcceptAllChangesAfterSave);
}
}
/// <summary>
/// 添加文章
/// </summary>
/// <param name="title"></param>
/// <param name="password"></param>
/// <returns></returns>
public static bool AddUser(string username, string password)
{
try
{
string sql = "insert into Admin (UserName,Password) values({0},{1})";
using (var db = new SCenterEntities())
{
db.ExecuteStoreCommand(sql, new object[] { username, FormsAuthentication.HashPasswordForStoringInConfigFile(password,"md5") });
db.SaveChanges();
}
return true;
}
catch
{
return false;
throw;
}
}
/// <summary>
/// 添加公告、下载
/// </summary>
/// <param name="title"></param>
/// <param name="cid"></param>
/// <param name="content"></param>
/// <returns></returns>
public static bool AddBulletin(string title, int cid, string content, string author, string source, DateTime date, string attachment, string filename)
{
DateTime Date = Convert.ToDateTime(date.ToString("yyyy-MM-dd") + " " + DateTime.Now.ToString("HH:mm:ss.fff"));
try
{
string sql = "insert into ArticleWithAthmt (Sid,Title,Content,Source,Author,PostTime,Attachment,AttachmentName) values({0},{1},{2},{3},{4},{5},{6},{7})";
using (var db = new SCenterEntities())
{
db.ExecuteStoreCommand(sql, new object[] { cid, title, content,source, author,Date, attachment, filename });
db.SaveChanges();
}
return true;
}
catch
{
return false;
throw;
}
}
/// <summary>
/// 修改新闻
/// </summary>
/// <param name="id"></param>
/// <param name="title"></param>
/// <param name="cid"></param>
/// <param name="content"></param>
/// <param name="ispic"></param>
/// <param name="isloop"></param>
/// <param name="path"></param>
/// <returns></returns>
public static bool UpdateNews(int id, string title, int cid, string author, string source, DateTime date, string content, bool ispic, bool isloop, string path)
{
try
{
using (var db = new SCenterEntities())
{
var news = db.News.Single(n => n.Nid == id);
news.Title = title;
news.Content = content;
news.Sid = cid;
news.Author = author;
news.Source = source;
news.PostTime = date;
news.IsPicNews = ispic;
news.IsLoopPicNews = isloop;
news.PicNewsPath = path;
db.SaveChanges();
}
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 修改文章
/// </summary>
/// <param name="id"></param>
/// <param name="title"></param>
/// <param name="cid"></param>
/// <param name="content"></param>
/// <param name="attachment"></param>
/// <returns></returns>
public static bool UpdateBulletin(int id, string title, int cid, string content, string author, string source, DateTime date, string attachment, string filename)
{
DateTime Date = Convert.ToDateTime(date.ToString("yyyy-MM-dd") + " " + DateTime.Now.ToString("HH:mm:ss.fff"));
try
{
using (var db = new SCenterEntities())
{
var bulletin = db.ArticleWithAthmts.Single(a => a.Bid == id);
bulletin.Title = title;
bulletin.Content = content;
bulletin.Sid = cid;
bulletin.Author = author;
bulletin.Source = source;
bulletin.PostTime = Date;
bulletin.Attachment = attachment;
bulletin.AttachmentName = filename;
db.SaveChanges();
}
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 修改人员
/// </summary>
/// <param name="id"></param>
/// <param name="name"></param>
/// <param name="cid"></param>
/// <param name="intro"></param>
/// <param name="path"></param>
/// <returns></returns>
public static bool UpdateStaff(int id, string name, int cid, string intro, string path)
{
try
{
using (var db = new SCenterEntities())
{
var staff = db.Members.Single(a => a.Mid == id);
staff.Name = name;
staff.Introduction = intro;
staff.Sid = cid;
staff.Photo = path;
db.SaveChanges();
}
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 修改文章
/// </summary>
/// <param name="id"></param>
/// <param name="username"></param>
/// <param name="password"></param>
/// <returns></returns>
public static bool UpdateUser(int id, string username, string password)
{
try
{
using (var db = new SCenterEntities())
{
var user = db.Admins.Single(a => a.Userid == id);
user.UserName = username;
user.Password = FormsAuthentication.HashPasswordForStoringInConfigFile(password, "md5");
db.SaveChanges();
}
return true;
}
catch
{
return false;
}
}
/// <summary>
/// rank down
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static bool DownStaff(int id)
{
try
{
using (var db = new SCenterEntities())
{
var m1 = db.Members.Single(a => a.Mid == id);
if (m1.Rank == null)
{
m1.Rank = m1.Mid;
}
var m2 = db.Members.SingleOrDefault(a => a.Rank == (m1.Rank + 1));
if (m2 != null)
{
m1.Rank += 1;
m2.Rank -= 1;
}
db.SaveChanges();
}
return true;
}
catch
{
return false;
}
}
/// <summary>
/// rank down
/// </summary>
/// <param name="id">新闻的ID</param>
/// <returns>修改是否成功</returns>
public static bool DownNews(int id)
{
try
{
using (var db = new SCenterEntities())
{
var m1 = db.News.Single(a => a.Nid == id);
if (m1.Rank == null) //防止没有Rank的条目
{
m1.Rank = m1.Nid;
}
//找出此类列表
List<News> clist = db.News.Where(n => n.Sid == m1.Sid).OrderByDescending(a => a.Rank).ToList();
if (clist != null && clist.Count > 0)
{
News m2 = null;
try
{
m2 = clist[clist.LastIndexOf(m1) + 1];
}
catch
{
}
if (m2 != null)
{
var tmp = m1.Rank;
m1.Rank = m2.Rank;
m2.Rank = tmp;
}
}
//var m2 = db.News.SingleOrDefault(a => a.Rank == (m1.Rank - 1));
//if (m2 != null)
//{
// m1.Rank -= 1;
// m2.Rank += 1;
//}
db.SaveChanges();
}
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 修改文章
/// </summary>
/// <param name="id"></param>
/// <param name="title"></param>
/// <param name="cid"></param>
/// <param name="content"></param>
/// <returns></returns>
public static bool UpdateArticle(int id, string title, int cid, string author, string source, DateTime date, string content)
{
DateTime Date = Convert.ToDateTime(date.ToString("yyyy-MM-dd") + " " + DateTime.Now.ToString("HH:mm:ss.fff"));
try
{
using (var db = new SCenterEntities())
{
var news = db.Articles.Single(a => a.Aid == id);
news.Title = title;
news.Content = content;
news.Sid = cid;
news.Author = author;
news.Source = source;
news.PostTime = Date;
db.SaveChanges();
}
return true;
}
catch
{
return false;
}
}