/// <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); }