xml转换为dataset

最新推荐文章于 2021-02-23 22:55:03 发布

goodyatou

最新推荐文章于 2021-02-23 22:55:03 发布

阅读量745

点赞数

文章标签： dataset xml string null cache

本文链接：https://blog.youkuaiyun.com/goodyatou/article/details/5054716

版权

        /// <summary>
        /// 读取数据集并加入缓存
        /// sea 2009-12-11
        /// </summary>
        /// <returns>结果集</returns>
        private DataSet BindData()
        {
            if (Cache["ds"] == null)
            {
                XmlDocument xdoc = new XmlDocument();
                xdoc.LoadXml(Service.TicketCancel.GetTicketCancel());
                DataSet ds = CreatDataSet();
                XmlNodeList xlist = xdoc.SelectSingleNode("/JIT-Cancel-Response").ChildNodes;
                foreach (XmlNode xnode in xlist)
                {
                    DataRow dr = ds.Tables[0].NewRow();
                    dr["id"] = xnode.Attributes["id"].Value;
                    dr["AirlineCompanyC"] = xnode.Attributes["AirlineCompanyC"].Value;
                    dr["AirlineCompanyE"] = xnode.Attributes["AirlineCompanyE"].Value;
                    dr["CancelContent"] = xnode.Attributes["CancelContent"].Value;
                    dr["userName"] = xnode.Attributes["userName"].Value;
                    dr["UpdateContent"] = xnode.Attributes["UpdateContent"].Value;
                    ds.Tables[0].Rows.Add(dr);
                }
                Cache.Add("ds", ds, null, DateTime.Now.AddHours(1), System.Web.Caching.Cache.NoSlidingExpiration, System.Web.Caching.CacheItemPriority.High, null
                    );
                return ds;
            }
            else
            {
                return (DataSet)Cache["ds"];
            }
        }
        public static DataSet CreatDataSet()
        {
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            dt.Columns.Add(new DataColumn("id", typeof(int)));
            dt.Columns.Add(new DataColumn("AirlineCompanyC", typeof(string)));
            dt.Columns.Add(new DataColumn("AirlineCompanyE", typeof(string)));
            dt.Columns.Add(new DataColumn("CancelContent", typeof(string)));
            dt.Columns.Add(new DataColumn("userName", typeof(string)));
            dt.Columns.Add(new DataColumn("UpdateContent",typeof(string)));
            ds.Tables.Add(dt);
            return ds;
        }