/// <summary> ///[NoticeInfo]表查询实体的方法 /// </summary> public static NoticeInfo getNoticeInfoById(int noticeid) { NoticeInfo noticeinfo = null; string sql = "select * from NoticeInfo where noticeid=@noticeid"; SqlParameter[] sp = new SqlParameter[] { new SqlParameter("@noticeid", noticeid) }; DataTable dt = DBHelper.GetDataSet(sql, sp); if (dt.Rows.Count > 0) { noticeinfo = new NoticeInfo(); foreach (DataRow dr in dt.Rows) { noticeinfo.Noticeid = Convert.ToInt32(dr["noticeid"]); noticeinfo.Title = Convert.ToString(dr["title"]); noticeinfo.Sortid = SortInfoService.getSortInfoById((int)dr["sortid"]); noticeinfo.Ifpublic = Convert.ToInt32(dr["ifpublic"]); noticeinfo.Fromuser = Convert.ToString(dr["fromuser"]); noticeinfo.Begintime = Convert.ToDateTime(dr["begintime"]); noticeinfo.Endtime = Convert.ToDateTime(dr["endtime"]); noticeinfo.Attribute = Convert.ToInt32(dr["attribute"]); noticeinfo.Accressory = Convert.ToString(dr["accressory"]); noticeinfo.Context = Convert.ToString(dr["context"]); } } return(noticeinfo); }
/// <summary> ///根据SQL语句获取集合 /// </summary> public static IList <NoticeInfo> getNoticeInfosBySql(string sql) { IList <NoticeInfo> list = new List <NoticeInfo>(); DataTable dt = DBHelper.GetDataSet(sql); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { NoticeInfo noticeinfo = new NoticeInfo(); noticeinfo.Noticeid = Convert.ToInt32(dr["noticeid"]); noticeinfo.Title = Convert.ToString(dr["title"]); noticeinfo.Sortid = SortInfoService.getSortInfoById((int)dr["sortid"]); noticeinfo.Ifpublic = Convert.ToInt32(dr["ifpublic"]); noticeinfo.Fromuser = Convert.ToString(dr["fromuser"]); noticeinfo.Begintime = Convert.ToDateTime(dr["begintime"]); noticeinfo.Endtime = Convert.ToDateTime(dr["endtime"]); noticeinfo.Attribute = Convert.ToInt32(dr["attribute"]); noticeinfo.Accressory = Convert.ToString(dr["accressory"]); noticeinfo.Context = Convert.ToString(dr["context"]); list.Add(noticeinfo); } } return(list); }