//删除企业信息
public int deleteCpById(string id)
{
int cid = int.Parse(id);
int result = QueryDB.Context().Delete(Config.pretable + "search").Where("id", cid).Execute();
return(result);
}
//更新企业信息
public int updateInformaticaById(News news)
{
//string sql = "insert into "+Config.pretable+"search(dtname,cpname,penaltyid,pubishtime,officename,pagelayout,pagesize,articleurl,articletitle) values (@0,@1,@2,@3,@4,@5,@6,@7,@8)";
//Boolean result=QueryDB.Context().Sql(sql).Parameters(news.Dtname,news.Cpname,news.Penaltyid,news.Publishtime,news.Officename,news.Pagelayout,news.Pagesize,news.Articleurl,news.Articletitle).Execute();
int result = QueryDB.Context().Update <News>(Config.pretable + "search", news).AutoMap(x => x.id).Where(x => x.id).Execute();
return(result);
}
//根据id获取企业信息
public News getListById(string id)
{
int cid = int.Parse(id);
string sql = "SELECT dtname,cpname,penaltyid,publishtime,officename,pagelayout,pagesize,articleurl,articletitle FROM dbo." + Config.pretable + "search WHERE dbo." + Config.pretable + "search.id = @0 ";
News result = QueryDB.Context().Sql(sql).Parameters(cid).QuerySingle <News>();
return(result);
}
//根据企业名查询列表
public List <NewsVO> getListByCpname(string cpname)
{
string formatecpname = string.Format("%{0}%", cpname);
string sql = "SELECT id,ROW_NUMBER() over (order by id desc) as rowid,dtname,cpname,penaltyid,publishtime,officename,pagelayout,pagesize,articleurl,articletitle FROM dbo." + Config.pretable + "search WHERE " + Config.pretable + "search." + Config.colName("企业名称") + " LIKE @0";;
List <NewsVO> result = QueryDB.Context().Sql(sql).Parameters(formatecpname).QueryMany <NewsVO>();
return(result);
}
//获取所有企业列表
public List <NewsVO> getAllList()
{
//ROW_NUMBER() over (order by id asc) as rowid
string sql = "SELECT id,ROW_NUMBER() over (order by id desc) as rowid,dtname,cpname,penaltyid,publishtime,officename,pagelayout,pagesize,articleurl,articletitle FROM " + Config.pretable + "search order by id desc";
List <NewsVO> result = QueryDB.Context().Sql(sql).QueryMany <NewsVO>();
return(result);
}
//创建企业信息
public int addCpname(News news)
{
int result = QueryDB.Context().Insert <News>(Config.pretable + "search", news).AutoMap(x => x.id).ExecuteReturnLastId <int>();
return(result);
}
