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