示例#1
0
        protected void SumByRegistersDropoDownList_SelectedIndexChanged(object sender, EventArgs e)
        {
            FiedsDropDownList.Items.Clear();
            FilterFiedsDropDownList.Items.Clear();
            DateForFilter.Items.Clear();
            SumByResultLabel.Text = "";
            int selectedId = 0;

            Int32.TryParse(RegistersDropoDownList.SelectedValue, out selectedId);
            if (selectedId == -1)
            {
                FiedsDropDownList.Items.Clear();
                FilterFiedsDropDownList.Items.Clear();
                DateForFilter.Items.Clear();


                FilterFiedsDropDownList.Enabled = false;
                FiedsDropDownList.Enabled       = false;
                DateForFilter.Enabled           = false;
                SumByButton.Enabled             = false;
                CreateTableButton.Enabled       = false;
            }
            else
            {
                Registers           currentRegister       = main.GetRegisterById(selectedId);
                List <FieldsGroups> fieldsGroupInRegister =
                    main.GetFieldsGroupsInRegisterModelOrderByLine(currentRegister.FkRegistersModel);
                List <Fields> allFields = new List <Fields>();
                foreach (FieldsGroups fieldGroup in fieldsGroupInRegister)
                {
                    List <Fields> tmp = main.GetFieldsInFieldGroupOrderByLine(fieldGroup.FieldsGroupID);
                    foreach (Fields curTmp in tmp)
                    {
                        allFields.Add(curTmp);
                    }
                }
                foreach (Fields field in allFields)
                {
                    FiedsDropDownList.Items.Add(new ListItem()
                    {
                        Value = field.FieldID.ToString(), Text = field.Name
                    });
                    FilterFiedsDropDownList.Items.Add(new ListItem()
                    {
                        Value = field.FieldID.ToString(),
                        Text  = field.Name
                    });
                }
                foreach (Fields field in allFields)
                {
                    if (field.Type == "date" || field.Type == "autoDate") /*&& field.Multiple == false*/// &&
                    {
                        // (from a in fieldsGroupInRegister where a.FieldsGroupID == field.FkFieldsGroup select a).FirstOrDefault().Multiple == false)

                        DateForFilter.Items.Add(new ListItem()
                        {
                            Value = field.FieldID.ToString(), Text = field.Name
                        });
                    }
                }

                FilterFiedsDropDownList.Enabled = true;
                FiedsDropDownList.Enabled       = true;
                DateForFilter.Enabled           = true;
                SumByButton.Enabled             = true;
                CreateTableButton.Enabled       = true;
            }
        }