Asp.net ajax 使用CascadingDropDown以数据库数据建立三级联下拉框

最新推荐文章于 2021-08-05 15:13:26 发布

clarkguo123

最新推荐文章于 2021-08-05 15:13:26 发布

阅读量2.5k

点赞数

文章标签： asp.net ajax 数据库 stylesheet activerecord string

本文链接：https://blog.youkuaiyun.com/appgqp/article/details/1729458

版权

　　Asp.net 的ajax 有ajax.net（ajaxPro），atlas等版本。Asp.net ajax 1.0 是Atalas的后续，功能强大，上手容易，建议学之。CascadingDropDown是其中的一个功能，为层叠下拉列表框。但是Samle是用ＸＭＬ作为数据源的，不符合我的要求（唉，什么时候我能掌握好ＸＭＬ啊），所以写了这个。希望能给大家带来帮助

　　数据库SQLSERVER 2000,其中有表T_company,T_department,T_user_customer,三表依次以前表ＩＤ连接关系。为了实现一个公司＝＝》部门＝＝》员工的三级下拉框，准备了如下步骤。

１、准备数据对象。

　　采用Castle.activerecod工具。这样可以省去写ＳＱＬ语句的烦恼。

Company对象:

using System;

using System.Collections.Generic;

using System.Text;

using Castle.ActiveRecord;

using System.Collections;

namespace util.DataVO

{

/// <summary>

/// Show the list of company

/// </summary>

[ActiveRecord("T_company")]

public class T_company : ActiveRecordBase<T_company>

{

private string companyName;

private int companyId;

/// <summary>

/// 公司名称

/// </summary>

[Property]

public string CompanyName

{

get { return companyName; }

set { companyName = value; }

}

/// <summary>

/// 公司ID

/// </summary>

[PrimaryKey(PrimaryKeyType.Assigned)]

public int CompanyId

{

get { return companyId; }

set { companyId = value; }

}

department对象:

using System;

using System.Collections.Generic;

using System.Text;

using Castle.ActiveRecord;

namespace util.DataVO

{

/// <summary>

/// show department

/// </summary>

[ActiveRecord("T_department")]

public class T_department : ActiveRecordBase<T_department>

{

private string departmentName;

private int departmentId;

private int companyId;

/// <summary>

/// 公司ID

/// </summary>

[Property]

public int CompanyId

{

get { return companyId; }

set { companyId = value; }

}

/// <summary>

/// 部门名称

/// </summary>

[Property]

public string DepartmentName

{

get { return departmentName; }

set { departmentName = value; }

}

/// <summary>

/// 部门ID

/// </summary>

[PrimaryKey(PrimaryKeyType.Assigned)]

public int DepartmentId

{

get { return departmentId; }

set { departmentId = value; }

}

T_user_Customer对象

using System;

using System.Collections.Generic;

using System.Text;

using Castle.ActiveRecord;

using System.Collections;

namespace util.DataVO

{

/// <summary>

/// user Account

/// </summary>

[ActiveRecord("T_User_Customer")]

public class T_User_Customer : ActiveRecordBase<T_User_Customer>

{

private string nameCn;

private int customerId;

private int companyId;

private int departmentId;

/// <summary>

/// 员工名

/// </summary>

[Property]

public string NameCn

{

set { nameCn = value; }

get { return nameCn; }

}

/// <summary>

/// 员工ID

/// </summary>

[PrimaryKey(PrimaryKeyType.Assigned)]

public int CustomerId

{

set { customerId = value; }

get { return customerId; }

}

/// <summary>

/// 公司ID

/// </summary>

[Property]

public int CompanyId

{

get { return companyId; }

set { companyId = value; }

}

/// <summary>

/// 部门ID

/// </summary>

[Property]

public int DepartmentId

{

get { return departmentId; }

set { departmentId = value; }

}

/// <summary>

/// 取得员工名称列表

/// </summary>

/// <returns></returns>

public static string[] findAllNamelist()

{

T_User_Customer[] list = FindAll();

string[] nameList = new string[list.Length];

for (int i = 0; i < list.Length; i++)

{

nameList[i] = list[i].NameCn;

}

return nameList;

}

在Global.asax里面添加初始化,初始化一个命名空间就可以了

Castle.ActiveRecord.Framework.IConfigurationSource source =

System.Configuration.ConfigurationManager.GetSection( " activerecord " ) as Castle.ActiveRecord.Framework.IConfigurationSource;

Castle.ActiveRecord.ActiveRecordStarter.Initialize( typeof (util.DataVO.T_company).Assembly, source);

２、在ＡＳＰＸ页面上加下拉列表框

<% @ Page Language = " C# " AutoEventWireup = " true " CodeFile = " ReportMasterCascading.aspx.cs " Inherits = " back_crystalReport_ReportMasterCascading " %>

<% @ Register Assembly = " AjaxControlToolkit " Namespace = " AjaxControlToolkit " TagPrefix = " ajaxToolkit " %>

< html xmlns = " http://www.w3.org/1999/xhtml " >

< head id = " Head1 " runat = " server " >

< title > 无标题页 </ title >

< link href = " ../../common/css/okcss.css " rel = " stylesheet " type = " text/css " />

< link href = " /aspnet_client/System_Web/2_0_50727/CrystalReportWebFormViewer3/css/default.css "