生成 内容 1.access 2.net2.0的泛型操作的 3.。net3.5-4.0的linq to entity 生成 的net2.0 代码 model using system;using system.collections.generic;namespace chinesecode.bll{public class news{/// summary/// /// /summarypublic int newsid{set;get;
生成内容
1.access
2.net2.0的泛型操作的
3.。net3.5-4.0的linq to entity
生成的net2.0代码
model

using system;using system.collections.generic;namespace chinesecode.bll{ public class news { /// /// /// public int newsid { set; get; } /// /// /// public int userid { set; get; } /// /// /// public int typeid { set; get; } /// /// /// public string author { set; get; } /// /// /// public string title { set; get; } /// /// /// public string excerpts { set; get; } /// /// /// public string body { set; get; } /// /// /// public string image { set; get; } /// /// /// public int views { set; get; } /// /// /// public bool isapprived { set; get; } /// /// /// public bool checkresult { set; get; } /// /// /// public int displayorder { set; get; } /// /// /// public bool iscommend { set; get; } /// /// /// public string sourse { set; get; } /// /// /// public datetime createdate { set; get; } /// /// /// public string postip { set; get; } /// /// /// public datetime? updatedate { set; get; } /// ///获取单个模型 /// private users _users; public users users { get { if (_users == null) { _users = usersmanager.getmodel(this.userid); return _users; } return _users; } } /// ///获取单个模型 /// private newstype _newstype; public newstype newstype { get { if (_newstype == null) { _newstype = newstypemanager.getmodel(this.typeid); return _newstype; } return _newstype; } } }}
bll
using system;using system.collections.generic;using system.text;using jrdlibrary;using system.data;using system.data.sqlclient;namespace chinesecode.bll{ public class newsmanager { #region 获取实体方法 /// /// 获取一个实体类 /// public static news getmodel(sqldatareader reader) { return sqldatareaderext.readertomodel(reader); } /// /// 获取一个实体类集合 /// public static list getlist(sqldatareader reader) { return sqldatareaderext.readertolist(reader); }#endregion /// /// 创建一个有默认值的model /// public static news createmodel() { news model = new news(); model.views = 0; model.isapprived = true; model.checkresult = true; model.displayorder = 0; model.iscommend = false; model.createdate = datetime.now; return model; } /// /// 增加一条数据 /// public static int insert(news model) { stringbuilder strsql = new stringbuilder(); strsql.append(insert into jrd_news(); strsql.append(userid,typeid,author,title,excerpts,body,image,views,isapprived,checkresult,displayorder,iscommend,sourse,createdate,postip)); strsql.append( values (); strsql.append(@userid,@typeid,@author,@title,@excerpts,@body,@image,@views,@isapprived,@checkresult,@displayorder,@iscommend,@sourse,@createdate,@postip)); strsql.append(;select @@identity); sqlparameter[] parameters = { new sqlparameter(@userid, sqldbtype.int,4), new sqlparameter(@typeid, sqldbtype.int,4), new sqlparameter(@author,sqldbtype.nvarchar,100), new sqlparameter(@title,sqldbtype.nvarchar,400), new sqlparameter(@excerpts,sqldbtype.nvarchar,1000), new sqlparameter(@body,sqldbtype.ntext), new sqlparameter(@image,sqldbtype.varchar,100), new sqlparameter(@views, sqldbtype.int,4), new sqlparameter(@isapprived,sqldbtype.bit,1), new sqlparameter(@checkresult,sqldbtype.bit,1), new sqlparameter(@displayorder, sqldbtype.int,4), new sqlparameter(@iscommend,sqldbtype.bit,1), new sqlparameter(@sourse,sqldbtype.nvarchar,200), new sqlparameter(@createdate,sqldbtype.datetime), new sqlparameter(@postip,sqldbtype.varchar,20) }; parameters[0].value = model.userid; parameters[1].value = model.typeid; parameters[2].value = model.author; parameters[3].value = model.title; parameters[4].value = model.excerpts; parameters[5].value = model.body; parameters[6].value = model.image; parameters[7].value = model.views; parameters[8].value = model.isapprived; parameters[9].value = model.checkresult; parameters[10].value = model.displayorder; parameters[11].value = model.iscommend; parameters[12].value = model.sourse; parameters[13].value = model.createdate; parameters[14].value = model.postip; object obj = dbhelpersql.getsingle(strsql.tostring(), parameters); if (obj == null) { return 0; } else { return convert.toint32(obj); } } /// /// 更新一条数据 /// public static bool update(news model) { stringbuilder strsql = new stringbuilder(); strsql.append(update jrd_news set ); strsql.append(userid=@userid,typeid=@typeid,author=@author,title=@title,excerpts=@excerpts,body=@body,image=@image,views=@views,isapprived=@isapprived,checkresult=@checkresult,displayorder=@displayorder,iscommend=@iscommend,sourse=@sourse,postip=@postip,updatedate=@updatedate ); strsql.append( where newsid=@newsid); sqlparameter[] parameters = { new sqlparameter(@userid, sqldbtype.int,4), new sqlparameter(@typeid, sqldbtype.int,4), new sqlparameter(@author,sqldbtype.nvarchar,100), new sqlparameter(@title,sqldbtype.nvarchar,400), new sqlparameter(@excerpts,sqldbtype.nvarchar,1000), new sqlparameter(@body,sqldbtype.ntext), new sqlparameter(@image,sqldbtype.varchar,100), new sqlparameter(@views, sqldbtype.int,4), new sqlparameter(@isapprived,sqldbtype.bit,1), new sqlparameter(@checkresult,sqldbtype.bit,1), new sqlparameter(@displayorder, sqldbtype.int,4), new sqlparameter(@iscommend,sqldbtype.bit,1), new sqlparameter(@sourse,sqldbtype.nvarchar,200), new sqlparameter(@postip,sqldbtype.varchar,20), new sqlparameter(@updatedate,sqldbtype.datetime), new sqlparameter(@newsid, sqldbtype.int,4) }; parameters[0].value = model.userid; parameters[1].value = model.typeid; parameters[2].value = model.author; parameters[3].value = model.title; parameters[4].value = model.excerpts; parameters[5].value = model.body; parameters[6].value = model.image; parameters[7].value = model.views; parameters[8].value = model.isapprived; parameters[9].value = model.checkresult; parameters[10].value = model.displayorder; parameters[11].value = model.iscommend; parameters[12].value = model.sourse; parameters[13].value = model.postip; parameters[14].value = model.updatedate; parameters[15].value = model.newsid; int rows = dbhelpersql.executesql(strsql.tostring(), parameters); if (rows > 0) { return true; } else { return false; } } /// /// 删除一条数据 /// public static bool delete(int newsid) { stringbuilder strsql=new stringbuilder(); strsql.append(delete from jrd_news ); strsql.append( where newsid=@newsid); sqlparameter[] parameters = { new sqlparameter(@newsid, sqldbtype.int,4) }; parameters[0].value = newsid; int rows = dbhelpersql.executesql(strsql.tostring(), parameters); if (rows > 0) { return true; } else { return false; } } /// /// 是否存在该记录 /// public static bool exists(int newsid) { stringbuilder strsql=new stringbuilder(); strsql.append(select count(1) from jrd_news); strsql.append( where newsid=@newsid); sqlparameter[] parameters = { new sqlparameter(@newsid, sqldbtype.int,4) }; parameters[0].value = newsid; return dbhelpersql.exists(strsql.tostring(),parameters); } /// /// 得到一个对象实体 /// public static news getmodel(int newsid) { stringbuilder strsql=new stringbuilder(); strsql.append(select top 1 newsid,userid,typeid,author,title,excerpts,body,image,views,isapprived,checkresult,displayorder,iscommend,sourse,createdate,postip from jrd_news ); strsql.append( where newsid=@newsid); sqlparameter[] parameters = { new sqlparameter(@newsid, sqldbtype.int,4) }; parameters[0].value = newsid; return getmodel(dbhelpersql.executereader(strsql.tostring(),parameters)); } /// /// 获得全部数据 /// public static list getall() { stringbuilder strsql=new stringbuilder(); strsql.append(select newsid,userid,typeid,author,title,excerpts,body,image,views,isapprived,checkresult,displayorder,iscommend,sourse,createdate,postip ); strsql.append( from jrd_news ); return getlist(dbhelpersql.executereader(strsql.tostring(),null)); } /// ///根据userid获取列表 /// public static list getnewsbyuserid(string andstr,int userid, int pagesize,int pagecurrent,string fdorder, ref int totalcount) { sqlquery query = new sqlquery(); query.add(userid, userid, queryoperator.equal); return getpager(query.getwhere + andstr, pagesize, pagecurrent, fdorder, sorttype.desc, ref totalcount); } /// ///根据typeid获取列表 /// public static list getnewsbytypeid(string andstr,int typeid, int pagesize,int pagecurrent,string fdorder, ref int totalcount) { sqlquery query = new sqlquery(); query.add(typeid, typeid, queryoperator.equal); return getpager(query.getwhere + andstr, pagesize, pagecurrent, fdorder, sorttype.desc, ref totalcount); } /// /// 根据排序分页获取数据列表 /// public static list getpagerbydisplayorder(string strwhere, int pagesize, int pagecurrent,sorttype sort, ref int recordcount) { return getpager(strwhere, pagesize, pagecurrent, displayorder , sort, ref recordcount); } /// /// 根据浏览分页获取数据列表 /// public static list getpagerbyviews(string strwhere, int pagesize, int pagecurrent, sorttype sort, ref int recordcount) { return getpager(strwhere, pagesize, pagecurrent, views , sort, ref recordcount); } /// /// 分页获取数据列表 /// public static list getpager(string strwhere, int pagesize, int pagecurrent, string fdorder,sorttype sort, ref int recordcount) { string sqlstr=select cast(newsid as int) as newsid,userid,typeid,author,title,excerpts,body,image,views,isapprived,checkresult,displayorder,iscommend,sourse,createdate,postip,updatedate from jrd_news ; if (string.isnullorempty(fdorder) || fdorder == ) fdorder =newsid desc; else fdorder = fdorder + + sort.tostring(); return getlist(pagerbll.getpagerreader(sqlstr + strwhere, pagesize, pagecurrent, , fdorder, ref recordcount)); } }}