/// <summary> /// 新增/删除/修改 sys_Online /// </summary> /// <param name="fam">sys_OnlineTable实体类</param> /// <returns>返回0操正常</returns> public override int sys_OnlineInsertUpdate(sys_OnlineTable fam) { int rInt = 0; using (SqlConnection Conn = GetSqlConnection()) { SqlCommand cmd = new SqlCommand("sys_OnlineInsertUpdateDelete", Conn); cmd.CommandType = CommandType.StoredProcedure; //设置参数 cmd.Parameters.Add("@DB_Option_Action_", SqlDbType.NVarChar).Value = fam.DB_Option_Action_; //操作方法 Insert:增加 Update:修改 Delete:删除 Disp:显示单笔记录 cmd.Parameters.Add("@OnlineID", SqlDbType.Int).Value = fam.OnlineID; //自动ID cmd.Parameters.Add("@O_SessionID", SqlDbType.VarChar).Value = fam.O_SessionID; //用户SessionID cmd.Parameters.Add("@O_UserName", SqlDbType.NVarChar).Value = fam.O_UserName; //用户名 cmd.Parameters.Add("@O_Ip", SqlDbType.VarChar).Value = fam.O_Ip; //用户IP地址 cmd.Parameters.Add("@O_LoginTime", SqlDbType.DateTime).Value = fam.O_LoginTime; //登陆时间 cmd.Parameters.Add("@O_LastTime", SqlDbType.DateTime).Value = fam.O_LastTime; //最后访问时间 cmd.Parameters.Add("@O_LastUrl", SqlDbType.NVarChar).Value = fam.O_LastUrl; //最后请求网站 Conn.Open(); rInt = Convert.ToInt32(cmd.ExecuteScalar()); cmd.Dispose(); Conn.Dispose(); Conn.Close(); } return rInt; }
/// <summary> /// 新增/删除/修改 sys_Online /// </summary> /// <param name="fam">sys_OnlineTable实体类</param> /// <returns>返回0操正常</returns> public abstract int sys_OnlineInsertUpdate(sys_OnlineTable fam);
/// <summary> /// 将记录集转为sys_OnlineTable实体类 /// </summary> /// <param name="dr">记录集</param> /// <returns>sys_OnlineTable</returns> protected object Populatesys_Online(IDataReader dr) { sys_OnlineTable nc = new sys_OnlineTable(); if (!Convert.IsDBNull(dr["OnlineID"])) nc.OnlineID = Convert.ToInt32(dr["OnlineID"]); // 自动ID if (!Convert.IsDBNull(dr["O_SessionID"])) nc.O_SessionID = Convert.ToString(dr["O_SessionID"]).Trim(); // 用户SessionID if (!Convert.IsDBNull(dr["O_UserName"])) nc.O_UserName = Convert.ToString(dr["O_UserName"]).Trim(); // 用户名 if (!Convert.IsDBNull(dr["O_Ip"])) nc.O_Ip = Convert.ToString(dr["O_Ip"]).Trim(); // 用户IP地址 if (!Convert.IsDBNull(dr["O_LoginTime"])) nc.O_LoginTime = Convert.ToDateTime(dr["O_LoginTime"]); // 登陆时间 if (!Convert.IsDBNull(dr["O_LastTime"])) nc.O_LastTime = Convert.ToDateTime(dr["O_LastTime"]); // 最后访问时间 if (!Convert.IsDBNull(dr["O_LastUrl"])) nc.O_LastUrl = Convert.ToString(dr["O_LastUrl"]).Trim(); // 最后请求网站 return nc; }
private static sys_OnlineTable PutUserOnline(string username, string sessionid, string action) { sys_OnlineTable online = new sys_OnlineTable(); online.DB_Option_Action_ = action; online.O_Ip = Common.GetIPAddress(); online.O_LastTime = DateTime.Now; online.O_LastUrl = Common.GetScriptUrl; online.O_LoginTime = online.O_LastTime; online.O_SessionID = sessionid; online.O_UserName = username; return online; }
/// <summary> /// 根据用户名读取在线用户 /// </summary> /// <param name="O_UserName">用户名</param> /// <param name="sessionid">用户SessionID</param> /// <returns>返回sys_OnlineTable实例</returns> public static sys_OnlineTable sys_OnlineDisp(string O_UserName,string sessionid) { sys_OnlineTable Online = new sys_OnlineTable(); QueryParam qp = new QueryParam(); qp.Where = string.Format("Where O_SessionID='{0}' and O_UserName='******'",sessionid, Common.inSQL(O_UserName)); qp.PageIndex = 1; qp.PageSize = 1; int rInt = 0; ArrayList lst = sys_OnlineList(qp, out rInt); if (rInt == 1) { Online = (sys_OnlineTable)lst[0]; } return Online; }
/// <summary> /// 根据UserID返回 sys_OnlineTable实体类 单笔资料 /// </summary> /// <param name="sessionid">用户sessionID</param> /// <returns>返回sys_OnlineTable实体类 OnlineID为0则无记录</returns> public static sys_OnlineTable sys_OnlineDispSessionID(string sessionid) { sys_OnlineTable fam = new sys_OnlineTable(); QueryParam qp = new QueryParam(); qp.PageIndex = 1; qp.PageSize = 1; qp.Where = " Where sys_Online.O_SessionID = '" + Common.inSQL(sessionid) + "'"; int RecordCount = 0; ArrayList lst = sys_OnlineList(qp, out RecordCount); if (RecordCount > 0) { fam = (sys_OnlineTable)lst[0]; } return fam; }
/// <summary> /// 根据ID返回 sys_OnlineTable实体类 单笔资料 /// </summary> /// <param name="OnlineID">自动ID</param> /// <returns>返回sys_OnlineTable实体类 OnlineID为0则无记录</returns> public static sys_OnlineTable sys_OnlineDisp(int OnlineID) { sys_OnlineTable fam = new sys_OnlineTable(); QueryParam qp = new QueryParam(); qp.PageIndex = 1; qp.PageSize = 1; qp.Where = " Where sys_Online.OnlineID = " + OnlineID; int RecordCount = 0; ArrayList lst = sys_OnlineList(qp, out RecordCount); if (RecordCount > 0) { fam = (sys_OnlineTable)lst[0]; } return fam; }
/// <summary> /// 新增/删除/修改 sys_Online /// </summary> /// <param name="fam">sys_OnlineTable实体类</param> /// <returns>返回0操正常</returns> public static int sys_OnlineInsertUpdate(sys_OnlineTable fam) { return DataProvider.Instance().sys_OnlineInsertUpdate(fam); }