/// <summary>
/// ��ȡ�û��ȼ���Ϣ
/// </summary>
/// <param name="userId">�û�Id</param>
/// <returns>���ݶ���</returns>
public Model.UserLoginInfo GetItem(long userId)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@strWhere"," Where U_ID=" + userId.ToString()),
new SqlParameter("@strTableName","XY_UserLoginLog"),
new SqlParameter("@strOrder","")
};
XYECOM.Model.UserLoginInfo info = null;
using (SqlDataReader reader = XYECOM.Core.Data.SqlHelper.ExecuteReader(CommandType.StoredProcedure, "XYP_SelectByWhere", param))
{
if (reader.Read())
{
info = new XYECOM.Model.UserLoginInfo();
info.UserId = userId;
info.FirstLoginDate = reader["FirstLoginDate"].ToString();
info.LastLoginDate = reader["LastLoginDate"].ToString();
info.LoginNum = Core.MyConvert.GetInt32(reader["Loginnum"].ToString());
info.RegIP = reader["regIP"].ToString();
info.LastLoginIP = reader["LastLoginIP"].ToString();
info.Id = Core.MyConvert.GetInt32(reader["UL_ID"].ToString());
}
}
return info;
}
/// <summary>
/// ����û���¼��Ϣ
/// </summary>
/// <param name="el">ʵ����</param>
/// <returns>��Ӱ�������</returns>
//public int InsertOrUpdate(long userId)
//{
// XYECOM.Model.UserLoginInfo userLoginInfo = new XYECOM.Model.UserLoginInfo();
// userLoginInfo.UserId = userId;
// userLoginInfo.RegIP = XYECOM.Core.XYRequest.GetIP();
// return DAL.Insert(userLoginInfo);
//}
/// <summary>
/// ����û���¼��Ϣ
/// </summary>
/// <param name="el">ʵ����</param>
/// <returns>��Ӱ�������</returns>
public int Insert(long userId, string ip, string Flag)
{
XYECOM.Model.UserLoginInfo userLoginInfo = new XYECOM.Model.UserLoginInfo();
if (Flag == XYECOM.Model.UserLog.Register.ToString())
{
userLoginInfo.UserId = userId;
userLoginInfo.RegIP = ip;
userLoginInfo.LastLoginIP = ip;
userLoginInfo.LastLoginDate = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); ;
userLoginInfo.FirstLoginDate = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); ;
}
else
{
userLoginInfo.UserId = userId;
userLoginInfo.RegIP = "";
userLoginInfo.LastLoginIP = ip;
userLoginInfo.LastLoginDate = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); ;
userLoginInfo.FirstLoginDate = "";
}
return DAL.Insert(userLoginInfo);
}
