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