public List <News> SelNewsInfo(string RstId) { List <News> list = null; try { IParameterMapper ipmapper = new SelNewsInfoParameterMapper(); DataAccessor <News> tableAccessor; string strSql = @"select n.ID,n.Title,n.CompanyId,n.Contents,n.Datetime from news n where n.CompanyId=@RstId"; tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder <News> .MapAllProperties() .Map(t => t.CompanyId).ToColumn("CompanyId") .Map(t => t.Contents).ToColumn("Contents") .Map(t => t.DateTime).ToColumn("DateTime") .Map(t => t.ID).ToColumn("ID") .Map(t => t.Title).ToColumn("Title") .Build()); list = tableAccessor.Execute(new string[] { RstId }).ToList(); return(list); } catch (Exception ex) { Logger.Log(ex); return(null); } }
public List<News> SelNewsInfo(string RstId) { List<News> list = null; try { IParameterMapper ipmapper = new SelNewsInfoParameterMapper(); DataAccessor<News> tableAccessor; string strSql = @"select n.ID,n.Title,n.CompanyId,n.Contents,n.Datetime from news n where n.CompanyId=@RstId"; tableAccessor = db.CreateSqlStringAccessor(strSql, ipmapper, MapBuilder<News>.MapAllProperties() .Map(t => t.CompanyId).ToColumn("CompanyId") .Map(t => t.Contents).ToColumn("Contents") .Map(t => t.DateTime).ToColumn("DateTime") .Map(t => t.ID).ToColumn("ID") .Map(t => t.Title).ToColumn("Title") .Build()); list = tableAccessor.Execute(new string[] { RstId }).ToList(); return list; } catch (Exception ex) { Logger.Log(ex); return null; } }