private void btnQuery_Click(object sender, EventArgs e)
        {
            try
            {
                string cmd = @"
                            select amount,paidamount,paydate,billxmldata from $paymenthistory.accountsreceivable 
                            where uid in 
	                            (
	                            select cast(refpaymenthistoryuid as bigint)
	                            from $paymenttransaction.accountsreceivable 
	                            where balanceaccount = '@BalanceAccount'
	                            )
                            ";

                string account = GetAccount();
                cmd = cmd.Replace("@BalanceAccount", account);

                ConnectionHelper conn = ConnectionHelper.GetConnection(Program.MainPanel.SelectedSource.First());

                XElement req = new XElement("Request",
                                            new XElement("SQL", cmd));

                Envelope rsp = conn.CallService("UDTService.DML.Query", new Envelope(new FISCA.XStringHolder(req.ToString())));

                dgvMerge.Rows.Clear();
                dgvPayItem.Rows.Clear();

                lblPayInfo.Text = "繳費資訊";

                XElement record = XElement.Parse(rsp.BodyContent.XmlString);
                record = record.Element("Record");
                if (record != null)
                {
                    string amount     = record.XPathSelectElement("Column[@Index='1']").Value; //amount
                    string paidamount = record.XPathSelectElement("Column[@Index='2']").Value; //paidamount
                    string paydate    = record.XPathSelectElement("Column[@Index='3']").Value; //paydate
                    string billxml    = record.XPathSelectElement("Column[@Index='4']").Value; //billxmldata

                    lblPayInfo.Text = string.Format("繳費資訊, 應繳:{0}, 已繳:{1}, 繳費日期:{2}", amount, paidamount, paydate);

                    XElement objxml = XElement.Parse(billxml);

                    foreach (XElement each in objxml.Element("Extensions").Elements("Extension"))
                    {
                        string[] fieldinfos = each.Attribute("Name").Value.Split(new string[] { "::" },
                                                                                 StringSplitOptions.RemoveEmptyEntries);

                        string type  = fieldinfos[0].ToLower();
                        string name  = string.Empty;
                        string value = each.Value;

                        if (fieldinfos.Length <= 1) //只有一個元素時都算是 MergeField。
                        {
                            type = "MergeField".ToLower();
                            name = fieldinfos[0];
                        }
                        else
                        {
                            name = fieldinfos[1];
                        }

                        if (type == "MergeField".ToLower())
                        {
                            DataGridViewRow row = new DataGridViewRow();
                            row.CreateCells(dgvMerge, name, value);
                            dgvMerge.Rows.Add(row);
                        }
                        else if (type == "PayItem".ToLower())
                        {
                            DataGridViewRow row = new DataGridViewRow();
                            row.CreateCells(dgvMerge, name, value);
                            dgvPayItem.Rows.Add(row);
                        }
                    }
                }
                else
                {
                    MessageBox.Show("找不到資料。");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }