页面设计中常见与Raptier结合的方法

1、填充货币下拉框 

ddl_Currency.Items.Clear();
        ddl_Currency.Items.Add("");
        using (QD_XDocument.DAL.QD_XDocument db = new QD_XDocument.DAL.QD_XDocument())
        {
            CurrencyRow[] Currencies = db.CurrencyCollection.GetAsArray("", "CurrencyName ASC");
            foreach (CurrencyRow currency in Currencies)
            {
                ddl_Currency.Items.Add(new ListItem(currency.CurrencyName,currency.CurrencyID));
            }

2、绑定GridView

由于该绑定使用到了两个表，因此在BLL中建立Country类   

#region f_databind  绑定GridView
    private void f_databind()
    {
        gv_Country.DataKeyField = "CountryID";
        gv_Country.DataSource = Country.GetAllCountries();
        gv_Country.DataBind();
        l_CurrentPage.Text = "第 " + (gv_Country.CurrentPageIndex + 1).ToString() + " 页";
        l_TotalPage.Text = "共 " + gv_Country.PageCount.ToString() + " 页";
    }   
    #endregion

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

/// <summary>
/// Country 的摘要说明
/// </summary>
namespace QD_XDocument.BLL
{
    public class Country
    {
        public Country()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }
        /// <summary>
        /// 获取所有国家及其使用货币
        /// </summary>
        /// <returns></returns>
        public static DataTable GetAllCountries()
        {
            using (QD_XDocument.DAL.QD_XDocument db = new QD_XDocument.DAL.QD_XDocument())
            {
                string strSQL = "SELECT TOP 100 PERCENT c.CountryID, c.CountryName, cu.CurrencyName, ";
                strSQL += "      c.CurrencyID";
                strSQL += " FROM dbo.Country c INNER JOIN";
                strSQL += "      dbo.Currency cu ON c.CurrencyID = cu.CurrencyID";
                strSQL += " ORDER BY c.CountryID";

                DataTable dt = db.ExecuteDataset(CommandType.Text,strSQL).Tables[0];
                return dt;
            }
        }
    }
}

３、//判断要增加的记录是否已存在
        using (QD_XDocument.DAL.QD_XDocument db = new QD_XDocument.DAL.QD_XDocument())
        {
            CountryRow[] Countries = db.CountryCollection.GetAsArray("CountryName='" + tb_CountryName.Text.Trim() + "'","");
            if (Countries.Length > 0)
            {
                Alert("国家名称 " + tb_CountryName.Text.Trim() + " 已存在，不能重复添加！");
                tb_CountryName.Focus();
                return;
            }
        }

4、        //获得应用货币ID CurrencyID
        string sCurrencyID = ddl_Currency.SelectedValue;

5、插入：

        using (QD_XDocument.DAL.QD_XDocument db = new QD_XDocument.DAL.QD_XDocument())
        {
            QD_XDocument.DAL.CountryRow row = new QD_XDocument.DAL.CountryRow();
            row.CountryID = Guid.NewGuid().ToString();
            row.CountryName = tb_CountryName.Text;
            row.CurrencyID = sCurrencyID;

            db.CountryCollection.Insert(row);
        }