コード例 #1
0
        private void InitData()
        {
            int    pageCount = 0;
            string filter    = "";                                                                                    //查询过滤条件
            ObservableCollection <object> paras = new System.Collections.ObjectModel.ObservableCollection <object>(); //参数值

            if (Common.CurrentLoginUserInfo != null)
            {
                if (!string.IsNullOrEmpty(Common.CurrentLoginUserInfo.UserPosts[0].CompanyID))
                {
                    filter += "(q.VIEWER =@" + paras.Count().ToString();
                    paras.Add(Common.CurrentLoginUserInfo.UserPosts[0].CompanyID);
                }
                if (!string.IsNullOrEmpty(Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID))
                {
                    if (!string.IsNullOrEmpty(filter))
                    {
                        filter += " or ";
                    }
                    filter += "q.VIEWER =@" + paras.Count().ToString();
                    paras.Add(Common.CurrentLoginUserInfo.UserPosts[0].DepartmentID);
                }
                if (!string.IsNullOrEmpty(Common.CurrentLoginUserInfo.UserPosts[0].PostID))
                {
                    if (!string.IsNullOrEmpty(filter))
                    {
                        filter += " or ";
                    }
                    filter += "q.VIEWER =@" + paras.Count().ToString();
                    paras.Add(Common.CurrentLoginUserInfo.UserPosts[0].PostID);
                }
                if (!string.IsNullOrEmpty(Common.CurrentLoginUserInfo.EmployeeID))
                {
                    if (!string.IsNullOrEmpty(filter))
                    {
                        filter += " or ";
                    }
                    filter += "q.VIEWER =@" + paras.Count().ToString() + ")";
                    paras.Add(Common.CurrentLoginUserInfo.EmployeeID);
                }
            }
            if (!string.IsNullOrEmpty(txtUptown.Text.Trim()))
            {
                if (!string.IsNullOrEmpty(filter))
                {
                    filter += " and ";
                }
                filter += "l.m.COMMUNITY ^@" + paras.Count().ToString();
                paras.Add(txtUptown.Text.Trim());
            }
            if (!string.IsNullOrEmpty(txtHouseName.Text.Trim()))
            {
                if (!string.IsNullOrEmpty(filter))
                {
                    filter += " and ";
                }
                filter += "l.m.HOUSENAME ^@" + paras.Count().ToString();
                paras.Add(txtHouseName.Text.Trim());
            }
            loadbar.Start();
            SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo loginUserInfo = new SMT.SaaS.OA.UI.SmtOACommonAdminService.LoginUserInfo();
            if (string.IsNullOrEmpty(loginUserInfo.companyID))
            {
                Utility.GetLoginUserInfo(loginUserInfo);
            }
            client.GetHireAppHouseListPagingAsync(dataPager.PageIndex, dataPager.PageSize, "CREATEDATE", filter, paras, pageCount, loginUserInfo);
        }