public static int InsertNews(string title, string summary, string content, DateTime createdate, string createuser)
{
NEWSINFO ni = new NEWSINFO();
ni.TITLE = title;
ni.SUMMARY = summary;
ni.NEWS_CONTENT = content;
ni.CREATEDATE = createdate;
ni.CREATEUSER = createuser;
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
db.Log = Console.Out;
db.NEWSINFO.InsertOnSubmit(ni);
db.SubmitChanges();
}
return ni.id;
}
/// <summary>
/// 根据新闻ID返回新闻详细信息
/// </summary>
/// <param name="nid"></param>
/// <returns></returns>
public static List<NewsInfo> GetNewsInfo(int nid)
{
DataClasses1DataContext db = new DataClasses1DataContext();
var result = from a in db.NEWSINFO
where a.id == nid
select new NewsInfo
{
NID = a.id,
Title = a.TITLE,
News_Content = a.NEWS_CONTENT,
Summary = a.SUMMARY,
CreateDate = a.CREATEDATE,
User = a.CREATEUSER
};
return result.ToList();
}
/// <summary>
/// 返回新闻列表
/// </summary>
/// <param name="_pageNo"></param>
/// <param name="_pageSize"></param>
/// <param name="pagCount"></param>
/// <returns></returns>
public static List<NewsInfo> GetNewsList(int _pageNo, int _pageSize,out int newscount)
{
List<NewsInfo> lstnews = new List<NewsInfo>();
DataClasses1DataContext db = new DataClasses1DataContext();
var query = from a in db.NEWSINFO
orderby a.CREATEDATE descending
select new NewsInfo
{
NID=a.id,
Title=a.TITLE,
News_Content =a.NEWS_CONTENT,
Summary=a.SUMMARY,
CreateDate=a.CREATEDATE,
User=a.CREATEUSER
};
newscount = query.Count();
lstnews = query.Skip(_pageSize * (_pageNo - 1)).Take<NewsInfo>(_pageSize).ToList<NewsInfo>();
return lstnews;
}
/// <summary>
/// 修改咨询，回答咨询
/// </summary>
/// <param name="qid"></param>
/// <param name="ansercontent"></param>
/// <param name="anserdate"></param>
/// <param name="anseruser"></param>
/// <returns></returns>
public static int UpdateQuestion(int qid, string ansercontent, DateTime anserdate, string anseruser)
{
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
db.Log = Console.Out;
var tb = db.QuestionInfo.SingleOrDefault<QuestionInfo>(s => s.ID == qid);
if (tb == null)
{
return 0;
}
tb.AnserContent = ansercontent;
tb.AnserDate = anserdate;
tb.AnserUser = anseruser;
tb.Status = 1;
db.SubmitChanges();
}
return 1;
}
/// <summary>
/// 新增咨询
/// </summary>
/// <param name="title"></param>
/// <param name="content"></param>
/// <param name="createdate"></param>
/// <param name="createuser"></param>
/// <returns></returns>
public static int InsertQuestion(string title, string content, DateTime createdate,int createuser)
{
QuestionInfo qi = new QuestionInfo();
qi.TITLE = title;
qi.QuestionContent = content;
qi.CreateUser = createuser;
qi.CreateDate = createdate;
qi.Status = 0;
using (DataClasses1DataContext db = new DataClasses1DataContext())
{
db.Log = Console.Out;
db.QuestionInfo.InsertOnSubmit(qi);
db.SubmitChanges();
}
return qi.ID;
}
/// <summary>
///
/// </summary>
/// <param name="_pageNo"></param>
/// <param name="_pageSize"></param>
/// <param name="status"></param>
/// <returns></returns>
public static List<QuestionsInfo> GetQuestionList(int _pageNo, int _pageSize,int status)
{
List<QuestionsInfo> lstnews = new List<QuestionsInfo>();
DataClasses1DataContext db = new DataClasses1DataContext();
var query = from a in db.QuestionInfo
where a.Status==status
select new QuestionsInfo
{
QID = a.ID,
Title = a.TITLE,
Content = a.QuestionContent,
CreateDate = a.CreateDate,
AnserContent = a.AnserContent,
AnserDate = a.AnserDate,
Status = a.Status
};
lstnews = query.Skip(_pageSize * (_pageNo - 1)).Take<QuestionsInfo>(_pageSize).ToList<QuestionsInfo>();
return lstnews;
}
/// <summary>
/// 当前人咨询列表
/// </summary>
/// <param name="_pageNo"></param>
/// <param name="_pageSize"></param>
/// <param name="userid"></param>
/// <param name="pagCount"></param>
/// <returns></returns>
public static List<QuestionsInfo> GetQuestionList(int _pageNo, int _pageSize, int userid, out int pagCount)
{
List<QuestionsInfo> lstnews = new List<QuestionsInfo>();
DataClasses1DataContext db = new DataClasses1DataContext();
var query = from a in db.QuestionInfo
where a.CreateUser == userid
orderby a.CreateDate descending
select new QuestionsInfo
{
QID=a.ID,
Title=a.TITLE,
Content=a.QuestionContent,
CreateDate=a.CreateDate,
AnserContent=a.AnserContent,
AnserDate=a.AnserDate,
Status=a.Status
};
pagCount = query.Count();
lstnews = query.Skip(_pageSize * (_pageNo - 1)).Take<QuestionsInfo>(_pageSize).ToList<QuestionsInfo>();
return lstnews;
}
/// <summary>
/// 咨询详细信息
/// </summary>
/// <param name="qid"></param>
/// <returns></returns>
public static List<QuestionsInfo> GetQuestionInfo(int qid)
{
DataClasses1DataContext db = new DataClasses1DataContext();
var query = from a in db.QuestionInfo
where a.ID == qid
select new QuestionsInfo
{
QID = a.ID,
Title = a.TITLE,
Content = a.QuestionContent,
CreateDate = a.CreateDate,
CreateUser =a.CreateUser,
AnserContent = a.AnserContent,
AnserDate = a.AnserDate,
AnserUser=a.AnserUser,
Status = a.Status
};
return query.ToList();
}