protected void rctxtStartingCycle_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e) { string whereStr; vUTPCycle endingCycle;//终止区域 if (rctxtCompany.SelectedValue != "N/A") { whereStr = " and it.CompanyID='" + rctxtCompany.SelectedValue + "'"; this.OrderBy = " it.Cycle asc "; BLL_vUTPCustomer = new vUTPCustomerBLL(); endingCycle = BLL_vUTPCustomer.FindLastCycleByCompanyId(rctxtCompany.SelectedValue, this.OrderBy); whereStr = " and it.CompanyID='" + rctxtCompany.SelectedValue + "' and it.Cycle >= " + rctxtStartingCycle.SelectedValue + " and it.Cycle <= " + endingCycle.Cycle + ""; vUTPCycleObjs = BLL_vUTPCustomer.GetUTPCycles(whereStr, this.OrderBy); if (vUTPCycleObjs.Count() > 0) { rctxtEndingCycle.DataSource = vUTPCycleObjs; rctxtEndingCycle.DataValueField = "Cycle"; rctxtEndingCycle.DataTextField = "Cycle"; rctxtEndingCycle.DataBind(); } } }
protected void CycleComboBoxBind(string UTPCompanyId) { RadComboBoxItem startingCycle; //起始区域Telerik控件 RadComboBoxItem endingCycle; //结束区域Telerik控件 string whereStr; whereStr = " and it.CompanyID='" + UTPCompanyId + "'"; this.OrderBy = " it.Cycle asc "; try { vUTPCycleObjs = BLL_vUTPCustomer.GetUTPCycles(whereStr, this.OrderBy); } catch (NullReferenceException) { BLL_vUTPCustomer = new vUTPCustomerBLL(); vUTPCycleObjs = BLL_vUTPCustomer.GetUTPCycles(whereStr, this.OrderBy); } if (vUTPCycleObjs.Count() > 0) { try { //起始区域 rctxtStartingCycle.DataSource = vUTPCycleObjs; rctxtStartingCycle.DataValueField = "Cycle"; rctxtStartingCycle.DataTextField = "Cycle"; rctxtStartingCycle.DataBind(); //终止区域 rctxtEndingCycle.DataSource = vUTPCycleObjs; rctxtEndingCycle.DataValueField = "Cycle"; rctxtEndingCycle.DataTextField = "Cycle"; rctxtEndingCycle.DataBind(); } catch (Exception) { //清空终止区域 rctxtEndingCycle.Items.Clear(); endingCycle = new RadComboBoxItem("N/A", "N/A"); rctxtEndingCycle.Items.Add(endingCycle); //清空起始区域 rctxtStartingCycle.Items.Clear(); startingCycle = new RadComboBoxItem("N/A", "N/A"); rctxtStartingCycle.Items.Add(startingCycle); } } else { //清空终止区域 rctxtEndingCycle.Items.Clear(); endingCycle = new RadComboBoxItem("N/A", "N/A"); rctxtEndingCycle.Items.Add(endingCycle); //清空起始区域 rctxtStartingCycle.Items.Clear(); startingCycle = new RadComboBoxItem("N/A", "N/A"); rctxtStartingCycle.Items.Add(startingCycle); //无数据chkAllCycles置灰 chkAllCycles.Checked = false; chkAllCycles.Enabled = false; } }