/// <summary>
/// 根据查询命令返回在线用户列表
/// </summary>
/// <param name="dc">查询命令</param>
/// <returns>返回在线用户列表</returns>
private IList <EyouSoft.Model.SystemStructure.SysOnlineUser> GetQueryList(DbCommand dc)
{
IList <EyouSoft.Model.SystemStructure.SysOnlineUser> list = new List <EyouSoft.Model.SystemStructure.SysOnlineUser>();
using (IDataReader dr = base.TourStore.ExecuteReader(dc))
{
EyouSoft.Model.SystemStructure.SysOnlineUser model = null;
while (dr.Read())
{
model = new Model.SystemStructure.SysOnlineUser();
model.ID = dr[0].ToString();
model.UserId = dr[1].ToString();
model.CompanyId = dr[2].ToString();
if (dr.IsDBNull(3))
{
model.LoginTime = dr.GetDateTime(3);
}
list.Add(model);
}
model = null;
}
return(list);
}
/// <summary>
/// 新增在线用户
/// </summary>
/// <param name="model">在线用户实体</param>
/// <returns>返回受影响行数</returns>
public virtual int AddSysOnlineUser(EyouSoft.Model.SystemStructure.SysOnlineUser model)
{
if (model == null)
{
return(0);
}
DbCommand dc = base.SystemStore.GetSqlStringCommand(Sql_SysOnlineUser_Add);
base.SystemStore.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, Guid.NewGuid().ToString());
base.SystemStore.AddInParameter(dc, "UserId", DbType.AnsiStringFixedLength, model.UserId);
base.SystemStore.AddInParameter(dc, "CompanyId", DbType.AnsiStringFixedLength, model.CompanyId);
base.SystemStore.AddInParameter(dc, "LoginTime", DbType.DateTime, model.LoginTime);
return(DbHelper.ExecuteSql(dc, base.SystemStore));
}
/// <summary>
/// 新增在线用户
/// </summary>
/// <param name="model">在线用户实体</param>
/// <returns>0:Error;1:Success</returns>
public int AddSysOnlineUser(EyouSoft.Model.SystemStructure.SysOnlineUser model)
{
if (model == null)
{
return(0);
}
int Result = dal.AddSysOnlineUser(model);
if (Result > 0)
{
return(1);
}
else
{
return(0);
}
}
