/// <summary> /// 查询 /// </summary> private void DoSelect() { string sql = @"select * from SysUser where UserID in ( select UserID from ( select count(UserID)%2 cnt,UserID from SysEvent where DateTime>=dateadd(day,-2,GetDate()) and Type is null group by UserID) a where cnt>0)"; if (SearchCriterion.GetSearchValue <string>("Name") != "") { sql += " and Name like '%" + SearchCriterion.GetSearchValue <string>("Name") + "%'"; } //PageState.Add("AbsenceApplyList", GetPageData(sql, SearchCriterion)); //ents = AbsenceApply.FindAll(SearchCriterion); //this.PageState.Add("AbsenceApplyList", ents); Aim.Portal.ServicesProvider.WebPortalServiceProvider ws = (Aim.Portal.ServicesProvider.WebPortalServiceProvider)WebPortalService.GetDefaultProvider(); SysUser[] users = Aim.Common.ServiceHelper.DeserializeFromBytes <SysUser[]>(ws.USService.GetSystemData("<container><parameters><parameter Name='SessionID'></parameter><parameter Name='Operation'>getonlineusers</parameter></parameters></container>")); PageState.Add("AbsenceApplyList", users); }
protected void Page_Load(object sender, EventArgs e) { switch (RequestActionString) { case "logout": WebPortalService.Logout(); break; default: if (Request.QueryString["tag"] != null && Request.QueryString["tag"] == "Refresh") { try { GoodwaySSO.Sso.Singletion.RefreshUserState(Session["PassCode"].ToString()); } catch { } //在线人数 int urcts = 0; Aim.Portal.ServicesProvider.WebPortalServiceProvider ws = (Aim.Portal.ServicesProvider.WebPortalServiceProvider)WebPortalService.GetDefaultProvider(); urcts = Aim.Common.ServiceHelper.DeserializeFromBytes <SysUser[]>(ws.USService.GetSystemData("<container><parameters><parameter Name='SessionID'></parameter><parameter Name='Operation'>getonlineusers</parameter></parameters></container>")).Length; Response.Write(urcts); Response.End(); } //string connStr = ConfigurationManager.AppSettings["BJKY_Examine"].ToString(); //SqlConnection conn = new SqlConnection(connStr); //string sql = "select Id from BJKY_Examine..PersonConfig where ClerkIds like '%" + UserInfo.UserID + "%' and GroupType <>'系统部门'";//判定登陆人是不是员工 //SqlCommand com = new SqlCommand(sql, conn); //conn.Open(); //DataSet ds = new DataSet(); //SqlDataAdapter da = new SqlDataAdapter(com); //da.Fill(ds); //conn.Close(); //if (ds.Tables[0].Rows.Count > 0) //{ // PageState.Add("IsClerk", "T"); //} //else //{ // PageState.Add("IsClerk", "F"); //} IEnumerable <SysModule> topAuthExamMdls = new List <SysModule>(); string appcode = EXAMINING_APP_CODE; if (this.Request.QueryString["App"] != null && this.Request.QueryString["App"].Trim() != "") { appcode = this.Request.QueryString["App"]; } if (UserContext.AccessibleApplications.Count > 0) { SysApplication examApp = UserContext.AccessibleApplications.FirstOrDefault(tent => tent.Code == appcode); if (examApp != null && UserContext.AccessibleModules.Count > 0) { topAuthExamMdls = UserContext.AccessibleModules.Where(tent => tent.ApplicationID == examApp.ApplicationID && String.IsNullOrEmpty(tent.ParentID)); topAuthExamMdls = topAuthExamMdls.OrderBy(tent => tent.SortIndex); } } if (Session["PassCode"] == null) { SqlDataAdapter sda = new SqlDataAdapter("select Id,WorkNo,UserName,SystemName from OgUser where SystemName='" + this.UserInfo.LoginName + "' ", System.Configuration.ConfigurationManager.ConnectionStrings["BJKY_BeAdmin"].ConnectionString); DataTable dt = new DataTable(); sda.Fill(dt); if (dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; string template = "<Form Name='" + row["Id"] + "'><Id>" + row["Id"] + "</Id><WorkNo>" + row["WorkNo"] + "</WorkNo><UserName>" + row["UserName"] + "</UserName><SystemName>" + row["SystemName"] + "</SystemName><Password></Password><Field></Field></Form>"; string passCode = ""; // 20140409 潘注释 不然导致首页加载非常慢 try { passCode = GoodwaySSO.Sso.LoginGW(template, row["Id"].ToString(), row["UserName"].ToString()); } catch { } PageState.Add("PassCode", passCode); Session["PassCode"] = passCode; } else { Session["PassCode"] = ""; } } IList <SysApplication> saEnts = UserContext.AccessibleApplications.OrderBy(tens => tens.SortIndex).Where(ent => ent.Status == 1).ToArray(); this.PageState.Add("Modules", saEnts); DataTable dtps = DataHelper.QueryDataTable("select GroupID DeptId,Name DeptName from SysGroup where GroupID in (select BaseTemplateId from WebPartTemplate where BlockType='DeptPortal')"); this.PageState.Add("Depts", DataHelper.DataTableToDictList(dtps)); //在线人数 int urs = 0; Aim.Portal.ServicesProvider.WebPortalServiceProvider uss = (Aim.Portal.ServicesProvider.WebPortalServiceProvider)WebPortalService.GetDefaultProvider(); urs = Aim.Common.ServiceHelper.DeserializeFromBytes <SysUser[]>(uss.USService.GetSystemData("<container><parameters><parameter Name='SessionID'></parameter><parameter Name='Operation'>getonlineusers</parameter></parameters></container>")).Length; this.PageState.Add("UserOnLine", urs); //PopWin(); break; } }