Пример #1
0
        private void InitQueryFilter()
        {
            //Button btnFind = this.expander.FindChildControl<Button>("btnFind");
            btnFind.IsEnabled = true;

            // 查询对象
            // LookUp lkObject = this.expander.FindChildControl<LookUp>("lkObject");
            MultiValuesItem <ExtOrgObj> item = new MultiValuesItem <ExtOrgObj>();

            SMT.Saas.Tools.PersonnelWS.T_HR_EMPLOYEE ep = new Saas.Tools.PersonnelWS.T_HR_EMPLOYEE();
            ep.EMPLOYEECNAME = DataCore.CurrentUser.Text;
            ep.EMPLOYEEID    = DataCore.CurrentUser.Value.ToString();

            List <ExtOrgObj> list = new List <ExtOrgObj>()
            {
                new ExtOrgObj {
                    ObjectInstance = ep
                }
            };

            item.Values                = list;
            item.Text                  = ep.EMPLOYEECNAME;
            lkObject.SelectItem        = item;
            lkObject.DataContext       = item;
            lkObject.DisplayMemberPath = "Text";
        }
Пример #2
0
        public void QueryEntity()
        {
            QueryExpression qeBudget = new QueryExpression();
            QueryExpression qe       = qeBudget;

            qe.PropertyName  = "USABLEMONEY";
            qe.PropertyValue = "0";
            qe.Operation     = QueryExpression.Operations.GreaterThan;
            qe.QueryType     = "QueryBudgetAccount";

            ComboBox       cbbBudgetType = this.expander.FindChildControl <ComboBox>("cbbBudgetType");
            ITextValueItem vitem         = cbbBudgetType.SelectedItem as ITextValueItem;

            if (vitem != null && !string.IsNullOrEmpty(vitem.Value.ToString()))
            {
                QueryExpression qeType = QueryExpressionHelper.Equal("AccountObjectType", vitem.Value.ToString());
                qe.RelatedExpression = qeType;
                qe = qeType;
            }
            LookUp lkObject = this.expander.FindChildControl <LookUp>("lkObject");
            MultiValuesItem <ExtOrgObj> mutilValues = lkObject.SelectItem as MultiValuesItem <ExtOrgObj>;

            if (mutilValues != null)
            {
                Dictionary <OrgTreeItemTypes, string> dictTypes = new Dictionary <OrgTreeItemTypes, string>();
                dictTypes.Add(OrgTreeItemTypes.Company, FieldName.OwnerCompanyID);
                dictTypes.Add(OrgTreeItemTypes.Department, FieldName.OwnerDepartmentID);
                dictTypes.Add(OrgTreeItemTypes.Personnel, FieldName.OwnerID);
                dictTypes.Add(OrgTreeItemTypes.Post, FieldName.OwnerPostID);

                mutilValues.Values.ForEach(item =>
                {
                    string propertyName    = dictTypes[item.ObjectType];
                    QueryExpression qeItem = QueryExpressionHelper.Equal(propertyName, item.ObjectID);
                    qeItem.RelatedType     = QueryExpression.RelationType.Or;
                    qe.RelatedExpression   = qeItem;
                    qe = qeItem;
                });
            }
            fbEntityService.QueryFBEntities(qeBudget);
        }
Пример #3
0
        private void lkObject_FindClick(object sender, EventArgs e)
        {
            LookUp             lookUp    = sender as LookUp;
            string             userID    = DataCore.CurrentUser.Value.ToString();
            string             perm      = ((int)Permissions.Browse).ToString();
            string             entity    = "QueryBudgetAccount";
            OrganizationLookup ogzLookup = new OrganizationLookup(userID, perm, entity);

            ogzLookup.MultiSelected   = true;
            ogzLookup.SelectedObjType = OrgTreeItemTypes.All;


            FrameworkElement plRoot = CommonFunction.ParentLayoutRoot;

            ogzLookup.SelectedClick += (o, ev) =>
            {
                if (ogzLookup.SelectedObj.Count > 0)
                {
                    List <ExtOrgObj> list = new List <ExtOrgObj>();
                    string           text = " ";

                    foreach (ExtOrgObj obj in ogzLookup.SelectedObj)
                    {
                        list.Add(obj);

                        text = text.Trim() + ";" + obj.ObjectName;
                    }
                    MultiValuesItem <ExtOrgObj> item = new MultiValuesItem <ExtOrgObj>();
                    item.Values        = list;
                    item.Text          = text.Substring(1);
                    lookUp.SelectItem  = item;
                    lookUp.DataContext = item;
                    //  lookUp.DisplayMemberPath = "Text";
                }
            };
            ogzLookup.Show <string>(DialogMode.ApplicationModal, plRoot, "", (result) => { });
        }
Пример #4
0
        private void InitQueryFilter()
        {
            Button btnFind = this.expander.FindChildControl <Button>("btnFind");

            btnFind.IsEnabled = true;

            // 预算类型
            ComboBox cbbBudgetType = this.expander.FindChildControl <ComboBox>("cbbBudgetType");

            CommonFunction.FillQueryComboBox <BudgetTypeData>(cbbBudgetType);
            ITextValueItem allItem = DataCore.AllSelectdData;

            cbbBudgetType.DisplayMemberPath = "Text";
            cbbBudgetType.SelectedItem      = allItem;

            // 查询对象
            LookUp lkObject = this.expander.FindChildControl <LookUp>("lkObject");
            MultiValuesItem <ExtOrgObj> item = new MultiValuesItem <ExtOrgObj>();

            SMT.Saas.Tools.PersonnelWS.T_HR_EMPLOYEE ep = new Saas.Tools.PersonnelWS.T_HR_EMPLOYEE();
            ep.EMPLOYEECNAME = DataCore.CurrentUser.Text;
            ep.EMPLOYEEID    = DataCore.CurrentUser.Value.ToString();

            List <ExtOrgObj> list = new List <ExtOrgObj>()
            {
                new ExtOrgObj {
                    ObjectInstance = ep
                }
            };

            item.Values                = list;
            item.Text                  = ep.EMPLOYEECNAME;
            lkObject.SelectItem        = item;
            lkObject.DataContext       = item;
            lkObject.DisplayMemberPath = "Text";
        }
Пример #5
0
        public void QueryEntity()
        {
            QueryExpression qeBudget = new QueryExpression();
            QueryExpression qe       = qeBudget;

            qe.PropertyName  = "USABLEMONEY";
            qe.PropertyValue = "0";
            qe.Operation     = QueryExpression.Operations.GreaterThan;
            qe.QueryType     = "QueryBudgetAccount";
            qe.RightType     = "QueryBudgetAccount";


            // 开始日期
            QueryExpression qeStartYear = new QueryExpression
            {
                PropertyName  = "BUDGETYEAR",
                PropertyValue = DateTime.Now.Year.ToString(),
                Operation     = QueryExpression.Operations.GreaterThanOrEqual
            };

            QueryExpression qeStartMonth = new QueryExpression
            {
                PropertyName  = "BUDGETMONTH",
                PropertyValue = DateTime.Now.Month.ToString(),
                Operation     = QueryExpression.Operations.GreaterThanOrEqual
            };

            qe.RelatedExpression          = qeStartYear;
            qeStartYear.RelatedExpression = qeStartMonth;
            qe = qeStartMonth;

            // 结束日期
            QueryExpression qeEndYear = new QueryExpression
            {
                PropertyName  = "BUDGETYEAR",
                PropertyValue = DateTime.Now.Year.ToString(),
                Operation     = QueryExpression.Operations.LessThanOrEqual
            };

            QueryExpression qeEndMonth = new QueryExpression
            {
                PropertyName  = "BUDGETMONTH",
                PropertyValue = DateTime.Now.Month.ToString(),
                Operation     = QueryExpression.Operations.LessThanOrEqual
            };

            qe.RelatedExpression        = qeEndYear;
            qeEndYear.RelatedExpression = qeEndMonth;
            qe = qeEndMonth;

            // 结束日期
            QueryExpression qeAccountType = new QueryExpression
            {
                PropertyName  = "ACCOUNTOBJECTTYPE",
                PropertyValue = "1",
                Operation     = QueryExpression.Operations.NotEqual
            };

            qe.RelatedExpression        = qeEndMonth;
            qeEndYear.RelatedExpression = qeAccountType;
            qe = qeAccountType;

            QueryExpression qeTemp = null;
            // 选择范围
            MultiValuesItem <ExtOrgObj> mutilValues = lkObject.SelectItem as MultiValuesItem <ExtOrgObj>;

            if (mutilValues != null)
            {
                Dictionary <OrgTreeItemTypes, string> dictTypes = new Dictionary <OrgTreeItemTypes, string>();
                dictTypes.Add(OrgTreeItemTypes.Company, FieldName.OwnerCompanyID);
                dictTypes.Add(OrgTreeItemTypes.Department, FieldName.OwnerDepartmentID);
                dictTypes.Add(OrgTreeItemTypes.Personnel, FieldName.OwnerID);
                dictTypes.Add(OrgTreeItemTypes.Post, FieldName.OwnerPostID);

                mutilValues.Values.ForEach(item =>
                {
                    string propertyName      = dictTypes[item.ObjectType];
                    QueryExpression qeItem   = QueryExpressionHelper.Equal(propertyName, item.ObjectID);
                    qeItem.RelatedType       = QueryExpression.RelationType.Or;
                    qeItem.RelatedExpression = qeTemp;
                    qeTemp = qeItem;
                });
            }

            if (qeTemp != null)
            {
                qe.RelatedExpression = qeTemp;
            }

            fbEntityService.QueryFBEntities(qeBudget);
        }