コード例 #1
0
ファイル: QueryModel.cs プロジェクト: rossspoon/bvcms
 public void EditCondition()
 {
     var c = Db.LoadQueryById(SelectedId);
     if (c == null)
         return;
     ConditionName = c.FieldInfo.Name;
     SetVisibility();
     Comparison = c.Comparison;
     switch (c.FieldInfo.Type)
     {
         case FieldType.String:
         case FieldType.StringEqual:
         case FieldType.StringEqualOrStartsWith:
             TextValue = c.TextValue;
             break;
         case FieldType.Integer:
         case FieldType.IntegerSimple:
         case FieldType.IntegerEqual:
         case FieldType.NullInteger:
             IntegerValue = c.TextValue;
             break;
         case FieldType.Number:
         case FieldType.NumberLG:
         case FieldType.NullNumber:
             NumberValue = c.TextValue;
             break;
         case FieldType.Date:
         case FieldType.DateSimple:
             DateValue = DateString(c.DateValue);
             break;
         case FieldType.Code:
         case FieldType.NullCode:
         case FieldType.CodeStr:
         case FieldType.DateField:
         case FieldType.Bit:
         case FieldType.NullBit:
             CodeValue = c.CodeIdValue;
             if (c.HasMultipleCodes && CodeValue.HasValue())
             {
                 CodeValues = c.CodeIdValue.Split(';');
                 foreach (var i in CodeData)
                     i.Selected = CodeValues.Contains(i.Value);
             }
             break;
     }
     Program = c.Program;
     DivisionData = Divisions(Program).ToList();
     Division = c.Division;
     OrganizationData = Organizations(Division).ToList();
     Organization = c.Organization;
     Schedule = c.Schedule;
     Campus = c.Campus;
     OrgType = c.OrgType;
     StartDate = DateString(c.StartDate);
     EndDate = DateString(c.EndDate);
     SelectMultiple = c.HasMultipleCodes;
     AddToGroupEnabled = c.IsGroup;
     AddEnabled = !c.IsFirst;
     RemoveEnabled = !c.IsFirst;
     Days = c.Days.ToString();
     Age = c.Age.ToString();
     Quarters = c.Quarters;
     if (TagsVisible)
     {
         if (c.Tags != null)
             Tags = c.Tags.Split(';');
         var cv = new CodeValueModel();
         TagData = CodeValueModel.ConvertToSelect(cv.UserTags(Util.UserPeopleId), "Code");
         foreach (var i in TagData)
             i.Selected = Tags.Contains(i.Value);
     }
     if (PmmLabelsVisible)
     {
         if (c.Tags != null)
             PmmLabels = c.Tags.Split(',').Select(vv => vv).ToArray();
         var cv = new CodeValueModel();
         PmmLabelData = CodeValueModel.ConvertToSelect(cv.PmmLabels(), "Id");
         if(PmmLabels != null)
             foreach (var i in PmmLabelData)
                 i.Selected = PmmLabels.Contains(i.Value);
     }
     if (MinistryVisible)
         Ministry = c.Program;
     SavedQueryDesc = c.SavedQueryIdDesc;
 }
コード例 #2
0
ファイル: QueryModel.cs プロジェクト: rossspoon/bvcms
        public void SetVisibility()
        {
            RightPanelVisible = true;
            TextVisible = false;
            NumberVisible = false;
            CodeVisible = false;
            CodesVisible = false;
            DateVisible = false;
            CodeData = null;
            ConditionName = ConditionName;
            CompareData = Comparisons().ToList();
            DivisionVisible = fieldMap.HasParam("Division");
            ProgramVisible = fieldMap.HasParam("Program");
            OrganizationVisible = fieldMap.HasParam("Organization");
            ScheduleVisible = fieldMap.HasParam("Schedule");
            CampusVisible = fieldMap.HasParam("Campus");
            OrgTypeVisible = fieldMap.HasParam("OrgType");
            DaysVisible = fieldMap.HasParam("Days");
            AgeVisible = fieldMap.HasParam("Age");
            SavedQueryVisible = fieldMap.HasParam("SavedQueryIdDesc");
            MinistryVisible = fieldMap.HasParam("Ministry");
            QuartersVisible = fieldMap.HasParam("Quarters");
            if (QuartersVisible)
                QuartersLabel = fieldMap.QuartersTitle;
            TagsVisible = fieldMap.HasParam("Tags");
            if (TagsVisible)
            {
                var cv = new CodeValueModel();
                TagData = CodeValueModel.ConvertToSelect(cv.UserTags(Util.UserPeopleId), "Code");
            }
            PmmLabelsVisible = fieldMap.HasParam("PmmLabels");
            if (PmmLabelsVisible)
            {
                var cv = new CodeValueModel();
                PmmLabelData = CodeValueModel.ConvertToSelect(cv.PmmLabels(), "Code");
            }
            StartDateVisible = fieldMap.HasParam("StartDate");
            EndDateVisible = fieldMap.HasParam("EndDate");

            var cvctl = new CodeValueModel();
            switch (fieldMap.Type)
            {
                case FieldType.Bit:
                case FieldType.NullBit:
                    CodeVisible = true;
                    CodeData = CodeValueModel.ConvertToSelect(BitCodes, fieldMap.DataValueField);
                    break;
                case FieldType.String:
                case FieldType.StringEqual:
                case FieldType.StringEqualOrStartsWith:
                    TextVisible = true;
                    break;
                case FieldType.NullNumber:
                case FieldType.Number:
                case FieldType.NumberLG:
                    NumberVisible = true;
                    break;
                case FieldType.NullInteger:
                case FieldType.Integer:
                case FieldType.IntegerSimple:
                case FieldType.IntegerEqual:
                    IntegerVisible = true;
                    break;
                case FieldType.NullCode:
                case FieldType.Code:
                case FieldType.CodeStr:
                    CodeVisible = true;
                    if (fieldMap.DataSource == "ExtraValues")
                        CodeData = StandardExtraValues.ExtraValueCodes();
                    else if (fieldMap.DataSource == "Campuses")
                        CodeData = Campuses();
                    else
                        CodeData = CodeValueModel.ConvertToSelect(Util.CallMethod(cvctl, fieldMap.DataSource), fieldMap.DataValueField);
                    break;
                case FieldType.Date:
                case FieldType.DateSimple:
                    DateVisible = true;
                    break;
                case FieldType.DateField:
                    CodeVisible = true;
                    CodeData = CodeValueModel.ConvertToSelect(Util.CallMethod(cvctl, fieldMap.DataSource), fieldMap.DataValueField);
                    break;
            }
            var cc = Db.LoadQueryById(SelectedId);
            if (cc == null)
                return;

            if (fieldMap.Type == FieldType.Group)
            {
                CompareData = Comparisons().ToList();
                RightPanelVisible = false;
                UpdateEnabled = cc.IsGroup;
                return;
            }
            UpdateEnabled = !cc.IsGroup && !cc.IsFirst;
            AddToGroupEnabled = cc.IsGroup;
            AddEnabled = !cc.IsFirst;
            RemoveEnabled = !cc.IsFirst;
        }