/// <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;
}
/// <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 (OleDbConnection Conn = GetSqlConnection())
{
string CommTxt;
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = Conn;
if (fam.DB_Option_Action_ == "Insert")
{
CommTxt = "Insert into sys_Online(O_SessionID,O_UserName,O_Ip,O_LoginTime,O_LastTime,O_LastUrl)VALUES(@O_SessionID,@O_UserName,@O_Ip,@O_LoginTime,@O_LastTime,@O_LastUrl)";
cmd.CommandText = CommTxt;
cmd.Parameters.Add("@O_SessionID", OleDbType.VarWChar).Value = fam.O_SessionID + ""; //用户SessionID
cmd.Parameters.Add("@O_UserName", OleDbType.VarWChar).Value = fam.O_UserName + ""; //用户名
cmd.Parameters.Add("@O_Ip", OleDbType.VarWChar).Value = fam.O_Ip + ""; //用户IP地址
cmd.Parameters.Add("@O_LoginTime", OleDbType.Date).Value = fam.O_LoginTime; //登陆时间
cmd.Parameters.Add("@O_LastTime", OleDbType.Date).Value = fam.O_LastTime; //最后访问时间
cmd.Parameters.Add("@O_LastUrl", OleDbType.VarWChar).Value = fam.O_LastUrl + ""; //最后请求网站
}
else if (fam.DB_Option_Action_ == "Update")
{
CommTxt = "UPDATE sys_Online SET O_SessionID = @O_SessionID,O_UserName = @O_UserName,O_Ip = @O_Ip,O_LoginTime = @O_LoginTime,O_LastTime = @O_LastTime,O_LastUrl = @O_LastUrl WHERE (OnlineID = @OnlineID)";
cmd.CommandText = CommTxt;
cmd.Parameters.Add("@O_SessionID", OleDbType.VarWChar).Value = fam.O_SessionID + ""; //用户SessionID
cmd.Parameters.Add("@O_UserName", OleDbType.VarWChar).Value = fam.O_UserName + ""; //用户名
cmd.Parameters.Add("@O_Ip", OleDbType.VarWChar).Value = fam.O_Ip + ""; //用户IP地址
cmd.Parameters.Add("@O_LoginTime", OleDbType.Date).Value = fam.O_LoginTime; //登陆时间
cmd.Parameters.Add("@O_LastTime", OleDbType.Date).Value = fam.O_LastTime; //最后访问时间
cmd.Parameters.Add("@O_LastUrl", OleDbType.VarWChar).Value = fam.O_LastUrl + ""; //最后请求网站
cmd.Parameters.Add("@OnlineID", OleDbType.Integer).Value = fam.OnlineID;
}
else if (fam.DB_Option_Action_ == "Delete")
{
CommTxt = "Delete from sys_Online WHERE (OnlineID = @OnlineID)";
cmd.CommandText = CommTxt;
cmd.Parameters.Add("@OnlineID", OleDbType.Integer).Value = fam.OnlineID;
}
else
throw new ApplicationException("无法识别的操作命令!");
Conn.Open();
rInt = cmd.ExecuteNonQuery();
if (fam.DB_Option_Action_ == "Insert")
{
cmd.CommandText = "SELECT @@identity";
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 override int sys_OnlineInsertUpdate(sys_OnlineTable fam)
{
int rInt = 0;
using (OracleConnection Conn = GetSqlConnection())
{
string CommTxt;
OracleCommand cmd = new OracleCommand();
cmd.Connection = Conn;
if (fam.DB_Option_Action_ == "Insert")
{
CommTxt = "Insert into sys_Online(OnlineID,O_SessionID,O_UserName,O_Ip,O_LoginTime,O_LastTime,O_LastUrl)VALUES(SEQ_sys_Online_ID.NEXTVAL,:O_SessionID,:O_UserName,:O_Ip,:O_LoginTime,:O_LastTime,:O_LastUrl)";
cmd.CommandText = CommTxt;
cmd.Parameters.Add("O_SessionID", OracleType.VarChar).Value = fam.O_SessionID + ""; //�û�SessionID
cmd.Parameters.Add("O_UserName", OracleType.NVarChar).Value = fam.O_UserName + ""; //�û���
cmd.Parameters.Add("O_Ip", OracleType.VarChar).Value = fam.O_Ip + ""; //�û�IP��ַ
cmd.Parameters.Add("O_LoginTime", OracleType.DateTime).Value = fam.O_LoginTime; //��½ʱ��
cmd.Parameters.Add("O_LastTime", OracleType.DateTime).Value = fam.O_LastTime; //������ʱ��
cmd.Parameters.Add("O_LastUrl", OracleType.NVarChar).Value = fam.O_LastUrl + ""; //���������վ
}
else if (fam.DB_Option_Action_ == "Update")
{
CommTxt = "UPDATE sys_Online SET O_SessionID = :O_SessionID,O_UserName = :O_UserName,O_Ip = :O_Ip,O_LoginTime = :O_LoginTime,O_LastTime = :O_LastTime,O_LastUrl = :O_LastUrl WHERE (OnlineID = :OnlineID)";
cmd.CommandText = CommTxt;
cmd.Parameters.Add("O_SessionID", OracleType.VarChar).Value = fam.O_SessionID + ""; //�û�SessionID
cmd.Parameters.Add("O_UserName", OracleType.NVarChar).Value = fam.O_UserName + ""; //�û���
cmd.Parameters.Add("O_Ip", OracleType.VarChar).Value = fam.O_Ip + ""; //�û�IP��ַ
cmd.Parameters.Add("O_LoginTime", OracleType.DateTime).Value = fam.O_LoginTime; //��½ʱ��
cmd.Parameters.Add("O_LastTime", OracleType.DateTime).Value = fam.O_LastTime; //������ʱ��
cmd.Parameters.Add("O_LastUrl", OracleType.NVarChar).Value = fam.O_LastUrl + ""; //���������վ
cmd.Parameters.Add("OnlineID", OracleType.Int32).Value = fam.OnlineID;
}
else if (fam.DB_Option_Action_ == "Delete")
{
CommTxt = "Delete from sys_Online WHERE (OnlineID = :OnlineID)";
cmd.CommandText = CommTxt;
cmd.Parameters.Add("OnlineID", OracleType.Int32).Value = fam.OnlineID;
}
else
throw new ApplicationException("��ʶ��IJ�������!");
Conn.Open();
OracleTransaction Tran = Conn.BeginTransaction();
cmd.Transaction = Tran;
try
{
rInt = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
if (fam.DB_Option_Action_ == "Insert")
{
cmd.CommandText = "select SEQ_sys_Online_ID.CURRVAL from dual";
rInt = Convert.ToInt32(cmd.ExecuteScalar());
}
Tran.Commit();
}
catch (Exception ex)
{
Tran.Rollback();
throw new ApplicationException(ex.ToString());
}
finally
{
Tran.Dispose();
cmd.Dispose();
Conn.Dispose();
Conn.Close();
}
}
return rInt;
}
/// <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>
/// 新增/删除/修改 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);
}
/// <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>
/// 根据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>
/// 插入在线用户表
/// </summary>
/// <param name="username">用户名</param>
/// <param name="sessionid">用户sessionID</param>
public static void InsertMemberOnline(string username, string sessionid)
{
sys_OnlineTable online = new sys_OnlineTable();
online.DB_Option_Action_ = "Insert";
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;
sys_OnlineInsertUpdate(online);
}
/// <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>
/// 根据用户名读取在线用户
/// </summary>
/// <param name="O_UserName">用户名</param>
/// <returns>返回sys_OnlineTable实例</returns>
public static sys_OnlineTable sys_OnlineDisp(string O_UserName)
{
sys_OnlineTable Online = new sys_OnlineTable();
QueryParam qp = new QueryParam();
qp.Where = "Where 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;
}
