解析XML获取数据

     /// <summary>
        /// 读取xml，分解xml内容
        /// </summary>
        public static void AnalysisXml() 
        {
            string strSql = "select BillCode,ApprovalLog from T_ReceiptBill_Head where BillCode != ''";
            DataTable dtReceiptBill = new DaoReceiptBill().GetReceiptBill(strSql);
            if (dtReceiptBill.Rows.Count == 0)
            {
                return;
            }
            List<User> UserList = new List<User>();
            foreach ( DataRow row in dtReceiptBill.Rows)
            {
                string strXml = Convert.ToString(row["ApprovalLog"]);
                User user = GetUserInfo(strXml);
                if (user == null || user.UserCode == null)
                {
                    continue;
                }
                user.BillCode = Convert.ToString(row["BillCode"]);
                Console.WriteLine("添加：" + user.BillCode);
                UserList.Add(user);
            }
            // 修改用户信息
            UpdateUserInfo(UserList);
        }

        private static void UpdateUserInfo(List<User> users)
        {
            DaoReceiptBill daoReceiptBill = new DaoReceiptBill();     
            try
            {
                // 开启事务
                daoReceiptBill.BeginTransaction();
                foreach (User user in users)
                {
                    Console.WriteLine("修改：-----------" + user.BillCode);
                    string str = string.Format("update T_ReceiptBill_Head set LastapproveTime = '{0}' where BillCode = '{1}'", user.Time,user.BillCode);
                    daoReceiptBill.UpdateBill(str);
                }
                // 提交事务
                daoReceiptBill.CommitTransaction();
            }
            catch (Exception ex)
            {
                daoReceiptBill.RollBackTransaction();
                Console.WriteLine("修改开票申请出错：" + ex.Message);
            }
        }