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; } }