同时更新3个下拉列表数据的标单怎么处理
有三个表,分别捆绑了3个下拉列表:
CREATE TABLE [dbo].[City] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[CityName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[CityId] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[AreaId] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[DepartmentId] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[Area] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[AreaName] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[departmentid] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[Areaid] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
CREATE TABLE [dbo].[Department] (
[id] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[DepartmentId] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[DepartmentName] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
1、现在是要选取CITY捆绑的下拉列表后,area的捆绑内容随city的变化而变化,department 的内容也变化
2、选取area后,department 的内容随着变化