/// <summary> /// 得到一个对象实体 /// </summary> public static Kingrocket.NotifyService.OnlineUserInfo DataRowToModel(DataRow row) { Kingrocket.NotifyService.OnlineUserInfo model = new Kingrocket.NotifyService.OnlineUserInfo(); if (row != null) { if (row["SessionID"] != null) { model.SessionID = row["SessionID"].ToString(); } if (row["LineID"] != null && row["LineID"].ToString() != "") { model.LineID = new Guid(row["LineID"].ToString()); } if (row["TestRoomCode"] != null) { model.TestRoomCode = row["TestRoomCode"].ToString(); } if (row["LineName"] != null) { model.LineName = row["LineName"].ToString(); } if (row["SegmentName"] != null) { model.SegmentName = row["SegmentName"].ToString(); } if (row["CompanyName"] != null) { model.CompanyName = row["CompanyName"].ToString(); } if (row["TestRoomName"] != null) { model.TestRoomName = row["TestRoomName"].ToString(); } if (row["ClientObj"] != null && row["ClientObj"].ToString() != "") { model.ClientObj = (byte[])row["ClientObj"]; } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["LoginTime"] != null && row["LoginTime"].ToString() != "") { model.LoginTime = DateTime.Parse(row["LoginTime"].ToString()); } if (row["LastActiveTime"] != null && row["LastActiveTime"].ToString() != "") { model.LastActiveTime = DateTime.Parse(row["LastActiveTime"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public static Kingrocket.NotifyService.OnlineUserInfo GetOnlineUserInfo(string SessionID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 SessionID,LineID,TestRoomCode,LineName,SegmentName,CompanyName,TestRoomName,ClientObj,UserName,LoginTime,LastActiveTime from sys_auth_Users_Online "); strSql.Append(" where SessionID=@SessionID "); SqlParameter[] parameters = { new SqlParameter("@SessionID", SqlDbType.VarChar, 100) }; parameters[0].Value = SessionID; Kingrocket.NotifyService.OnlineUserInfo model = new Kingrocket.NotifyService.OnlineUserInfo(); DataSet ds = Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }