• 使用List<T>


    .aspx页面中的方法:

    //将获取到的List<T>值赋值给TextBox

    private void InitTextBox()

    {

        int id = int.Parse(ViewState["ID"].ToString());
                List<NewsModel> list =NewsBLL.GetLoad(id);
                foreach (NewsModel m in list)
                {
                    txtTitle.Text = m.Title;
                    txtCata.Text = m.NewsCatagory;
                    txtContent.Text = m.Content;
                    listBoxAttachment.Items.Add(m.Attachment);
                }

    }

    BLL中调用DAL中的方法:

    /// <summary>
            /// 获取新闻所有信息
            /// </summary>
            /// <param name="id"></param>
            /// <returns></returns>
            public static List<NewsModel> GetLoad(int id)
            {
                string sql = "select * from TB_XWGG where ID="+id;
                return NewsHelper.GetList(sql);
            }

    DAL中方法:

    /// <summary>
            /// 返回新闻表中的所有信息
            /// </summary>
            /// <param name="sql"></param>
            /// <returns></returns>
            public static List<NewsModel> GetList(string sql)
            {
                List<NewsModel> list = new List<NewsModel>();
                NewsModel m = new NewsModel();
                try
                {
                    OraConn = new OracleConnection(ConnString);
                    OraCmd = OraConn.CreateCommand();
                    OraCmd.CommandText = sql;
                    OraConn.Open();
                    OracleDataReader reader = OraCmd.ExecuteReader();
                    while (reader.Read())
                    {
                        m.ID = int.Parse(reader["ID"].ToString());
                        m.Title = reader["BT"].ToString();  //标题
                        m.Content = reader["NR"].ToString();  //内容
                        m.NewsCatagory = reader["XWLX"].ToString();  //新闻类型
                        m.Creator = reader["FBR"].ToString();  //发布人
                        m.CreateUnitID = reader["FBDW"].ToString();  //发布单位
                        m.CreateTime = Convert.ToDateTime(reader["FBSJ"].ToString());   //发布时间
                        m.Attachment = reader["FJMC"].ToString();    //附件名称
                        m.AttachmentPath=reader["FJLJ"].ToString();   //附件路径
                        m.AttachmentState=int.Parse(reader["FJCZ"].ToString());   //附件状态
                        m.NewsState=int.Parse(reader["SFQY"].ToString());  //新闻状态
                    }
                    list.Add(m);
                }
                catch (Exception)
                { }
                finally {
                    OraCmd.Dispose(); //释放资源
                    OraConn.Close();  //关闭数据库
                }
                return list;
            }

  • 相关阅读:
    关于datatable的一些操作以及使用adapter对数据的操作
    P1083 借教室
    P2264 情书
    P1772 [ZJOI2006]物流运输
    P1353 [USACO08JAN]跑步Running
    P2903 [USACO08MAR]麻烦的干草打包机The Loathesome Hay Baler
    P2895 [USACO08FEB]流星雨Meteor Shower
    P2665 [USACO08FEB]连线游戏Game of Lines
    P2896 [USACO08FEB]一起吃饭Eating Together
    P2925 [USACO08DEC]干草出售Hay For Sale
  • 原文地址:https://www.cnblogs.com/jsping/p/2553315.html
Copyright © 2020-2023  润新知