/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.User.UserLogin model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update userlogin set "); strSql.Append("userId=@userId,"); strSql.Append("lastLoginIp=@lastLoginIp,"); strSql.Append("lastLoginTime=@lastLoginTime,"); strSql.Append("currentLoginIp=@currentLoginIp,"); strSql.Append("currentLoginTime=@currentLoginTime,"); strSql.Append("sessionId=@sessionId,"); strSql.Append("loginType=@loginType"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@userId", SqlDbType.Int, 4), new SqlParameter("@lastLoginIp", SqlDbType.VarChar, 50), new SqlParameter("@lastLoginTime", SqlDbType.DateTime), new SqlParameter("@currentLoginIp", SqlDbType.VarChar, 50), new SqlParameter("@currentLoginTime", SqlDbType.DateTime), new SqlParameter("@sessionId", SqlDbType.VarChar, 60), new SqlParameter("@loginType", SqlDbType.TinyInt, 1), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.userId; parameters[1].Value = model.lastLoginIp; parameters[2].Value = model.lastLoginTime; parameters[3].Value = model.currentLoginIp; parameters[4].Value = model.currentLoginTime; parameters[5].Value = model.sessionId; parameters[6].Value = model.loginType; parameters[7].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.User.UserLogin DataRowToModel(DataRow row) { Model.User.UserLogin model = new Model.User.UserLogin(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { model.id = int.Parse(row["id"].ToString()); } if (row["userId"] != null && row["userId"].ToString() != "") { model.userId = int.Parse(row["userId"].ToString()); } if (row["lastLoginIp"] != null) { model.lastLoginIp = row["lastLoginIp"].ToString(); } if (row["lastLoginTime"] != null && row["lastLoginTime"].ToString() != "") { model.lastLoginTime = DateTime.Parse(row["lastLoginTime"].ToString()); } if (row["currentLoginIp"] != null) { model.currentLoginIp = row["currentLoginIp"].ToString(); } if (row["currentLoginTime"] != null && row["currentLoginTime"].ToString() != "") { model.currentLoginTime = DateTime.Parse(row["currentLoginTime"].ToString()); } if (row["sessionId"] != null) { model.sessionId = row["sessionId"].ToString(); } if (row["loginType"] != null && row["loginType"].ToString() != "") { model.loginType = int.Parse(row["loginType"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Model.User.UserLogin model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into userlogin("); strSql.Append("userId,lastLoginIp,lastLoginTime,currentLoginIp,currentLoginTime,sessionId,loginType)"); strSql.Append(" values ("); strSql.Append("@userId,@lastLoginIp,@lastLoginTime,@currentLoginIp,@currentLoginTime,@sessionId,@loginType)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@userId", SqlDbType.Int, 4), new SqlParameter("@lastLoginIp", SqlDbType.VarChar, 50), new SqlParameter("@lastLoginTime", SqlDbType.DateTime), new SqlParameter("@currentLoginIp", SqlDbType.VarChar, 50), new SqlParameter("@currentLoginTime", SqlDbType.DateTime), new SqlParameter("@sessionId", SqlDbType.VarChar, 60), new SqlParameter("@loginType", SqlDbType.TinyInt, 1) }; parameters[0].Value = model.userId; parameters[1].Value = model.lastLoginIp; parameters[2].Value = model.lastLoginTime; parameters[3].Value = model.currentLoginIp; parameters[4].Value = model.currentLoginTime; parameters[5].Value = model.sessionId; parameters[6].Value = model.loginType; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.User.UserLogin GetModel(int userId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,userId,lastLoginIp,lastLoginTime,currentLoginIp,currentLoginTime,sessionId,loginType from userlogin "); strSql.Append(" where userId=@userId"); SqlParameter[] parameters = { new SqlParameter("@userId", SqlDbType.Int, 4) }; parameters[0].Value = userId; Model.User.UserLogin model = new Model.User.UserLogin(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.User.UserLogin model) { return(dal.Update(model)); }