/// <summary> /// 更新一条数据 /// </summary> public bool Update(Garfield.Model.Sys_online model, string where) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Sys_online set "); strSql.Append("UserID=@UserID,"); strSql.Append("UserName=@UserName,"); strSql.Append("LastLogTime=@LastLogTime"); strSql.Append(" where " + where); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@UserName", SqlDbType.VarChar, 50), new SqlParameter("@LastLogTime", SqlDbType.DateTime) }; parameters[0].Value = model.UserID; parameters[1].Value = model.UserName; parameters[2].Value = model.LastLogTime; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(Garfield.Model.Sys_online model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sys_online("); strSql.Append("UserID,UserName,LastLogTime)"); strSql.Append(" values ("); strSql.Append("@UserID,@UserName,@LastLogTime)"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@UserName", SqlDbType.VarChar, 50), new SqlParameter("@LastLogTime", SqlDbType.DateTime) }; parameters[0].Value = model.UserID; parameters[1].Value = model.UserName; parameters[2].Value = model.LastLogTime; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }