/// <summary>
/// 修改新闻类型
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public int UpdateNewstype(News_type type)
{
string sql = "update NewsType set news_type_name='" + type.TypeName + "' where news_type_id='" + type.TypeID + "'";
int result = DBHelp.DoSql(sql);
return(result);
}
/// <summary>
/// 添加新闻类型
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public int addNewstype(News_type type)
{
string sql = "insert into NewsType (news_type_name,news_type_createTime,news_type_ParentID) values('" + type.TypeName + "','" + type.Type_createTime + "','" + type.Type_ParentID + "')";
int result = DBHelp.DoSql(sql);
return(result);
}
/// <summary>
/// 更新一条数据
/// </summary>
public virtual void Update(News_type model)
{
using (var session = sessionFactory.OpenSession())
{
session.SaveOrUpdate(model);
session.Flush();
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public virtual object Save(News_type model)
{
using (ISession session = sessionFactory.OpenSession())
{
var id = session.Save(model);
session.Flush();
return(id);
}
}
/// <summary>
/// 修改新闻类型
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public bool UpdateNewstype(News_type type)
{
if (newsType.UpdateNewstype(type) == 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加新闻类型
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public bool addNewstype(News_type type)
{
if (newsType.addNewstype(type) == 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除数据
/// </summary>
public override void Delete(News_type model)
{
string key = "News_type:" + model.id;
if (rh.Exist(key) > 0) //存在
{
rh.Remove(key);
//检查是否存在关联
rh.DelJoin("News_type");
}
base.Delete(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public override void Update(News_type model)
{
string key = "News_type:" + model.id;
if (rh.Exist(key) > 0) //存在
{
//修改当前集合
rh.Set <News_type>(key, model);
//检查是否存在关联
rh.DelJoin("News_type");
}
base.Update(model);
}
/// <summary>
/// 根据ID查出新闻类型(并以对象返回)
/// </summary>
/// <returns></returns>
public News_type selectedNewstype(int id)
{
News_type type = new News_type();
DataTable dt = newsType.selectedNewstype(id);
foreach (DataRow d in dt.Rows)
{
type.TypeID = Convert.ToInt16(d["news_type_id"].ToString().Trim());
type.TypeName = d["news_type_name"].ToString().Trim();
type.Type_createTime = Convert.ToDateTime(d["news_type_createTime"].ToString().Trim());
type.Type_ParentID = Convert.ToInt16(d["news_type_ParentID"].ToString().Trim());
type.Type_sequence = Convert.ToInt16(d["news_type_sequence"].ToString().Trim());
type.Type_count = Convert.ToInt16(d["news_type_count"].ToString().Trim());
}
return(type);
}
/// <summary>
/// 增加一条数据
/// </summary>
public override object Save(News_type model)
{
var res = base.Save(model);
if ((int)res > 0)
{
string key = "News_type:" + res;
if (rh.Exist(key) <= 0) //不存在
{
rh.Set <News_type>(key, model);
//检查是否存在关联
rh.DelJoin("News_type");
}
}
return(res);
}
