protected void tr_OrganizeCity_Selected(object sender, SelectedEventArgs e) { #region 限定选择提成计算方法的范围只能是当前片区 DropDownList ddl_SalaryGrade = (DropDownList)UC_DetailView1.FindControl("PM_Promotor_SalaryGrade"); if (ddl_SalaryGrade != null) { try { ddl_SalaryGrade.DataTextField = "Name"; ddl_SalaryGrade.DataValueField = "ID"; string orgcitys = ""; DataTable dt = TreeTableBLL.GetFullPath("MCS_SYS.dbo.Addr_OrganizeCity", "ID", "SuperID", int.Parse(tr_OrganizeCity.SelectValue)); foreach (DataRow dr in dt.Rows) { if (dr["ID"].ToString() != "") { orgcitys += "," + dr["ID"].ToString(); } } if (orgcitys.Length > 1) { orgcitys = orgcitys.Substring(1, orgcitys.Length - 1); } ddl_SalaryGrade.DataSource = PM_SalaryLevelBLL.GetModelList("OrganizeCity in (" + orgcitys + ")"); ddl_SalaryGrade.DataBind(); } catch { } ddl_SalaryGrade.Items.Insert(0, new ListItem("请选择", "0")); } #endregion }