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;
}
}
}
}
3、//判断要增加的记录是否已存在
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);
}